NTSB investigations: Continental IO-550 series
12 cases on aircraft whose registry engine model is Continental IO-550 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
| 1994 | 1 |
|---|---|
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 1 |
Where
Open the mapLatest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042')
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042')
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 ATL07LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Brunswick, GAThe pilot's failure to activate the electric fuel pump following a loss of engine power for undetermined reasons.NTSB CHI06LA243Accident · 1 fatalLimited investigationFinal reportFrick Questair Q20 · Big Rapids, MIThe pilot's failure to ensure an adequate fuel supply, which resulted in the exhaustion of the fuel supply and the subsequent loss of engine power. The trees that the airplane struck during the forced landing were a factor.NTSB DFW06LA071Accident · Serious injuriesLimited investigationFinal reportHodge Express · Tyler, TXA loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA05CA143Accident · No injuriesData collectionFinal reportBeech A36 · Sequim, WAThe temporary loss of engine power for an undetermined reason during the takeoff initial climb.NTSB DFW05LA115Accident · No injuriesLimited investigationFinal reportLancair Legacy · Nacogdoches, TXThe loss of engine power for undetermined reasons.NTSB FTW04LA092Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Conroe, TXThe loss of engine power due to the improper fuel type. Contributing factors were the improper aircraft servicing, lack of training by the fixed base operator, and the low cloud ceiling.NTSB FTW04LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20R · Sheridan, ARThe loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel tank selector. A factor was the lack of suitable terrain for the forced landing.NTSB ATL04LA060Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · King, NCA loss of engine power for undetermined reasons and the pilot's failure to maintain a visual lookout and obstacle clearance while performing a simulated engine out resulting in an in-flight-collision with a power line and the ground.NTSB CHI02LA258Accident · No injuriesLimited investigationFinal reportBeech A36 · Benton, KSFuel starvation due to the pilot's improper fuel management, the pilot's improper remedial actions during engine restart, and the unsuitable terrain encountered during the forced landing. Additional factors included the inadequate flare and the dark night.NTSB CHI01LA140Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Gaylord, MIthe pilot not maintaining directional control during the reported loss of number one engine power during initial climb and the pilot not following the airplane emergency procedure's corrective action for engine failure after lift-off, and the inadvertent…NTSB LAX01LA012Accident · Minor injuriesLimited investigationFinal reportTolle Venture Model 20 · Madera, CAThe mechanical failure of a fuel sump tank check valve, during takeoff initial climb, that resulted in fuel starvation.NTSB ATL95FA012Accident · Serious injuriesField investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate management of the fuel supply which resulted in fuel exhaustion and a complete loss of engine power.