Fatal NTSB investigations: Bombardier ROTAX (ALL), 2011

8 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), 2011 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\") = 2011
    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 ERA12FA107Accident · 1 fatalField investigationFinal reportShaw Douglas Wayne Rans S 7 · Somerville, TNThe pilot's incapacitation due to a ruptured berry aneurysm during takeoff.Dec 11, 2011 · N347DS · Substantial damageNTSB WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…Oct 4, 2011 · N91BV · Substantial damageNTSB CEN11LA623Accident · 1 fatalLimited investigationFinal reportHoffmann HK36R Super Dimona · Winsted, MNThe pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.Sep 5, 2011 · N63RK · Substantial damageNTSB ERA11FA463Accident · 1 fatalField investigationFinal reportQuad City Ultralight Challenger II · Ransom Township, PAThe non-certificated pilot's failure to maintain aircraft control while maneuvering, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot's lack of overall flight experience and lack of experience in the same make…Aug 17, 2011 · N6613Z · Substantial damageNTSB CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.Jul 9, 2011 · N3266R · Substantial damageNTSB CEN11FA319Accident · 1 fatalField investigationFinal reportThomas Europa · Shreveport, LAThe loss of aircraft control and subsequent impact with terrain for undetermined reasons.May 4, 2011 · N914KM · Substantial damageNTSB CEN11FA312Accident · 1 fatalField investigationFinal reportCombs Earl W Kitfox Speedster · Elephant Butte, NMThe pilot's loss of control of the airplane for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.May 1, 2011 · N89MM · DestroyedNTSB WPR11LA183Accident · 1 fatalLimited investigationFinal reportTomei S12 XL · Pleasant Grove, CAThe pilot’s failure to allow the airplane’s engine to properly warm up before applying takeoff power, which resulted in the forward cylinder's piston seizing and a subsequent loss of engine power. Also causal was the pilot's failure to maintain an adequate…Apr 3, 2011 · N8113N · Substantial damage