NTSB investigations: Bombardier ROTAX (ALL), 2005
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\") = 2005
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") = 2005
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 NYC06LA024Accident · Minor injuriesLimited investigationFinal reportLo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VAFailure of the ignition system, which resulted in a loss of engine power.NTSB CHI06CA024Accident · Minor injuriesData collectionFinal reportColson/Goodbread Rans S-12 · Flushing, MIThe loss of engine power on initial climb for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.NTSB IAD05CA134Accident · Serious injuriesData collectionFinal reportLamont Aventura II · Hope, METhe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin and subsequent impact with water. A factor to the accident was the wind gusts.NTSB CHI05LA228Accident · No injuriesLimited investigationFinal reportAuseth Kitfox IV · Little Grand La, MNThe inadequate flare during landing by the pilot.NTSB MIA05LA145Accident · Serious injuriesLimited investigationFinal reportFox Alfred C. Kitfox IV 1200 · Immokalee, FLThe pilot's failure to detect standing water on the grass strip resulting in a nose over during the landing roll.NTSB ATL05CA141Accident · Serious injuriesData collectionFinal reportTherrien Roger Vortex · Lawrenceburg, TNThe pilot's improper landing flair, which resulted in a hard landing.NTSB DFW05CA199Accident · No injuriesData collectionFinal reportMrazek Rans S-14 · Forth Worth, TXThe loss of engine power for undetermined reasons. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB IAD05LA089Accident · 1 fatalLimited investigationFinal reportLongtin Kitfox Model III · New London, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.NTSB ATL05LA110Accident · 1 fatalLimited investigationFinal reportCasten Rans S-10 · Perry, SCA loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI05CA139Accident · Minor injuriesData collectionFinal reportGrimes SNS-9 · Niles, MIThe pilot's failure to maintain airspeed which led to the inadvertent stall/mush, and subsequent impact with the ground.NTSB LAX05LA149Accident · 2 fatalLimited investigationFinal reportSchlitter Randy J Rans S6ES Coyote II · Tombstone, AZloss of engine power for undetermined reasons and the flying pilot's failure to maintain an adequate airspeed that resulted in a stall and uncontrolled descent into terrain.NTSB SEA05LA073Accident · No injuriesLimited investigationFinal reportShorethose Kitfox Series 5 · Cresent City, FLAircraft handling not maintained during the landing rollout. Factors include soft terrain.NTSB SEA05LA071Accident · Minor injuriesLimited investigationFinal reportPark Kitfox IV · Eagle Point, ORLoss of partial engine power during initial climb for undetermined reasons. Soft terrain was a factorNTSB SEA05CA060Accident · No injuriesData collectionFinal reportBirtch Kitfox II · Dillard, ORThe pilot's failure to maintain clearance from obstacles while in cruise flight at low altitude, which resulted in an inflight collision with a power line. A factor was the pilot's decision to fly at low altitude.NTSB ANC05LA032Accident · Minor injuriesLimited investigationFinal reportJohnson Revolution Mini 500 · Isabela, PRThe loss of engine power during cruise flight for an undetermined reason, which resulted in an autorotation and collision with terrain.