NTSB investigations: Rotax SEE BOMBADIER, 2014
9 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\") = 2014
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") = 2014
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 CEN15LA026Accident · 1 fatalLimited investigationFinal reportStephenson Stol CH 701 · Mount Vernon, INThe pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…NTSB WPR15FA010Accident · 2 fatalField investigationFinal reportCessna 170B · Yerington, NVThe failure of the Savannah pilot to maintain awareness of the position of the Cessna while attempting a join up maneuver. Contributing to the accident was the impaired decision-making of the Savannah's pilot due to the combined effects of licit and illicit…NTSB ERA15CA010Accident · No injuriesData collectionFinal reportToerner Bob SEA REY · Tampa, FLThe pilot's failure to retract the landing gear after takeoff, which resulted in the landing gear contacting the water while maneuvering at low altitude.NTSB WPR14CA388Accident · Serious injuriesData collectionFinal reportLundak Robert Kitfox IV · Sonoma, CAThe pilot's inadequate fuel management which resulted in an engine failure due to fuel starvation and subsequent collision with power lines during the forced landing.NTSB ANC14LA065Accident · No injuriesLimited investigationFinal reportTerry W. Thayer Zenith Stol CH701 · Nikiski, AKThe pilot’s improper positioning of the fuel selector valves, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow preflight checklists.NTSB CEN14LA373Accident · Serious injuriesLimited investigationFinal reportGarramone Mike A Vixen · Columbus, NMA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any preimpact failures or malfunctions that would have precluded normal operation.NTSB CEN14CA268Accident · No injuriesData collectionFinal reportFlight Design Ctsw · New Carlisle, OHThe pilot did not maintain control of the airplane while landing.NTSB ERA14CA234Accident · Minor injuriesData collectionFinal reportSam R Peachey Just Aircraft Highla · Roxbury, PAThe pilot's failure to maintain adequate airspeed during low altitude maneuvering.NTSB CEN14LA136Accident · Serious injuriesLimited investigationFinal reportMahon Paul D Capella XS · Houston, TXThe loss of engine power due to carburetor icing.