Fatal NTSB investigations: Continental C85 series, 1986
6 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 | 6 |
|---|---|
| 1965 | 3 |
| 1966 | 3 |
| 1967 | 6 |
| 1968 | 7 |
| 1969 | 4 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 3 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 3 |
| 1977 | 3 |
| 1978 | 5 |
| 1979 | 7 |
| 1980 | 3 |
| 1981 | 3 |
| 1982 | 4 |
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 7 |
| 1986 | 6 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 8 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 4 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 3 |
| 2018 | 2 |
| 2019 | 2 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 3 |
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\") = 1986
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1986
AND c."highestInjuryLevel" = 'Fatal'
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 ATL87FA001Accident · 3 fatalField investigationFinal reportPiper J3-65C · Goldsboro, NCThe J-3 cub had been practicing touch and go landings at the uncontrolled airport when the Cessna 182 was returning from a cross-country flight. The pilot of the Cessna had received UNICOM airport advisories that indicated rwy 22 was the active runway. The…NTSB SEA86FA231Accident · 1 fatalField investigationFinal reportErcoupe 415C · Prosser, WAThe plt was practicing fly-bys for the next days airshow. The left wing sustained an inflight structural failure. Investigation revealed a progressive crack in the #7 rib emanating from previous damage to the leading edge of the left wing tip. This resulted…NTSB SEA86FA213Accident · 2 fatalField investigationFinal reportLuscombe 8A · Pelican, AKAt about 1500 adt on 8/19/86, the plt departed on a flt to hoonak, AK. When he did not return, a search was initiated. The acft was located at 1400 adt on the following day where it had crashed on rising mountainous terrain at an elev of about 1740 ft. an…NTSB ATL86FA178Accident · 2 fatalField investigationFinal reportCessna 120 · Marlton, NJAbout 10 min after takeoff, the acft collided with trees & crashed while the plts were performing aerobatic maneuvers. According to witnesses, aerobatics were being performed at an about 500 ft AGL. They rprtd that the plts had made an overhead maneuver…NTSB MKC86FA123Accident · 3 fatalField investigationFinal reportCessna 140 · Des Arc, ARNumerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…NTSB FTW86FA046Accident · 1 fatalField investigationFinal reportCessna 120 · Whitefield, OKThe pilot was flying at very low altitude while circling the area and most probably did not see the powerline, due to sunglare, until at very close range. He then pulled up steeply in the strong and gusty headwind and stalled the aircraft without sufficient…