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 FTW97LA326Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAThe disconnect of the #5 tail rotor drive segment due to the debonding of the joint between the shaft tube and the flange fitting. Factors were the improper bead blasting of the tail rotor drive segment by an unknown maintenance personnel, and the lack of…NTSB ANC97GA126Accident · 1 fatalFinal reportBell BH-206B · Dillingham, AKThe pilot's intentional VFR flight into instrument meteorological conditions (IMC). Factors associated with the accident are the pilot's failure to activate the cabin heating system, the lack of an operable windshield defogger, the pilot's overconfidence in…NTSB LAX97LA262Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pollock Pines, CAthe passenger's failure to recognize and avoid the hazard associated with the rotating tail rotor. The operator/event organizer's lack of ground facilities or support personnel to assist/control passenger access to the helipad was a related factor.NTSB FTW97LA252Accident · Serious injuriesLimited investigationFinal reportBell 206B · New Iberia, LAthe pilot's improper in-flight planning/decision. A related factor was his failure to follow the company procedure of maintaining visual contact with the external long-line cable, while hovering with it attached.NTSB FTW97FA208Accident · 1 fatalField investigationFinal reportBell 206B · Intracoastl Cty, LAThe failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…NTSB MIA97FA172Accident · Serious injuriesField investigationFinal reportBell 206B · Winter Park, FLThe pilots improper in-flight planning/decision to conduct an out of ground effect hover with a tailwind resulting in an in-flight loss of directional control due to loss of tailrotor effectiveness/unanticipated right yaw, and subsequent in-flight collision…NTSB LAX97LA185Accident · 1 fatalLimited investigationFinal reportBell 206B · Hilo, HIthe noninstrument-rated pilot flew into instrument conditions and failed to maintain adequate terrain clearance, while attempting to descend through an overcast. The adverse weather conditions and mountainous terrain were related factors.NTSB LAX97LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mountain Spring, NVthe pilot's poor weather evaluation and the decision to continue to attempt to land during forecast adverse weather conditions.NTSB SEA97LA029Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Ballston, ORa loss of control for undetermined reasons.NTSB LAX97LA030Accident · Minor injuriesLimited investigationFinal reportBell 206B · Supai, AZimproper routing of the external cargo hoist cable (over helicopter skid), which resulted in lateral imbalance and roll-over of the helicopter, as weight on the cable became effective.NTSB FTW97LA030Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Creole, LAthe pilot's inadequate preflight by failing to remove the 100 foot long line and the external cargo basket from the helicopter before takeoff, and/or his failure to ensure that clearance/altitude was maintained from the fence.NTSB MIA96TA236Accident · No injuriesFinal reportBell 206B III · Flamingo, FLthe wire strike protection guide became entangled in a mangrove branch which resulted in helicopter control not being maintained.NTSB LAX96LA346Accident · No injuriesLimited investigationFinal reportBell 206B · Fillmore, CAthe flight instructor's inadequate supervision and delay in taking remedial action to stop the aircraft's lateral movement, which resulted in a dynamic rollover after touchdown.NTSB LAX96LA342Accident · No injuriesLimited investigationFinal reportBell 206B · Van Nuys, CAthe pilot's improper in-flight planning/decision to turn right instead of left.NTSB ANC96LA154Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cantwell, AKthe pilot's continued VFR flight into instrument meteorological conditions (IMC). The terrain conditions, low ceiling, fog, and whiteout conditions were related factors.NTSB SEA96LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Greybull, WYthe pilot's misjudged recovery (remedial action) from a simulated autorotation demonstration.NTSB SEA96LA198Accident · Serious injuriesLimited investigationFinal reportBell 206B · Glenns Ferry, IDfuel contamination, due to improper servicing of the helicopter, which resulted in an intermittent loss of engine power. A factor relating to the accident was: the pilot's inadequate control of the helicopter, during autorotation with intermittent engine…NTSB NYC96LA167Accident · No injuriesLimited investigationFinal reportBell 206B · Starks, MEthe pilot's improper decision to operate at slow airspeed, and close to the critical relative wind azimuth area in gusty, variable winds, which resulted in an inadvertent loss of tail rotor effectiveness. The gusty crosswind and lack of a suitable terrain for…NTSB MIA96LA200Accident · 1 fatalLimited investigationFinal reportBell 206B III · Barton, ALfailure of the pilot to see-and/or-avoid the obstruction (unmarked power line), while en route between the area that was being treated and the refueling location. The power line and lack of visual cues at dusk were related factors.NTSB SEA96LA165Accident · 1 fatalLimited investigationFinal reportBell 206B · Warren, IDthe pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…NTSB MIA96LA180Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pigeon Forge, TNfatigue failure of the engine PC line, induced by damage from improper installation, which resulted in a loss of engine power and an autorotative landing to unsuitable terrain.NTSB IAD96FA107Accident · 5 fatalField investigationFinal reportBell 206B · Salem, OHThe pilot's impairment of judgment and performance due to alcohol and the pilot's improper handling of the helicopter resulting in a loss of tail rotor effectiveness. A related factor was the pilot's disregard for the aircraft's weight and balance while…NTSB ANC96LA097Accident · No injuriesLimited investigationFinal reportBell 206B · Juneau, AKThe pilot's failure to maintain proper alignment while lifting the helicopter to a hover and inducing a dynamic roll to avoid striking a passenger.NTSB IAD96LA067Accident · No injuriesLimited investigationFinal reportBell 206B · Logan, WVthe pilot's failure to maintain an adequate fuel supply for the flight which resulted in a loss of engine power due to fuel exhaustion, and the loss of rotor rpm during the autorotation. The downhill sloping terrain was a related factor.NTSB SEA96LA070Accident · Minor injuriesLimited investigationFinal reportBell 206B · La Grande, ORthe pilot's failure to maintain clearance with trees after pulling up from an aerial application spray run.NTSB FTW96LA147Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Houma, LAthe pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.NTSB CHI96FA088Accident · 1 fatalField investigationFinal reportBell 206B-III · Pellston, MIflight into known adverse weather conditions (fog) at too low an altitude by the pilot. Factors associated with this accident were inadequate preflight planning and an improper inflight decision by the pilot when he chose to continue flight into the fog…NTSB SEA96TA050Accident · No injuriesFinal reportBell 206B · Kemmerer, WYthe selection of an unsuitable landing zone by the pilot.NTSB LAX96LA194Accident · No injuriesLimited investigationFinal reportBell 206B · Barstow, CAfailure of the pilot to maintain adequate terrain clearance, while maneuvering around a ground vehicle at low altitude.NTSB LAX96LA104Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kamuela, HIfailure of the nose case (No.1) bearing resulting in oil starvation.NTSB MIA96WA070Accident · Minor injuriesForeign investigationBell 206 · Exuma, BahamasNTSB MIA95TA230Accident · Serious injuriesFinal reportBell 206B · Culebra, PRthe failure of company maintenance personnel to insure the tail rotor gearbox attach bolts were properly torqued.NTSB ANC95TA166Accident · Serious injuriesFinal reportBell 206B · Glennallen, AKThe pilot's improper in-flight planing/decision and inadequate supervision of the passenger, which allowed the helicopter's lateral center-of-gravity to be exceeded. Factors relating to the accident were: pressure (compelling influence) on the pilot and…NTSB LAX95LA310Accident · No injuriesLimited investigationFinal reportBell 206BIII · Carmel Valley, CAthe pilot's failure to maintain an adequate clearance from obstructions while hovering.NTSB NYC95LA198Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bingham, MEthe pilot's inadequate landing flare resulting in a hard landing and roll over, and a subsequent collision with trees.NTSB MIA95LA205Accident · No injuriesLimited investigationFinal reportBell 206B · Immokalee, FLThe pilot's improper use of the cyclic during a power-on autorotative landing (low flare), resulting in the ventral fin colliding with the ground.NTSB ANC95LA115Accident · Minor injuriesLimited investigationFinal reportBell 206B · Talkeetna, AKThe inadvertent restriction of the anti-torque pedal by the pilot's foot, while the pilot (an incomplete paraplegic) was attempting to land.NTSB ANC95LA112Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Bettles, AKFailure of the pilot to ensuring the sling cable was free of the skid before lifting off into a hover, which allowed the cable to become wrapped (entangled) around the skid.NTSB FTW95LA303Accident · No injuriesLimited investigationFinal reportBell 206B · West CameronThe disconnect of the tail rotor drive system for undetermined reasons. Factors were the pilot's inability to maintain directional control, and the lack of suitable terrain for the forced landing.NTSB FTW95TA228Accident · No injuriesFinal reportBell 206B-III · Meeker, COFailure by the pilot to maintain control of the aircraft during landing. A factor was soft terrain.NTSB LAX95LA146Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)the loss of tail rotor control for undetermined reasons.NTSB SEA95GA062Accident · No injuriesFinal reportBell 206 · Dillon, MTThe pilot's selection of a landing site that was not suitable to support the weight of the helicopter. Factors include terrain covered with soft snow.NTSB MIA95WA068Accident · No injuriesForeign investigationBell 206B3 · Neacon, NicaraguaNTSB LAX95FA079Accident · 2 fatalField investigationFinal reportBell 206B · Los Angeles, CAThe pilot's continued VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's and operator's failure to follow their established dispatch procedures, the pilot's poor judgment in initiating the flight,…NTSB MIA95LA044Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLInadequate supervision by the pilot-in-command (CFI) for failure to note reduction in clearance between the tail rotor and an embankment.NTSB LAX95LA052Accident · No injuriesLimited investigationFinal reportBell 206B · Julian, CAthe failure of the pilot to maintain a proper alignment during hover in a mountainous area.NTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.NTSB CHI95LA026Accident · Serious injuriesLimited investigationFinal reportBell 206B3 · Inver Grove Hts, MNthe pilot's improper altitude and inadequate visual lookout.NTSB ANC94LA110Accident · No injuriesLimited investigationFinal reportBell B-206 · Gustavus, AKThe pilot misjudged his distance/altitude from the landing area, and his lack of recent night flying experience. Factors which contributed to the accident were: the pilot's failure to assure that he would be landing with sufficient light, and the dusk/dark…NTSB LAX94T#A08Accident · No injuriesClass 3Final reportBell 206B-III · Yreka, CA
Back to Bell 206B