NTSB investigations: Continental C85 series, 1967, WA
8 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 | 5 |
|---|---|
| 1965 | 3 |
| 1966 | 4 |
| 1967 | 8 |
| 1968 | 4 |
| 1969 | 4 |
| 1970 | 4 |
| 1971 | 2 |
| 1972 | 9 |
| 1974 | 3 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 3 |
| 1979 | 4 |
| 1980 | 1 |
| 1982 | 4 |
| 1983 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2003 | 2 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2017 | 1 |
| 2022 | 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\") = 1967
AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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") = 1967
AND c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
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 SEA68D0222Accident · Minor injuriesClosedCessna 140 · Davenport, WANTSB SEA68D0148Accident · No injuriesClosedCessna 140 · Seattle, WANTSB SEA68F0116Accident · Minor injuriesClosedErco 415-C · Pt.Townsend, WANTSB SEA68D0134Accident · Minor injuriesClosedCessna 120 · Seattle, WANTSB SEA68D0003Accident · No injuriesClosedErco 415-C · Walla Walla, WANTSB SEA67D0241Accident · No injuriesClosedCessna 140 · Starbuck, WANTSB SEA67D0284Accident · No injuriesClosedCessna 140 · Bothell, WANTSB SEA67D0283Accident · No injuriesClosedCessna 140 · Redmond, WA