NTSB investigations: Rotax 912ULS series, 2012
11 cases on aircraft whose registry engine model is Rotax 912ULS series, 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 | 5 |
|---|---|
| 2009 | 7 |
| 2010 | 10 |
| 2011 | 9 |
| 2012 | 11 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 4 |
| 2018 | 6 |
| 2019 | 7 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 4 |
| 2026 | 1 |
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 year(c.\"eventDate\") = 2012
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55572')
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 year(c."eventDate") = 2012
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55572')
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 WPR13CA039Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Carlsbad, CAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with parked aircraft. Contributing to the accident was the pilot's lack of experience in the airplane make/model.NTSB CEN13CA017Accident · Serious injuriesData collectionFinal reportHunthrop Autogyro MTO Sport · Bourland, TXThe pilot's decision to fly the gyroplane in gusty wind conditions that exceeded his limitations and his resultant loss of control during takeoff.NTSB WPR12FA395Accident · 1 fatalField investigationFinal reportSkykits USA Savannah ADV · Murtaugh, IDThe pilot's failure to maintain adequate airspeed while maneuvering at or above the airplane's maximum ceiling, which resulted in a stall and a subsequent loss of airplane control. Contributing to the accident was the pilot's decision to operate the airplane…NTSB CEN12CA603Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Pittsford, MIThe student pilot’s failure to maintain directional control of the airplane while maneuvering at a low altitude.NTSB CEN12LA466Accident · 1 fatalLimited investigationFinal reportToman Jack JR Skystar Kitfox 4 · Cross Lake, MNThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's impairment due to marijuana.NTSB WPR12FA295Accident · 2 fatalField investigationFinal reportTL Ultralight Sro Stingsport · Piru, CAThe pilot’s failure to recover from a stall, which resulted in a spin. Contributing to the accident was the instructor’s inadequate remedial action.NTSB CEN12CA370Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot’s improper performance of a soft field takeoff procedure, which resulted in a loss of airplane control, and the flight instructor’s delayed remedial action to correct the situation.NTSB CEN12CA356Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Indianapolis, INThe student pilot’s failure to maintain control of the airplane during takeoff.NTSB CEN12CA295Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Moorhead, MNThe failure to maintain adequate airspeed for the wind conditions during landing, which resulted in a loss of airplane control.NTSB CEN12LA231Accident · Serious injuriesLimited investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Ann Arbor, MIThe student pilot's failure to maintain airplane control on takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB ERA12LA264Accident · Serious injuriesLimited investigationFinal reportPowrachute Airwolf 912ULS · Plant City, FLThe flight instructor’s failure to ensure an obstruction-free takeoff path prior to initiating the takeoff and his inadequate preflight inspection of the powered parachute’s flight controls, which resulted in a collision with trees during the takeoff.