Fatal NTSB investigations: Bombardier ROTAX (ALL), 1995

5 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), 1995 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\") = 1995
    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 MIA96LA042Accident · 2 fatalLimited investigationFinal reportOtis King COBRA-B · Newberry, FLan in-flight loss of control for undetermined reasons.Dec 16, 1995 · N102DJ · Substantial damageNTSB MIA96LA004Accident · 1 fatalLimited investigationFinal reportLouks Pulsar XP · Inverness, FLPremature rotation by the pilot during takeoff, which resulted in an inadvertent stall/mush, while attempting to accelerate in ground effect after lift-off.Oct 7, 1995 · N912XL · Substantial damageNTSB SEA96LA001Accident · 1 fatalLimited investigationFinal reportRasmussen Kitfox 2 · Battle Ground, WAfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall/mush and subsequent collision with trees and the ground.Oct 1, 1995 · N488WR · DestroyedNTSB FTW95LA285Accident · 2 fatalLimited investigationFinal reportMeyer Pulsar XP · Spring Branch, TXThe pilot's improper positioning of the fuel tank selector and his failure to maintain airspeed. A factor was the pilot's diverted attention to the power loss.Jul 10, 1995 · N912XP · DestroyedNTSB FTW95LA257Accident · 1 fatalLimited investigationFinal reportRocky Mountain Buccaneer 11 B2B · Longmont, COThe pilot's failure to maintain flying speed, resulting in an inadvertent stall while attempting to make a forced landing. Factors were the pilot's lack of total experience in airplane make/model, improper maintenance of the airplane, and operation of the…Jun 23, 1995 · N4093F · Destroyed