NTSB investigations: Bombardier ROTAX (ALL), 1995

8 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence 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 per year

19832026
NTSB investigations: Bombardier ROTAX (ALL), 1995 per year, 1983–2026: 124 cases
19832
19841
19851
19861
19873
19883
19893
19903
19915
19928
19932
19943
19958
19964
19974
199814
199912
20005
200112
200210
20037
20044
20054
20062
20073

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('09050')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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 CHI95LA214Accident · Minor injuriesLimited investigationFinal reportAvid Flyer · Auburn, KSthe pilot operating the airplane with known deficiencies. Factors included lack of recent flight experience, inadequate maintenance, and low airspeed.Jul 9, 1995 · N8031M · Substantial damageNTSB CHI95LA144Accident · No injuriesLimited investigationFinal reportQuad City Challenger · Bridgeport, MIInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.May 2, 1995 · N100GB · DestroyedNTSB ATL95LA083Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Super GT 400 · Pleasant Hill, TNThe pilot's inadequate compensation for wind conditions, and his failure to maintain aircraft control during the initial climb. Factors were the crosswind conditions, the perimeter trees, and the pilot's lack of total flying experience.Apr 15, 1995 · N12SK · Substantial damageNTSB ATL95LA067Accident · No injuriesLimited investigationFinal reportWente Kitfox III · Moncks Corner, SCThe pilot's selection of the wrong runway relative to the wind conditions and his failure to maintain alignment with the runway during the balked landing.Mar 19, 1995 · N803BW · Substantial damageNTSB FTW95LA132Accident · Minor injuriesLimited investigationFinal reportSchmanski Kitfox III · Greeley, COThe pilot's inadequate compensation for wind conditions. A factor was a sudden wind shift.Mar 4, 1995 · N951BW · Destroyed