Fatal NTSB investigations: Cessna 172M

9 cases on aircraft the registry lists as Cessna 172M, where the sequence of events included Loss of control in flight. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

20102026
Fatal NTSB investigations: Cessna 172M per year, 2010–2026: 9 cases
20101
20111
20121
20132
20141
20202
20231

Latest cases

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ERA23LA328Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Charlotte Amalie, CBThe pilots’ loss of airplane control due to spatial disorientation. Contributing to the accident was both pilots’ lack of experience in operating in actual instrument meteorological conditions.Aug 4, 2023 · N13384 · DestroyedNTSB WPR20LA203Accident · 4 fatalClass 3 · LimitedFinal reportCessna 172 · Alpine, UTThe pilot’s exceedance of the airplane’s critical angle-of-attack while maneuvering in a canyon, which resulted in a loss of airplane control.Jul 3, 2020 · N6929H · DestroyedNTSB CEN20LA214Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · New Washington, INA high velocity descent and impact with terrain for undetermined reasons.Jun 6, 2020 · N13520 · DestroyedNTSB CEN15FA083Accident · 1 fatalField investigationFinal reportCessna 172M · Odessa, TXThe pilot’s failure to maintain adequate airspeed while maneuvering at an excessive bank angle at a low altitude, which resulted in an accelerated stall and spin with insufficient altitude for a recovery.Dec 22, 2014 · N9922V · DestroyedNTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.Jun 21, 2013 · N9926Q · DestroyedNTSB WPR13FA138Accident · 1 fatalField investigationFinal reportCessna 172M · Saratoga, WYThe pilot’s decision to attempt flight into approaching adverse weather, which led to his low-level flight, encounter with mountain obscuration and moderate turbulence, and his subsequent loss of airplane control. Contributing to the severity of the pilot’s…Mar 3, 2013 · N5129R · Substantial damageNTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…Jul 25, 2012 · N73115 · Substantial damageNTSB ERA11FA369Accident · 2 fatalField investigationFinal reportCessna 172M · Poughkeepsie, NYThe pilot’s loss of airplane control due to impairment or incapacitation as a result of coronary artery disease in combination with atrial fibrillation. Contributing to the accident was the pilot's failure to report his paroxysmal atrial fibrillation to the…Jun 28, 2011 · N61579 · Substantial damageNTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.Aug 11, 2010 · N21363 · Substantial damage