NTSB investigations: Cessna 172, IA
21 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.
Cases per year
| 1965 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 3 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 3 |
| 1972 | 3 |
| 1979 | 1 |
| 1986 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2009 | 1 |
| 2017 | 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 ('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" = '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 ('2072402'))
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 CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.NTSB CEN09LA409Accident · 1 fatalLimited investigationFinal reportCessna 172 · Latimer, IAThe pilot's failure to maintain clearance from the power line while flying at a low altitude.NTSB CHI96LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Ankeny, IAthe pilot's poor judgment in attempting flight operations in the existing wind condition, and the high gusting wind.NTSB CHI95LA220Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Cedar Rapids, IAthe pilot's lack of experience in flying from the right seat. A factor was the steep final approach.NTSB MKC86LA050Accident · No injuriesLimited investigationFinal reportCessna 172 · Des Moines, IAN8036B diverted to Des Moines for fuel after encountering strong head winds enroute. After landing on rwy 30R the plt turned off the rwy onto a taxiway that runs to the north. The plt then stopped to change radio frequencies. While the acft was stopped a…NTSB MKC79DCD19Accident · No injuriesClosedCessna 172 · Sioux Center, IANTSB MKC73DCD36Accident · No injuriesClosedCessna 172 · Columbus Jct, IANTSB MKC72FCD68Accident · No injuriesClosedCessna 172 · Storm Lake, IANTSB MKC72DCD51Accident · No injuriesClosedCessna 172 · Belmond, IANTSB MKC72AK009Accident · 1 fatalClosedCessna 172 · Bridgewater, IANTSB MKC71DCD64Accident · No injuriesClosedCessna 172 · Traer, IANTSB MKC71DCD54Accident · No injuriesClosedCessna 172 · Creston, IANTSB MKC70AK045Accident · 1 fatalClosedCessna 172 · Muscatine, IANTSB MKC69D0261Accident · No injuriesClosedCessna 172 · Fredericksburg, IANTSB MKC68D0543Accident · No injuriesClosedCessna 172 · Jefferson, IANTSB MKC68D0187Accident · No injuriesClosedCessna 172 · Corydon, IANTSB MKC68F0206Accident · No injuriesClosedCessna 172 · Adel, IANTSB MKC67D0583Accident · Minor injuriesClosedCessna 172 · Pella, IANTSB MKC67D0275Accident · No injuriesClosedCessna 172 · Anita, IANTSB MKC67A0004Accident · 3 fatalClosedCessna 172 · Lorimor, IANTSB MKC66F0058Accident · Minor injuriesClosedCessna 172 · Murray, IA