NTSB investigations: Continental C85 series, 2004
15 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 | 171 |
|---|---|
| 1965 | 121 |
| 1966 | 127 |
| 1967 | 123 |
| 1968 | 97 |
| 1969 | 111 |
| 1970 | 79 |
| 1971 | 76 |
| 1972 | 75 |
| 1973 | 58 |
| 1974 | 60 |
| 1975 | 62 |
| 1976 | 58 |
| 1977 | 52 |
| 1978 | 38 |
| 1979 | 42 |
| 1980 | 31 |
| 1981 | 30 |
| 1982 | 30 |
| 1983 | 32 |
| 1984 | 34 |
| 1985 | 22 |
| 1986 | 38 |
| 1987 | 30 |
| 1988 | 27 |
| 1989 | 24 |
| 1990 | 20 |
| 1991 | 24 |
| 1992 | 26 |
| 1993 | 21 |
| 1994 | 32 |
| 1995 | 28 |
| 1996 | 21 |
| 1997 | 21 |
| 1998 | 28 |
| 1999 | 17 |
| 2000 | 18 |
| 2001 | 19 |
| 2002 | 11 |
| 2003 | 23 |
| 2004 | 15 |
| 2005 | 13 |
| 2006 | 17 |
| 2007 | 18 |
| 2008 | 16 |
| 2009 | 17 |
| 2010 | 17 |
| 2011 | 15 |
| 2012 | 16 |
| 2013 | 14 |
| 2014 | 19 |
| 2015 | 18 |
| 2016 | 19 |
| 2017 | 14 |
| 2018 | 17 |
| 2019 | 11 |
| 2020 | 8 |
| 2021 | 11 |
| 2022 | 16 |
| 2023 | 11 |
| 2024 | 10 |
| 2025 | 14 |
| 2026 | 9 |
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\") = 2004
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") = 2004
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 IAD05LA009Accident · No injuriesLimited investigationFinal reportCessna 120 · Willimantic, CTthe pilot's loss of directional control due to his uneven application of brakes. A factor in the accident was the tailwind.NTSB CHI04CA288Accident · No injuriesData collectionFinal reportAeronca 7BCM · St. James, MOThe pilot's failure to maintain clearance from trees during the go-around. Factors were the sun glare and the trees.NTSB ANC04LA109Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot's failure to use carburetor heat during takeoff/initial climb, which resulted in a total loss of engine power, and an in-flight collision with trees.NTSB FTW04LA202Accident · No injuriesLimited investigationFinal reportCessna 140 · Kingston, OKThe failure by the other pilot to maintain visual lookout for other aircraft during landing.NTSB MIA04CA114Accident · No injuriesData collectionFinal reportCessna 140 · Wimauma, FLThe improper in-flight weather evaluation by the student pilot resulting in a downwind landing and subsequent nose over.NTSB ANC04LA081Accident · No injuriesLimited investigationFinal reportCessna 120 · Beluga, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in airplane departing the landing surface into a ditch, and subsequently nosing over in tall bushes. A factor contributing to the accident was soft…NTSB LAX04LA265Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Santa Clarita, CAthe pilot's inadequate planning/decision by his inadequate evaluation of the weather resulting in an attempt to conduct flight beyond the aircraft's climb performance capability.NTSB CHI04CA175Accident · Minor injuriesData collectionFinal reportErcoupe 415C · Lake City, MIThe pilot selecting the wrong runway for the wind conditions and his delay in executing an aborted takeoff resulting in the airplane running off the departure end of the runway and into a ditch. The tailwind and the ditch were contributing factors.NTSB NYC04CA150Accident · No injuriesData collectionFinal reportHenes Zenair CH 701 · Mansfield, OHThe pilot's failure to maintain directional control during a precautionary landing. A factor was the pilot's unapproved maintenance modification resulting in the loss of oil pressure and partial loss of engine power.NTSB CHI04CA153Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Joliet, ILThe pilot's selection of unsuitable terrain for takeoff and the subsequent failure to maintain aircraft control during the encounter with the standing water. Contributing factors were the standing water and the soft runway condition.NTSB SEA04LA084Accident · No injuriesLimited investigationFinal reportPiper J4/E · Bigfork, MTA loss of engine power due to fuel exhaustion while in cruise flight as a result of inadequate preflight planning / preparation. Factors contributing to the accident were the short landing field and trees.NTSB ANC04LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Big Lake, AKAn in-flight loss of control for an undetermined reason, which resulted in a forced landing and in-flight collision with trees.NTSB CHI04LA075Accident · No injuriesLimited investigationFinal reportCessna 120 · Merrill, WIThe pilot's selection of unsuitable terrain to conduct a landing. Factors were the reported flat light conditions and the uneven terrain.NTSB FTW04LA065Accident · No injuriesLimited investigationFinal reportCessna 120 · Lonoke, ARThe loss of engine power for undetermined reasons. A contributing factor was the dusk lighting conditions and unlit airfield.NTSB LAX04LA092Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Vacaville, CAthe pilot's failure to either obtain a preflight weather report and forecast for the destination or to add additional fuel, which ultimately resulted in fuel exhaustion and collision with trees.