NTSB investigations: Continental C85 series, 1985, KY
3 cases on aircraft whose registry engine model is Continental C85 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
| 1964 | 1 |
|---|---|
| 1971 | 2 |
| 1976 | 1 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2006 | 1 |
| 2022 | 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 year(c.\"eventDate\") = 1985
AND 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.engine_model_code IN ('17008'))
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 year(c."eventDate") = 1985
AND 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.engine_model_code IN ('17008'))
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 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 ATL85LA094Accident · No injuriesLimited investigationFinal reportChampion 7FC · Louisville, KYThe student plt departed from a snow covered rwy & proceeded on a solo x-country. When he returned, the nosewheel broke thru the snow crusted surface & collapsed, then the acft nosed over. The plt said there were ruts on the rwy from other acft which caused…