NTSB investigations: Rotax 503 series, 2009
7 cases on aircraft whose registry engine model is Rotax 503 series. 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
| 2007 | 2 |
|---|---|
| 2008 | 4 |
| 2009 | 7 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 6 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 5 |
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\") = 2009
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55564'))
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") = 2009
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55564'))
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 CEN10LA074Accident · Serious injuriesLimited investigationFinal reportGibson Mark Manta 503 · Magnolia, TXThe pilot's failure to maintain clearance from a static wire while maneuvering and his improper decision to fly with a low overcast sky.NTSB WPR09LA453Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Redlands, CAStructural failure of the right wing during the landing approach due to the separation of the wing's fabric covering.NTSB ERA09LA492Accident · 1 fatalLimited investigationFinal reportBond Neal O S-9 · Saylorsburg, PAThe pilot’s excessive flight control inputs that resulted in an overload failure of the right elevator and horizontal stabilizer.NTSB ERA09LA451Accident · Serious injuriesLimited investigationFinal reportEngle David TWO Place · Manlius, NYThe pilot's failure to maintain adequate airspeed during climbout, resulting in an aerodynamic stall.NTSB CEN09CA504Accident · Minor injuriesData collectionFinal reportVanderhoof Steve AIR Comman · Mentone, INThe pilot's failure to maintain aircraft control during the landing and subsequent impact with a parked aircraft.NTSB ERA09LA383Accident · Minor injuriesLimited investigationFinal reportRans S5 Coyote · Greeneville, TNThe pilot's failure to maintain airspeed during a forced landing. Contributing to the accident was the loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.NTSB WPR09LA130Accident · 1 fatalLimited investigationFinal reportToland S/Thornburgh J Twin 503SL · Torrance, CAThe passenger’s inadvertent activation of the engine throttle.