Star Trek: First Contact

Planet Earth. Population 9 billion. None human.

The time is the 24th century and the ship is the newly commissioned Enterprise-E. It's captain, Jean-Luc Picard, has been ordered not to interfere in a combat between a Borg Cube and ships from the Federation. However, seeing the Federation is about to lose, Picard ignore his orders and take command of the defending fleet. With his knowledge of the weak spot of the Cube, they destroy it. However, a small part of it escapes and plot a course directly to Earth. The Enterprise chases it and enters a time distortion created by the Borg. They end up in the mid 21st century, their only chance of stopping the Borg from assimilating Earth being to help Zefram Cochrane make his famous first faster than light travel to the stars...