NTSB investigations: Bell 47G-2

8 cases on aircraft the registry lists as Bell 47G-2, where the first occurrence was “In flight collision with terrain/water”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Bell 47G-2 per year, 1982–2026: 8 cases
1982	2
1983	1
1984	1
1985	1
1987	1
1989	1
1991	1

Where

Open the map

Latest cases

Query with 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."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" = 230)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 230))
  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 ('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" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW91LA125Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Slidell, LAThe pilot performing a touchdown autorotation to unsuitable terrain. Factors were the soft terrain and the inadequate supervision by the FAA inspector.Jul 22, 1991 · N312SH · Substantial damage NTSB BFO89LA045Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Moundsville, WVThe pilot failed to maintian directional control and obstacle clearance while hovering at low altitude. A tail rotor blade struck an obstacle causing an overload separation failure of the blade.Jun 17, 1989 · N2487B · Destroyed NTSB ATL87LA222Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Huntsville, ALThe helicopter impacted the water during a low-altitude turn over a river. The plt made a low pass to the south over an island at about 30 ft AGL, to show the island to the policewoman/traffic observer onboard. As he was making a climbing right turn at about…Jul 23, 1987 · N972B · Substantial damage NTSB LAX86LA070Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Moss, CAAfter starting a left climbing turn at the end of a spray run the plt said he felt a 'shudder in the airframe' as the engine 'went to full RPM.' The plt stated that he thought 'the clutch had slipped' and added collective to compensate. The helicopter began…Dec 19, 1985 · N8404E · Substantial damage NTSB CHI84LA245Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · Nimrod, MNWhile landing in an area of tall grass a skid collided with a sand ridge causing a roll over.Jun 18, 1984 · N18JM · Destroyed NTSB MIA83LA196Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Miami, FLThe student was a rated single eng, multiengine, land plt, but did not have a helicopter rating. During a dual instructional flt, he had just completed the final phase of an autorotation & the skids were on the ground, when he abruptly pulled the collective…Aug 5, 1983 · N471KC · Substantial damage NTSB MKC82DA082Accident · Minor injuriesFinal reportBell 47G2 · Thornton, IADuring the downwind turn for the fourth spraying pass the pilot encountered a gust of wind. The pilot stated he applied power, collective and cyclic to level off at spraying altitude but the wind was too strong to prevent the tailboom from striking the ground.May 14, 1982 · N8426E · Substantial damage NTSB SEA82DA050Accident · No injuriesFinal reportBell 47G-2A · Lyle, WADuring takeoff with a load of fertilizer, insufficient power was available to maintain engine and rotor RPM and sustain flight. The pilot dumped the load, but was unable to avoid ground contact. The tail rotor struck first and separated from the aircraft. The…Apr 10, 1982 · N11VH · Substantial damage