NTSB investigations: Bell 47G
7 cases on aircraft the registry lists as Bell 47G, where the first occurrence was “Loss of control - in flight”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1998 | 1 |
Where
Latest cases
Query with SQL
duckdb -csv -c "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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181002')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB FTW98LA371Accident · No injuriesLimited investigationFinal reportBell 47G · Monette, ARThe pilot's failure to maintain control. A factor was his lack of total flight experience in helicopters.NTSB MIA91LA141Accident · No injuriesLimited investigationFinal reportBell 47-G · Aguadilla, PRThe improper in flight planning/decision of the pilot-in-command to conduct an out-of-ground-effect hover with a right crosswind. This resulted in an in flight loss of control due to settling with power and in flight collision with terrain.NTSB FTW86LA043Accident · No injuriesLimited investigationFinal reportBell 47G · Beaumont, TXThe pilot was taking off from an area which was protected from the wind by a large building. After obtaining translational lift and climbing above the building, a right quartering tail wind, with gusts to 20 knots, was encountered. The pilot stated he lost…NTSB MKC85LA152Accident · Minor injuriesLimited investigationFinal reportBell 47G · Pella, IAThe purpose of the flt was to provede training in aerial application procedures and techniques for the plt/owner of N75273. The instructor plt has extensive experience in this m/m and was at the controls. He was demonstrating a turn around at the end of a…NTSB ATL83LA354Accident · No injuriesLimited investigationFinal reportBell 47G · Charleston, WVThe helicopter settled after takeoff and rolled over after touching down on sloping terrain. One of the two pilots aboard was being transported to receive a private rating in helicopters. He had been endorsed for solo in the Bell 47 and had flown the Bell 47…NTSB CHI82DA176Accident · Minor injuriesFinal reportBell 47G-1 · Cincinnati, OHThe fore and aft cyclic control linkage tube became disconnected in flight. An emergency descent, using collective "s" turns to reduce airspeed was performed. The pilot intentionally collided with trees during the forced landing to cushion the fall.…NTSB MKC82DA080Accident · No injuriesFinal reportBell 47G-2 · Osage Beech, MOShortly 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…