NTSB investigations: Bell 47G-2, 1974
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
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 ('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") = 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 ('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 SEA75AS022Accident · 1 fatalClosedBell 47G-2 · Kingston, WANTSB CHI75FEM12Accident · Minor injuriesClosedBell 47G-2 · Paw Paw, MINTSB SEA75FYG10Accident · Serious injuriesClosedBell 47G-2 · Quincy, WANTSB SEA75DYG07Accident · No injuriesClosedBell 47G-2 · Royal City, WANTSB SEA75FYE11Accident · Serious injuriesClosedBell 47G-2A · Mercer Isl, WANTSB MKC75DER12Accident · No injuriesClosedBell 47G-2 · Meridan, MNNTSB OAK75FVM04Accident · Serious injuriesClosedBell 47G-2A · Gonzales, CANTSB MIA75FKQ02Accident · Minor injuriesClosedBell 47G-2 · Raleigh, MSNTSB OAK75DVD03Accident · No injuriesClosedBell 47G-2 · Linden, CANTSB SEA74DYG49Accident · No injuriesClosedBell 47G-2 · Ephrata, WANTSB NYC74FHJ31Accident · No injuriesClosedBell 47G-2 · Garden City, NYNTSB SEA74DYG38Accident · Minor injuriesClosedBell 47G-2 · Ephrata, WANTSB IAD74FID36Accident · Minor injuriesClosedBell 47G-2 · Norfolk, VANTSB ANC74AA069Accident · Minor injuriesClosedBell 47G-2 · Seward, AKNTSB SEA74DYE42Accident · No injuriesClosedBell 47G-2 · Centralia, WANTSB OAK74FVD22Accident · No injuriesClosedBell 47D1 · Sebastopol, CANTSB MIA74AM079Accident · Serious injuriesClosedBell 47G-2 · Miami, FLNTSB SEA74DYE39Accident · No injuriesClosedBell 47G-2 · Forks, WANTSB SEA74DYC25Accident · No injuriesClosedBell 47G-2 · Spokane, WANTSB LAX74AL057Accident · 2 fatalClosedBell 47D1 · Westminster, CA