Fatal NTSB investigations: Bombardier ROTAX (ALL), 2009

9 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL). 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

19842026
Fatal NTSB investigations: Bombardier ROTAX (ALL), 2009 per year, 1984–2026: 148 cases
19842
19852
19862
19871
19884
19906
19914
19923
19933
19944
19955
19962
19976
19985
19994
20003
200112
200210
20036
20044
20054
20065
20074
20081
20099
20108
20118
20123
20131
20144
20152
20162
20171
20182
20191
20201
20231
20241
20251
20261

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\") = 2009
    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 ('09050'))
  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 CEN10LA049Accident · 1 fatalLimited investigationFinal reportLockwood AIR-CAM · Mount Victory, OHThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot's unfamiliarity with the airplane subsequent to float installation.Nov 7, 2009 · N32786 · Substantial damageNTSB CEN10LA041Accident · 2 fatalLimited investigationFinal reportWicks Air Center Hornet · Bonham, TXThe pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.Nov 7, 2009 · N651WA · DestroyedNTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.Sep 24, 2009 · N4340D · Substantial damageNTSB ERA09LA500Accident · 1 fatalLimited investigationFinal reportBlum Matthew Aventura II · Boca Raton, FLThe improper assembly of both carburetors, resulting in an excessively rich fuel to air ratio and subsequent partial loss of engine power.Sep 6, 2009 · N6301M · Substantial damageNTSB WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.Aug 19, 2009 · N35MP · Substantial damageNTSB CEN09LA312Accident · 2 fatalLimited investigationFinal reportNorthwing Design Apache Sport · Fredericksburg, TXThe loss of aircraft control for undetermined reasons.May 25, 2009 · N600GB · Substantial damageNTSB CEN09LA262Accident · 1 fatalLimited investigationFinal reportCapra, Salvatore O Aventura 2 · Des Allemands, LAThe pilot’s failure to achieve adequate altitude and airspeed before beginning a downwind turn after takeoff.Apr 22, 2009 · N912SC · Substantial damageNTSB CEN09LA255Accident · 1 fatalLimited investigationFinal reportWhitehead Titan · Slaughter, LAThe pilot's incorrect use of pitch control, resulting in induced pitch oscillations and loss of aircraft control. Contributing to the accident were the pilot's total lack of experience in aircraft make/model, and his lack of recency of experience.Apr 20, 2009 · N226BW · DestroyedNTSB ERA09LA250Accident · 1 fatalLimited investigationFinal reportGladstone Kitfox · Dubre, KYThe pilot's failure to maintain airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall.Apr 18, 2009 · N191KF · Substantial damage