NTSB investigations: Rotax 582UL
6 cases on aircraft whose registry engine model is Rotax 582UL, where the probable cause includes Aircraft control. 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 | 2 |
|---|---|
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
Where
Latest 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 ('55558')
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\", '02063040')))
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 ('55558')
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", '02063040')))
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 ERA21LA310Accident · Serious injuriesClass 3 · LimitedFinal reportLiteflite PTY Dragonfly Model C · Middletown, NYThe improper installation of the carburetor, which resulted in a momentary total loss of engine power during initial climb. Contributing was the pilot’s failure to maintain control of the airplane following the initial power loss.NTSB ERA21LA283Accident · 1 fatalClass 3 · LimitedFinal reportBailey N Moyes Dragonfly · Charlestown, NHThe passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.NTSB CEN19FA195Accident · 1 fatalClass 2 · FieldFinal reportRans S12 · Orleans, INThe pilot's exceedance of the airplane's critical angle of attack while maneuvering toward the runway, which resulted in an aerodynamic stall and a loss of control.NTSB GAA18CA306Accident · No injuriesData collectionFinal reportLite Flight Dragonfly · Mint Hill, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a turn, which resulted in an aerodynamic stall/spin.NTSB SEA08LA207Accident · Serious injuriesLimited investigationFinal reportSimpson Amphibious Trike · Lake Chelan, WAThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an inadvertent aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the float-equipped, weight-shift airplane.NTSB CHI08LA185Accident · No injuriesLimited investigationFinal reportTraxler John N Kitfox · Hartford, CTThe pilot's failure to compensate for crosswinds resulting in a loss of directional control while landing. Contributing to the accident was the pilot's lack of experience and training in tailwheeled airplanes.