# NTSB investigations: Bell 47G: 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 ATL01LA108](https://openairdocs.org/ntsb/ATL01LA108.md): Bell 47G · Berry, AL · Accident · No injuries · Limited investigation · Final report · Sep 7, 2001 · N6327D · Substantial damage
  > The failure of the main rotor system stabilizer damper control horn assembly, resulting in an uncontrolled descent and subsequent collision with a tree and terrain.
- [NTSB MIA89LA229](https://openairdocs.org/ntsb/MIA89LA229.md): Bell 47G · Ponce, PR · Accident · No injuries · Limited investigation · Final report · Aug 23, 1989 · N955B · Substantial damage
  > Failure of the aft tail rotor drive shaft.
- [NTSB NYC87FA114](https://openairdocs.org/ntsb/NYC87FA114.md): Bell 47G · Wassaic, NY · Accident · 2 fatal · Field investigation · Final report · Mar 19, 1987 · N13766 · Destroyed
  > The Bell 47G helicopter was on a aerial survey of buried telephone cable when the red main rotor blade separated from the blade grips in flight. The main rotor hub with the main rotor blade separated from the transmission and the helicopter crashed. No…
- [NTSB NYC83FHM01](https://openairdocs.org/ntsb/NYC83FHM01.md): Bell 47G · Plainsboro, NJ · Accident · Minor injuries · Final report · May 15, 1983 · N6597D · Destroyed
  > The acft collided with the ground after a tail rotor drive shaft failed. The plt lost tail rotor control during an aerial application maneuver. The metallurgist report of examination and discovery of fatigue fracture after the accident is a part of the…
- [NTSB LAX82FA341](https://openairdocs.org/ntsb/LAX82FA341.md): Bell 47G-2 · San Diego, CA · Accident · Minor injuries · Field investigation · Final report · Sep 11, 1982 · N4242A · Destroyed
  > The plt was in the local pattern practicing maneuvers. After completing a quick stop maneuver & hovering, another takeoff was initiated. The plt stated that it seemed to take an unusual amount of forward cyclic to initiate forward flt. During the final…

## 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 ('1181002')
    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=1181002&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.