NTSB investigations: Bell 47G-2
14 cases on aircraft the registry lists as Bell 47G-2, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181008')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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 ('1181008')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 FTW04LA198Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · La Porte, TXThe loss of engine power for undetermined reasons.NTSB LAX94LA303Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Scottsdale, AZThe pilot's failure to refuel appropriately, the altitude and airspeed at the time the engine stoppage occurred were factors in the accident.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.NTSB ATL92LA160Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Slocomb, ALA hard landing due to a power loss from fuel exhaustion. A factor in the accident was the lack of sustable terrain for the landing.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.NTSB CHI88DEM05Accident · No injuriesFinal reportBell 47G-2A · Midland, MIThe plt rprtd that before takeoff, he checked the fuel gage & concluded there was enough fuel to dispense his load. However, after spraying out the load, he started to return to the landing site & then the eng lost power from fuel exhaustion. The helicopter…NTSB CHI87DEV02Accident · No injuriesFinal reportBell 47G2 · Peoria Heights, ILReturning from a powerline patrol flight, the engine surged twice and quit. The pilot executed an autorotation to the only available landing site, a high school football field. On touchdown the blades flexed and severed the tailboom. Investigation revealed…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…NTSB SEA85LA155Accident · No injuriesLimited investigationFinal reportBell 47G2 · Roosevelt, WAA total loss of power occurred while on a CFR 137 flight, due to fuel exhaustion. Although the fuel gauge showed 1/2 tank of fuel, the pilot failed to visually check the fuel prior to this flight. During autorotation onto a wheat field a hard landing occurred…NTSB LAX85LA035Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Castroville, CAAt the beginning of a swath run a total loss of power occurred. During the hard forced landing, the main rotor blades severed the tail boom. The helicopter fuel tanks were found empty after the accident.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…NTSB SEA83LA122Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAThe rotorcraft made a hard landing after colliding with trees during an autorotation. The acft had experienced an enginefailure while on a repositioning flight between aerial application operations and was forced to land. The acft was autorotated into an…NTSB SEA82DA112Accident · Serious injuriesFinal reportBell 47G-2 · Harrah, WAThe pilot reported that before taking off, the fuel quantity guages indicated there was sufficient fuel to complete one more load and still have an adequate reserve. After dispensing the load, the engine lost power while he was returning to the nurse truck.…NTSB LAX82FA077Accident · No injuriesField investigationFinal reportBell 47G2 · Brawley, CAThe pilot visually checked the gas tank before takeoff and estimated there was about 1/4 tank of fuel. He then started the engine and hovered over to the water tanker and loaded 60 gallons of water in the spray tank in order to calibrate the number of gallons…