Fatal NTSB investigations: Continental C85 series, FL
10 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2018 | 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\" = 'FL' 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 ('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 c."eventStateOrRegion" = 'FL' 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 ('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 ERA18FA152Accident · 1 fatalField investigationFinal reportCessna 140 · Daytona Beach, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation during the initial climb, and his failure to maintain adequate airspeed while turning back to the runway, which resulted in an exceedance of the…NTSB ERA09FA087Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Sebring, FLThe pilot's exceedance of the design stress limitations of the airplane.NTSB MIA06LA118Accident · 2 fatalLimited investigationFinal reportErcoupe 415C · Panacea, FLA loss of engine power for undetermined reasons, which resulted in the airplane descending and impacting trees during the approach. A possible contributing factor was the pilot's pre-existing cardiovascular condition.NTSB MIA03FA077Accident · 1 fatalField investigationFinal reportChampion Aeronca 7BCM · Pahokee, FLThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall while maneuvering.NTSB MIA88FA184Accident · 2 fatalField investigationFinal reportPiper J3C · N Fort Myers, FLThe plt tkof on rwy 27 with the wind fm 060 deg at 12 gusting 23 KTS. Density alt was 2100'. Witnesses said the acft was in a slow speed, nose hi climb, when eng pwr was interrupted momentarily. Pwr was restored, but soon thereafter, the acft rolled rgt,…NTSB MIA87FA250Accident · 3 fatalField investigationFinal reportCommonwealth 185 · St. Petersburg, FLThe pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…NTSB MIA85FA239Accident · 2 fatalField investigationFinal reportSilvaire Luscombe 8E · Ocala, FLThe acft was observed to take off, make a steep turn, a few seconds later, at an altitude of about 200 ft AGL, enter another steep turn and spin into the ground. Witnesses report that the pilot exhibited lack of control coordination while performing turns in…NTSB MIA68A0001Accident · 1 fatalClosedPiper J3C-65 · Clewiston, FLNTSB MIA67A0031Accident · 2 fatalClosedLuscombe 8C · Zephrhills, FLNTSB MIA66A0011Accident · 2 fatalClosedCessna 120 · Brooksville, FL