NTSB investigations: Continental IO-520 series, 1986
4 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1982 | 4 |
|---|---|
| 1983 | 9 |
| 1984 | 7 |
| 1985 | 5 |
| 1986 | 4 |
| 1987 | 7 |
| 1988 | 3 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 8 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 8 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 9 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 10 |
| 2006 | 2 |
| 2007 | 4 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 CHI87LA020Accident · No injuriesLimited investigationFinal reportCessna 310R · Belvidere, ILDuring takeoff roll, the acft door popped open at a point too late to abort the takeoff. The PIC tried to hold the door closed while the second plt flew the acft around the traffic pattern. Just prior to touchdown, the door opened wider and the PIC reached to…NTSB NYC87LA026Accident · No injuriesLimited investigationFinal reportCessna U206F · Marshfiled, MAElectrical failure occurred in flight due to an alternator belt failure. The acft landed in the grass beside the rwy and was damaged. The landing was difficult due to darkness, fog and no lights. The plt tried to use flaps but failed due to no elec power. The…NTSB MIA86LA186Accident · No injuriesLimited investigationFinal reportCessna U206F · Ft. Myers, FLThe private pilot had just completed a short no-radio night flight and during the landing roll the nose gear wheel assembly separated from the aircraft. Examination revealed that the wrong nuts had been installed on the wheel assembly at the last annual…NTSB MIA86LA104Accident · No injuriesLimited investigationFinal reportCessna 210E · Jacksonville, FLAfter departure plt selected landing gear up and did not receive a gear up indication. Another aircraft flew under the aircraft and reported the nose gear and left main gear were up and that the right main gear was partially extended. When attempts to correct…