NTSB investigations: Continental IO-520 series, 1983, MI
5 cases on aircraft whose registry engine model is Continental IO-520 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
| 1965 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 6 |
| 1968 | 5 |
| 1969 | 1 |
| 1970 | 3 |
| 1971 | 4 |
| 1972 | 1 |
| 1974 | 3 |
| 1975 | 4 |
| 1976 | 7 |
| 1977 | 1 |
| 1978 | 4 |
| 1979 | 2 |
| 1980 | 3 |
| 1981 | 4 |
| 1982 | 2 |
| 1983 | 5 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 5 |
| 1987 | 2 |
| 1989 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2017 | 1 |
| 2019 | 3 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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 ('17032'))
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 ('17032'))
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 CHI84LA056Accident · No injuriesLimited investigationFinal reportCessna A185F · Bad Axe, MIDuring arrival, the plt was advised by the UNICOM operator that rwy 21 was the active rwy. Soon after landing, a passenger boarded the acft & the plt took off again. He proceeded to make a pattern around the arpt & initiated another landing on rwy 21. The…NTSB CHI84LA029Accident · No injuriesLimited investigationFinal reportCessna U206G · South Fox Isl., MIThe acft collided with a mound alongside the rwy during landing. The rwy is 3500 ft long turf strip with a 20 degree dogleg 1500 ft from the north end. There is a small hill running along both sides of the rwy. The grass rwy was wet and theacft slid sideways.…NTSB CHI83LA212Accident · No injuriesLimited investigationFinal reportCessna A185F · Eaton Rapids, MIThe acft nosed over during landing at the plt's private strip the plt stated that he took off for a 15 minute local flt and during landing he touched down in a soft area. The wheels bogged in and the acft nosed over. He had taken off to thenorth and landed to…NTSB CHI83LA195Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Gaylord, MIThe acft nosed over immediately upon landing on a turf rwy. An inspection of the rwy revealed two skid marks in the turf about 75 ft long and 900 ft from the approach end of rwy 36.NTSB CHI83LA117Accident · No injuriesLimited investigationFinal reportBeech 58 · Detroit, MIDuring arrival, the plt received vectors for an ILS approach. He elected to make a localizer only approach. At the outer marker, the acft was aprx 200 ft above the minimum altitude & above the approach speed. The plt reported that he reduced the airspeed…