Fatal NTSB investigations: Cessna 172S

8 cases on aircraft the registry lists as Cessna 172S, where the sequence of events included Aerodynamic stall/spin. 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

20082026
Fatal NTSB investigations: Cessna 172S per year, 2008–2026: 8 cases
20082
20121
20141
20172
20191
20201

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 ('2072439', '2072442')
      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\" = '241' 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 CEN20FA110Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Lincoln, ILThe pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.Mar 3, 2020 · N157SF · DestroyedNTSB ERA19FA107Accident · 2 fatalField investigationFinal reportCessna 172 · Mansfield, MAThe flight instructor's failure to maintain airplane control during initial climb after a touch-and-go landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.Feb 23, 2019 · N224TA · Substantial damageNTSB ERA17LA261Accident · 1 fatalLimited investigationFinal reportCessna 172 · Danbury, CTThe pilot's exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to operate the airplane above its maximum gross weight, which likely reduced…Jul 30, 2017 · N612DF · Substantial damageNTSB CEN17FA111Accident · 2 fatalField investigationFinal reportCessna 172S · Berthoud, COThe failure of the pilots to apply prompt and/or correct flight control inputs to adequately recover from the intentional aerodynamic spin.Feb 27, 2017 · N2461N · Substantial damageNTSB ERA14FA283Accident · 2 fatalField investigationFinal reportCessna 172S · Daytona Beach, FLA partial loss of engine power during the initial climb after takeoff for reasons that could not be determined due to the postaccident condition of the wreckage. Contributing to the accident was the pilots' decision to turn back to the airport, which led to…Jun 10, 2014 · N5524L · DestroyedNTSB WPR12FA230Accident · 4 fatalField investigationFinal reportCessna 172S · St. George, UTThe pilot's failure to maintain adequate airspeed during an aggressive pitch-up maneuver, which resulted in a low-altitude aerodynamic stall shortly after takeoff. Contributing to the accident was the pilot's impairment from alcohol consumption and an…May 26, 2012 · N953SP · Substantial damageNTSB LAX08LA191Accident · 2 fatalLimited investigationFinal reportCessna 172S · Oceanside, CAFailure of the pilot to regain airplane control during an intentional stall/spin maneuver.Jun 23, 2008 · N2436F · DestroyedNTSB NYC08FA133Accident · 4 fatalField investigationFinal reportCessna 172 · Indiantown, FLThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude. Contributing to the accident was the overweight condition of the airplane and the inoperative stall warning horn.Mar 13, 2008 · N284SP · Substantial damage