NTSB investigations: Rotax SEE BOMBADIER, 2013
6 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\") = 2013
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") = 2013
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 CEN14CA039Accident · Minor injuriesData collectionFinal reportWohaska John Parsons Stiles Gyro · Festus, MOThe pilot's improper propeller adjustment, which resulted in decreased performance and a loss of aircraft control.NTSB CEN13CA430Accident · Minor injuriesData collectionFinal reportAlvarez Marvin R Rans S-6S · Schertz, TXThe noncertificated pilot's operation of the airplane, which resulted in impact with terrain.NTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB CEN13LA298Accident · No injuriesLimited investigationFinal reportAllen Jan A Challenger II · Greeley, COThe loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.NTSB ERA13CA250Accident · Minor injuriesData collectionFinal reportThomas David W Rans S-12 XL · Cleveland, GAThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of overall recent flight experience and lack of experience in make and model.NTSB ERA13LA199Accident · Minor injuriesLimited investigationFinal reportMaxfly Inc/Mckay WM Searey · Polk City, FLThe improper installation of incorrect attachment hardware by maintenance personnel during an undocumented repair, which resulted in an in-flight structural failure and subsequent loss of aircraft control. Contributing to the accident was the covering of the…