NTSB investigations: Bell 47G-5, FL

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

19692026

NTSB investigations: Bell 47G-5, FL per year, 1969–2026: 12 cases
1969	1
1970	2
1973	2
1974	2
1984	1
1991	2
1992	1
2004	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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032')) 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
  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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
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 MIA04GA117Accident · 1 fatalFinal reportBell 47G-5 · Bunnell, FLThe pilot's continued flights and inadequate inspections after repeated tail rotor guard ground strikes due to improper flaring, which resulted in an in-flight failure of tail rotor drive shaft components, a loss of control, and the helicopter crash.Aug 4, 2004 · N232MC · Substantial damage NTSB MIA93LA027Accident · Minor injuriesLimited investigationFinal reportBell 47-G5A · Belle Glade, FLThe improper in flight decision of the pilot in command to attempt an agricultural turn with insufficient altitude to accomplish the maneuver. Contributing to the accident was the pilot's overconfidence in his abilities.Dec 7, 1992 · N7925J · Substantial damage NTSB MIA92LA014Accident · No injuriesLimited investigationFinal reportBell 47G-5 · La Belle, FLThe pilot in command's improper aft application of cyclic control during an autorotative landing to an open field, resulting in the main rotor blades colliding with the tail boom. Contributing to the accident was the in flight failure of the outer bearing of…Oct 13, 1991 · N1201W · Substantial damage NTSB MIA91TL#03Accident · No injuriesClass 3Final reportBell 47-G5A · Titusville, FLMar 27, 1991 · N7925J · Substantial damage NTSB MIA84LA179Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Jupiter, FLThe acft crashed landed after a partial loss of power. During an exam of the eng, the compressor bleed control valve was found stuck open causing an improper fuel/air mixture.Jun 7, 1984 · N1201W · Substantial damage NTSB MIA75DLD21Accident · No injuriesClosedBell 47G-5 · Plant City, FLSep 24, 1974 · N2214W · Substantial damage NTSB MIA74DLD71Accident · No injuriesClosedBell 47G5 · Arcadia, FLMar 9, 1974 · N8197J · Substantial damage NTSB MIA73DLA46Accident · No injuriesClosedBell 47G-5 · Newberry, FLJun 18, 1973 · N2214W · Substantial damage NTSB MIA73DLD54Accident · No injuriesClosedBell 47G-5 · Avon Park, FLJan 27, 1973 · N1476W · Destroyed NTSB MIA71FLD10Accident · Minor injuriesClosedBell 47G-5 · Frostproof, FLAug 17, 1970 · N4096G · Destroyed NTSB MIA70FLA11Accident · Minor injuriesClosedBell 47G-5 · Jasper, FLMar 23, 1970 · N7841S · Substantial damage NTSB MIA70F0184Accident · No injuriesClosedBell 47G-5 · Largo, FLJul 23, 1969 · N4041G · Destroyed