NTSB investigations: Continental C85 series, 1973
58 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\") = 1973
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") = 1973
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 CHI74DEM30Accident · Minor injuriesClosedPiper PA-11 · Newaygo, MINTSB SEA74DYC26Accident · No injuriesClosedCessna 140 · Portland, ORNTSB NYC74FFA17Accident · 1 fatalClosedCessna 140A · Scotia, NYNTSB MKC74DCG15Accident · No injuriesClosedAeronca 11AC · Ava, MONTSB OAK74DXQ15Accident · No injuriesClosedCessna 120 · Emigrnt Gap, CANTSB SEA74DTA14Accident · No injuriesClosedPiper J-3 · Culbertson, MTNTSB LAX74DUJ29Accident · No injuriesClosedCessna 140 · Willcox, AZNTSB NYC74FNE10Accident · No injuriesClosedCessna 140 · Simsbury, CTNTSB CHI74FEC18Accident · Minor injuriesClosedCessna 120 · Stockbridge, MINTSB NYC74FHD18Accident · No injuriesClosedPietenpol Aircam · Lakewood, NJNTSB FTW74FPJ11Accident · 1 fatalClosedPiper J-3 · Elk City, OKNTSB SEA74DYC21Accident · No injuriesClosedCessna 140 · Astoria, ORNTSB CHI74FEP15Accident · Minor injuriesClosedErco 415C · Portage, WINTSB ANC74FAA10Accident · No injuriesClosedAeronca S7BCM · Birch Lake, AKNTSB CHI74FEE21Accident · No injuriesClosedLuscombe 8E · Grayslake, ILNTSB NYC74AN021Accident · 2 fatalClosedAeronca S11AC · New Milford, CTNTSB IAD74DKM18Accident · No injuriesClosedCessna 140 · Greensboro, NCNTSB SEA74DYA10Accident · No injuriesClosedCessna 140 · Preston, IDNTSB FTW74DPG18Accident · No injuriesClosedCommonwlth 185 · Jonesboro, ARNTSB MKC74DCQ09Accident · No injuriesClosedCessna 140 · Goodland, KSNTSB MIA74FLG08Accident · No injuriesClosedPiper J3C-65 · Ulmers, SCNTSB OAK74FVW06Accident · No injuriesClosedCessna 120 · Las Vegas, NVNTSB SEA74FTA06Accident · Serious injuriesClosedCessna 140 · Ekalaka, MTNTSB MIA74DKG11Accident · No injuriesClosedCessna 140 · Thomaston, GANTSB ANC74DAG18Accident · No injuriesClosedPiper J-3 · Grizzly Lake, AKNTSB CHI74FEP09Accident · Minor injuriesClosedCessna 120 · Okauchee, WINTSB MKC74FCG07Accident · No injuriesClosedCessna 140 · Kansas City, MONTSB MKC74DCA05Accident · No injuriesClosedCessna 120 · House Springs, MONTSB FTW74DPJ05Accident · No injuriesClosedLuscombe 8A · Optima, OKNTSB IAD74DKM07Accident · No injuriesClosedAeronca 7BCM · Charlotte, NCNTSB IAD74FID06Accident · No injuriesClosedErco 415-D · Ashland, VANTSB OAK74DVG04Accident · No injuriesClosedCessna 140 · Georgetown, CANTSB IAD74DLT01Accident · No injuriesClosedCessna 140 · Arlington, TNNTSB IAD74AI003Accident · No injuriesClosedLuscombe 8E · Pasadena, MDNTSB CHI74DEI24Accident · Minor injuriesClosedCessna 120 · Valley City, OHNTSB CHI74DEI01Accident · No injuriesClosedCessna 140 · Canton, OHNTSB MIA73DLA47Accident · No injuriesClosedCessna 140 · Cross City, FLNTSB IAD74DKW03Accident · No injuriesClosedAeronca 7BCM · Gibbs Com, TNNTSB OAK73DXQ34Accident · No injuriesClosedLuscombe 8E · Truckee, CANTSB CHI73DEK27Accident · No injuriesClosedCessna 140 · Spring Mtn, OHNTSB MIA73DKG80Accident · No injuriesClosedCessna 140 · Marietta, GANTSB MKC73FER57Accident · No injuriesClosedCessna 140 · Anoka, MNNTSB CHI73DEI42Accident · Minor injuriesClosedLuscombe 8E · Belleville, OHNTSB MKC73DCD60Accident · No injuriesClosedCessna 120 · Councl Bluff, IANTSB CHI73DEA33Accident · No injuriesClosedEFF Graham Midget · Seymour, INNTSB OAK73DVG57Accident · Minor injuriesClosedPiper J-5 · Fair Oaks, CANTSB LAX73FUJ67Accident · Minor injuriesClosedGlobe GC-1B · Flagstaff, AZNTSB LAX73DUJ70Accident · Minor injuriesClosedErco 415-D · Catalina, AZNTSB FTW73FPG42Accident · No injuriesClosedErcoupe 415-C · Rosston, ARNTSB CHI73DEC26Accident · No injuriesClosedLuscombe 8E · Lake Orion, MI