NTSB investigations: Cessna 172H, OK

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

NTSB investigations: Cessna 172H, OK per year, 1966–2026: 10 cases
1966	1
1967	1
1968	1
1971	1
1972	1
1974	1
1976	1
1986	1
2018	1
2019	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" = 'OK' 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 ('2072424')) 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\" = 'OK' 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 ('2072424'))
  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" = 'OK' 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 ('2072424'))
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 CEN19LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Kingston, OKThe partial loss of engine power due to a stuck exhaust valve.Jul 22, 2019 · N8251L · Substantial damage NTSB GAA18CA485Accident · No injuriesData collectionFinal reportCessna 172 · Sallisaw, OKThe student pilot's loss of directional control during the landing roll.Aug 4, 2018 · N707TM · Substantial damage NTSB 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 damage NTSB FTW76FPJ50Accident · Serious injuriesClosedCessna 172 · Hooker, OKAug 5, 1976 · N2534L · Destroyed NTSB FTW74DPM23Accident · No injuriesClosedCessna 172 · Honobia, OKMay 2, 1974 · N3801R · Substantial damage NTSB FTW72DPJ31Accident · No injuriesClosedCessna 172 · Oklahoma Cty, OKJan 23, 1972 · N1423F · Substantial damage NTSB FTW72FPJ10Accident · Minor injuriesClosedCessna 172H · Bethany, OKAug 27, 1971 · N2790L · Substantial damage NTSB FTW68F0483Accident · 1 fatalClosedCessna 172 · Broken Arrow, OKMar 1, 1968 · N8063L · Destroyed NTSB FTW67F0655Accident · Minor injuriesClosedCessna 172H · Bethany, OKJun 1, 1967 · N3783R · Substantial damage NTSB FTW67D0305Accident · No injuriesClosedCessna 172 · Jenks, OKNov 23, 1966 · N1422F · Substantial damage