NTSB investigations: Rotax 912UL series, 2007
8 cases on aircraft whose registry engine model is Rotax 912UL 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
| 2004 | 1 |
|---|---|
| 2006 | 1 |
| 2007 | 8 |
| 2008 | 1 |
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 1 |
| 2012 | 5 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 5 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 4 |
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\") = 2007
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55571'))
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") = 2007
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55571'))
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 DFW08CA024Accident · Minor injuriesData collectionFinal reportPipistrel Sinus 912 · Holt, FLThe pilot's failure to maintain clearance from terrain. A contributing factor was the gusting crosswind.NTSB CHI08CA004Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey · Cokato, MNThe inadequate flare by the pilot during landing. Contributing factors were the lack of an endorsement by the pilot, the lack of total experience in the type of aircraft by the pilot, and the glassy water.NTSB CHI07CA275Accident · Minor injuriesData collectionFinal reportWeaver, David A Pulsar 912XP · Plato Center, ILthe pilot's failure to maintain airspeed. Factors were the pilot's lack of familiarity with the aircraft and pilot's failure to maintain altitude.NTSB CHI07CA223Accident · Minor injuriesData collectionFinal reportBush Caddy USA LSA · Chadron, NEThe pilot's failure to maintain control of the aircraft during landing. A contributing factor was the gusty, crosswind condition.NTSB LAX07CA228Accident · No injuriesData collectionFinal reportDta Sari Combo FC 912 · San Luis Obispo, CAThe student pilot's improper flare, which resulted in a hard landing. Also causal was the instructor's inadequate supervision.NTSB LAX07LA218Accident · Minor injuriesLimited investigationFinal reportClement Zenith Zodiac CH601 · Rosamond, CAA total loss of engine power during approach due to the improper idle screw/stop adjustment. A factor contributing to the accident was deteriorated fuel.NTSB MIA07LA120Accident · Minor injuriesLimited investigationFinal reportJohn D. Williams XT-912 · Newport News, VAThe pilot's failure to comply with FAA and engine manufacturer directives resulting in deterioration of fuel system components by fuel containing ethanol and blockage of the fuel filter by contaminants.NTSB MIA07CA069Accident · No injuriesData collectionFinal reportAeroprakt A-22 · Keenansville, FLThe pilot's failure to maintain directional control during the landing roll on a wet grass runway. A factor associated with the accident was the wet runway.