NTSB investigations: Rotax SEE BOMBADIER, 2021
4 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\") = 2021
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") = 2021
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 CEN22LA015Accident · No injuriesClass 4 · LimitedFinal reportZuber Thomas P Zuber Super Drifter · Horseshoe Bay, TXThe pilot’s failure to adequately monitor airspeed during a low-level turn, which resulted in an aerodynamic stall and impact with the water.NTSB CEN21LA372Accident · Serious injuriesClass 3 · LimitedFinal reportFlying K Enterprises Sky Raider · Augusta, KSA partial loss of engine power for reasons that could not determined based on available information.NTSB WPR21LA248Accident · No injuriesClass 4 · LimitedFinal reportDewsnup Dave Zenair CH 701 SP · Chester, CAThe pilot’s failure to properly position of the fuel selector valve, which resulted in a loss of engine power during initial climb due to fuel starvation.NTSB ERA21LA103Accident · No injuriesClass 3 · LimitedFinal reportTL Ultralight Sro Stingsport · Hollywood, FLThe inadequate maintenance and inspection of the fuel system, which resulted in a partial loss of engine power. Contributing was the pilot's mismanagement of the emergency approach and landing, which resulted in a runway overrun.