NTSB investigations: Bell 47G-2, 1967
18 cases on aircraft the registry lists as Bell 47G-2. 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 | 21 |
|---|---|
| 1965 | 16 |
| 1966 | 13 |
| 1967 | 18 |
| 1968 | 16 |
| 1969 | 22 |
| 1970 | 20 |
| 1971 | 10 |
| 1972 | 14 |
| 1973 | 19 |
| 1974 | 20 |
| 1975 | 20 |
| 1976 | 10 |
| 1977 | 9 |
| 1978 | 14 |
| 1979 | 12 |
| 1980 | 4 |
| 1981 | 9 |
| 1982 | 11 |
| 1983 | 9 |
| 1984 | 6 |
| 1985 | 10 |
| 1986 | 6 |
| 1987 | 10 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 4 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2022 | 1 |
| 2026 | 2 |
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 ('1181008'))
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 ('1181008'))
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 LAX68A0059Accident · No injuriesClosedBell 47G-2 · Lahabra, CANTSB LAX68A0050Accident · No injuriesClosedBell 47G-2 · Huntington, CANTSB MIA68A0040Accident · No injuriesClosedBell 47G · Davie, FLNTSB FTW68A0028Accident · Serious injuriesClosedBell 47G-2 · Leeville, LANTSB LAX68A0024Accident · No injuriesClosedBell 47G-2 · Hntngtn Bch, CANTSB LAX68A0022Accident · Minor injuriesClosedBell 47G-2 · Camarillo, CANTSB ANC68A0004Accident · 1 fatalClosedBell 47G-2 · Cordova, AKNTSB DIA68A0003Accident · No injuriesClosedBell 47G-2 · Frisco, NCNTSB ANC68A0002Accident · Serious injuriesClosedBell 47G-2 · Beaver, AKNTSB NYC67A0187Accident · No injuriesClosedBell 47G-2 · Bedford, PANTSB MKC67A0078Accident · Serious injuriesClosedBell 47G-2 · West Plains, MONTSB ANC67A0061Accident · Minor injuriesClosedBell 47G-2 · Cold Bay, AKNTSB SEA67A0071Accident · No injuriesClosedBell 47G-2 · Kennewick, WANTSB OAK67A0082Accident · No injuriesClosedBell 47G-2 · King City, CANTSB MIA67A0105Accident · Minor injuriesClosedBell 47G-2 · Foley, ALNTSB SEA67A0057Accident · No injuriesClosedBell 47G-2 · Seattle, WANTSB MIA67A0086Accident · No injuriesClosedBell 47G-2 · Ft.Lauderdale, FLNTSB MIA67A0084Accident · No injuriesClosedBell 47G-2 · Donelson, TN