# NTSB investigations, TX: Main rotor drive

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA20LA054](https://openairdocs.org/ntsb/ERA20LA054.md): Robinson R44 · San Antonio, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Dec 14, 2019 · N440AH · Substantial damage
  > Maintenance personnel’s failure to complete all necessary steps of a service bulletin and subsequent failure to identify the loose lower actuator bearing support bracket during inspections, which resulted in the misalignment of the clutch actuator, resulted…
- [NTSB CEN12LA228](https://openairdocs.org/ntsb/CEN12LA228.md): Enstrom 280FX · Corpus Christi, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 2012 · N3042D · Substantial damage
  > The failure of the bolt that retained the clutch drive rod end, which resulted in a loss of main rotor drive and a subsequent hard landing.
- [NTSB DFW08CA152](https://openairdocs.org/ntsb/DFW08CA152.md): Rotorway 162F · Gonzales, TX · Accident · Serious injuries · Data collection · Final report · May 24, 2008 · N771SS · Destroyed
  > failure of the main rotor drive belt for undetermined reasons.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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" = 'TX' 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", '010463'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010463/cases?state=TX

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
