The Concorde was a remarkable achievement of aviation, but factors like mammoth ticket prices and a terrible tragedy would ultimately lead to its demise.