NTSB investigations: Rotax 503 DCDI
23 cases on aircraft whose registry engine model is Rotax 503 DCDI, 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 | 4 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55566')
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55566')
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 WPR27FA015Accident · 1 fatalClass 4 · FieldInvestigation openBertling Courtney MXL-2 · Newberg, ORNTSB ERA25LA063Accident · No injuriesClass 4 · LimitedFinal reportHoltz Rodney R Challenger II · Concord, NHThe pilot’s failure to maintain directional control and eventual stall/mush of the airplane while trying to secure an open door in flight.NTSB ERA22LA301Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar · Cleveland, GAThe pilot’s failure to maintain control of the airplane on takeoff for unknown reasons.NTSB CEN21LA446Accident · Serious injuriesClass 4 · LimitedFinal reportCole Paul B Challenger I · Higginsville, MOThe non-certificated pilot's exceedance of the airplane's critical angle of attack during a low-level turn, which resulted in an aerodynamic stall.NTSB WPR20LA118Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar 2 · La Center, WAA loss of control for reasons that could not be determined based on the available information.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 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.NTSB GAA17CA136Accident · Minor injuriesData collectionFinal reportNielsen Martin M Challenger II · Punta Gorda, FLThe pilot’s failure to maintain directional control during landing.NTSB GAA15CA212Accident · Minor injuriesData collectionFinal reportMain Air Rapier · Reidsville, NCThe student pilot landed with variable wind conditions, which resulted in an in-flight loss of control and subsequent impact with terrain.NTSB CEN14CA413Accident · Minor injuriesData collectionFinal reportPhantom Phantom X 1 · Three Rivers, MIThe pilot did not maintain adequate airspeed while flying a visual pattern, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CEN14LA192Accident · 1 fatalLimited investigationFinal reportAerotrike Safari · Littlefield, TXThe non-certificated pilot's in-flight loss of control for reasons that could not be determined from the available evidence.NTSB ERA13CA161Accident · Minor injuriesData collectionFinal reportRainbow Aircraft PTY Cobra · Camden, SCThe pilot's failure to maintain airplane control during the approach to land.NTSB ERA12CA570Accident · Serious injuriesData collectionFinal reportFly Hard Trike Skycycle Sting RAY · Gulfport, MSThe pilot’s failure to maintain aircraft control after an unexpected wind gust/turbulence encounter during landing.NTSB CEN12LA407Accident · Serious injuriesLimited investigationFinal reportFields Mike Hawk SSC · Evansville, INThe operation of an airplane by a non-certificated pilot, and the pilot's loss of control during takeoff, which resulted in an inadvertent stall and spin.NTSB ERA12LA386Accident · 1 fatalLimited investigationFinal reportBowen Christopher W Dogbee · Wrens, GAThe pilot’s loss of control during a low-altitude maneuver for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision…NTSB CEN11LA455Accident · No injuriesLimited investigationFinal reportCouvillion S-17 · Toledo, OHThe loss of control during initial climb for undetermined reasons, which resulted in a hard landing.NTSB ERA10LA166Accident · Minor injuriesLimited investigationFinal reportBelcher William B II Firestar · Wetumpka, ALThe student pilot’s in-flight loss of control as a result of previous damage to the airplane from an undetermined event.NTSB CEN09CA334Accident · Minor injuriesData collectionFinal reportAerotrike Safari · Lake City, MIThe pilot's failure to maintain adequate airspeed during the initial climb.NTSB DFW08CA213Accident · Serious injuriesData collectionFinal reportAerotrike Spirit · Vinland Valley, KSThe flight instructor's failure to maintain control of the sport aircraft on takeoff.NTSB MIA08LA105Accident · 1 fatalLimited investigationFinal reportAviate Raptor · Bealeton, VAAn in-flight loss of control for undetermined reasons.NTSB CHI08CA086Accident · No injuriesData collectionFinal reportRans S-4 Coyote I · Lakeville, MNThe pilot's failure to maintain directional control and his inadequate compensation for the crosswind conditions. Factors included the pilot's lack of experience in the make and model of the airplane and the crosswind gust.NTSB MIA08CA049Accident · Serious injuriesData collectionFinal reportAirborne Redback · Jefferson, GAThe failure of the pilot-in-command to maintain control of the airplane and his poor weather evaluation before attempting to taxi the airplane. A factor in the accident was the failure of airport personnel to correct the inaccurate wind information reported…