NTSB investigations: Bell 47G-2

7 cases on aircraft the registry lists as Bell 47G-2, where the first occurrence was “Hard landing”. 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

19822026

NTSB investigations: Bell 47G-2 per year, 1982–2026: 7 cases
1982	1
1983	1
1985	1
1986	1
1991	1
1993	1
1994	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181008') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181008')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181008')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 CHI94LA133Accident · No injuriesLimited investigationFinal reportBell 47-62 · Aurora, MOThe dual students inadequate flare and the pilot in command's (flight instructor) delayed remedial action.Mar 5, 1994 · N6711D · Substantial damage NTSB LAX93LA209Accident · No injuriesLimited investigationFinal reportBell 47-G2 · AntarcticaThe pilot's poorly planned approach.Apr 28, 1993 · N1437 · Substantial damage NTSB LAX91LA405Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Keaau, HIThe pilot's landing hard. A contributing factor in this accident was the aircraft emitting a vibration from an unknown source.Sep 14, 1991 · N6708D · Substantial damage NTSB NYC86LA203Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Hazleton, PAThe Bell 47G2 made a hard landing in a field. The main rotor contacted the tail rotor and boom. The helicopter received substantial damage and the pilot received minor injuries. On scene examination revealed no evidence of any defect or malfunction of the…Aug 7, 1986 · N7739 · Substantial damage NTSB MIA85LA085Accident · No injuriesLimited investigationFinal reportBell 47-G · Miami, FLThe plt stated the helicopter gained too much forward speed because of gusty winds while he was maneuvering the helicopter to the refueling area. A hard landing resulted as the plt attempted to slow the helicopter to avoid contacting refueling equipment.Jan 28, 1985 · N17271 · Substantial damage NTSB ANC83LA035Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Anchorage, AKThe helicopter made a landing during which the tail boom was severed. This was a dual instructional flight and accordingto the instructor, a high reconnaissance was performed before selecting their approach to the pinnacle. The pinnacle is a 3000 foot landing…Jan 19, 1983 · N2822B · Substantial damage NTSB MIA82DA174Accident · No injuriesFinal reportBell 47G-2 · Miami, FLThe pilot reported that while he was practicing an autorotative landing, he started to flare a bit too high. He stated that the helicopter touched down harder than normal and the main rotor blades flexed downward and swept across the tail boom. Subsequently,…Aug 20, 1982 · N366DJ · Substantial damage