NTSB investigations: Bell 47G-4A, CA
15 cases on aircraft the registry lists as Bell 47G-4A. 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
| 1968 | 1 |
|---|---|
| 1981 | 1 |
| 1983 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2010 | 1 |
Where
Open the mapLatest 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 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 ('1181031'))
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 ('1181031'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR10LA117Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe loss of a main rotor blade counterweight due to corrosion. Contributing to the accident was the failure of the operator to perform the initial and recurrent inspections required by a Service Bulletin to detect the corrosion in the counterweight.NTSB LAX05LA187Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAthe pilot's inadequate visual lookout and failure to maintain clearance from the power lines.NTSB LAX04LA176Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAa loss of tail rotor drive due to a disconnection of the drive shaft's splined coupling at the tail rotor gear box. The splined coupling to tail rotor gear box disconnection occurred as a result of tail boom flexing due to the combined effects of an…NTSB LAX01LA276Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Strathmore, CAThe pilot's inadequate visual lookout while maneuvering during an aerial application flight.NTSB LAX01LA196Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Buttonwillow, CAThe pilot's inadequate in-flight planning that resulted in settling with power during an aerial application turn-to-reverse direction and collision with the ground. Factors were high density altitude and a wind shift.NTSB LAX00LA116Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Wasco, CAThe pilot's failure to use carburetor heat, which resulted in a loss of engine power. Factors included the ambient carburetor icing conditions and the lack of suitable terrain for the forced landing.NTSB LAX98LA197Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe aircraft's encounter with settling with power, which resulted from the pilot's decision to perform a steep downwind approach.NTSB LAX93LA120Accident · No injuriesLimited investigationFinal reportBell 47G · Bakersfield, CAThe clutch slippage and failure of the pilot to jettison the load.NTSB LAX91LA363Accident · Minor injuriesLimited investigationFinal reportBell 47G · Kettleman City, CAA non-mechanical loss of engine power due to fuel exhaustion by the pilot's improper calculation of the fuel supply and subsequent hard landing.NTSB LAX87DVD01Accident · Serious injuriesFinal reportBell 47G4A · Stockton, CAJust after takeoff, the engine experienced a power loss while transporting agricultural equipment. A fractographic examination of the failed fuel disconnect fitting by anamet laboratories, concluded that approximately 70% of the retaining ring on the fuel…NTSB LAX86DVA13Accident · No injuriesFinal reportBell 47G-4A · Shafter, CAShortly after departing the loading rig, en route to an agricultural aerial application operation, the forward coupling tail rotor drive shaft failed. The helicopter was about 10 ft above ground level and about 100 ft west of the loading rig. The pilot…NTSB LAX83FA462Accident · No injuriesField investigationFinal reportBell 47G-4G · Lodi, CADuring takeoff, the helicopter lost power after climbing aprx 20 ft. the plt made an autorotative landing, but after touchdown, the helicopter slid down a river bank, rolled over & began burning. The fuel tanks did not rupture & still contained fuel. When…NTSB LAX83FA087Accident · Minor injuriesField investigationFinal reportBell 47G4 · Five Points, CAThe pilot was on his final pass of the operation. He flew under 2 sets of wires but failed to see a third set. The spray boom caught on the the wire pitching the helicopter nose down. The main rotor hit the tail boom and the helicoptercrashed into a canal.NTSB LAX82DVA05Accident · No injuriesClosedBell 47G-4A · Wasco, CANTSB LAX68A0064Accident · Serious injuriesClosedBell 47G-4A · Los Angeles, CA