Skip to content

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

20 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

19662026

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" = 'OR' 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\" = 'OR' 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" = 'OR' 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 WPR10CA470Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's failure to maintain tail rotor clearance while landing on a transport trailer positioned on an uneven surface.Sep 26, 2010 · N7860S · Substantial damage NTSB SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.Jun 23, 2004 · N73909 · Substantial damage NTSB SEA03LA189Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Diamond, ORLoss of engine power for undetermined reasons during hover.Sep 12, 2003 · N48020 · Substantial damage NTSB SEA00LA124Accident · Minor injuriesLimited investigationFinal reportBell 47G · Haines, ORThe pilot's failure to correctly judge his rate of descent and his failure to initiate his level off soon enough to keep the helicopter from impacting the terrain. Factors include hilly terrain near the edge of the field he was spraying.Jul 4, 2000 · N30DP · Substantial damage NTSB SEA94LA065Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Gold Hill, ORSeparation of the crossover fuel line, and the inability of the pilot in command to maintain a proper rate of descent during the autorotation.Feb 24, 1994 · N73909 · Destroyed NTSB SEA92LA067Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Miltonfreewater, ORThe inadequate prelight preparation by the pilot in his failure to ensure the filler hose was removed before attempting to takeoff.Apr 2, 1992 · N7920S · Substantial damage NTSB SEA86LA182Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORA Bell 47G3B1 crashed into the south santiam river after contacting power lines while on an instructional flight. The CFI (helicopter) plt received serious injuries and the private plt (airplane) helicopter student received minor injuries. The helicopter…Jul 29, 1986 · N9417A · Substantial damage NTSB SEA86LA105Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORThe plt reported that after aprx 15 minutes of flt, the eng sputtered 2 or 3 times. An autorotation was performed onto rough terrain during which the tail rotor drive shaft was damaged by the main rotor blades. Post accident inspection revealed a hole in the…Apr 15, 1986 · N9417A · Substantial damage NTSB SEA85LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Lebanon, ORThe plt stated he performed 4 circling approaches over a sand bar and on the 5th approcah, rotor RPM decayed. Unable to regain the RPM, a hard landing resulted during which the main rotor blades severed the tailrotor.Jul 19, 1985 · N9417A · Substantial damage NTSB SEA80FA018Accident · 2 fatalClosedBell 47G3B1 · Jefferson, ORJan 30, 1980 · N73285 · Destroyed NTSB SEA78DYK11Accident · No injuriesClosedBell 47G3B1 · Myrtle Creek, ORMar 6, 1978 · N73984 · Substantial damage NTSB SEA78FYM02Accident · Minor injuriesClosedBell 47G3B1 · Alsea, OROct 2, 1977 · N1199W · Substantial damage NTSB SEA74DYC54Accident · Minor injuriesClosedBell 47G-3B · North Powder, ORMay 24, 1974 · N73940 · Substantial damage NTSB SEA73FYC37Accident · Serious injuriesClosedBell 47G-3B · Warm Springs, ORJun 21, 1973 · N1324X · Destroyed NTSB SEA72DYC08Accident · No injuriesClosedBell 47G3B1 · Legrande, ORJul 20, 1971 · N1324X · Destroyed NTSB SEA71FYC38Accident · No injuriesClosedBell 47G-3B · Elgin, ORApr 30, 1971 · N73940 · Substantial damage NTSB SEA71DVQ16Accident · No injuriesClosedBell 47G-2 · Sixes, ORDec 21, 1970 · N73284 · Substantial damage NTSB SEA70DWA14Accident · No injuriesClosedBell 47G3B1 · Cove, ORMay 3, 1970 · N73940 · Substantial damage NTSB SEA68A0010Accident · 1 fatalClosedBell 47G3B1 · Rufus, ORJul 30, 1967 · N8518F · Destroyed NTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORDec 14, 1966 · N8554F · Substantial damage