NTSB investigations: Bell 47G-5, AZ
12 cases on aircraft the registry lists as Bell 47G-5. 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
| 1967 | 1 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1980 | 3 |
| 1981 | 1 |
| 1985 | 1 |
| 1992 | 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\" = 'AZ' 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 ('1181032'))
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" = 'AZ' 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 ('1181032'))
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 LAX92LA278Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Mesa, AZA partial loss of engine power due to unknown reason (s). Factors in this accident were 1) low altitude when the partial loss of power occurred 2) low rotor RPM as a result of the loss of power, and 3) the pilot not being able to take remedial action due to…NTSB LAX86FUM01Accident · Minor injuriesFinal reportBell 47 G-5 · Yuma, AZThe pilot was hovering after a night takeoff and collided with an electrical power line.NTSB LAX81DUK02Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX81FUJ03Accident · No injuriesClosedBell 47G-5 · Roll, AZNTSB LAX80FUJ83Accident · Minor injuriesClosedBell 47G-5 · Sommerton, AZNTSB LAX80DUJ43Accident · No injuriesClosedBell 47G5 · Somerton, AZNTSB LAX79DUJ18Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX74DUJ49Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX74DUJ05Accident · No injuriesClosedBell 47G-5 · Yuma, AZNTSB LAX73FUJ11Accident · No injuriesClosedBell 47-G5 · Chandler, AZNTSB LAX71FUJ40Accident · Serious injuriesClosedBell 47G-5 · El Mirage, AZNTSB LAX68A0003Accident · Minor injuriesClosedBell 47G-5 · Casa Grande, AZ