NTSB investigations: Continental C85 series, 1987, WI
2 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 | 2 |
| 1966 | 4 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 3 |
| 1971 | 3 |
| 1972 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 2 |
| 1992 | 3 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 3 |
| 2003 | 2 |
| 2004 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
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\") = 1987
AND c.\"eventStateOrRegion\" = 'WI' 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") = 1987
AND c."eventStateOrRegion" = 'WI' 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 CHI87FA185Accident · Serious injuriesField investigationFinal reportCessna 120 · Oshkosh, WIThe plt was taxiing out of the antique/classic camping area at Oshkosh with the assistance of wing walkers when he stopped to permit the pax (his wife) to perform an errand. The pax deplaned & went under the outer 1/3 of the wing strut, then walked back into…NTSB CHI87LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Dodgeville, WIWhile landing on runway 30, the pilot reported that the wind shifted from a crosswind to a tailwind. During an attempted go-around the pilot lost directional control and struck a metal utility shed prior to impacting the ground.