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 LAX72FUM19Accident · Minor injuriesClosedBell 47G3B1 · Brawley, CANTSB DEN72FQD18Accident · No injuriesClosedBell 47G3B1 · Hollomn Afb, NMNTSB DEN72AD011Accident · No injuriesClosedBell 47G3B1 · Sandy, UTNTSB DEN72FQD08Accident · No injuriesClosedBell 47G3B1 · Ruidoso, NMNTSB DEN72DTE19Accident · No injuriesClosedBell 47G3B1 · Minturn, CONTSB SEA72DYC08Accident · No injuriesClosedBell 47G3B1 · Legrande, ORNTSB UNK71X0109Accident · No injuriesClosedBell 47G-4A · Angola, AngolaNTSB LAX71FUQ89Accident · No injuriesClosedBell 47G3B1 · Pacoima, CANTSB SEA71FYC38Accident · No injuriesClosedBell 47G-3B · Elgin, ORNTSB SEA71DVQ16Accident · No injuriesClosedBell 47G-2 · Sixes, ORNTSB LAX71AL033Accident · 1 fatalClosedBell 47G3B1 · Rim Forest, CANTSB OAK71DVA40Accident · No injuriesClosedBell 47G3B1 · Grant Cove, CANTSB SEA71FWG15Accident · Minor injuriesClosedBell 47G3B1 · Colville, WANTSB OAK71DVA19Accident · No injuriesClosedBell 47G3B1 · Kernville, CANTSB SEA71DWD09Accident · Minor injuriesClosedBell 47G3B1 · Diablo, WANTSB LAX71DUJ06Accident · No injuriesClosedBell 47G3B1 · Elfrida, AZNTSB SEA71DXM01Accident · No injuriesClosedBell 47G-3B · Hailey, IDNTSB LAX70FUG50Accident · No injuriesClosedBell 47G-3B · Idyllwild, CANTSB OAK70FXQ12Accident · No injuriesClosedBell 47G3B1 · Reno, NVNTSB SEA70DWA14Accident · No injuriesClosedBell 47G3B1 · Cove, ORNTSB OAK70F0212Accident · 1 fatalClosedBell 47G3B1 · Hamiltn Afb, CANTSB OAK70D0160Accident · No injuriesClosedBell 47G3B1 · Bishop, CANTSB OAK70D0068Accident · No injuriesClosedBell 47G3B1 · Bishop, CANTSB MKC70I0081Incident · No injuriesClosedBell 47G3B1 · Hill City, SDNTSB LAX70A0008Accident · 3 fatalClosedBell 47G3B1 · Grnd Canyon, AZNTSB CAN70A4457Accident · 3 fatalClosedBell 47G3B1 · Hope, CanadaNTSB OAK70A0008Accident · Serious injuriesClosedBell 47G-3B · Willow Crek, CANTSB OAK70F0086Accident · Minor injuriesClosedBell 47G3B1 · Stirling Cy, CANTSB LAX70F0070Accident · No injuriesClosedBell 47G3B1 · Siera Madre, CANTSB DEN70F0008Accident · Serious injuriesClosedBell 47G3B1 · Broomfield, CONTSB LAX69D0357Accident · No injuriesClosedBell 47G3B1 · Grnd Canyon, AZNTSB OAK69F0318Accident · No injuriesClosedBell 47G3B1 · Las Vegas, NVNTSB DEN70F0019Accident · Serious injuriesClosedBell 47G3B1 · Idaho Spring, CONTSB OAK69D0286Accident · No injuriesClosedBell 47G3B1 · Stockton, CANTSB DEN69D0213Accident · Minor injuriesClosedBell 47G3B1 · Albany, WYNTSB DEN69F0190Accident · No injuriesClosedBell 47G3B1 · Tularosa, NMNTSB MIA69F0313Accident · No injuriesClosedBell 47G · Jackson, MSNTSB LAX69D0253Accident · No injuriesClosedBell 47G3B1 · Grand Canyon, AZNTSB SEA69D0122Accident · Minor injuriesClosedBell 47G3B1 · Anaconda, MTNTSB OAK69F0150Accident · Serious injuriesClosedBell 47G3B1 · Chowchilla, CANTSB LAX69F0105Accident · Minor injuriesClosedBell 47G3B1 · Azusa, CANTSB MKC69F0174Accident · Minor injuriesClosedBell 47G3B1 · Custer, SDNTSB ANC69A0009Accident · Serious injuriesClosedBell 47G3B1 · Susitna Lodg, AKNTSB SEA69D0057Accident · No injuriesClosedBell 47G3B1 · Garden Valley, IDNTSB NYC69F0178Accident · 1 fatalClosedBell 47G3B1 · Sipesville, PANTSB LAX69D0079Accident · No injuriesClosedBell 47G3B1 · Peach Spgs, AZNTSB SEA69A0008Accident · 1 fatalClosedBell 47G3B1 · North Fork, IDNTSB SEA68A0074Accident · Minor injuriesClosedBell 47G3B1 · Lewiston, IDNTSB LAX69D0041Accident · No injuriesClosedBell 47G3B1 · Boron, CANTSB DEN69D0043Accident · No injuriesClosedBell 47G3B1 · Loa, UT
Back to Bell 47G-3B-1