# NTSB investigations: Bell 47G-3B-1, FL

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 MIA93LA014](https://openairdocs.org/ntsb/MIA93LA014.md): Bell 47-G3-B1 · Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1992 · N94720 · Substantial damage
  > The pilot's inadequate preflight planning. A factor was the pilot's failure to maintain rotor RPM during the autorotation.
- [NTSB MIA90LA125](https://openairdocs.org/ntsb/MIA90LA125.md): Bell 47G-3B-1 · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · May 21, 1990 · N1390X · Destroyed
  > The pilot's failure to maintain adequate clearance between the main rotor blades and a power line pole while maneuvering during an aerial application flight.
- [NTSB MIA89LA165](https://openairdocs.org/ntsb/MIA89LA165.md): Bell 47G-3B-1 · Keystone Hgts., FL · Accident · Minor injuries · Limited investigation · Final report · May 30, 1989 · N53SP · Substantial damage
  > The tail rotor drive system became disconnected due to a bent tail rotor drive shaft. The trees contributed to the helicopter damage.
- [NTSB MIA86LA152](https://openairdocs.org/ntsb/MIA86LA152.md): Bell 47G-3B-1 · Panama City, FL · Accident · No injuries · Limited investigation · Final report · May 9, 1986 · N1159W · Substantial damage
  > While approaching to land during a sightseeing flt a loss of eng pwr was experienced and an autorotation was made 70 ft short of the helipad. During touchdown, the main rotor struck and severed the tail boom. The plt stated after touchdown the eng continued…

## 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" = 'FL' 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 ('1181028', '118103A'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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