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 DEN66A0020Accident · No injuriesClosedBell 47G3B1 · Commerce Cty, COSep 9, 1965 · N1135W · Substantial damageNTSB MKC66A0013Accident · No injuriesClosedBell 47G3B1 · Altura, MNAug 26, 1965 · N73247 · Substantial damageNTSB DEN66A0017Accident · No injuriesClosedBell 47G3B1 · Salida, COAug 25, 1965 · N1180W · Substantial damageNTSB SEA66A0012Accident · No injuriesClosedBell 47G3B1 · Libby, MTAug 16, 1965 · N73920 · Substantial damageNTSB DEN66A0005Accident · No injuriesClosedBell 47G3B1 · Grand Canyon, AZAug 5, 1965 · N1182W · Substantial damageNTSB DEN65A0073Accident · No injuriesClosedBell 47G3B1 · Glenwood Spg, COMay 21, 1965 · N1127W · Substantial damageNTSB SEA65A0059Accident · Minor injuriesClosedBell 47G3B1 · Marblemount, WAApr 28, 1965 · N68645 · Substantial damageNTSB LAX65A0071Accident · Minor injuriesClosedBell 47G3B1 · Bishop, CAFeb 27, 1965 · N73998 · DestroyedNTSB OAK65A0051Accident · No injuriesClosedBell 47G3B1 · Yreka, CAJan 7, 1965 · N73982 · Substantial damageNTSB UNK64X3437Accident · No injuriesClosedBell 47G3B1 · Castries Bwi, São Tomé & PríncipeAug 17, 1964 · N1127W · DestroyedNTSB UNK64X2453Accident · No injuriesClosedBell 47G3B1 · Bondurant, WYJun 23, 1964 · N73914 · Substantial damageNTSB UNK64X0473Accident · 1 fatalClosedBell 47G3B1 · Little Nway, CAFeb 5, 1964 · N73909 · DestroyedNTSB UNK64X0270Accident · No injuriesClosedBell 47G3B1 · Shell Beachf, CAJan 18, 1964 · N73919 · Substantial damage
Back to Bell 47G-3B-1