Star Trek Picard

29 “Võx”

Troi discovers that Jack’s visions are coming from the Borg and Picard’s supposed Irumodic Syndrome was actually undetected, organic Borg technology from his time as Locutus.

Jack uses his visions to find the Borg Queen, intending to kill her, but is assimilated.

At the Starfleet Museum, Geordi reveals that he has restored the Enterprise-D which is now the only functioning Starfleet ship not controlled by the Borg.

30 “The Last Generation”

The Enterprise-D crew find the Queen’s Borg Cube in the clouds of Jupiter.

The assimilated fleet destroys Earth’s planetary shields and starts targeting major cities. Picard connects himself to the Borg collective and rescues Jack from the Queen’s influence.

Data flies the Enterprise-D through the Cube so they can retrieve Picard, Jack, Riker, and Worf. They destroy the Cube, killing the Queen and returning the assimilated Starfleet personnel to normal.