NTSB investigations: Bombardier ROTAX (ALL), ID
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
| 1991 | 1 |
|---|---|
| 1999 | 1 |
| 2002 | 1 |
| 2004 | 3 |
| 2006 | 1 |
| 2009 | 3 |
| 2011 | 2 |
| 2016 | 2 |
| 2021 | 1 |
| 2023 | 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\" = 'ID' 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" = 'ID' 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 WPR25LA210Accident · No injuriesClass 3 · LimitedPreliminary reportHibbard Rick Rans S7 · Blackfoot, IDOn July 12, 2025, about 2015 mountain daylight time, an experimental amateur-built Rans S7 airplane, N69TY, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was not injured. The airplane was operated as a Title 14…NTSB WPR23LA144Accident · No injuriesClass 4 · LimitedFinal reportKeskimaki Charles A Kitfox · Rigby, IDThe pilot receiving instruction’s failure to maintain directional control during landing and the flight instructor’s delayed remedial action.NTSB WPR22LA014Accident · No injuriesClass 3 · LimitedFinal reportAvid Mark IV · Payette, IDA total loss of engine power during cruise flight due to fuel starvation. Contributing to the accident was the lack of an outlet screen on the fuel system header tank.NTSB GAA16CA522Accident · No injuriesData collectionFinal reportDieterich Robert A AIR CAM · McCall, IDThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear wheel separating from the airplane, followed by an aborted landing, and a subsequent ground loop during the follow-on landing.NTSB GAA16CA136Accident · No injuriesData collectionFinal reportFox AL KIT FOX Model · Slate Creek, IDThe left main landing gear forward gear tube collapsed during the landing roll.NTSB WPR11CA323Accident · No injuriesData collectionFinal reportTL Ultralight Sro Stingsport · Soda Springs, IDThe pilot's improper landing flare and failure to maintain directional control during the landing.NTSB WPR11CA088Accident · No injuriesData collectionFinal reportFerkin Kitfox IV · Homedale, IDThe pilot's inadequate compensation for the snow-covered terrain during the takeoff ground roll, which resulted in a nose-over.NTSB WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.NTSB WPR09CA225Accident · No injuriesData collectionFinal reportRans S-7 · Atomic City, IDA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB WPR09CA181Accident · No injuriesData collectionFinal reportMax A Boesiger Jr Pulsar · Riddle, IDA loss of engine power due to fuel exhaustion as a result of the pilot's becoming lost and disoriented. Contributing to the accident was fatigue, as reported by the pilot.NTSB SEA06CA089Accident · No injuriesData collectionFinal reportEly Kitfox III · Lewiston, IDFailure to maintain aircraft control during the landing roll from an aborted takeoff. Excessive use of the rudder to control the airplane, the subsequent inadvertent ground loop, and the inadequate supervision by the flight instructor were factors.NTSB SEA04CA160Accident · No injuriesData collectionFinal reportBeyers Kitfox IV · Sandpoint, IDThe pilot's failure to maintain aircraft control during the landing roll. Contributing factors were the rough grass runway, and the trees on the left side of the runway.NTSB SEA04LA120Accident · No injuriesLimited investigationFinal reportSheppard Kitfox IV · Rigby, IDFailure to maintain directional control during the landing roll. Factors include muddy terrain.NTSB SEA04LA074Accident · 1 fatalLimited investigationFinal reportSchramm Helicycle · Montour, IDIn flight collision with terrain for undetermined reasons.NTSB SEA02LA052Accident · No injuriesLimited investigationFinal reportSkystar Kitfox Lite Squared · Caldwell, IDThe pilot's failure to adequately compensate for the wind conditions. High and gusting winds were a factor.NTSB SEA99LA099Accident · Minor injuriesLimited investigationFinal reportWhithington Kitfox 1200 · Caldwell, IDThe pilot's failure to maintain clearance from obstacles along his departure path. Factors include the pilot's incorrect positioning of the flaps prior to takeoff, and a transmission wire and trees along the aircraft's flight path.NTSB SEA91LA174Accident · No injuriesLimited investigationFinal reportSchrader, Edward A · Nampa, IDA loss of engine power for undetermined reasons.