Fatal NTSB investigations: Cessna 172S

25 cases on aircraft the registry lists as Cessna 172S, where the sequence of events included Collision with terr/obj (non-CFIT). 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: 25 cases
20083
20092
20101
20112
20123
20132
20141
20152
20172
20181
20192
20201
20211
20221
20241

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\" = '470' 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 ERA25FA082Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Cintrona, PRMaintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.Dec 20, 2024 · N22088 · DestroyedNTSB ERA23FA001Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Hermantown, MNThe pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…Oct 2, 2022 · N262TA · Substantial damageNTSB ERA22FA058Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Branchville, NJThe flight instructor’s failure to recover from a steep spiral turn during an instructional flight.Nov 11, 2021 · N90559 · DestroyedNTSB 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 CEN19FA221Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Katy, TXThe pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.Jul 13, 2019 · N517LA · 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 ERA18LA094Accident · 2 fatalLimited investigationFinal reportCessna 172 · Ocean City, MDThe pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.Mar 1, 2018 · N615JA · DestroyedNTSB 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 ANC16LA011Accident · 1 fatalLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's intentional flight into a building.Dec 29, 2015 · N914CP · DestroyedNTSB ERA16LA008Accident · 1 fatalLimited investigationFinal reportCessna 172S · Seville, FLThe airplane’s encounter with a downdraft, and the pilot's decision to maneuver the airplane at a low altitude and airspeed, which provided insufficient time and altitude to recover before impacting terrain.Oct 10, 2015 · N5295Y · 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 WPR13FA254Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Anthem, AZThe failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.May 31, 2013 · N327PA · 2 aircraft · Substantial damageNTSB WPR13FA116Accident · 1 fatalField investigationFinal reportCessna 172S · Minden, NVThe pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.Feb 7, 2013 · N328SP · DestroyedNTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.Dec 2, 2012 · N3554Y · Substantial damageNTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.Mar 23, 2012 · N10468 · 2 aircraft · Substantial damageNTSB ERA12FA193Accident · 2 fatalField investigationFinal reportCessna 172S · Key West, FLThe non-night-qualified pilot's improper decision to depart in dark night visual meteorological conditions, which resulted in his subsequent spatial disorientation, loss of control, and impact with water.Feb 24, 2012 · N53589 · Substantial damageNTSB ERA11FA146Accident · 2 fatalField investigationFinal reportCessna 172S · New Smyrna Beach, FLThe flight instructor's failure to recognize or implement adequate remedial action to counter the effects of spatial disorientation. Contributing to the accident was the spatial disorientation experienced by one or both pilots.Feb 16, 2011 · N6345L · Substantial damageNTSB ERA11FA118Accident · 2 fatalField investigationFinal reportCessna 172S · North Myrtle Beach, SCThe pilot's loss of airplane control during a missed approach due to spatial disorientation.Jan 18, 2011 · N2100V · Substantial damageNTSB ERA10LA105Accident · 1 fatalLimited investigationFinal reportCessna 172S · Greenbush, METhe pilot's improper decision to attempt a transoceanic flight in turbulent, icing conditions, with an overweight airplane that was not approved for moderate turbulence and not equipped with deicing systems. Contributing to the accident was the pilot's…Jan 4, 2010 · N5118J · Substantial damageNTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…Dec 8, 2009 · N5269X · DestroyedNTSB ERA10FA048Accident · 2 fatalField investigationFinal reportCessna 172S · Tallahassee, FLThe pilots' spatial disorientation during flight in dark conditions, which resulted in an uncontrolled descent into terrain.Nov 5, 2009 · N5194X · DestroyedNTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light conditions.Dec 18, 2008 · N967SP · DestroyedNTSB 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