Fatal NTSB investigations: Continental C90 series, 1986
2 cases on aircraft whose registry engine model is Continental C90 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 | 2 |
|---|---|
| 1966 | 2 |
| 1967 | 3 |
| 1968 | 2 |
| 1969 | 3 |
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 4 |
| 1980 | 6 |
| 1981 | 2 |
| 1982 | 2 |
| 1984 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2006 | 1 |
| 2008 | 2 |
| 2010 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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 ('17009'))
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 ('17009'))
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 LAX86LA322Accident · 2 fatalLimited investigationFinal reportLuscombe 8F · Marble Canyon, AZWitnesses rprtd that prior to the acdnt, the plt made a low pass over a raft on the Colorado river to 'wave his wings' at the rafting group. Rprtdly, he was attempting to reverse his direction when the acft suddenly crashed in the river. A search was…NTSB MIA86FA184Accident · 2 fatalField investigationFinal reportAeronca 7CCM · Boynton Beach, FLAccording to witnesses, the acft entered a turn shortly after taking off from a touch-&-go landing, then stalled & began to spin to the right. The acft impacted the ground at the edge of a canal, aprx 1000 ft from the dept end of the rwy. One witness stated…