NTSB investigations: Bell 47G-3B-1, NM
15 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
| 1966 | 2 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1988 | 1 |
| 1998 | 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\" = 'NM' 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" = 'NM' 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 FTW98TA099Accident · No injuriesFinal reportBell 47G-3B-1 · Magdalena, NMThe pilot's failure to maintain adequate main rotor rpm. A factor was a lack of recent experience in the type of operation being performed.NTSB DEN88GA088Accident · No injuriesFinal reportBell 47G-3B1 · Gobernador, NMThe commerical plt was hovering out of ground effect at 40 feet AGL. During a maneuver he reported hearing a loud bang and the rotor RPM began to decay. The plt made a hovering autorotation resulting in a hard landing. The main rotor struck the tail boom and…NTSB FTW80FA090Accident · Serious injuriesClosedBell 47G3B1 · Mescalero, NMNTSB DEN80FA005Accident · 1 fatalClosedSoloy 47G · Ruidoso, NMNTSB DEN79FQA37Accident · No injuriesClosedBell 47G · Socorro, NMNTSB DEN76FQD32Accident · No injuriesClosedBell 47G3B1 · Mesquite, NMNTSB DEN76FAQ06Accident · No injuriesClosedBell 47G3B1 · Belen, NMNTSB DEN72FQD18Accident · No injuriesClosedBell 47G3B1 · Hollomn Afb, NMNTSB DEN72FQD08Accident · No injuriesClosedBell 47G3B1 · Ruidoso, NMNTSB DEN69F0190Accident · No injuriesClosedBell 47G3B1 · Tularosa, NMNTSB DEN68F0266Accident · No injuriesClosedBell 47G3B1 · Capitan, NMNTSB DEN68A0019Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMNTSB DEN68A0002Accident · No injuriesClosedBell 47G3B1 · Winston, NMNTSB DEN67A0037Accident · Minor injuriesClosedBell 47G3B1 · Holloman Ab, NMNTSB DEN67A0024Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NM