Skip to content

NTSB investigations: Bell 47D1, FL

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

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 ('1180802')) 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 ('1180802'))
  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 ('1180802'))
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 MIA98LA051Accident · No injuriesLimited investigationFinal reportBell 47D1 · Bunnell, FLthe student pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.Jan 3, 1998 · N59326 · Substantial damage NTSB MIA96LA028Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Jasper, FLImproper maintenance and inspection of the carburetor system by maintenance personnel during the last annual inspection which resulted in a partial loss of engine power due to carburetor ice. Contributing to the accident were: the pilot's failure to perform…Nov 15, 1995 · N4702S · Substantial damage NTSB MIA94FA125Accident · 2 fatalField investigationFinal reportBell 47D1 · Marathon, FLSeparation of the tail rotor gearbox and tail rotor blades for an undetermined reason. Factors related to the accident were: failure of maintenance personnel to follow the proper maintenance procedure after a previous tail rotor strike, and failure to conduct…Apr 22, 1994 · N9660 · Destroyed NTSB MIA92LA069Accident · No injuriesLimited investigationFinal reportBell 47D1 · Cross City, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the autorotative landing.Jan 27, 1992 · N93067 · Substantial damage NTSB MIA90LA096Accident · No injuriesLimited investigationFinal reportBell 47D1 · Rockledge, FLFailure of a connecting rod.Mar 25, 1990 · N10326 · Substantial damage NTSB MIA90LA023Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Loxahatchee, FLFailure of the pilot to maintain rotor RPM after pulling up from a swath run. A related factor was the presence of trees.Nov 2, 1989 · N93067 · Substantial damage NTSB MIA89LA133Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Miami, FLThe unqualified persons failure to maintain clearance from the fence. Pressure induced by others, lack of experience, and over confidence in personal ability are contributing factors to this accident.Apr 17, 1989 · N342L · Substantial damage NTSB MIA87LA116Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Homosassa, FLThe plt stated that just after takeoff, at about 50 ft, the eng lost power and he made a forced landing in a canal. No determination could be made as to the nature of the malfunction of the engine as described by the pilot.Mar 22, 1987 · N88929 · Substantial damage NTSB MIA86LA168Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Panama City Bch, FLThe pilot had intended to hover the helicopter and allow a 'clown' to touch the skids while a photographer recorded the event looking upward to give the appearance that the 'clown' was hanging from the skid. The 'clown' grabbed the left rear skid and the…May 29, 1986 · N10065 · Substantial damage NTSB MIA83LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Riverview, FLAccording to the pilot he lost control of the acft after a bird hit him on the right temple while flying at about 15 feet above the water. The acft was traveling at about 50 mph when the bird flew in through left door opening. The pilot lost control of the…Jan 29, 1983 · N74822 · Substantial damage NTSB MIA81FKJ03Accident · No injuriesClosedBell 47D1 · Panama City, FLNov 8, 1980 · N9115R · Substantial damage NTSB MIA79FLD57Accident · No injuriesClosedBell 47-D1 · Clearwater, FLApr 13, 1979 · N68632 · Destroyed NTSB MIA79DKT30Accident · No injuriesClosedBell 47G · Opa Locka, FLJan 7, 1979 · N2AR · Destroyed NTSB MIA76DLA48Accident · No injuriesClosedBell 47D-1 · Lake Butler, FLMay 21, 1976 · N74123 · Substantial damage NTSB MIA76DKT59Accident · No injuriesClosedBell 47D1 · South Bay, FLMar 1, 1976 · N12088 · Substantial damage NTSB MIA76DLA08Accident · No injuriesClosedBell 47D1 · Monticello, FLAug 21, 1975 · N74123 · Substantial damage NTSB MIA74DKT61Accident · No injuriesClosedBell 47D1 · Ochopee, FLMar 16, 1974 · N9660 · Substantial damage NTSB MIA74FLA08Accident · No injuriesClosedBell 47D-1 · Destin, FLAug 5, 1973 · N6579D · Substantial damage NTSB MIA72FKT22Accident · No injuriesClosedBell 47D-1 · South Bay, FLOct 20, 1971 · N160B · Substantial damage NTSB MIA70FLD13Accident · No injuriesClosedBell 47D1 · Nocatee, FLApr 1, 1970 · N6579D · Substantial damage NTSB MIA69F0050Accident · No injuriesClosedBell 47G · Cape Canaverl, FLJul 1, 1968 · N4018A · Substantial damage NTSB MIA68A0011Accident · No injuriesClosedBell 47D1 · Pnama Cty Bch, FLJul 22, 1967 · N322A · Substantial damage NTSB MIA66A0086Accident · Minor injuriesClosedBell 47D1 · Florida City, FLJan 31, 1966 · N322A · Substantial damage NTSB UNK64X2908Accident · No injuriesClosedBell 47D1 · Waverly, FLJul 18, 1964 · N4018A · Substantial damage