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 ('1181511')
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 ('1181511')
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 FTW91FA070Accident · 2 fatalField investigationFinal reportBell 206B · So. Marsh 275The inflight structural failure and separation of the vertical fin which led to a loss of control and mast bumping. The failure of the fin was due to inadequate corrosion control efforts by the operator.NTSB LAX91LA127Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIInaccurate fuel consumption calculation by the pilot. A factor was the partial deflation of the emergency flotation equipment.NTSB ANC91LA030Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Kodiak, AKA loss of control and collision with terrain after the helicopter entered a whiteout condition.NTSB FTW91FA031Accident · 3 fatalField investigationFinal reportBell B 206B III · So. Pass Blk 70The pilot's loss of control of the aircraft for undetermined reasons shortly after departure. Factors in the accident were the restrictions to visibility that existed at the time.NTSB SEA90FA079Accident · No injuriesField investigationFinal reportBell 206B-3 · Coeur D'Alene, IDFailure of the pilot-in-command (PIC) to maintain rotor RPM, and a delay by the FAA inspector (flight examiner) in taking remedical action.NTSB MIA91TF#01Accident · Serious injuriesClass 3Final reportBell 206B · Boca Grande, FLNTSB MIA91LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Fort Pierce, FLThe incorrect cyclic control input by the student during the touchdown autorotation landing and failure of the CFI to correct this before the helicopter touched down.NTSB ANC90LA170Accident · Serious injuriesLimited investigationFinal reportBell 206B · Kokhanok, AKThe failure of the compressor end of the air compressor scroll to tee tube assembly causing the engine to spool down. The forced landing in eneven, unprepared, and lightly forested terrain were factors.NTSB FTW90LA172Accident · Minor injuriesLimited investigationFinal reportBell B206BIII · Cameron, LAThe pilot's failure to jettison the external load.NTSB LAX90LA298Accident · No injuriesLimited investigationFinal reportBell 206B · California City, CAThe failure of the helicopter pilot to maintain adequate clearance from the jump aircraft. A factor in the accident was the inability of the jump aircraft pilot to maintain visual contact with the helicopter.NTSB LAX90LA283Accident · Minor injuriesLimited investigationFinal reportBell 206B II · San Francisco, CAThe pilot's failure to maintain directional control of the helicopter. Contributing to the accident was the pilot's decision to operate the helicopter in a flight regime conducive to unanticipated right yaw.NTSB NYC90LA189Accident · Serious injuriesLimited investigationFinal reportBell 206 · Athens, OHThe pilot's failure to visually acquire and maintain clearance from the powerline(s). Contributing to the accident was the adverse weather conditions.NTSB NYC90LA187Accident · No injuriesLimited investigationFinal reportBell 206B · Fitchburg, MAThe pilot's failure to assure that adequate fuel was on board for the flight.NTSB LAX90FA268Accident · No injuriesField investigationFinal reportBell 206B · Quincy, CAAn unidentified contaminate lodged in the fuel governor.NTSB MIA90LA158Accident · Minor injuriesLimited investigationFinal reportBell 206B · Sarasota, FLImproper control input after the loss of tail rotor effectiveness.NTSB CHI90IA181Incident · No injuriesIncident investigationFinal reportBell 206A · Lake Ozark, MOCompression assembly blade and emergency floatation gear failure.NTSB LAX90T#A08Accident · No injuriesClass 3Final reportBell 206B · San Carlos, AZNTSB LAX90FA170Accident · 1 fatalField investigationFinal reportBell 206B · Carmel Valley, CAThe pilot's inadequate visual lookout and improper climb.NTSB FTW90LA107Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kaplan, LARestricted movement of the right skid assembly causing the lateral center of gravity to be exceeded during the attempted take off.NTSB LAX90TL#03Accident · Minor injuriesClass 3Final reportBell 206B · La Verne, CANTSB FTW90LA083Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pearland, TXDynamic rollover resultant from improper takeoff techniques used by the rated pilot, and inadequate supervision by the company check pilot.NTSB NYC90LA072Accident · Minor injuriesLimited investigationFinal reportBell 206B · Norwood, MAImproper planning/decision by the pilot. The turbulence was a related factor.NTSB CHI90TL#03Accident · Serious injuriesClass 3Final reportBell 206B · Fort Thompson, SDNTSB SEA90LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Winthrop, WAWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. Darkness and the obstructions in the emergency landing area were related factors.NTSB FTW90LA007Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · High Island 474 (Gulf of Mexico)The pilot's attempted takeoff with one tie-down strap still attached to the helicopter which resulted from an inadequatepreflight inspection of the aircraft.NTSB FTW89LA174Accident · No injuriesLimited investigationFinal reportBell 206BII · Grand Prairie, TXThe pilot's decision to execute an abrupt maneuver while hovering downwind, which led to a reduction in rotor RPM and subsequent hard landing.NTSB BFO89FA079Accident · Serious injuriesField investigationFinal reportBell 206B-III · White Plains, MDThe pilot's failure to follow procedures in that he delayed his climb during a night takeoff from a confined area. Contributing factor(s) was: the dark night and surrounding obstructions.NTSB LAX89LA297Accident · No injuriesLimited investigationFinal reportBell 206B · Murrieta, CAA partial loss of engine power due to contaminates in the fuel control unit. The origin of the contaminates was not determined. Contributing factor(s) was: the helicopter was not equipped with floats.NTSB MKC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Park Rapids, MNThe pilot misjudged the clearance between the helicopter and the power line. The power line (transmission wire) was considered to be a contributing factor.NTSB FTW89LA150Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAPilot's improper emergency procedures and flare that led to a hard landing and roll over. Factors in the accident were the pilot's decision to initiate an autorotation following an undetermined event and failure to maintain directional control during the…NTSB MKC89LA178Accident · No injuriesLimited investigationFinal reportBell 206B · Marys Home, MOThe failure of the pilot to maintain control of the helicopter.NTSB NYC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Nanuet, NYInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB DEN89LA189Accident · Serious injuriesLimited investigationFinal reportBell 206B · Georgetown, COImproper inflight planning/decision by the pilot. The high density altitude, tail wind, gusts, and terrain were related factors.NTSB DEN89FA175Accident · 3 fatalField investigationFinal reportBell 206B · Duchesne, UTThe pilot failed to maintain clearance from the power line. Contributing factors were: lack of mission training provided by the company/operator, the pilot's lack of experience in this type of operation, his lack of familiarity with the geographic area, and…NTSB SEA89LA128Accident · No injuriesLimited investigationFinal reportBell 206B · Longview, WAThe pilot inadvertently turning off the engine fuel supply instead of the external load fuel supply. Contributing to the accident was the pilot's failure to jettison the external load during the autorotation.NTSB SEA89LA095Accident · No injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDA loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB LAX89FA203Accident · 1 fatalField investigationFinal reportBell 206B · Camp Verde, AZFailure of the pilot to maintain adequate altitude to clear obstructions in his flight path and visually detect obstructions in order to avert a collision.NTSB SEA89LA087Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Lewiston, IDThe pilot's improper use of the helicopter's flight controls. Contributing to the accident was the pilot's misjudgement of the external load characteristics.NTSB MIA89TL#04Accident · Minor injuriesClass 3Final reportBell 206B · Ochopee, FLNTSB NYC89GA116Accident · 2 fatalFinal reportBell 206B · Airville, PAThe pilot was unable to see and avoid the unmarked power lines stretched across the river. A contributing factor was the lack of visual clues.NTSB FTW89FA075Accident · No injuriesField investigationFinal reportBell 206B · West CameronInadequate maintenance/inspection of the aircraft fuel system by company maintenance personnel and fuel contamination, which resulted in a partial loss of engine power. Related factors were: a binding (stuck) fuel filter cap bypass valve and partial failure…NTSB DEN89FA101Accident · No injuriesField investigationFinal reportBell 206B-III · Park City, UTAn encounter with strong down-slope winds and gusts during a critiacal phase of flight which caused power required to exceed power available. Contributing factors to the accident was the downhill terrain and the downdraft conditions.NTSB ATL89FA112Accident · Serious injuriesField investigationFinal reportBell 206B · Atlanta, GAFatigue failure of the engine spur adapter gearshaft in an area where there was a lack of lubrication (oil starvation) due to a partially blocked oil delivery tube. Contributing factors were: inattentive maintenance or servicing of the aircraft by unknown…NTSB LAX89LA125Accident · No injuriesLimited investigationFinal reportBell 206B · Corona, CAImproper operation of the cyclic by the student pilot, failure of the student to relinquish control and inadequate supervision by the flight instructor.NTSB NYC89LA096Accident · No injuriesLimited investigationFinal reportBell 206B · Harding Twnp, NJThe pilots attempt to conduct the flight with less than required fuel resulting in loss of engine power and subsequent damage to the helicopter while performing an autorotative landing.NTSB DEN89LA059Accident · No injuriesLimited investigationFinal reportBell 206B III · Park City, UTThe selection of an unsuitable landing site by the pilot, resulting in tail rotor contact with the terrain and shearing of the tail rotor driveshaft.NTSB FTW89LA036Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · S.Timbalier 151A collision between the aircraft and the platform during the emergency autorotation which caused the left skid and float to separate and destabilized the autorotation. The collision was probably unadoidable due to the maneuver that was being conducted at the…NTSB ATL89FA051Accident · No injuriesField investigationFinal reportBell 206B · Pinson, ALTwo FAA inspectors were conducting currency training when the helicopter landed hard during a practice power recovery autorotation. The pilot had delayed in applying power and collective pitch. Upon contact with the ground, all engine instruments indicated…NTSB FTW89LA026Accident · No injuriesLimited investigationFinal reportBell 206B · Chalmette, LAThe rated pilot's inadequate takeoff technique the the instructor pilot's momentary lack of judgement in having the pilot attempt a hydraulics off takeoff.NTSB FTW88LA158Accident · Minor injuriesLimited investigationFinal reportBell 206B · West Cameron 28The pilot landed the heicopter on a drilling platform and instructed the mechanic to install only the forward tie-downs. The mechanic secured the forward and aft tie-downs and secured the forward rotor blades. When the pilot returned to the helicopter, he…
Back to Bell 206B