NTSB investigations: Continental C85 series, 2018
17 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\") = 2018
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") = 2018
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 GAA19CA026Accident · No injuriesData collectionFinal reportCessna 140 · Denver, COThe pilot’s inadvertent brake application, which resulted in a loss of directional control and a subsequent nose-over.NTSB CEN19LA006Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Hudson, COThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA013Accident · No injuriesData collectionFinal reportCessna 140 · Marina, CAThe pilot’s inadvertent application of the brakes, which resulted in a nose-over.NTSB GAA18CA568Accident · No injuriesData collectionFinal reportCessna U206 · Millbrook, NYThe failure of the other pilot to yield to traffic established on the taxiway, which resulted in a ground collision.NTSB CEN18LA362Accident · Serious injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Carlisle, OHA total loss of engine power shortly after takeoff due to carburetor ice.NTSB GAA18CA495Accident · No injuriesData collectionFinal reportCessna 140 · Hayes Center, NEThe pilot's failure to maintain directional control during landing.NTSB WPR18LA224Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Marsing, IDThe loss of engine power during a low pass as a result of a blockage of the carburetor idle chambers which led to a forced landing in a river.NTSB CEN18LA317Accident · No injuriesLimited investigationFinal reportCessna 120 · Pomona, MOThe pilot's inadequate fuel management, which resulted in fuel starvation and a forced landing.NTSB GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA455Accident · No injuriesData collectionFinal reportCessna 140 · Healdsburg, CAThe pilot's improper brake application during the landing roll, which resulted in a nose-over.NTSB CEN18FA235Accident · 2 fatalField investigationFinal reportErcoupe 415 D · Monmouth, ILA loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18LA223Accident · Serious injuriesClass 3 · LimitedFinal reportAeronca 7BCM · Eureka Springs, ARThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power after takeoff for undetermined reasons, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.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 CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.NTSB GAA18CA221Accident · No injuriesData collectionFinal reportCessna 120 · Iola, WIThe pilot’s decision to reject the takeoff from a snow-covered grass surface, which resulted in a nose-over.NTSB GAA18CA166Accident · No injuriesData collectionFinal reportCessna 140 · Madison, SDThe flight instructor’s delayed aborted takeoff on a soft, wet, grass runway, which resulted in a runway overrun.NTSB GAA18CA128Accident · No injuriesData collectionFinal reportCessna 140 · Keller, TXThe pilot's inability to gain altitude normally in order to avoid a flock of ducks flying overhead during takeoff, which resulted in the airplane striking a fence.