NTSB investigations: Bell 47G-5

8 cases on aircraft the registry lists as Bell 47G-5, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19822026

NTSB investigations: Bell 47G-5 per year, 1982–2026: 8 cases
1982	1
1983	1
1985	1
1987	1
1990	1
1996	1
1998	1
2006	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."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" = 353)) 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.\"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\" = 353))
  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" = 353))
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 LAX06CA180Accident · No injuriesData collectionFinal reportBell 47-G5 · Soledad, CAfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and failure to refuel the helicopter which resulted in a loss of engine power.May 23, 2006 · N4741R · Substantial damage NTSB IAD99LA024Accident · Serious injuriesLimited investigationFinal reportBell 47-G5 · Essex Junction, VTthe pilot's improper entry into the autorotation, which resulted in the loss of power and a low rotor rpm condition. Also causal was the pilot's improper execution of the autorotation which resulted in the hard landing. Factors in the accident were the…Dec 14, 1998 · N8103J · Substantial damage NTSB LAX96LA287Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Lost Hills, CAimproper installation of the carburetor air box.Jul 23, 1996 · N7885S · Substantial damage NTSB NYC90DNA02Accident · No injuriesFinal reportBell 47G5 · Marion, MAImproper use of carburetor heat by the pilot resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.Apr 26, 1990 · N8591F · Substantial damage NTSB LAX87DVM03Accident · No injuriesFinal reportBell 47G-5 · Salinas, CAAt the end of an aerial application operation, enroute to the airport, the engine quit. The pilot autorotated the helicopter onto a soft field, where on touchdown, the helicopter was substantially damaged. Inspection of the helicopter revealed that the fuel…Jun 28, 1987 · N6288N · Substantial damage NTSB CHI86FA017Accident · 1 fatalField investigationFinal reportBell 47G-5 · Plainfield, WIThe acft crashed into trees and nosed into the wooded terrain after a loss of powr. The helicopter had been refueled the day before the acc. Normal fuel load was 20 gals. The plt had sprayed 20 acres & flown 9 miles to another field to spray but aborted due…Oct 27, 1985 · N7840S · Destroyed NTSB LAX83FUM07Accident · No injuriesFinal reportBell 47G-5 · Valley Center, CAThe acft was damaged during a forced landing following a power loss while engaged in aerial application. The pilot took off with 25 gallons of fuel which he said was usually enough for spraying 40-50 acres. This job was 19 acres but it was 10-12 miles away at…Jun 14, 1983 · N2252W · Substantial damage NTSB CHI82DA171Accident · Minor injuriesFinal reportBell 47G-5 · Sublette, ILPrior to this flight, the helicopter had been flown about 1 hr from roselle to Sublette, IL, then it was flown another 1/2 hr to survey the area to be sprayed. About 10 minutes after departing to spray, the engine lost power. The pilot started an autorotative…May 17, 1982 · N7841S · Substantial damage