NTSB investigations: Cessna 172H, KS
14 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.
Cases per year
| 1967 | 3 |
|---|---|
| 1969 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 2015 | 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\" = 'KS' 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" = 'KS' 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" 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 GAA15CA136Accident · No injuriesData collectionFinal reportCessna 172H · Cottonwood Falls, KSThe pilot's failure to attain adequate airspeed to climb the airplane out of ground effect, which resulted in an aerodynamic stall and a collision with terrain.NTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.NTSB MKC86LA178Accident · 1 fatalLimited investigationFinal reportCessna 172 · Emporia, KSThe acft was found stopped in an open field having penetrated the southern boundary of the Emporia airport property. The acft eng was still running when rescuers approached the location. Forced entry was made into the acft to shut the eng down and rescue the…NTSB MKC81DCG25Accident · No injuriesClosedCessna 172H · St Marys, KSNTSB MKC77OCQ33Accident · No injuriesClosedCessna 172H · Fall River, KSNTSB MKC74DCG34Accident · No injuriesClosedCessna 172 · Horton, KSNTSB MKC74DCQ14Accident · No injuriesClosedCessna 172 · Inman, KSNTSB MKC72FCG51Accident · Minor injuriesClosedCessna 172H · Gardner, KSNTSB MKC72DCQ47Accident · Minor injuriesClosedCessna 172H · Emporia, KSNTSB MKC70D0148Accident · No injuriesClosedCessna 172H · Hill City, KSNTSB MKC69D0458Accident · No injuriesClosedCessna 172H · Manhattan, KSNTSB MKC67F0605Accident · Minor injuriesClosedCessna 172 · Topeka, KSNTSB MKC67D0485Accident · Minor injuriesClosedCessna 172H · Cassody, KSNTSB MKC67F0425Accident · Minor injuriesClosedCessna 172H · Wichita, KS