NTSB investigations, 2017
11 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\") = 2017
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") = 2017 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 CEN18FA001Accident · 1 fatalField investigationFinal reportBrantly B 2B · Midland, MIThe pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…NTSB ERA17LA305Accident · Serious injuriesLimited investigationFinal reportMD Helicopter 369 · Lawrenceville, GAThe pilot's inadequate compensation for wind conditions during the approach to landing, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB GAA17CA495Accident · No injuriesData collectionFinal reportBell 206 · Minden, NVThe pilot’s failure to maintain helicopter control during landing due to a loss of tail rotor effectiveness.NTSB CEN17LA267Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ireland, INThe pilot's failure to apply the proper procedures to recover from a loss of tail rotor effectiveness, which resulted in a loss of control during an aerial application turn.NTSB WPR17LA143Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Ronan, MTThe pilot's failure to maintain adequate airspeed, which resulted in a loss of tail rotor effectiveness during a low-altitude orbiting maneuver and a subsequent hard landing.NTSB GAA17CA393Accident · No injuriesData collectionFinal reportBell 206 · Dixon, KYThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude. Contributing to the accident was the pilot’s failure to adequately identify hazards to flight during agricultural application operation planning.NTSB GAA17CA376Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Kelso, WAThe flight instructor’s delayed remedial action, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB GAA17CA369Accident · No injuriesData collectionFinal reportBell 206B · Entiat, WAThe pilot’s failure to secure a loose item inside the cockpit that interfered with antitorque pedal control and led to a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB GAA17CA251Accident · No injuriesData collectionFinal reportBender Joseph KIT Rotoway · Wheatland, WYThe pilot's decision to operate the helicopter in gusting wind and high-density altitude conditions and his positioning of the helicopter such that it resulted in a right quartering tailwind, which resulted in a loss of helicopter control due to a loss of…NTSB ERA17LA168Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Newton, NCThe pilot's failure to maintain an adequate airspeed during out-of-ground-effect maneuvering at a low airspeed with a tailwind, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB GAA17CA237Accident · No injuriesData collectionFinal reportBrantly B 2B · Earl Park, INThe pilot’s failure to recognize that he was operating in the weathercock stability flight regime of loss of tail rotor effectiveness, which resulted in a loss of directional control during the execution of a right pedal turn.