My Star Trek TOS Database

Quote of the Day

Well, if there is a bright center to the universe, you're on the planet farthest from.

—Luke Skywalker, expressing the lament of a young person growing up in a small town. As a person who grew up in a small, rural Minnesota town, I understand his feelings perfectly.

Figure 1: Spock with Whiz Wheel.

Figure 1: Spock with Whiz Wheel. I love the
anachronism here. (Source)

The people on my team frequently chide me for using management analogies drawn from the original Star Trek television series, which fans refer to as Star Trek TOS. Because of these analogies, I need to provide exact references for the younger folks on our team who have not memorized every episode. I decided that it was time for me to put together an online list that I could search and sort as the need arises. I grabbed the data from the Internet Movie Database (IMBD), including their review score for each episode.

The IMDB ratings did provide me with one surprise. While I expected City on the Edge of Forever to be the most popular episode, I was a bit surprised to see Mirror, Mirror as the second most popular.

Table 1: Star Trek TOS Episodes and Ranking.

EpisodeTitleRatingPlot Summary
1-01The Man Trap7.3Dr. McCoy discovers his old flame is not what she seems after crew members begin dying from a sudden lack of salt in their bodies.
1-02Charlie X7.2Captain Kirk must learn the limits to the power of a 17-year-old boy with the psychic ability to create anything and destroy anyone.
1-03Where No Man Has Gone Before7.8The flight recorder of the 200-year-old U.S.S. Valiant relays a tale of terror--a magnetic storm at the edge of the galaxy!
1-04The Naked Time8.0The crew is infected with a mysterious disease that removes people's emotional inhibitions to a dangerous degree.
1-05The Enemy Within7.8A transporter malfunction splits Captain Kirk into two halves: one meek and indecisive, the other violent and ill tempered. The remaining crew members stranded on the planet cannot be beamed up to the ship until a problem is fixed.
1-06Mudd's Women6.9The Enterprise picks up untrustworthy entrepreneur Harry Mudd accompanied by three beautiful women who immediately put a spell on all the male crew members.
1-07What Are Little Girls Made Of?7.6Nurse Chapel is reunited with her fiance; but his new obsession leads him to make an android duplicate of Captain Kirk.
1-08Miri7.1The Enterprise discovers a planet exactly like Earth, but the only inhabitants are children who contract a fatal disease upon entering puberty.
1-09Dagger of the Mind7.5Kirk and psychiatrist Helen Noel are trapped on a maximum security penal colony that experiments with mind control and Spock must use the Vulcan mind-meld to find a way to save them.
1-10The Corbomite Maneuver8.2After the Enterprise is forced to destroy a dangerous marker buoy, a gigantic alien ship arrives to capture and condemn the crew as trespassers.
1-11The Menagerie: Part I8.4Spock kidnaps the crippled Capt. Pike, hijacks the Enterprise and then surrenders for court martial.
1-12The Menagerie: Part II8.3At Spock's court martial, he explains himself with mysterious footage about when Capt. Pike was kidnapped by powerful illusion casting aliens.
1-13The Conscience of the King7.3While Captain Kirk investigates whether an actor is actually a presumed dead mass murderer, a mysterious assailant is killing the people who could identify the fugitive.
1-14Balance of Terror9.0The Enterprise must decide on its response when a Romulan ship makes a destructively hostile armed probe of Federation territory.
1-15Shore Leave7.7The past three months has left the crew of the Enterprise exhausted and in desperate need of a break...
1-16The Galileo Seven7.8The Galileo, under Spock's command, crash-lands on a hostile planet. As the Enterprise races against time to find the shuttlecraft, Spock's strictly logical leadership clashes with the fear and resentment of his crew.
1-17The Squire of Gothos7.5A being that controls matter and creates planets wants to play with the Enterprise crew.
1-18Arena8.1For bringing hostility into their solar system, a superior alien race brings Captain Kirk in mortal combat against the reptilian captain of an alien ship he was pursuing.
1-19Tomorrow Is Yesterday8.0The Enterprise is thrown back in time to 1960s Earth.
1-20Court Martial7.5Kirk draws a court martial in the negligent death of a crewman.
1-21The Return of the Archons7.3Seeking the answer to a century-old mystery, Kirk and crew encounter a vacantly peaceful society under a 6000-year autocratic rule that kills all those it can't absorb.
1-22Space Seed8.9While on patrol in deep space, Captain Kirk and his crew find and revive a genetically engineered world conqueror and his compatriots from Earth's 20th century.
1-23A Taste of Armageddon8.1Kirk and Spock must save their ship's crew when they are declared all killed in action in a bizarre computer simulated war where the actual deaths must occur to continue.
1-24This Side of Paradise8.0The Enterprise investigates a planet whose colonists should be dead, but are not.
1-25The Devil in the Dark8.5The Enterprise is sent to a mining colony that is being terrorized by a mysterious monster.
1-26Errand of Mercy8.3With a war with Klingons raging, Kirk and Spock attempt to resist an occupation of a planet with incomprehensibly placid natives.
1-27The Alternative Factor5.8Existence itself comes under threat from a man's power-struggle with his alternate self, with the Enterprise's strained dilithium crystals presenting his key to a final solution.
1-28The City on the Edge of Forever9.3When a temporarily insane Dr. McCoy accidentally changes history and destroys his time, Kirk and Spock follow him to prevent the disaster, but the price to do so is high.
1-29Operation: Annihilate!7.6The Enterprise crew attempts to stop a plague of amoeba-like creatures from possessing human hosts and spreading throughout the galaxy.
2-30Amok Time8.8In the throes of his Pon Farr mating period, Spock must return to Vulcan to meet his intended future wife, betrothed from childhood.
2-31Who Mourns for Adonais?7.1A powerful being claiming to be the Greek god Apollo appears and demands that the crew of the Enterprise disembark onto his planet to worship him.
2-32The Changeling7.8A powerful artificially intelligent Earth probe, with a murderously twisted imperative, comes aboard the Enterprise and confuses Capt. Kirk as his creator.
2-33Mirror, Mirror9.2A transporter accident places Capt. Kirk's landing party in an alternate universe, where the Federation is a barbarically brutal empire.
2-34The Apple6.4Primitive inhabitants of Gamma Trianguli VI worship a God who orders them to kill visitors, from the Enterprise.
2-35The Doomsday Machine8.8The USS Enterprise encounters the wrecked USS Constellation and its distraught captain who's determined to stop the giant planet-destroying robot ship that killed his crew.
2-36Catspaw6.2Very alien visitors to our galaxy attempt to connect with human consciousness but miss, winding up tapping into the regions of human nightmares instead.
2-37I, Mudd7.5Harry Mudd returns with a plot to take over the Enterprise by stranding the crew on a planet populated by androids under his command.
2-38Metamorphosis7.4While returning to the Enterprise aboard the shuttlecraft, Kirk, Spock, McCoy and a seriously ill Federation diplomat find themselves kidnapped by an energized cloud.
2-39Journey to Babel8.6The Enterprise hosts a number of quarrelling diplomats, including Spock's father, but someone on board has murder in mind.
2-40Friday's Child6.9The Federation clashes with the Klingon Empire over mining rights to Capella IV. A sudden coup between its warrior-minded inhabitants forces Kirk's party to flee with the now dead leader's pregnant wife.
2-41The Deadly Years7.4A landing party from the Enterprise is exposed to strange form of radiation which rapidly ages them.
2-42Obsession7.4Capt. Kirk obsessively hunts for a mysterious cloud creature he encountered in his youth.
2-43Wolf in the Fold7.4Kirk and the Enterprise Computer become detectives after Scotty is accused of murdering women on a pleasure planet.
2-44The Trouble With Tribbles8.9To protect a space station with a vital grain shipment, Kirk must deal with Federation bureaucrats, a Klingon battle cruiser and a peddler who sells furry, purring, hungry little creatures as pets.
2-45The Gamesters of Triskelion7.0Kirk, Uhura and Chekov are trapped on a planet where abducted aliens are enslaved and trained to perform as gladiators for the amusement of bored, faceless aliens.
2-46A Piece of the Action7.9The crew of Enterprise struggles to cope with a planet of imitative people who have modeled their society on 1920's gangsters.
2-47The Immunity Syndrome7.6The Enterprise encounters a gigantic energy draining space organism that threatens the galaxy.
2-48A Private Little War7.0Peaceful, primitive peoples get caught up in the struggle between superpowers, with Kirk unhappily trying to restore the balance of power disrupted by the Klingons.
2-49Return to Tomorrow7.6The Enterprise is guided to a distant, long-dead world where survivors of an extremely ancient race - existing only as disembodied energy - desiring the bodies of Kirk, Spock and astro-biologist Ann Mulhall so that they may live again.
2-50Patterns of Force7.6Looking for a missing Federation cultural observer, Kirk and Spock find themselves on a planet whose culture has been completely patterned after Earth's 1944 Nazi society.
2-51By Any Other Name7.7Galactic alien scouts capture the Enterprise for a return voyage and a prelude to invasion. Kirk's one advantage - they're not used to their adopted human form.
2-52The Omega Glory6.3Responding to a distress signal, Kirk finds Captain Tracey of the U.S.S. Exeter violating the prime directive and interfering with a war between the Yangs and the Kohms to find the secret of their longevity.
2-53The Ultimate Computer8.1Kirk and a sub-skeleton crew are ordered to test out an advanced artificially intelligent control system - the M-5 Multitronic system, which could potentially render them all redundant.
2-54Bread and Circuses7.3The Enterprise crew investigates the disappearance of a ship's crew on a planet that is a modern version of the Roman Empire.
2-55Assignment: Earth7.7While back in time observing Earth in 1968, the Enterprise crew encounters the mysterious Gary Seven who has his own agenda on the planet.
3-56Spock's Brain5.6The crew of the Enterprise pursues a mysterious woman who has abducted Spock's brain.
3-57The Enterprise Incident8.6An apparently insane Capt. Kirk has the Enterprise deliberately enter the Romulan Neutral Zone where the ship is immediately captured by the enemy.
3-58The Paradise Syndrome6.8Trapped on a planet whose inhabitants are descended from Northwestern American Indians, Kirk loses his memory and is proclaimed a God while the crippled Enterprise races back to the planet before it is destroyed by an asteroid.
3-59And the Children Shall Lead5.2The Enterprise reaches a Federation colony where the adults have all killed themselves but the children play without care.
3-60Is There in Truth No Beauty?7.0Lovely telepath Miranda is aide to Ambassador Kollos, in a box to stop insanity when humans see Medusans. She rejects Larry, a designer of Enterprise, and senses murderous intent nearby.
3-61Spectre of the Gun7.4As punishment for ignoring their warning and trespassing on their planet, the Melkot condemn Capt. Kirk and his landing party to the losing side of a surreal recreation of the 1881 historic gunfight at the OK Corral.
3-62Day of the Dove8.0Both humans and Klingons have been lured to a planet by a formless entity that feeds on hatred and has set about to fashion them into a permanent food supply for itself.
3-63For the World Is Hollow and I Have Touched the Sky7.2The Enterprise discovers an apparent asteroid that is on a collision course with a planet is actually an ancient populated generation ship.
3-64The Tholian Web8.1With Capt. Kirk and the derelict USS Defiant apparently lost, the Enterprise grapples with an insanity causing plague and an attack by the Tholians.
3-65Plato's Stepchildren6.6After Dr. McCoy helps the leader of a planet populated by people with powerful psionic abilities, they decide to force him to stay by torturing his comrades until he submits.
3-66Wink of an Eye7.4A group of aliens who exist in a state of incredible acceleration invade the Enterprise and abduct Capt. Kirk.
3-67The Empath6.6Trapped in an alien laboratory Kirk, Spock and McCoy meet an empath and are involved in a series of experiments.
3-68Elaan of Troyius7.2While transporting an arrogant, demanding princess for a political marriage, Captain Kirk must cope both with her biochemical ability to force him to love her and sabotage on his ship.
3-69Whom Gods Destroy7.0Kirk and Spock are taken prisoners by a former starship captain named Garth, who now resides at, and has taken over, a high security asylum for the criminally insane.
3-70Let That Be Your Last Battlefield7.2The Enterprise encounters two duo-chromatic and mutually belligerent aliens who put the ship in the middle of their old conflict.
3-71The Mark of Gideon6.5Kirk beams down to the planet Gideon and appears to find himself trapped on a deserted Enterprise. Spock on the real Enterprise must use his diplomatic skills to deal with the uncooperative inhabitants of Gideon and find the Captain.
3-72That Which Survives6.5After the Enterprise landing party beams down to investigate a geologically interesting planet, their ship is hurled across the galaxy. Kirk and company find a deserted outpost guarded by the deadly image of a beautiful woman.
3-73The Lights of Zetar6.2A mysterious, twinkling mass of sapient energy ravages an important archive and Scotty's new girlfriend may be linked to it.
3-74Requiem for Methuselah7.6On a planet, looking for an urgent medicinal cure, Kirk, Spock and McCoy come across a dignified recluse living privately but in splendor with his sheltered ward and a very protective robot servant.
3-75The Way to Eden5.5A group of idealistic hippies, led by an irrational leader, come aboard the U.S.S. Enterprise.
3-76The Cloud Minders7.0Kirk and Spock are caught up in a revolution on a planet where intellectuals and artists live on a utopian city in the sky while the rest of the population toils in mines on the barren surface below.
3-77The Savage Curtain6.8Kirk, Spock, Abraham Lincoln and Vulcan legend Surak are pitted in battle against notorious villains from history for the purpose of helping a conscious rock creature's understanding of a concept he does not understand, good vs. evil.
3-78All Our Yesterdays8.3When Kirk, Spock and McCoy investigate the disappearance of a doomed planet's population, they find themselves trapped in different periods of that world's past.
3-79Turnabout Intruder6.9Captain Kirk's insane ex-lover Dr. Janice Lester forcibly switches bodies with him in order to take command of the Enterprise.
This entry was posted in Science Fiction. Bookmark the permalink.

5 Responses to My Star Trek TOS Database

  1. RONAN A MANDRA says:

    Being from the Star Trek TOS era, I would be interested in your "management analogies" when you have time to share.

    Thanks in advance

    • mathscinotes says:

      Here are some recent situations where Star Trek analogies come up:

      • I am in a conference room with a number of people on a phone call with the microphone muted. You hear someone on the call take a shot at someone who then becomes very defensive. I then grin and say "Shields Up."
      • I have been tasked with due dilligence work for a few merger opportunities. I often compare aspects of corporate mergers to Vulcan mating or the Pon Farr.
      • People are always asking my team to do something that just isn't possible. I then find myself quoting Scotty by saying "You can't mix anti-matter cold!"
      • Recently, I have received many requests to build something using a part that does not exist. I often refer to these parts as dilithium or unobtainium.
      • I have an engineer in my group who frequently encounters illogical decision making. Because she knows that I am a Star Trek fan, she often says that this exposure to illogical thinking is impeding her progress on achieving the Kolinahr.
      • Engineers frequently get angry with their computers or test equipment — sometimes even cursing at them. I always warn these engineers that they should not insult the gods of electronics because they are frequently vindictive. I then mention the behavior of Landru or M5.
      • I struggle with our Accounting department. Every week they want me to present them an offering of financial data. I refer to them as Vaal.
      • When an engineer walked in wearing a goatee, I said he looked a bit like evil Spock.
      • When a person is angry, I will occasionally say that they are "mad enough to chew neutronium", which was mentioned in "A Piece of the Action."

      This is a fairly representative list from recent weeks.


      I should mention that other members of my team are more Star Wars people. Here are a few of their comments:

      • An engineer made a sarcastic comment in a meeting – a very common occurrence. A young engineer turned to me and said, "The sarcasm is strong in this one."
      • While on a phone conference call, an engineer hears a marketing person try to convince a customer that a problem is really not a problem but a feature. An engineer puts the phone on mute and says "These aren't the droids you're looking for."


  2. Roger says:

    When you are wrong, your team to say, "Behold, the God who bleeds!"

  3. RONAN A MANDRA says:

    I went Star Trek quote hunting and found these websites:
    - #2 from above. "Logic is the beginning of wisdom, not the end." Mr. Spock, Star Trek VI: The Undiscovered Country
    - #39 from above: “NUCLEAR WESSELS.”

    Thanks for sharing your Star Trek analogies. I especially like the one linking the accounting depart to Vaal.


Comments are closed.