# Fatal NTSB investigations: Bell 47G

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 DFW07WA110](https://openairdocs.org/ntsb/DFW07WA110.md): Bell 47G · Ciudad Victoria, Mexico · Accident · 1 fatal · Foreign investigation · May 12, 2007 · N25802 · Substantial damage
- [NTSB FTW98FA306](https://openairdocs.org/ntsb/FTW98FA306.md): Bell 47G · Jones, OK · Accident · 2 fatal · Field investigation · Final report · Jul 10, 1998 · N12085 · Destroyed
  > The pilot's failure to maintain adequate clearance from the trees during a low altitude flight/maneuver.
- [NTSB FTW98FA238](https://openairdocs.org/ntsb/FTW98FA238.md): Bell 47G · Bixby, OK · Accident · 1 fatal · Field investigation · Final report · May 24, 1998 · N9954F · Substantial damage
  > The pilot's failure to maintain clearance from the power lines.
- [NTSB MIA97FA248](https://openairdocs.org/ntsb/MIA97FA248.md): Bell 47G · Saluda, SC · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1997 · N70747 · Destroyed
  > in-flight collision with a tree, for undetermined reason(s).
- [NTSB LAX93FA272](https://openairdocs.org/ntsb/LAX93FA272.md): Bell 47G2-M · S. Sn Francisco, CA · Accident · 1 fatal · Field investigation · Final report · Jul 2, 1993 · N2473B · Destroyed
  > The pilot's inadequate preflight planning/preparation which resulted in flight into high winds, turbulence and windshear.
- [NTSB MIA93FA121](https://openairdocs.org/ntsb/MIA93FA121.md): Bell 47-G · Parker, FL · Accident · 2 fatal · Field investigation · Final report · May 16, 1993 · N970B · Destroyed
  > the misjudgement of the distance by the nonrated pilot-in-command and subsequent collision with a tree. Contributing to the accident was the lack of helicopter experience of the pilot-in-command.
- [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 MKC78FA065](https://openairdocs.org/ntsb/MKC78FA065.md): Bell 47-G2 · Branson, MO · Accident · 3 fatal · Closed · Aug 18, 1978 · N939B · Destroyed
- [NTSB FTW78FA032](https://openairdocs.org/ntsb/FTW78FA032.md): Bell 47G · Eola, TX · Accident · 1 fatal · Closed · Mar 15, 1978 · N967B · Destroyed
- [NTSB FTW71AF085](https://openairdocs.org/ntsb/FTW71AF085.md): Bell 47G-4A · New Orleans, LA · Accident · 1 fatal · Closed · Jun 21, 1971 · N7814S · Destroyed
- [NTSB MIA69F0149](https://openairdocs.org/ntsb/MIA69F0149.md): Bell 47G · Merigold, MS · Accident · 1 fatal · Closed · Sep 2, 1968 · N10175 · Destroyed
- [NTSB CHI67A0128](https://openairdocs.org/ntsb/CHI67A0128.md): Bell 47G · Dearborn, MI · Accident · 1 fatal · Closed · Jun 3, 1967 · N953B · Destroyed
- [NTSB UNK64X3405](https://openairdocs.org/ntsb/UNK64X3405.md): Bell 47G · Alameda, CA · Accident · 1 fatal · Closed · Aug 15, 1964 · N179B · Destroyed
- [NTSB UNK64X2560](https://openairdocs.org/ntsb/UNK64X2560.md): Bell 47G · Ogden, UT · Accident · 1 fatal · Closed · Jun 29, 1964 · N19H · Destroyed
- [NTSB UNK64X0867](https://openairdocs.org/ntsb/UNK64X0867.md): Bell 47G · Grand Isle, LA · Accident · 2 fatal · Closed · Mar 10, 1964 · N994B · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=1181002

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