NTSB investigations: Bombardier ROTAX (ALL), 1994
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\") = 1994
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") = 1994
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 MIA95LA036Accident · Serious injuriesLimited investigationFinal reportColvin Kitfox II · Fort Pierce, FLThe failure of the pilot to abort the takeoff when he encountered water on the grass runway.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 LAX95LA023Accident · No injuriesLimited investigationFinal reportGlen A. Senecal 5151 · Apple Valley, CAthe manufacturer's (owner/operator) improper balancing of the aileron flight controls which resulted in a cable separation due to overload from the aileron flutter. The rough/uneven terrain was also a factor.NTSB NYC95LA016Accident · No injuriesLimited investigationFinal reportAngel Avid/Heavy Hauler · Sutton, MAThe pilot's failure to maintain the fuel selector on the proper position.NTSB SEA94LA241Accident · No injuriesLimited investigationFinal reportOestreich Avid Flyer MK IV · Moses Lake, WAProper descent rate was exceeded. Lack of total experience in type operation was a factor.NTSB MIA94LA213Accident · 1 fatalLimited investigationFinal reportRans S-12 Airaile · Clearwater, FLThe loss of engine power for undetermined reasons.NTSB CHI94LA302Accident · Minor injuriesLimited investigationFinal reportFrith Challenger II · Fairfield, IAthe total failure and separation of the propeller system drive belt. Obstacles (powerlines and pole) were a factor in the accident.NTSB BFO94LA152Accident · Minor injuriesLimited investigationFinal reportA. Le Francois Rans S-7 · Palmer, MAThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed.NTSB FTW94LA277Accident · No injuriesLimited investigationFinal reportHodges P-51-51 · Beaumont, TXThe improper adjustment of the propeller system pitch.NTSB CHI94FA258Accident · Minor injuriesField investigationFinal reportKeuthan, Charles J. Buccaneer II · Oshkosh, WIthe pilot's inadvertent stall of the airplane. Factors were the tailwind condition and the pilot's inadequate compensation for the tailwind.NTSB ANC94LA095Accident · No injuriesLimited investigationFinal reportStarman Teirra II · North Pole, AKThe seizure of the no. 2 cylinder as a result of an inadequate cooling system for the high ambient temperature.NTSB CHI94LA270Accident · No injuriesLimited investigationFinal reportMiller Kitfox · Spencer, INthe private pilot/airplane builder's failure to maintain adequate clearance from obstacles during the approach to landing.NTSB NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.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 FTW94LA135Accident · No injuriesLimited investigationFinal reportSavage Kitfox · Longmont, COThe pilot's failure to maintain directional control.NTSB SEA94LA160Accident · No injuriesLimited investigationFinal reportNewgard Kitfox III · Yelm, WAFuel starvation due to an inadequately installed fuel line.