Fatal NTSB investigations: Bell 47G-3B
9 cases on aircraft the registry lists as Bell 47G-3B. 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
| 1967 | 1 |
|---|---|
| 1974 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1982 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181026'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181026'))
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 LAX94LA322Accident · 1 fatalLimited investigationFinal reportBell 47-G3B · Truk Island, MicronesiaThe pilot misjudged the clearance between the helicopter's rotor blades and the coconut trees.NTSB LAX93LA166Accident · 1 fatalLimited investigationFinal reportBell 47G2A · Pacific Ocean (Pacific Ocean)The passenger's failure to adhere to the pilot's instructions. Factors which contributed to the accident were: the language/communications difficulty between the pilot & the passenger, and the bird strike.NTSB DEN88FA106Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Cortez, COThe plt said that he had just taken off and reached an alt of about 300 ft when his collective control went 'limp'. The helicopter entered a descent, partially controlled by the plt using throttle and cyclic control inputs. The helicopter touched down in soft…NTSB ATL82FKQ12Accident · 1 fatalFinal reportBell/Soloy 47G-3B · Magee, MSThe Bell 47G-3B with a Soloy conversion was being used to demonstrate an aerial application spraying technique for use along powerline right-of-ways. For about 15 to 20 minutes after takeoff, routine spray runs were made over several different powerlines…NTSB ANC80FA015Accident · 1 fatalClosedBell 47G3B1 · Farewell, AKNTSB LAX79FUJ13Accident · 1 fatalClosedBell 47G3B · Springerville, AZNTSB NYC78FA055Accident · 1 fatalClosedBell 47G-3B · Wantagh, NYNTSB LAX74AL084Accident · 2 fatalClosedBell 47G-3B · La Crescnta, CANTSB DEN68A0008Accident · 2 fatalClosedBell 47G3B1 · Bondurant, WY