# NTSB investigations: Bell 47G-3

A list on [Bell 47G-3](https://openairdocs.org/model/bell-47g-3.md).

Matched to the registry by N-number and event date, newest first.

- [NTSB NYC85LA081](https://openairdocs.org/ntsb/NYC85LA081.md): Bell 47G-3 · Plainsboro, NJ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N49882 · Substantial damage
  > The helicpopter crashed shortly after takeoff with 55 gallons of fertilizer on board. The plt stated that each time he made a swath run over the field the blades of the helicopter were picking up some of the liquid fertilizer. On takeoff helicopter felt…
- [NTSB NYC84FGT02](https://openairdocs.org/ntsb/NYC84FGT02.md): Bell 47G-3 · Landisburg, PA · Accident · No injuries · Final report · Jun 4, 1984 · N49882 · Substantial damage
  > The helicopter lost eng power while turning on approach for landing, autorotated to a hard landing with main rotor contact to the tail boom. Two gals of fuel were drained from the acft fuel tank at the accident site. An eng run up was performed & found…
- [NTSB MIA79ELA24](https://openairdocs.org/ntsb/MIA79ELA24.md): Bell 47G3 · Palatka, FL · Accident · Serious injuries · Closed · Apr 24, 1979 · N49882 · Destroyed
- [NTSB ANC76AA002](https://openairdocs.org/ntsb/ANC76AA002.md): Bell 47G-3 · Nondalton, AK · Accident · No injuries · Closed · Jun 28, 1975 · N8414E · Substantial damage
- [NTSB CHI74FEA04](https://openairdocs.org/ntsb/CHI74FEA04.md): Bell 47G-3 · Dana, IN · Accident · Serious injuries · Closed · Jul 13, 1973 · N8416E · Substantial damage
- [NTSB SEA73FTA07](https://openairdocs.org/ntsb/SEA73FTA07.md): Bell 47G-3 · Moore, MT · Accident · 1 fatal · Closed · May 19, 1973 · N8401E · Destroyed
- [NTSB OAK72DVD03](https://openairdocs.org/ntsb/OAK72DVD03.md): Bell 47G3 · Tracy, CA · Accident · No injuries · Closed · Jul 11, 1971 · N6787D · Substantial damage
- [NTSB SEA70FDA06](https://openairdocs.org/ntsb/SEA70FDA06.md): Bell 47G3 · Jordan, MT · Accident · No injuries · Closed · May 1, 1970 · N6787D · Substantial damage
- [NTSB SEA70D0079](https://openairdocs.org/ntsb/SEA70D0079.md): Bell 47G-3 · Circle, MT · Accident · No injuries · Closed · Sep 12, 1969 · N6787D · Substantial damage
- [NTSB DEN68A0035](https://openairdocs.org/ntsb/DEN68A0035.md): Bell 47G-3 · Yellowstone P, WY · Accident · No injuries · Closed · Feb 3, 1968 · N8416E · Substantial damage
- [NTSB SEA68A0006](https://openairdocs.org/ntsb/SEA68A0006.md): Bell 47G-3 · Fairfield, MT · Accident · No injuries · Closed · Jul 10, 1967 · N8414E · Substantial damage
- [NTSB SEA67A0024](https://openairdocs.org/ntsb/SEA67A0024.md): Bell 47G-3 · Challis, ID · Accident · No injuries · Closed · Sep 17, 1966 · N8461E · Substantial damage
- [NTSB SEA66A0053](https://openairdocs.org/ntsb/SEA66A0053.md): Bell 47G-3B · Missoula, MT · Accident · No injuries · Closed · Apr 30, 1966 · N8414E · Substantial damage
- [NTSB OAK66A0046](https://openairdocs.org/ntsb/OAK66A0046.md): Bell 47G-3 · Sierra City, CA · Accident · No injuries · Closed · Mar 30, 1966 · N8437E · Substantial damage
- [NTSB DEN66A0021](https://openairdocs.org/ntsb/DEN66A0021.md): Bell 47G3 · South Fork, CO · Accident · Minor injuries · Closed · Sep 14, 1965 · N73913 · Substantial damage
- [NTSB DEN66A0008](https://openairdocs.org/ntsb/DEN66A0008.md): Bell 47G3B · Phoenix, AZ · Accident · No injuries · Closed · Jul 12, 1965 · N6788D · Substantial damage
- [NTSB DEN65A0084](https://openairdocs.org/ntsb/DEN65A0084.md): Bell B-47G3 · 10sw Payson, AZ · Accident · No injuries · Closed · Jun 25, 1965 · N6788D · Substantial damage
- [NTSB ANC65A0047](https://openairdocs.org/ntsb/ANC65A0047.md): Bell 47G3 · Anchorage, AK · Accident · Serious injuries · Closed · Apr 27, 1965 · N8413E · Destroyed
- [NTSB UNK65X0344](https://openairdocs.org/ntsb/UNK65X0344.md): Bell 47G3 · Stevensville, MT · Accident · No injuries · Closed · Oct 20, 1964 · N8418E · Destroyed
- [NTSB UNK64X0604](https://openairdocs.org/ntsb/UNK64X0604.md): Bell 47G-3 · Moab, UT · Accident · No injuries · Closed · Feb 18, 1964 · N8461E · Substantial damage

## 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1181024')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/model/bell-47g-3/ntsb

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