Skip to content

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

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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

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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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.

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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR24LA093Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G-3B-1 · Garey, CAMaintenance personnel’s failure to properly check the torque paint on a fuel control unit B-nut, which resulted in the loosening of the B-nut, a loss of engine power at a low altitude, and a subsequent impact with terrain.Feb 23, 2024 · N2618W · Substantial damage NTSB LAX08CA229Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Shafter, CAThe pilot's failure to maintain adequate altitude while maneuvering. Contributing factors were the failure of the helicopter's lights during the night flight and the effect of that failure on the pilot's visual perception.Jul 15, 2008 · N1390X · Substantial damage NTSB LAX01LA098Accident · No injuriesLimited investigationFinal reportBell 47-G3B1 · Winterhaven, CAA failure of the transmission free wheeling unit due to improper maintenance. A factor was the dark night visual condition.Feb 10, 2001 · N3084G · Substantial damage NTSB LAX99LA049Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Winterhaven, CAThe failure of the pilot to maintain rotor rpm. A factor was his attempt to take off over gross weight.Dec 4, 1998 · N3084G · Substantial damage NTSB LAX96LA263Accident · No injuriesLimited investigationFinal reportBell 47G3 · Wasco, CAthe pilot's failure to maintain adequate engine rpm during an aerial application flight.Jul 6, 1996 · N154PG · Substantial damage NTSB LAX83FA366Accident · Serious injuriesField investigationFinal reportBell 47G-3B-1 · S. Lake Tahoe, CADuring takeoff over descending terrain in a mountainous area, the RPM began decaying when the helicopter had accelerated to 40 KTS & was about 75 ft AGL. The plt applied more throttle & increased the collective, then noted that the manifold pressure was…Jul 31, 1983 · N11102 · Destroyed NTSB LAX83LA184Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Delano, CAThe acft collided with a power line and trees while applying pesticide to an orchard. The pilot was flying into the rising sun and failed to see the power line which serviced an agricultural deep well.Apr 8, 1983 · N1397X · Substantial damage NTSB LAX80FUA22Accident · No injuriesClosedBell 47G-3B · Bellflower, CASep 7, 1980 · N3084G · Substantial damage NTSB LAX80FA132Accident · Serious injuriesClosedBell 47G3B1 · Los Angeles, CAAug 12, 1980 · N1131W · Destroyed NTSB LAX80DVM16Accident · No injuriesClosedBell 47G3B1 · Templeton, CAMar 1, 1980 · N3095G · Substantial damage NTSB LAX80FUG15Accident · Serious injuriesClosedBell 47G3B1 · Yucaipa, CADec 19, 1979 · N7923S · Destroyed NTSB LAX79DUQ28Accident · Minor injuriesClosedBell 47G3B1 · Newhall, CAMay 6, 1979 · N7829S · Substantial damage NTSB LAX78FA074Accident · 1 fatalClosedBell 47G-3B · Pasadena, CASep 3, 1978 · N1135W · Destroyed NTSB OAK77DXQ30Accident · Minor injuriesClosedBell 47G3B1 · Rubicon Spring, CAJul 31, 1977 · N337RH · Substantial damage NTSB LAX76DVA56Accident · No injuriesClosedBell 47G3B1 · Coalinga, CAApr 29, 1976 · N73959 · Substantial damage NTSB LAX76DVA21Accident · No injuriesClosedBell 47G3B1 · Fellows, CAOct 17, 1975 · N3079G · Substantial damage NTSB LAX76AL009Accident · Serious injuriesClosedBell 47G3B1 · Mt.Baldy, CAAug 5, 1975 · N1358X · Substantial damage NTSB OAK76DXQ05Accident · No injuriesClosedBell 47G3B1 · Mommoth Lakes, CAJul 8, 1975 · N1358X · Substantial damage NTSB LAX75FVW12Accident · No injuriesClosedBell 47G3B1 · Trona, CAJan 9, 1975 · N1359X · Destroyed NTSB LAX75DUG22Accident · No injuriesClosedBell 47G3B1 · Joshua Tree, CANov 21, 1974 · N3084G · Substantial damage NTSB OAK75DXQ19Accident · No injuriesClosedBell 47G3B1 · Soda Sprngs, CAAug 15, 1974 · N7829S · Substantial damage NTSB OAK73DXQ36Accident · Minor injuriesClosedBell 47G3B1 · Belden, CAJun 29, 1973 · N8465E · Substantial damage NTSB OAK73FVG48Accident · No injuriesClosedBell 47G3B1 · Gridley, CAFeb 18, 1973 · N73288 · Substantial damage NTSB OAK72DVA91Accident · No injuriesClosedBell 47G3B1 · Springville, CAJun 29, 1972 · N3096G · Substantial damage NTSB LAX72DVA70Accident · No injuriesClosedBell 47G-3B · Lebec, CAMay 10, 1972 · N1360X · Substantial damage NTSB LAX72FUM19Accident · Minor injuriesClosedBell 47G3B1 · Brawley, CAFeb 24, 1972 · N1332X · Destroyed NTSB LAX71FUQ89Accident · No injuriesClosedBell 47G3B1 · Pacoima, CAJun 7, 1971 · N1133W · 2 aircraft · Substantial damage NTSB LAX71AL033Accident · 1 fatalClosedBell 47G3B1 · Rim Forest, CADec 1, 1970 · N1126W · Destroyed NTSB OAK71DVA40Accident · No injuriesClosedBell 47G3B1 · Grant Cove, CANov 19, 1970 · N7901S · Substantial damage NTSB OAK71DVA19Accident · No injuriesClosedBell 47G3B1 · Kernville, CAAug 17, 1970 · N7829S · Substantial damage NTSB LAX70FUG50Accident · No injuriesClosedBell 47G-3B · Idyllwild, CAJun 25, 1970 · N1301X · Substantial damage NTSB OAK70F0212Accident · 1 fatalClosedBell 47G3B1 · Hamiltn Afb, CADec 30, 1969 · N1320X · Substantial damage NTSB OAK70D0160Accident · No injuriesClosedBell 47G3B1 · Bishop, CAOct 7, 1969 · N3096G · Destroyed NTSB OAK70D0068Accident · No injuriesClosedBell 47G3B1 · Bishop, CAAug 2, 1969 · N6219N · Substantial damage NTSB OAK70A0008Accident · Serious injuriesClosedBell 47G-3B · Willow Crek, CAJul 25, 1969 · N8465E · Destroyed NTSB OAK70F0086Accident · Minor injuriesClosedBell 47G3B1 · Stirling Cy, CAJul 23, 1969 · N8529F · Substantial damage NTSB LAX70F0070Accident · No injuriesClosedBell 47G3B1 · Siera Madre, CAJul 5, 1969 · N1126W · Substantial damage NTSB OAK69D0286Accident · No injuriesClosedBell 47G3B1 · Stockton, CAApr 29, 1969 · N8470E · Substantial damage NTSB OAK69F0150Accident · Serious injuriesClosedBell 47G3B1 · Chowchilla, CASep 26, 1968 · N3377H · Destroyed NTSB LAX69F0105Accident · Minor injuriesClosedBell 47G3B1 · Azusa, CAAug 29, 1968 · N1136W · Destroyed NTSB LAX69D0041Accident · No injuriesClosedBell 47G3B1 · Boron, CAJun 25, 1968 · N1110J · Substantial damage NTSB LAX68A0090Accident · Minor injuriesClosedBell 47G3B1 · Castaic, CAMar 20, 1968 · N7822S · Destroyed NTSB OAK68A0028Accident · Minor injuriesClosedBell 47G3B1 · S.Lak Tahoe, CASep 16, 1967 · N7829S · Substantial damage NTSB OAK68A0010Accident · No injuriesClosedBell 47G-3B · Clearlake, CAAug 6, 1967 · N73285 · Substantial damage NTSB LAX67A0118Accident · No injuriesClosedBell 47G3B1 · Van Nuys, CAJun 28, 1967 · N1131W · Substantial damage NTSB OAK67A0023Accident · No injuriesClosedBell 47G3B1 · Bridgeport, CAAug 11, 1966 · N337RH · Substantial damage NTSB OAK67A0022Accident · Serious injuriesClosedBell 47G3B1 · Bishop, CAAug 9, 1966 · N8528F · Destroyed NTSB LAX66A0097Accident · Minor injuriesClosedBell 47G3B1 · Glendora, CAJun 6, 1966 · N3079G · Substantial damage NTSB LAX65A0071Accident · Minor injuriesClosedBell 47G3B1 · Bishop, CAFeb 27, 1965 · N73998 · Destroyed NTSB OAK65A0051Accident · No injuriesClosedBell 47G3B1 · Yreka, CAJan 7, 1965 · N73982 · Substantial damage