NTSB investigations: Bell 47G-3B-1, 1992
5 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
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\") = 1992
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") = 1992
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 MIA93LA014Accident · Minor injuriesLimited investigationFinal reportBell 47-G3-B1 · Palm Beach, FLThe pilot's inadequate preflight planning. A factor was the pilot's failure to maintain rotor RPM during the autorotation.NTSB ATL93LA009Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Centre, ALThe pilot's failure to maintain main rotor RPM, which resulted in an in flight loss of control and collision with terrain.NTSB CHI92LA249Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Marshall, INThe pilot's failure to maintain control of the helicopter due to his alcoholic impairment of efficiency and judgement.NTSB NYC92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · West Mifflin, PAA yaw for unknown reason(s) which resulted in the tail rotor contacting the dirt bank and a loss of control. A factor related to the accident was the decision of the pilot to operate in close vicinity to the dirk bank.NTSB SEA92LA067Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Miltonfreewater, ORThe inadequate prelight preparation by the pilot in his failure to ensure the filler hose was removed before attempting to takeoff.