NTSB investigations: Bombardier ROTAX (ALL), 2020
8 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\") = 2020
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") = 2020
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 WPR20LA170Accident · 1 fatalClass 3 · LimitedFinal reportKitfox Kitfox · Lander, WYThe inexperienced pilot’s exceedance of the airplane’s critical angle-of-attack during a turn at high density altitude, which resulted in an accelerated stall and impact with water. Contributing to the accident was the pilot’s poor judgment to continue the…NTSB CEN20LA203Accident · Minor injuriesClass 3 · LimitedFinal reportMagni Magni M 16 · Cape Girardeau, MOThe student pilot’s decision to take off with inadequate runway remaining, and his subsequent failure to attain proper airspeed, which resulted in the gyroplane’s descent into terrain.NTSB CEN20CA196Accident · No injuriesClass 4 · Data collectionFinal reportDenney Kitfox Speedster · Georgetown, TXThe pilot's failure to maintain directional control during landing.NTSB ERA20LA188Accident · Minor injuriesClass 3 · LimitedFinal reportVaughn Challenger · Clarksville, TNThe loss of engine power due to carburetor ice.NTSB CEN20CA177Accident · Minor injuriesClass 4 · Data collectionFinal reportM-Squared Sport 1000 · Little Falls, MNThe uncertificated pilot's failure to maintain aircraft control during takeoff, which resulted in an impact with terrain.NTSB WPR20LA122Accident · No injuriesClass 3 · LimitedFinal reportBuckman Bucks Special · Prescott, WADiminished engine performance due to carburetor icing conditions and multiple mechanical anomalies that did not allow for the airplane to attain adequate airspeed during takeoff from a planted field and failure to maintain clearance from obstructions.…NTSB WPR20LA116Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hurricane, UTA total loss of engine power due to the failure of the ignition system as a result of foreign object damage.NTSB ERA20CA083Accident · Minor injuriesData collectionFinal reportDenney Kitfox · Wauchula, FLThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control, which resulted in a runway excursion and nose-over.