NTSB investigations: Bell 47G-3B-1, 1991
10 cases on aircraft the registry lists as Bell 47G-3B-1. 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 | 4 |
|---|---|
| 1965 | 13 |
| 1966 | 22 |
| 1967 | 18 |
| 1968 | 19 |
| 1969 | 17 |
| 1970 | 11 |
| 1971 | 8 |
| 1972 | 10 |
| 1973 | 8 |
| 1974 | 15 |
| 1975 | 12 |
| 1976 | 6 |
| 1977 | 7 |
| 1978 | 8 |
| 1979 | 13 |
| 1980 | 8 |
| 1981 | 4 |
| 1982 | 6 |
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 4 |
| 1986 | 7 |
| 1987 | 3 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 10 |
| 1992 | 5 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2024 | 1 |
Where
Latest 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\") = 1991
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181028', '118103A'))
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") = 1991
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181028', '118103A'))
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 NYC92LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Catawissa, PAPilot factor in that the pilot used poor judgement and loaded more passengers than were seats on the helicopter this resulted in control interference and subsequent loss of control. Contributing was the pilot's failure to check the weight and balance for the…NTSB SEA91LA251Accident · No injuriesLimited investigationFinal reportBell BH-47-G3B1 · Rock Island, WAThe failure of the pilot to use the proper touchdown point while landing on a trailer.NTSB MIA91LA217Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Penuelas, PRInadvertent control interference by a passenger shortly after takeoff resulting in the loss of control and roll over after touchdown.NTSB CHI91LA257Accident · No injuriesLimited investigationFinal reportBell 47G · Lake Ozark, MOFailure of the rotorcraft's tail boom in flight. Factors related to the accident were reduced aircraft control available to the pilot.NTSB CHI91DER13Accident · No injuriesFinal reportBell 47G-3B-1 · Maple Grove, MNThe pilot's failure to maintain directional control of the helicopter during the forced landing. Related factors are the loss of engine power, loss of rotor RPM, the eroded compressor blades, the pilot's operation with known deficiencies in equipment and…NTSB DEN91LA096Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Colorado Spring, COThe pilot attempting to operate the helicopter outside the design operating envelope. Factors were: high altitude, high temperature, and high density altitude.NTSB SEA91FA142Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Goldendale, WAThe pilot's misjudgement of fuel supply.NTSB CHI91DER05Accident · No injuriesFinal reportBell 47G3B1 · Lasalle, MNThe pilot's failure to maintain adequate clearance from the terrain. A related factor is the pilot's misjudged altitude above the crop.NTSB SEA91LA109Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Malott, WAAn undetermined failure of the fuel pump casing resulting in an in flight fire and loss of engine power.NTSB NYC91DGT03Accident · Serious injuriesFinal reportBell 47-G3B1 · Hughesville, PAThe loss of engine power for undetermined reasons and the pilot's selection of the forced landing area.