NTSB investigations: Continental C85 series, 2002
11 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
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 year(c.\"eventDate\") = 2002
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") = 2002
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 SEA03LA002Accident · Serious injuriesLimited investigationFinal reportGentry Vari-Eze · Shine, WALoss of engine power for undetermined reasons during cruise. Trees and objects near the roadway were factors.NTSB CHI02LA281Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Effingham, ILThe partial loss of engine power due to the seized exhaust valve. A factor was the soft field.NTSB CHI02CA279Accident · Serious injuriesData collectionFinal reportCessna 120 · Brookfield, WIThe inadequate visual outlook by the pilot during taxi.NTSB SEA02LA158Accident · No injuriesLimited investigationFinal reportCessna 120 · Missoula, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Delayed remedial action and a high crosswind condition were factors.NTSB CHI02LA230Accident · No injuriesLimited investigationFinal reportErcoupe G · Palmyra, WIFailure by the pilot-in-command to properly compensate for the wind conditions, as well as an improper landing flare. Contibuting factors were the inadequate supervision by the flight instructor and the wind gusts.NTSB CHI02LA225Accident · No injuriesLimited investigationFinal reportCessna 140 · Cook, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB FTW02LA168Accident · No injuriesLimited investigationFinal reportErcoupe ERCO-415-E · Conway, ARThe loss of engine power for undetermined reasons. Factors were the pilots necessity to avoid a power line during the emergency descent and the lack of suitable terrain for the forced landing.NTSB CHI02LA118Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Racine, WIThe inadequate weather evaluation and delayed application of carburetor heat by the pilot, and the unsuitable terrain encountered during the forced landing. The carburetor icing conditions and the low altitude were factors.NTSB FTW02LA126Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Powderly, TXthe pilot's failure to maintain directional control during the takeoff roll, which resulted in an encounter with muddy terrain and a nose over. Contributing factors to the accident were the crosswind and muddy terrain.NTSB CHI02LA104Accident · Serious injuriesLimited investigationFinal reportHoagland Varieze · Gary, INThe pilot was unable to maintain directional control of the airplane during the forced landing due to a locked brake. Factors associated with the accident were the pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion and the…NTSB SEA02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Deer Park, WALoss of directional control while landing. A drainage ditch was a factor.