NTSB investigations: Bell 47G-2, 1975
20 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\") = 1975
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") = 1975
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 OAK76DVM20Accident · No injuriesClosedBell 47G-2 · Salinas, CANTSB CHI76FCA03Accident · No injuriesClosedBell 47G2 · Sauget, ILNTSB MIA76FKQ19Accident · No injuriesClosedBell 47G2 · Sumner, MSNTSB IAD76II014Incident · No injuriesClosedBell 47G-2 · Pigeon Forge, TNNTSB ANC75AA029Accident · No injuriesClosedBell 47G-2 · Hurricane, AKNTSB MIA76FLG13Accident · Minor injuriesClosedBell 47G-2 · Elliott, SCNTSB MIA76FKQ07Accident · Serious injuriesClosedBell 47G-2 · Itta Bena, MSNTSB LAX76FUQQ5Accident · No injuriesClosedBell 47G-2 · Valencia, CANTSB NYC76DHJ01Accident · No injuriesClosedBell 47G-2 · Orient Point, NYNTSB OAK76FVG02Accident · 1 fatalClosedBell 47G-2 · Napa, CANTSB SEA76DYG01Accident · Minor injuriesClosedBell 47G-2 · Moses Lake, WANTSB CHI75FEK32Accident · No injuriesClosedBell 47G2 · Paulding, OHNTSB MKC75DER73Accident · No injuriesClosedBell 47G2 · Rosemount, MNNTSB SEA75DYC40Accident · Serious injuriesClosedBell 47G-2A · Corvallis, ORNTSB FTW75DPG68Accident · Minor injuriesClosedBell 47G-2 · Denmark, ARNTSB SEA75DYG39Accident · No injuriesClosedBell 47G-2 · Mesa, WANTSB CHI75FEA21Accident · No injuriesClosedTownsend 47G2 · Earl Park, INNTSB ANC75AAG87Accident · No injuriesClosedBell 47G-2 · Anchorage, AKNTSB NYC75FEV23Accident · No injuriesClosedBell 47G-2 · Eddyville, ILNTSB LAX75DUQ22Accident · No injuriesClosedBell 47G-2 · Arroyo Grande, CA