Fatal NTSB investigations: Continental 0-200 series, KY
14 cases on aircraft whose registry engine model is Continental 0-200 series. 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 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1980 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1996 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2006 | 1 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17020'))
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 NYC06LA214Accident · 1 fatalLimited investigationFinal reportCessna 150K · Shelby Gap, KYThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.NTSB NYC06LA010Accident · 1 fatalLimited investigationFinal reportCessna 150F · Pineville, KYThe pilot's continued VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors in the accident were the low cloud ceiling and fog.NTSB NYC04LA011Accident · 2 fatalLimited investigationFinal reportCessna 150M · Wax, KYThe pilot's failure to maintain obstacle clearance. Low altitude flight is a contributing factor.NTSB NYC03LA090Accident · 1 fatalLimited investigationFinal reportStarnes Quickie Q-200 · Henderson, KYThe pilot's improper recovery from a bounced landing and his failure to maintain directional control, after experiencing an in-flight loss of control for undetermined reasons.NTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.NTSB ATL87FA244Accident · 1 fatalField investigationFinal reportCessna 150L · Murray, KYPIC stated to friends he intended to execute a hammerhead stall after take off from a private grass strip. Airstrip owner observed acft make a low pass, pitch up vertically, and execute a hammerhead stall at about 450-500 feet AGL. There was insufficient…NTSB ATL85FLT06Accident · 1 fatalFinal reportCessna 150F · Jeffersonville, KYThe acft collided with the ground in a steep nose down attitude while banking to the left. The acft was in the process of making an approach to land in an off arpt pasture which was not normally used for acft operations. No mecanical reasons for the accident…NTSB ATL80FA045Accident · 1 fatalClosedCessna 150 · Pikeville, KYNTSB IAD80FA027Accident · 1 fatalClosedCessna 150 · Reidland, KYNTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYNTSB IAD76AI081Accident · 3 fatalClosedCessna 150 · Elkhorn City, KYNTSB CHI73AC016Accident · 1 fatalClosedCessna 150H · Louisville, KYNTSB CHI72FLQ24Accident · 1 fatalClosedCessna 150H · Louisville, KYNTSB CHI69A0089Accident · 1 fatalClosedCessna 150 · Prospect, KY