As part of the A-6 excavation team, he was aboard the transport Arctic One which was sent to search and investigate a debris field in the Arctic Circle on Earth in 2153. When the team found the remains of a Borg sphere and two alien lifeforms they built up a base camp for further research. Drake made a bet with Commander Williams about finding it, and won a bottle of scotch.
While investigating more debris, including a transwarp coil, outside with Rooney he noticed phase rifle fire and scream from within the research module. Inside the module, he found his colleague Moninger under some equipment. When he told Rooney to get a medical kit, the scientist almost ran into a Borg drone and the team was assimilated.
The revived drones and assimilated scientists left Earth in Arctic One (which was gradually assimilated as well), presumably on a course for Borg space, before they were intercepted and eventually destroyed by Enterprise NX-01. (ENT: "Regeneration")