Skip to content

NTSB investigations: Cessna 172, MO

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

19642026

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 ('2072402')) 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 ('2072402'))
  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 ('2072402'))
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 CEN17LA241Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fulton, MOThe partial loss of engine power due to water contamination in the fuel system.Jun 24, 2017 · N6474B · Substantial damage NTSB CHI07CA012Accident · Minor injuriesData collectionFinal reportCessna 172 · Maryville, MOThe pilot's inadequate recovery from a bounced landing leading to the nose gear overload.Oct 29, 2006 · N8196B · Substantial damage NTSB CHI01LA031Accident · No injuriesLimited investigationFinal reportCessna 172 · Carrollton, MOthe misjudged touchdown point by the pilot. Factors were the runway lights not on, the dark night, and the plowed field.Oct 29, 2000 · N8611B · Substantial damage NTSB CHI00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Buffalo, MOThe inadvertent stall during a go-around. Factors relating to this accident were the student pilot's improper in-flight decisions and his failure to raise the flaps during the go around.Sep 21, 2000 · N7353A · Substantial damage NTSB CHI93LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aurora, MOThe pilot's lack of familiarity with the airplane, a switched off fuel selector and fuel starvation.Nov 8, 1992 · N5889A · Destroyed NTSB MKC89LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Linn, MOWhile attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…Nov 3, 1988 · N6287E · Substantial damage NTSB MKC86LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Guilford, MOThe plt reports that he landed hard, bounced and came down on the nose gear. The nose gear broke and the acft went over on its back.Oct 5, 1985 · N4016F · Substantial damage NTSB MKC83LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenfield, MOThe plt reported that before landing he applied carburetor heat & extended full flaps. Reportedly, he made a steep approach to the 3000 ft, sod rwy. He said he overshot the 1st half of the rwy & touched down at about midfield. At this point, the plt initiated…Mar 16, 1983 · N6258E · Substantial damage NTSB MKC82FCA02Accident · Minor injuriesClosedCessna 172 · Piedmont, MONov 2, 1981 · N7284A · Destroyed NTSB MKC77FCA15Accident · No injuriesClosedCessna 172 · Qulin, MOApr 9, 1977 · N8090B · Substantial damage NTSB MKC76FCA22Accident · Minor injuriesClosedCessna 172 · Shelbyville, MOApr 24, 1976 · N8507B · Substantial damage NTSB MKC74DCG44Accident · No injuriesClosedCessna 172 · Columbia, MOJun 23, 1974 · N8319B · Substantial damage NTSB MKC73DCG32Accident · No injuriesClosedCessna 172 · Springfield, MOMar 14, 1973 · N3935F · Substantial damage NTSB MKC73AK033Accident · No injuriesClosedCessna 172 · Chesterfield, MONov 4, 1972 · N20183 · 2 aircraft · Substantial damage NTSB MKC72DCG58Accident · No injuriesClosedCessna 172 · Stover, MOJun 3, 1972 · N6892A · Substantial damage NTSB MKC69F0284Accident · No injuriesClosedCessna 172 · Carrollton, MONov 14, 1968 · N4097F · Substantial damage NTSB MKC68D0410Accident · No injuriesClosedCessna 172 · Kansas City, MONov 24, 1967 · N8673B · Substantial damage NTSB MKC68D0296Accident · No injuriesClosedCessna 172 · St Joseph, MOJul 6, 1967 · N8040B · Substantial damage NTSB MKC68D0133Accident · No injuriesClosedCessna 172 · Lancaster, MOJun 18, 1967 · N5733A · Destroyed NTSB MKC67F0028Accident · No injuriesClosedCessna 172 · Berger, MOJun 17, 1966 · N7287A · Substantial damage NTSB MKC67D0069Accident · No injuriesClosedCessna 172 · St.Charles, MOMay 28, 1966 · N5643A · Substantial damage NTSB MKC65F0117Accident · No injuriesClosedCessna 172 · St Charles, MOApr 11, 1965 · N8894B · Substantial damage NTSB MKC65F0080Accident · No injuriesClosedCessna 172 · Kansas City, MOJan 25, 1965 · N5009A · Substantial damage NTSB MKC65F0026Accident · No injuriesClosedCessna 172 · Kansas City, MOJan 9, 1965 · N8040B · Substantial damage NTSB UNK65X0796Accident · No injuriesClosedCessna 172 · East Prairie, MONov 22, 1964 · N6833A · Substantial damage