NTSB investigations: Cessna 172H

14 cases on aircraft the registry lists as Cessna 172H, where the first occurrence was “Loss of control - on ground/water”. 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

19832026
NTSB investigations: Cessna 172H per year, 1983–2026: 14 cases
19832
19863
19871
19882
19901
19911
19921
19931
20001
20021

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072424')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
  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 ANC02LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the runway and colliding with objects. Factors contributing to the accident were the rough and uneven runway, and the premature lift-off of the…Aug 27, 2002 · N3752F · Substantial damageNTSB CHI01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Kalkaska, MIThe student pilot's failure to maintain aircraft control on the ground. Factors relating to this accident were the student pilot's improper abort procedures, the sign, and the ditch.Nov 15, 2000 · N1706F · Substantial damageNTSB CHI93LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Manistique, MIAn excessive taxi speed.Mar 2, 1993 · N8275L · Substantial damageNTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.Aug 9, 1992 · N8100L · Substantial damageNTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.Dec 31, 1991 · N3281L · Substantial damageNTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.Oct 4, 1990 · N3226L · Substantial damageNTSB ANC89FA028Accident · No injuriesField investigationFinal reportCessna 172 · Anchorage, AKThe 103 hour private pilot was in the process of demonstrating his Cessna 172 conventional gear airplane (tail-dragger) to a prospective purchaser, when he lost directional control during landing and nosed-over. The pilot reported that he had just touched…Dec 30, 1988 · N3752F · Substantial damageNTSB MKC88LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Warrensburg, MOWhile practicing stop and go ldgs, the student lost directional control. The takeoff was attempted with a left crosswind. The acft veered to the left, off the runway, and hit an embankment. The nose and left main gears, the propeller, and fuselage were…Sep 10, 1988 · N1462F · Substantial damageNTSB DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.Mar 23, 1987 · N1725F · Substantial damageNTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…Aug 26, 1986 · N3791R · Minor damageNTSB DEN86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Albuquerque, NMWhile taxiing for takeoff in strong gusty wind conditions the aircraft was blown into an inverted position on the taxiway.Jul 31, 1986 · N3809R · Substantial damageNTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.Mar 31, 1986 · N2826L · Substantial damageNTSB CHI84LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · Kentland, INThe acft ran off the rwy into soft dirt during landing roll and cartwheeled. The student plt landed on rwy 27 with windsreported from the south at 18-20 KTS. After a 100 ft ground roll the acft left the rwy to the right into an open field where it cartwheeled.Nov 14, 1983 · N2549L · Substantial damageNTSB FTW83LA395Accident · No injuriesLimited investigationFinal reportCessna 172H · Plano, TXThe acft collided with 2 parked acft after the student plt lost control during landing. The plt stated that he experienced a crosswind gust or updraft during touchdown. The landing was on rwy 16 and the wind was estimated to be from 220 degrees at 12 KTS. The…Aug 25, 1983 · N8058L · Substantial damage