# NTSB investigations: Hiller H-23D: Airframe/component/system failure/malfunction

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 CHI89DEP07](https://openairdocs.org/ntsb/CHI89DEP07.md): Hiller UH-12E · Blackriverfalls, WI · Accident · Minor injuries · Final report · Jul 20, 1989 · N48313 · Destroyed
  > Pilot-in-command's failure to jettison the external load followed by his misjudgement of distance to avoid collision with the external load.
- [NTSB LAX87DVD04](https://openairdocs.org/ntsb/LAX87DVD04.md): Hiller UH-23-D · Brentwood, CA · Accident · No injuries · Final report · Aug 5, 1987 · N61PC · Substantial damage
  > During an aerial application flight, the tail boom weight separated and contacted the tail rotor. The pilot lost control of the aircraft and collided with a tree and subsequently the terrain. Post acc invest revealed that the 'pip pins' which secure the tail…
- [NTSB MKC84LA205](https://openairdocs.org/ntsb/MKC84LA205.md): Hiller H-23D · Neelyville, MO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N48313 · Destroyed
  > The acft rolled over during an emergency landing. The plt claimed that the rotor disengaged at about 30 ft AGL during takeoff. After the accident the upper half of the yoke control was found fractured. A lab report stated that no materialdefects were related…

## 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.aircraft_model_code IN ('4360120')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=4360120&occurrence=130

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