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 MIA99LA045Accident · Minor injuriesLimited investigationFinal reportQuicksilver MXL-2 · Humacao, PRThe pilot's use of a synthetic oil that is not recommended by the engine manufacturer when premixing his two cycle gasoline/oil fuel mixture, resulting is a total loss of engine power due to decreased lubricating properties, and the subsequent forced landing…NTSB NYC99LA030Accident · No injuriesLimited investigationFinal reportKing Kitfox IV · Gasport, NYA collision with a deer while landing.NTSB LAX99LA054Accident · No injuriesLimited investigationFinal reportWilliams Hurrican HP · Corona, CAThe seizure of the engine due to a cylinder/piston overheat condition for undetermined reasons.NTSB MIA99LA022Accident · 1 fatalLimited investigationFinal reportFerguson Rans S-10 Sakota · Pisgah, MSThe pilot's failure to maintain aircraft control during a low altitude maneuver resulting in the aircraft's uncontrollable descent until impact with the terrain.NTSB FTW99LA007Accident · 1 fatalLimited investigationFinal reportPainton Loehle Aviation 5151 · Osceola, ARThe pilot's failure to maintain aircraft control due to incapacitation as a result of hypertensive arteriosclerotic cardiovascular disease.NTSB ATL99LA003Accident · No injuriesLimited investigationFinal reportAuxier Herschel A Jr. SEA REY Amphibian · Keystone Height, FLThe pilots failure to attain adequate airspeed, which resulted in a stall, and loss of control.NTSB SEA98LA195Accident · No injuriesLimited investigationFinal reportEvarts Kitfox IV 1200 · Sula, MTAn excessive brake application by the pilot. Factors included a narrow landing area, the pilot's failure to maintain directional control during a 180-degree taxi turn, and a tailwind.NTSB FTW98LA419Accident · No injuriesLimited investigationFinal reportHundere Kitfox II · Somerset, TXThe pilot's inadvertent stall. Factors were the wind sock that was displaying inaccurate information, the gusty wind condition, and the pilot's lack of experience in the tailwheel equipped airplane.NTSB SEA98LA181Accident · Serious injuriesLimited investigationFinal reportKelly Kolb Mark III · Cashmere, WAFuel starvation caused by the partial blockage of the fuel pump chambers as a result of the misalignment of the fuel pump front cover by the pilot/builder. Factors include trees in the area in which the pilot attempted the forced landing.NTSB NYC98LA187Accident · Minor injuriesLimited investigationFinal reportAnkenbruck Searey · Chippewa Lake, OHEncounter with swells from a boat wake. A factor in the accident was the pilot's inadequate initial training.NTSB CHI98LA334Accident · No injuriesLimited investigationFinal reportCulver-Revolution Mini 500 · Eden Prairie, MNa design change to the fuel tank filler neck sealant made by the owner/builder of the helicopter. Factors associated with this accident were an improper sealant material used by the owner/builder and an autorotation was not possible by the pilot due to the…NTSB ATL98LA123Accident · Minor injuriesLimited investigationFinal reportVertical Concepts Searey · Hiawassee, GAThe delamination of the hull that resulted in a nose over during landing.NTSB MIA98LA236Accident · No injuriesLimited investigationFinal reportHall Revolution Mini 500 · Hattiesburg, MSThe failure of the pilot to maintain main rotor rpm during a forward hover and the cyclic grip separating during the resultant bounced landing resulting in the pilot losing cyclic control and the main rotor contacting the tail boom. A factor in the accident…NTSB ANC98LA129Accident · Minor injuriesLimited investigationFinal reportDrake Kitfox III · Aniak, AKThe pilot's inadequate in-flight planning/decision, and an inadvertent stall. Factors in the accident were the pilot/owner's improper installation and pitch setting of the propeller assembly, and a tailwind.NTSB LAX98LA272Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-20-A1 · Woodland, CAThe pilot's failure during a preflight inspection to detect the damaged propeller from the previous hard landing. The damaged propeller degraded the climb performance capability of the airplane.NTSB FTW98LA355Accident · No injuriesLimited investigationFinal reportCrane Quicksilver Sport 2 · Glenn Heights, TXThe loss of engine power as the result of the owner/pilot's failure to install and adjust the proper carburetor jets. A factor was the lack of suitable terrain for the forced landing.NTSB IAD98LA082Accident · Minor injuriesLimited investigationFinal reportMiehl Team HI-MAX-1700R · Jamestown, NYthe pilot's failure to obtain proper airspeed and his subsequent loss of directional control.NTSB FTW98LA313Accident · Serious injuriesLimited investigationFinal reportShoemaker S-12 Aeraile · Marion, ARThe non-certificated pilot's failure to maintain minimum required airspeed resulting in an inadvertent stall. A factor was the pilot's lack of total flight experience.NTSB IAD98LA078Accident · Serious injuriesLimited investigationFinal reportMastopietro Rans S12 · Phillips, MELoss of engine power due to a separated oil line. A related factor was the unsuitable field.NTSB LAX98LA215Accident · No injuriesLimited investigationFinal reportZimmerman Kitfox 4-1200 · Fountain Hills, AZThe failure of the pilot to maintain directional control during the landing roll in a crosswind.NTSB MIA98LA184Accident · No injuriesLimited investigationFinal reportProgressive Aerodyne Stingray · Lake Tarpon, FLThe pilot's failure to insure that the landing gear was in the up-and-locked position prior to the water landing.NTSB CHI98LA206Accident · Minor injuriesLimited investigationFinal reportParker Rotorway 162-F · Manchester, INthe pilot misjudged the flare.NTSB CHI98LA197Accident · No injuriesLimited investigationFinal reportWolfe Pulsar 582 · Greenfield, INthe pilot's failure to obtain control of the aircraft during the recovery from a stall. Factors associated with the accident were the intentional stall initiated and the low altitude which did not allow a full recovery from the stall condition.NTSB LAX98LA177Accident · No injuriesLimited investigationFinal reportRans S6EX Coyote II · Delano, CAThe pilot's inadequate compensation for wind conditions, failure to maintain directional control, and his failure to maintain aircraft controlNTSB CHI98LA176Accident · Minor injuriesLimited investigationFinal reportWaters Vortex · Monroe, WIthe pilot's failure to maintain rotor RPM. A factor associated with the accident was the soft terrain on which the gyrocopter touched down.NTSB NYC98LA118Accident · No injuriesLimited investigationFinal reportMorrison Rans S-12 · Gum Spring, VAA loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.NTSB CHI98LA146Accident · No injuriesLimited investigationFinal reportDangremond Challenger II · Wayland, MIthe pilot's improper installation of the right wing forward strut attachment bolt.NTSB CHI98LA142Accident · 1 fatalLimited investigationFinal reportBombardier Rans S-9 · Waukee, IAthe pilot's failure to maintain control of the airplane which resulted in a stall while performing intentional buzzing maneuvers.NTSB MIA98LA141Accident · 1 fatalLimited investigationFinal reportStar-Lite Engineering Warp 1A · Lakeland, FLthe pilot's failure to maintain airspeed, while maneuvering on crosswind in the traffic pattern, which resulted in an inadvertent stall, and an in-flight collision with a building and the terrain. Factors relating to the accident were: the pilot's decision to…NTSB CHI98LA120Accident · 2 fatalLimited investigationFinal reportRodgers Raven · Brandt, SDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to this accident was the pilot's lack of experience in the airplane.NTSB NYC98LA088Accident · Serious injuriesLimited investigationFinal reportRamseyer Tierra II · Wooster, OHThe pilot's failure to maintain airspeed during the landing approach. A factor in this accident was the pilot's lack of experience in make and model.NTSB SEA98LA030Accident · No injuriesLimited investigationFinal reportRaser Mini 500 · Newberg, ORa power loss resulting from overtemperature of a cylinder. The pilot's operation with known deficiencies was a factor.NTSB FTW98LA107Accident · Serious injuriesLimited investigationFinal reportSutton Tierra II · Woodson, ARThe pilot's inability to maintain control of the airplane for undetermined reasons.NTSB FTW98LA408Accident · No injuriesLimited investigationFinal reportPalermo Challenger II · Erwinville, LAThe pilot's failure to compensate for the prevailing crosswind. Factors were the crosswind and the loss of engine power due to the separation of the fuel pick-up line.NTSB NYC98LA049Accident · 1 fatalLimited investigationFinal reportBihn Mini 500 · Gettysburg, OHA loss of engine power for undetermined reasons, followed by the main rotor striking the tailboom, which resulted in the separation of a main rotor blade.NTSB SEA98LA020Accident · Minor injuriesLimited investigationFinal reportSchramm Helicycle · Big Timber, MTthe pilot's failure to maintain clearance from power lines. The pilot's diverted attention and transmission wires were factors.NTSB IAD98LA014Accident · Minor injuriesLimited investigationFinal reportJones Mini 500 · Bluefield, WVPilot's unfamiliarity with reciprocating engine powered helicopter lead to a reduction in main rotor rpm and subsequent uncontrolled rate of descent with insufficient altitude to recover.NTSB ATL98LA012Accident · No injuriesLimited investigationFinal reportRoebuck Rans S-10 Sakota · Columbia, SCthe airplane builder's improper routing of vinyl/plastic cooling/vent line(s) for the engine oil system, and improper materials supplied by the manufacturer, which led to overheating of the line(s) in the engine compartment and an in-flight fire.NTSB LAX97LA326Accident · Minor injuriesLimited investigationFinal reportLampert M500 · San Carlos, CAloss of engine power for undetermined reasons, and the pilot's improper use of the flight controls following the loss of power. The pilot's lack of training/certification in rotorcraft operations was a factor in this accident.NTSB MIA97LA240Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, NCThe failure of the pilot to latch the canopy closed prior to takeoff. This resulted in the canopying opening while on approach to land and the pilot was unable to maintain altitude due to the excessive drag.NTSB SEA97LA199Accident · No injuriesLimited investigationFinal reportComeaux Kitfox 1 · Bend, ORThe private pilot-in-command's failure to ensure that directional control was maintained. A related factor was the private pilot's lack of total flight experience.NTSB FTW97LA328Accident · No injuriesLimited investigationFinal reportFingerhut Revolution Mini 500 · Huffman, TXThe disengagement of the helicopter's collective control tube due to improper installation by the builder. Factors were the lack of sufficient information provided by the kit manufacturer and the pilot's inability to cushion the landing.NTSB IAD97LA113Accident · No injuriesLimited investigationFinal reportHaines Revolution Mini 500 · N Philadelphia, OHA leak on the exhaust manifold which resulted in a loss of engine power.NTSB NYC97LA162Accident · Minor injuriesLimited investigationFinal reportSimpson Avid Flyer · Westerly, RIThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.NTSB IAD97LA107Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Slatington, PAThe pilot's inadequate preflight planning/ preparation which resulted in fuel exhaustion.NTSB CHI97LA251Accident · Serious injuriesLimited investigationFinal reportLarsen T-BIRD II · Oshkosh, WIthe pilot's failure to maintain flying speed and loss of control resulting in a stall. Factors were the tree and the fence.NTSB CHI97LA231Accident · 1 fatalLimited investigationFinal reportStratton Challenger II · Bellaire, MIfailure of the pilot to maintain control of the airplane during takeoff. The gusty wind condition was a related factor.NTSB NYC97LA152Accident · Serious injuriesLimited investigationFinal reportKenneson Merlin GT · Kensington, NHthe pilot's inability to obtain and/or maintain control of the airplane after takeoff.NTSB IAD97LA102Accident · 1 fatalLimited investigationFinal reportLardas Renegade Spirit · Boonsboro, MDThe pilot's failure to maintain control of his homebuilt airplane during a low level maneuver after a loss of engine power due to undetermined reasons. A factor in the accident was the pilot's alcohol impairment.NTSB FTW97FA274Accident · 1 fatalField investigationFinal reportHillam Rans S-9 · Mckinney, TXloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with the terrain.