NTSB investigations: Rotax 582SER, 2008
18 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\") = 2008
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") = 2008
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 WPR09CA020Accident · Serious injuriesData collectionFinal reportRoyse David Avid C Aerobat · Hollister, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain airplane control during the landing flare. Contributing to the accident were the gusty wind conditions.NTSB CEN09CA025Accident · Serious injuriesData collectionFinal reportHolmes William E Predator · Branson, MOThe pilot's failure to maintain directional control. Contributing to the accident was the wing's failure to open all cells for undetermined reasons and the trees near the runway.NTSB ERA09CA003Accident · No injuriesData collectionFinal reportBuckeye Dream Machine · Lexington, KYThe student pilot's improper decision to continue the takeoff.NTSB MIA08CA150Accident · Serious injuriesData collectionFinal reportBuckeye Breeze · New Market, TNThe student pilot's failure to consider the aircraft's performance for the takeoff.NTSB CHI08CA204Accident · Serious injuriesData collectionFinal reportIndy T-Bird II · Independence, IAThe takeoff airspeed not attained and the aborted takeoff not performed by the pilot. An additional cause was the lack of familiarity with the airplane by the pilot.NTSB SEA08LA162Accident · Serious injuriesLimited investigationFinal reportSport Flight Talon XP · Inverness, FLThe lower rod bearing failed due to corrosion.NTSB DEN08LA108Accident · No injuriesLimited investigationFinal reportMercer Avid Flyer Mk IV · Augusta, KSFailure of the engine cooling system's thermostat, causing the engine to overheat and seize. Contributing to the accident was the fence.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.NTSB SEA08CA154Accident · Minor injuriesData collectionFinal reportUetz, Walter Spitfire II · Kamiah, IDThe total loss of engine power for undetermined reasons, and the pilot's failure maintain the proper descent rate during the last part of his approach to a forced landing in an open hayfield.NTSB CEN09CA108Accident · Minor injuriesData collectionFinal reportPowrachute Pegasus · Sunrise Beach, TXThe pilot's failure to maintain altitude/clearance from a powerline while maneuvering. A contributing factor was the powerline.NTSB CHI08CA149Accident · Serious injuriesData collectionFinal reportMischanko Buckeye Breeze · Walkerton, INThe directional control of the parachute not obtained/maintained by the pilot during the takeoff roll. A contributing factor was separation of the nose landing gear.NTSB DFW08CA150Accident · Minor injuriesData collectionFinal reportCortesy, John E Airborne Edge-X · San Juan Pueblo, NMThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB CHI08LA125Accident · Serious injuriesLimited investigationFinal reportRans S-12 XL · Pelion, SCA loss of engine power due to the improper actions of the instructor pilot and the low experience level of the instructor pilot in this make and model of aircraft.NTSB DFW08LA105Accident · 1 fatalLimited investigationFinal reportBlevens Gary Vortex · Berclair, TXLoss of control for undetermined reasons.NTSB NYC08CA147Accident · No injuriesData collectionFinal reportRans S12XL · Wauchula, FLThe malfunction of the fuel line, which resulted in a loss of engine power due to fuel starvation.NTSB MIA08CA055Accident · Minor injuriesData collectionFinal reportWilliam P. Crowell Genesis · Warm Springs, GAThe failure of the pilot to maintain directional control of the airplane during final approach.NTSB CHI08CA072Accident · No injuriesData collectionFinal reportAvid MK-IV · Boswell, INThe pilot's inadequate compensation for the crosswind condition which resulted in a loss of directional control during a bounced landing. Factors associated with the accident were the improper flare, the crosswind, and the trees which the airplane contacted.NTSB LAX08LA050Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper · Green Valley, AZAn in-flight loss of control and an uncontrolled descent into terrain for undetermined reasons.