NTSB investigations: Cessna 172K, IA
8 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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 2019 | 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\" = 'IA' 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" = 'IA' 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 GAA19CA193Accident · No injuriesData collectionFinal reportCessna 172 · Pella, IAThe student pilot's failure to maintain the runway heading and the flight instructor's delayed remedial action during landing, which resulted in the instructor landing the airplane in grass left of the runway and a subsequent nose-over.NTSB MKC87LA076Accident · No injuriesLimited investigationFinal reportCessna 172 · Muscatine, IAThe grass runway was 1300 feet long. The wind was 90 degrees cross at 5 knots, gusts to 20 KTS. The instructor said they had a wind shift and then they hit a soft spot near the end of the runway which slowed them. The elevator and stabilizer caught on a…NTSB MKC85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Kalona, IAThe plt reported that on the initial indication of rain, he elected to takeoff from the harvested soybean field before it became muddy. The field was soft & was about 2100 ft long. Before the acdnt, the wind was from the south, so the plt began his takeoff in…NTSB MKC81DCD10Accident · No injuriesClosedCessna 172 · Spencer, IANTSB MKC78DCD57Accident · No injuriesClosedCessna 172 · Jesup, IANTSB MKC76DCD38Accident · No injuriesClosedCessna 172 · Council Bluffs, IANTSB MKC72DCD14Accident · No injuriesClosedCessna 172K · Lowden, IANTSB MKC71DCD40Accident · No injuriesClosedCessna 172K · Johnston, IA