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 CHI95LA214Accident · Minor injuriesLimited investigationFinal reportAvid Flyer · Auburn, KSthe pilot operating the airplane with known deficiencies. Factors included lack of recent flight experience, inadequate maintenance, and low airspeed.NTSB FTW95LA257Accident · 1 fatalLimited investigationFinal reportRocky Mountain Buccaneer 11 B2B · Longmont, COThe pilot's failure to maintain flying speed, resulting in an inadvertent stall while attempting to make a forced landing. Factors were the pilot's lack of total experience in airplane make/model, improper maintenance of the airplane, and operation of the…NTSB MIA95WA171Accident · No injuriesForeign investigationWillingham, Dave L. Kolb Twinstar · Freeport, BahamasNTSB LAX95LA215Accident · Serious injuriesLimited investigationFinal reportIssoire-Aviation PIK-30 · Dayton, NVthe pilot's delayed decision to extend and use the engine to maintain adequate terrain clearance after encountering downdrafts.NTSB MIA95LA140Accident · No injuriesLimited investigationFinal reportMoncrief Zodiac 601 · Fernandina Bch, FLThe failure of maintenance personnel to adequately torque the propeller bolts during the last inspection resulting in the bolt failures and the loss of the propeller.NTSB LAX95LA178Accident · No injuriesLimited investigationFinal reportGodkey Kitfox IV · Phoenix, AZthe failure of the ignition system due to a deffective diode.NTSB CHI95LA144Accident · No injuriesLimited investigationFinal reportQuad City Challenger · Bridgeport, MIInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.NTSB MIA95LA124Accident · Minor injuriesLimited investigationFinal reportBubel, John A. Condor 2 · Homestead, FLLoss of engine power for undetermined reasons.NTSB MIA95LA125Accident · No injuriesLimited investigationFinal reportFabre Searay Bombadier · Orlando, FLThe abrupt use of the flight controls,by the pilot-in-command while taxiing on water that resulted in the airplane capsizing.NTSB ATL95LA083Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Super GT 400 · Pleasant Hill, TNThe pilot's inadequate compensation for wind conditions, and his failure to maintain aircraft control during the initial climb. Factors were the crosswind conditions, the perimeter trees, and the pilot's lack of total flying experience.NTSB ATL95LA067Accident · No injuriesLimited investigationFinal reportWente Kitfox III · Moncks Corner, SCThe pilot's selection of the wrong runway relative to the wind conditions and his failure to maintain alignment with the runway during the balked landing.NTSB FTW95LA132Accident · Minor injuriesLimited investigationFinal reportSchmanski Kitfox III · Greeley, COThe pilot's inadequate compensation for wind conditions. A factor was a sudden wind shift.NTSB MIA95LA036Accident · Serious injuriesLimited investigationFinal reportColvin Kitfox II · Fort Pierce, FLThe failure of the pilot to abort the takeoff when he encountered water on the grass runway.NTSB NYC95LA039Accident · 1 fatalLimited investigationFinal reportWilliam MC Glumphy Kitfox III · Cadiz, OHThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall, and uncontrolled collision with the ground. A factor was pilot's lack of total experience in this make and model.NTSB LAX95LA023Accident · No injuriesLimited investigationFinal reportGlen A. Senecal 5151 · Apple Valley, CAthe manufacturer's (owner/operator) improper balancing of the aileron flight controls which resulted in a cable separation due to overload from the aileron flutter. The rough/uneven terrain was also a factor.NTSB NYC95LA016Accident · No injuriesLimited investigationFinal reportAngel Avid/Heavy Hauler · Sutton, MAThe pilot's failure to maintain the fuel selector on the proper position.NTSB SEA94LA241Accident · No injuriesLimited investigationFinal reportOestreich Avid Flyer MK IV · Moses Lake, WAProper descent rate was exceeded. Lack of total experience in type operation was a factor.NTSB MIA94LA213Accident · 1 fatalLimited investigationFinal reportRans S-12 Airaile · Clearwater, FLThe loss of engine power for undetermined reasons.NTSB CHI94LA302Accident · Minor injuriesLimited investigationFinal reportFrith Challenger II · Fairfield, IAthe total failure and separation of the propeller system drive belt. Obstacles (powerlines and pole) were a factor in the accident.NTSB BFO94LA152Accident · Minor injuriesLimited investigationFinal reportA. Le Francois Rans S-7 · Palmer, MAThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed.NTSB FTW94LA277Accident · No injuriesLimited investigationFinal reportHodges P-51-51 · Beaumont, TXThe improper adjustment of the propeller system pitch.NTSB CHI94FA258Accident · Minor injuriesField investigationFinal reportKeuthan, Charles J. Buccaneer II · Oshkosh, WIthe pilot's inadvertent stall of the airplane. Factors were the tailwind condition and the pilot's inadequate compensation for the tailwind.NTSB ANC94LA095Accident · No injuriesLimited investigationFinal reportStarman Teirra II · North Pole, AKThe seizure of the no. 2 cylinder as a result of an inadequate cooling system for the high ambient temperature.NTSB CHI94LA270Accident · No injuriesLimited investigationFinal reportMiller Kitfox · Spencer, INthe private pilot/airplane builder's failure to maintain adequate clearance from obstacles during the approach to landing.NTSB NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.NTSB MIA94LA170Accident · 1 fatalLimited investigationFinal reportFullana Quicksilver GT-500 · Palmas Del Mar, PRThe pilot's abrupt lowering of the flaps which resulted in a loss of control at an altitude insufficient for recovery, and the pilot's unwarranted low flying.NTSB FTW94LA135Accident · No injuriesLimited investigationFinal reportSavage Kitfox · Longmont, COThe pilot's failure to maintain directional control.NTSB SEA94LA160Accident · No injuriesLimited investigationFinal reportNewgard Kitfox III · Yelm, WAFuel starvation due to an inadequately installed fuel line.NTSB CHI94DEP01Accident · No injuriesFinal reportKrotje Kolb Mark III · Oshkosh, WIThe lack of carburetor heat for the engine. A factor related to the accident was: the weather condition, which was favorable for formation of carburetor ice.NTSB SEA94LA021Accident · Serious injuriesLimited investigationFinal reportHannah Avid Amphibian · Scappoose, ORThe pilot's poor inflight decision, and failure to maintain sufficient airspeed. Factors include contaminated fuel.NTSB NYC94LA008Accident · 1 fatalLimited investigationFinal reportFeatherston Titan Tornado · Mechanicsville, VAFailure of the pilot to correct the descent. Factors related to the accident were: the light conditions at dusk, impairment of the pilot from use of a medication (prescription drug), and possible lack of visual ques (pilot's visual perception).NTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.NTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.NTSB FTW93LA256Accident · No injuriesLimited investigationFinal reportJones Dominator · Magnolia, ARTotal loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.NTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.NTSB CHI93DEP04Accident · No injuriesFinal reportJordi, Ronald H. Challenger II · Plymouth, WIthe loss of engine power for undetermined reason(s).NTSB MIA93LA175Accident · Serious injuriesLimited investigationFinal reportRotec Engineering Rotec Rally 3 · Jay, FLFailure of the pilot in command to maintain airspeed (vs), inadvertent stall/mush by the pilot in command, and altitude insufficient for recovery. Contributing to the accident was lack of total experience by the pilot in command and in flight encounter with…NTSB FTW93LA233Accident · Minor injuriesLimited investigationFinal reportAero Falcon Intl. Knight Falcon · Mineral Wells, TXFailure of the autopilot which resulted in an improper flight control condition. A factor was the pilot's inability to regain control.NTSB CHI93DEP03Accident · No injuriesFinal reportKit Fox IV · Green Bay, WIthe improper modification of the fuel system by the pilot-in-command. A factor was bockage of the fuel system screen.NTSB FTW93LA262Accident · No injuriesLimited investigationFinal reportZbacnick Challenger II · Alamogordo, NMThe seizure of the propeller shaft bearing and the resultant propeller blade separation. Factors were the unfavorable winds and the lack of suitable terrain available for the forced landing.NTSB BFO93LA123Accident · 1 fatalLimited investigationFinal reportRolando Rans S-10 · Numidia, PAThe excessive maneuver attempted by the pilot which resulted in a loss of control in flight and an inadvertent spin at an altitude insufficient for recovery.NTSB MIA93LA128Accident · No injuriesLimited investigationFinal reportJohn Shufflebarger Zenair Zodiak · Lakeland, FLThe failure of the pilot-in-command to maintain airspeed after separation of the canopy, resulting in the aircraft entering a stall/mush condition and descending uncontrolled to the ground. Contributing to the accident was the failure of the pilot-in-command…NTSB NYC93LA094Accident · Minor injuriesLimited investigationFinal reportSteven Kurtis Rand S 12 · E Stroudsburg, PAA forced landing in trees as a result of a complete loss of engine power for unknown reasons.NTSB FTW93FA138Accident · 1 fatalField investigationFinal reportSnobird 532 · Early, TXThe pilot's inadvertent porpoise. A factor was the improperly adjusted trim springNTSB FTW93LA136Accident · Minor injuriesLimited investigationFinal reportTuttle Star Lite · Conroe, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landingNTSB SEA93LA076Accident · No injuriesLimited investigationFinal reportBarr Kitfox II · Sheridan, WYA partial power loss for undetermined reasons. Factors include a strong crosswind on landing.NTSB LAX93LA143Accident · No injuriesLimited investigationFinal reportE.L. Erickson Tierra II · Rio Linda, CAThe flight's encounter with a downdraft. A factor relating to this accident was the trees.NTSB FTW93LA078Accident · No injuriesLimited investigationFinal reportRans S-7 · Lancaster, TXAircraft control not maintained by pilot. Turbulence due to strong, gusty winds was a factorNTSB CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.NTSB MIA93LA040Accident · Serious injuriesLimited investigationFinal reportCuevas, Orlando S. Quicksilver MXL 2 · Guayama, PRThe pilot in command's failure to maintain directional control while making a go around following a bounced landing resulting in a collision with trees.