Star Trek: 10 Times The Ship Was Stolen
1. Of Course It's The Borg
Shall we attempt to narrow down a time when the Borg took control of a Starfleet vessel? Quite frankly there are a few to choose from and even more attempted takeovers on top of that.
The Enterprise-E was almost lost to the Borg in 2063, though thankfully a little Picard and Data magic saved the day. Some of those same Borg attempted, though failed, to takeover the NX-01 several years later.
The Stargazer became, for however brief a time, a Borg vessel once Juratti's quasi-Collective commandeered the ship to battle the Galactic event, then less than a year later the OG Collective - in the form of a decrepit and dying Queen - took command of the entirety of Starfleet as they gathered for Frontier Day.
If there is a constant in this Galaxy, it's that given enough time to think up a plot, the Borg will be back to try and ruin everyone's good times. At the very least, they do seem to be utterly woeful at holding on to the ships they take. So there's that.