NTSB investigations: Continental IO-520 series, 1986, 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\") = 1986
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") = 1986
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 CHI86LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grosse Ile, MIThe pilot stated that he had a habit of landing left of the centerline. While landing with a right crosswind, the aircraft drifted to the left and the left wing struck three construction sawhorses, placed off the left side of the runway.NTSB CHI86FEM07Accident · No injuriesFinal reportCessna 188B · Bay City, MIDuring an ag spray operation, the plt flew over the area before starting his swath runs. On his first run, he flew over wires at the end of the field. On the return swath run, he attempted to fly under the wires. While doing so, the acft struck a newly…NTSB CHI86FEC03Accident · No injuriesFinal reportCessna U-206B · Tecumseh, MIThe acft collided with terrain following a landing on rwy 18. According to the plt, a gust of wind lifted the right wing of the acft during roll out. The propeller then struck the ground and the acft rocked back onto the right wing.NTSB CHI86FA102Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Frankfort, MIThe plt was taking off from his local arpt and local residents described conditions of 100 ft vis in heavy ground fog. After lift-off he began a left turn toward a 300 ft high ridge topped by 100 ft trees. The acft struck the tree tops, the plt lost control…NTSB CHI86LA091Accident · No injuriesLimited investigationFinal reportCessna 210M · While Lake Twp., MIThe acft was four miles from the arpt on an ILS apch when an eng failure was experienced. The acft was damaged during the forced landing on a frozen lake. Post accident eng teardown revealed the eng failure originated from movement of the #2 main bearing.…