NTSB investigations: Bell 47G-3B-1, 1968
19 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\") = 1968
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") = 1968
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 LAX69D0253Accident · No injuriesClosedBell 47G3B1 · Grand Canyon, AZNTSB SEA69D0122Accident · Minor injuriesClosedBell 47G3B1 · Anaconda, MTNTSB OAK69F0150Accident · Serious injuriesClosedBell 47G3B1 · Chowchilla, CANTSB LAX69F0105Accident · Minor injuriesClosedBell 47G3B1 · Azusa, CANTSB MKC69F0174Accident · Minor injuriesClosedBell 47G3B1 · Custer, SDNTSB ANC69A0009Accident · Serious injuriesClosedBell 47G3B1 · Susitna Lodg, AKNTSB SEA69D0057Accident · No injuriesClosedBell 47G3B1 · Garden Valley, IDNTSB NYC69F0178Accident · 1 fatalClosedBell 47G3B1 · Sipesville, PANTSB LAX69D0079Accident · No injuriesClosedBell 47G3B1 · Peach Spgs, AZNTSB SEA69A0008Accident · 1 fatalClosedBell 47G3B1 · North Fork, IDNTSB SEA68A0074Accident · Minor injuriesClosedBell 47G3B1 · Lewiston, IDNTSB LAX69D0041Accident · No injuriesClosedBell 47G3B1 · Boron, CANTSB DEN69D0043Accident · No injuriesClosedBell 47G3B1 · Loa, UTNTSB LAX69D0033Accident · No injuriesClosedBell 47G3B1 · Alpine, AZNTSB DEN68F0266Accident · No injuriesClosedBell 47G3B1 · Capitan, NMNTSB LAX69F0010Accident · Minor injuriesClosedBell 47G3B1 · Springervill, AZNTSB SEA68D0310Accident · No injuriesClosedBell 47G3B1 · Jackson, MTNTSB DEN68A0050Accident · Minor injuriesClosedBell 47G3B1 · Aspen, CONTSB LAX68A0090Accident · Minor injuriesClosedBell 47G3B1 · Castaic, CA