NTSB investigations: Continental IO-520 series, 1984, WI
2 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 |
|---|---|
| 1974 | 2 |
| 1975 | 2 |
| 1977 | 3 |
| 1978 | 2 |
| 1979 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1996 | 1 |
| 1998 | 3 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2025 | 2 |
| 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\") = 1984
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 ('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") = 1984
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 ('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 CHI85LA090Accident · No injuriesLimited investigationFinal reportBeech 58 · Hayward, WIThe acft sustained subst damage after uncontrolled contact with the rwy during landing. Investigation revealed that the landing was inadvertently attempted at a time when the winds shifted to a direct x-wind with gusts to 35 KTS.NTSB CHI84LA146Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Delavan, WIThe plt reported that when he was descending from 3500 ft MSL to traffic pattern alt (2000 ft MSL), he switched the fuel selector from the left fuel tank to the right tank. Upon entering the traffic pattern, he made his prelanding checks. When he advanced the…