NTSB investigations: Continental IO-520 series, 1997
9 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of engine power”. 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 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 6 |
| 1985 | 6 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 9 |
| 1999 | 10 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 7 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 13 |
| 2006 | 7 |
| 2007 | 11 |
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\") = 1997
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\" = 350))
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") = 1997
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" = 350))
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 FTW98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Fruita, COThe total loss of engine power for undetermined reasons .NTSB FTW97LA338Accident · No injuriesLimited investigationFinal reportBeech V35B · Saguache, CO**This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…NTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB CHI97LA210Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNloss of engine power for undetermined reason(s). A factor relating to the accident was: the wet/soft terrain in the emergency landing area.NTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..NTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.NTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.NTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB MIA97LA083Accident · No injuriesLimited investigationFinal reportCessna 210L · Weston, FLa loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.