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 FTW88LA153Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXThe helicopter was at 300 feet AGL, making an approach after a maintenance test flight, when the engine overtemped and engine power was lost. During the autorotation landing, the helicopter touched down hard. The acft eng began to decelerate prior to…NTSB DEN88LA180Accident · No injuriesLimited investigationFinal reportBell 206B · Sturgis, SDThe plt was on a flt with 2 pax to take pictures. He stated that 'while in level flight at 120 mph and 300 feet above the ground, a pitch over was initiated for picture taking. At that moment, it appeared that the fuel flow cavitated. The forward fuel pump…NTSB SEA88LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Enterprise, ORWhile in cruise flt at abt 500 ft AGL, the plt stated he heard a 'ping' sound from the eng and pwr decreased to flt idle. An autorotation was attempted into a cleared upsloping area but the plt had to pull 'up' collective in order to clear a fence. A hard…NTSB NYC88LA201Accident · No injuriesLimited investigationFinal reportBell 206B · Plymouth, MAA loss of power to the engine because the fuel control was not properly adjusted and collision with terrain due to an unsuitable landing area.NTSB LAX88LA203Accident · Minor injuriesLimited investigationFinal reportBell 206B · Honolulu, HIDuring a sightseeing flt, just after take off, the helicopter began to spin to the right, the plt tried to correct the situation by applying left rudder. The helicopter continued to spin. The plt reduced the throttle and adjusted the collective. The spin…NTSB NYC88FA133Accident · 1 fatalField investigationFinal reportBell 206B · Long Island Cty, NYThe Bell 206B was on a sightseeing flight around the Island of manhattan when it experienced a low rotor RPM situation. The pilot said he could not recover rotor RPM and made a forced landing in the east river. The pilot and three passengers exited the…NTSB NYC88LA105Accident · Minor injuriesLimited investigationFinal reportBell 206B · Agawam, MAThe pilot was on approach to landing from the south at about 2,000 yards from his pad. Speed was about 65 knots and was about 500 feet from the ground when the pilot said he had a flashback and doesn't remember what happened, the helicopter rolled over while…NTSB LAX88LA136Accident · No injuriesLimited investigationFinal reportBell 206B · Honolulu, HIAfter touchdown the plt reduced the throttle and removed his left hand from the throttle/collective pitch control to retune the radio. His attention was directed to the frequency indicator during the procedure. The helicopter became airborne and moved to the…NTSB CHI88LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Martinsville, INWhile engaged in intentional low level flight for the purpose of doing advertising photography, the helicopter experienced a wire strike. The wire wound around the main rotor and pulled the helicopter to the ground. The helicopter received substantial damage.…NTSB DEN88LA026Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Albuquerque, NMWhile attempting to retrieve a parachute retarded rocket that came to rest in a tree by hooking the right front skid shoe under the chute, the parachute got hung up in the tree. The helicopter lifted the rocket approx 6 ft into the air before it swung into…NTSB FTW87LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Gulf Of MexicoWhile departing from an off-shore oil platform in the Gulf Of Mexico, the helicopter eng lost power. The plt initiated an autorotation & made a mayday call, but did not get the emerg floats inflated before touching down in the water. Subsequently, the…NTSB LAX87FA332Accident · 3 fatalField investigationFinal reportBell 206B · Vallejo, CAWhile performing a routine aerial observation flight to inspect the integrity of the pacific gas & electric company's transmission lines, the helicopter crashed after colliding with an unmarked static wire. The line installation was on sloping terrain &…NTSB LAX87LA310Accident · Minor injuriesLimited investigationFinal reportBell 206B · Kailua-Kona, HIAs the helicopter was climbing over rising terrain at 300' to 400' AGL, the plt noted altimeter & airspeed indcns of 8700' & 60 mph. After climbing an adnl 2 min to aprx 10,000' (12,000' density alt), he noticed the rotor RPM was bleeding off. He made a 180…NTSB BFO87FA057Accident · 3 fatalField investigationFinal reportBell 206B · Washington, DCThe helicopter was on a LCL photography (sight-seeing) flt. While hovering at aprx 200' abv the potomac river, the eng lost pwr. The plt initiated an autorotation & deployed the emerg floats. Subsequently, the helicopter impacted in the river & rolled ovr,…NTSB FTW87FA198Accident · No injuriesField investigationFinal reportBell 206B · Pledger, TXWhile cruising at 900' AGL, the plt noted a hvy shudder flwd by a grinding noise, loud 'bang' & a low rotor RPM signal. He made an autorotation to a road, but drg touchdown, the main rotor blades flexed dwn & severed the tail boom. An exam revealed the main…NTSB LAX87LA179Accident · Minor injuriesLimited investigationFinal reportBell 206B-II · Yucaipa, CAA Bell 206B went out of control and crashed while lndg at a 5,720 ft high helipad. The plt indicated that he terminated the aprch at a 8-10 ft hover and began to spin to the right with full left pedal applied. After 1 1/2 to 2 turns the plt atmptd to fly out…NTSB LAX87LA178Accident · 1 fatalLimited investigationFinal reportBell 206B · Laupahoehoe, HIThe pilot of the Bell 206B and his three passengers arrived over a beached barge that they were to land on. The pilot hovered over the barge in a left quartering tailwind of about 10 knots and over a moderate sea with waves breaking against the barge. The two…NTSB LAX87LA161Accident · 1 fatalLimited investigationFinal reportBell 206B · Kona, HIThe pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the…NTSB FTW87LA068Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Braunfels, TXAcft had been parked in an open field and when the plt returned he noticed that the left skid had sunk into the mud. After eng start and run up, the plt attempted to takeoff with right cyclic applied to un-stick the left skid. The acft lifted off with a right…NTSB SEA87LA059Accident · No injuriesLimited investigationFinal reportBell 206B-III · Dayton, WAPlt lifted off with fertilizer bucket on 3-FT external hook. As fwd motion commenced, acft settled slightly, dragging bucket on ground and tipping it over. Plt attempted to recover by backing up, but skid caught on bucket, causing loss of control.NTSB NYC87LA030Accident · Serious injuriesLimited investigationFinal reportBell 206B · Staten Island, NYThe on-demand cargo flight encountered a bird strike enroute from new jersey to jamaica, new york. The pilot received serious injury to the eye and checkbone but was able to accomplish an emergency landing in a parking lot without further damage or injury.NTSB FTW87FA007Accident · Serious injuriesField investigationFinal reportBell 206B · Mustang IslandAcft experienced a power loss immediately after takeoff from an offshore platform in the gulf of Mexico. The plt held collective to clear the rig and then popped the floats and autorotated to the water. The auto was successful, however, the acft was struck by…NTSB LAX86MA311Accident · 2 fatalMajor investigationFinal reportBell 206B · Alamo, CAWitnesses reported seeing the helicopter circle twice over a residence at an alt of aprx 50' AGL. Upon initiating the third turn the helicopter entered an abrupt 90 deg bank and nosed down to impact with the terrain. Exam of the helicopter failed to reveal…NTSB FTW86LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Sand Springs, OKThe student pilot was hovering aircraft at 3 feet and allowed the aircraft to drift to the right. High skid gear was installed on the a/c. the right skid made contact with the ground causing dynamic rollover. The student pilot had a total of 44.2 hours flight…NTSB FTW86LA130Accident · Serious injuriesLimited investigationFinal reportBell 206B · Conroe, TXThe pilot reported that he lost tail rotor control during the transition part of the takeoff. As the helicopter rotated to the right, the pilot reduced power and pulled in collective before impact. Examination of the tail rotor showed no evidence of any tail…NTSB LAX86FJA02Accident · 1 fatalFinal reportBell 206B · Pacific Ocean (Pacific Ocean)The plt was attempting to take off from the deck of a tuna boat when it contacted the side of the boat and sank in the Ocean. Post accident inspection revealed one of two nose tiedown straps had not been removed from the helicopter prior to the takeoff. The…NTSB NYC86LA168Accident · No injuriesLimited investigationFinal reportBell 206B III · Moultonboro, NHThe Bell jet ranger had just dropped off an external load and was returning downhill when the pilot reported hearing a growling noise in the aft portion of the aircraft. He autorotated to landing as control was lost. When the wreckage was examined after it…NTSB DCA86AA028Accident · 25 fatalFinal reportBell 206B · Grand Canyon, AZAt about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & Bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the…NTSB DEN86LA151Accident · Minor injuriesLimited investigationFinal reportBell 206B · Portal, NDThe plt reported that the acft hit wires at the end of a swath run. The pitch change link broke when the main rotor contacted the wires and the plt attempted to land. After touchdown, the helicopter rolled onto its side.NTSB NYC86FA216Accident · 3 fatalField investigationFinal reportBell 206B · Noman'S Land, MAThe Bell 206 helicopter was en route to nantocket island when the pilot received an inflight weather briefing with VFR flight not recommended. The pilot acknowledged this report and it appears he elected to continue the flight. The acft did not reach it's…NTSB LAX86LA226Accident · Minor injuriesLimited investigationFinal reportBell 206B · Los Angeles, CADuring a x-wind takeoff the downwind skid contacted the landing pad and the helicopter rolled over to the right. One person on the ground was injured by flying debris.NTSB LAX86FJA06Accident · 2 fatalFinal reportBell 206B · Maui, HIThe acft collided with powerlines while carrying pass'g on a sightseeing flt through a canyon. The wires across the canyon were EST to be 1700 long with height AGL unknown. The wires were unmarked and were 1/2 in dia aluminum. One of the passengers was…NTSB FTW86FA085Accident · 2 fatalField investigationFinal reportBell 206B · Pine Spring, TXThe helicopter was on a flt to a site nr guadalupe pass, an area known for erratic & gusty wnds. As the plt was on an apch to a hi meadow (elev aprx 5460'), the helicopter entered a dscnt & crashed well short of the intended lndg area. A witness rprtd the…NTSB LAX86LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Huntington Bch, CAA Bell 206B collided with a berm after an eng failure while departing a helipad. The plt indicated he had just departed the helipad at night and at aprx 50 ft AGL the eng failed. The acft vertical fin hit the berm causing the tail boom to bend aft of the…NTSB SEA86LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mount Baldy, IDThe pilot allowed the aircraft to enter into instrument meteorological conditions. The artificial horizon was inoperative as well as the turn portion of the turn and bank. A tree was struck with the aircraft then striking the ground.NTSB LAX86FA106Accident · 1 fatalField investigationFinal reportBell 206B · Young, AZThe plt & his daughter planned to fly to their ranch for the purpose of hiring a manager. Upon arriving at their destination ground fog prevailed. The plt, familiar with the area, attempted to find an area where he could descend below the fog. The fog was at…NTSB FTW86FA033Accident · Minor injuriesField investigationFinal reportBell 206B · Port O'Connor, TXThe helicopter sustained a loss of tailrotor drive on lift off. A bonding in a shaft coupling failed. Extensive research and analysis discovered no discrepancies in design, production, quality assurance, maintenance or operating environment that could have…NTSB NYC86FA037Accident · 2 fatalField investigationFinal reportBell 206B · Cheshire, CTThe helicopter was flying at or near the base of the overcast when it contacted a tree and descended to ground impact. Witnesses reported hearing the eng operating during the accident sequence and the area was covered with heavy fog. No mechanical malfunction…NTSB FTW86LRG01Accident · No injuriesFinal reportBell 206B · Port O'Conner, TXThe acft rolled over after a forced lndg due to loss of power. The eng lost about 60 percent of its power during cruise at about 250 ft AGL. Post acc inspection showed that fuel line p/n 685481 b-nut had backed off the fuel control end of line 250C20 ipc. The…NTSB DEN86LA007Accident · Serious injuriesLimited investigationFinal reportBell BH 206BII · Kremmling, COWhile maneuvering to observe wildlife, the pilot attempted to hover out of gnd effect in steep mtns terrain at 9800 ft MSL at 2550 lbs gw with a 7-10KT tailwind. According to acft hoge charts in the POH, the acft was not capable of hoge in the conditions of…NTSB FTW85LA360Accident · Serious injuriesLimited investigationFinal reportBell 206B · North Padre 967The helicoter was attempting to take off with a rope still attached to the forward fuselage tiedown. A witness stated that the nose of the aircraft rotated down as the tail lifted to a near vertical attitude. The pilot inflated the floatsbut the aircraft…NTSB NYC85FA245Accident · 1 fatalField investigationFinal reportBell 206B · Chalkhill, PAThe helicopter was being used on an external load operation with a 100 ft cable attached. When a 618 lb load was ready to be moved, the plt started the eng, lifted off & moved the helicopter to a hover over the load. The loaders hooked the load to the cable &…NTSB LAX85LA407Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)The helicopter experienced a loss of pwr within 10 minutes after takeoff from a fishing vessel. The helicopter was ditched in the Ocean at coordinates 11.25'N and 103.37'W. Examination of fuel samples from the fishing vessel revealed both upper and lower fuel…NTSB SEA85LA214Accident · Minor injuriesLimited investigationFinal reportBell 206BII · Atlanta, IDA loss of pwr occurred shortly before touchdown. The left skid struck a rock during touchdown causing the acft to roll onto its right side. Twenty-five flt hrs prior to this flt an identical situation occurred and a loose air line to the fuel control was…NTSB FTW85LA315Accident · Minor injuriesLimited investigationFinal reportBell 206B · Damon, TXThe plt experienced an eng deceleration to flt idle while cruising 1000 MSL. He autorotated into trees in a heavily wooded area. A subsequent eng disassembly and examination revealed the pwr control line, p/n 6848471-B, was broken at its attaching 'b' nut…NTSB CHI85LA303Accident · No injuriesLimited investigationFinal reportBell 206BII · Farmington, MNDuring maneuvering to ld in an uncultivated fld the tail rotor struck a fence post,from a dismantled fence,that was concealed by high weeds. One tail rotor blade was separated,the pilot lost control,and on touchdown the helicopter rolled over.NTSB LAX85LA323Accident · Serious injuriesLimited investigationFinal reportBell 206B · Soda Springs, CAOn July 19,1985 a Bell 206B lost control while maneuvering near Soda Springs,CA.the aircraft was substantially damaged and the two pilots sustained serious injuries. The repoted he was maneuvering at 30 mph looking for sheep in mountainous terrain when he…NTSB LAX85FA315Accident · 2 fatalField investigationFinal reportBell 206-B · Page, AZOn July 12, 1984, a Bell 206B helicopter collided with a steel bridge 10 miles so of Page, AZ. The helicopter was being filmed in flt during the making of a movie. VMC existed at the time. The helicopter was destroyed and the plt and pax, an italian actor,…NTSB LAX85LA299Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Grand Canyon, AZDuring a movie filming flight, the helicopter was acting as the camera platform and filming a fixed wing aircraft during a straight in appraoch to the airport, the plt of the helicopter requested a right 180 degree turn at mid field to land at the north…NTSB NYC85FNC04Accident · Serious injuriesFinal reportBell 206B · W. Brattleboro, VTThe acft lost pwr during normal cruise. The plt attempted to autorotate into a clearing in the trees. Post accident exam discovered an air leak in the fuel control. The pressure compressor discharge (pcd) line 'b' nut was disconnected from the fuel control.…
Back to Bell 206B