NTSB investigations: Bell 47G-2A
7 cases on aircraft the registry lists as Bell 47G-2A, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 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 ('1181012')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('1181012')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN16LA161Accident · Serious injuriesLimited investigationFinal reportBell 47G-2A · Los Fresnos, TXThe pilot's inability to see and avoid the power lines because of trees obscuring his view.NTSB WPR15LA116Accident · Serious injuriesLimited investigationFinal reportBell 47G 2A · Ivanhoe, CAThe pilot’s failure to maintain clearance from a power line while maneuvering at low altitude.NTSB WPR14CA296Accident · Serious injuriesData collectionFinal reportBell 47G 2A · Merced, CAThe pilot's failure to adequately monitor the environment to maintain clearance from the power pole guide wire during low level maneuvering.NTSB CEN12CA484Accident · Serious injuriesData collectionFinal reportBell 47G-2A · Austin, INThe pilot did not maintain clearance from terrain during a low-level aerial application flight and lost control of the helicopter.NTSB CEN12LA480Accident · Minor injuriesLimited investigationFinal reportScotts-Bell 47 47G-2A · Akeley, MNThe pilot’s failure to maintain helicopter control during low altitude agricultural operations.NTSB CEN11CA525Accident · No injuriesData collectionFinal reportBell 47G-2A · Nicolett, MNThe pilot's failure to maintain control of the helicopter while maneuvering during an aerial application flight.NTSB CEN09CA517Accident · No injuriesData collectionFinal reportBell 47G-2A · Covert, MIA loss of engine power due to fuel starvation as a result of blocked fuel vents.