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

15 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.

Cases per year

19642026
NTSB investigations: Bell 47G-3B-1, 1974 per year, 1964–2026: 313 cases
19644
196513
196622
196718
196819
196917
197011
19718
197210
19738
197415
197512
19766
19777
19788
197913
19808
19814
19826
19836
19843
19854
19867
19873
19883
19892
19905
199110
19925
19933
19943
19952
19965
19974
19984
19991
20004
20011
20022
20031
20043
20053
20061
20071
20082
20101
20111
20133
20141
20152
20162
20181
20193
20201
20241

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1974
    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.

NTSB FTW75FRG48Accident · Serious injuriesClosedBell 47GB31 · Freer, TXDec 5, 1974 · N8505F · Substantial damageNTSB LAX75DUG22Accident · No injuriesClosedBell 47G3B1 · Joshua Tree, CANov 21, 1974 · N3084G · Substantial damageNTSB DEN75AD022Accident · Minor injuriesClosedBell 47G3B1 · Vernal, UTOct 26, 1974 · N1170W · Substantial damageNTSB DEN75FTE21Accident · No injuriesClosedBell 47G3B1 · Grand Valley, COSep 6, 1974 · N1135W · Substantial damageNTSB DEN75AD009Accident · 1 fatalClosedBell 47G3B1 · Ogden, UTSep 5, 1974 · N73972 · DestroyedNTSB OAK75DXQ19Accident · No injuriesClosedBell 47G3B1 · Soda Sprngs, CAAug 15, 1974 · N7829S · Substantial damageNTSB DEN75AD003Accident · No injuriesClosedBell 47G3B1 · Grand Valley, COJul 24, 1974 · N3067G · Substantial damageNTSB SEA74DTI29Accident · No injuriesClosedBell 47G3B1 · Lima, MTJun 16, 1974 · N7928S · Substantial damageNTSB MKC74FCQ41Accident · No injuriesClosedBell 47G-3B · Dodge City, KSJun 10, 1974 · N1380X · Substantial damageNTSB SEA74DYG44Accident · No injuriesClosedBell 47G3B1 · Stratford, WAJun 4, 1974 · N1135W · DestroyedNTSB SEA74DYC54Accident · Minor injuriesClosedBell 47G-3B · North Powder, ORMay 24, 1974 · N73940 · Substantial damageNTSB SEA74DYE44Accident · Minor injuriesClosedBell 47G3B1 · Forks, WAApr 8, 1974 · N1325X · DestroyedNTSB OAK74FXQ28Accident · No injuriesClosedBell 47G-3B · Bordertown, NVMar 23, 1974 · N1136W · Substantial damageNTSB LAX74DUJ75Accident · No injuriesClosedBell 47G3B1 · Supai, AZFeb 25, 1974 · N1321X · Substantial damageNTSB SEA74DTI18Accident · No injuriesClosedBell 47G3B1 · Conrad, MTFeb 24, 1974 · N7936S · Substantial damage