NTSB investigations: Rotax 582SER, 2010
15 cases on aircraft whose registry engine model is Rotax 582SER. 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
| 1998 | 1 |
|---|---|
| 2007 | 3 |
| 2008 | 18 |
| 2009 | 15 |
| 2010 | 15 |
| 2011 | 13 |
| 2012 | 19 |
| 2013 | 4 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 6 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 2010
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55556'))
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 year(c."eventDate") = 2010
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55556'))
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 ERA11LA056Accident · 1 fatalLimited investigationFinal reportCarlo Robert Quicksilver SPT 2S · Lajas, PRThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and entry into a spin.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 ERA11LA049Accident · Serious injuriesLimited investigationFinal reportAirborne Classic · Stow, MAThe operator's inadequate engine maintenance, which resulted in a total loss of engine power. Contributing to the accident was the pilot's decision to conduct a downwind takeoff.NTSB CEN10CA569Accident · Minor injuriesData collectionFinal reportCentral Ohio Dragonfly Clubllc DRAGONFLY-C · Orient, OHThe pilot's failure to disconnect the tow bridal line prior to takeoff.NTSB ERA10CA470Accident · Minor injuriesData collectionFinal reportNorth Wing Uum Sport X2 · Winterville, NCThe pilot's loss of directional control while landing during an encounter with a wind gust.NTSB ERA10LA431Accident · 1 fatalLimited investigationFinal reportMaxair MU 582 Drifter · Old Forge, NYThe pilot's failure to use the full length of the lake, which necessitated a steep turn to avoid obstacles during takeoff that resulted in an accelerated stall.NTSB WPR10CA403Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 582S · Petaluma, CAThe pilot’s improper flare, resulting in a hard landing and nose over.NTSB CEN10CA480Accident · Serious injuriesData collectionFinal reportBuckeye Industries Dream Machine · Seymour, INAn inadvertent encounter with turbulence which exceeded the performance capability of the powered parachute.NTSB CEN10LA492Accident · Serious injuriesLimited investigationFinal reportInfinity Infinity · Little Rock, ARThe failure of the control lanyard for undetermined reasons.NTSB WPR10LA353Accident · Serious injuriesLimited investigationFinal reportTopdog Ultralights TOP DOG 582 · Eagle Point, ORThe separation of the left wingtip.NTSB CEN10CA423Accident · No injuriesData collectionFinal reportAirborne Outback · Denver, COThe student pilot’s improper flare at touchdown.NTSB CEN10CA344Accident · Serious injuriesData collectionFinal reportAir Creation GTE · Neenah, WIThe pilot's improper landing flare that resulted in a hard landing.NTSB CEN10LA339Accident · 1 fatalLimited investigationFinal reportAirborne Windsport Edge · Ft. Lupton, COThe pilot intentionally performed prohibited aerobatic maneuvers that damaged the carriage wing attachment hang point and collapsed the wing.NTSB WPR10LA274Accident · Serious injuriesLimited investigationFinal reportSmithwick/Treidel Tukan · Prairie, IDThe pilot's loss of control of the weight-shift-controlled airplane during takeoff for undetermined reasons.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.