Fatal NTSB investigations: Bombardier ROTAX (ALL), 2010

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), 2010 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\") = 2010
    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 CEN11LA050Accident · 1 fatalLimited investigationFinal reportMcfarland Bill Challenger II · Praire Du Sac, WIThe separation of the fuselage-mounted wing strut attachment fitting for an undetermined reason, which resulted in the separation of the left wing of the airplane.Nov 1, 2010 · N448WM · Substantial damageNTSB CEN11LA012Accident · 1 fatalLimited investigationFinal reportNewmann Edward W Challenger II · Easton, KSThe pilot’s failure to maintain control of the airplane for undetermined reasons.Oct 8, 2010 · N61328 · Substantial damageNTSB WPR10FA388Accident · 1 fatalField investigationFinal reportDiamond HK36 · Bend, ORAn condition, which could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation, that prompted the pilot to discontinue the flight. Contributing to the accident…Aug 8, 2010 · N40440 · Substantial damageNTSB ERA10LA391Accident · 1 fatalLimited investigationFinal reportTurck G L/Duflo J T SEA REY · Winter Haven, FLThe pilot's failure to maintain adequate airspeed on approach for landing, resulting in an inadvertent stall/spin and collision with water.Aug 2, 2010 · N914SR · Substantial damageNTSB ERA10LA373Accident · 2 fatalLimited investigationFinal reportNadig Paul K Nadig · Franklin, PAA partial loss of engine power due to the owner’s inadequate fuel system maintenance, which resulted in a collision with trees and subsequent impact with the ground.Jul 24, 2010 · N579PN · Substantial damageNTSB CEN10LA334Accident · 1 fatalLimited investigationFinal reportDrone Paul E Pulsar III · Carmi, ILThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an aerodynamic stall and impact with terrain.Jun 21, 2010 · N47PD · Substantial damageNTSB CEN10LA165Accident · 1 fatalLimited investigationFinal reportWalsh Philip J SEA REY · Huntsville, ARThe pilot's loss of airplane control for undetermined reasons.Mar 18, 2010 · N100JW · Substantial damageNTSB CEN10LA099Accident · 2 fatalLimited investigationFinal reportBuckeye DM · Sublette, KSThe failure of both pilots to see and avoid the other aircraft, which resulted in a midair collision while maneuvering at low altitude.Jan 17, 2010 · N582DW · 2 aircraft · Substantial damage