NTSB investigations: Rotax 582SER
14 cases on aircraft whose registry engine model is Rotax 582SER, where the probable cause includes Performance/control parameters, general. 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
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2024 | 2 |
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 ('55556')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND f.\"inProbableCause\" AND starts_with(f.\"findingCode\", '01062000')))
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 ('55556')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND f."inProbableCause" AND starts_with(f."findingCode", '01062000')))
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 ERA25LA023Accident · 2 fatalClass 3 · LimitedFinal reportBuckeye Dream Machine · Nicholasville, KYThe pilot’s loss of control in flight, which resulted in a collision with terrain.NTSB ANC24LA051Accident · No injuriesClass 4 · LimitedFinal reportMorgan Edward L Edge X 582 · Fairbanks, AKThe pilot’s selection of an unsuitable landing site, resulting in a collision with a hole during landing rollout.NTSB ERA17FA211Accident · 1 fatalField investigationFinal reportBuckeye Powered Parachutes Dream Machine 582 · Federalsburg, MDThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with power lines. Contributing to the accident was the pilot's lack of experience in powered parachutes.NTSB WPR14LA119Accident · 1 fatalLimited investigationFinal reportSabrena Dragonfly · Maricopa, AZThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.NTSB WPR13LA398Accident · Serious injuriesLimited investigationFinal reportStrong Dream Machine · Bieber, CAThe pilot’s inability to maintain aircraft control during takeoff after several suspension lines became entangled in, and were subsequently severed by, the propeller blades.NTSB WPR13FA074Accident · 1 fatalField investigationFinal reportCharland Vortex · Wellton, AZThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern.NTSB ERA11LA496Accident · 1 fatalLimited investigationFinal reportAero Adventure Zephyr II · Sylacauga, ALThe pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.NTSB WPR11LA133Accident · 1 fatalLimited investigationFinal reportBuckeye Breeze LX · Bullfrog, UTThe pilot’s loss of control while maneuvering to land at an off-airport site.NTSB CEN11CA057Accident · Serious injuriesData collectionFinal reportSix Chuter SR7 · Winnie, TXThe collapse of the powered parachute's canopy on short final for undetermined reasons, resulting in a loss of lift.NTSB CEN10CA160Accident · No injuriesData collectionFinal reportUltralight America Spitfire II Modelctv · Cameron, TXThe pilot's failure to maintain control while maneuvering during a forced landing after a partial loss of engine power.NTSB ERA09LA452Accident · 1 fatalLimited investigationFinal reportMaxair Drifter · Bumpass, VAThe accelerated stall induced by the pilot in a steep turn to avoid obstacles during takeoff. Contributing to the accident were the pilot’s chosen takeoff path and the density altitude.NTSB CEN09CA366Accident · Serious injuriesData collectionFinal reportSabre 2PL · Harrison, NEA loss of directional control for undetermined reasons.NTSB ERA09CA328Accident · Serious injuriesData collectionFinal reportTrick Trikes Storm Thunder · Raleigh, NCThe pilot's failure to maintain aircraft control on approach for landing.NTSB DEN08LA113Accident · Serious injuriesLimited investigationFinal reportSouthern Powered Parachutes Condor · Brookfield, MOthe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the pilot's lack of familiarity and experience in the accident aircraft.