OpenAirDocs.org

Fatal NTSB investigations: Bombardier ROTAX (ALL)

13 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Airframe/component/system failure/malfunction”. 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

Where

Open the map

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 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')
      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\" = 130))
  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 ATL07LA054Accident · 1 fatalLimited investigationFinal reportJames Walter Hornet · Talbotton, GAThe failure of the right main fuel line, resulting in fuel starvation and a loss of engine power.Mar 18, 2007 · N7XS · Substantial damageNTSB NYC02LA184Accident · 1 fatalLimited investigationFinal reportGraham Mini-500 · Renfrew, PAFailure of the main transmission.Sep 7, 2002 · N373TG · Substantial damageNTSB MIA97LA120Accident · 1 fatalLimited investigationFinal reportBasinski Kolb MK3 · Winter Haven, FLfailure of the pilot to maintain airspeed after an oil leak occurred, which resulted in an inadvertent stall/spin and subsequent collision with a residence and the terrain. The oil leak and the pilot's diverted attention were related factors.Apr 8, 1997 · N128BB · Substantial damageNTSB LAX96LA258Accident · 1 fatalLimited investigationFinal reportDavis Challenger I CW · Paso Robles, CAthe owner/builder/pilot's impairment of judgment and performance due to drugs which led to his improper handling of the airplane and failure to maintain an adequate airspeed margin above stall speed, resulting in an inadvertent stall/spin. A factor which…Jul 2, 1996 · N75489 · DestroyedNTSB LAX90DVM03Accident · 1 fatalFinal reportIlli Thunder Gull · Calif Valley, CAPoor judgement of the pilot from use of a drug (cocaine), and the pilot allowing the design stress limits of the aircraft to be exceeded, while maneuvering, which resulted in overload failure of the wing spar & wing separation.Aug 8, 1990 · N2223E · DestroyedNTSB NYC90FHD01Accident · 1 fatalFinal reportMason Hummel Bird · Lumberton, NJFailure of the rudder attach bolt, which resulted in a loss of aircraft control and an uncontrolled descent to the ground.Jun 10, 1990 · N51L · DestroyedNTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…Sep 21, 1988 · N7015C · DestroyedNTSB MIA88FA213Accident · 2 fatalField investigationFinal reportFranklin Drifter XP-503 · Lake Wales, FLThe owner rprtd the plt flew the acft at a company picnic without authorization. Company psnl saw the experimental, amateur built acft takeoff from the company strip, then maneuver for a low pass over the area at about 150 to 200 ft AGL. Some estimated the…Jul 4, 1988 · N65DF · DestroyedNTSB MKC88DCQ01Accident · 1 fatalFinal reportFlagg Star Lite · Ft. Scott, KSThe failure of the main spars at the attachment points inside the fuselage.Jan 1, 1988 · N87LF · DestroyedNTSB MIA87FA003Accident · 1 fatalField investigationFinal reportGriffin STAR-LITE · Raymond, MSThe plt had just completed building the acft and was on the initial flt. Family members watched as the acft tookoff and climbed over the arpt. They then observed pieces falling from the acft. The acft rolled inverted and crashed. An exam of the elevator bell…Oct 5, 1986 · N124PK · DestroyedNTSB LAX86FUM02Accident · 1 fatalFinal reportStar-Lite UNK · Ramona, CADuring a local test flight of an experimental homebuilt acft, the plt was circling aprx 700 ft AGL when the right wing separated from the fuselage. The acft entered an uncontrollable steep angle dive and collided with the terrain. Inspection as to the…Aug 23, 1986 · N42TJ · DestroyedNTSB LAX85FA066Accident · 1 fatalField investigationFinal reportBarry Zielinski SNS 8 Hiperlt · Corona, CAN5303U, owned & operated by the amateur acft builder sustained an inflt structual failure of the lt bottom wing & crashed 6 mi east of Corona, CA. The ultralight type acft was destroyed and the plt fatally injured. Investigation revealed that wing spar…Dec 11, 1984 · N5303U · DestroyedNTSB CHI84FA290Accident · 1 fatalField investigationFinal reportJerry D. Fish Drifter · Columbus, INDuring flt, the plt was performing aerobatics & did a series of loops. While maneuvering, the left wing folded upward & the acft, an experimental ultralight, entered a descent & crashed. An exam revealed that the left wing had folded over the eng. Evidence…Jul 13, 1984 · N5150J · Destroyed