# NTSB investigations: Allison 250 series: Part(s) separation from AC

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 WPR20LA224](https://openairdocs.org/ntsb/WPR20LA224.md): Hiller UH 12D · Mehama, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 17, 2020 · N2297W · Destroyed
  > An in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.
- [NTSB WPR19LA028](https://openairdocs.org/ntsb/WPR19LA028.md): Bell 430 · Kailua, HI · Accident · No injuries · Class 3 · Limited · Final report · Oct 27, 2018 · N430ST · Substantial damage
  > The separation of one of the tail rotors blades’ root enclosures due to improper repair.
- [NTSB CEN16LA330](https://openairdocs.org/ntsb/CEN16LA330.md): Hiller UH 12D · Cokeville, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 2016 · N97TH · Substantial damage
  > Failure of the control rotor cuff due to fatigue.
- [NTSB WPR10FA440](https://openairdocs.org/ntsb/WPR10FA440.md): Hiller UH 12E · Kamiah, ID · Accident · 3 fatal · Field investigation · Final report · Aug 31, 2010 · N67264 · Substantial damage
  > In-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…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03014', '03019')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '338'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/338/cases?engine=03014

---
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.
