# NTSB investigations: Bell 47G-2, AR

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 FTW02LA264](https://openairdocs.org/ntsb/FTW02LA264.md): Bell 47G-2 · Edmondson, AR · Accident · 1 fatal · Limited investigation · Final report · Sep 25, 2002 · N5193B · Destroyed
  > The pilot's failure to maintain clearance from the high voltage power lines.
- [NTSB MKC88LA092](https://openairdocs.org/ntsb/MKC88LA092.md): Bell 47G-2 · Mc Dougal, AR · Accident · No injuries · Limited investigation · Final report · May 19, 1988 · N4690 · Substantial damage
  > The pilot stated that he had just begun the spraying of a rice field when one of the spray nozzles malfunctioned. As he was attempting to set the helicopter down on the ground, to work on the nozzle, the main rotor blades struck a tree. The main rotor blades…
- [NTSB FTW79DPG55](https://openairdocs.org/ntsb/FTW79DPG55.md): Bell 47G-2 · Earle, AR · Accident · No injuries · Closed · Jun 19, 1979 · N3550 · Substantial damage
- [NTSB FTW77FPG86](https://openairdocs.org/ntsb/FTW77FPG86.md): Bell 47G2H1 · Mountain View, AR · Accident · No injuries · Closed · Sep 19, 1977 · N38926 · Destroyed
- [NTSB FTW76AF081](https://openairdocs.org/ntsb/FTW76AF081.md): Bell 47G-2 · Jonesboro, AR · Accident · No injuries · Closed · Mar 30, 1976 · N8422E · Substantial damage
- [NTSB FTW75DPG68](https://openairdocs.org/ntsb/FTW75DPG68.md): Bell 47G-2 · Denmark, AR · Accident · Minor injuries · Closed · May 26, 1975 · N38926 · Substantial damage
- [NTSB FTW74FPG23](https://openairdocs.org/ntsb/FTW74FPG23.md): Bell 47G2 · Viola, AR · Accident · Serious injuries · Closed · Sep 18, 1973 · N2870B · Substantial damage
- [NTSB FTW71DPG02](https://openairdocs.org/ntsb/FTW71DPG02.md): Bell 47G-2 · Norfork, AR · Accident · No injuries · Closed · Jul 30, 1970 · N6744D · 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_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" = 'AR' 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 ('1181008'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1181008&state=AR

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