NTSB investigations: Continental IO-550 series
10 cases on aircraft whose registry engine model is Continental IO-550 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1998 | 1 |
|---|---|
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2007 | 2 |
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\" = 351))
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" = 351))
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 SEA08LA033Accident · No injuriesLimited investigationFinal reportBeech A36 · El Centro, CAThe failure of maintenance personnel to properly secure the #2 cylinder through bolts. A contributing factor was the lack of suitable terrain for landing.NTSB DEN07LA133Accident · Serious injuriesLimited investigationFinal reportWalker Lancair IV · Sylvan Grove, KSA catastrophic engine failure due to oil starvation when an oil line to the turbocharger wastegate actuator came loose. Contributing factors in this accident were the unsuitable terrain on which to make a forced landing.NTSB CHI04FA203Accident · 1 fatalField investigationFinal reportKnoepflein Lancair Legacy 2000 · Madison, WIA loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…NTSB CHI04LA187Accident · No injuriesLimited investigationFinal reportBeech A36 · Algona, IAThe failure of the connecting rod which resulted in the loss of engine power during cruise flight and subsequent forced landing. A contributing factor was the delayed lowering of the landing gear in order to clear the other vehicle encountered during the…NTSB LAX04LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Lancaster, CAA loss of engine power due to thermal fatigue failure of the first stage turbine wheel resulting in release of a section of its rim. The thermal fatigue was due to the engine exceeding its temperature limits during one or more start cycles.NTSB MIA03LA028Accident · No injuriesLimited investigationFinal reportBeech A36 · Laurens, SCImproper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…NTSB CHI01LA255Accident · No injuriesLimited investigationFinal reportBeech A36 · Sugar Grove, ILthe inadequate maintenance inspection and the unsuitable terrain encountered by the pilot mechanic. The fuel system leak was a contributing factor.NTSB CHI01FA220Accident · 1 fatalField investigationFinal reportMooney M-20R · Eden Prairie, MNThe fractured camshaft gear and the pilot not maintaining aircraft control. Factors relating to this accident were metal fatigue in the camshaft gear teeth, the inadvertent stall, the low airspeed, and the trees.NTSB DEN01LA103Accident · Minor injuriesLimited investigationFinal reportHall Lancair 4P · Bennett, COunsuitable terrain on which to make a forced landing. A contributing factor was a fatigue fracture of the starter adapter drive shaft, which resulted in a loss of engine power due to oil starvation.NTSB NYC98LA074Accident · No injuriesLimited investigationFinal reportBeech A36 · Lynchburgh, VAFailure of the number six connecting rod bolt due to improper maintenance.