NTSB investigations: Bell 47G
7 cases on aircraft the registry lists as Bell 47G, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1993 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2005 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181002')
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\" = 220))
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 ('1181002')
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" = 220))
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 DFW05CA235Accident · Serious injuriesData collectionFinal reportBell 47G · Swifton, ARThe pilot's failure to maintain clearance with the power lines. A contributing factor was sun glare.NTSB NYC00LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Coudersport, PAThe pilot's improper preflight planning and decision to attempt a takeoff with the passenger from the confined area.NTSB FTW98FA306Accident · 2 fatalField investigationFinal reportBell 47G · Jones, OKThe pilot's failure to maintain adequate clearance from the trees during a low altitude flight/maneuver.NTSB FTW98FA238Accident · 1 fatalField investigationFinal reportBell 47G · Bixby, OKThe pilot's failure to maintain clearance from the power lines.NTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).NTSB MIA93FA121Accident · 2 fatalField investigationFinal reportBell 47-G · Parker, FLthe misjudgement of the distance by the nonrated pilot-in-command and subsequent collision with a tree. Contributing to the accident was the lack of helicopter experience of the pilot-in-command.NTSB CHI82DA212Accident · No injuriesFinal reportBell 47G-2A · Hudsonville, MIThe pilot was flying a swath run that required him to fly under electric wires near a blacktop county road. As the pilot was coming off the field and passing under the wires, he realized he was on a collision course with a car. He pulled up to avoid the car…