NTSB investigations, CA
7 cases where NTSB found Tail rotor drive system.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2022 | 3 |
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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010465'))
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010465')) 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 WPR23LA004Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206B · Fresno, CAThe disbond of a tail rotor drive shaft splined adapter, which resulted in a loss of tail rotor drive and a subsequent hard landing.NTSB WPR22LA340Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Banning, CAThe improper attachment of the tail rotor drive shaft to the air conditioner drive pulley without a drive ring, which resulted in the failure of the hardware, a loss of tail rotor drive, and the loss of control of the helicopter followed by a hard landing and…NTSB WPR22LA084Accident · No injuriesClass 3 · LimitedFinal reportBell UH-1E · Gustine, CAFailure of the 90° gearbox due to the lack of lubricating oil, which resulted in a loss of rotational drive to the tail rotor and a subsequent loss of control of the helicopter.NTSB WPR14LA225Accident · No injuriesLimited investigationFinal reportEmery Mark Rotorway 162F · Merced, CAThe helicopter pilot/owner's decision to install a belt type not recommended by the kit manufacturer in the tail rotor drive system using the incorrect tension values, which led to the belt’s in-flight failure and the subsequent loss of tail rotor drive…NTSB WPR11LA282Accident · No injuriesLimited investigationFinal reportHiller UH12E · Hanford, CAThe separation of the tail rotor drive gear shaft due to torsional fatigue of its threaded portion, which resulted in a loss of tail rotor control.NTSB WPR09LA226Accident · No injuriesLimited investigationFinal reportMD Helicopter 369FF · Santa Clarita, CAThe pilot's failure to maintain clearance from the water while maneuvering at low altitude as a result of the helicopter's grappling hook temporarily becoming ensnared with an underwater obstruction.NTSB LAX08LA183Accident · Minor injuriesLimited investigationFinal reportRobinson R44 II · Topanga, CAThe in-flight separation of the tail rotor gear box for an undetermined reason. Contributing to the accident was the hilly terrain, which was unsuitable for a forced landing.