NTSB investigations: Bell 47G-2, OH
8 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.
Cases per year
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 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 c.\"eventStateOrRegion\" = 'OH' 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" = 'OH' 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" 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 ATL87DEI05Accident · Minor injuriesFinal reportBell 47G-2 · Lisbon, OHThe helicopter rolled over as it was lifting off from a transport trailer. A post-crash exam revealed that the left rear tie-down strap on the trailer was wrapped around one of the helicopter skids. The ground crewman believed he had removed all of the straps…NTSB ATL86FEI07Accident · 1 fatalFinal reportBell 47G2 · Lisbon, OHThe aerial application helicopter was being serviced by a chemical truck that was parked adjacent to the acft. The acft engine was at high idle with the main rotor turning at 250 RPM. The ground crewman jumped off the side of the chemical truck into the main…NTSB CHI84LA317Accident · No injuriesLimited investigationFinal reportBell 47-G2 · Jeffersonville, OHThe acft started to settle with power during takeoff after the acft was loaded with chemicals. The plt said he had a choice of, going through a fence or over it and decided to go over it. Pulling collective bled off m/r and the acft stopped flying. The tail…NTSB CHI79DEG13Accident · Minor injuriesClosedBell 47G-2 · Piqua, OHNTSB CHI75FEK32Accident · No injuriesClosedBell 47G2 · Paulding, OHNTSB CHI73FEK10Accident · No injuriesClosedBell 47G-2 · Zanesville, OHNTSB CHI70F0264Accident · No injuriesClosedBell 47G-2 · Gallipolis, OHNTSB CHI68A0062Accident · Serious injuriesClosedBell 47G-2 · Delta, OH