NTSB investigations: Rotax 503 DCDI, 2018
4 cases on aircraft whose registry engine model is Rotax 503 DCDI. 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 | 6 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 4 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 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\") = 2018
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55566'))
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") = 2018
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55566'))
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 ERA19FA036Accident · 1 fatalField investigationFinal reportTitan Tornado 1 · Louisa, VAThe pilot's failure to maintain airspeed and the airplane's exceedance of its critical angle of attack, which resulted in an aerodynamic stall and spin at a low altitude.NTSB WPR18TA238Accident · Serious injuriesClass 3Final reportRans S14 · Brownsville, ORThe pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, loss of control, and impact with terrain.NTSB CEN18CA291Accident · No injuriesData collectionFinal reportQuad City Challenger · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed during the base to final turn and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18LA137Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver GT 400 · Maxwell, IAThe noncertificated pilot's unfamiliarity with the airplane, which resulted in a loss of airplane control when the pilot encounter a wind gust.