# NTSB investigations: Bell 47G-2, IA

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 CEN11CA540](https://openairdocs.org/ntsb/CEN11CA540.md): Bell 47G-2 · Charles City, IA · Accident · Serious injuries · Data collection · Final report · Aug 2, 2011 · N4771N · Substantial damage
  > The pilot's failure to refuel the helicopter which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB MKC82DA082](https://openairdocs.org/ntsb/MKC82DA082.md): Bell 47G2 · Thornton, IA · Accident · Minor injuries · Final report · May 14, 1982 · N8426E · Substantial damage
  > During the downwind turn for the fourth spraying pass the pilot encountered a gust of wind. The pilot stated he applied power, collective and cyclic to level off at spraying altitude but the wind was too strong to prevent the tailboom from striking the ground.
- [NTSB MKC79DCD28](https://openairdocs.org/ntsb/MKC79DCD28.md): Bell 47-G2 · Anthon, IA · Accident · No injuries · Closed · Jul 3, 1979 · N85Z · Destroyed
- [NTSB MKC72FCD63](https://openairdocs.org/ntsb/MKC72FCD63.md): Bell 47G-2 · Fremont, IA · Accident · Minor injuries · Closed · Mar 20, 1972 · N976B · 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" = 'IA' 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=IA

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