Fatal NTSB investigations: Bombardier ROTAX (ALL), 2001
12 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
| 1984 | 2 |
|---|---|
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 4 |
| 1990 | 6 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 12 |
| 2002 | 10 |
| 2003 | 6 |
| 2004 | 4 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 2001
AND 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'))
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") = 2001
AND 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'))
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 MIA02LA042Accident · 1 fatalLimited investigationFinal reportFerguson A 26 Vulcan SS · Newnan, GAThe pilot's failure to maintain directional control during landing and go-around, resulting in a collision with a runway perimeter fence pole and trees.NTSB MIA02LA022Accident · 1 fatalLimited investigationFinal reportRobert N. Gilmore Rans S-10 · Oneonta, ALThe failure of the pilot to maintain airspeed following loss of engine power resulting in the airplane stalling and entering a spin from which it crashed. Factors in the accident was improper repair of the front cylinder intake manifold seal by the pilot…NTSB CHI02LA037Accident · 1 fatalLimited investigationFinal reportVermeys T-Bird II · Sherburn, MNThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.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 NYC02LA019Accident · 2 fatalLimited investigationFinal reportNorton/Cloeren Titan Tornado II · New Windsor, MDLoss of power for an undetermined reason.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 ATL01LA097Accident · 1 fatalLimited investigationFinal reportTroy A. Woodland Sky Raider II · NewSmyrna Beach, FLThe pilot's failure to maintain airspeed while performing an emergency maneuver, resulting in a stall and an uncontrolled descent, and the subsequent collision with terrain. A factors was, the loss of engine power for undetermined reasons.NTSB NYC01LA209Accident · 2 fatalLimited investigationFinal reportDominiak Kitfox · Byron, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the physiological impairment of the pilot due to the consumption of alcohol.NTSB CHI01LA237Accident · 1 fatalLimited investigationFinal reportVeith Kolb Sling Shot · Goodview, MNThe loss of engine power due to fuel starvation caused by a blocked, unsecured, fuel vent line. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall at a low…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 DEN01FA105Accident · 2 fatalField investigationFinal reportSchempp-Hirth Nimbus-3DM · Alamogordo, NMThe flight crew's inadequate in-flight planning to fly over the mesa with insufficient altitude. A contributing factor was the downdraft weather conditionNTSB LAX01LA153Accident · 1 fatalLimited investigationFinal reportHolt Christian Eagle II · White Water, CAThe pilot's failure to maintain an adequate clearance from the power lines during an intentional low level flight.