Bell 47G-2
NTSB investigations · 379
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 ('1181008')
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 ('1181008')
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 ANC83LA035Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Anchorage, AKThe helicopter made a landing during which the tail boom was severed. This was a dual instructional flight and accordingto the instructor, a high reconnaissance was performed before selecting their approach to the pinnacle. The pinnacle is a 3000 foot landing…NTSB LAX83LVM01Accident · No injuriesFinal reportBell 47G2 · 5nm East Of Sal, CAAfter takeoff, during an aerial application flight, the pilot felt a sudden jolt and the engine RPM revved then decayed very rapidly. The pilot made a hard landing and the main rotor severed the tail rotor. The aircraft was within the weight and balance…NTSB MIA82DA174Accident · No injuriesFinal reportBell 47G-2 · Miami, FLThe pilot reported that while he was practicing an autorotative landing, he started to flare a bit too high. He stated that the helicopter touched down harder than normal and the main rotor blades flexed downward and swept across the tail boom. Subsequently,…NTSB SEA82DA112Accident · Serious injuriesFinal reportBell 47G-2 · Harrah, WAThe pilot reported that before taking off, the fuel quantity guages indicated there was sufficient fuel to complete one more load and still have an adequate reserve. After dispensing the load, the engine lost power while he was returning to the nurse truck.…NTSB LAX82DA186Accident · No injuriesFinal reportBell 47G2 · Santa Maria, CAThe helicopter contacted the platform with a landing skid and rolled over during an attempted takeoff. As the helicopterlifted off of a truck mounted platform a skid became fouled by the truck and a dynamic roll-over occurred.NTSB SEA82DA072Accident · No injuriesFinal reportBell 47G-2 · Grandview, WAWhile dispensing herbicide (systox) over an apple orchard the pilot sensed that the engine was binding followed by a power loss. The pilot elected to dump the herbicide and performed a power-off autorotation landing in a grape vineyard. Investigation revealed…NTSB NYC82DA097Accident · No injuriesFinal reportBell 47G-2 · Brookville, NYWhile returning to the heliport, the pilot noticed a decay in the engine and rotor rpm's. he elected to make a precautionary landing in a plowed field. During landing, the manifold pressure went to the red line while the RPM decayed. The helicopter touched…NTSB MKC82DA082Accident · Minor injuriesFinal reportBell 47G2 · Thornton, IADuring the downwind turn for the fourth spraying pass the pilot encountered a gust of wind. The pilot stated he applied power, collective and cyclic to level off at spraying altitude but the wind was too strong to prevent the tailboom from striking the ground.NTSB LAX82DA135Accident · No injuriesFinal reportBell 47G-2 · Stockton, CAThe pilot landed to pick up a flagger and take him to the end of the field. The landing was made facing north on a north-south driveway. An overhead line was located along the east side of the driveway. During takeoff, the pilot moved laterally to the west,…NTSB SEA82DA050Accident · No injuriesFinal reportBell 47G-2A · Lyle, WADuring takeoff with a load of fertilizer, insufficient power was available to maintain engine and rotor RPM and sustain flight. The pilot dumped the load, but was unable to avoid ground contact. The tail rotor struck first and separated from the aircraft. The…NTSB LAX82FA077Accident · No injuriesField investigationFinal reportBell 47G2 · Brawley, CAThe pilot visually checked the gas tank before takeoff and estimated there was about 1/4 tank of fuel. He then started the engine and hovered over to the water tanker and loaded 60 gallons of water in the spray tank in order to calibrate the number of gallons…NTSB LAX82DA051Accident · No injuriesFinal reportBell 47G-2 · Watsonville, CADuring a preceding spray operation, the pilot noted that some of the spray nozzles were not functioning properly. He flushed the tanks with fresh water and partially refilled them with water to perform an airborne nozzle check. While performing the check at…NTSB CHI82DER14Accident · No injuriesClosedBell 47G2 · Kerrick, MNNTSB NYC81FHJ17Accident · No injuriesClosedBell 47G-2 · Farmingdale, NYNTSB LAX81FUQ25Accident · No injuriesClosedBell 47G-2 · Agua Dulce, CANTSB CHI81DER47Accident · No injuriesClosedBell 47G-2 · Gully, MNNTSB LAX81FVD24Accident · No injuriesClosedBell 47G-2 · Oakland, CANTSB LAX81FVA38Accident · Serious injuriesClosedBell 47G-2 · Orosi, CANTSB LAX81FUG25Accident · Serious injuriesClosedBell 47G-2 · Oasis, CANTSB NYC81FHM04Accident · No injuriesClosedBell 47G-2 · Wingdale, NYNTSB SEA81FYP12Accident · No injuriesClosedBell 47G-2 · Union Gap, WANTSB LAX80DUQ15Accident · No injuriesClosedBell 47G-2 · Rosamond, CANTSB NYC80DHM19Accident · Minor injuriesClosedBell 47G-2 · Ramapo, NYNTSB MIA80FKJ35Accident · Serious injuriesClosedBell 47G-2 · Panama Cy Bch, FLNTSB LAX80FA063Accident · Serious injuriesClosedBell 47G2 · Brentwood, CANTSB LAX79DA091Accident · No injuriesClosedBell 47G2 · Greenfield, CANTSB ANC79DAA33Accident · Minor injuriesClosedBell 47G-2 · Ruby, AKNTSB MKC79DER70Accident · No injuriesClosedBell 47G-2 · St.Peter, MNNTSB LAX79FVM30Accident · No injuriesClosedBell 47G-2A · Salinas, CANTSB MKC79DCD28Accident · No injuriesClosedBell 47-G2 · Anthon, IANTSB OAK79DVA44Accident · No injuriesClosedBell 47G-2 · Kerman, CANTSB FTW79DPG55Accident · No injuriesClosedBell 47G-2 · Earle, ARNTSB NYC79FHA15Accident · Serious injuriesClosedBell 47G-2 · Waupwallopen, PANTSB OAK79FVM24Accident · Minor injuriesClosedBell 47-G2 · Salinas, CANTSB CHI79DEG13Accident · Minor injuriesClosedBell 47G-2 · Piqua, OHNTSB MIA79DKT49Accident · No injuriesClosedBell 47G · Miami, FLNTSB MIA79FA042Accident · 5 fatalClosedBell 47G2 · Opa Locka, FLNTSB OAK79DVM07Accident · Minor injuriesClosedBell 47G2 · Castroville, CANTSB FTW79FRG10Accident · No injuriesClosedBell 47G-2 · Alamo, TXNTSB MKC79FCA01Accident · Serious injuriesClosedBell 47G-2 · St Louis, MONTSB CHI78FEX40Accident · Minor injuriesClosedBell 47G2 · Waveland, INNTSB OAK78FVM41Accident · No injuriesClosedBell 47-G2 · Soledad, CANTSB MIA79FLA34Accident · 1 fatalClosedBell 47G2 · Omega, GANTSB NYC78IA074Incident · No injuriesClosedBell 47G2 · Garden City, NYNTSB MKC78FCA34Accident · Serious injuriesClosedBell 47G-2 · St Louis, MONTSB MKC78DCJ18Accident · No injuriesClosedBell 47-G2 · Neligh, NENTSB MKC78DCA30Accident · No injuriesClosedBell 47G-2 · Naylor, MONTSB SEA78DYP33Accident · No injuriesClosedBell 47G-2 · Benton City, WANTSB SEA78DYM23Accident · No injuriesClosedBell 47G-2 · Goldendale, WANTSB LAX78DUM16Accident · No injuriesClosedBell 47G2 · Oceanside, CA
Back to Bell 47G-2