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

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

19692026

NTSB investigations: Bell 47G-3B-2, OR per year, 1969–2026: 10 cases
1969	1
1971	1
1978	2
1980	1
1981	1
1987	1
1996	1
2003	1
2014	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."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 ('1181029', '1181036')) 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 ('1181029', '1181036'))
  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 ('1181029', '1181036'))
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 WPR14CA280Accident · No injuriesData collectionFinal reportBell 47G · Gaston, ORThe pilot's inability to maintain control of the helicopter as a result of a hydraulic hose becoming entangled around the right skid.Jul 3, 2014 · N684PC · Substantial damage NTSB SEA04LA018Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Monmouth, ORFatigue failure of a tail rotor blade during hover operations.Nov 18, 2003 · N7825S · Substantial damage NTSB SEA97LA035Accident · 2 fatalLimited investigationFinal reportBell 47G · Pendleton, ORThe pilot-in-command's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with hilly terrain. A contributing factor in the accident was the presence of fog.Dec 10, 1996 · N4758R · Destroyed NTSB SEA87LA118Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-2 · Milton-Freewatr, ORThe pilot was hovering up rising terrain at a slow airspeed, at 15 feet above the ground while on an agricultural spraying flight and encountered settling with power. The aircraft entered an uncontrolled descent and impacted the ground.Jun 12, 1987 · N2219W · Destroyed NTSB SEA81DYM48Accident · No injuriesClosedBell 47G3B1 · Albany, ORSep 30, 1981 · N2243W · Substantial damage NTSB SEA80DYM29Accident · No injuriesClosedBell 47G-3B · Albany, ORMar 28, 1980 · N2243W · Substantial damage NTSB SEA78FYM25Accident · No injuriesClosedBell 47G · Kings Valley, ORApr 15, 1978 · N2919W · Substantial damage NTSB SEA78FYM14Accident · Serious injuriesClosedBell 47G3B2 · Milton-Freewtr, ORJan 4, 1978 · N2906W · Substantial damage NTSB SEA72FYC14Accident · 1 fatalClosedBell 47-G3B · Mt Vernon, ORJul 31, 1971 · N4079G · Destroyed NTSB SEA70F0046Accident · Serious injuriesClosedBell 47G3B2 · Albany, ORJul 19, 1969 · N4758R · Destroyed