NTSB investigations: Continental TSIO-520 series, 1982, MI
3 cases on aircraft whose registry engine model is Continental TSIO-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
| 1966 | 1 |
|---|---|
| 1974 | 2 |
| 1979 | 1 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 3 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 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\") = 1982
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 ('17040'))
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") = 1982
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 ('17040'))
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 CHI83LA061Accident · No injuriesLimited investigationFinal reportCessna 310R · Gaylord, MIPrior to a flight from charleston, WV to sault ste marie, MI, the pilot was briefed to expect icing conditions. During the flight, mixed and rime icing conditions were encountered; however, the deicing equipment removed it satisfactorily. An update weather…NTSB CHI83LA008Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Sparta, MIWitnesses observed a normal climb out, but as the acft cleared trees the plt began jettisoning the load. The plt stated that about 1/2 mi from the departure end of rwy 6 the acft seemed to mush & then descend into the trees. The wind at grand rapids, 20 mi…NTSB CHI82DA056Accident · No injuriesFinal reportCessna 340A · Near Lansing, MIDuring flight over lake Michigan at 13,000 feet, the pilot noticed that the throttle, mixture and propeller controls to one of the engines began binding. The controls to the other engine remained normal. He descended to 9000 feet and continued at reduced…