NTSB investigations: Rotax 912UL
8 cases on aircraft whose registry engine model is Rotax 912UL, where NTSB found Aircraft control. 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
| 2011 | 2 |
|---|---|
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 2 |
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55592')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '02063040')))
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 ('55592')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '02063040')))
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 ERA23LA390Accident · Minor injuriesClass 4 · LimitedFinal reportIrwin Jeffrey C Buccaneer Biib · Sopchoppy, FLThe pilot’s improper recovery from a bounced landing.NTSB CEN23LA227Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Twinstar · Starbuck, MNThe pilot’s improper landing flare and hard landing, which resulted in the left axle fracturing from bending overstress.NTSB ERA22LA305Accident · No injuriesClass 4 · LimitedFinal reportDuffy Russell A Slingshot · Shirley, NYThe pilot’s failure to maintain adequate airspeed during landing leading to an aerodynamic stall and subsequent impact with the ground.NTSB WPR19FA159Accident · 1 fatalClass 3 · FieldFinal reportTitan Titan II · Summerville, ORThe noncertificated pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall/spin and impact with terrain.NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB ERA15CA080Accident · No injuriesData collectionFinal reportBauer Thomas G Kitfox III · Bumpass, VAThe pilot's improper flare during a water landing.NTSB WPR11LA405Accident · No injuriesLimited investigationFinal reportJuneau Stol CH-701 · Snohomish, WAThe pilot's improper landing flare, which resulted in a stall and a hard landing.NTSB ERA11CA177Accident · No injuriesData collectionFinal reportQuist Kitfox · Indian Trail, NCThe pilot's failure to maintain directional control during an aborted landing, resulting in a runway excursion and collision with a vehicle.