NTSB investigations: Continental IO-520 series, 2005
13 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\") = 2005
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") = 2005
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 LAX06FA075Accident · 3 fatalField investigationFinal reportBeech V35A · Valley Center, CAthe pilot's failure to maintain an adequate airspeed margin following a loss of engine power in the takeoff initial climb, resulting in a stall/spin. While the laboratory tests indicated the presence of an unknown biological contaminant in the fuel manifold…NTSB DFW06LA040Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Columbus, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06CA004Accident · No injuriesData collectionFinal reportBeech F33A · Millington, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation. A factor in the accident was the pilot's failure to maintain airspeed and misjudged distance to the forced landing area resulting in a stall and collision…NTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.NTSB DFW05LA215Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Joiner, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA05FA130Accident · 1 fatalField investigationFinal reportBeech V35 · De Funiak Sprgs, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and an in-flight collision with tress and terrain.NTSB SEA05FA136Accident · 2 fatalField investigationFinal reportBeech E-55 · Lopez, WAThe pilot's failure to refuel the airplane which resulted in a dual loss of engine power during normal descent due to fuel exhaustion. A contributing factor was the incorrect installation of the left and right wing fuel sight gage/float assemblies by unknown…NTSB DFW05LA165Accident · Minor injuriesLimited investigationFinal reportCessna 401A · Houston, TXThe loss of engine power to both engines due to fuel starvation as a result of the pilot's improper fuel management. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ANC05LA079Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Stony River, AKA partially blocked fuel pump, which resulted in a loss of engine power while in cruise flight. A factor associated with the accident was an inoperative electric auxiliary fuel pump.NTSB SEA05LA110Accident · No injuriesLimited investigationFinal reportBeech A-36 · Tacoma, WAThe malfunction of the fuel injection control system, for undetermined reasons, while the aircraft was on base leg for a full-stop landing. Factors include soft terrain in the area where the pilot found it necessary to perform a forced landing.NTSB DFW05LA105Accident · No injuriesLimited investigationFinal reportBeech A36 · Early, TXA loss of engine power due to the improper installation of the oil filter resulting in oil starvation and eventual seizure of the engine. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA05FA061Accident · Serious injuriesField investigationFinal reportNavion Navion H · Hubbard, ORThe total loss of engine power immediately after takeoff for undetermined reason.NTSB NYC05FA048Accident · 1 fatalField investigationFinal reportBeech V35B · Norwich, NYA loss of engine power for undetermined reasons.