NTSB investigations: Bell 47G-5
16 cases on aircraft the registry lists as Bell 47G-5, where the first occurrence was “In flight collision with object”. 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
| 1984 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 2 |
| 2006 | 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 ('1181032')
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\" = 220))
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')
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" = 220))
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 CHI06CA242Accident · No injuriesData collectionFinal reportBell 47G-5 · Sanborn, NDThe pilot's failure to maintain clearance from the power lines during the aerial application flight. The power lines were a factor.NTSB LAX03CA285Accident · No injuriesData collectionFinal reportBell 47G-5 · Greenfield, CAthe pilot's failure to maintain clearance with the wires due to an inadequate visual lookout.NTSB CHI03LA210Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Cleveland, MNThe pilot's inadequate visual lookout and low altitude flight when he failed to maintain altitude/clearance from the transmission wire. A factor contributing to the accident was the transmission wire.NTSB LAX00LA280Accident · No injuriesLimited investigationFinal reportBell 47G-5 · King City, CAThe pilot's intentional flight into adverse weather which resulted in loss of visual reference and flight into power transmission wires and terrain.NTSB LAX98LA225Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Salinas, CAThe failure of the pilot to maintain clearance with the telephone lines.NTSB NYC96LA145Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Carver, MAthe pilot's inadequate visual look out for obstacles, which resulted in a collision with wires and the ground.NTSB LAX95LA113Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Sonoma, CAthe pilot's failure to maintain an adequate visual lookout for obstructions during initial climb. Factors which contributed to the accident were the pilot's inadequate preflight inspection, and his decision to fly with an inadequately cleaned bubble which…NTSB LAX93LA157Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Greenfield, CAThe pilot's failure to maintain an adequate clearance from the power lines while performing an aerial application run.NTSB MKC90LA124Accident · No injuriesLimited investigationFinal reportBell B47G-5 · Shell Knob, MOVisual outlook not maintained by the pilot in command.NTSB LAX90DVM01Accident · No injuriesFinal reportBell 47G-5 · Guadalupe, CAThe pilot's failure to maintain sufficient clearance allowing the aircraft to collide with a wooden power pole. Contributing to the accident was the sunglare which inhibited the pilot's vision.NTSB LAX88DVM02Accident · Minor injuriesFinal reportBell 47G5 · Oceano, CANTSB NYC86FNC05Accident · Minor injuriesFinal reportBell 47G-5 · Walthamer, MEWhile on a spray run the pilot of the Bell 47 was blinded by the sun as he was turning. The aircraft struck power lines, control was lost and the helicopter crashed.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 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 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.