NTSB investigations: Bombardier ROTAX (ALL), 2004
22 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\") = 2004
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") = 2004
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 SEA05LA016Accident · Minor injuriesLimited investigationFinal reportHannah Avid Amphibian · Creswell, ORCarburetor icing and the failure of the pilot to maintain airspeed which resulted in a stall. Factors contributing to the accident included the lack of a carburetor heat system and the probability of carburetor ice.NTSB CHI05CA025Accident · No injuriesData collectionFinal reportJabat Avid Flyer · Cleveland, MOThe separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.NTSB ATL05LA020Accident · Serious injuriesLimited investigationFinal reportFranzreb Loehle 5151 Mustang · Athens, TNThe loss of engine power due to the electrical fuel pump failure, and fuel starvation.NTSB MIA05LA015Accident · Serious injuriesLimited investigationFinal reportDavid Cadorette Fox Model II · Vero Beach, FLLoss of engine power, for undetermined reasons, resulting in the airplane impacting with a tree and the ground during the subsequent forced landing.NTSB ATL04CA191Accident · Serious injuriesData collectionFinal reportPinkham Challenger II · Lancaster, SCA partial loss of engine power in-flight due to water ingestion and his misjudgment of obstacle clearance resulting in a collision with trees and the ground. A factor in the accident was the pilot's failure to follow the manufactures instructions for…NTSB IAD04LA046Accident · 1 fatalLimited investigationFinal reportScott Rans S-12 · Seneca, NYThe student pilot's failure to maintain airspeed above stall speed, which resulted in an inadvertant stall/spin. A factor in the accident was the pilot's lack of pilot certification.NTSB LAX04CA306Accident · No injuriesData collectionFinal reportQuicksilver MXL II · Rio Vista, CAthe pilot's failure to maintain adequate clearance from high vegetation while flying at a low altitude.NTSB ATL04LA171Accident · Minor injuriesLimited investigationFinal reportHawkins William Searey · Dayton, TNThe delamination of the fiberglass hull of the airplane.NTSB CHI04LA231Accident · Serious injuriesLimited investigationFinal reportStephen T-Bird TBT06 · Gobles, MIThe pilot's inadvertent flight into adverse weather conditions which resulted in an encounter with a downdraft that exceeded the climb capabilities of the airplane. The downdraft and the trees were factors.NTSB SEA04CA160Accident · No injuriesData collectionFinal reportBeyers Kitfox IV · Sandpoint, IDThe pilot's failure to maintain aircraft control during the landing roll. Contributing factors were the rough grass runway, and the trees on the left side of the runway.NTSB FTW04LA187Accident · Serious injuriesLimited investigationFinal reportSaladino Searey · Lewisville, TXThe pilot's failure to maintain control of the airplane during final approach. A contributing factor was the gusty crosswind condition.NTSB SEA04LA120Accident · No injuriesLimited investigationFinal reportSheppard Kitfox IV · Rigby, IDFailure to maintain directional control during the landing roll. Factors include muddy terrain.NTSB LAX04LA228Accident · Minor injuriesLimited investigationFinal reportWilson Avid Bandit · Paso Robles, CAthe loss of engine power during takeoff climb due to a cold seizure of the rear cylinder.NTSB NYC04LA133Accident · Serious injuriesLimited investigationFinal reportMosher Avid Heavy Hauler · Fitchburg, MAThe malfunction of the elevator control system, resulting in a forced landing.NTSB ATL04LA122Accident · Serious injuriesLimited investigationFinal reportQuicksilver GT-500 · Cleveland, GAThe student pilot's failure to maintain directional control and his inadequate compensation for wind during takeoff. A factor was crosswind condition.NTSB ATL04LA109Accident · 1 fatalLimited investigationFinal reportBergmann Rans S-12 XL Airaile · Cummings, GAThe unqualified person's poor judgement and his failed to maintain clearance from power lines and trees while maneuvering for a landing which resulted in the in-flight collision with trees and power lines. Factors were the dark night and the unqualified…NTSB NYC04LA111Accident · Serious injuriesLimited investigationFinal reportBlack Kitfox · Mount Sterling, KYThe loss of engine power due to blockage of the fuel filters resulting in fuel starvation. A factor in the accident was the inadequate maintenance inspection.NTSB SEA04LA074Accident · 1 fatalLimited investigationFinal reportSchramm Helicycle · Montour, IDIn flight collision with terrain for undetermined reasons.NTSB ATL04CA083Accident · Minor injuriesData collectionFinal reportDantzer Lawrence L Rans S-12 · Lowndesboro, ALThe pilot's failure to maintain airspeed while manuevering which resulted in an inadvertent stall/spin. A factor was trees.NTSB DEN04LA051Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Berthoud, COthe pilot's improper flare and his inadequate compensation for wind. The wind gust was a contributing factor.NTSB LAX04LA132Accident · 1 fatalLimited investigationFinal reportGillespie Sport Copter Vortex · Yuba City, CAa loss of engine power due to the incorrect installation of the fuel line, which resulted in fuel starvation, and the pilot's failure to maintain rotor RPM, which resulted in an inflight loss of control. A factor to the accident was the pilot's lack of…NTSB ATL04LA066Accident · Minor injuriesLimited investigationFinal reportCurrent Kitfox 313 · Selma, ALThe pilot's inadequate installation, and his failure to secure the main fuel line, which resulted in fuel starvation.