NTSB investigations: Bell 47G-5, 1973
19 cases on aircraft the registry lists as Bell 47G-5. 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
| 1966 | 6 |
|---|---|
| 1967 | 8 |
| 1968 | 9 |
| 1969 | 5 |
| 1970 | 9 |
| 1971 | 6 |
| 1972 | 11 |
| 1973 | 19 |
| 1974 | 13 |
| 1975 | 6 |
| 1976 | 8 |
| 1977 | 2 |
| 1978 | 7 |
| 1979 | 2 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 5 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 3 |
| 1996 | 5 |
| 1998 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 3 |
| 2004 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 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\") = 1973
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
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") = 1973
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
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 LAX74DUG31Accident · No injuriesClosedBell 47G-5 · La Verne, CANTSB NYC74AN035Accident · 2 fatalClosedBell 47G-5 · Waynesburg, PANTSB MKC74FCA12Accident · No injuriesClosedBell 47G-5 · Creve Coeur, MONTSB OAK74DVA22Accident · No injuriesClosedBell 47G-5 · Fresno, CANTSB CHI74FEG08Accident · No injuriesClosedBell 47-G5 · Washingtn Ch, OHNTSB OAK74FVM08Accident · Minor injuriesClosedBell 47G-5 · Santa Clara, CANTSB IAD74FIG06Accident · Minor injuriesClosedBell 47G-5 · Berlin, MDNTSB LAX74DUJ05Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB MKC74DER01Accident · No injuriesClosedBell 47G-5 · Bloomington, MNNTSB DEN74FQA03Accident · No injuriesClosedBell 47G5 · Albuquerque, NMNTSB MKC73FCA30Accident · Minor injuriesClosedBell 47G-5 · St Louis, MONTSB CHI73DEP66Accident · Minor injuriesClosedBell 47G-5 · Appleton, WINTSB MIA73DLA46Accident · No injuriesClosedBell 47G-5 · Newberry, FLNTSB IAD73FKM43Accident · Serious injuriesClosedBell 47G5 · Charlotte, NCNTSB FTW73DPD41Accident · No injuriesClosedBell 47G-5 · Gainesville, TXNTSB OAK73FJA12Accident · Serious injuriesClosedBell 47G-5 · Koloa, HINTSB FTW73DRG47Accident · No injuriesClosedBell 47G-5 · Harlingen, TXNTSB MIA73DLD54Accident · No injuriesClosedBell 47G-5 · Avon Park, FLNTSB FTW73FPA20Accident · No injuriesClosedBell 47G-5 · Dallas, TX