Skip to content

Fatal NTSB investigations: Bell 47G-2

27 cases on aircraft the registry lists as Bell 47G-2. 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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181008')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181008'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181008'))
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 CEN18FA258Accident · 1 fatalField investigationFinal reportBell 47G · Arlington, INThe inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.Jul 6, 2018 · N96195 · Substantial damage NTSB CEN14LA415Accident · 1 fatalLimited investigationFinal reportBell 47G 2 · Jeanerette, LAThe pilot’s improper decision to operate an unairworthy helicopter, which resulted in a loss of control and subsequent impact with terrain.Aug 10, 2014 · N4690 · Destroyed NTSB CEN13LA086Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Walkerville, MIThe pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.Dec 1, 2012 · N3755Z · Substantial damage NTSB FTW02LA264Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Edmondson, ARThe pilot's failure to maintain clearance from the high voltage power lines.Sep 25, 2002 · N5193B · Destroyed NTSB SEA99LA149Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Benton City, WAA loss of power for undetermined reasons and the failure of the pilot to maintain adequate rotor RPM following the power loss. Contributing factors were the pilot's lack of certification and total experience.Aug 26, 1999 · N11VH · Destroyed NTSB CHI94FA202Accident · 2 fatalField investigationFinal reportBell 47G2 · Baldwin, ILThe inadequate maintenance (inspection of aircraft) by maintenance personnel, which resulted in a loss of engine power due to fuel exhaustion. Related factors are the unsafetied fuel filter, and low altitude at which the helicopter operated.Jun 15, 1994 · N4992G · Destroyed NTSB FTW94FA158Accident · 1 fatalField investigationFinal reportBell 47G-2 · Tulsa, OKIn flight loss of control due to the pilot's improper use of the cyclic and collective controls when he maneuvered abruptly to avoid colliding with a flock of birds. Factors were the birds and the inflight separation of the left synchronized elevator.May 16, 1994 · N47GY · Destroyed NTSB MIA87FA236Accident · 1 fatalField investigationFinal reportCessna 152 · Opa Locka, FLA student plt & instructor (CFI) in Cessna 152, N48864, took off & entered rgt traffic to practice lndgs on rwy 9R. Soonthereafter, a helicopter plt (h/p) in a bell 47G-2, N6728D, took off & entered rgt traffic to practice lndgs in a desig-nated helicopter…Aug 31, 1987 · N48864 · 2 aircraft · Substantial damage NTSB ATL86FEI07Accident · 1 fatalFinal reportBell 47G2 · Lisbon, OHThe aerial application helicopter was being serviced by a chemical truck that was parked adjacent to the acft. The acft engine was at high idle with the main rotor turning at 250 RPM. The ground crewman jumped off the side of the chemical truck into the main…Jun 26, 1986 · N984B · Minor damage NTSB CHI85FA198Accident · 1 fatalField investigationFinal reportBell 47G-2 · Burlington, MIThe helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.May 16, 1985 · N3755J · Substantial damage NTSB NYC83FA106Accident · 2 fatalField investigationFinal reportBell 47G-2 · Waymart, PAThis was an introductory instructional flt. Witnesses observed the helicopter flying straight & level prior to the accident. The helicopter had impacted a 60-FT tree at about the 40-FT level. No preimpact failure/falfunction of either the airframe or engine…Apr 30, 1983 · N2829B · Destroyed NTSB MIA79FA042Accident · 5 fatalClosedBell 47G2 · Opa Locka, FLJan 17, 1979 · N2873B · 2 aircraft · Destroyed NTSB MIA79FLA34Accident · 1 fatalClosedBell 47G2 · Omega, GAAug 12, 1978 · N6729D · Destroyed NTSB IAD77DA011Accident · 1 fatalClosedBell 47G-2 · Pigeon Forge, TNNov 6, 1976 · N6755D · Destroyed NTSB OAK76FVG02Accident · 1 fatalClosedBell 47G-2 · Napa, CAJul 2, 1975 · N988B · Destroyed NTSB SEA75AS022Accident · 1 fatalClosedBell 47G-2 · Kingston, WANov 4, 1974 · N5160B · Destroyed NTSB LAX74AL057Accident · 2 fatalClosedBell 47D1 · Westminster, CAJan 28, 1974 · N74084 · Destroyed NTSB FTW74FPJ06Accident · 1 fatalClosedEL Tomcat MK5 · Springer, OKAug 16, 1973 · N11VH · Substantial damage NTSB NYC71FHA51Accident · 1 fatalClosedBell 47G2 · Branchville, NJJun 8, 1971 · N8426E · Destroyed NTSB SEA70F0119Accident · 2 fatalClosedBell 47G-2 · Loomis, WAOct 31, 1969 · N2803B · Destroyed NTSB UNK69X0137Accident · 3 fatalClosedBell 47G-2 · Ngara Fall, CanadaAug 5, 1969 · N8403E · Destroyed NTSB NYC69A0072Accident · 1 fatalClosedBell 47G-2 · Astoria, NYJan 10, 1969 · N710K · Destroyed NTSB LAX70F0025Accident · 2 fatalClosedBell 47G-2 · Hollywood, CASep 4, 1968 · N5193B · Destroyed NTSB ANC68A0004Accident · 1 fatalClosedBell 47G-2 · Cordova, AKJul 27, 1967 · N8406E · Destroyed NTSB ANC67A0037Accident · 1 fatalClosedBell 47G-2 · Anchorage, AKOct 16, 1966 · N2816B · Destroyed NTSB MKC67A0003Accident · 1 fatalClosedBell 47G-2 · St.Paul, MNJul 15, 1966 · N2820B · Destroyed NTSB UNK64X2719Accident · 1 fatalClosedBell 47G3 · Manson, WAJul 8, 1964 · N8441E · Destroyed