NTSB investigations: Bombardier ROTAX (ALL), 1991
16 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 per year
| 1983 | 7 |
|---|---|
| 1984 | 7 |
| 1985 | 3 |
| 1986 | 7 |
| 1987 | 10 |
| 1988 | 8 |
| 1989 | 8 |
| 1990 | 15 |
| 1991 | 16 |
| 1992 | 27 |
| 1993 | 20 |
| 1994 | 16 |
| 1995 | 27 |
| 1996 | 20 |
| 1997 | 31 |
| 1998 | 35 |
| 1999 | 31 |
| 2000 | 32 |
| 2001 | 51 |
| 2002 | 39 |
| 2003 | 20 |
| 2004 | 22 |
| 2005 | 16 |
| 2006 | 22 |
| 2007 | 20 |
| 2008 | 16 |
| 2009 | 29 |
| 2010 | 21 |
| 2011 | 27 |
| 2012 | 17 |
| 2013 | 16 |
| 2014 | 10 |
| 2015 | 14 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 6 |
| 2019 | 10 |
| 2020 | 8 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 12 |
| 2024 | 8 |
| 2025 | 10 |
| 2026 | 5 |
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 year(c.\"eventDate\") = 1991
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'))
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 year(c."eventDate") = 1991
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'))
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 ATL92LA023Accident · No injuriesLimited investigationFinal reportGeorga L. Atwood Kitfox III · Trezevant, TNThe pilot's improper handling of the airplane which resulted in a noseover.NTSB NYC92DHJ01Accident · 1 fatalFinal reportChallenger II Bombadier · Moriches, NYA loss of control in flight due to a flight control malfunction for undetermined reasons.NTSB LAX92LA002Accident · No injuriesLimited investigationFinal reportCano Avid Flyer · Sonora, CAFuel starvation due to vapor lock.NTSB CHI91DCD03Accident · 2 fatalFinal reportTullis Tierra II · Ottumwa, IAFailure of the pilot to maintain control of the airplane during maneuvering flight.NTSB DEN91LA112Accident · No injuriesLimited investigationFinal reportLars Avid Flyer · Colorado Spring, COThe pilot's delay in flaring the airplane. Factors were: (1) stuck piston rings and (2) the pilot's failure to use flaps.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 SEA91LA174Accident · No injuriesLimited investigationFinal reportSchrader, Edward A · Nampa, IDA loss of engine power for undetermined reasons.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 SEA91LA153Accident · Minor injuriesLimited investigationFinal reportDerego Avid Flyer/B · Myrtle Creek, ORLoss of engine power for an undetermined reason.NTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.NTSB CHI91DCA01Accident · Serious injuriesFinal reportGremminger Kolb Twinstar · St. Genevieve, MOThe failure of the pilot to abort the takeoff and improper remedial action by the pilot rated passenger after assuming control of the airplane. A factor associated with the accident is the pilot losing directional control during the takeoff ground run.NTSB LAX91LA229Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-500M · Minden, NVAn engine failure produced as a result of the pilot improperly adjusting the carburetor mixture jet.NTSB NYC91DGT02Accident · Minor injuriesFinal reportKolb Twinstar · Williamsport, PAAn engine seizure as the result of overheating.NTSB CHI91DEM04Accident · No injuriesFinal reportFred B. Stencel Falcon X P · St. Charles, MIA result of the pilot in command not maintaining directional control during the go around maneuver. Factors associated with the accident were the pilot in command's lack of total experience and familiarity with the airplane.NTSB LAX91LA160Accident · No injuriesLimited investigationFinal reportBurnett, Jerry D. Challenger II · Bullhead City, AZThe disintegration of the propeller. Contributing to this accident was the deterioration of aircraft control and the nonavilability of suitable landing terrain.NTSB CHI91DEE03Accident · Minor injuriesFinal reportAir Command Gyrocopter · Lansing, ILThe pilot's delayed pullup. A factor in the accident was the pilot's exessive rate of descent during the spiral maneuver.