NTSB investigations: Rotax SEE BOMBADIER
9 cases on aircraft whose registry engine model is Rotax SEE BOMBADIER, where the defining event was Loss of engine power (partial). 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
| 2010 | 1 |
|---|---|
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2025 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55555')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55555')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '342'))
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 ERA25LA122Accident · No injuriesClass 4 · LimitedFinal reportAllyn Kaste Rans S-19 (KIT) · Doylestown, PAThe pilot’s inadequate maintenance and preflight inspection.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.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 WPR17LA003Accident · Minor injuriesLimited investigationFinal reportMelborn Joe B Kolb Sport 600 · Roberts, IDA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN14LA136Accident · Serious injuriesLimited investigationFinal reportMahon Paul D Capella XS · Houston, TXThe loss of engine power due to carburetor icing.NTSB CEN12LA371Accident · No injuriesLimited investigationFinal reportAmen Star Lite · San Antonio, TXThe separation of the fuel tank sealant coating, which traveled into the fuel pump, blocked the fuel flow, and resulted in fuel starvation to the engine.NTSB WPR11FA333Accident · 2 fatalField investigationFinal reportDavidson Zenith Stol CH701 · Glendale, ORA total loss of engine power due to fuel starvation and the pilot’s subsequent failure to maintain airplane control during the forced landing. Contributing to the accident was the pilot’s failure to ensure that the fuel valves were in the correct position for…NTSB CEN11LA374Accident · Serious injuriesLimited investigationFinal reportMalkin Roy K Searey · Minneapolis, MNThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall. Contributing to the accident was the degraded engine performance due to the improper servicing and maintenance of the fuel system.NTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.