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 ('1180802')
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 ('1180802')
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 NYC89LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G · Champion, NYThe pilot was unable to sustain flight due to a severe downdraft accompanied by a power loss at a low altitude.NTSB CHI88DEC05Accident · No injuriesFinal reportBell 47D1 (OH-13E) · Stockbridge, MIThe plt was spraying an onion field when he noted a vibration, followed by a loud noise & severe shaking of the helicopter. He attempted a forced landing, but the helicopter was unresponsive to cyclic & collective inputs. Subsequently, the right skid dug into…NTSB MIA88LA212Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ruleville, MSDuring an aerial application flt while spraying chemicals the plt reported that the engine quit. The pilot attempted an autorotation but was too low and slow to complete it. The aircraft landed hard in the field of crops and nosed over. Examination of the…NTSB LAX88LA160Accident · No injuriesLimited investigationFinal reportBell 47D1 · Taft, CANTSB LAX87LA294Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Taft, CAThe plt rprtd the eng lost power at about 300' AGL after the helicopter had flown aprx 2.7 hrs without refueling. He initiated an autorotative landing; however, before touchdown, the main rotor blades contacted & severed the tail boom. An exam revealed the…NTSB ATL87LA204Accident · No injuriesLimited investigationFinal reportBell 47D1 · Huntsville, ALThe aerial application flight was dispensing insecticides on a cotton field. While maneuvering to avoid powerlines during the procedure turnaround following an upwind swath run, the pilot failed to maintain sufficient airspeed to ensure effective…NTSB MIA87LA145Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Rolling Fork, MSWhile landing downwind, at an alt of aprx 20 feet, the helicopter began to settle with power. The pilot then attempted to stop the descent, however, because of insufficient alt & airspeed, was unable. The helicopter then landed hard, rolled over, after which,…NTSB FTW87LA107Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe pilot reportedly heard an unusual noise in the engine and made a precautionary autorotation to landing. Touchdown was on uneven terrain and in a nose low attitude. This resulted in the tail rotor assembly being chopped off the tail boom by the main rotor…NTSB MIA87LA116Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Homosassa, FLThe plt stated that just after takeoff, at about 50 ft, the eng lost power and he made a forced landing in a canal. No determination could be made as to the nature of the malfunction of the engine as described by the pilot.NTSB MIA86LA168Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Panama City Bch, FLThe pilot had intended to hover the helicopter and allow a 'clown' to touch the skids while a photographer recorded the event looking upward to give the appearance that the 'clown' was hanging from the skid. The 'clown' grabbed the left rear skid and the…NTSB MIA85LA214Accident · No injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAThe plt stated that while he was on an aerial application mission, the helicopter ran out of fuel. During an autorotation, the main rotor severed the tail boom.NTSB FTW85LA074Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe acft collided with power lines during a recovery from a practice autorotational landing. The instructor plt took control of the acft for recovery and did not see the wires.NTSB FTW85LA043Accident · No injuriesLimited investigationFinal reportBell 47D1 · Terlingua, TXShortly after the plt took off on a sight-seeing flt, the eng lost power when the helicopter was over rough terrain at about 200 ft AGL. During an autorotative landing, the helicopter rocked forward causing the main rotor blades to strike the tail boom.…NTSB CHI84LA184Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Alpena, MIPrior to the accident, the owner/plt of the helicopter reportedly 'buzzed' a local baseball game. Shortly after that, the helicopter was observed to maneuver over a wooded area, enter a nose high attitude, then roll or bank & enter a descent into a wooded…NTSB CHI84LA181Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ridge Farm, ILThe helicopter rolled over after a hard landing following loss of rotor RPM. The plt reported that during initial climb at about 300 ft AGL the rotor decreased about 500 RPM. He tried to regain rotor RPM until about 100 ft AGL and then tried an autorotation.…NTSB MIA84LA134Accident · No injuriesLimited investigationFinal reportBell 47D1 · Berlin, GAThe plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report.NTSB ATL83LA315Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAAfter completing a swath run, the plt pulled up, made a turn, then started a let down for another pass. As he increased power, the eng RPM went from 3000 to 3100. At the same time, the plt heard a whining noise and noted that the rotor RPM was decreasing. The…NTSB MIA83LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Riverview, FLAccording to the pilot he lost control of the acft after a bird hit him on the right temple while flying at about 15 feet above the water. The acft was traveling at about 50 mph when the bird flew in through left door opening. The pilot lost control of the…NTSB CHI83LA027Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Georgetown, INThe pilot started to takeoff from area that was difficult to exit. He relanded once. During the 2nd attempt to fly out, the helicopter collided with trees and crashed. The pilot was not rated in helicopters, but he said he had soloed.NTSB ATL82DA183Accident · No injuriesFinal reportBell 47D1 · Louisville, KYThe pilot was en route to have a radio installed when the engine lost power. He made an autorotative landing in an open field. When the helicopter contacted the ground, the main rotor, tail rotor, tail boom, and skids were damaged. The pilot stated that he…NTSB CHI82DA196Accident · No injuriesFinal reportBell 47D1 · Le Sueur, MNDuring a spraying operation, the aircraft was being refueled from a 200 gal fuel tank, mounted on the rear of a truck. The truck was parked on a slight slope with the outlet for the servicing hose at the lower end. After the helicopter was serviced with 14…NTSB ATL82DA150Accident · No injuriesFinal reportBell 47D1 · Blountville, TNThe aircraft lost power at 100 feet above ground level. An autorotation was attempted to a highway. The hard landing resulted in the main rotor severing the tail.NTSB FTW82DA189Accident · No injuriesFinal reportBell 47D-1 · Harrisburg, ARDuring an agricultural spraying operation the pilot turned downwind and the tail rotor struck a rice dike. The pilot lost control and the aircraft landed hard. The main rotor severed the tail boom. Investigation revealed the aircraft had been loaded within…NTSB NYC82DHD11Accident · Minor injuriesFinal reportBell 47G · New Egypt, NJThe pilot stated that he was about to finish spraying the field and had only two passes remaining when the accident occurred. Passes were made to the north and south with the wind from the west at 5 to 10 knots. After completing a pass to the south, he pulled…NTSB DEN82FTI03Accident · No injuriesClosedBell 47D1 · Haugen, MTNTSB LAX81FUJ85Accident · Minor injuriesClosedBell 47D1 · Poston, AZNTSB LAX81FVG21Accident · Minor injuriesClosedBell 47D1 · Chico, CANTSB FTW81FA045Accident · Minor injuriesClosedBell 47D1 · Roanoke, TXNTSB LAX81FUJ12Accident · Minor injuriesClosedBell 47D-1 · Horseshoe Lk, AZNTSB MIA81FKJ03Accident · No injuriesClosedBell 47D1 · Panama City, FLNTSB CHI80FEC26Accident · 1 fatalClosedBell 47D1 · Munith, MINTSB CHI80DEV30Accident · No injuriesClosedBell 47D-1 · Rantoul, ILNTSB CHI80FEC25Accident · Serious injuriesClosedBell 47D1 · Milan, MINTSB LAX80FVG22Accident · No injuriesClosedBell 47D1 · Chico, CANTSB LAX80FVM17Accident · No injuriesClosedBell 47D1 · Salinas, CANTSB LAX79FJA17Accident · No injuriesClosedBell 47D1 · Pearl City, HINTSB FTW79DPJ37Accident · No injuriesClosedBell 47D1 · Ardmore, OKNTSB MIA79FLA48Accident · No injuriesClosedBell 47D1 · Hahira, GANTSB NYC79FNE18Accident · No injuriesClosedBell 47D-1 · Ridgefield, CTNTSB NYC79FGT17Accident · Minor injuriesClosedBell 47D-1 · Hanover, PANTSB MIA79FKQ11Accident · No injuriesClosedBell 47D · Parchman, MSNTSB MIA79FLD57Accident · No injuriesClosedBell 47-D1 · Clearwater, FLNTSB MIA79DKT30Accident · No injuriesClosedBell 47G · Opa Locka, FLNTSB OAK78FVM46Accident · No injuriesClosedBell 47D1 · Castroville, CANTSB MIA78DLG36Accident · No injuriesClosedBell 47D1 · Summerville, SCNTSB MIA78FKG74Accident · No injuriesClosedBell 47D1 · Hartwell, GANTSB ANC78FA050Incident · No injuriesClosedBell 47D-1 · Anchorage, AKNTSB SEA78DYA10Accident · No injuriesClosedBell 47G3B1 · Ukon, IDNTSB LAX78FUQ25Accident · No injuriesClosedBell 47G · Sylmar, CANTSB LAX78FVA25Accident · No injuriesClosedBell 47G1 · Buttonwillow, CA
Back to Bell 47D1