NTSB investigations: Cessna 172N, KY
12 cases on aircraft the registry lists as Cessna 172N. 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
| 1979 | 2 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2002 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2024 | 1 |
| 2025 | 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\" = 'KY' 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 ('2072434'))
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" = 'KY' 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 ('2072434'))
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 ERA25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mayfield, KYThe student pilot’s improper landing flare, which resulted in a hard landing and nose landing gear collapse.NTSB ERA24LA352Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Danville, KYThe pilot’s failure to maintain control of the airplane while landing and his inadequate communication to the pilot-rated passenger of her role during the flight.NTSB ERA21LA050Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cynthiana, KYThe pilot’s failure to maintain proper glide path during a visual approach that was conducted at night, resulting in a collision with trees and terrain.NTSB GAA19CA367Accident · Minor injuriesData collectionFinal reportCessna 172 · Lebanon, KYThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion, impact with a ditch, and subsequent nose-over.NTSB IAD03FA005Accident · 2 fatalField investigationFinal reportCessna 172N · Mount Sterling, KYThe failure of the pilot to follow the published instrument approach procedure, which resulted in an early descent into an antenna tower. A factor was the low ceiling.NTSB MIA95FA070Accident · 2 fatalField investigationFinal reportCessna 172N · Mintonville, KYThe flightcrew's intentional VFR flight into known instrument meteorological conditions. A factor was the inadequate altitude to prevent an inadvertent collision with an obstruction.NTSB BFO93LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Falmouth, KYThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent swerve, and his delayed remedial action.NTSB ATL90FA008Accident · 2 fatalField investigationFinal reportCessna 172N · Eddyville, KYThe pilot continuing VFR flight into adverse weather conditions. Contributing factor(s) was: low ceiling and rain.NTSB ATL81FA015Accident · Minor injuriesClosedCessna 172N · Hazard, KYNTSB ATL80FA058Accident · 4 fatalClosedCessna 172N · West Liberty, KYNTSB IAD79FA088Accident · No injuriesClosedCessna 172 · Paducah, KYNTSB IAD79FA053Accident · 1 fatalClosedCessna 172N · Mackville, KY