Skip to content

NTSB investigations: Bell 47G, FL

26 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

19652026

Where

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 ('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.\"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 ('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."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 ('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 MIA98LA170Accident · No injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot-in-command(CFI) failure to maintain control of the aircraft.May 28, 1998 · N182JR · Substantial damage NTSB ATL96LA106Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bartow, FLthe pilot's inadequate visual lookout, and his failure to maintain ground clearance, while maneuvering to avoid a collision with a utility line.Jul 9, 1996 · N6356 · Destroyed NTSB MIA93LA144Accident · Minor injuriesLimited investigationFinal reportBell 47G · Panama City, FLImproper planning/decision by the pilot-in-command and his failure to maintain rotor RPM, which resulted in failure of the helicopter to attain effective translational lift. Factors related to the accident were: the fence & terrain conditions.Jun 19, 1993 · N3628G · Substantial damage 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 MIA90LA077Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miami, FLInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The location of trees was a related factor in that the pilot was unable to maintain rotor RPM while attempting to reach a suitable landing area during…Mar 3, 1990 · N4837 · Substantial damage NTSB MIA89LA092Accident · No injuriesLimited investigationFinal reportBell 47G · Oklawaha, FLPilot's failure to properly control the helicopter during an attempted landing on the back of a truck. Contributing to the accident was the pilot's lack of experience in performing similar landings.Feb 24, 1989 · N863Z · Substantial damage NTSB MIA78FKT56Accident · No injuriesClosedBell 47G · Pompano, FLJun 30, 1978 · N62139 · Substantial damage NTSB MIA78FKT44Accident · Serious injuriesClosedBell 47G · North Miami, FLApr 26, 1978 · N4837 · Substantial damage NTSB MIA76FKT67Accident · Minor injuriesClosedBell 47G · N Miami Beach, FLApr 12, 1976 · N4837 · Substantial damage NTSB MIA76FLD46Accident · Minor injuriesClosedBell 47G · Clearwater, FLFeb 22, 1976 · N3628G · Substantial damage NTSB MIA76DKT10Accident · No injuriesClosedBell 47G · Miami, FLAug 30, 1975 · N4837 · Substantial damage NTSB MIA75DKT07Accident · No injuriesClosedBell 47G · Hollywood, FLJul 10, 1974 · N2867B · Substantial damage NTSB MIA74DLE08Accident · No injuriesClosedBell 47G · Mulberry, FLJun 19, 1974 · N7068 · Substantial damage NTSB MIA74DLD46Accident · No injuriesClosedEL Tomcat 47 · Arcadia, FLDec 14, 1973 · N208B · Substantial damage NTSB MIA73FLD50Accident · No injuriesClosedBell 47G · Orlando, FLDec 28, 1972 · N184B · Substantial damage NTSB MIA73FLD07Accident · No injuriesClosedBell Tomcat 47D · Winter Garden, FLAug 18, 1972 · N208B · Substantial damage NTSB MIA72AM126Accident · No injuriesClosedBell 47G · Opa Locka, FLMay 26, 1972 · N4837 · Substantial damage NTSB MIA72FKT48Accident · Serious injuriesClosedBell 47G · Ft Lauderdale, FLJan 29, 1972 · N16414 · Destroyed NTSB MIA72FKT10Accident · No injuriesClosedBell 47G · Hollywood, FLAug 23, 1971 · N2867B · Substantial damage NTSB MIA71FKT46Accident · No injuriesClosedBell 47G · Loxahatchee, FLMar 16, 1971 · N10175 · Substantial damage NTSB MIA70F0145Accident · Serious injuriesClosedBell 47-G · Winter Garden, FLJul 30, 1969 · N208B · Substantial damage NTSB MIA70D0009Accident · No injuriesClosedBell 47G · Groveland, FLMay 4, 1969 · N10175 · Substantial damage NTSB MIA69F0460Accident · No injuriesClosedBell 47G · Clermont, FLMay 1, 1969 · N208B · Substantial damage NTSB MIA68A0056Accident · No injuriesClosedBell 47G · Miami, FLDec 20, 1967 · N2867B · Substantial damage NTSB MIA66A0082Accident · Serious injuriesClosedBell 47G-1 · N.Miami Beach, FLJan 13, 1966 · N2821B · Substantial damage NTSB MIA66A0016Accident · No injuriesClosedBell 47G · Panama City, FLJul 26, 1965 · N3628G · Substantial damage