Although Nova Squadron disbanded after Wesley came clean about Josh's death, Red Squad takes Nova Squadron's place in Star Trek: Deep Space Nine's season 4 2-parter, "Homefront" and "Paradise Lost". Starfleet Academy's Red Squad is enlisted by Admiral Leyton (Robert Foxworth) to sabotage Earth's power grid, enabling Leyton to enact martial law. Leyton resigns, but Red Squad returns in DS9 season 6, episode 22, "Valiant". Red Squad's Cadet Tim Watters (Paul Popowich) takes command of the Defiant Class USS Valiant after its ranking officers are killed. As captain, Watters takes on the Dominion, which destroys the Valiant and kills nearly everyone aboard.
Why Star Trek: DS9’s Red Squad Was So Much Worse Than TNG’s Nova Squadron
Red Squad's Hubris Was Much More Deadly Than Nova Squadron's
Red Squad reaffirmed that Starfleet Academy having a squadron of elite cadets is a bad idea in the first place. Nova Squadron ostensibly existed to recognize cadets who excelled as pilots, but Red Squad was only elevated to help Leyton's Starfleet coup. In both cases, it was easy for a rogue Starfleet Admiral and the squadrons' leaders to manipulate impressionable teenage cadets into becoming accomplices. Wesley Crusher proved that Nova Squadron still had integrity, but Watters' bad leadership on the USS Valiant proved Red Squad didn't have the emotional intelligence to responsibly use the power that came with their status.
Nova Squadron’s Nick Locarno Became A Star Trek Super Villain
Locarno's Persistent Belief In His Superiority Was Fueled By Misremembered Glory Days
Star Trek: Lower Decks season 2, episode 6, "The Spy Humongous", parodied groups like Nova Squadron and Red Squad with the USS Cerritos' own club of self-styled elite ensigns, the Redshirts. The Redshirts' favored activity of pretending to be captains prevented them from actually getting real work done.
Will Star Trek: Starfleet Academy Have A Red Squad Or Nova Squadron?
A New Cadet Squad In Starfleet Academy Might Be More Like Star Trek: Prodigy's Nova Squadron
Hopefully, Star Trek: Starfleet Academy won't have an elite cadet team like Red Squad or Nova Squadron, but Star Trek history tends to repeat itself, as evidenced by Red Squad taking Nova Squadron's place in DS9. Nova Squadron also reappeared in Star Trek: Prodigy season 2, with a whole new crop of cadets taking on the legacy name, almost 20 years after the previous Nova Squadron's fatal accident. Maj'el (Michaela Dietz), Zeph (Sunkrish Bala), and pinch-hitter Dal (Brett Gray) were actually noble examples of Starfleet Cadets who redeemed Nova Squadron's name, thanks to Captain Chakotay's (Robert Beltran) guidance.
The elitism that harmed the earlier Nova Squadron and Red Squad was solved in Star Trek: Prodigy because Captain Chakotay was a kind and competent leader who encouraged the 2384 Nova Squadron to include newcomer Dal. As a legacy character in Starfleet Academy, Star Trek: Discovery's Lieutenant Sylvia Tilly (Mary Wiseman) would almost certainly impart similar compassionate guidance to any elite squad in Star Trek: Starfleet Academy. If a new Red Squad or Nova Squadron is taught that leadership is a service rather than a status symbol, the deadly mistakes Red Squad made in Star Trek: Deep Space Nine won't be repeated.