NTSB investigations: Bell 47G-2

6 cases on aircraft the registry lists as Bell 47G-2, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19822026
NTSB investigations: Bell 47G-2 per year, 1982–2026: 6 cases
19822
19831
19862
19871

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 ('1181008')
      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\" = 351))
  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.

NTSB MIA87IA185Incident · No injuriesIncident investigationFinal reportBell 47G-2 · Miami, FLWhile in cruise flt at aprx 300 ft the plt reported that he heard a loud noise followed by a loss of power. He then autorotated & set the helicopter down with no further incident. Insp of the eng revealed that the number 6 cylinder connecting rod failed near…Jun 17, 1987 · N17271 · Minor damageNTSB SEA86LA168Accident · No injuriesLimited investigationFinal reportBell 47G2A · Chehalis, WADuring an aerial applications maneuver, a complete loss of power occurred. The power loss was caused by failure of the connecting rod bolt. The acft was too low for autorotation and the aircraft struck the ground tail low. The main rotor blade then struck the…Jul 13, 1986 · N12848 · Substantial damageNTSB SEA86LA143Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAEn route to the local spray area a total loss of power occurred along with a loss of oil pressure. The acft was aprx 200 ft AGL over a pear orchard. The plt was attempting to autorotate onto a nearby road but the left skid caught the roof top of a metal shed.…Jun 12, 1986 · N11VH · DestroyedNTSB FTW83FA311Accident · Minor injuriesField investigationFinal reportBell 47G-2 · Bethany, OKThe helicopter collided with trees and rolled over during a forced landing after engine failure. The plt had been takingpassengers up for sight-seeing for several hours. After the last flt he and his wife had departed the city park to fly back to the acft…Jul 3, 1983 · N2495B · DestroyedNTSB LAX83LVM01Accident · No injuriesFinal reportBell 47G2 · 5nm East Of Sal, CAAfter takeoff, during an aerial application flight, the pilot felt a sudden jolt and the engine RPM revved then decayed very rapidly. The pilot made a hard landing and the main rotor severed the tail rotor. The aircraft was within the weight and balance…Oct 10, 1982 · N5159B · Substantial damageNTSB SEA82DA072Accident · No injuriesFinal reportBell 47G-2 · Grandview, WAWhile dispensing herbicide (systox) over an apple orchard the pilot sensed that the engine was binding followed by a power loss. The pilot elected to dump the herbicide and performed a power-off autorotation landing in a grape vineyard. Investigation revealed…May 18, 1982 · N11VH · Substantial damage