# NTSB investigations: Hiller UH-12D, TX

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 FTW01LA202](https://openairdocs.org/ntsb/FTW01LA202.md): Hiller UH-12D · Lubbock, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 3, 2001 · N2770 · Substantial damage
  > the failure of the tail rotor drive shaft hanger bearing, which resulted in the separation of the tail rotor drive shaft. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW85LA135](https://openairdocs.org/ntsb/FTW85LA135.md): Hiller UH-12D · Big Spring, TX · Accident · No injuries · Limited investigation · Final report · Mar 2, 1985 · N26EW · Substantial damage
  > CFI was demonstrating a simulated eng failure with tailwind of 10 KTS, 20 KTS grnd speed. The acft yawed left and touchdown was made with 10 kt grnd speed. The right skid broke off and the acft rolled over. The maneuver was initiated at 4 ft skid height.

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360118'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=4360118&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.
