NTSB investigations: Bell 47G-3B, CA
14 cases on aircraft the registry lists as Bell 47G-3B. 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
| 1964 | 1 |
|---|---|
| 1966 | 3 |
| 1967 | 3 |
| 1971 | 2 |
| 1972 | 1 |
| 1974 | 2 |
| 1978 | 1 |
| 1995 | 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\" = 'CA' 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 ('1181026'))
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" = 'CA' 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 ('1181026'))
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 LAX95LA100Accident · No injuriesLimited investigationFinal reportBell 47G-3B · China Lake, CAthe pilot's misjudgement of the clearance between the main rotor and a tree while maneuvering at low altitude to herd animals.NTSB OAK78DVG65Accident · No injuriesClosedBell 47G-3B · Angwin, CANTSB LAX74AL084Accident · 2 fatalClosedBell 47G-3B · La Crescnta, CANTSB OAK74AP059Accident · Serious injuriesClosedBell 47G3B1 · Lone Pine, CANTSB OAK73DVW12Accident · No injuriesClosedBell 47G3B1 · Bishop, CANTSB OAK72FVD11Accident · No injuriesClosedBell 47G3B · Brentwood, CANTSB LAX71FUG57Accident · Minor injuriesClosedBell 47G3B · La Verne, CANTSB OAK68A0012Accident · No injuriesClosedBell 47G3B · Big Meadows, CANTSB OAK67A0090Accident · No injuriesClosedBell 47G-3B · Castella, CANTSB LAX67A0076Accident · Minor injuriesClosedBell 47G-3B · Santa Ana, CANTSB OAK67A0034Accident · No injuriesClosedBell 47G-3B · San Rafael, CANTSB LAX67A0029Accident · No injuriesClosedBell 47G3B · Vincent, CANTSB OAK66A0033Accident · No injuriesClosedBell 47G-3B · Antioch, CANTSB UNK64X2503Accident · No injuriesClosedBell 47G3B · Tujunga, CA