NTSB investigations: Bombardier ROTAX (ALL), 2006

7 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence was “Loss of engine power”. 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
NTSB investigations: Bombardier ROTAX (ALL), 2006 per year, 1984–2026: 99 cases
19842
19861
19872
19892
19902
19923
19936
19943
19953
19964
19977
19986
19995
20004
200113
200211
20033
20043
20055
20067
20077

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\") = 2006
    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\" = 350))
  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 SEA07LA040Accident · 1 fatalLimited investigationFinal reportTessier Avid Flyer · Hillsboro, ORThe loss of engine power during maneuvering flight due to carburetor icing, and inadvertent flight into instrument meteorological conditions. Factors were the ambient weather conditions conducive to carburetor icing and fog.Dec 30, 2006 · N93TT · Substantial damageNTSB CHI07CA007Accident · No injuriesData collectionFinal reportSteinbaum Kitfox IV · Proctorville, OHThe blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.Oct 10, 2006 · N5103R · Substantial damageNTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.Oct 6, 2006 · N134U · DestroyedNTSB ANC06LA086Accident · Serious injuriesLimited investigationFinal reportStorm Zenair CH-701 · Fairbanks, AKThe total loss of engine power for an undetermined reason during cruise flight, which resulted in an emergency descent into trees.Jul 9, 2006 · N4233J · Substantial damageNTSB NYC06LA157Accident · Serious injuriesLimited investigationFinal reportWorcester Everett Renegade II · Orneville, MEA loss of engine power for an undetermined reason.Jun 24, 2006 · N536N · DestroyedNTSB MIA06LA116Accident · No injuriesLimited investigationFinal reportTecnam P92 Super Echo · Sebring, FLThe loss of engine power for undetermined reasons resulting in a forced landing and collision with a fence.May 25, 2006 · N929HA · Substantial damageNTSB CHI06CA102Accident · No injuriesData collectionFinal reportMartin Rans S-7 Courier · Ray, MIThe loss of engine power and fire for undetermined reasons.Mar 29, 2006 · N22220 · Destroyed