TNG Season 6 Episode 15
Air Date: February 15th, 1993
Captain Picard was injured and dies during an attack during a diplomatic mission, the attack damaged his artificial heart. Once in the afterlife, Q appears as God and tells Picard they are to spend eternity together. When Picard mentions that this was all due to a poor decision he made when he was young, fighting a Nausicaan and getting stabbed through the heart. Q gives him a second chance, to go back and prevent that from happening.
Only in doing so, he alienates one of his best friends and becomes a Starfleet officer that doesn't take risks. This alters his career paths and while he is stationed on the Enterprise, he is only a lieutenant and not on the command track. He does the one thing he never wanted to do. He tells Q that he was right and that sometimes the poor choice is the right one. Q lets him go back and fight the Nausicaan again. He then wakes up on the operating table with Doctor Crusher telling him that he will be all right.
In the episode Samaritan Snare, Picard describes the fight with the Nausicaan right down to him laughing while looking at the blade coming out of his chest. The scene was re-enacted twice in this episode, once by a young Picard and once by present day Picard. The fight with the Nausicaan was choreographed the same way which showed attention to detail. This was the third time we see Q in the 1992-1993 season, two in TNG and one in DS9. Other than the TNG series finale we won't see him again until Star Trek: Voyager.
Quotes
"Q, what is going on?" - Captain Picard"I told you. You're dead. This is the afterlife. And I'm God." - Q
"You are not God!" - Captain Picard
"Now that you've shuffled off the mortal coil, we're free to spend a little time together." - Q
"A little time together? How much?" - Captain Picard
"Eternity." - Q
"Q, even if you have been able to bring me back in time somehow, surely you must realize that any alteration in this timeline will have a profound impact on the future." - Captain Picard
"Please, spare me your egotistical musings on your pivotal role in history. Nothing you do here will cause the Federation to collapse or galaxies to explode. To be blunt, you're not that important." - Q
"Flowers! Is there a John Luck Pickurd here?" - Q
"You having a good laugh now, Q? Does it amuse you to think of me living out the rest of my life as a dreary man in a tedious job?" - Lt. Picard
"I gave you something most mortals never experience: a second chance at life. And now all you can do is complain?" - Q
"I can't live out my days as that person. That man is bereft of passion, and imagination! That is not who I am!" - Lt. Picard
"Au contraire. He's the person you wanted to be, one who was less arrogant and undisciplined in his youth, one who was less like me. The Jean-Luc Picard you wanted to be, the one who did not fight the Nausicaan, had quite a different career from the one you remember. That Picard never had a brush with death, never came face to face with his own mortality, never realized how fragile life is or how important each moment must be. So his life never came into focus. He drifted through much of his career, with no plan or agenda, going from one assignment to the next, never seizing the opportunities that presented themselves. He never led the away team on Milika III to save the Ambassador, or take charge of the Stargazer's bridge when its captain was killed. And no one ever offered him a command. He learned to play it safe, and he never, ever, got noticed by anyone." - Q