NTSB investigations: Bell 47G-4A, 1987
2 cases on aircraft the registry lists as Bell 47G-4A. 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 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 5 |
| 1969 | 10 |
| 1970 | 4 |
| 1971 | 10 |
| 1972 | 4 |
| 1973 | 7 |
| 1974 | 7 |
| 1975 | 5 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 2 |
| 1979 | 5 |
| 1980 | 3 |
| 1981 | 5 |
| 1982 | 1 |
| 1983 | 5 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2008 | 1 |
| 2010 | 3 |
| 2011 | 1 |
| 2015 | 2 |
| 2019 | 1 |
| 2025 | 1 |
| 2026 | 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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181031'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181031'))
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 DEN87DTG02Accident · No injuriesFinal reportBell 47G-4A · Minot, NDThe plt rprtd that when he took off fm a nrby nurse truck, the wind was fm the NE at 5 to 7 mph. He made an observation pass across the area to be treated, then bgn a dscndg rgt turn to make a swath run in the opposite drctn. He stated he was unaware of a…NTSB LAX87DVD01Accident · Serious injuriesFinal reportBell 47G4A · Stockton, CAJust after takeoff, the engine experienced a power loss while transporting agricultural equipment. A fractographic examination of the failed fuel disconnect fitting by anamet laboratories, concluded that approximately 70% of the retaining ring on the fuel…