NTSB investigations: Cessna 172L, MO

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

19722026

NTSB investigations: Cessna 172L, MO per year, 1972–2026: 8 cases
1972	1
1974	1
1976	1
1978	2
1984	1
1988	1
1993	1

Where

Open the map

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 ('2072432')) 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 ('2072432'))
  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 ('2072432'))
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 CHI93LA339Accident · No injuriesLimited investigationFinal reportCessna 172L · Curryville, MOImproper preflight planning and procedures by the pilot-in-command which resulted in fuel exhaustion.Aug 27, 1993 · N25BK · Substantial damage NTSB MKC88LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cameron, MOThe student pilot said he was practicing short field takeoffs from his pasture, when he stalled shortly after takeoff. The aircraft fell uncontrolled to the terrain causing substantial damage to the wings, fuselage and nose gear.Sep 25, 1988 · N2866Q · Substantial damage NTSB MKC84LA249Accident · No injuriesLimited investigationFinal reportCessna 172L · Chesterfield, MODuring arrival the plt was instructed to make a right hand traffic pattern. She was cleared to land behind another acft on a touch & go from a left pattern. The other acft was still on the rwy when she started flaring to land. The plt stated that the acft…Aug 13, 1984 · N2898Q · Substantial damage NTSB MKC79DER06Accident · No injuriesClosedCessna 172 · Eveleth, MONov 22, 1978 · N9816G · Substantial damage NTSB MKC78DCA20Accident · No injuriesClosedCessna 172 · Bismarck, MOApr 29, 1978 · N3980Q · Substantial damage NTSB MKC76FCA28Accident · Serious injuriesClosedCessna 172L · Eminence, MOJun 19, 1976 · N19626 · Substantial damage NTSB MKC74FCA23Accident · No injuriesClosedCessna 172L · St Charles, MOMar 3, 1974 · N7630G · Substantial damage NTSB MKC73AK032Accident · 1 fatalClosedCessna 172L · Thayer, MOSep 1, 1972 · N2897Q · Destroyed