NTSB investigations: Continental C85 series, 2023
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\") = 2023
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") = 2023
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 CEN23LA378Accident · No injuriesClass 4 · LimitedFinal reportPiper J4 · Cleburne, TXThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions.NTSB CEN23LA322Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415-D · Waupun, WIThe pilot’s decision to take off without correcting a misinstalled fuel cap, which resulted in a loss of engine power due to fuel starvation caused by improper venting of the fuel system.NTSB ANC23LA053Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Ninilchik, AKA total loss of engine power due to a shift of a crankshaft main bearing, which resulted in a lack of lubrication and subsequent overheating and failure of the engine crankshaft.NTSB CEN23LA277Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-50 · Elbert, COThe pilot's loss of directional control during takeoff and subsequent excessive use of brakes which resulted in a nose-over. Contributing to the accident was his decision to takeoff downwind.NTSB CEN23LA208Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Cortez, COFailure of the right main landing gear due to prolonged corrosion of the landing gear tube, which weakened the gear.NTSB GAA23WA146Accident · 2 fatalClass 5 · ForeignEngineering & Research 415-C · St. Mary, JamaicaNTSB CEN23LA218Incident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Romeoville, ILThe inflight failure of the propeller blade due to fatigue cracking from corrosion pits, initiating at the midpoint of the cambered face.NTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.NTSB WPR23LA128Accident · Serious injuriesClass 3 · LimitedFinal reportJones Jay D Cassutt M 11 · Castroville, CAA failure of the outboard trailing edge rib in the left wing, which resulted in a separation of the left aileron and a loss of control.NTSB CEN23LA118Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Houston, TXThe pilot’s failure to attain/maintain lateral airplane control during landing, which resulted in an impact with the runway surface.NTSB CEN23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Eagle River, WIThe pilot’s decision to takeoff from an unsuitable surface which resulted in collision with an object.