NTSB investigations: Continental A&C65 series, 1983, MI
2 cases on aircraft whose registry engine model is Continental A&C65 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 | 6 |
| 1966 | 6 |
| 1967 | 5 |
| 1968 | 7 |
| 1969 | 13 |
| 1970 | 4 |
| 1971 | 3 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 6 |
| 1975 | 5 |
| 1976 | 6 |
| 1977 | 4 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 7 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 5 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 1983
AND c.\"eventStateOrRegion\" = 'MI' 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 ('17003'))
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") = 1983
AND c."eventStateOrRegion" = 'MI' 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 ('17003'))
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 CHI84LA033Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Burnips, MIReportedly, the plt had consumed 4 beers after 2200 EDT, while at the bostwick lake inn, then consumed another beer after he left the inn. At aprx 0330 EDT, he & a passenger took off from an unlit arpt. The plt stated that shortly after takeoff, he became…NTSB CHI83LA127Accident · Minor injuriesLimited investigationFinal reportAeronca Champion 7AC · Newberry, MIThe aircraft collided with a telephone pole while attempting a takeoff on skis. The snow was wet, sparse and sticky and the takeoff was being performed on a taxiway because it had more snow. This was a dual instructional flight with the student at the…