NTSB investigations: Rotax 582SER, 2017
6 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\") = 2017
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") = 2017
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 CEN17LA318Accident · Minor injuriesLimited investigationFinal reportKnapp Easy Raider · Rochester, INA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA17FA223Accident · 1 fatalField investigationFinal reportSlip Stream Genesis · Linesville, PAThe pilot's failure to maintain airspeed during a climbing turn after takeoff and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery. Contributing to the accident was the…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 GAA17CA261Accident · No injuriesData collectionFinal reportQuicksilver Manufacturing SPORT2S R582 · Arecibo, PRThe pilot’s failure to see and avoid trees during low-altitude flight.NTSB GAA17CA259Accident · No injuriesData collectionFinal reportCurtis Lund Vortex · Spanish Fork, UTThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA250Accident · Minor injuriesData collectionFinal reportNorth Wing Uum Sport X2-N · Boulder City, NVThe student pilot’s exceedance of the weight-shift-control aircraft’s critical angle of attack and the flight instructor’s delayed remedial action and failure to maintain the proper airspeed after encountering localized turbulence during approach, which…