USS Enterprise (NCC-1701-E)

[1] The Enterprise-E is a Sovereign class starship, launched in 2372 from the San Francisco Fleet Yards under the command of Captain Jean-Luc Picard, and most of the key officers from the Enterprise-D.[2] According to the non-canon novel Ship of the Line, the originally planned name for the vessel was USS Honorius, and Montgomery Scott was part of the team of engineers that designed the Enterprise-E.[3] In the film Star Trek: First Contact, the Enterprise participates in the Battle of Sector 001, a Borg attack directly on Earth, the capital of the Federation, using a Borg Cube.

The Enterprise's crew briefly glimpse the result of the creation of this alternate history while following the vessel back through time; the attack is successful and Earth is wholly assimilated by the Borg.

This leads to the crew now realizing that the Borg's reason for time-travelling was to stop the first contact event and they decide to covertly assist Cochrane in his preparations in a bid to ensure the flight happens as intended and history remains intact.

[4] In the penultimate episode of Star Trek: Picard, "Võx", the Enterprise is briefly mentioned as having been later commanded by Worf, but is unusable and out-of service for nebulous reasons.

The Enterprise-E appears in the Star Trek: Prodigy season 1 two-part finale "Supernova" as one of the ships that intercepts the USS Protostar and falls victim to the Vau N'Akat living construct weapon.

In the Star Trek: Lower Decks series finale "The New Next Generation," Starfleet Command sends the Enterprise-E to stop a interdimensional rift that's threatening to destroy the prime universe, but it won't arrive in time so the USS Cerritos is dispatched to deal with it in the meantime.

[9] In 2018, Io9/Gizmodo ranked the fictional spacecraft design shown in the films First Contact, Insurrection, and Nemesis, the Enterprise-E, as the third best version of starship Enterprise of the Star Trek franchise.