NTSB investigations: Rotax SEE BOMBADIER
11 cases on aircraft whose registry engine model is Rotax SEE BOMBADIER, where the first occurrence was “Loss of engine power”. 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
| 2001 | 1 |
|---|---|
| 2003 | 3 |
| 2004 | 2 |
| 2006 | 2 |
| 2007 | 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 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 SEA07FA240Accident · Serious injuriesField investigationFinal reportFlight Design Ctsw · St. George, UTThe loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX07LA148Accident · 2 fatalLimited investigationFinal reportHill Europa XS · Livermore, CAthe loss of engine power for an undetermined reason during the initial climb, and the pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in a stall/spin.NTSB LAX07LA075Accident · Minor injuriesLimited investigationFinal reportJihlavan KP-5 · Moorpark, CAa partial loss of power for undetermined reasons.NTSB DFW07LA010Accident · No injuriesLimited investigationFinal reportTaylor Zodiac 601 · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA142Accident · No injuriesData collectionFinal reportStys T-Bird Sport · West Bend, WIThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed which resulted in a stall.NTSB MIA05LA001Accident · No injuriesLimited investigationFinal reportRotorway 162F · New Smyrna Beac, FLA loss of engine power due to undetermined reasons, which resulted in the pilot entering autorotation and affecting a forced landing to the water.NTSB ATL04LA111Accident · 1 fatalLimited investigationFinal reportRiggs Skyraider 1 · Blounts Creek, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was loss of engine power and water in the fuel.NTSB SEA03LA186Accident · Serious injuriesLimited investigationFinal reportSchmidt Zodiac 601 XL · Sumner, WALoss of engine power during the initial climb. Factors include the in-flight collision with trees during the uncontrolled descent.NTSB CHI03LA256Accident · No injuriesLimited investigationFinal reportNicoson Antares MA-33 · Palmyra, WIThe loss of engine power for undetermined reasons and the pilot misjudging the descent rate during the forced landing, which resulted in the airplane landing short of the desired landing area. A factor to the accident was the fence.NTSB NYC03LA085Accident · Minor injuriesLimited investigationFinal reportMcCaa Minimax 1500R · Robbinsville, NJA partial loss of power for undertermined reason(s).NTSB DEN01LA153Accident · Minor injuriesLimited investigationFinal reportBradley Rans S-7 · Fruita, COloss of engine power due to both piston rings failing, and the subsequent inadvertent stall/spin during the attempted forced landing. A contributing factor was the lack of suitable terrain for a forced landing.