OpenAirDocs.org

Fatal NTSB investigations: Continental IO-550 series, 2003

7 cases on aircraft whose registry engine model is Continental IO-550 series. 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

19912026

Where

Open the map

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\") = 2003
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17042'))
  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.

NTSB ATL04WA042Accident · 4 fatalForeign investigationCirrus Design SR-22 · Pamplona, SpainOct 12, 2003 · N100BR · Substantial damageNTSB LAX03LA275Accident · 2 fatalLimited investigationFinal reportBacon Questair #20 Venture · Carefree, AZThe pilot's misjudgment of speed/distance and his failure to do a go-around. Also causal was the pilot's failure to maintain directional control, and his delay aborting the landing.Sep 2, 2003 · N29G · DestroyedNTSB ATL03LA094Accident · 4 fatalLimited investigationFinal reportKerner Lancair IV · Allendale, SCThe pilot's inadvertent flight into adverse weather ,thunderstorms, that resulted in the design limits of the airplane being exceeded.May 16, 2003 · N29ME · DestroyedNTSB IAD03FA050Accident · 2 fatalField investigationFinal reportBeech A36 · Jackson, OHThe flight instructor's improper decision to turn back to the airport at an insufficient altitude after takeoff and his failure to maintain adequate airspeed, during a simulated engine failure.Apr 26, 2003 · N523BL · Substantial damageNTSB LAX03FA135Accident · 3 fatalField investigationFinal reportBeech A36 · Sedona, AZa partial loss of engine power due to the certified flight instructor's failure to comply with the pilot operating handbook requirements for the mixture setting during takeoff. Also causal was the instructor's inadequate supervision of the flight, failure to…Apr 13, 2003 · N323D · DestroyedNTSB IAD03FA039Accident · 1 fatalField investigationFinal reportMooney M20R · Leesburg, VAThe pilot's failure to maintain control of the airplane while on final approach for undetermined reasons.Mar 21, 2003 · N1005P · DestroyedNTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…Jan 18, 2003 · N9523P · Destroyed