NTSB investigations, 2010
5 cases where NTSB found Tail rotor.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 5 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 4 |
| 2019 | 1 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 5 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 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\") = 2010
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010464'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010464')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…NTSB CEN10FA509Accident · 3 fatalField investigationFinal reportBell Helicopter Textron 206L-1 · Walnut Grove, ARThe pilot’s loss of aircraft control, due to spatial disorientation, resulting in the in-flight separation of the main rotor and tail boom.NTSB CEN10IA314Incident · Minor injuriesIncident investigationFinal reportBell 206L-3 · Gulf of MexicoA suspected failure of the tail rotor for undetermined reasons. A contributing factor was the failure of the emergency floats to properly inflate due to improper installment and inspection by maintenance personnel.NTSB WPR10LA200Accident · No injuriesLimited investigationFinal reportBell 222U · Santa Maria, CAThe pilot's inadequate preflight inspection to ensure that all tie-down straps were removed prior to flight. Contributing to the accident was the pilot's improper management of sleep opportunities during the preceding rest period, which likely contributed to…NTSB ERA10LA118Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B2 · New York, NYThe failure of maintenance personnel to properly secure one tail rotor pitch change link to its respective tail rotor blade resulting in an in-flight separation of the link from the blade. Contributing to the accident was the lack of an adequate…