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 ('1181104')
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 ('1181104')
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 MIA92FA156Accident · 4 fatalField investigationFinal reportBell 47J2 · Adjuntas, PRThe failure of the pilot-in-command to maintain adequate rotor RPM during a precautionary landing following the loss of engine oil. In addition, the pilot failed to insure that the engine contained adequate oil, and that the oil dip stick was secure prior to…NTSB ATL91FA013Accident · Serious injuriesField investigationFinal reportBell 47J-2 · Gatlinburg, TNThe accident was inadequate maintenance of the helicopter, allowing a tail rotor drive shaft bearing to exceed wear limits. This resulted in high loads on the tail rotor drive shaft, and the resulting fatigue failure of the drive shaft.NTSB NYC88LA170Accident · Serious injuriesLimited investigationFinal reportBell 47J2 · Newburyport, MAThe helicopter departed runway 10 at plum island airport, turned left over the plum island river and shortly thereafter the engine quit. The pilot stated that no warning was noted and a check of the instruments indicated no problems. He further stated that…NTSB MIA88LA018Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Key Colony Bch., FLThe plt stated that he did not check the fuel system for contaminates after refueling but an eighteen minute flt after refueling was uneventful. He then landed the helicopter, remained on the ground aprx 20 minutes, performed a walk around insp, again without…NTSB DEN87LA204Accident · No injuriesLimited investigationFinal reportBell 47J-2 · Canon City, COThe ATP plt was flying sightseeing rides. There were two adults and two children in the four passenger helicopter. Density altitude was 10000 feet. The acft lost pwr and the plt aborted takeoff and landed. After an eng runup the plt took off again and the…NTSB LAX84FA130Accident · 1 fatalField investigationFinal reportBell 47J-2 · Kahuku, HIAbout 3 min after takeoff, the helicopter was observed descending in a 'gliding fashion' until water impact. A witness reported that it appeared to be flying straight & did not appear to be in trouble. The witness reported that she could hear the eng & it…NTSB MKC82DA135Accident · No injuriesFinal reportBell 47J-2 · Chesterfield, MOThe pilot stated that he took off and was going through translational lift at about 15 to 20 ft AGL when he heard a loud bang. He said the loud bang was accompanied by a power loss. An immediate descent was made and the helicopter was landed hard with a…NTSB MKC81FCG36Accident · No injuriesClosedBell 47J-2 · Branson, MONTSB CHI80FA055Accident · No injuriesClosedBell 47J2 · Cleveland, OHNTSB LAX79FA081Accident · 5 fatalClosedBell 47J-2 · Long Beach, CANTSB CHI79FEX25Accident · No injuriesClosedBell 47J2 · Westfield, INNTSB MKC79FCA02Accident · No injuriesClosedBell 47J-2 · St Louis, MONTSB MKC78FTK40Accident · No injuriesClosedBell 47-J2 · Cactus Flats, SDNTSB MKC78DCD34Accident · No injuriesClosedBell 47J-2 · Burlington, IANTSB MKC78FCQ26Accident · Minor injuriesClosedBell 47J-2 · Onaga, KSNTSB LAX78FA008Accident · 2 fatalClosedBell 47J-2 · Burbank, CANTSB FTW76AF097Accident · Minor injuriesClosedBell 47J-2 · Baton Rouge, LANTSB MIA76FKG60Accident · No injuriesClosedBell 47G · Stockbridge, GANTSB NYC76FHJ34Accident · Minor injuriesClosedBell 47J · New York, NYNTSB NYC76AN044Accident · No injuriesClosedBell 47J-2 · Conshocken, PANTSB MIA75AM034Accident · 1 fatalClosedBell 47J-2 · Daytona Beach, FLNTSB MIA74FKQ01Accident · Serious injuriesClosedBell 47J-2 · Edwards, MSNTSB NYC74DFJ12Accident · Minor injuriesClosedBell 47J-2 · Niagara Falls, NYNTSB SEA74FYG08Accident · Serious injuriesClosedBell 47J-2A · Inchelium, WANTSB FTW73DRD13Accident · Minor injuriesClosedBell 47J-2 · Gulf Of Mexico (Gulf of Mexico)NTSB LAX73FUA12Accident · No injuriesClosedBell 47J-2 · Huntgtn Bch, CANTSB OAK72FJY15Accident · Serious injuriesClosedBell 47J-2 · Piti Village, GUNTSB NYC72AN130Accident · 3 fatalClosedBell 47J-2 · New York, NYNTSB LAX72FUA02Accident · No injuriesClosedBell 47J-2 · Hntngtn Bch, CANTSB NYC71ANI12Accident · No injuriesClosedBell 47J2 · New York, NYNTSB LAX71FVQ74Accident · Minor injuriesClosedBell 47J2 · Sta Barbara, CANTSB CHI70FDW23Accident · No injuriesClosedBell 47-J2 · Union Lake, MINTSB NYC70AN115Accident · No injuriesClosedBell 47J-2 · Piscataway, NJNTSB LAX70DUA17Accident · No injuriesClosedBell 47J-2 · Long Beach, CANTSB ANC70AA055Accident · 2 fatalClosedBell 47J-2 · Healy, AKNTSB LAX70A0031Accident · No injuriesClosedBell 47J · Goleta, CANTSB ANC70D0079Accident · Minor injuriesClosedBell 47J-2 · Iliamna, AKNTSB ANC70A0035Accident · 1 fatalClosedBell 47J-2 · Fairbanks, AKNTSB DEN70F0100Accident · No injuriesClosedBell 47J2B · Santa Fe, NMNTSB DEN70D0146Accident · No injuriesClosedBell 47J-2A · Montrose, CONTSB ANC69D0082Accident · No injuriesClosedBell 47J-2 · Barrow, AKNTSB ANC69A0023Accident · 1 fatalClosedBell 47J-2 · Prudhoe Bay, AKNTSB ANC69A0022Accident · Minor injuriesClosedBell 47J-2 · Point Barrow, AKNTSB LAX69A0011Accident · No injuriesClosedBell 47J-2 · Los Angeles, CANTSB CHI68A0107Accident · 1 fatalClosedBell 47J-2 · Rice Lake, WINTSB NYC68A0082Accident · 2 fatalClosedBell 47J-2 · New York City, NYNTSB MIA67A0102Accident · Minor injuriesClosedBell 47J-2 · Starke, FLNTSB LAX67A0044Accident · 4 fatalClosedBell 47J-2 · Carpenter, CANTSB NYC67A0067Accident · No injuriesClosedBell 47J-2 · Brookline, MANTSB NYC67A0030Accident · No injuriesClosedBell 47J-2 · Dedham, MA
Back to Bell 47J-2