NTSB investigations: Bell 47G-3B-1, 1967
18 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\") = 1967
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") = 1967
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 DEN68A0020Accident · Minor injuriesClosedBell 47G-3B · Silverthorne, CONTSB SEA68A0033Accident · No injuriesClosedBell 47G3B1 · Snoqualmie P, WANTSB DEN68A0019Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMNTSB UNK67X0157Accident · No injuriesClosedBell 47G3B1 · Dhahran, Saudi ArabiaNTSB OAK68A0028Accident · Minor injuriesClosedBell 47G3B1 · S.Lak Tahoe, CANTSB SEA68A0012Accident · No injuriesClosedBell 47G-3B · Augusta, MTNTSB OAK68A0010Accident · No injuriesClosedBell 47G-3B · Clearlake, CANTSB LAX68F0086Accident · No injuriesClosedBell 47G3B1 · Marana, AZNTSB SEA68A0010Accident · 1 fatalClosedBell 47G3B1 · Rufus, ORNTSB SEA68A0021Accident · No injuriesClosedBell 47G3B1 · West Glacier, MTNTSB DEN68A0006Accident · No injuriesClosedBell 47G3B1 · Leadville, CONTSB DEN68A0002Accident · No injuriesClosedBell 47G3B1 · Winston, NMNTSB LAX67A0118Accident · No injuriesClosedBell 47G3B1 · Van Nuys, CANTSB DEN67A0052Accident · Minor injuriesClosedBell 47G3B1 · Cody, WYNTSB LAX67A0083Accident · Serious injuriesClosedBell 47G3B1 · Kingman, AZNTSB DEN67A0049Accident · Serious injuriesClosedBell 47G3B1 · Estes Park, CONTSB DEN67A0048Accident · No injuriesClosedBell 47G3B1 · Riverton, WYNTSB SEA67A0046Accident · No injuriesClosedBell 47G-3B · Pomeroy, WA