In the TNG episode "Tapestry," Q is talking about the Picard that would never be if Picard had made a different choice in picking a fight with the Nausicaans. One of the events he mentions is the Picard who would “take charge of the Stargazer’s bridge when its captain was killed.” I know it isn’t mentioned again in the TV series, but is the story of that event detailed in any of the books or comics or other sources?
Yes! Several in fact all by Michael Jan Friedman:
- Stargazer: Gauntlet (2002)
- Stargazer: Progenitor (2002)
- Stargazer: Three (2003)
- Stargazer: Oblivion (2003)
- Stargazer: Enigma (2004)
- Stargazer: Maker (2004)
But it all started with one of the very first TNG novels, also by Michael Jan Friedman, Star Trek: The Next Generation Reunion - in which the remaining crew of the U.S.S. Stargazer reunite to see a former officer installed as ruler of the Daa'Vit Empire.
The reunion turns deadly when an assassin begins eliminating Stargazer crew members one by one. Picard's present and former shipmates must join forces to solve the mystery of the assassin who threatens the peace of the entire galaxy.
There are also several other novels and comics that tie-into Picard's past:
- TNG: The Valiant
- TNG Novel 32: Requiem (1997)
- TNG Novel 56: The First Virtue (1999)
- Star Trek: The Next Generation (DC volume 2):
- Issue 59: "Children of Chaos"
- Issue 60: "Mother of Madness"
- Issue 61: "Brothers in Darkness"
- Tales from the Captain's Table: "Darkness" (2005)
- TNG: Death in Winter (2005)
- TNG: The Buried Age (2007)