NTSB investigations: Bell 47G-2, 1974

20 cases on aircraft the registry lists as Bell 47G-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.

Cases per year

19642026
NTSB investigations: Bell 47G-2, 1974 per year, 1964–2026: 379 cases
196421
196516
196613
196718
196816
196922
197020
197110
197214
197319
197420
197520
197610
19779
197814
197912
19804
19819
198211
19839
19846
198510
19866
198710
19882
19896
19903
19914
19923
19931
19945
19954
19972
19981
19991
20002
20012
20024
20042
20051
20062
20071
20092
20111
20122
20141
20161
20181
20193
20221
20262

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 ('1181008'))
  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 SEA75AS022Accident · 1 fatalClosedBell 47G-2 · Kingston, WANov 4, 1974 · N5160B · DestroyedNTSB CHI75FEM12Accident · Minor injuriesClosedBell 47G-2 · Paw Paw, MISep 21, 1974 · N7893B · Substantial damageNTSB SEA75FYG10Accident · Serious injuriesClosedBell 47G-2 · Quincy, WAAug 27, 1974 · N6717D · DestroyedNTSB SEA75DYG07Accident · No injuriesClosedBell 47G-2 · Royal City, WAAug 14, 1974 · N6717D · Substantial damageNTSB SEA75FYE11Accident · Serious injuriesClosedBell 47G-2A · Mercer Isl, WAAug 11, 1974 · N88AR · DestroyedNTSB MKC75DER12Accident · No injuriesClosedBell 47G-2 · Meridan, MNAug 5, 1974 · N2870B · Substantial damageNTSB OAK75FVM04Accident · Serious injuriesClosedBell 47G-2A · Gonzales, CAJul 24, 1974 · N2889B · DestroyedNTSB MIA75FKQ02Accident · Minor injuriesClosedBell 47G-2 · Raleigh, MSJul 11, 1974 · N4823 · Substantial damageNTSB OAK75DVD03Accident · No injuriesClosedBell 47G-2 · Linden, CAJul 6, 1974 · N6701D · Substantial damageNTSB SEA74DYG49Accident · No injuriesClosedBell 47G-2 · Ephrata, WAJun 24, 1974 · N2899B · Substantial damageNTSB NYC74FHJ31Accident · No injuriesClosedBell 47G-2 · Garden City, NYJun 11, 1974 · N6173 · Substantial damageNTSB SEA74DYG38Accident · Minor injuriesClosedBell 47G-2 · Ephrata, WAMay 4, 1974 · N7887B · Substantial damageNTSB IAD74FID36Accident · Minor injuriesClosedBell 47G-2 · Norfolk, VAMay 1, 1974 · N6752D · DestroyedNTSB ANC74AA069Accident · Minor injuriesClosedBell 47G-2 · Seward, AKApr 23, 1974 · N2822B · Substantial damageNTSB SEA74DYE42Accident · No injuriesClosedBell 47G-2 · Centralia, WAApr 18, 1974 · N984B · Substantial damageNTSB OAK74FVD22Accident · No injuriesClosedBell 47D1 · Sebastopol, CAMar 30, 1974 · N68367 · Substantial damageNTSB MIA74AM079Accident · Serious injuriesClosedBell 47G-2 · Miami, FLMar 14, 1974 · N4775S · DestroyedNTSB SEA74DYE39Accident · No injuriesClosedBell 47G-2 · Forks, WAMar 3, 1974 · N5161B · Substantial damageNTSB SEA74DYC25Accident · No injuriesClosedBell 47G-2 · Spokane, WAFeb 24, 1974 · N59H · Substantial damageNTSB LAX74AL057Accident · 2 fatalClosedBell 47D1 · Westminster, CAJan 28, 1974 · N74084 · Destroyed