Bell 47G-3B-1
NTSB investigations · 313
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 DEN66A0020Accident · No injuriesClosedBell 47G3B1 · Commerce Cty, CONTSB MKC66A0013Accident · No injuriesClosedBell 47G3B1 · Altura, MNNTSB DEN66A0017Accident · No injuriesClosedBell 47G3B1 · Salida, CONTSB SEA66A0012Accident · No injuriesClosedBell 47G3B1 · Libby, MTNTSB DEN66A0005Accident · No injuriesClosedBell 47G3B1 · Grand Canyon, AZNTSB DEN65A0073Accident · No injuriesClosedBell 47G3B1 · Glenwood Spg, CONTSB SEA65A0059Accident · Minor injuriesClosedBell 47G3B1 · Marblemount, WANTSB LAX65A0071Accident · Minor injuriesClosedBell 47G3B1 · Bishop, CANTSB OAK65A0051Accident · No injuriesClosedBell 47G3B1 · Yreka, CANTSB UNK64X3437Accident · No injuriesClosedBell 47G3B1 · Castries Bwi, São Tomé & PríncipeNTSB UNK64X2453Accident · No injuriesClosedBell 47G3B1 · Bondurant, WYNTSB UNK64X0473Accident · 1 fatalClosedBell 47G3B1 · Little Nway, CANTSB UNK64X0270Accident · No injuriesClosedBell 47G3B1 · Shell Beachf, CA
Back to Bell 47G-3B-1