Skip to content

NTSB investigations: Bell 47G-2, FL

28 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

19662026

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" = 'FL' 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 ('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.\"eventStateOrRegion\" = 'FL' 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 ('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."eventStateOrRegion" = 'FL' 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 ('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 GAA20CA062Accident · No injuriesData collectionFinal reportBell 47G · Groveland, FLThe student pilot's improper cyclic input after a reported hydraulic failure, the reason for which could not be determined, and his failure to follow the emergency procedures, which resulted in a hard landing.Nov 7, 2019 · N6746D · Substantial damage NTSB MIA02LA101Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Bunnell, FLThe failure of the student pilot to secure the rotorcraft floorboard mounted ballast, resulting in shifting of the ballast on liftoff, and the subsequent dynamic rollover.May 28, 2002 · N6746D · Substantial damage NTSB MIA00LA176Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Fort Walton Bch, FLThe unsuitable terrain encountered by the pilot-in-command during the forced landing and the loss of engine power for undetermined reasons.May 27, 2000 · N96MB · Substantial damage NTSB MIA98LA154Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Fort Walton Bch, FLThe loss of engine power for undetermined reasons.May 9, 1998 · N6714D · Substantial damage NTSB MIA91LA215Accident · No injuriesLimited investigationFinal reportBell 47G2A · Immokalee, FLThe improper use of the flight controls by the pilot in command, which resulted in a collision with the ground and a nose over.Sep 7, 1991 · N7573 · Substantial damage NTSB MIA89LA213Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Sarasota, FLThe student pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the student pilot's lack of total experience & tree(s) in the emergency landing area.Aug 5, 1989 · N3550 · Substantial damage 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 MIA87LA190Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Miami, FLThe instructor plt stated that the helicopter began to vibrate while the student plt was maneuvering it during an instructional flt. The instructor plt then executed a forced landing and upon touchdown the main rotor blades contacted the ground. Inspection of…Jun 20, 1987 · N6772D · Substantial damage NTSB MIA87IA185Incident · No injuriesIncident investigationFinal reportBell 47G-2 · Miami, FLWhile in cruise flt at aprx 300 ft the plt reported that he heard a loud noise followed by a loss of power. He then autorotated & set the helicopter down with no further incident. Insp of the eng revealed that the number 6 cylinder connecting rod failed near…Jun 17, 1987 · N17271 · Minor damage NTSB MIA85LA243Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Moore Haven, FLThe plt stated that while flying around his property, he slowed the helicopter up to descend and land, at aprx 40 ft altitude the eng lost power due to carburator ice buildup. He autorotated to a landing & on touchdown his right skid contacted a large boulder…Sep 4, 1985 · N8429E · Substantial damage NTSB MIA85LA223Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Ochopee, FLThe plt stated that he dropped his passenger off at a water station in the everglades, water taxied away from the station, accellerated up to 3100 RPM & just before he added collective pitch the transmission ass'y departed the helicopter, it rolled to the…Aug 1, 1985 · N88AR · Substantial damage NTSB MIA85LA085Accident · No injuriesLimited investigationFinal reportBell 47-G · Miami, FLThe plt stated the helicopter gained too much forward speed because of gusty winds while he was maneuvering the helicopter to the refueling area. A hard landing resulted as the plt attempted to slow the helicopter to avoid contacting refueling equipment.Jan 28, 1985 · N17271 · Substantial damage NTSB MIA83LA196Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Miami, FLThe student was a rated single eng, multiengine, land plt, but did not have a helicopter rating. During a dual instructional flt, he had just completed the final phase of an autorotation & the skids were on the ground, when he abruptly pulled the collective…Aug 5, 1983 · N471KC · Substantial damage NTSB MIA83FA181Accident · Serious injuriesField investigationFinal reportBell 47G-2 · Lake Worth, FLAt 2037 EDT, the plt called palm beach tower & reported that he was east of lantana arpt at 500 ft, inbound for a landing at the palm beach arpt. Aprx a min later, there was another call from helicopter stating that it was going down, out of fuel. During an…Jul 7, 1983 · N366DJ · Substantial damage NTSB MIA82DA174Accident · No injuriesFinal reportBell 47G-2 · Miami, FLThe pilot reported that while he was practicing an autorotative landing, he started to flare a bit too high. He stated that the helicopter touched down harder than normal and the main rotor blades flexed downward and swept across the tail boom. Subsequently,…Aug 20, 1982 · N366DJ · Substantial damage NTSB MIA80FKJ35Accident · Serious injuriesClosedBell 47G-2 · Panama Cy Bch, FLMay 4, 1980 · N5185B · Substantial damage NTSB MIA79DKT49Accident · No injuriesClosedBell 47G · Miami, FLMar 25, 1979 · N514SF · Destroyed NTSB MIA79FA042Accident · 5 fatalClosedBell 47G2 · Opa Locka, FLJan 17, 1979 · N2873B · 2 aircraft · Destroyed NTSB MIA74AM079Accident · Serious injuriesClosedBell 47G-2 · Miami, FLMar 14, 1974 · N4775S · Destroyed NTSB MIA74ALD35Accident · Serious injuriesClosedBell 47G-2 · Ft Pierce, FLOct 28, 1973 · N2883B · Substantial damage NTSB MIA74FLA06Accident · No injuriesClosedBell 47G2 · High Springs, FLAug 4, 1973 · N5180B · Substantial damage NTSB MIA71FKT61Accident · No injuriesClosedBell 47G · Homstead, FLMay 7, 1971 · N17271 · Destroyed NTSB MIA71FLA09Accident · No injuriesClosedBell 47G-2 · Panama City, FLAug 14, 1970 · N5185B · Substantial damage NTSB MIA70FLD32Accident · No injuriesClosedBell 47-G2 · Kissimmee, FLJun 19, 1970 · N6750D · Destroyed NTSB MIA69D0067Accident · No injuriesClosedBell 47G-2 · Panama City, FLJun 29, 1968 · N5185B · Substantial damage NTSB MIA68A0040Accident · No injuriesClosedBell 47G · Davie, FLOct 25, 1967 · N17271 · Substantial damage NTSB MIA67A0086Accident · No injuriesClosedBell 47G-2 · Ft.Lauderdale, FLFeb 19, 1967 · N2487B · Substantial damage NTSB MIA66A0125Accident · Minor injuriesClosedBell 47G-2 · Homestead, FLApr 26, 1966 · N6774D · Substantial damage