NTSB investigations: Bell 47G-5
184 cases on aircraft the registry lists as Bell 47G-5. 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, 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_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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
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 CHI86FER11Accident · Serious injuriesFinal reportBell 47G-5 · Brooten, MNAccording to the pilot, the helicopter collective control failed to respond to a climb input to level off after a descent for an agricultural swath run. Fire and impact damage to the helicopter was extensive, however one broken rod end in the collective…NTSB LAX86LA231Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Castaic, CAThe helicopter collided with unmarked wires while heading into sun during spraying operation. Plt does not recall seeing or hitting wires.NTSB CHI86FA017Accident · 1 fatalField investigationFinal reportBell 47G-5 · Plainfield, WIThe acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due…NTSB LAX86FUM01Accident · Minor injuriesFinal reportBell 47 G-5 · Yuma, AZThe pilot was hovering after a night takeoff and collided with an electrical power line.NTSB CHI85LA338Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pickett, WIThe fld where this accident occurred had been sprayed one week prior to the accident by a fixed-wing acft at an alt of 20 ft. no wires were noted to be a hazard at that time. On the day of the accident the plt of the helicopter was talking to a spotter on the…NTSB FTW85LA288Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Crane, TXThe helicopter was being operated from a flat bed trailer. The plt stated he had lifted to a 3 foot hover when the eng stopped. The helicopter suddenly rotated about 45 degs before he could stop it. The plt attempted to make an autorotation touchdown but was…NTSB LAX85LVA03Accident · Minor injuriesFinal reportBell 47-G5 · Lindsay, CAThe acft made a forced landing in a beet field following a noise in the eng or transmission. After he heard a noise the plt auto-rotated and during the hard landing the acft was damaged.NTSB ATL84LA295Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Bluefield, WVThe pilot stated that he hovered the helicopter, made a right pedal turn and initiated a hover taxi across a rocky ravine adjacent to the pad. When over the ravine the helicopter settled onto to boulders beneath it. The pilot also stated that he thought he…NTSB LAX84LA464Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Watsonville, CAThe plt maneuvered during an aerial application flt to avoid high tension wires and collided with lower telephone lines. The plt said the winds were gusty at the time of the accident.NTSB NYC84FGM05Accident · No injuriesFinal reportBell 47G-5 · Penn Run, PAThe plt was spraying a potatoe field with a lightly loaded helicopter when the eng failed. At that time, the helicopter was about 10 ft AGL in a slight right turn & at aprx 35 mph. The plt flared to stop the forward movement & landed, but the tail rotor…NTSB LAX84LA341Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Oceanside, CAA security guard with no flight experience attempted to fly the helicopter which he was guarding during early morning hours after substantial alcoholic beverage consumption. The acft sustained substantial damage when it touched down on the rt skid aprx 15 ft…NTSB MIA84LA179Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Jupiter, FLThe acft crashed landed after a partial loss of power. During an exam of the eng, the compressor bleed control valve was found stuck open causing an improper fuel/air mixture.NTSB LAX83FUM07Accident · No injuriesFinal reportBell 47G-5 · Valley Center, CAThe acft was damaged during a forced landing following a power loss while engaged in aerial application. The pilot took off with 25 gallons of fuel which he said was usually enough for spraying 40-50 acres. This job was 19 acres but it was 10-12 miles away at…NTSB LAX83FUA03Accident · No injuriesFinal reportBell 47G-5 · Irvine, CAThe helicopter landed hard in a field off the airport following an engine power loss. The acfr had lifted off and only traveled about 50 feet at 15 feet AGL when the power loss occurred. An engine teardown revealed that the rings on 3 cylinders had not seated…NTSB LAX82DA360Accident · No injuriesFinal reportBell 47G-5 · Soledad, CAThe pilot experienced a power loss during lift-off. A hard landing was made. No reason for the malfunction was found.NTSB CHI82DA171Accident · Minor injuriesFinal reportBell 47G-5 · Sublette, ILPrior to this flight, the helicopter had been flown about 1 hr from roselle to Sublette, IL, then it was flown another 1/2 hr to survey the area to be sprayed. About 10 minutes after departing to spray, the engine lost power. The pilot started an autorotative…NTSB LAX81DUK02Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB CHI81DEP22Accident · No injuriesClosedBell 47G-5 · Coloma, WINTSB LAX81FUJ03Accident · No injuriesClosedBell 47G-5 · Roll, AZNTSB LAX80FUJ83Accident · Minor injuriesClosedBell 47G-5 · Sommerton, AZNTSB LAX80FVD29Accident · No injuriesClosedBell 47G-5 · Stockton, CANTSB LAX80FVD25Accident · No injuriesClosedBell 47G-5 · Oakland, CANTSB LAX80DUJ43Accident · No injuriesClosedBell 47G5 · Somerton, AZNTSB NYC79FHJ21Accident · 1 fatalClosedBell 47G-5 · Jamesport, NYNTSB LAX79FUM20Accident · Serious injuriesClosedBell 47G-5 · Escondido, CANTSB MIA79FLT02Accident · No injuriesClosedBell 47G5 · Paden, MSNTSB LAX79DUJ18Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX78FUQ40Accident · No injuriesClosedBell 47G-5 · Camarillo, CANTSB NYC78FA079Accident · No injuriesClosedBell 47G · Riverhead, NYNTSB OAK78DVG52Accident · No injuriesClosedBell 47G5 · Napa, CANTSB LAX78DVM17Accident · No injuriesClosedBell 47G5 · Templeton, CANTSB LAX78FUQ21Accident · Minor injuriesClosedBell 47G · Santa Ynez, CANTSB MKC77FCD41Accident · Serious injuriesClosedBell 47G5 · Denison, IANTSB CHI77FEV22Accident · Minor injuriesClosedBell 47G5 · Enfield, ILNTSB MKC76FCG98Accident · No injuriesClosedBell 47G-5 · King City, MONTSB LAX76FUQ48Accident · Minor injuriesClosedBell 47G-5 · Lompoc, CANTSB MKC76DCQ63Accident · No injuriesClosedBell 47G5 · Scott City, KSNTSB LAX76AL084Accident · 1 fatalClosedBell 47G-5 · Los Angeles, CANTSB FTW76FRD52Accident · No injuriesClosedBell 47G-5 · Walker, LANTSB OAK76DVD36Accident · No injuriesClosedBell 47G-5 · Cloverdale, CANTSB MKC76FCJ32Accident · No injuriesClosedBell 47G-5 · Geneva, NENTSB CHI76FEC31Accident · No injuriesClosedBell 47G-5 · Adrian, MINTSB MKC76AK012Accident · 3 fatalClosedBell 47G-5 · Keystone, SDNTSB FTW75DPD41Accident · No injuriesClosedBell 47G-5 · Fort Worth, TXNTSB OAK75DVD48Accident · No injuriesClosedBell 47G-5 · Oakland, CANTSB OAK75FVW17Accident · No injuriesClosedBell 47G-5 · Las Vegas, NVNTSB OAK75DVA51Accident · No injuriesClosedBell 47G-5 · Porterville, CANTSB FTW75FPD23Accident · No injuriesClosedBell 47G-5 · Fort Worth, TXNTSB LAX75AL024Accident · No injuriesClosedBell 47G-5 · Riverside, CANTSB MKC75AK024Accident · 3 fatalClosedBell 47G-5 · Moorhead, MN