Skip to content

NTSB investigations: Cessna 172G, MO

19 cases on aircraft the registry lists as Cessna 172G. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072420')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072420'))
  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.

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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072420'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI06LA095Accident · No injuriesLimited investigationFinal reportCessna 172G · Collins, MOThe pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion, and the loss of engine power during cruise flight. An additional cause was the pilot's improper in-flight decision to continue when he believed his fuel gauges were erratic…Mar 22, 2006 · N4444L · Substantial damage NTSB CHI02LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Butler, MOThe fuel exhaustion, the inadequate fuel consumption calculations by the pilot, and the inadequate in-flight planning/decision by the pilot. The unsuitable terrain encountered during the forced landing is a contributing factor.Jun 17, 2002 · N5953R · Substantial damage NTSB MKC88FA124Accident · 1 fatalField investigationFinal reportCessna 172G · Sarcoxie, MOWitnesses at the acdnt site characterized the wx as having a low ceiling with fog. They rprtd they saw the acft 'appear out of clouds' in a steep descent. The acft then began to 'pull up;' however, during recovery from the dive, the acft struck trees &…Jul 13, 1988 · N4288L · Destroyed NTSB MKC88LA068Accident · No injuriesLimited investigationFinal reportCessna 172G · Springfield, MOThe pilot reported that while taxiing for takeoff a wind gust caught the wing of the aircraft resulting in loss of aircraft control. Aircraft moved nose down and the propeller and the right wing contacted the runway. Winds at the time of the accident were 180…Mar 24, 1988 · N72PF · Substantial damage NTSB MKC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Grain Valley, MOThe PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon…Mar 2, 1986 · N3979L · Substantial damage NTSB MKC85LA203Accident · No injuriesLimited investigationFinal reportCessna 172G · Deepwater, MOThe acft was crusing at 2,000 ft, 50 min after takeoff when the eng began running rough, lost RPM, and then quit. The plt made a forced landing in a small fld and the collided with trees during the landing roll. The investigation, which included running the…Sep 1, 1985 · N3943L · Substantial damage NTSB MKC81FA042Accident · 2 fatalClosedCessna 172G · Newburg, MOJul 5, 1981 · N1383F · Destroyed NTSB MKC78DCA46Accident · No injuriesClosedCessna 172 · Taylor, MOAug 12, 1978 · N4191L · Substantial damage NTSB MKC78FCG28Accident · Minor injuriesClosedCessna 172G · Springfield, MOMay 10, 1978 · N4233L · Substantial damage NTSB MKC73FCG11Accident · Minor injuriesClosedCessna 172 · Shell Knob, MOAug 21, 1972 · N5728R · Destroyed NTSB MKC72FCA22Accident · Minor injuriesClosedCessna 172G · Middletown, MOFeb 11, 1972 · N4206L · Destroyed NTSB MKC71DCG75Accident · No injuriesClosedCessna 172 · Springfield, MOApr 2, 1971 · N1381F · Substantial damage NTSB MKC70DCG07Accident · No injuriesClosedCessna 172G · Columbia, MOFeb 13, 1970 · N3981L · Substantial damage NTSB MKC68D0251Accident · Minor injuriesClosedCessna 172 · Clinton, MOSep 11, 1967 · N3738L · Substantial damage NTSB MKC67A0068Accident · 5 fatalClosedCessna 172G · Portland, MOMay 12, 1967 · N4409L · Destroyed NTSB MKC67A0047Accident · 2 fatalClosedCessna 172G · Warrensburg, MOFeb 13, 1967 · N4403L · Destroyed NTSB MKC67D0152Accident · No injuriesClosedCessna 172 · Piedmont, MOJun 22, 1966 · N4408L · Substantial damage NTSB MKC66F0528Accident · No injuriesClosedCessna 172 · St. Joseph, MOApr 2, 1966 · N5755R · Substantial damage NTSB MKC66D0445Accident · No injuriesClosedCessna 172 · Macon, MOMar 6, 1966 · N2975U · Substantial damage