Gambit

TNG Season 7 Episode 4 and 5
Air Date: October 11th and 17th, 1993

The senior staff of the Enterprise start looking for Captain Picard who went missing. They learn that he died, killed by some mercenaries that had been looting archaeological sites. Cmdr. Riker is given command of the Enterprise (not the first time Picard has died to give Riker the chair) but Riker refuses to accept Picards death and takes the Enterprise to find his killers. They track them to another archaeological site where Riker gets abducted leaving Lt. Cmdr Data in command.

We learn that Picard didn't die but is under cover on the ship trying to figure out what it is they are looking for. Eventually they find a Vulcan artifact that can amplify negative emotions. One of the crew of the mercenaries is Vulcan and she was wanting the artifact to take over Vulcan and return them to a time where they had emotion. Only Picard figures out that the device only works when a person is experiencing a negative emotion such as fear or anger and by taking no aggressive action towards her, is safe from the weapon.

Quotes

"This is not about revenge. This is about justice. The Captain died in a bar fight, for nothing. Somebody has to answer for that. Then I can mourn." - Cmdr Riker

"Do you think you're the only one in pain? That you have a monopoly on loss? Well, I've got news for you. We're all hurting, we're all angry. And like it or not, you've got a responsibility to this crew. And you can't just indulge your personal desire for revenge." - Counselor Troi

"He's all right. He's only stunned." - Counselor Troi
"I must admit, I am experiencing a similar sensation." - Lt. Cmdr Data

"Number One, will you set a course for Starbase 227, I'll join you on the bridge shortly." - Captain Picard
"Wait a minute, you've been declared dead. You can't give orders around here." - Cmdr. Riker
"If we are to adhere to the exact letter of Starfleet regulations, then technically, sir, you have been declared a renegade. In fact, I believe you are facing twelve counts of court martial offenses. You cannot give orders either, sir." - Lt. Cmdr. Data
"That's quite right. And as I am supposed to be dead, I'll go and get some sleep, and Mr. Data, I suggest that you escort Commander Riker to the brig." - Captain Picard
"Aye, sir. This way, sir." - Lt. Cmdr. Data
"Data, he was joking. You know that, right? Data?" - Cmdr. Riker