NTSB investigations: Bell 47G, 1990
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\") = 1990
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") = 1990
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 FTW91LA007Accident · No injuriesLimited investigationFinal reportBell 47G · Grand Prairie, TXThe pilot's inadequate compensation for the existing tailwind conditions and his failure to maintain rotor RPM.NTSB LAX90LA164Accident · Minor injuriesLimited investigationFinal reportBell 47G · Riverside, CAThe pilot's failure to maintain control of the helicopter. A factor related to the accident was: the pilot's lack of experience in the type of aircraft.NTSB MIA90LA077Accident · Minor injuriesLimited investigationFinal reportBell 47G · Miami, FLInadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The location of trees was a related factor in that the pilot was unable to maintain rotor RPM while attempting to reach a suitable landing area during…