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 LAX69D0033Accident · No injuriesClosedBell 47G3B1 · Alpine, AZNTSB DEN68F0266Accident · No injuriesClosedBell 47G3B1 · Capitan, NMNTSB LAX69F0010Accident · Minor injuriesClosedBell 47G3B1 · Springervill, AZNTSB SEA68D0310Accident · No injuriesClosedBell 47G3B1 · Jackson, MTNTSB DEN68A0050Accident · Minor injuriesClosedBell 47G3B1 · Aspen, CONTSB LAX68A0090Accident · Minor injuriesClosedBell 47G3B1 · Castaic, CANTSB DEN68A0020Accident · Minor injuriesClosedBell 47G-3B · Silverthorne, CONTSB SEA68A0033Accident · No injuriesClosedBell 47G3B1 · Snoqualmie P, WANTSB DEN68A0019Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMNTSB UNK67X0157Accident · No injuriesClosedBell 47G3B1 · Dhahran, Saudi ArabiaNTSB OAK68A0028Accident · Minor injuriesClosedBell 47G3B1 · S.Lak Tahoe, CANTSB SEA68A0012Accident · No injuriesClosedBell 47G-3B · Augusta, MTNTSB OAK68A0010Accident · No injuriesClosedBell 47G-3B · Clearlake, CANTSB LAX68F0086Accident · No injuriesClosedBell 47G3B1 · Marana, AZNTSB SEA68A0010Accident · 1 fatalClosedBell 47G3B1 · Rufus, ORNTSB SEA68A0021Accident · No injuriesClosedBell 47G3B1 · West Glacier, MTNTSB DEN68A0006Accident · No injuriesClosedBell 47G3B1 · Leadville, CONTSB DEN68A0002Accident · No injuriesClosedBell 47G3B1 · Winston, NMNTSB LAX67A0118Accident · No injuriesClosedBell 47G3B1 · Van Nuys, CANTSB DEN67A0052Accident · Minor injuriesClosedBell 47G3B1 · Cody, WYNTSB LAX67A0083Accident · Serious injuriesClosedBell 47G3B1 · Kingman, AZNTSB DEN67A0049Accident · Serious injuriesClosedBell 47G3B1 · Estes Park, CONTSB DEN67A0048Accident · No injuriesClosedBell 47G3B1 · Riverton, WYNTSB SEA67A0046Accident · No injuriesClosedBell 47G-3B · Pomeroy, WANTSB DEN67A0037Accident · Minor injuriesClosedBell 47G3B1 · Holloman Ab, NMNTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORNTSB SEA67A0036Accident · No injuriesClosedBell 47G3B1 · Cle Elum, WANTSB UNK67X0101Accident · No injuriesClosedBell 47G3B1 · Manta, EcuadorNTSB UNK67X0100Accident · 2 fatalClosedBell 47G3B1 · Janakpur, NepalNTSB SEA67A0027Accident · 2 fatalClosedBell 47G3B1 · W.Yellowston, MTNTSB DEN67A0024Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMNTSB DEN67A0021Accident · Serious injuriesClosedBell 47G3B1 · Old Faithful, WYNTSB FTW67A0030Accident · No injuriesClosedBell 47G3B1 · Yukon, OKNTSB UNK66X0166Accident · 1 fatalClosedBell 47G-3B · Rahgird, IranNTSB NYC67A0033Accident · No injuriesClosedBell 47G3B1 · Great Meadows, NJNTSB OAK67A0023Accident · No injuriesClosedBell 47G3B1 · Bridgeport, CANTSB OAK67A0022Accident · Serious injuriesClosedBell 47G3B1 · Bishop, CANTSB DEN67A0007Accident · Serious injuriesClosedBell 47G3B1 · Riverton, WYNTSB SEA67A0002Accident · Serious injuriesClosedBell 47-G3B · Clinton, MTNTSB LAX66A0004Accident · Serious injuriesClosedBell 47G-3B · Grand Canyon, AZNTSB SEA66A0072Accident · Minor injuriesClosedBell 47G3B1 · Livingston, MTNTSB LAX66A0102Accident · No injuriesClosedBell 47G-3B · Alpine, AZNTSB LAX66A0097Accident · Minor injuriesClosedBell 47G3B1 · Glendora, CANTSB DEN66A0081Accident · Serious injuriesClosedBell 47G3B1 · Aspen, CONTSB DEN66A0074Accident · 1 fatalClosedBell 47G-3B · Grand Canyon, AZNTSB MIA66A0108Accident · Minor injuriesClosedBell 47G3B1 · Fredericksted, VINTSB DEN66A0051Accident · No injuriesClosedBell 47G3B1 · Mesa, AZNTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTNTSB DEN66A0024Accident · Minor injuriesClosedBell 47G3B1 · Jackson, WYNTSB DEN66A0023Accident · 1 fatalClosedBell 47G3B1 · Monticello, UT
Back to Bell 47G-3B-1