NTSB investigations: Rotax SEE BOMBADIER, GA
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 |
|---|---|
| 2008 | 1 |
| 2013 | 1 |
| 2023 | 1 |
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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
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 ERA23LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEdmisten Robert Eugene SR Rans S-14 Airaile · Bonaire, GAThe pilot’s failure to properly adjust the propeller’s pitch angle, which resulted in a loss of thrust and an inability to maintain altitude.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 NYC08LA235Accident · 1 fatalLimited investigationFinal reportLanier James A Talon XP · Cleveland, GAAn inadvertent stall during the initial climb.NTSB ATL88DKG05Accident · No injuriesFinal reportAmerican Falcon XP · Palmetto, GAThe pilot failed to properly flare the aircraft during a normal landing which resulted in a hard landing. The nose gear assembly failed from overload, and the pilot was not able to control the aircraft as it slid over the ground. The aircraft collided with a…