NTSB investigations: Bell 47G-2
6 cases on aircraft the registry lists as Bell 47G-2, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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 | 1 |
| 1986 | 2 |
| 1987 | 1 |
Where
Latest 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\" = 351))
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" = 351))
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 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…NTSB SEA86LA168Accident · No injuriesLimited investigationFinal reportBell 47G2A · Chehalis, WADuring an aerial applications maneuver, a complete loss of power occurred. The power loss was caused by failure of the connecting rod bolt. The acft was too low for autorotation and the aircraft struck the ground tail low. The main rotor blade then struck the…NTSB SEA86LA143Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAEn route to the local spray area a total loss of power occurred along with a loss of oil pressure. The acft was aprx 200 ft AGL over a pear orchard. The plt was attempting to autorotate onto a nearby road but the left skid caught the roof top of a metal shed.…NTSB FTW83FA311Accident · Minor injuriesField investigationFinal reportBell 47G-2 · Bethany, OKThe helicopter collided with trees and rolled over during a forced landing after engine failure. The plt had been takingpassengers up for sight-seeing for several hours. After the last flt he and his wife had departed the city park to fly back to the acft…NTSB LAX83LVM01Accident · No injuriesFinal reportBell 47G2 · 5nm East Of Sal, CAAfter takeoff, during an aerial application flight, the pilot felt a sudden jolt and the engine RPM revved then decayed very rapidly. The pilot made a hard landing and the main rotor severed the tail rotor. The aircraft was within the weight and balance…NTSB SEA82DA072Accident · No injuriesFinal reportBell 47G-2 · Grandview, WAWhile dispensing herbicide (systox) over an apple orchard the pilot sensed that the engine was binding followed by a power loss. The pilot elected to dump the herbicide and performed a power-off autorotation landing in a grape vineyard. Investigation revealed…