NTSB investigations: Continental IO-550 series

58 cases on aircraft whose registry engine model is Continental IO-550 series, where the defining event was Loss of control in flight. 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, newest first

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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
  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 WPR09FA347Accident · 3 fatalField investigationFinal reportRaytheon G36 · Hawthorne, CAThe pilot’s failure to maintain an adequate airspeed during a go-around, which resulted in a loss of airplane control. Contributing to the accident was the inadvertent activation of the fuel boost pump during the attempted go-around.Jul 15, 2009 · N618MW · Substantial damageNTSB CEN09FA363Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Crystal, MNThe pilot's failure to maintain airspeed which resulted in a loss of aircraft control during a go-around. Factors associated with the accident were the dark night lighting conditions, moderate to heavy rain, and fatigue.Jun 17, 2009 · N214BN · DestroyedNTSB CEN09WA033Accident · 2 fatalForeign investigationCirrus Design SR22 · Zurich, SwitzerlandUnder the jurisdiction and control of the Swiss Government.Oct 22, 2008 · N467BD · DestroyedNTSB LAX08LA253Accident · 2 fatalLimited investigationFinal reportLong Lancair ES · Cliffdell, WAThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident was turbulence and clouds.Aug 1, 2008 · N45EL · DestroyedNTSB CHI08FA224Accident · 2 fatalField investigationFinal reportMoser Georg Lancair Legacy FG · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall and subsequent loss of control.Jul 31, 2008 · N515RB · Substantial damageNTSB LAX08CA173Accident · Minor injuriesData collectionFinal reportBeech A36 · Ryegate, MTThe pilot's failure to abort the takeoff when the ground roll acceleration profile was determined to be insufficient for takeoff. Contributing to the accident was the shifting wind conditions.Jun 26, 2008 · N824C · Substantial damageNTSB LAX08CA189Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot's failure to attain and maintain an adequate airspeed during a go around, that resulted in a stall/mush. Contributing to the accident was the tailwind condition.Jun 24, 2008 · N877CM · Substantial damageNTSB CHI08FA066Accident · 1 fatalField investigationFinal reportHawker Beechcraft 58 · Cleveland, OHThe pilot experienced spatial disorientation during the inital climb causing him to lose control of the airplane.Jan 17, 2008 · N3217L · Substantial damage