NTSB investigations: Bombardier ROTAX (ALL)
756 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, newest first
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.\"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."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 DFW07CA190Accident · No injuriesData collectionFinal reportKitFox Series 5 · Kerrville, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB ATL07LA112Accident · Serious injuriesLimited investigationFinal reportFalcon Safety Craft Falcon XP · Montgomery, NYA total loss of engine power during initial climb for undetermined reasons.NTSB CHI07LA238Accident · 1 fatalLimited investigationFinal reportSwanson Aventura II · Lakewood, WIThe pilot's excessive pull up, his not maintaining airspeed, and the inadvertent stall resulting in the loss of control. A factor contributing to the accident was the trees.NTSB ATL07CA108Accident · No injuriesData collectionFinal reportEvektor Aerotechnic Sportstar · Shirley, NYThe student pilot's failure to maintain adequate airspeed resulting in a stall. Contributing to the accident was the student pilots failure to relinquish the flight controls when instructed to do so.NTSB DFW07LA153Accident · No injuriesLimited investigationFinal reportZenair CH701 · Huntington, PAThe loss of engine power for undetermined reasons.NTSB CHI07LA199Accident · Minor injuriesLimited investigationFinal reportHesler Zodiac CH 601 HDS · Jamestown, OHThe loss of engine power during takeoff for undetermined reasons, the pilot not performing an aborted takeoff at the initial recognition of a loss of engine performance, and the stall/mush the pilot encountered after takeoff.NTSB SEA07CA162Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus-3DM · Minden, NVThe flight's encounter with severe downdrafts during cruise flight. Contributing factors were the pilot's inadvertent selection of unsuitable terrain with hidden obstructions.NTSB ATL07LA089Accident · 1 fatalLimited investigationFinal reportGordon R Smith Sea Rey · Port St. Joe, FLThe pilot's failure to maintain a visual lookout and his improper decision to conduct a low altitude maneuver.NTSB SEA07LA188Accident · Minor injuriesLimited investigationFinal reportVance Renegade Spirit · Blanding, UTThe loss of engine power during cruise due to oil starvation.NTSB LAX07LA156Accident · 2 fatalLimited investigationFinal reportTeague Rans S-6ES Coyote II · Nyssa, ORLoss of aircraft control while maneuvering for undetermined reasons.NTSB DFW07CA098Accident · No injuriesData collectionFinal reportFlagg Kitfox IV · Centerville, TXThe loss of engine power due to the failure of the air induction ducting. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07CA116Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-A1 · Warrenton, MOThe pilot's inadequate pre-flight planning which resulted in exhaustion of the fuel supply and the unsuitable terrain encountered for the forced landing. A factor in the accident was inaccurate fuel quantity indication.NTSB ANC07LA027Accident · Serious injuriesLimited investigationFinal reportCarris Avid Aircraft · Delray, FLThe loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain adequate airspeed during an emergency descent, which resulted in an inadvertent stall and in-flight collision with terrain. A factor associated with…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.NTSB DEN07LA074Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pueblo, COThe pilot of the North American SNJ-5 warbird's inadequate visual lookout while taxiing, resulting in an on-ground collision with the stationary Grob motor glider.NTSB SEA07LA066Accident · No injuriesLimited investigationFinal reportScherer Europa · Upland, CAThe pilot's inadequate condition inspection and subsequent loss of engine power due to fuel starvation as a result of a blocked fuel filter.NTSB DEN07LA042Accident · Serious injuriesLimited investigationFinal reportMino Kitfox 3 · Canon City, COThe certificated flight instructor's failure to adequately supervise the dual student during the landing flare-touchdown, which resulted in a hard landing and a nose over. A factor associated with the accident is the dual student's improper recovery from a…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.NTSB MIA07CA030Accident · No injuriesData collectionFinal reportMorgan, Marvin R. Zenair CH701 Stol · Lithia, FLCollapse of the nosegear for undetermined reasons.NTSB 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.NTSB 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.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 DFW06CA204Accident · No injuriesData collectionFinal reportRon Burleigh Air Cam · Post, TXThe pilot's failure to maintain clearance with power lines while making a precautionary landing.NTSB DFW06CA196Accident · No injuriesData collectionFinal reportPearson Superfly · Denton, TXThe loss of control as result of the pilot's selection of an unsuitable landing area. A contributing factor was the muddy terrain.NTSB ATL06LA115Accident · 1 fatalLimited investigationFinal reportMcWhorter Skystar Vixen · Peachtree City, GAThe pilot's failure to maintain airspeed while maneuvering to reverse his direction following loss of engine power shortly after takeoff resulting in an inadvertent stall and collision with the ground. A factor in the accident was a loss of engine power for…NTSB NYC06LA187Accident · 1 fatalLimited investigationFinal reportBurleigh SeaRey · Ringoes, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Factors included a partial loss of engine power for undetermined reasons.NTSB CHI06LA207Accident · Serious injuriesLimited investigationFinal reportSchlei Avid Flyer Speed Win · Fergus Falls, MNthe fractured aileron bell crank and elevator clevis rod end.NTSB 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.NTSB CHI06CA171Accident · Serious injuriesData collectionFinal reportCroke Zenith CH 701 · Brussels, WIThe pilot not maintaining clearance from the trees during final approach. The trees located along the final approach course were a factor in the accident.NTSB NYC06LA157Accident · Serious injuriesLimited investigationFinal reportWorcester Everett Renegade II · Orneville, MEA loss of engine power for an undetermined reason.NTSB SEA06CA107Accident · No injuriesData collectionFinal reportTaplin Avid Flyer · Grants Pass, ORThe partial loss of engine power for undertermined reasons, resulting in a forced landing and substantial damage to the airplane. A contributing factor was the transmission wire.NTSB 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.NTSB LAX06LA170Accident · 1 fatalLimited investigationFinal reportSchlitter Rans S-18 Stinger · Llano, CAan in-flight loss of control and collision with terrain for undetermined reasons.NTSB ANC06CA051Accident · Minor injuriesData collectionFinal reportLanford Antares MA-33 · Trapper Creek, AKThe non-certificated pilot's failure to maintain altitude/clearance during final approach for landing, which resulted in the airplane striking a tree, and an in-flight collision with terrain. A factor associated with the accident was the tree.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 DEN06LA055Accident · Serious injuriesLimited investigationFinal reportMcLaughlin Rans S-7 · Hudson, COthe pilot's failure to maintain control of the airplane during an attempted landing. Contributing factors include the pilot's improper in-flight planning and decision making, the pilot's lack of experience in tailwheel airplanes, the pilot's lack of a…NTSB CHI06CA102Accident · No injuriesData collectionFinal reportMartin Rans S-7 Courier · Ray, MIThe loss of engine power and fire for undetermined reasons.NTSB ATL06LA051Accident · Serious injuriesLimited investigationFinal reportEakle R Grandin Jr Talon XP · Auburn, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A factor was the improper maintenance inspection of the engine fuel lines resulting in loss of engine power due to a loose fuel line and subsequent fuel starvation.NTSB NYC06LA024Accident · Minor injuriesLimited investigationFinal reportLo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VAFailure of the ignition system, which resulted in a loss of engine power.NTSB CHI06CA024Accident · Minor injuriesData collectionFinal reportColson/Goodbread Rans S-12 · Flushing, MIThe loss of engine power on initial climb for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.NTSB IAD05CA134Accident · Serious injuriesData collectionFinal reportLamont Aventura II · Hope, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with water. A factor to the accident was the wind gusts.NTSB CHI05LA228Accident · No injuriesLimited investigationFinal reportAuseth Kitfox IV · Little Grand La, MNThe inadequate flare during landing by the pilot.NTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.NTSB ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.NTSB DFW05CA199Accident · No injuriesData collectionFinal reportMrazek Rans S-14 · Forth Worth, TXThe loss of engine power for undetermined reasons. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB IAD05LA089Accident · 1 fatalLimited investigationFinal reportLongtin Kitfox Model III · New London, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.NTSB ATL05LA110Accident · 1 fatalLimited investigationFinal reportCasten Rans S-10 · Perry, SCA loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI05CA139Accident · Minor injuriesData collectionFinal reportGrimes SNS-9 · Niles, MIThe pilot's failure to maintain airspeed which led to the inadvertent stall/mush, and subsequent impact with the ground.NTSB LAX05LA149Accident · 2 fatalLimited investigationFinal reportSchlitter Randy J Rans S6ES Coyote II · Tombstone, AZloss of engine power for undetermined reasons and the flying pilot's failure to maintain an adequate airspeed that resulted in a stall and uncontrolled descent into terrain.