Mars Climate Orbiter didn't fail because of a unit conversion it failed because nobody verified the software against a spec that already existed
Quick context most retellings skip: NASA's Software Interface Specification for this mission was published in 1996, two years before launch, and it explicitly required newton-seconds for thruster data. The contractor's ground software (a program called SM_FORCES) put out pound-force seconds instead a factor-of-4.45 error that fed directly into the navigation team's trajectory model for the entire cruise to Mars.
What I find more interesting than the unit mix-up itself: engineers noticed the spacecraft's angular-momentum desaturation events were happening 10-14x more often than expected, and separately, Doppler tracking data kept suggesting a closer approach to Mars than the official trajectory predicted. Neither discrepancy got resolved before the orbital insertion burn on Sept 23, 1999.
I made a documentary going through the full timeline, sourced to the Mishap Investigation Board's Phase I report happy to share if anyone's interested, but mostly wanted to discuss the "systemic verification failure" angle since most coverage flattens this into a punchline about metric vs. imperial units.