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 SEA05LA073Accident · No injuriesLimited investigationFinal reportShorethose Kitfox Series 5 · Cresent City, FLAircraft handling not maintained during the landing rollout. Factors include soft terrain.NTSB SEA05LA071Accident · Minor injuriesLimited investigationFinal reportPark Kitfox IV · Eagle Point, ORLoss of partial engine power during initial climb for undetermined reasons. Soft terrain was a factorNTSB SEA05CA060Accident · No injuriesData collectionFinal reportBirtch Kitfox II · Dillard, ORThe pilot's failure to maintain clearance from obstacles while in cruise flight at low altitude, which resulted in an inflight collision with a power line. A factor was the pilot's decision to fly at low altitude.NTSB ANC05LA032Accident · Minor injuriesLimited investigationFinal reportJohnson Revolution Mini 500 · Isabela, PRThe loss of engine power during cruise flight for an undetermined reason, which resulted in an autorotation and collision with terrain.NTSB SEA05LA016Accident · Minor injuriesLimited investigationFinal reportHannah Avid Amphibian · Creswell, ORCarburetor icing and the failure of the pilot to maintain airspeed which resulted in a stall. Factors contributing to the accident included the lack of a carburetor heat system and the probability of carburetor ice.NTSB CHI05CA025Accident · No injuriesData collectionFinal reportJabat Avid Flyer · Cleveland, MOThe separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.NTSB ATL05LA020Accident · Serious injuriesLimited investigationFinal reportFranzreb Loehle 5151 Mustang · Athens, TNThe loss of engine power due to the electrical fuel pump failure, and fuel starvation.NTSB MIA05LA015Accident · Serious injuriesLimited investigationFinal reportDavid Cadorette Fox Model II · Vero Beach, FLLoss of engine power, for undetermined reasons, resulting in the airplane impacting with a tree and the ground during the subsequent forced landing.NTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…NTSB IAD04LA046Accident · 1 fatalLimited investigationFinal reportScott Rans S-12 · Seneca, NYThe student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.NTSB LAX04CA306Accident · No injuriesData collectionFinal reportQuicksilver MXL II · Rio Vista, CAthe pilot's failure to maintain adequate clearance from high vegetation while flying at a low altitude.NTSB ATL04LA171Accident · Minor injuriesLimited investigationFinal reportHawkins William Searey · Dayton, TNThe delamination of the fiberglass hull of the airplane.NTSB CHI04LA231Accident · Serious injuriesLimited investigationFinal reportStephen T-Bird TBT06 · Gobles, MIThe pilot's inadvertent flight into adverse weather conditions which resulted in an encounter with a downdraft that exceeded the climb capabilities of the airplane. The downdraft and the trees 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 FTW04LA187Accident · Serious injuriesLimited investigationFinal reportSaladino Searey · Lewisville, TXThe pilot's failure to maintain control of the airplane during final approach. A contributing factor was the gusty crosswind condition.NTSB SEA04LA120Accident · No injuriesLimited investigationFinal reportSheppard Kitfox IV · Rigby, IDFailure to maintain directional control during the landing roll. Factors include muddy terrain.NTSB LAX04LA228Accident · Minor injuriesLimited investigationFinal reportWilson Avid Bandit · Paso Robles, CAthe loss of engine power during takeoff climb due to a cold seizure of the rear cylinder.NTSB NYC04LA133Accident · Serious injuriesLimited investigationFinal reportMosher Avid Heavy Hauler · Fitchburg, MAThe malfunction of the elevator control system, resulting in a forced landing.NTSB ATL04LA122Accident · Serious injuriesLimited investigationFinal reportQuicksilver GT-500 · Cleveland, GAThe student pilot's failure to maintain directional control and his inadequate compensation for wind during takeoff. A factor was crosswind condition.NTSB ATL04LA109Accident · 1 fatalLimited investigationFinal reportBergmann Rans S-12 XL Airaile · Cummings, GAThe unqualified person's poor judgement and his failed to maintain clearance from power lines and trees while maneuvering for a landing which resulted in the in-flight collision with trees and power lines. Factors were the dark night and the unqualified…NTSB NYC04LA111Accident · Serious injuriesLimited investigationFinal reportBlack Kitfox · Mount Sterling, KYThe loss of engine power due to blockage of the fuel filters resulting in fuel starvation. A factor in the accident was the inadequate maintenance inspection.NTSB SEA04LA074Accident · 1 fatalLimited investigationFinal reportSchramm Helicycle · Montour, IDIn flight collision with terrain for undetermined reasons.NTSB ATL04CA083Accident · Minor injuriesData collectionFinal reportDantzer Lawrence L Rans S-12 · Lowndesboro, ALThe pilot's failure to maintain airspeed while manuevering which resulted in an inadvertent stall/spin. A factor was trees.NTSB DEN04LA051Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Berthoud, COthe pilot's improper flare and his inadequate compensation for wind. The wind gust was a contributing factor.NTSB LAX04LA132Accident · 1 fatalLimited investigationFinal reportGillespie Sport Copter Vortex · Yuba City, CAa loss of engine power due to the incorrect installation of the fuel line, which resulted in fuel starvation, and the pilot's failure to maintain rotor RPM, which resulted in an inflight loss of control. A factor to the accident was the pilot's lack of…NTSB ATL04LA066Accident · Minor injuriesLimited investigationFinal reportCurrent Kitfox 313 · Selma, ALThe pilot's inadequate installation, and his failure to secure the main fuel line, which resulted in fuel starvation.NTSB LAX04FA064Accident · 1 fatalField investigationFinal reportIniziative Industriali Italian Sky Arrow 650 TC · Placerville, CAthe pilot's failure to fully remove an accumulation of ice and frost on the wings, which led to an inadvertent stall/mush and collision with the ground. A factor in the accident was the pilot's failure to correctly configure the flaps for takeoff.NTSB NYC04LA029Accident · No injuriesLimited investigationFinal reportWalters Kolb Mark III · Ashtabula, OHA power loss for undetermined reason(s).NTSB FTW04LA014Accident · 1 fatalLimited investigationFinal reportRans S-10 · Ponder, TXThe pilot's decision to conduct low altitude maneuvering flight and his failure to maintain adequate airspeed.NTSB CHI04LA014Accident · No injuriesLimited investigationFinal reportCroke Zenith CH 701 · Brussels, WIA partial loss of engine power for undetermined reasons.NTSB SEA03LA197Accident · No injuriesLimited investigationFinal reportThompson Avid Flyer · Roche Harbor, WAA complete loss of power due to fuel starvation for undetermined reason(s).NTSB MIA03LA186Accident · Minor injuriesLimited investigationFinal reportS. FL. Ultralights Capella Classic · Port Charlotte, FLThe loss of engine power for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced landing resulting in the airplane cart wheeling and subsequent substantial damage.NTSB SEA03LA157Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-24E · Hood River, ORThe pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.NTSB SEA03LA132Accident · Serious injuriesLimited investigationFinal reportHanks Avid Flyer · Toledo, WAThe pilot's failure to maintain aircraft control during a simulated emergency descent. Inadequate remedial action was a factor.NTSB DEN03LA121Accident · Serious injuriesLimited investigationFinal reportPringle Rans S-7 Courer · Manti, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Low altitude flight and high density altitude are contributing factors.NTSB CHI03LA201Accident · 2 fatalLimited investigationFinal reportMcIlraith Sea Rey · Tomah, WIThe loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.NTSB LAX03LA211Accident · No injuriesLimited investigationFinal reportPieterse Kitfox 2 · Corona, CAThe improper design and installation of the airplane's fuel system by the builder of the experimental airplane, which resulted in fuel starvation and a loss of engine power.NTSB DEN03LA104Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Eureka, UTthe pilot's improper in-flight planning and failure to maintain aircraft control. Contributing factors include high density altitude, hilly terrain, low airspeed and the subsequent inadvertent stall/mush.NTSB ATL03LA102Accident · No injuriesLimited investigationFinal reportCollier Quickie · Alexander, ALThe loss engine of power due to undetermined reasons.NTSB MIA03LA109Accident · Serious injuriesLimited investigationFinal reportBill Darling Rans S9 · Green Cove Sprg, FLA loss of engine power for undetermined reasons.NTSB CHI03LA117Accident · 1 fatalLimited investigationFinal reportSmith Rans S-7 · Baudette, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the low altitude maneuver by the student pilot.NTSB CHI03LA120Accident · No injuriesLimited investigationFinal reportYadon Starflight Stiletto · Peculiar, MOThe pilot's inadvertent shutdown of the engine. Contributing factors were unsuitable terrain and trees.NTSB MIA03LA085Accident · Minor injuriesLimited investigationFinal reportGhiles Philippe/American Ga MCR-01 VLA · Lakeland, FLThe failure of the pilot-in-command to abort the takeoff after recognizing that the airplane did not become airborne at the calculated point down the runway. A contributing factor in the accident was the windshift during the takeoff roll resulting in a…NTSB LAX03LA110Accident · No injuriesLimited investigationFinal reportKolb Firestar · San Diego, CApropeller delamination due to the pilot's failure to properly secure the rear seat shoulder harness prior to flight. A contributing factor was the soft ground in which the airplane landed.NTSB ATL03LA043Accident · Serious injuriesLimited investigationFinal reportPenska Rans S-9 · Dothan, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent inflight collision with the groundNTSB CHI03LA052Accident · 1 fatalLimited investigationFinal reportHavir Avid Flyer · Cambridge, NEThe inadvertent stall by the pilot following a total loss of engine power and the seizure of the engine. A factor to the accident was the engine overhaul not performed in accordance with the manufacturer's recommendations.NTSB FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.NTSB FTW03LA039Accident · Serious injuriesLimited investigationFinal reportLarson Kitfox III · Little Rock, ARThe pilot's failure to maintain aircraft control during an intentional taxi resulting in the inadvertent lift-off of the airplane and subsequent inadvertent stall. Contributing factors were the pilot's lack of total experience in the make and model of…NTSB ANC03LA009Accident · No injuriesLimited investigationFinal reportArima Kolb Fire Star II · Chugiak, AKThe pilot's inadequate preflight inspection which failed to remove contaminated fuel from the airplane's fuel system, resulting in a loss of engine power during takeoff.NTSB SEA03LA006Accident · Serious injuriesLimited investigationFinal reportRutledge Kitfox · Condon, ORA loose clamp around the gascolator bowl. A related factor was the maintenance inspection not being performed.