NTSB investigations: Rotax SEE BOMBADIER
182 cases on aircraft whose registry engine model is Rotax SEE BOMBADIER. 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 ('55555'))
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 ('55555'))
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 CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB NYC08LA235Accident · 1 fatalLimited investigationFinal reportLanier James A Talon XP · Cleveland, GAAn inadvertent stall during the initial climb.NTSB LAX08CA208Accident · No injuriesData collectionFinal reportPipistrel Virus 912 · Bend, ORThe pilot's improper flare, inadequate bounced landing recovery, and his failure to maintain directional control.NTSB DEN08LA109Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Von Ormy, TXThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing to the accident were a proper touchdown point was not possible and the inadequate display of the fuel quantity indicator.NTSB LAX08LA130Accident · Serious injuriesLimited investigationFinal reportGreco Drifter 912 · Homestead, FLThe pilot's failure to maintain adequate airspeed during a turn to the final approach leg of the traffic pattern, resulting in an accelerated stall.NTSB MIA08CA088Accident · Serious injuriesData collectionFinal reportWilliam E. Furr SeaRey · Winter Springs, FLThe pilot's inadequate preflight inspection of the airplane.NTSB NYC08FA158Accident · 1 fatalField investigationFinal reportChech Aircraft Works Spol Sro CH 601 XL RTF · Polk City, FLThe in-flight failure of the left wing for undetermined reasons.NTSB MIA08LA034Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Stevensville, MDA loss of engine power due to the failure of company maintenance personnel to comply with engine manufacturers requirements for carburetor adjustment during the 100-hour inspection.NTSB DEN08LA040Accident · 1 fatalLimited investigationFinal reportGarniss Stol 701 · Mesilla, NMThe pilot's failure to maintain aircraft control during an intentional low altitude maneuver due to impairment, resulting in the in-flight collision with terrain.NTSB LAX08CA022Accident · No injuriesData collectionFinal reportBagnall Harold E Kitfox Lite 2 · N. Bonneville, WAThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude that resulted in a stall-mush condition and collision with the water.NTSB DEN08CA001Accident · Serious injuriesData collectionFinal reportDegelia Rotor Flight Dynamic · Ashland, KYthe pilot's failure to maintain aircraft control during the landing flare resulting in a hard landing. Contributing factors were the crosswind and the pilot's failure to recover from a bounced landing.NTSB ATL07LA129Accident · 1 fatalLimited investigationFinal reportKolb MK II · Sweetwater, TNThe pilot's failure to maintain control of the airplane during climb.NTSB DEN07CA153Accident · Minor injuriesData collectionFinal reportJones Challenger II · Edgewood, NMThe loss of aircraft control after encountering a dust devil.NTSB SEA07FA240Accident · Serious injuriesField investigationFinal reportFlight Design Ctsw · St. George, UTThe loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DEN07FA136Accident · 2 fatalField investigationFinal reportZlin Aviation s.r.o. Savage · Mosquero, NMThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall. Contributing to the accident was the conflicting airspeed information provided by the manufacturer, the incorrect airspeed indicator markings, and the high density…NTSB DEN07CA107Accident · Minor injuriesData collectionFinal reportTruitt Peter Zenair CH 701SP · Mountain View, WYThe pilot's failure to maintain aircraft control during cruise flight resulting in an impact with terrain. Contributing factors were the wind gust and high density altitude.NTSB LAX07LA148Accident · 2 fatalLimited investigationFinal reportHill Europa XS · Livermore, CAthe loss of engine power for an undetermined reason during the initial climb, and the pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in a stall/spin.NTSB NYC07CA127Accident · Minor injuriesData collectionFinal reportWroblewski Searey · Freeport, PAThe pilot's improper flare, which resulted in a nose over while attempting to land on a river. A factor in this accident was the glassy water landing conditions.NTSB ATL07CA082Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Fort Meade, MDThe student pilot's inadequate compensation for the gusty wind conditions during the landing flare, resulting in a loss of control, and an in-flight collision with terrain. A factor associated with the accident was the wind gusts.NTSB MIA07CA078Accident · Serious injuriesData collectionFinal reportRobert J. Goodyear Hummel Bird · Lakeland, FLThe pilot's failure to maintain airspeed during a go-around.NTSB LAX07LA075Accident · Minor injuriesLimited investigationFinal reportJihlavan KP-5 · Moorpark, CAa partial loss of power for undetermined reasons.NTSB NYC07CA057Accident · No injuriesData collectionFinal reportFoley James Searey · Danbury, CTCollapse of the left main landing gear due to previous damage. A factor in the accident was the inadequate annual condition inspection.NTSB MIA07CA027Accident · Serious injuriesData collectionFinal reportRichard F. Sheldon Aventura II · Palm Beach Gard, FLThe pilot's failure maintain the proper airspeed during takeoff, which resulted in a stall.NTSB ATL07LA025Accident · 2 fatalLimited investigationFinal reportFagan Rans S-6S · Taylorsville, NCThe pilots failure to maintain airspeed while maneuvering resulting in an inadvertent stall, uncontrolled decent, collision with the ground, and a post crash fire.NTSB DFW07LA032Accident · 2 fatalLimited investigationFinal reportNoble Vans RV-7A · Norman, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.NTSB DFW07LA026Accident · 2 fatalLimited investigationFinal reportKeesler Pulsar · Alvarado, TXThe pilot's improper handling of the airplane while manuevering at a low altitude, which resulted in an inadvertant stall.NTSB LAX07CA042Accident · No injuriesData collectionFinal reportPippert Zenith CH-701 · Yerington, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain both directional and pitch control.NTSB LAX07LA032Accident · 2 fatalLimited investigationFinal reportKolb MK III · Paulden, AZfailure of the pilot to maintain an adequate airspeed that led to a stall/spin.NTSB NYC07FA025Accident · 1 fatalField investigationFinal reportCzech Aircraft Works CH 601 XL RTF · Basye, VAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB LAX07LA017Accident · 2 fatalLimited investigationFinal reportWilson Quicksilver Sport 2S · Buckeye, AZFailure of the pilot to maintain adequate clearance from obstacles.NTSB DFW07LA010Accident · No injuriesLimited investigationFinal reportTaylor Zodiac 601 · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC06LA220Accident · Serious injuriesLimited investigationFinal reportFlight Design Ctsw · Tunkhannock, PAThe pilot's improper recovery from a bounced landing.NTSB CHI06FA196Accident · 2 fatalField investigationFinal reportShaw Europa XS · Oshkosh, WIThe pilot's failure to maintain adequate airspeed on final approach which resulted in a stall.NTSB LAX06LA236Accident · Serious injuriesLimited investigationFinal reportHammack Air Command Elite · Hilo, HIan in-flight separation of a control rod joint assembly, which resulted in the pilot's loss of control. The underlying reason for the separation could not be determined.NTSB CHI06LA178Accident · 1 fatalLimited investigationFinal reportMoon Rans S-14 · Berlin, ILThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB ANC06LA087Accident · Minor injuriesLimited investigationFinal reportKennedy Chinook Plus 2 · Willow, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall during takeoff/initial climb, which resulted in an uncontrolled descent and collision with trees. A factor associated with the accident was an inadvertent stall.NTSB NYC06CA146Accident · Serious injuriesData collectionFinal reportTheordore Jankowski Rans S-12 · Caribou, METhe pilot's failure to maintain directional control which resulted in a subsequent impact with trees. A factor in the accident was the unmowed area of vegetation.NTSB NYC06CA135Accident · Minor injuriesData collectionFinal reportFlight Design Gmbh · Leesburg, VAThe pilot's improper remedial action to regain directional control after takeoff. A factor was the pilot's failure to maintain directional control after takeoff.NTSB CHI06CA142Accident · No injuriesData collectionFinal reportStys T-Bird Sport · West Bend, WIThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed which resulted in a stall.NTSB CHI06LA119Accident · 1 fatalLimited investigationFinal reportWoods Skyboy Quick Kit · Huntington, INThe flight's impact with terrain while maneuvering due to undetermined reasons.NTSB ATL06CA066Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Shelbyville, TNThe pilot's inadequate in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion.NTSB MIA06LA078Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Parrot · Palm City, FLThe failure of the pilot-in-command to abort the takeoff after recognizing the engine was not developing full power during the takeoff roll. A contributing factor in the accident was the bending of the throttle cables which prevented full movement of the…NTSB DFW06CA092Accident · No injuriesData collectionFinal reportWaterwings SeaRey · Vicksburg, MSThe pilot's inadvertent reduction of power resuting in a collision with water. Contributing factors were the low altiude selected and the pilot's inattention.NTSB ATL06CA055Accident · No injuriesData collectionFinal reportUrban Air UFM-10 · Lancaster, SCThe pilot's excessive climb angle during a go-around from a bounced landing which resulted in an inadvertent stall and subsequent in-flight collision with trees.NTSB MIA06CA129Accident · No injuriesData collectionFinal reportTharp S Richard Challenger II · Apopka, FLThe pilot's inadequate selection of a landing area which resulted in one of the seaplane's floats impacting a submerged stump.NTSB LAX06CA074Accident · No injuriesData collectionFinal reportAvid Mark IV · California City, CAthe pilot's inadequate compensation for the crosswind and failure to maintain directional control of the airplane on takeoff.NTSB CHI06CA050Accident · Minor injuriesData collectionFinal reportElliott Quad City Ultralight Challenger II · California, MOThe pilot's failure to maintain aircraft control due to his failure to comply with procedures/directives, and the inadvertent stall/spin he encountered on his turn to base.NTSB SEA06CA023Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries HK 36 TTC · Sandpoint, IDExcessive speed for the landing roll and inadequate remedial action for the initial takeoff. An object near the end of the runway and snow covered surface were factors.NTSB ATL05LA140Accident · 2 fatalLimited investigationFinal reportAllegro 2000 · Supply, NCThe instructor pilot's failure to maintain airspeed for unknown reasons, resulting in an aerodynamic stall and subsequent collision with the ground.