NTSB investigations: Bell 47G-2
9 cases on aircraft the registry lists as Bell 47G-2, where the first occurrence was “Loss of control - in flight”. 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
| 1983 | 2 |
|---|---|
| 1984 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1995 | 1 |
| 2006 | 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 ('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\" = 250))
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" = 250))
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 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.NTSB LAX95LA214Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Nipomo, CAthe pilot's improper handling of the helicopter by her failure to maintain an adequate airspeed for the attempted maneuver resulting in an uncontrolled descent and subsequent collision with the ground.NTSB LAX90LA042Accident · Minor injuriesLimited investigationFinal reportBell 47G-II · Rialto, CAThe pilot's loss of directional control and subsequent overcontrol while hovering. Contributing to the accident were the gusty wind conditions and the pilot's inexperience.NTSB SEA88LA014Accident · No injuriesLimited investigationFinal reportBell 47G2 · Lebanon, ORThe student was performing an autorotation at about 50' AGL and the flare was begun. The instructor pilot noticed that the helicopter was not leveling and took control of the aircraft. The helicopter settled tail low onto the soft ground striking the tail…NTSB SEA87LA172Accident · Serious injuriesLimited investigationFinal reportBell 47G2 · Grandview, WAAfter the completion of spray operations the pilot was attempting to place the helicopter onto a trailer. The pilot misjudged his position, over-corrected, and then lost control of the helicopter, striking the ground.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 LAX84LA366Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Concord, CAAccording to a plt/operator statement, the student plt was cleared for a downwind apch to land on 'pad 3.' The student stated that the apch was normal until he slowed to 40 mph & 'made left turn to final approach into a cross wind.' During the turn to final…NTSB ATL83LA291Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Cumberland, KYThe plt was conducting local sightseeing flts from a school parking lot. The lot was about 75 yds by 35 yds. On the sidenear a highway there is a six-foot chain link fence the plt had to clear during each takeoff. After boarding the pax theplt hovered…NTSB CHI83LA295Accident · No injuriesLimited investigationFinal reportBell 47G2 · Thomasville, ILThe helicopter tail rotor struck the ground during landing. The helicopter was engaged in aerial application and was returning to reload. The plt reported that at touchdown a gust of wind caused the tail rotor to hit the ground. Decatur winds were reported as…