NTSB investigations: Bell 47G-3B

6 cases on aircraft the registry lists as Bell 47G-3B, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Bell 47G-3B per year, 1982–2026: 6 cases
1982	1
1983	1
1984	1
1990	1
1997	1
2005	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 ('1181026') 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

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 ('1181026')
      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 ('1181026')
    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

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 DFW05CA231Accident · No injuriesData collectionFinal reportBell 47 · Monette, ARThe loss of control as result of a loss of hydraulic pressure for undetermined reasons.Aug 16, 2005 · N8494E · Destroyed NTSB SEA97LA112Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Snohomish, WAthe pilot's encounter with of a loss of tail rotor effectiveness (LTE) situation, and his subsequent inadequate remedial action. Related factors included: wind conditions that were conducive to an unanticipated right yaw event, and the pilot's limited…May 15, 1997 · N8491E · Substantial damage NTSB FTW90DRD11Accident · No injuriesFinal reportBell 47G3-B · Houma, LAThe pilot's failure to maintain rotor RPM and an excessive sink rate.Jun 5, 1990 · N73241 · Substantial damage NTSB SEA84LA162Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Eagle Point, ORThe acft main rotor struck the ground during landing. The commercial plt had taken 2 passengers for a sight seeing tour and during landing he said one of them grabbed his right arm at 4 ft AGL and he was unable to recover before ground contact.Jul 5, 1984 · N73224 · Substantial damage NTSB CHI83LA264Accident · No injuriesLimited investigationFinal reportBell 47-G3B · Litchfield, MNThe helicopter rolled over while attempting a takeoff after servicing from a truck platform for a spraying operation. The hose used to put the chemical spray into the hopper was not removed. When takeoff was attempted the acft was tethered to the ground rig…Jun 17, 1983 · N8471E · Substantial damage NTSB ATL82FKQ12Accident · 1 fatalFinal reportBell/Soloy 47G-3B · Magee, MSThe Bell 47G-3B with a Soloy conversion was being used to demonstrate an aerial application spraying technique for use along powerline right-of-ways. For about 15 to 20 minutes after takeoff, routine spray runs were made over several different powerlines…Apr 27, 1982 · N8469E · Destroyed