NTSB investigations: Bell 47G-3B-1
10 cases on aircraft the registry lists as Bell 47G-3B-1, 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 2 |
| 1990 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2005 | 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 ('1181028', '118103A')
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 ('1181028', '118103A')
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 CHI05CA147Accident · Minor injuriesData collectionFinal reportBell 47G · Twin Brooks, SDThe pilot's inadequate lookout and his failure to maintain clearance with the power lines. A factor was the low altitude at which the helicopter was operating.NTSB SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.NTSB MIA00LA257Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Canton, MSThe pilot's inadequate visual lookout which resulted in the helicopter colliding with power lines, catching fire, and being consumed by fire after landing.NTSB CHI98LA198Accident · Serious injuriesLimited investigationFinal reportBell 47G · Le Center, MNthe pilot's failure to maintain clearance with the wire. A factor associated with the accident was the wire which the helicopter contacted.NTSB MIA90LA125Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Lake Wales, FLThe pilot's failure to maintain adequate clearance between the main rotor blades and a power line pole while maneuvering during an aerial application flight.NTSB SEA86LA182Accident · Serious injuriesLimited investigationFinal reportBell 47G3B1 · Albany, ORA Bell 47G3B1 crashed into the south santiam river after contacting power lines while on an instructional flight. The CFI (helicopter) plt received serious injuries and the private plt (airplane) helicopter student received minor injuries. The helicopter…NTSB SEA86LA079Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Overton, NVThe noncertificated plt rprtd that he had repaired the helicopter, then proceeded to make a local test flt. He rprtd that he took off in darkness after having a few beers. The plt chose to turn off the landing light shortly after takeoff. While at low…NTSB CHI84LA232Accident · Minor injuriesLimited investigationFinal reportBell 47G · Fairfax, MNThe helicopter plt turned at the end of a spray run & the acft collided with a power line. He said that because of a quartering tailwind, the helicopter was in a nose high attitude & the tail rotor hit a wire. The plt was able to make an autorotation after…NTSB LAX83LA184Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Delano, CAThe acft collided with a power line and trees while applying pesticide to an orchard. The pilot was flying into the rising sun and failed to see the power line which serviced an agricultural deep well.NTSB ATL82DA179Accident · Minor injuriesFinal reportBell 47G-3B-1 · Headland, ALThe pilot was positioning the aircraft for refueling when the main rotor contacted the fuel meter. There was substantialdamage to the helicopter and minor injuries to the chemical loader.