NTSB investigations: Bell 47G-3B-1, 1974
15 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\") = 1974
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") = 1974
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 FTW75FRG48Accident · Serious injuriesClosedBell 47GB31 · Freer, TXNTSB LAX75DUG22Accident · No injuriesClosedBell 47G3B1 · Joshua Tree, CANTSB DEN75AD022Accident · Minor injuriesClosedBell 47G3B1 · Vernal, UTNTSB DEN75FTE21Accident · No injuriesClosedBell 47G3B1 · Grand Valley, CONTSB DEN75AD009Accident · 1 fatalClosedBell 47G3B1 · Ogden, UTNTSB OAK75DXQ19Accident · No injuriesClosedBell 47G3B1 · Soda Sprngs, CANTSB DEN75AD003Accident · No injuriesClosedBell 47G3B1 · Grand Valley, CONTSB SEA74DTI29Accident · No injuriesClosedBell 47G3B1 · Lima, MTNTSB MKC74FCQ41Accident · No injuriesClosedBell 47G-3B · Dodge City, KSNTSB SEA74DYG44Accident · No injuriesClosedBell 47G3B1 · Stratford, WANTSB SEA74DYC54Accident · Minor injuriesClosedBell 47G-3B · North Powder, ORNTSB SEA74DYE44Accident · Minor injuriesClosedBell 47G3B1 · Forks, WANTSB OAK74FXQ28Accident · No injuriesClosedBell 47G-3B · Bordertown, NVNTSB LAX74DUJ75Accident · No injuriesClosedBell 47G3B1 · Supai, AZNTSB SEA74DTI18Accident · No injuriesClosedBell 47G3B1 · Conrad, MT