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 CHI97LA222Accident · No injuriesLimited investigationFinal reportMorgan MINI-500 · Ava, MOLoss of engine power due to loss of engine cooling fluid. Related factors were maintenance service bulletin not complied with by the owner/pilot mechanic resulting in low output of the carburetor, and unsuitable terrain.NTSB SEA97LA156Accident · No injuriesLimited investigationFinal reportStiritz Eipper MX II · Newport, WAThe failure of the owner/builder to adequately inspect his homebuilt aircraft, which subsequently led to the failure of the right wing lift cable attach bolt and resulted in the collapse of the right wing during flight.NTSB MIA97LA191Accident · No injuriesLimited investigationFinal reportSherman Powell Kitfox IV · Concord, NCFailure of the pilot-in-command to maintain directional control and his poor preflight planning preparation for allowing the pilot rated passenger to manipulate the throttle control. Contributing to the accident was the pilots total lack of experience in make…NTSB NYC97LA116Accident · 1 fatalLimited investigationFinal reportGoodwin Rans S-4 · Cedar Bluff, VAThe pilot's failure to maintain airspeed during the initial takeoff climb which resulted in an inadvertent stall. A related factor was the pilot's lack of familiarity with the airplane.NTSB ANC97LA084Accident · No injuriesLimited investigationFinal reportAnderson Kitfox IV-1200 · Fairbanks, AKa seized crankshaft connecting rod bearing. A factor relating to the acciden was: the lack of suitable terrain for an emergency landing.NTSB CHI97LA158Accident · No injuriesLimited investigationFinal reportKohles Kitfox III · Meadow Grove, NEfailure of the pilot to maintain directional control of the airplane during an aborted takeoff. A factor was the pilot's lack of recent experience in the make and model of airplane.NTSB MIA97LA166Accident · Serious injuriesLimited investigationFinal reportTravis C. Elmore B2B/582 · Haines City, FLThe pilots inadvertent activation of the rear carburetor choke lever during routine engine maintenance the day before the accident. Contributing to the accident was the unsuitable terrain encountered during the forced landing and also failure of the engine…NTSB FTW97LA188Accident · No injuriesLimited investigationFinal reportAeromot AMT-200 · Longmont, COthe dual student pilot's improper landing flare and the flight instructor's inadequate supervision of the flight.NTSB IAD97LA069Accident · Serious injuriesLimited investigationFinal reportJaquish Challenger Spec II · Mansfield, PAinadequate visual lookout by the pilot, which led to an in-flight collision with an electrical wire. Related factors were: low altitude flight by the pilot, and the proximity of the transmission line.NTSB MIA97LA136Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Hollywood, FLthe student pilot's failure to maintain directional control during the landing/go-around, which led to subsequent in-flight collision with a fixed object (approach light/light bar/sign) and terrain. The student's failure to obtain the proper touchdown point…NTSB MIA97LA120Accident · 1 fatalLimited investigationFinal reportBasinski Kolb MK3 · Winter Haven, FLfailure of the pilot to maintain airspeed after an oil leak occurred, which resulted in an inadvertent stall/spin and subsequent collision with a residence and the terrain. The oil leak and the pilot's diverted attention were related factors.NTSB MIA97LA112Accident · Serious injuriesLimited investigationFinal reportCharles J. Keuthan Zephyr II · Bunnell, FLInadvertent stall/mush by the pilot while maneuvering for a forced landing. Contributing to the accident was the partial loss of engine power due to a partial failure of the top compression ring of one of the cylinders.NTSB CHI97LA128Accident · No injuriesLimited investigationFinal reportRochette Rans S-12 XL · Hays, KSthe pilot improperly flared the airplane and the pilot's lack of experience in the type of airplane.NTSB ANC97LA036Accident · Minor injuriesLimited investigationFinal reportWilliams Kitfox · Wasilla, AKa broken electrical wire, which resulted in an inoperative electrical fuel pump, an overly lean mixture, fuel starvation, and loss of engine power.NTSB LAX97LA140Accident · No injuriesLimited investigationFinal reportHoffman, Wolf, Flugzeugbau Super Dimona HK 36R · Scottsdale, AZthe pilot's failure to maintain an adequate glide path.NTSB ATL97LA023Accident · Minor injuriesLimited investigationFinal reportPereyra Aventura II · Rockledge, FLThe loss of engine power for undetermined reasons.NTSB NYC96LA190Accident · No injuriesLimited investigationFinal reportBins Kitfox IV · Pittsfield, MAthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control, the airplane veering off the runway, and a subsequent nose over. The adverse wind condition and uneven terrain were related factors.NTSB ANC96LA147Accident · No injuriesLimited investigationFinal reportRans 7 · Anchorage, AKthe pilot's improper recovery from a bounced landing and failure to maintain control of the aircraft. A factor relatated to the accident was: the pilot's improper decision to continue the flight after he identified he was having difficulty landing the…NTSB FTW96LA372Accident · No injuriesLimited investigationFinal reportHardie KIT FOX XL · Monticello, ARthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA319Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA20-A1 · S. Lake Tahoe, CAThe pilot's inadequate use of the brakes, which resulted in loss of directional control while taxiing in a non-movement area.NTSB CHI96LA286Accident · Serious injuriesLimited investigationFinal reportSchuler T Bird II · Fond Du Lac, WIloss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.NTSB LAX96LA281Accident · No injuriesLimited investigationFinal reportGraham Falcon XP · Mesa, AZblockage of the fuel system vent in the fuel cap, when the pilot overtorqued the fuel cap during his preflight check, which restricted fuel flow to the engine. The pilot's lack of experience in the make and model of airplane was a related factor.NTSB NYC96LA153Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Gowanda, NYfailure of the pilot to properly flare the airplane during the landing.NTSB ANC96LA100Accident · No injuriesLimited investigationFinal reportHorton Avid Flyer MK IV · Tenakee Springs, AKThe pilot's inadequate compensation for wind conditions. Gusty winds were a factor in the accident.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 LAX96LA258Accident · 1 fatalLimited investigationFinal reportDavis Challenger I CW · Paso Robles, CAthe owner/builder/pilot's impairment of judgment and performance due to drugs which led to his improper handling of the airplane and failure to maintain an adequate airspeed margin above stall speed, resulting in an inadvertent stall/spin. A factor which…NTSB CHI96LA215Accident · No injuriesLimited investigationFinal reportLoehle-Avia 5151RG · Fond Du Lac, WIthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the design/location of the fuel tank selector.NTSB SEA96LA110Accident · No injuriesLimited investigationFinal reportStelly Kolb Firestar II · Independence, ORfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. The aircraft's excessive gross weight was a related factor.NTSB ATL96LA087Accident · Serious injuriesLimited investigationFinal reportSky Star Kitfox #1 · Bridgeport, ALloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB CHI96LA176Accident · No injuriesLimited investigationFinal reportMerlin GT · Charlotte, MIthe pilot's failure to maintain airspeed. A factor was the pilot's lack of experience in the airplane.NTSB CHI96LA164Accident · No injuriesLimited investigationFinal reportSchlitter Rans S6ES Coyote II · Hays, KSfailure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.NTSB SEA96LA093Accident · Serious injuriesLimited investigationFinal reportCrescenzi Kitfox · Terrebonne, ORThe pilot's inadequate compensation for wind conditions and failure to maintain altitude/clearance above terrain, while maneuvering to land. The unfavorable wind was a related factor.NTSB FTW96LA155Accident · 1 fatalLimited investigationFinal reportDomaille Rans S-12 · Albuquerque, NMthe student pilot's failure to maintain control of the aircraft after initiating a flight into adverse weather conditions. The strong, gusting wind was a factor.NTSB MIA96LA087Accident · Serious injuriesLimited investigationFinal reportMarks Kitfox II · Panama City, FLthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve and subsequent collision with a ditch. Factors relating to the accident were: failure of the…NTSB CHI96LA084Accident · No injuriesLimited investigationFinal reportConnell Kitfox · Omaha, NEthe pilot's inadequate preflight of the aircraft and the frozen left landing gear wheel.NTSB MIA96LA042Accident · 2 fatalLimited investigationFinal reportOtis King COBRA-B · Newberry, FLan in-flight loss of control for undetermined reasons.NTSB LAX96LA051Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · San Carlos, CAthe pilot's improper recovery from a bounced landing and failure to maintain directional control, while landing at night.NTSB FTW96LA015Accident · Minor injuriesLimited investigationFinal reportAdams Kitfox · Seminole, TXthe pilot's excessive braking.NTSB CHI96LA007Accident · Minor injuriesLimited investigationFinal reportRoisum Team MINI-MAX · Neenah, WIFuel starvation due to fuel filter blockage. Factors associated with the accident were the manufacturers design of the fuel filter and the builder/pilots decision to use an automotive type fuel filter.NTSB MIA96LA004Accident · 1 fatalLimited investigationFinal reportLouks Pulsar XP · Inverness, FLPremature rotation by the pilot during takeoff, which resulted in an inadvertent stall/mush, while attempting to accelerate in ground effect after lift-off.NTSB BFO96LA006Accident · Minor injuriesLimited investigationFinal reportMadsen/Rans Rans S12 Airaile · Cobbs Creek, VAloss of engine power for undetermined reasons.NTSB LAX96LA007Accident · No injuriesLimited investigationFinal reportSchlitter Rans S-9 · Chandler, AZseizure of the #2 cylinder for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB SEA96LA001Accident · 1 fatalLimited investigationFinal reportRasmussen Kitfox 2 · Battle Ground, WAfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall/mush and subsequent collision with trees and the ground.NTSB LAX95LA345Accident · Minor injuriesLimited investigationFinal reportPro-built Kitfox IV Speedster · Lakeport, CAthe pilot's improper installation of the carburetors.NTSB LAX95LA324Accident · No injuriesLimited investigationFinal reportWelles Kitfox Speedster · San Luis Obispo, CAthe pilot's failure to maintain directional control.NTSB FTW95LA364Accident · Serious injuriesLimited investigationFinal reportIsaacson Kolb Twin Star MK II · Mansfield, TXthe loss of engine power for undertermined reasons, and the pilot's failure to maintain airspeed. A factor was the pilot's lack of flying experience.NTSB BFO95LA085Accident · Serious injuriesLimited investigationFinal reportBirdman Enterprises Chinook 2S · Hammondsville, OHthe pilot's failure to maintain adequate altitude/clearance from obstacles (power lines) in his flight path.NTSB CHI95FA242Accident · No injuriesField investigationFinal reportRevolution Helicopter MINI-500 · Oshkosh, WIthe inadequate design of the helicopter skid shoes. Factors related to the accident were: false indications of rotor rpm and EGT which led to seizure of the piston.NTSB FTW95LA313Accident · No injuriesLimited investigationFinal reportSteinke Early Bird · Akron, COFailure of the pilot to properly flare the airplane for landing during an emergency landing after takeoff. Factors relating to the accidents were: a malfunction of the side rave valve, an excessively rich fuel mixture, and the high density altitude, which…NTSB FTW95LA285Accident · 2 fatalLimited investigationFinal reportMeyer Pulsar XP · Spring Branch, TXThe pilot's improper positioning of the fuel tank selector and his failure to maintain airspeed. A factor was the pilot's diverted attention to the power loss.