NTSB investigations: Rotax SEE BOMBADIER, 2019
7 cases on aircraft whose registry engine model is Rotax SEE BOMBADIER. 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
| 1987 | 1 |
|---|---|
| 1994 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 7 |
| 2004 | 12 |
| 2005 | 11 |
| 2006 | 23 |
| 2007 | 14 |
| 2008 | 14 |
| 2009 | 6 |
| 2010 | 4 |
| 2011 | 8 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 9 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 3 |
| 2024 | 6 |
| 2025 | 5 |
| 2026 | 3 |
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\") = 2019
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55555'))
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") = 2019
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55555'))
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 CEN19FA276Accident · 1 fatalClass 2 · FieldFinal reportShirley Carl Sportcopter Vortex · Viroqua, WIThe noncertificated pilot's loss of control of the gyrocopter after a total loss of engine power due to seizure of the crankshaft bearings. Contributing to the accident were the insufficient maintenance of the engine and the pilot's lack of gyrocopter flight…NTSB ERA19LA247Accident · 1 fatalClass 3 · LimitedFinal reportFantasy Air Allegro · Boone, NCThe reported total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN19LA172Accident · Minor injuriesClass 3 · LimitedFinal reportKarns SKY Ranger · Hedgesville, WVA partial loss of engine power during takeoff due to the formation of carburetor ice while on the ground, which resulted in an impact with terrain.NTSB WPR19FA121Accident · 2 fatalClass 3 · FieldFinal reportTL Ultralight Sro Stingsport · Madera, CAThe pilot's exceedance of the airplane's critical angle of attack during the simulated engine failure on initial climb after takeoff, which resulted in an aerodynamic stall and subsequent loss of control at too low of an altitude to recover.NTSB CEN19FA122Accident · 2 fatalClass 3 · FieldFinal reportRans S7 · Kingsland, TXThe exceedance of the airplane's critical angle of attack during a steep climb after takeoff, which resulted in an aerodynamic stall and spin into terrain.NTSB WPR19FA106Accident · 2 fatalClass 3 · FieldFinal reportTecnam P2002 · Santa Fe, NMThe flight instructor’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control.NTSB GAA19CA133Accident · No injuriesData collectionFinal reportDenney Kitfox IV Speedster · Page, AZThe pilot's failure to maintain lateral control during the landing flare, which resulted in the left wing striking a tree.