# NTSB investigations: Bell 47G-2, IN

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 CEN18FA258](https://openairdocs.org/ntsb/CEN18FA258.md): Bell 47G · Arlington, IN · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2018 · N96195 · Substantial damage
  > The inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.
- [NTSB CHI04CA229](https://openairdocs.org/ntsb/CHI04CA229.md): Bell 47G2 · Muncie, IN · Accident · No injuries · Data collection · Final report · Aug 14, 2004 · N96MB · Destroyed
  > The engine failure for an undetermined reason, and the pilot's inability to properly level-off for landing due to the low rotor speed, which resulted in the hard landing. The low altitude where the engine failure occurred was a factor.
- [NTSB CHI90LA067](https://openairdocs.org/ntsb/CHI90LA067.md): Bell 47-G2 · Lafayette, IN · Accident · No injuries · Limited investigation · Final report · Jan 17, 1990 · N90836 · Substantial damage
  > The helicopter student's iproper use of the collective pitch lever during the landing phase of flight. The pilot's lack of total expereince, the relatively high wind, and inadvertent liftoff of the helicopter were factors related to the accident.
- [NTSB CHI78FEX40](https://openairdocs.org/ntsb/CHI78FEX40.md): Bell 47G2 · Waveland, IN · Accident · Minor injuries · Closed · Sep 23, 1978 · N8429E · Substantial damage
- [NTSB CHI77FET11](https://openairdocs.org/ntsb/CHI77FET11.md): Bell 47G2 · Kentland, IN · Accident · Minor injuries · Closed · Mar 25, 1977 · N90836 · Substantial damage
- [NTSB CHI75FEA21](https://openairdocs.org/ntsb/CHI75FEA21.md): Townsend 47G2 · Earl Park, IN · Accident · No injuries · Closed · May 11, 1975 · N90836 · Destroyed
- [NTSB CHI72FET06](https://openairdocs.org/ntsb/CHI72FET06.md): Bell 47G-2 · Laporte, IN · Accident · Minor injuries · Closed · Aug 18, 1971 · N2495B · 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" = 'IN' 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=IN

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