Fatal NTSB investigations: Bombardier ROTAX (ALL)
46 cases on aircraft whose registry engine model is Bombardier ROTAX (ALL), where the first occurrence 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 5 |
| 1999 | 4 |
| 2001 | 3 |
| 2002 | 5 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
Where
Latest 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.\"highestInjuryLevel\" = 'Fatal'
AND 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."highestInjuryLevel" = 'Fatal'
AND 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 LAX07LA156Accident · 2 fatalLimited investigationFinal reportTeague Rans S-6ES Coyote II · Nyssa, ORLoss of aircraft control while maneuvering for undetermined reasons.NTSB LAX06LA170Accident · 1 fatalLimited investigationFinal reportSchlitter Rans S-18 Stinger · Llano, CAan in-flight loss of control and collision with terrain for undetermined reasons.NTSB IAD05LA089Accident · 1 fatalLimited investigationFinal reportLongtin Kitfox Model III · New London, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.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 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 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 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 DEN02LA109Accident · 2 fatalLimited investigationFinal reportSabian Rans S-12XL · Mexican Hat, UTthe pilot's inadequate in-flight planning and decision making (flying up a canyon with insufficient altitude) which resulted in an inadvertent stall/mush, and the pilot's failure to follow the proper emergency procedures for activating his Ballistic Recovery…NTSB LAX02LA155Accident · 1 fatalLimited investigationFinal reportMueller Skyraider 1 · Elko, NVthe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB FTW02LA134Accident · 1 fatalLimited investigationFinal reportRobinson Tierra II · Hooker, OKthe loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.NTSB ATL02LA092Accident · 1 fatalLimited investigationFinal reportHartman Buccaneer 2 · Estero Bay, FLThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI02LA062Accident · 1 fatalLimited investigationFinal reportWolter Avid Flyer · Rush City, MNThe unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.NTSB ATL02LA009Accident · 1 fatalLimited investigationFinal reportBass Moni · Locust Grove, GAThe pilot's failure to maintain airspeed during a low-altitude aerobatic maneuver, which resulted in an inadvertent stall/spin and subsequent uncontrolled descent into terrain.NTSB MIA02LA014Accident · 2 fatalLimited investigationFinal reportRans S-6 · Wyatte, MSthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with trees, while at a low altitude.NTSB ATL01LA077Accident · 1 fatalLimited investigationFinal reportKenneth West ARV 582 · Sebring, FLThe pilot's failure to maintain flying speed, followed by a subsequent inadvertent stall spin.NTSB NYC99LA208Accident · 2 fatalLimited investigationFinal reportKlotz Kolb Mark III · Scott, OHThe pilot's failure to maintain airspeed, which resulted in a stall, after he experienced a loss of lift due to an improperly installed gap seal.NTSB MIA99LA223Accident · 1 fatalLimited investigationFinal reportArnet Pereyra Aero Aventura II · Rockledge, FLThe pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.NTSB MIA99LA149Accident · 2 fatalLimited investigationFinal reportR.O. and D.O Hewitt Kitfox IV-1200 · Kannapolis, NCThe failure of the pilot-in-command to maintain airspeed and the inadvertent stall resulting in the uncontrolled descent with terrain. A factor in the accident was the impairment of the pilot by drugs (tetrahydrocannabinol).NTSB NYC99FA096Accident · 1 fatalField investigationFinal reportSellors Searey · Selby Beach, MDThe pilot's failure to maintain aircraft control during the landing sequence, which resulted in the airplane contacting the water in a nose low attitude.NTSB MIA99LA022Accident · 1 fatalLimited investigationFinal reportFerguson Rans S-10 Sakota · Pisgah, MSThe pilot's failure to maintain aircraft control during a low altitude maneuver resulting in the aircraft's uncontrollable descent until impact with the terrain.NTSB FTW99LA007Accident · 1 fatalLimited investigationFinal reportPainton Loehle Aviation 5151 · Osceola, ARThe pilot's failure to maintain aircraft control due to incapacitation as a result of hypertensive arteriosclerotic cardiovascular disease.NTSB CHI98LA142Accident · 1 fatalLimited investigationFinal reportBombardier Rans S-9 · Waukee, IAthe pilot's failure to maintain control of the airplane which resulted in a stall while performing intentional buzzing maneuvers.NTSB MIA98LA141Accident · 1 fatalLimited investigationFinal reportStar-Lite Engineering Warp 1A · Lakeland, FLthe pilot's failure to maintain airspeed, while maneuvering on crosswind in the traffic pattern, which resulted in an inadvertent stall, and an in-flight collision with a building and the terrain. Factors relating to the accident were: the pilot's decision to…NTSB CHI98LA120Accident · 2 fatalLimited investigationFinal reportRodgers Raven · Brandt, SDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor contributing to this accident was the pilot's lack of experience in the airplane.NTSB CHI97LA231Accident · 1 fatalLimited investigationFinal reportStratton Challenger II · Bellaire, MIfailure of the pilot to maintain control of the airplane during takeoff. The gusty wind condition was a related factor.NTSB NYC97LA116Accident · 1 fatalLimited investigationFinal reportGoodwin Rans S-4 · Cedar Bluff, VAThe pilot's failure to maintain airspeed during the initial takeoff climb which resulted in an inadvertent stall. A related factor was the pilot's lack of familiarity with the airplane.NTSB FTW96LA155Accident · 1 fatalLimited investigationFinal reportDomaille Rans S-12 · Albuquerque, NMthe student pilot's failure to maintain control of the aircraft after initiating a flight into adverse weather conditions. The strong, gusting wind was a factor.NTSB MIA96LA042Accident · 2 fatalLimited investigationFinal reportOtis King COBRA-B · Newberry, FLan in-flight loss of control for undetermined reasons.NTSB MIA96LA004Accident · 1 fatalLimited investigationFinal reportLouks Pulsar XP · Inverness, FLPremature rotation by the pilot during takeoff, which resulted in an inadvertent stall/mush, while attempting to accelerate in ground effect after lift-off.NTSB SEA96LA001Accident · 1 fatalLimited investigationFinal reportRasmussen Kitfox 2 · Battle Ground, WAfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall/mush and subsequent collision with trees and the ground.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 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 FTW93FA138Accident · 1 fatalField investigationFinal reportSnobird 532 · Early, TXThe pilot's inadvertent porpoise. A factor was the improperly adjusted trim springNTSB DEN93LA007Accident · 1 fatalLimited investigationFinal reportMarcy Kitfox IV · Longmont, COAn inadvertent stall. A factor was: the pilot's lack of familiarity with the airplane.NTSB CHI92DCD05Accident · 1 fatalFinal reportRutter 532 Commander · Washburn, IAFailure of the pilot to maintain control of the gryocopter during initial climb.NTSB FTW92DPG01Accident · 1 fatalFinal reportWind Ryder · Little Rock, ARA loss of control for undetermined reason(s).NTSB NYC92DHJ01Accident · 1 fatalFinal reportChallenger II Bombadier · Moriches, NYA loss of control in flight due to a flight control malfunction for undetermined reasons.NTSB CHI91DCD03Accident · 2 fatalFinal reportTullis Tierra II · Ottumwa, IAFailure of the pilot to maintain control of the airplane during maneuvering flight.NTSB SEA91LA202Accident · 1 fatalLimited investigationFinal reportTaylor Air Command 532 Elite · Libby, MTLoss of control during takeoff due to the pilot's total lack of experience in the type of aircraft.NTSB MIA91LA185Accident · 1 fatalLimited investigationFinal reportDonald R. Lee AIR Command · Quitman, MSThe pilot in commands failure to maintain control resulting in an uncontrolled descent and an in flight collision with terrain.NTSB FTW90DRA07Accident · 1 fatalFinal reportBensen B-8M · Hearne, TXThe pilot's loss of control in flight due to excessive control inputs and his abrupt attempts to recover control of the aircraft prior to impact.NTSB MIA90FA102Accident · 1 fatalField investigationFinal reportFarrington AIR Command 532 · Okeechobee, FLPilot's decision to attempt to fly the gyrocopter without proper training resulting in the inflight loss of control and subsequent crash.NTSB NYC88DFA02Accident · 1 fatalFinal reportTerry Tierra II · Plattsburgh, NYAccording to witnesses, the plt was on his 2nd flt of the day in a recently purchased ultralight type of acft. They rprtd that after the acft took off from rwy 32, it climbed to about 300' AGL & rolled into a steep right bank. Its nose then dropped & the acft…NTSB MKC87FA148Accident · 1 fatalField investigationFinal reportWatts 532 Elite · Davenport, IAWitnesses located 1/4 mi north of the accident site, observed the gyrocopter departing the Davenport, IA airport and turning to the southwest. While in cruise flight the witnesses observed the aircraft moving in an up and down motion prior to what appeared to…NTSB FTW85FRD02Accident · 1 fatalFinal reportTeratorn Tierra II · Lake Charles, LAThe acft impacted the terrain in an uncontrolled descent. Witnesses stated the acft was participating in a bean bag drop contest when the accident occurred. After dropping the last bag the acft made a turn to the west, entered a spin and descended to ground…