Skip to content

NTSB investigations: Bell 47G-2, TX

20 cases on aircraft the registry lists as Bell 47G-2. 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

19642026

Where

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 ('1181008')) 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 ('1181008'))
  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 ('1181008'))
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 GAA19CA250Accident · No injuriesData collectionFinal reportBell 47G · Denton, TXThe flight instructor's improper decision to instruct the student pilot to establish a hover and reposition the helicopter with a tailwind, which resulted in the student pilot's loss of pitch control.May 6, 2019 · N5990 · Substantial damage NTSB CEN09LA324Accident · Serious injuriesLimited investigationFinal reportBell 47G · Kyle, TXThe ground crewmember's failure to assure that the fuel nozzle was closed before pressurizing the line. Contributing to the accident was the lack of an available fire extinguisher.May 30, 2009 · N4823 · Substantial damage NTSB DFW06CA123Accident · Minor injuriesData collectionFinal reportBell 47G-2 · Rosenberg, TXThe pilots encounter with loss of tail rotor effectiveness during an aerial application flight. A contributing factor was the gusty winds.May 10, 2006 · N993B · Substantial damage NTSB FTW04LA198Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · La Porte, TXThe loss of engine power for undetermined reasons.Aug 1, 2004 · N7892B · Destroyed NTSB FTW96LA008Accident · Minor injuriesLimited investigationFinal reportBell 47-G2 · Freer, TXthe pilot's failure to maintain clearance from the power lines due to his improper takeoff technique. A factor was the helicopter induced blowing dust which impaired the pilot's visibility.Oct 5, 1995 · N4423 · Substantial damage NTSB FTW92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Danbury, TXThe failure of the landing gear skid due to internal corrosion. A factor was the soft ground.Jun 14, 1992 · N6746D · Substantial damage NTSB FTW88LA008Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Lapra, TXUpon entering a bank approx. 80 to 100 ft. off the ground, the aircraft experienced a power loss with vibration. During autorotation the aircraft contacted a tree causing substantial damage. Examination of the wreckage found the transmission clutch assembly…Oct 20, 1987 · N8403E · Substantial damage NTSB FTW79FRG10Accident · No injuriesClosedBell 47G-2 · Alamo, TXDec 6, 1978 · N972B · Destroyed NTSB FTW78DRG08Accident · No injuriesClosedBell 47G-2 · Edinburg, TXOct 20, 1977 · N7888B · Substantial damage NTSB FTW76DRG70Accident · No injuriesClosedBell 47G-2 · Mcallen, TXJul 17, 1976 · N38926 · Substantial damage NTSB FTW74FQG36Accident · No injuriesClosedBell 47G-2 · Stratford, TXDec 30, 1973 · N6708D · Substantial damage NTSB FTW74DRG16Accident · No injuriesClosedBell 47G-2 · Harlingen, TXAug 21, 1973 · N17121 · Substantial damage NTSB FTW71DRG55Accident · No injuriesClosedBell 47G-2 · Corpus Chrsti, TXDec 4, 1970 · N4823 · Substantial damage NTSB FTW70FRG32Accident · No injuriesClosedBell 47G-2 · Zapata, TXMar 31, 1970 · N2820B · Substantial damage NTSB FTW70F0204Accident · No injuriesClosedBell 47G-2 · Friendswood, TXSep 4, 1969 · N17120 · Substantial damage NTSB FTW69F0500Accident · Minor injuriesClosedBell 47G-2 · Amarillo, TXMay 2, 1969 · N6744D · Substantial damage NTSB FTW69F0318Accident · No injuriesClosedBell 47G-2 · Watauga, TXDec 19, 1968 · N17121 · Substantial damage NTSB FTW67A0041Accident · No injuriesClosedBell 47G-2 · Prt Mansfield, TXOct 2, 1966 · N13658 · Substantial damage NTSB FTW65A0125Accident · No injuriesClosedBell 47G2 · Rio Grand Cty, TXJun 12, 1965 · N987B · Destroyed NTSB UNK64X2134Accident · No injuriesClosedBell 47G2 · Fort Worth, TXJun 5, 1964 · N2151 · Destroyed