Query with SQL
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1181002')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR26LA247Accident · Serious injuriesClass 4 · LimitedInvestigation openBell 47G · Springtown, TXNTSB WPR23LA006Accident · No injuriesClass 3 · LimitedFinal reportBell 47G2 · Mesa, AZA total loss of engine power due to fuel exhaustion.NTSB GAA16CA143Accident · Minor injuriesData collectionFinal reportBell 47 · Agua Dulce, CAThe pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.NTSB WPR14CA196Accident · No injuriesData collectionFinal reportBell 47G · Bakersfield, CAThe pilot's failure to maintain aircraft control after the helicopter's skid catching on the side of a trailer during takeoff, which resulted in a dynamic rollover.NTSB WPR14LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G · El Monte, CAA partial loss of engine power during climbout due to a malfunctioning magneto and spark plugs.NTSB WPR11LA190Accident · Minor injuriesLimited investigationFinal reportBell 47G · Torrance, CAThe pilot did not maintain adequate altitude during takeoff, which resulted in ground contact and a dynamic rollover.NTSB DFW07WA110Accident · 1 fatalForeign investigationBell 47G · Ciudad Victoria, MexicoNTSB DFW05CA235Accident · Serious injuriesData collectionFinal reportBell 47G · Swifton, ARThe pilot's failure to maintain clearance with the power lines. A contributing factor was sun glare.NTSB ATL01LA108Accident · No injuriesLimited investigationFinal reportBell 47G · Berry, ALThe failure of the main rotor system stabilizer damper control horn assembly, resulting in an uncontrolled descent and subsequent collision with a tree and terrain.NTSB NYC00LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Coudersport, PAThe pilot's improper preflight planning and decision to attempt a takeoff with the passenger from the confined area.NTSB FTW98LA371Accident · No injuriesLimited investigationFinal reportBell 47G · Monette, ARThe pilot's failure to maintain control. A factor was his lack of total flight experience in helicopters.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.NTSB MIA98LA170Accident · No injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot-in-command(CFI) failure to maintain control of the aircraft.NTSB FTW98FA238Accident · 1 fatalField investigationFinal reportBell 47G · Bixby, OKThe pilot's failure to maintain clearance from the power lines.NTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).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.NTSB ATL95LA171Accident · No injuriesLimited investigationFinal reportBell 47G · Union City, TNFailure of a #4 connecting rod bolt, which resulted in engine stoppage and a forced landing.NTSB FTW94LA166Accident · No injuriesLimited investigationFinal reportBell 47G · Sulphur, OKThe loss of engine power due to the failure of an engine accessory oil pump gear. A factor was the lack of suitable terrain for the autorotation.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.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.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.NTSB MIA91LA141Accident · No injuriesLimited investigationFinal reportBell 47-G · Aguadilla, PRThe improper in flight planning/decision of the pilot-in-command to conduct an out-of-ground-effect hover with a right crosswind. This resulted in an in flight loss of control due to settling with power and in flight collision with terrain.NTSB FTW91LA007Accident · No injuriesLimited investigationFinal reportBell 47G · Grand Prairie, TXThe pilot's inadequate compensation for the existing tailwind conditions and his failure to maintain rotor RPM.NTSB LAX90LA164Accident · Minor injuriesLimited investigationFinal reportBell 47G · Riverside, CAThe pilot's failure to maintain control of the helicopter. A factor related to the accident was: the pilot's lack of experience in the type of aircraft.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…NTSB SEA89LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G · Corvallis, ORStudent pilot's improper use of the collective control while performing hovering autorotations, and the instructor's inadequate supervision of the student's actions, which resuled in hard landings. In addition, the engine mount was significantly weakened…NTSB MKC89LA195Accident · No injuriesLimited investigationFinal reportBell 47G · Ozark, MOThe failure of the dual student to properly flare during an autorotative landing resulting in a hard landing and partial failure of the right skid. The CFI also failed to properly monitor the student's actions on the flight controls.NTSB MIA89LA229Accident · No injuriesLimited investigationFinal reportBell 47G · Ponce, PRFailure of the aft tail rotor drive shaft.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.NTSB ATL87LA229Accident · Minor injuriesLimited investigationFinal reportBell 47G (TOM CAT) · Dothan, ALThe plt rprtd that while he was making a turn-around over trees after the 1st swath run, the helicopter enctrd a sudden wind change. He stated that the wind cond was from a cumulus buildup which put him in a tailwind situation. As he completed his turn with…NTSB NYC87LA210Accident · Minor injuriesLimited investigationFinal reportBell 47G3 · Marston Mills, MAThe helicopter reached an altitude of about 50 feet when a loss of power was experienced. Immediately the pilot set up for an emergency landing and set the helicopter down. The aircraft, however, collided with the ground hard and incurred substantial damage.…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…NTSB FTW86LA043Accident · No injuriesLimited investigationFinal reportBell 47G · Beaumont, TXThe pilot was taking off from an area which was protected from the wind by a large building. After obtaining translational lift and climbing above the building, a right quartering tail wind, with gusts to 20 knots, was encountered. The pilot stated he lost…NTSB MKC85LA152Accident · Minor injuriesLimited investigationFinal reportBell 47G · Pella, IAThe purpose of the flt was to provede training in aerial application procedures and techniques for the plt/owner of N75273. The instructor plt has extensive experience in this m/m and was at the controls. He was demonstrating a turn around at the end of a…NTSB LAX85LA079Accident · No injuriesLimited investigationFinal reportBell 47G · Chatsworth, CAThe plt was practicing off airport touch & go's. on the second lndg the left skid contacted a hidden dirt embankment andthe acft rolled over. A post impact fire consumed the aircraft. Both certificated commercial plts aboard the helicopter escaped unharmed.…NTSB CHI84LA211Accident · Serious injuriesLimited investigationFinal reportBell 47G · Drummond Island, MIThe plt had previously made 2 local flts, during which, he practiced water landings & takeoffs as well as other maneuvers. On the 3rd flt, he made several water takeoffs & landings. Then while on a landing, the helicopter began to roll quickly to the right.…NTSB LAX84LA108Accident · No injuriesLimited investigationFinal reportBell 47G · El Cajon, CADuring a demonstration to show his student how to autorotate fm a 2 ft height AGL the instructor reduced pwr and inadvertently applied fwd cyclic. The front portion of the skids hit the gd followed by the main rotor blades. Helicopter then rocked backwards,…NTSB LAX83FA448Accident · No injuriesField investigationFinal reportBell 47G · Oceanside, CAShortly after takeoff, the eng lost power at an alt of aprx 400 ft AGL. An autorotative landing was made on uneven terrain beside a stream with weeds aprx 3 ft high. During touchdown, the main rotor struck the tail boom. An inspection of the engine revealed…NTSB ATL83LA354Accident · No injuriesLimited investigationFinal reportBell 47G · Charleston, WVThe helicopter settled after takeoff and rolled over after touching down on sloping terrain. One of the two pilots aboard was being transported to receive a private rating in helicopters. He had been endorsed for solo in the Bell 47 and had flown the Bell 47…NTSB NYC83FHM01Accident · Minor injuriesFinal reportBell 47G · Plainsboro, NJThe acft collided with the ground after a tail rotor drive shaft failed. The plt lost tail rotor control during an aerial application maneuver. The metallurgist report of examination and discovery of fatigue fracture after the accident is a part of the…NTSB LAX82FA341Accident · Minor injuriesField investigationFinal reportBell 47G-2 · San Diego, CAThe plt was in the local pattern practicing maneuvers. After completing a quick stop maneuver & hovering, another takeoff was initiated. The plt stated that it seemed to take an unusual amount of forward cyclic to initiate forward flt. During the final…NTSB CHI82DA212Accident · No injuriesFinal reportBell 47G-2A · Hudsonville, MIThe pilot was flying a swath run that required him to fly under electric wires near a blacktop county road. As the pilot was coming off the field and passing under the wires, he realized he was on a collision course with a car. He pulled up to avoid the car…NTSB CHI82DA176Accident · Minor injuriesFinal reportBell 47G-1 · Cincinnati, OHThe fore and aft cyclic control linkage tube became disconnected in flight. An emergency descent, using collective "s" turns to reduce airspeed was performed. The pilot intentionally collided with trees during the forced landing to cushion the fall.…NTSB MKC82DA080Accident · No injuriesFinal reportBell 47G-2 · Osage Beech, MOShortly after the helicopter cleared the helipad the pilot noticed that although he had the cyclic positioned in the full forward position against the stop the airspeed was gradually decaying. The pilot then removed his seatbeat and moved forward. Along with…NTSB FTW82DA073Accident · No injuriesFinal reportBell 47G · Dallas, TXThe pilot attempted to land on a narrow flatbed trailer. He stated that he encountered some buffeting from the wind funneling between two hangars. On his third attempt to position the helicopter on the trailer, the right skid slipped off. The main rotor…NTSB LAX81DVM17Accident · No injuriesClosedBell 47G · Pescadero, CANTSB ATL81FKW02Accident · Minor injuriesClosedBell 47G · Clarksville, TNNTSB LAX80DVA64Accident · No injuriesClosedBell 47G · Bakersfield, CANTSB NYC80FGT16Accident · No injuriesClosedBell 47G · Gettysburg, PANTSB LAX80FA104Accident · No injuriesClosedBell 47G · Long Beach, CA
Back to Bell 47G