Bell 47G3B2A
NTSB investigations · 23
Matched to the registry by N-number and event date, newest first.
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 ('1181025')
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 ('1181025')
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 IAD03LA042Accident · No injuriesLimited investigationFinal reportBell BHT-47-G3B2A · Lexington, KYThe pilot's failure to maintain directional control while maneuvering to land after a loss of engine power. A factor was the loss of engine power.NTSB ATL02LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Marion, ALThe pilot's failure to maintain visual lookout while conducting an aerial application maneuver. A factor was the transmission line.NTSB DEN99LA168Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Tremonton, UTThe pilot's failure to maintain rotor rpm while attempting a precautionary autorotation landing. A factor was the loss of engine power for undetermined reasons.NTSB SEA99LA098Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Pendleton, ORA fouled external load cable, and the pilot's operation of the helicopter with a non-approved external bucket installation, resulting in misrouted hydraulic lines and consequent malfunction of the external load release system.NTSB SEA98LA069Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Stanwood, WAThe failure of the number two connecting rod, which led to additional internal engine damage and a complete loss of power. Factors include soft terrain in the area where the pilot found it necessary to execute his forced landing.NTSB SEA93LA034Accident · No injuriesLimited investigationFinal reportBell 47G3-B2A · Montpelier, IDThe loss of engine power due to leaking internal carburetor seals, resulting from improper repair of the carburetor by an acft repair station.NTSB FTW92LA026Accident · Serious injuriesLimited investigationFinal reportBell 47G3B2A · Texarkana, TXThe pilot's failure to maintain proper terrain clearance during takeoff. A factor was his lack of total experience in helicopters.NTSB NYC91DNA01Accident · No injuriesFinal reportBell 47-G3-B · Nantucket, MAA hard landing, after a power loss due to improper use of the carburetor heat control by the pilot.NTSB SEA89LA175Accident · 1 fatalLimited investigationFinal reportBell 47G3B2 · Monitor, WAThe pilot failed to maintain aircraft separation from obstacles on the ground. A factor in the accident was the bright glare from the rising sun.NTSB SEA89LA116Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2A · Dyer, NVThe pilots poor planning in attempting a hover in undesirable conditions which resulting in the inability to maintain rotor rom. Contributing to the accident was the mountainous terrain and high density alt.NTSB DEN87LA120Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Brigham City, UTAn ag plt was ferrying a helicopter to another job in his local area. The plt, an ATP, had estimated that the helicopter had enough fuel for the flt. The helicopter's engine quit and an autorotation was performed, resulting in a hard landing. Less than one…NTSB DEN84LA260Accident · No injuriesLimited investigationFinal reportBell 47G · West Glacier, MTFollowing in-flight power loss the pilot performed an autorotation to a forced landing on a highway. On touchdown, the main rotor made contact with a passing motor home. Investigation revealed no fuel on board, although the pilot calculated 0.6 hours of fuel…NTSB NYC81FNA19Accident · No injuriesClosedBell 47G-3B · Pawtucket, RINTSB SEA81DYP21Accident · Serious injuriesClosedBell 47G3B2 · Walla Walla, WANTSB DEN81FTI06Accident · 1 fatalClosedBell 47G-3B · Thompson Falls, MTNTSB DEN79FQA06Accident · No injuriesClosedBell 47G3B2 · Albuquerque, NMNTSB SEA76FYG50Accident · No injuriesClosedBell 47G-3B · Spokane, WANTSB CHI76AC012Accident · 1 fatalClosedBell 47G · Chicago, ILNTSB OAK75DVA30Accident · Minor injuriesClosedBell 47G3B2 · Big Creek, CANTSB DEN74DQA42Accident · No injuriesClosedBell 47G3B2 · Farmington, NMNTSB DEN74DQA06Accident · No injuriesClosedBell 47G3B2 · Luna, NMNTSB DEN73AD055Accident · 1 fatalClosedBell 4G3B2A · Luna, NMNTSB OAK73DVD01Accident · No injuriesClosedBell 47 · Monte Rio, CA
Back to Bell 47G3B2A