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 LAX72FUM19Accident · Minor injuriesClosedBell 47G3B1 · Brawley, CAFeb 24, 1972 · N1332X · DestroyedNTSB DEN72FQD18Accident · No injuriesClosedBell 47G3B1 · Hollomn Afb, NMDec 15, 1971 · N1382X · Substantial damageNTSB DEN72AD011Accident · No injuriesClosedBell 47G3B1 · Sandy, UTSep 13, 1971 · N73972 · Substantial damageNTSB DEN72FQD08Accident · No injuriesClosedBell 47G3B1 · Ruidoso, NMAug 31, 1971 · N1333X · Substantial damageNTSB DEN72DTE19Accident · No injuriesClosedBell 47G3B1 · Minturn, COAug 13, 1971 · N73978 · Substantial damageNTSB SEA72DYC08Accident · No injuriesClosedBell 47G3B1 · Legrande, ORJul 20, 1971 · N1324X · DestroyedNTSB UNK71X0109Accident · No injuriesClosedBell 47G-4A · Angola, AngolaJun 8, 1971 · N4002G · Substantial damageNTSB LAX71FUQ89Accident · No injuriesClosedBell 47G3B1 · Pacoima, CAJun 7, 1971 · N1133W · 2 aircraft · Substantial damageNTSB SEA71FYC38Accident · No injuriesClosedBell 47G-3B · Elgin, ORApr 30, 1971 · N73940 · Substantial damageNTSB SEA71DVQ16Accident · No injuriesClosedBell 47G-2 · Sixes, ORDec 21, 1970 · N73284 · Substantial damageNTSB LAX71AL033Accident · 1 fatalClosedBell 47G3B1 · Rim Forest, CADec 1, 1970 · N1126W · DestroyedNTSB OAK71DVA40Accident · No injuriesClosedBell 47G3B1 · Grant Cove, CANov 19, 1970 · N7901S · Substantial damageNTSB SEA71FWG15Accident · Minor injuriesClosedBell 47G3B1 · Colville, WASep 2, 1970 · N3097G · Substantial damageNTSB OAK71DVA19Accident · No injuriesClosedBell 47G3B1 · Kernville, CAAug 17, 1970 · N7829S · Substantial damageNTSB SEA71DWD09Accident · Minor injuriesClosedBell 47G3B1 · Diablo, WAAug 7, 1970 · N1182W · Substantial damageNTSB LAX71DUJ06Accident · No injuriesClosedBell 47G3B1 · Elfrida, AZJul 13, 1970 · N1358X · Substantial damageNTSB SEA71DXM01Accident · No injuriesClosedBell 47G-3B · Hailey, IDJul 6, 1970 · N68645 · Substantial damageNTSB LAX70FUG50Accident · No injuriesClosedBell 47G-3B · Idyllwild, CAJun 25, 1970 · N1301X · Substantial damageNTSB OAK70FXQ12Accident · No injuriesClosedBell 47G3B1 · Reno, NVMay 21, 1970 · N337RH · Substantial damageNTSB SEA70DWA14Accident · No injuriesClosedBell 47G3B1 · Cove, ORMay 3, 1970 · N73940 · Substantial damageNTSB OAK70F0212Accident · 1 fatalClosedBell 47G3B1 · Hamiltn Afb, CADec 30, 1969 · N1320X · Substantial damageNTSB OAK70D0160Accident · No injuriesClosedBell 47G3B1 · Bishop, CAOct 7, 1969 · N3096G · DestroyedNTSB OAK70D0068Accident · No injuriesClosedBell 47G3B1 · Bishop, CAAug 2, 1969 · N6219N · Substantial damageNTSB MKC70I0081Incident · No injuriesClosedBell 47G3B1 · Hill City, SDAug 2, 1969 · N7924S · Minor damageNTSB LAX70A0008Accident · 3 fatalClosedBell 47G3B1 · Grnd Canyon, AZJul 30, 1969 · N73909 · DestroyedNTSB CAN70A4457Accident · 3 fatalClosedBell 47G3B1 · Hope, CanadaJul 26, 1969 · N1335X · 2 aircraft · DestroyedNTSB OAK70A0008Accident · Serious injuriesClosedBell 47G-3B · Willow Crek, CAJul 25, 1969 · N8465E · DestroyedNTSB OAK70F0086Accident · Minor injuriesClosedBell 47G3B1 · Stirling Cy, CAJul 23, 1969 · N8529F · Substantial damageNTSB LAX70F0070Accident · No injuriesClosedBell 47G3B1 · Siera Madre, CAJul 5, 1969 · N1126W · Substantial damageNTSB DEN70F0008Accident · Serious injuriesClosedBell 47G3B1 · Broomfield, COJun 14, 1969 · N8541F · Substantial damageNTSB LAX69D0357Accident · No injuriesClosedBell 47G3B1 · Grnd Canyon, AZMay 21, 1969 · N73909 · Substantial damageNTSB OAK69F0318Accident · No injuriesClosedBell 47G3B1 · Las Vegas, NVMay 11, 1969 · N1335X · Substantial damageNTSB DEN70F0019Accident · Serious injuriesClosedBell 47G3B1 · Idaho Spring, COMay 11, 1969 · N7927S · DestroyedNTSB OAK69D0286Accident · No injuriesClosedBell 47G3B1 · Stockton, CAApr 29, 1969 · N8470E · Substantial damageNTSB DEN69D0213Accident · Minor injuriesClosedBell 47G3B1 · Albany, WYMar 25, 1969 · N73285 · Substantial damageNTSB DEN69F0190Accident · No injuriesClosedBell 47G3B1 · Tularosa, NMMar 11, 1969 · N1381X · Substantial damageNTSB MIA69F0313Accident · No injuriesClosedBell 47G · Jackson, MSJan 16, 1969 · N3096G · Substantial damageNTSB LAX69D0253Accident · No injuriesClosedBell 47G3B1 · Grand Canyon, AZDec 16, 1968 · N1321X · Substantial damageNTSB SEA69D0122Accident · Minor injuriesClosedBell 47G3B1 · Anaconda, MTSep 26, 1968 · N73931 · Substantial damageNTSB OAK69F0150Accident · Serious injuriesClosedBell 47G3B1 · Chowchilla, CASep 26, 1968 · N3377H · DestroyedNTSB LAX69F0105Accident · Minor injuriesClosedBell 47G3B1 · Azusa, CAAug 29, 1968 · N1136W · DestroyedNTSB MKC69F0174Accident · Minor injuriesClosedBell 47G3B1 · Custer, SDAug 18, 1968 · N6214N · DestroyedNTSB ANC69A0009Accident · Serious injuriesClosedBell 47G3B1 · Susitna Lodg, AKAug 15, 1968 · N68645 · Substantial damageNTSB SEA69D0057Accident · No injuriesClosedBell 47G3B1 · Garden Valley, IDAug 11, 1968 · N73972 · DestroyedNTSB NYC69F0178Accident · 1 fatalClosedBell 47G3B1 · Sipesville, PAAug 5, 1968 · N73247 · DestroyedNTSB LAX69D0079Accident · No injuriesClosedBell 47G3B1 · Peach Spgs, AZJul 30, 1968 · N6245N · Substantial damageNTSB SEA69A0008Accident · 1 fatalClosedBell 47G3B1 · North Fork, IDJul 23, 1968 · N8537F · DestroyedNTSB SEA68A0074Accident · Minor injuriesClosedBell 47G3B1 · Lewiston, IDJun 27, 1968 · N73284 · DestroyedNTSB LAX69D0041Accident · No injuriesClosedBell 47G3B1 · Boron, CAJun 25, 1968 · N1110J · Substantial damageNTSB DEN69D0043Accident · No injuriesClosedBell 47G3B1 · Loa, UTJun 22, 1968 · N1357X · Substantial damage
Back to Bell 47G-3B-1