Mars Climate Orbiter was sent to Mars to look at the Martian climate in a more detailed way than all other past missions. It failed shortly before arriving in Mars's orbit because of a human error in the use of metric and English system.
For more about Mars Climate Orbiter Click Here