NTSB investigations: Cessna 172K, OH
14 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
| 1969 | 1 |
|---|---|
| 1971 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2014 | 1 |
| 2022 | 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\" = 'OH' 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" = 'OH' 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 ERA22LA267Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe student pilot’s loss of control during climb after an aborted landing, which resulted in an aerodynamic stall.NTSB CEN15LA024Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Xenia, OHThe failure of the seat track mechanism, which led the pilot to inadvertently apply aft yoke and lift his feet off the rudder pedals and resulted in a loss of directional control during takeoff.NTSB NYC04CA028Accident · No injuriesData collectionFinal reportCessna 172K · Kilbourne, OHThe pilot's failure to obtain the proper touchdown point which resulted in an overrun and subsequent nose over.NTSB IAD99LA001Accident · No injuriesLimited investigationFinal reportCessna 172K · Middlefield, OHThe pilot's inadequate preflight inspection which resulted in fuel exhaustion.NTSB NYC94LA060Accident · No injuriesLimited investigationFinal reportCessna 172K · Dayton, OHthe pilot's failure to maintain directional control which resulted in a runway overrun. Factors are the pilot's improper recovery from a bounced landing, and his lack of experience.NTSB BFO92LA104Accident · No injuriesLimited investigationFinal reportCessna 172K · Piqua, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB ATL90LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Columbus, OHImproper planning/decision by the pilot. A factor related to the accident was: the adverse wind condition.NTSB CHI79DEG23Accident · Minor injuriesClosedCessna 172 · Troy, OHNTSB CHI79FEI29Accident · No injuriesClosedCessna 172K · Youngstown, OHNTSB CHI78FEK18Accident · No injuriesClosedCessna 172K · Fredericktown, OHNTSB CHI74FEI31Accident · Minor injuriesClosedCessna 172 · Warren, OHNTSB CHI71DEI50Accident · Minor injuriesClosedCessna 172 · Cleveland, OHNTSB CHI71FGG28Accident · No injuriesClosedCessna 172 · Columbus, OHNTSB CHI70D0399Accident · Serious injuriesClosedCessna 172 · Wadsworth, OH