NTSB investigations: Rotax 582SER, 2012
6 cases on aircraft whose registry engine model is Rotax 582SER, where the defining event was Loss of control in flight. 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 | 5 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 6 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2024 | 2 |
| 2026 | 1 |
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 year(c.\"eventDate\") = 2012
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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") = 2012
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
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 WPR13FA074Accident · 1 fatalField investigationFinal reportCharland Vortex · Wellton, AZThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern.NTSB ERA13CA009Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Cumming, GAThe operation of the powered parachute by a non-certificated pilot, and his failure to maintain directional control during the initial climb, which resulted in a collision with trees.NTSB ERA12CA587Accident · Minor injuriesData collectionFinal reportBuckeye 582 Dream Machine · North Huntingdon, PAThe operation of a powered parachute by a noncertificated pilot. Contributing to the accident was the noncertificated pilot’s failure to maintain directional control during the climb following an aborted landing.NTSB ERA12CA485Accident · No injuriesData collectionFinal reportBayliss Milton A III X-AIR · Houlton, METhe pilot's failure to maintain directional control during the landing flare in a gusting crosswind, which resulted in a runway excursion.NTSB ERA12CA389Accident · Serious injuriesData collectionFinal reportBuckeye Breeze · Lower Burrell, PAThe pilot’s failure to maintain directional control of the powered parachute, which resulted in a collision with trees during final approach. Contributing to the accident was the pilot's lack of flight training.NTSB WPR12LA152Accident · 2 fatalLimited investigationFinal reportNelson Rans S-12 · Mesa, AZThe pilot’s failure to maintain airplane control while maneuvering at low altitude shortly after takeoff.