NTSB investigations: Rotax 912S series, 2010
3 cases on aircraft whose registry engine model is Rotax 912S 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
| 2007 | 3 |
|---|---|
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 2 |
| 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 year(c.\"eventDate\") = 2010
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55570'))
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") = 2010
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55570'))
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 CEN11LA077Accident · No injuriesLimited investigationFinal reportHalbrook Rans S-6S · St. Cloud, MNThe airplane kit manufacturer’s recommended use of an improper nut type for securing the door hinge.NTSB WPR10CA418Accident · No injuriesData collectionFinal reportWilde Daniel L Zenith 701 · Turlock, CAThe pilot’s inadequate compensation for the crosswind and failure to maintain runway alignment.NTSB ERA10LA330Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Freehold, NYThe failure of the nosegear fork assembly due to fatigue. Contributing to the accident was an inadequate recent annual inspection.