NTSB investigations: Bell 47G-2, 1984
6 cases on aircraft the registry lists as Bell 47G-2. 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.
Cases per year
| 1964 | 21 |
|---|---|
| 1965 | 16 |
| 1966 | 13 |
| 1967 | 18 |
| 1968 | 16 |
| 1969 | 22 |
| 1970 | 20 |
| 1971 | 10 |
| 1972 | 14 |
| 1973 | 19 |
| 1974 | 20 |
| 1975 | 20 |
| 1976 | 10 |
| 1977 | 9 |
| 1978 | 14 |
| 1979 | 12 |
| 1980 | 4 |
| 1981 | 9 |
| 1982 | 11 |
| 1983 | 9 |
| 1984 | 6 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 10 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 4 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2022 | 1 |
| 2026 | 2 |
Where
Open the mapLatest cases
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_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 year(c.\"eventDate\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_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 year(c."eventDate") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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 LAX85LA035Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Castroville, CAAt the beginning of a swath run a total loss of power occurred. During the hard forced landing, the main rotor blades severed the tail boom. The helicopter fuel tanks were found empty after the accident.NTSB CHI84LA317Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Jeffersonville, OHThe acft started to settle with power during takeoff after the acft was loaded with chemicals. The plt said he had a choice of, going through a fence or over it and decided to go over it. Pulling collective bled off m/r and the acft stopped flying. The tail…NTSB LAX84LA366Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Concord, CAAccording to a plt/operator statement, the student plt was cleared for a downwind apch to land on 'pad 3.' The student stated that the apch was normal until he slowed to 40 mph & 'made left turn to final approach into a cross wind.' During the turn to final…NTSB CHI84LA245Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · Nimrod, MNWhile landing in an area of tall grass a skid collided with a sand ridge causing a roll over.NTSB SEA84LA132Accident · No injuriesLimited investigationFinal reportBell 47G2A · Buena, WAMain rotor blades contacted a wind machine during an aerial application flt. Helicopter settled into trees and rolled over. Plt said he knew the machine was there but had forgotten.NTSB LAX84LA131Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Watsonville, CAThe plt reported that he was making a swath run at the edge of the field when he apchd a standpipe. He applied control pressure to avoid the obstruction, but the outer 3 inches of the rotor blades struck the standpipe. The helicopter contacted the ground…