NTSB investigations: Bombardier ROTAX (ALL), UT
17 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
| 1983 | 1 |
|---|---|
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2015 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
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.
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."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA'
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB WPR22LA052Accident · No injuriesClass 4 · LimitedFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Fairfield, UTThe pilot's failure to maintain directional control during takeoff with a right crosswind.NTSB WPR20LA116Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hurricane, UTA total loss of engine power due to the failure of the ignition system as a result of foreign object damage.NTSB GAA15CA257Accident · No injuriesData collectionFinal reportGlenn Timothy C Skystar Series 5 · Green River, UTThe pilot's failure to maintain pitch attitude, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB GAA15CA029Accident · No injuriesData collectionFinal reportKerr John A Kitfox Classic IV · Logan, UTThe pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, and a loss of engine power en route.NTSB WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…NTSB WPR10CA269Accident · No injuriesData collectionFinal reportBagley Curtis Lynn Rans S-6S Coyote II · Koosharem, UTThe pilot's failure to maintain clearance from a sign on the side of his landing area (a dirt road). Contributing to the accident was the pilot's failure to perform a fly-by of the road to check for hazards.NTSB SEA07LA188Accident · Minor injuriesLimited investigationFinal reportVance Renegade Spirit · Blanding, UTThe loss of engine power during cruise due to oil starvation.NTSB SEA06LA175Accident · Serious injuriesLimited investigationFinal reportStraw T-Bird II · Leamington, UTThe pilot's loss of aircraft control (control not possible) due to the failure of the left elevator control surface which was the result of a missing inboard bolt (for undetermined reason) which holds the left elevator bow in place.NTSB DEN03LA121Accident · Serious injuriesLimited investigationFinal reportPringle Rans S-7 Courer · Manti, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Low altitude flight and high density altitude are contributing factors.NTSB DEN03LA104Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Eureka, UTthe pilot's improper in-flight planning and failure to maintain aircraft control. Contributing factors include high density altitude, hilly terrain, low airspeed and the subsequent inadvertent stall/mush.NTSB DEN02LA109Accident · 2 fatalLimited investigationFinal reportSabian Rans S-12XL · Mexican Hat, UTthe pilot's inadequate in-flight planning and decision making (flying up a canyon with insufficient altitude) which resulted in an inadvertent stall/mush, and the pilot's failure to follow the proper emergency procedures for activating his Ballistic Recovery…NTSB DEN01LA085Accident · Minor injuriesLimited investigationFinal reportBoyd Young Kolb Mark III · Brigham City, UTthe pilot's misjudged landing flare, which resulted in a hard landing. A factor was the propeller tip separation due to foreign object damage.NTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.NTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…NTSB SEA96LA152Accident · No injuriesLimited investigationFinal reportHanks Avid Flyer · Spanish Fork, UTpartial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.NTSB DEN83FTM07Accident · Minor injuriesFinal reportWormley Wizard/T-38 · Spanish Fork, UTThe acft collided with the ground after a stall at about 75 ft afl during takeoff. The pilot stated that he took off on runway 30 after a ground roll of about 200 ft, started to climb, and at about 75 ft noticed he was flying too slow, he felt a buffet and…