NTSB investigations: Bombardier ROTAX (ALL), 1993
20 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\") = 1993
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") = 1993
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 CHI94DEP01Accident · No injuriesFinal reportKrotje Kolb Mark III · Oshkosh, WIThe lack of carburetor heat for the engine. A factor related to the accident was: the weather condition, which was favorable for formation of carburetor ice.NTSB SEA94LA021Accident · Serious injuriesLimited investigationFinal reportHannah Avid Amphibian · Scappoose, ORThe pilot's poor inflight decision, and failure to maintain sufficient airspeed. Factors include contaminated fuel.NTSB NYC94LA008Accident · 1 fatalLimited investigationFinal reportFeatherston Titan Tornado · Mechanicsville, VAFailure of the pilot to correct the descent. Factors related to the accident were: the light conditions at dusk, impairment of the pilot from use of a medication (prescription drug), and possible lack of visual ques (pilot's visual perception).NTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.NTSB BFO93LA166Accident · Minor injuriesLimited investigationFinal reportWilson KIT FOX Model 4 · Bowdoinham, MELoss of engine power for an undetermined reason.NTSB FTW93LA256Accident · No injuriesLimited investigationFinal reportJones Dominator · Magnolia, ARTotal loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.NTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.NTSB CHI93DEP04Accident · No injuriesFinal reportJordi, Ronald H. Challenger II · Plymouth, WIthe loss of engine power for undetermined reason(s).NTSB MIA93LA175Accident · Serious injuriesLimited investigationFinal reportRotec Engineering Rotec Rally 3 · Jay, FLFailure of the pilot in command to maintain airspeed (vs), inadvertent stall/mush by the pilot in command, and altitude insufficient for recovery. Contributing to the accident was lack of total experience by the pilot in command and in flight encounter with…NTSB FTW93LA233Accident · Minor injuriesLimited investigationFinal reportAero Falcon Intl. Knight Falcon · Mineral Wells, TXFailure of the autopilot which resulted in an improper flight control condition. A factor was the pilot's inability to regain control.NTSB CHI93DEP03Accident · No injuriesFinal reportKit Fox IV · Green Bay, WIthe improper modification of the fuel system by the pilot-in-command. A factor was bockage of the fuel system screen.NTSB FTW93LA262Accident · No injuriesLimited investigationFinal reportZbacnick Challenger II · Alamogordo, NMThe seizure of the propeller shaft bearing and the resultant propeller blade separation. Factors were the unfavorable winds and the lack of suitable terrain available for the forced landing.NTSB BFO93LA123Accident · 1 fatalLimited investigationFinal reportRolando Rans S-10 · Numidia, PAThe excessive maneuver attempted by the pilot which resulted in a loss of control in flight and an inadvertent spin at an altitude insufficient for recovery.NTSB MIA93LA128Accident · No injuriesLimited investigationFinal reportJohn Shufflebarger Zenair Zodiak · Lakeland, FLThe failure of the pilot-in-command to maintain airspeed after separation of the canopy, resulting in the aircraft entering a stall/mush condition and descending uncontrolled to the ground. Contributing to the accident was the failure of the pilot-in-command…NTSB NYC93LA094Accident · Minor injuriesLimited investigationFinal reportSteven Kurtis Rand S 12 · E Stroudsburg, PAA forced landing in trees as a result of a complete loss of engine power for unknown reasons.NTSB FTW93FA138Accident · 1 fatalField investigationFinal reportSnobird 532 · Early, TXThe pilot's inadvertent porpoise. A factor was the improperly adjusted trim springNTSB FTW93LA136Accident · Minor injuriesLimited investigationFinal reportTuttle Star Lite · Conroe, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landingNTSB SEA93LA076Accident · No injuriesLimited investigationFinal reportBarr Kitfox II · Sheridan, WYA partial power loss for undetermined reasons. Factors include a strong crosswind on landing.NTSB LAX93LA143Accident · No injuriesLimited investigationFinal reportE.L. Erickson Tierra II · Rio Linda, CAThe flight's encounter with a downdraft. A factor relating to this accident was the trees.NTSB FTW93LA078Accident · No injuriesLimited investigationFinal reportRans S-7 · Lancaster, TXAircraft control not maintained by pilot. Turbulence due to strong, gusty winds was a factor