NTSB investigations: Bell 47G, TX

9 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19732026

NTSB investigations: Bell 47G, TX per year, 1973–2026: 9 cases
1973	2
1976	1
1978	1
1979	1
1982	1
1986	1
1990	1
2026	1

Where

Open the map

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' 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

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 c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
  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

Run 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 WPR26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportBell 47G · Springtown, TXThe pilot’s failure to maintain clearance from trees while in a low hover.Jul 3, 2026 · N7985A · Substantial damage 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.Oct 20, 1990 · N1071Z · Substantial damage NTSB FTW86LA043Accident · No injuriesLimited investigationFinal reportBell 47G · Beaumont, TXThe pilot was taking off from an area which was protected from the wind by a large building. After obtaining translational lift and climbing above the building, a right quartering tail wind, with gusts to 20 knots, was encountered. The pilot stated he lost…Mar 18, 1986 · N2275B · Substantial damage NTSB FTW82DA073Accident · No injuriesFinal reportBell 47G · Dallas, TXThe pilot attempted to land on a narrow flatbed trailer. He stated that he encountered some buffeting from the wind funneling between two hangars. On his third attempt to position the helicopter on the trailer, the right skid slipped off. The main rotor…Feb 28, 1982 · N1773 · Substantial damage NTSB FTW79DRG35Accident · No injuriesClosedBell 47G · Spofford, TXMay 30, 1979 · N3740G · Substantial damage NTSB FTW78FA032Accident · 1 fatalClosedBell 47G · Eola, TXMar 15, 1978 · N967B · Destroyed NTSB FTW77FRG02Accident · Serious injuriesClosedBell 47G · Kerrville, TXOct 12, 1976 · N2772 · Destroyed NTSB FTW73DRG66Accident · No injuriesClosedBell 47G · San Antonio, TXApr 4, 1973 · N2772 · Substantial damage NTSB FTW73DRG50Accident · No injuriesClosedBell 47G · Robstown, TXFeb 10, 1973 · N3740G · Substantial damage