Fatal NTSB investigations: Bell 47G

15 cases on aircraft the registry lists as Bell 47G. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Fatal NTSB investigations: Bell 47G per year, 1964–2026: 15 cases
1964	3
1967	1
1968	1
1971	1
1978	2
1987	1
1993	2
1997	1
1998	2
2007	1

Where

Open the map

Latest cases

Query with SQL

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 ('1181002')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('1181002'))
  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 ('1181002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 DFW07WA110Accident · 1 fatalForeign investigationBell 47G · Ciudad Victoria, MexicoMay 12, 2007 · N25802 · Substantial damage NTSB FTW98FA306Accident · 2 fatalField investigationFinal reportBell 47G · Jones, OKThe pilot's failure to maintain adequate clearance from the trees during a low altitude flight/maneuver.Jul 10, 1998 · N12085 · Destroyed NTSB FTW98FA238Accident · 1 fatalField investigationFinal reportBell 47G · Bixby, OKThe pilot's failure to maintain clearance from the power lines.May 24, 1998 · N9954F · Substantial damage NTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).Sep 19, 1997 · N70747 · Destroyed NTSB LAX93FA272Accident · 1 fatalField investigationFinal reportBell 47G2-M · S. Sn Francisco, CAThe pilot's inadequate preflight planning/preparation which resulted in flight into high winds, turbulence and windshear.Jul 2, 1993 · N2473B · Destroyed NTSB MIA93FA121Accident · 2 fatalField investigationFinal reportBell 47-G · Parker, FLthe misjudgement of the distance by the nonrated pilot-in-command and subsequent collision with a tree. Contributing to the accident was the lack of helicopter experience of the pilot-in-command.May 16, 1993 · N970B · Destroyed NTSB NYC87FA114Accident · 2 fatalField investigationFinal reportBell 47G · Wassaic, NYThe Bell 47G helicopter was on a aerial survey of buried telephone cable when the red main rotor blade separated from the blade grips in flight. The main rotor hub with the main rotor blade separated from the transmission and the helicopter crashed. No…Mar 19, 1987 · N13766 · Destroyed NTSB MKC78FA065Accident · 3 fatalClosedBell 47-G2 · Branson, MOAug 18, 1978 · N939B · Destroyed NTSB FTW78FA032Accident · 1 fatalClosedBell 47G · Eola, TXMar 15, 1978 · N967B · Destroyed NTSB FTW71AF085Accident · 1 fatalClosedBell 47G-4A · New Orleans, LAJun 21, 1971 · N7814S · Destroyed NTSB MIA69F0149Accident · 1 fatalClosedBell 47G · Merigold, MSSep 2, 1968 · N10175 · Destroyed NTSB CHI67A0128Accident · 1 fatalClosedBell 47G · Dearborn, MIJun 3, 1967 · N953B · Destroyed NTSB UNK64X3405Accident · 1 fatalClosedBell 47G · Alameda, CAAug 15, 1964 · N179B · Destroyed NTSB UNK64X2560Accident · 1 fatalClosedBell 47G · Ogden, UTJun 29, 1964 · N19H · Destroyed NTSB UNK64X0867Accident · 2 fatalClosedBell 47G · Grand Isle, LAMar 10, 1964 · N994B · Destroyed