NTSB investigations: Bell 47G, 1987
3 cases on aircraft the registry lists as Bell 47G. 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 | 12 |
|---|---|
| 1965 | 4 |
| 1966 | 10 |
| 1967 | 7 |
| 1968 | 6 |
| 1969 | 9 |
| 1970 | 4 |
| 1971 | 6 |
| 1972 | 8 |
| 1973 | 9 |
| 1974 | 9 |
| 1975 | 7 |
| 1976 | 8 |
| 1977 | 3 |
| 1978 | 9 |
| 1979 | 4 |
| 1980 | 5 |
| 1981 | 1 |
| 1982 | 5 |
| 1983 | 4 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2014 | 2 |
| 2016 | 1 |
| 2022 | 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 ('1181002'))
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 ('1181002'))
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 ATL87LA229Accident · Minor injuriesLimited investigationFinal reportBell 47G (TOM CAT) · Dothan, ALThe plt rprtd that while he was making a turn-around over trees after the 1st swath run, the helicopter enctrd a sudden wind change. He stated that the wind cond was from a cumulus buildup which put him in a tailwind situation. As he completed his turn with…NTSB NYC87LA210Accident · Minor injuriesLimited investigationFinal reportBell 47G3 · Marston Mills, MAThe helicopter reached an altitude of about 50 feet when a loss of power was experienced. Immediately the pilot set up for an emergency landing and set the helicopter down. The aircraft, however, collided with the ground hard and incurred substantial damage.…NTSB NYC87FA114Accident · 2 fatalField investigationFinal reportBell 47G · Wassaic, NYThe Bell 47G helicopter was on a aerial survey of buried telephone cable when the red main rotor blade separated from the blade grips in flight. The main rotor hub with the main rotor blade separated from the transmission and the helicopter crashed. No…