Scotty was a red shirt. Not all red shirts died and red shirts weren’t the only away party members that were killed. If more of them seem to have died in action, well I guess that goes with the duty, security, that went with the shirt.
Lt Leslie was on a lot of missions, and was a bridge crew member as well, but only died once. (He got better, though.)
Thank you, I will look into them.
One of the duties. Red was Operations, which covered security, engineering, communications, etc.
Security and Engineering tend to have high body count, for obvious reasons.
^ Yeah, thanks a lot, Dr. Daystrom!
Actually that could have been used in the TOS episode “The Cloud Minders”. The planet could orbit a hot blue star that puts out tons of ultraviolet light and the upper class are all dark-skinned who can tolerate the UV. The light-skinned lower class mostly stay underground working as miners because the UV is too much for them. The darks derogatively refer to the lights as “grubbers”, which as Spock explains refers both to their occupation as miners and an allusion to their pale skin. The dark rulers treat the visiting officers from the Enterprise rather paternalisticly, astonished that lights can actually be starship officers instead of drunken brawlers, commending them as “a credit to their race”.
Also, at the start of the episode I envision the following scene: the party is preparing to beam down and Dr. McCoy is making sure everyone is heavily slathered with sunscreen, leading to the following exchange:
KIRK: “Bones, you’re fussing like a mother taking her kids on a day at the beach”.
MCCOY: “Day at the beach my keester! If I have to regenerate your hide because you let yourself get third-degree sunburn, I swear you’ll do it without anesthetic!”
^ McCoy: I’m a doctor, not a Baywatch lifeguard. 
This wouldn’t be an episode but a novel, preferably by Diane Duane: In the opening, a conversation with Kirk and McCoy leads Spock to reveal that when his mother Amanda was pregnant with him, she was targeted by assassins that saw her as a threat to Vulcan racial purity. Most of the novel would be a flashback to this.
“The One Where They Name The Episode Like It’s Friends”
This was an idea for a ST:TNG episode that I and my friend Scott thought up: Ryker, Worf, Data and Wesley are supposed to beam aboard, but a transporter malfunction occurs and they get replaced by their Mirror Universe counterparts. They manage to keep their cool when they see that everything is the same but different. They meet together privately and ascertain that they are in The Mirror Universe (to them), and decide they can take advantage of it.
MU Riker is a conniving schemer who achieved higher rank by killing off his rivals, so in this universe, he plans to kill Picard and replace him as Enterprise Captain. MU Worf is more savage and doesn’t believe in honor. MU Wesley is an absolute snot who got his position from family influence, and loves to make rude and smartassed comments. MU Data is simply regarded as a machine that takes orders, and the others have no concept of him as a sentient person. He eventually turns on his comrades after seeing how humans in this universe treat him with dignity and respect.
This is more or less what the fans at the time bitched about the most - Riker’s stupidity for passing up commands of other starships to be 2nd banana on the Enterprise, Worf always getting beat up, everybody hating boy genius Wesley, and please stop the “Is Data human” crap! This would have been an opportunity to make these characters so much more hateful, and to provide unpleasant alternatives to what fans already groused about.
I want them named like Wild Wild West, or Buck Rogers.
The Night of* the Treacherous Tribble
The Night of the Infernal Computer
The Night of Methusela’s Requiem
The Night of the Mad Captain
The Night of the Murderous Thespian
The Night of the Body Switchers
The Night of the Sikh
The Night of the Surreal Kirk
*or Flight of, like Buck
Too late to edit.
What we need is a new Star Trek. Steampunk Star Trek. Jules Verne-era space travel. Starfleet headquarters is in 1890s San Francisco. The Enterprise is all riveted metal, and the engine room is steam pipes and valves.
Take the best of Wild Wild West, Q.E.D., Brisco County, The Bearcats, The Barbary Coast, 20K Leagues UtS, and The Time Machine, stir them together, skim off the crap, and voila, instant hit.
Would Moriarty have a on-going role?