NTSB investigations: Bell 47G-3B-1, UT
16 cases on aircraft the registry lists as Bell 47G-3B-1. 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
| 1965 | 2 |
|---|---|
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1996 | 1 |
| 1997 | 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\" = 'UT' 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 ('1181028', '118103A'))
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" = 'UT' 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 ('1181028', '118103A'))
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 SEA97LA158Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Roosevelt, UTthe pilot's failure to maintain directional control. Wind gusts were a factor.NTSB SEA97TA023Accident · 1 fatalFinal reportBell 47G-3B-1 · Fillmore, UTinadequate procedure and inadequate monitoring by the pilot, the operator, and/or other personnel, which allowed one of three external cables to the seed bucket to become entangled with the right skid of the helicopter, resulting in an imbalance and loss of…NTSB DEN87LA019Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Goshen, UTThe plt was practicing power recovery autorotations then attempted one power off, full stop. The plt allowed the main rotor RPM to decay during approach and took no corrective action. The acft landed hard with slight forward motion and the plt applied aft…NTSB DEN84LA079Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Ogden, UTThe plt took off from a mountainous work site to return to salt lake city, UT. The wx was clear at the work site (elevation 6700 ft), but there was fog below. After encountering the fog, the plt hovered with a slow forward speed over snow covered terrain. A…NTSB DEN82FTM11Accident · Serious injuriesFinal reportBell 47G-3B-1 · Vermal, UTThe pilot stated that he experienced a partial loss of engine power during landing at an elevation of about 5280 ft MSL. The temperature was about 50 degrees fahrenheit. He applied full throttle, but the RPM decayed and the plane crash landed. A partial…NTSB DEN82FTM02Accident · No injuriesClosedSoloy 47 · Fruitland, UTNTSB DEN80DTM01Accident · No injuriesClosedBell 47G3B1 · Torrey, UTNTSB DEN79DTM24Accident · No injuriesClosedBell 47G3B1 · Beaver, UTNTSB DEN75AD022Accident · Minor injuriesClosedBell 47G3B1 · Vernal, UTNTSB DEN75AD009Accident · 1 fatalClosedBell 47G3B1 · Ogden, UTNTSB DEN73AD039Accident · No injuriesClosedBell 47G3B1 · Salt Lake City, UTNTSB DEN73FTM01Accident · 1 fatalClosedBell 47G3B1 · Ogden, UTNTSB DEN72AD011Accident · No injuriesClosedBell 47G3B1 · Sandy, UTNTSB DEN69D0043Accident · No injuriesClosedBell 47G3B1 · Loa, UTNTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTNTSB DEN66A0023Accident · 1 fatalClosedBell 47G3B1 · Monticello, UT