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 CEN15CA353Accident · Minor injuriesData collectionFinal reportRatte James Aventura II · Tyler, TXThe loss of airplane control during a go around, which resulted in impact with the water. Contributing to the accident was the pilot's lack of seaplane rating and inexperience in the accident airplane.NTSB GAA15CA210Accident · No injuriesData collectionFinal reportExperimental Amat Built Kitfox III · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with terrain.NTSB ERA15LA271Accident · No injuriesLimited investigationFinal reportYoung John E Searey · Corbin, KYThe pilot’s improper conduct of a precautionary landing, which resulted in abnormal water contact that damaged the hull.NTSB GAA15CA087Accident · No injuriesData collectionFinal reportSmith Vilas Kitfox · McLeansboro, ILThe pilot's failure to maintain attitude control during the landing roll. A contributing factor was the pilot's lack of training and experience in this airplane make and model.NTSB ANC15WA067Accident · 1 fatalForeign investigationKevin D. Yarnevich Kitfox · Surrey, CanadaNTSB CEN15LA252Accident · No injuriesLimited investigationFinal reportMichael Wilson Murphy Spirit · Livingston, TXThe pilot’s failure to maintain adequate airspeed, which increased the induced drag and led to the engine having insufficient power to overcome the drag and climb the airplane and resulted in a forced landing and the subsequent collapse of the main landing…NTSB CEN15CA201Accident · Minor injuriesData collectionFinal reportFiebich Paul Dean Airbike RX40 · Derby, KSThe pilot's inadequate compensation for wind conditions during the landing, which resulted in a hard landing and separation of the left main landing gear.NTSB GAA15CA029Accident · No injuriesData collectionFinal reportKerr John A Kitfox Classic IV · Logan, UTThe pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, and a loss of engine power en route.NTSB GAA15LA025Accident · Serious injuriesLimited investigationFinal reportSpaulding Errol Rans S 7 Courier · Pinedale, WYThe pilot’s decision to take off in a crosswind that exceeded the airplane’s maximum demonstrated crosswind capability and his subsequent inability to maintain directional control.NTSB CEN15LA169Accident · Serious injuriesLimited investigationFinal reportHoke Bobby F Rans S 12 · Rusk, TXA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's failure to maintain control while maneuvering for a forced landing, which resulted in the airplane…NTSB WPR14FA393Accident · 1 fatalField investigationFinal reportTifft Kitfox III · Lake Stevens, WAThe pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…NTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.NTSB CEN14LA411Accident · Minor injuriesLimited investigationFinal reportHanson Lonn Avid Amphibian · Waterville, MNThe noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.NTSB WPR14CA279Accident · Serious injuriesData collectionFinal reportWiley Kitfox IV · Sprague, WAThe pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.NTSB CEN14LA281Accident · Serious injuriesLimited investigationFinal reportOffchiss Edward R Avid Flyer · Lamoni, IAThe student pilot’s failure to maintain control of the airplane while landing.NTSB CEN14LA251Accident · Serious injuriesLimited investigationFinal reportSmythe Donald F Kitfox Classic IV · Slaughter, LAThe pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.NTSB WPR14CA214Accident · No injuriesData collectionFinal reportOlson Kitfox II · Helena, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane nosing over.NTSB WPR14LA179Accident · No injuriesLimited investigationFinal reportCoulter Hugh Clarke Pulsar XP Series I · Bremerton, WAFatigue failure of the nose landing gear retention and pivot shaft, which resulted in the in-flight separation of the nose gear wheel and tire assembly.NTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.NTSB CEN14FA140Accident · 1 fatalField investigationFinal reportHillam Scott L Rans S 10 · Shepherd, TXThe noncertificated pilot’s improper decision to attempt aerobatic maneuvers that exceeded the airplane’s design limitations, which resulted in the subsequent in-flight breakup of the airplane. Contributing to the accident was the pilot’s lack of aerobatic…NTSB CEN14LA079Accident · Serious injuriesLimited investigationFinal reportThompson William A Sparrow II · Jeromesville, OHThe student pilot's in-flight loss of control while attempting to return to the runway following a loss of engine power. The cause of the loss of engine power could not be determined because the postaccident examination did not reveal any anomalies.NTSB WPR14LA055Accident · Serious injuriesLimited investigationFinal reportRichard S Duncan Avid Flyer · Lakeside, ORThe pilot/owner’s failure to comply with the engine manufacturer’s maintenance guidance, which resulted in the total loss of engine power due to the fracture failure of the plastic drive gear for the engine lubricating oil pump.NTSB CEN14LA045Accident · No injuriesLimited investigationFinal reportSutphin Rans S-12 · French Lick, INThe pilot's failure to maintain adequate airspeed while in a steep turn, which resulted in an aerodynamic stall/mush at a low altitude.NTSB CEN13CA521Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Osage Beach, MOThe pilot’s failure to maintain aircraft control during initial climb in gusty wind conditions.NTSB CEN13LA524Accident · Serious injuriesLimited investigationFinal reportStemme S10-VT · Mackinaw City, MIThe mechanic’s failure to inspect the tightness of the bolts that connected the flexible disk to the driveshaft, which resulted in the failure of these components.NTSB CEN13FA440Accident · No injuriesField investigationFinal reportPhelps Kitfox III · Oshkosh, WIThe degraded fuel line, which prevented fuel from the left tank from reaching the header tank and resulted in the loss of engine power due to fuel starvation.NTSB ERA13CA333Accident · Minor injuriesData collectionFinal reportMillhouse D Scott Kitfox II · Logan, WVThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and subsequent nose over. Contributing to the accident was the flight instructor’s inadequate supervision of the student.NTSB ERA13LA329Accident · Serious injuriesLimited investigationFinal reportKrips Jack E JR Kolb MK III · Fowler, NYThe pilot’s improper landing flare, which resulted in a nose-down collision with water.NTSB ERA13LA323Accident · Minor injuriesLimited investigationFinal reportJohnson Garret W Merlin GT · Collierville, TNThe total loss of engine power during takeoff for reasons that could not be determined during postaccident examination due to postcrash fire damage.NTSB WPR13LA363Accident · No injuriesLimited investigationFinal reportQuarnoccio Avid Flyer · White City, ORExcessive engine operating temperature, which resulted in engine failure and a forced landing. The reason for the excessive engine operating temperature could not be determined during postaccident engine examination.NTSB WPR13LA314Accident · Serious injuriesLimited investigationFinal reportLuy Wayman Lockwood Aircam · Groveland, CAThe pilot’s inadequate compensation for a crosswind and failure to maintain airplane control during a go-around.NTSB CEN13LA363Accident · No injuriesLimited investigationFinal reportThomsen Avid Flyer MK IV · Hibbing, MNA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA13CA277Accident · Minor injuriesData collectionFinal reportBoswell John J AIR CAM 912S · West Palm Beach, FLThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB CEN13CA230Accident · No injuriesData collectionFinal reportWing Harold Kitfox II · Blaine, MNThe pilot's improper touchdown and subsequent failure to maintain control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of experience in tailwheel-equipped airplanes.NTSB ERA13FA201Accident · 1 fatalField investigationFinal reportSchoonover John D KIT FOX IV 1200 · St. Lucie, FLThe pilot’s failure to maintain adequate airspeed during the turn to final, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s combined use of two sedating…NTSB ERA13LA198Accident · No injuriesLimited investigationFinal reportFranke Russell J Searey · Polk City, FLAn inadvertent encounter with the water wake from a larger amphibious airplane before takeoff and the pilot's subsequent inadequate preflight inspection of the airplane during which he failed to note damage caused by the wake encounter.NTSB CEN12LA655Accident · No injuriesLimited investigationFinal reportTL Ultralight Sro Stingsport · Longmont, COThe failure of the wood propeller blades in flight. Contributing to the accident was the owner/operator’s failure to complete required inspections on the propeller within the specified interval, which reduced the likelihood of detecting the cracks and may…NTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.NTSB CEN12CA574Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Centralia, ILThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB CEN12CA567Accident · No injuriesData collectionFinal reportFantasy Air Allegro 2000 · Bear Creek, WIA malfunction of the right brake for reasons that could not be determined because of the perishable evidence, which resulted in the pilot’s inability to maintain directional control of the airplane during landing.NTSB CEN12LA531Accident · No injuriesLimited investigationFinal reportRistine Avid Mark IV · Poplar Grove, ILThe failure of the lower right side longeron tail-spring support area during landing due to excessive corrosion.NTSB WPR12LA277Accident · 1 fatalLimited investigationFinal reportRehn Kitfox IV · Vancouver, WAThe pilot's failure to maintain airspeed during an attempt to return to the runway immediately after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was foreign debris in the right-hand carburetor bowl, which precipitated a loss…NTSB CEN12CA363Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · New Douglas, ILThe pilot’s improper landing flare and inadequate recovery from a bounced landing.NTSB CEN12CA329Accident · No injuriesData collectionFinal reportBrumbaugh B/Kasowski L Avid Flyer IV · Pryor, OKThe pilot's failure to maintain directional control during a high speed taxi.NTSB ERA12CA361Accident · No injuriesData collectionFinal reportLydon Patrick F Searey · Sanford, FLThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB CEN12LA307Accident · 1 fatalLimited investigationFinal reportDial David L Titan Tornado II · Checotah, OKThe noncertificated pilot's loss of airplane control while maneuvering during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s ostentatious display.NTSB CEN12LA302Accident · Serious injuriesLimited investigationFinal reportTroyer Kitfox 3 · Elm Creek, NEThe pilot’s failure to verify the amount of oil in the injection oil reservoir before takeoff, which resulted in an insufficient fuel/oil ratio and subsequent loss of engine power.NTSB ERA12CA302Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Lancaster, PAThe pilot's loss of directional control during the takeoff, and her delayed remedial action in aborting the takeoff after the loss of directional control.NTSB CEN12FA249Accident · Minor injuriesField investigationFinal reportHeiser Robert C JR Pulsar XP · San Angelo, TXThe loss of engine power due to fuel starvation as a result of a blocked fuel vent line.NTSB ERA12LA285Accident · Serious injuriesLimited investigationFinal reportWilloughby Pete A Streak Shadow · Salem, WVA total loss of engine power due to a piston seizure that resulted from a fuel system restriction and poorly secured fuel lines. Contributing to the accident were the pilot/builder’s failure to follow the engine manufacturer procedures and his use of…