NTSB investigations: Cessna 172K, OK
16 cases on aircraft the registry lists as Cessna 172K. 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 2 |
| 1971 | 3 |
| 1972 | 1 |
| 1973 | 3 |
| 1977 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1998 | 1 |
Where
Open the mapLatest 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.\"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 ('2072430'))
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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW98LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Marietta, OKThe pilot's improper compensation for the wind conditions. A factor was the crosswind.NTSB FTW82DA070Accident · No injuriesFinal reportCessna 172 · Hennessey, OKThe pilot reported that he encountered a gust of wind as he was flaring with full flaps about two feet above the strip. He stated that the right wing was blown down (the tail moved to the left) and the right wing collided with a fence beside the airstrip. The…NTSB FTW82FPM02Accident · No injuriesClosedCessna 172 · Broken Arrow, OKNTSB FTW80FPJ04Accident · No injuriesClosedCessna 172K · Norman, OKNTSB FTW77FPM06Accident · No injuriesClosedCessna 172K · Bartlesville, OKNTSB FTW74AF005Accident · 3 fatalClosedBoeing 727 · Yukon, OKNTSB FTW73FPM12Accident · Serious injuriesClosedCessna 172K · Henryetta, OKNTSB FTW73DPJ16Accident · No injuriesClosedCessna 172 · Alva, OKNTSB FTW72DPM22Accident · No injuriesClosedCessna 172 · Cookson, OKNTSB FTW72FPM15Accident · No injuriesClosedCessna 172K · Jenks, OKNTSB FTW71DPJ38Accident · No injuriesClosedCessna 172K · Altus, OKNTSB FTW71FPJ30Accident · No injuriesClosedCessna 172K · Bethany, OKNTSB FTW71DPJ19Accident · No injuriesClosedCessna 172 · Oklahoma Cty, OKNTSB FTW71FPM02Accident · Minor injuriesClosedCessna 172 · Tulsa, OKNTSB FTW70D0312Accident · No injuriesClosedCessna 172 · Pryor, OKNTSB FTW69F0324Accident · No injuriesClosedCessna 172K · Oklahoma Cty, OK