NTSB investigations: Bombardier ROTAX (ALL), 1996
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\") = 1996
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") = 1996
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 ATL97LA023Accident · Minor injuriesLimited investigationFinal reportPereyra Aventura II · Rockledge, FLThe loss of engine power for undetermined reasons.NTSB NYC96LA190Accident · No injuriesLimited investigationFinal reportBins Kitfox IV · Pittsfield, MAthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control, the airplane veering off the runway, and a subsequent nose over. The adverse wind condition and uneven terrain were related factors.NTSB ANC96LA147Accident · No injuriesLimited investigationFinal reportRans 7 · Anchorage, AKthe pilot's improper recovery from a bounced landing and failure to maintain control of the aircraft. A factor relatated to the accident was: the pilot's improper decision to continue the flight after he identified he was having difficulty landing the…NTSB FTW96LA372Accident · No injuriesLimited investigationFinal reportHardie KIT FOX XL · Monticello, ARthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA319Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA20-A1 · S. Lake Tahoe, CAThe pilot's inadequate use of the brakes, which resulted in loss of directional control while taxiing in a non-movement area.NTSB CHI96LA286Accident · Serious injuriesLimited investigationFinal reportSchuler T Bird II · Fond Du Lac, WIloss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.NTSB LAX96LA281Accident · No injuriesLimited investigationFinal reportGraham Falcon XP · Mesa, AZblockage of the fuel system vent in the fuel cap, when the pilot overtorqued the fuel cap during his preflight check, which restricted fuel flow to the engine. The pilot's lack of experience in the make and model of airplane was a related factor.NTSB NYC96LA153Accident · Serious injuriesLimited investigationFinal reportKolb Mark III · Gowanda, NYfailure of the pilot to properly flare the airplane during the landing.NTSB ANC96LA100Accident · No injuriesLimited investigationFinal reportHorton Avid Flyer MK IV · Tenakee Springs, AKThe pilot's inadequate compensation for wind conditions. Gusty winds were a factor in the accident.NTSB SEA96LA152Accident · No injuriesLimited investigationFinal reportHanks Avid Flyer · Spanish Fork, UTpartial loss of engine power for undetermined reason(s). A factor relating to the accident was: the tall grain crop that was encountered during the forced landing.NTSB LAX96LA258Accident · 1 fatalLimited investigationFinal reportDavis Challenger I CW · Paso Robles, CAthe owner/builder/pilot's impairment of judgment and performance due to drugs which led to his improper handling of the airplane and failure to maintain an adequate airspeed margin above stall speed, resulting in an inadvertent stall/spin. A factor which…NTSB CHI96LA215Accident · No injuriesLimited investigationFinal reportLoehle-Avia 5151RG · Fond Du Lac, WIthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the design/location of the fuel tank selector.NTSB SEA96LA110Accident · No injuriesLimited investigationFinal reportStelly Kolb Firestar II · Independence, ORfailure of the pilot to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. The aircraft's excessive gross weight was a related factor.NTSB ATL96LA087Accident · Serious injuriesLimited investigationFinal reportSky Star Kitfox #1 · Bridgeport, ALloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.NTSB CHI96LA176Accident · No injuriesLimited investigationFinal reportMerlin GT · Charlotte, MIthe pilot's failure to maintain airspeed. A factor was the pilot's lack of experience in the airplane.NTSB CHI96LA164Accident · No injuriesLimited investigationFinal reportSchlitter Rans S6ES Coyote II · Hays, KSfailure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.NTSB SEA96LA093Accident · Serious injuriesLimited investigationFinal reportCrescenzi Kitfox · Terrebonne, ORThe pilot's inadequate compensation for wind conditions and failure to maintain altitude/clearance above terrain, while maneuvering to land. The unfavorable wind was a related factor.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 MIA96LA087Accident · Serious injuriesLimited investigationFinal reportMarks Kitfox II · Panama City, FLthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve and subsequent collision with a ditch. Factors relating to the accident were: failure of the…NTSB CHI96LA084Accident · No injuriesLimited investigationFinal reportConnell Kitfox · Omaha, NEthe pilot's inadequate preflight of the aircraft and the frozen left landing gear wheel.