Bell 47G-3B-1

NTSB investigations · 313

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.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 LAX69D0033Accident · No injuriesClosedBell 47G3B1 · Alpine, AZJun 21, 1968 · N73285 · Substantial damageNTSB DEN68F0266Accident · No injuriesClosedBell 47G3B1 · Capitan, NMMay 29, 1968 · N1320X · Substantial damageNTSB LAX69F0010Accident · Minor injuriesClosedBell 47G3B1 · Springervill, AZMay 22, 1968 · N73965 · DestroyedNTSB SEA68D0310Accident · No injuriesClosedBell 47G3B1 · Jackson, MTMay 11, 1968 · N7920S · Substantial damageNTSB DEN68A0050Accident · Minor injuriesClosedBell 47G3B1 · Aspen, COApr 24, 1968 · N7942S · Substantial damageNTSB LAX68A0090Accident · Minor injuriesClosedBell 47G3B1 · Castaic, CAMar 20, 1968 · N7822S · DestroyedNTSB DEN68A0020Accident · Minor injuriesClosedBell 47G-3B · Silverthorne, COOct 12, 1967 · N1397X · Substantial damageNTSB SEA68A0033Accident · No injuriesClosedBell 47G3B1 · Snoqualmie P, WAOct 11, 1967 · N1321X · Substantial damageNTSB DEN68A0019Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMOct 5, 1967 · N1337X · Substantial damageNTSB UNK67X0157Accident · No injuriesClosedBell 47G3B1 · Dhahran, Saudi ArabiaSep 20, 1967 · N1341X · DestroyedNTSB OAK68A0028Accident · Minor injuriesClosedBell 47G3B1 · S.Lak Tahoe, CASep 16, 1967 · N7829S · Substantial damageNTSB SEA68A0012Accident · No injuriesClosedBell 47G-3B · Augusta, MTAug 7, 1967 · N1357X · Substantial damageNTSB OAK68A0010Accident · No injuriesClosedBell 47G-3B · Clearlake, CAAug 6, 1967 · N73285 · Substantial damageNTSB LAX68F0086Accident · No injuriesClosedBell 47G3B1 · Marana, AZAug 2, 1967 · N1181W · Substantial damageNTSB SEA68A0010Accident · 1 fatalClosedBell 47G3B1 · Rufus, ORJul 30, 1967 · N8518F · DestroyedNTSB SEA68A0021Accident · No injuriesClosedBell 47G3B1 · West Glacier, MTJul 29, 1967 · N73916 · Substantial damageNTSB DEN68A0006Accident · No injuriesClosedBell 47G3B1 · Leadville, COJul 22, 1967 · N1334X · Substantial damageNTSB DEN68A0002Accident · No injuriesClosedBell 47G3B1 · Winston, NMJul 6, 1967 · N1320X · Substantial damageNTSB LAX67A0118Accident · No injuriesClosedBell 47G3B1 · Van Nuys, CAJun 28, 1967 · N1131W · Substantial damageNTSB DEN67A0052Accident · Minor injuriesClosedBell 47G3B1 · Cody, WYMar 10, 1967 · N8537F · DestroyedNTSB LAX67A0083Accident · Serious injuriesClosedBell 47G3B1 · Kingman, AZMar 8, 1967 · N73991 · DestroyedNTSB DEN67A0049Accident · Serious injuriesClosedBell 47G3B1 · Estes Park, COMar 1, 1967 · N8541F · DestroyedNTSB DEN67A0048Accident · No injuriesClosedBell 47G3B1 · Riverton, WYFeb 21, 1967 · N8537F · Substantial damageNTSB SEA67A0046Accident · No injuriesClosedBell 47G-3B · Pomeroy, WAJan 4, 1967 · N73919 · Substantial damageNTSB DEN67A0037Accident · Minor injuriesClosedBell 47G3B1 · Holloman Ab, NMDec 16, 1966 · N1362X · DestroyedNTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORDec 14, 1966 · N8554F · Substantial damageNTSB SEA67A0036Accident · No injuriesClosedBell 47G3B1 · Cle Elum, WAOct 8, 1966 · N8518F · Substantial damageNTSB UNK67X0101Accident · No injuriesClosedBell 47G3B1 · Manta, EcuadorOct 6, 1966 · N73288 · Substantial damageNTSB UNK67X0100Accident · 2 fatalClosedBell 47G3B1 · Janakpur, NepalOct 5, 1966 · N73973 · DestroyedNTSB SEA67A0027Accident · 2 fatalClosedBell 47G3B1 · W.Yellowston, MTSep 21, 1966 · N1169W · DestroyedNTSB DEN67A0024Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMSep 21, 1966 · N1381X · Substantial damageNTSB DEN67A0021Accident · Serious injuriesClosedBell 47G3B1 · Old Faithful, WYSep 15, 1966 · N73982 · Substantial damageNTSB FTW67A0030Accident · No injuriesClosedBell 47G3B1 · Yukon, OKSep 6, 1966 · N8542F · Substantial damageNTSB UNK66X0166Accident · 1 fatalClosedBell 47G-3B · Rahgird, IranAug 23, 1966 · N8547F · DestroyedNTSB NYC67A0033Accident · No injuriesClosedBell 47G3B1 · Great Meadows, NJAug 19, 1966 · N8508F · Substantial damageNTSB OAK67A0023Accident · No injuriesClosedBell 47G3B1 · Bridgeport, CAAug 11, 1966 · N337RH · Substantial damageNTSB OAK67A0022Accident · Serious injuriesClosedBell 47G3B1 · Bishop, CAAug 9, 1966 · N8528F · DestroyedNTSB DEN67A0007Accident · Serious injuriesClosedBell 47G3B1 · Riverton, WYJul 20, 1966 · N1332X · Substantial damageNTSB SEA67A0002Accident · Serious injuriesClosedBell 47-G3B · Clinton, MTJul 14, 1966 · N8509F · DestroyedNTSB LAX66A0004Accident · Serious injuriesClosedBell 47G-3B · Grand Canyon, AZJul 11, 1966 · N73947 · DestroyedNTSB SEA66A0072Accident · Minor injuriesClosedBell 47G3B1 · Livingston, MTJun 30, 1966 · N73916 · DestroyedNTSB LAX66A0102Accident · No injuriesClosedBell 47G-3B · Alpine, AZJun 16, 1966 · N73965 · Substantial damageNTSB LAX66A0097Accident · Minor injuriesClosedBell 47G3B1 · Glendora, CAJun 6, 1966 · N3079G · Substantial damageNTSB DEN66A0081Accident · Serious injuriesClosedBell 47G3B1 · Aspen, COMay 11, 1966 · N1180W · Substantial damageNTSB DEN66A0074Accident · 1 fatalClosedBell 47G-3B · Grand Canyon, AZApr 12, 1966 · N73909 · DestroyedNTSB MIA66A0108Accident · Minor injuriesClosedBell 47G3B1 · Fredericksted, VIMar 20, 1966 · N1110J · Substantial damageNTSB DEN66A0051Accident · No injuriesClosedBell 47G3B1 · Mesa, AZDec 30, 1965 · N73947 · Substantial damageNTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTOct 5, 1965 · N8537F · DestroyedNTSB DEN66A0024Accident · Minor injuriesClosedBell 47G3B1 · Jackson, WYSep 29, 1965 · N1136W · Substantial damageNTSB DEN66A0023Accident · 1 fatalClosedBell 47G3B1 · Monticello, UTSep 28, 1965 · N1127W · Destroyed
Back to Bell 47G-3B-1