NTSB investigations, 2012
5 cases where the sequence of events included Loss of tail rotor effectiveness.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 7 |
| 2012 | 5 |
| 2013 | 9 |
| 2014 | 8 |
| 2015 | 7 |
| 2016 | 8 |
| 2017 | 11 |
| 2018 | 4 |
| 2019 | 6 |
| 2020 | 2 |
| 2021 | 8 |
| 2022 | 4 |
| 2024 | 4 |
| 2025 | 1 |
| 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\") = 2012
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '242' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '242' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA12CA357Accident · No injuriesData collectionFinal reportHughes TH-55 · Pittsfield, PAThe student pilot's failure to maintain helicopter control during an encounter with loss of tail rotor effectiveness.NTSB CEN12LA267Accident · Minor injuriesLimited investigationFinal reportBell 206B · Valley Falls, KSThe pilot’s inadequate compensation for the wind conditions during a hover maneuver, which resulted in a loss of tail rotor effectiveness.NTSB ERA12LA282Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Farmington, CTThe pilot's inadequate compensation for wind during a high-power, low-speed downwind turn, which resulted in a loss of control due to loss of tail rotor effectiveness and settling with power. Contributing to the accident was the pilot’s decision to land…NTSB WPR12CA100Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Las Vegas, NVThe pilot's inadequate compensation for the known wind conditions during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.NTSB CEN12LA120Accident · Serious injuriesLimited investigationFinal reportContinental Copters 47G2 · Lohn, TXThe improper installation of the tail rotor gearbox by maintenance personnel, which led to accelerated wear of the ring and pinion gears, resulting in the loss of tail rotor effectiveness and subsequent forced landing.