NTSB investigations: Bombardier ROTAX (ALL)
54 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the defining event was Loss of control in flight. 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 per year
| 2008 | 5 |
|---|---|
| 2009 | 8 |
| 2010 | 5 |
| 2011 | 12 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 3 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
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 WPR26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportRans S7 · Kemmerer, WYThe pilot’s decision to perform a take-off in high-density-altitude, gusting-crosswind conditions, which resulted in an aerodynamic stall, hard landing and subsequent nose-over.NTSB CEN25LA383Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Crystal Mountain, MIThe pilot’s failure to maintain aircraft control during initial climb.NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB WPR24FA284Accident · 1 fatalClass 3 · FieldPreliminary reportLockwood AIR CAM · Minden, NVOn August 20, 2024, about 0819 Pacific daylight time, an experimental amateur-built Lockwood Air Cam, N2412Y, was substantially damaged when in was involved in an accident at the Minden-Tahoe Airport, Minden, Nevada. The pilot was fatally injured, and the…NTSB ERA24LA349Accident · No injuriesClass 4 · LimitedFinal reportSmith T Gunter Quick Silver SP II · Mobile, ALThe pilot’s failure to maintain control of the airplane in gusty wind conditions while flying low over water, which resulted in the floats impacting a wave and the airplane’s subsequent nose over into the water.NTSB WPR23LA243Accident · No injuriesClass 3 · LimitedFinal reportKitfox 2 · Cave Junction, ORThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB WPR22LA310Accident · Serious injuriesClass 3 · LimitedFinal reportStucker Gary Banty · Camarillo, CAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN21LA425Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Mark III · Steamboat Springs, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN21LA292Accident · Minor injuriesClass 4 · LimitedFinal reportCurnutt Elton E SKY Ranger B · Ellicott, COThe pilot’s loss of control while maneuvering at low altitude.NTSB CEN20CA177Accident · Minor injuriesClass 4 · Data collectionFinal reportM-Squared Sport 1000 · Little Falls, MNThe uncertificated pilot's failure to maintain aircraft control during takeoff, which resulted in an impact with terrain.NTSB ERA18LA134Accident · 1 fatalLimited investigationFinal reportStanley Ernie Sigurd Kolb Mark · Collegedale, TNThe pilot's loss of airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to take off in the nonairworthy airplane in which he had no training and his lack of flight experience in the 17…NTSB CEN16LA363Accident · Serious injuriesLimited investigationFinal reportCGS Hawk Aero II · Holland, MIThe improper installation of quick release connectors in the fuel lines, which was not in accordance with the engine manufacturer's maintenance instructions and allowed air to be introduced into the fuel system and resulted in a partial loss of engine power.…NTSB CEN16LA293Accident · No injuriesLimited investigationFinal reportBoam Larry Rans S 7 · Oshkosh, WIThe pilot's failure to maintain airplane control on takeoff, which resulted in his remedial action to induce an aerodynamic stall and the subsequent impact with terrain.NTSB CEN16FA209Accident · 1 fatalField investigationFinal reportPruss Richard S Kitfox IV · De Smet, SDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack during a steep turn at a low altitude, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.NTSB ERA16LA068Accident · 1 fatalLimited investigationFinal reportMccorkle Robert B Rans S-12 Airaile · Benton, TNThe pilot's failure to maintain airplane control during the initial climb, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin.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 CEN14LA281Accident · Serious injuriesLimited investigationFinal reportOffchiss Edward R Avid Flyer · Lamoni, IAThe student pilot’s failure to maintain control of the airplane while landing.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 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 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 ERA12FA194Accident · 2 fatalField investigationFinal reportStrout Frank Aventura II · Laceys Spring, ALThe pilot's failure to maintain control of the airplane during a low-altitude maneuver. Contributing to the accident was the pilot's lack of the required rating to operate the airplane.NTSB ERA12FA107Accident · 1 fatalField investigationFinal reportShaw Douglas Wayne Rans S 7 · Somerville, TNThe pilot's incapacitation due to a ruptured berry aneurysm during takeoff.NTSB CEN12LA102Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Festus, MOThe certified flight instructor’s delayed remedial action as the airplane neared an aerodynamic stall/spin. Contributing to the accident was that the student pilot did not maintain adequate airspeed during the go-around attempt.NTSB WPR12FA001Accident · 2 fatalField investigationFinal reportVaughn Pulsar · West Jordan, UTThe pilot’s failure to maintain sufficient airspeed and airplane control while initiating a turn during the initial climb after takeoff in a high density altitude environment, above the airplane’s maximum allowable gross weight, and with an overly rich…NTSB ERA12CA013Accident · Minor injuriesData collectionFinal reportLoehle Loehle P-40 · Tullahoma, TNThe pilot's delayed decision to abort the takeoff.NTSB CEN11LA415Accident · Serious injuriesLimited investigationFinal reportBins Tom Kitfox IV · Lafayette, LAThe pilot’s loss of control during a forced landing after a loss of engine power for undetermined reasons during takeoff.NTSB CEN11LA623Accident · 1 fatalLimited investigationFinal reportHoffmann HK36R Super Dimona · Winsted, MNThe pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB ERA11FA463Accident · 1 fatalField investigationFinal reportQuad City Ultralight Challenger II · Ransom Township, PAThe non-certificated pilot's failure to maintain aircraft control while maneuvering, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot's lack of overall flight experience and lack of experience in the same make…NTSB CEN11LA549Accident · No injuriesLimited investigationFinal reportAerosport Ikarus C42E · East Troy, WIThe flight instrctor's delayed remedial action during landing. Contributing to the accident was the student pilot’s loss of directional control when he became distracted with the open door.NTSB CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.NTSB ERA11LA336Accident · Serious injuriesLimited investigationFinal reportMarks Ca III Kitfox II · Scarborough, METhe pilot’s failure to maintain control of the airplane while taking off with a gusting wind.NTSB CEN11FA319Accident · 1 fatalField investigationFinal reportThomas Europa · Shreveport, LAThe loss of aircraft control and subsequent impact with terrain for undetermined reasons.NTSB WPR11LA183Accident · 1 fatalLimited investigationFinal reportTomei S12 XL · Pleasant Grove, CAThe pilot’s failure to allow the airplane’s engine to properly warm up before applying takeoff power, which resulted in the forward cylinder's piston seizing and a subsequent loss of engine power. Also causal was the pilot's failure to maintain an adequate…NTSB CEN11LA012Accident · 1 fatalLimited investigationFinal reportNewmann Edward W Challenger II · Easton, KSThe pilot’s failure to maintain control of the airplane for undetermined reasons.NTSB CEN10CA294Accident · No injuriesData collectionFinal reportHolden Frank Joseph Rans S6ES · Waxahachie, TXThe pilot's failure to attain adequate airspeed during takeoff, resulting in a stall/msuh.NTSB CEN10CA249Accident · Minor injuriesData collectionFinal reportQuicksilver GT-500 · Big Lake, TXThe pilot's loss of control when the airplane unexpectedly encountered a downdraft shortly after takeoff.NTSB ERA10CA185Accident · Serious injuriesData collectionFinal reportShaw Fisher FP 404 · Lillian, ALThe pilot’s inadequate weather evaluation and failure to maintain directional control during takeoff in gusty wind conditions.NTSB CEN10LA165Accident · 1 fatalLimited investigationFinal reportWalsh Philip J SEA REY · Huntsville, ARThe pilot's loss of airplane control for undetermined reasons.NTSB CEN10LA049Accident · 1 fatalLimited investigationFinal reportLockwood AIR-CAM · Mount Victory, OHThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot's unfamiliarity with the airplane subsequent to float installation.NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.NTSB ERA09LA500Accident · 1 fatalLimited investigationFinal reportBlum Matthew Aventura II · Boca Raton, FLThe improper assembly of both carburetors, resulting in an excessively rich fuel to air ratio and subsequent partial loss of engine power.NTSB WPR09FA409Accident · 1 fatalField investigationFinal reportStemme S10-VT · Mackay, IDThe pilot's failure to maintain adequate airspeed while maneuvering in terrain-induced turbulent wind conditions, resulting in an inadvertent entry into a stall/spin.NTSB CEN09LA312Accident · 2 fatalLimited investigationFinal reportNorthwing Design Apache Sport · Fredericksburg, TXThe loss of aircraft control for undetermined reasons.NTSB ERA09CA285Accident · No injuriesData collectionFinal reportRichard Rank KitFox 4 · Madison, MSThe pilot’s failure to maintain aircraft control during an aborted formation takeoff.NTSB CEN09LA255Accident · 1 fatalLimited investigationFinal reportWhitehead Titan · Slaughter, LAThe pilot's incorrect use of pitch control, resulting in induced pitch oscillations and loss of aircraft control. Contributing to the accident were the pilot's total lack of experience in aircraft make/model, and his lack of recency of experience.NTSB WPR09CA183Accident · No injuriesData collectionFinal reportDenny Aerocraft Kitfox III · Oakdale, CAThe pilot's inadequate compensation for the crosswind conditions.NTSB ERA09CA101Accident · Minor injuriesData collectionFinal reportSteven G Goonen Searey · Polkland, FLA loss of control during the initial climb for undetermined reasons.