NTSB investigations: Cessna 140, KY
12 cases on aircraft the registry lists as Cessna 140. 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
| 1964 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 2 |
| 1972 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1985 | 2 |
| 1987 | 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\" = '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 ('2071602', '2071603'))
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 ('2071602', '2071603'))
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 ERA17LA268Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Mount Sterling, KYA total loss of engine power for reasons that could not be determined based on the available information.NTSB ATL87LA183Accident · No injuriesLimited investigationFinal reportCessna 140 · Falmouth, KYThe pilot was on a cross-country flight and had made several refueling stops during the day. He stated that during landing he experienced a crosswind of approximately 7 to 10 knots. The aircraft bounced, rocked up on the left main landing gear, departed the…NTSB ATL85FA140Accident · 2 fatalField investigationFinal reportCessna 140 · Hawesville, KYThe acft collided with and sunk into the Ohio river following a wing separation after contacting the lowest wire in a set of 3 power lines which spanned the river. Two other wires were located above the set of 3 power lines. Witnesses on and near the river…NTSB ATL85LA130Accident · No injuriesLimited investigationFinal reportCessna 140 · Hawesville, KYThe plt was on a flt from lordsburg, NM, to mansfield, OH, and could not find hancock county airport, Hawesville, KY. While searching for the airport the engine lost total power due to fuel exhaustion. The plt said that he planned to refuel at hancock co.…NTSB IAD79DLQ06Accident · No injuriesClosedCessna 140 · Shelbyville, KYNTSB IAD76FLQ16Accident · Minor injuriesClosedCessna 140 · Bardstown, KYNTSB IAD75FLQ01Accident · No injuriesClosedCessna 140 · Symsonia, KYNTSB CHI73FLQ07Accident · No injuriesClosedCessna 140 · Monticello, KYNTSB CHI70D0001Accident · No injuriesClosedCessna 140 · Shepherdsville, KYNTSB CHI69F0583Accident · Minor injuriesClosedCessna 140 · West Paducah, KYNTSB CHI67F0542Accident · Serious injuriesClosedCessna 140 · Pine Top, KYNTSB UNK64X2701Accident · No injuriesClosedCessna 140 · Bowling Green, KY