# NTSB investigations: Bell 47G-2, MI

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 CEN13LA086](https://openairdocs.org/ntsb/CEN13LA086.md): Bell 47G-2 · Walkerville, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 1, 2012 · N3755Z · Substantial damage
  > The pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.
- [NTSB CHI88DEM05](https://openairdocs.org/ntsb/CHI88DEM05.md): Bell 47G-2A · Midland, MI · Accident · No injuries · Final report · May 31, 1988 · N440TG · Substantial damage
  > The plt rprtd that before takeoff, he checked the fuel gage & concluded there was enough fuel to dispense his load. However, after spraying out the load, he started to return to the landing site & then the eng lost power from fuel exhaustion. The helicopter…
- [NTSB CHI85FA198](https://openairdocs.org/ntsb/CHI85FA198.md): Bell 47G-2 · Burlington, MI · Accident · 1 fatal · Field investigation · Final report · May 16, 1985 · N3755J · Substantial damage
  > The helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.
- [NTSB CHI76FEC35](https://openairdocs.org/ntsb/CHI76FEC35.md): Bell 47G-2 · Whitmore Lake, MI · Accident · No injuries · Closed · Mar 26, 1976 · N2873B · Destroyed
- [NTSB CHI75FEM12](https://openairdocs.org/ntsb/CHI75FEM12.md): Bell 47G-2 · Paw Paw, MI · Accident · Minor injuries · Closed · Sep 21, 1974 · N7893B · Substantial damage
- [NTSB CHI73FEM61](https://openairdocs.org/ntsb/CHI73FEM61.md): Bell 47G2 · Marquette, MI · Accident · Minor injuries · Closed · May 15, 1973 · N6725D · Substantial damage
- [NTSB CHI72FEM23](https://openairdocs.org/ntsb/CHI72FEM23.md): Bell 47G2 · Manistee, MI · Accident · No injuries · Closed · Sep 4, 1971 · N10NR · 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."eventStateOrRegion" = 'MI' 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=MI

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