# NTSB investigations: Bell 47G, MO

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 MKC89LA195](https://openairdocs.org/ntsb/MKC89LA195.md): Bell 47G · Ozark, MO · Accident · No injuries · Limited investigation · Final report · Sep 2, 1989 · N182JR · Substantial damage
  > The failure of the dual student to properly flare during an autorotative landing resulting in a hard landing and partial failure of the right skid. The CFI also failed to properly monitor the student's actions on the flight controls.
- [NTSB MKC82DA080](https://openairdocs.org/ntsb/MKC82DA080.md): Bell 47G-2 · Osage Beech, MO · Accident · No injuries · Final report · May 15, 1982 · N208B · Destroyed
  > Shortly after the helicopter cleared the helipad the pilot noticed that although he had the cyclic positioned in the full forward position against the stop the airspeed was gradually decaying. The pilot then removed his seatbeat and moved forward. Along with…
- [NTSB MKC78FA065](https://openairdocs.org/ntsb/MKC78FA065.md): Bell 47-G2 · Branson, MO · Accident · 3 fatal · Closed · Aug 18, 1978 · N939B · Destroyed
- [NTSB MKC74FCG06](https://openairdocs.org/ntsb/MKC74FCG06.md): Bell 47G-2 · Branson, MO · Accident · Minor injuries · Closed · Aug 12, 1973 · N939B · Substantial damage
- [NTSB MKC73FCA14](https://openairdocs.org/ntsb/MKC73FCA14.md): Bell 47G · Chesterfield, MO · Accident · No injuries · Closed · Jan 24, 1973 · N9655 · 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" = 'MO' 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 ('1181002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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