Skip to content

NTSB investigations: Bell 47G-3B-1, WA

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

19652026

Where

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."eventStateOrRegion" = 'WA' 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

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.\"eventStateOrRegion\" = 'WA' 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"

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."eventStateOrRegion" = 'WA' 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

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 SEA05CA122Accident · Minor injuriesData collectionFinal reportBell 47G-3B-1 · Brewster, WAThe pilot's inadvertent anti-torque pedal input, which resulted in a loss of control and collision with trees while hovering.Jun 19, 2005 · N8554F · Substantial damage NTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…Apr 2, 2000 · N3377H · Destroyed NTSB SEA98LA064Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Sedro Wooley, WAFuel contamination and subsequent carburetor fuel flow restriction initiated by the use of an improper material (incorrect fuel hose). A factor was the trees.Apr 20, 1998 · N80SD · Destroyed NTSB SEA94LA042Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Mesa, WAThe pilot's improper flare. Factors include excessive airspeed while approaching the flare.Nov 15, 1993 · N1181W · Substantial damage NTSB SEA91LA251Accident · No injuriesLimited investigationFinal reportBell BH-47-G3B1 · Rock Island, WAThe failure of the pilot to use the proper touchdown point while landing on a trailer.Sep 26, 1991 · N5474A · Destroyed NTSB SEA91FA142Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Goldendale, WAThe pilot's misjudgement of fuel supply.Jun 26, 1991 · N7859S · Substantial damage NTSB SEA91LA109Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Malott, WAAn undetermined failure of the fuel pump casing resulting in an in flight fire and loss of engine power.May 19, 1991 · N73903 · Destroyed NTSB SEA86LA176Accident · 1 fatalLimited investigationFinal reportBell 47G-3B1 · Burbank, WAThe helicopter had landed for reloading and was stationary with rotors idling. A ground loader person approached the helicopter over a small sandy knoll and was struck by the main rotor, sustaining fatal injury.Jul 23, 1986 · N1197W · Minor damage NTSB SEA80FYP34Accident · No injuriesClosedBell 47G-2 · Sunnyside, WAAug 23, 1980 · N73284 · Substantial damage NTSB SEA78FA052Accident · No injuriesClosedBell 47G3B1 · Snoqualmie Fls, WAAug 7, 1978 · N1182W · Destroyed NTSB SEA77FYP29Accident · No injuriesClosedBell 47G3B1 · Pomeroy, WAApr 26, 1977 · N73919 · Substantial damage NTSB SEA75DYG37Accident · No injuriesClosedBell 47G3B1 · Palouse, WAMay 14, 1975 · N6257N · Destroyed NTSB SEA74DYG44Accident · No injuriesClosedBell 47G3B1 · Stratford, WAJun 4, 1974 · N1135W · Destroyed NTSB SEA74DYE44Accident · Minor injuriesClosedBell 47G3B1 · Forks, WAApr 8, 1974 · N1325X · Destroyed NTSB SEA73FYG13Accident · 1 fatalClosedBell 47-G2A · Selah, WASep 23, 1972 · N73284 · Substantial damage NTSB SEA71FWG15Accident · Minor injuriesClosedBell 47G3B1 · Colville, WASep 2, 1970 · N3097G · Substantial damage NTSB SEA71DWD09Accident · Minor injuriesClosedBell 47G3B1 · Diablo, WAAug 7, 1970 · N1182W · Substantial damage NTSB SEA68A0033Accident · No injuriesClosedBell 47G3B1 · Snoqualmie P, WAOct 11, 1967 · N1321X · Substantial damage NTSB SEA67A0046Accident · No injuriesClosedBell 47G-3B · Pomeroy, WAJan 4, 1967 · N73919 · Substantial damage NTSB SEA67A0036Accident · No injuriesClosedBell 47G3B1 · Cle Elum, WAOct 8, 1966 · N8518F · Substantial damage NTSB SEA65A0059Accident · Minor injuriesClosedBell 47G3B1 · Marblemount, WAApr 28, 1965 · N68645 · Substantial damage