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 NYC85FGM04Accident · Serious injuriesFinal reportBell 206B · New Baltimore, PAThe acft collided with a power line during aerial application operations. There was no malfunction of equipment prior to the accident. The helicopter descended into trees & was damaged. The plt said that he was looking for a cut off marker in the form of a…NTSB ANC85FA065Accident · No injuriesField investigationFinal reportBell BH-206-B · Valdez, AKThe pilot in command stated that he was on final approach and at 125 feet AGL, he heard the low RPM audio warning and he immediately entered an autorotation by lowering the collective to the full down position and closing the throttle to the flight idle…NTSB ANC85FA052Accident · 1 fatalField investigationFinal reportBell 206B · Whittier, AKThe helicopter impacted terrain in a 150 ft gorge after contacting telephone lines along a railroad right-of-way aprx 2 miles north of a tunnel station. Purpose of the flt was to survey the area around the tunnel station.NTSB SEA85FA040Accident · Serious injuriesField investigationFinal reportBell 206BIII · Yerington, NVThe plt made an en route emergency landing due to deteriorated wx. After waiting some period of time, a takeoff was attempted but the helicopter was unable to become airborne. The helicopter bounced down hilly terrain and rolled over to the left. Wx at the…NTSB LAX85FA101Accident · Minor injuriesField investigationFinal reportBell 206B · Trimmer, CAThe plt stated the helicopter lost pwr during cruise when he attempted to add pwr to climb. He stated that N2 decreased along with the activation of visual and audio engine out warnings. An autorotation was performed to a road, however, the helicopter slid…NTSB DEN85LA033Accident · No injuriesLimited investigationFinal reportBell 206B-III · Mancos, COThe acft settled during an emer lndg after the plt said the engine failed. Investigation revealed the acft received minor maintenance on the day of the accident, consisting of changing the pitch chain links on the main rotor blades. Theplt made a written…NTSB DEN85FA027Accident · 4 fatalField investigationFinal reportBell 206B-11 · Bingham Canyon, UTPilot was taking passeengers on a sightseeng flight over the kennecott copper mine, largest open pit copper mine in the world. Helicopter collided with unmarked power lines approx 185 ft AGL. Power lines are supported by two unmarked towers on opposing hills…NTSB LAX85LA045Accident · No injuriesLimited investigationFinal reportBell 206B · Inverness, CAAn autorotation was initiated at about 300 ft as eng and rotor RPM began to decrease. Touchdown occurred in soft sand with some forward motion. Full aft cyclic was applied causing the main rotor to contact the tailboom. Exam of the acft fuel system revealed…NTSB LAX85FA036Accident · 2 fatalField investigationFinal reportBell 206B · Beaumont, CAApproximately one min before the accident the pilot contacted the tower at norton air force base for clearance through their traffic area. He reported initially that he was at 300 ft AGL. Seconds later he transmitted that he was at 100 ft over the freeway.…NTSB FTW85FA032Accident · Serious injuriesField investigationFinal reportBell 206B · Lane City, TXDuring cruise at 600 ft AGL a bang was heard & acft experienced a vibration. When turning toward a fld to land a second bang was heard & vibration ceased. However, an uncommanded rt yaw was experienced & the nose began to tuck under. Acft contacted terrain…NTSB ATL84FA297Accident · 2 fatalField investigationFinal reportBell 206B · Kernersville, NCWhile dismantling a water tower, an iron worker was seriously injured & pinned as he was removing a portion of a water tower leg (aprx 92 ft AGL). The helicopter plt responded to the emergency. The acft was equipped with a make-shift sling line to retrieve…NTSB LAX84LA488Accident · Serious injuriesLimited investigationFinal reportBell 206B · Paso Robles, CAPlt stated that after receiving a special VFR clearence he took off to spray a nearby field. He continued to state that he 'made a couple of circuits over the field, observed the telephone wires and began spraying. After performing 2 or 3 passes I hit some…NTSB FTW84FA393Accident · Serious injuriesField investigationFinal reportBell 206B II · Dallas, TXAcft made forced autorotative landing off arpt in a residential area which was congested. Acft developed a high sink rate in the autorotation and landed hard. The forced landing was due to fuel exhaustion. 45 gallons of fuel were added to the acft at 1226 CST…NTSB NYC84FA307Accident · 4 fatalField investigationFinal reportBell 206B · Wallingford, CTThe acft collided with wires after the plt announced by radio that he was going to make a low pass over the site of an outdoor event that he had just attended. Some witnesses saw the helicopter flying extremely low. It appeared that one of the landing skid…NTSB FTW84LA378Accident · Minor injuriesLimited investigationFinal reportBell 206B · Houma, LAThe helicopter was on a cargo, non scheduled air taxi flight when the plt smelled smoke. A precautionary landing was made on a beach after which the acft was destroyed by fire.NTSB ANC84LA122Accident · No injuriesLimited investigationFinal reportBell 206B · Healy, AKThe plt was attempting to land the helicopter on terrain which had a slight slope. Before the aircraft was completely on the ground the plt decided to move the acft & the right skid caught in the tundra causing the acft to roll over to the right.NTSB FTW84FA321Accident · 2 fatalField investigationFinal reportBell 206B · Dallas, TXWitnesses observed the helicopter circling a 523 ft, free standing, communications tower. After circling several times, helicopter passed close to the tower & a main rotor blade struck it at the 451 ft level. The outboard portion of the rotor blade separated…NTSB NYC84LA231Accident · No injuriesLimited investigationFinal reportBell 206B · Somers, CTThe acft made a hard touchdown with the left side low. One side of the rotor came off and the other hit the engine according to one of the passengers aboard the acft. The plt said that the approach was normal and he brought the acft toa hover. However…NTSB DEN84FA207Accident · 2 fatalField investigationFinal reportBell 206B · Englewood, COWitnesses stated the helicopter entered a 'hard left turn' into a near inverted position before 'it went down hard and fast.' Inspection disclosed the metal connection for the left cyclic stick was broken in half. (Plt was flying from left seat.) Exam of the…NTSB FTW84LA270Accident · Minor injuriesLimited investigationFinal reportBell 206B · South PeltoWhile cruising at 550 ft above the gulf of Mexico, the plt noted hi tot indications, followed by loss of N1 RPM & eng failure. An autorotation was initiated which terminated in a hard landing in 5 ft waves. One emergency float separated during the landing &…NTSB DEN84LA124Accident · No injuriesLimited investigationFinal reportBell 206B · Farmington, NMWhile climbing, there was a heavy smell of fuel. At aprx 150 ft AGL on a precautionary landing, the eng quit. The helicopter impacted hard, collapsing the skids, & the main rotor blades sheared of the tail boom. During an investigation, the fuel hose b-nut…NTSB DEN84LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Alpine, WYThe plt stated on takeoff at an alt of 10 ft AGL a loss of power occurred. During the forced landing the left skid contacted either the pad or an object on the pad and the acft rolled over to the left. The plt stated that white out condition occurred during…NTSB DEN84FA102Accident · 1 fatalField investigationFinal reportBell 206B-III · Coalville, UTThe helicopter was equipped with 'bear paws'. Snowshoe-like devices on the skids to distribute weight on soft surfaces. The bear paws on this acft rotated freely around the skids, not tightened down as per design spec. Also, bear paws are not approved for…NTSB MIA84FA067Accident · 1 fatalField investigationFinal reportBell 206B · Stuart, FLWitnesses observed the helicopter flying at 100 to 150 ft above the water & about 100 yds offshore. They observed & heard nothing unusual, except they said the helicopter began descending until it impacted the water. The rear doors had been removed for the…NTSB LAX84LA117Accident · Serious injuriesLimited investigationFinal reportBell 206B III · Mountain City, NVThe helicopter collided with the snow covered ground after the eng quit during a power-line patrol at about 30 ft AGL. The plt reported that the visibility was 1/2 mile with light snow falling. He also said he could see 4 to 7 of the supporting structures.…NTSB DEN84FA038Accident · Serious injuriesField investigationFinal reportBell 206B · Ft. Morgan, COThe helicopter was owned & operated by a tv station & was being used for transportation to a news event. While en route, clouds & reduced visibility due to fog were encountered. The plt elected to land in a field covered with powdered snow. During the…NTSB ANC84LA012Accident · Serious injuriesLimited investigationFinal reportBell 206-B · Kodiak, AKWhile inspecting a transmission wire tower, the left skid became entangled with the power line guide. This pulled the helicopter out of CG. While the plt was trying to correct the problem, the m/r blade contacted the tower & struck the tail boom separating…NTSB NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…NTSB ANC84FA008Accident · Minor injuriesField investigationFinal reportBell B-206B · Paxson, AKAccording to the plt, he took off upslope into the wind in an easterly direction. Immediately after taking off, he made a right turn to a x-wind, & seconds later, he made a further turn the right (downwind). Visibility toward the east was about 1/4 mi, but to…NTSB LAX83FA400Accident · Minor injuriesField investigationFinal reportBell 206-B · Battle Mountain, NVThe helicopter lost power during takeoff,touched down on the left skid,bounced and rolled over. The flt had originated at 1315 at a local field and proceeded to pick up a passenger at another location. The acft had just landed, picked up the passenger and was…NTSB MIA83LA199Accident · No injuriesLimited investigationFinal reportBell 206B · Stuart, FLWhile in cruise flt at aprx 600 ft AGL, a catastrophic failure of the engine's 3rd stage turbine occurred. The plt related that he observed an engine chip detector light, which was followed almost immediately by fire in the engine. He made a successful…NTSB FTW83LA369Accident · No injuriesLimited investigationFinal reportBell 206B · Grand Isle BlkWhile flaring to land on an off-shore platform, the plt noted a sudden vibration. He continued the landing; however, by the time the helicopter touched down, the vibration became severe & the acft turned to the right. An exam revealed that a midspan balance…NTSB FTW83LA371Accident · No injuriesLimited investigationFinal reportBell 206B · Venice, LAThe acft landed hard during an autorotation landing. The plt said he could not control the engine RPM with RPM switch onthe collective or the manual throttle control. N2 tended to go over 100 percent. The plt notified his company and planned for an…NTSB ATL83LA294Accident · Minor injuriesLimited investigationFinal reportBell 206B · Nr Gatlinburg, TNThe plt reported that he was beginning his apch to a landing site at an elevation of 5200 ft when he felt a bump in the tail rotor pedals. The helicopter begun to spin to the right & the plt found he has no tail rotor control. An autorotative landing was made…NTSB LAX83FA287Accident · Minor injuriesField investigationFinal reportBell 206B · Temecula, CAThe plt took off on a demonstration flt to familiarize the passengers with the helicopter. He reported that after takeoff, he proceeded northeast at about 100 to 150 ft AGL & 80 KTS in wind that was from the west at 25 gusting 30 KTS. After traveling about 3…NTSB FTW83LA218Accident · No injuriesLimited investigationFinal reportBell 206B · Thorndale, TXThe acft approached the field to be surveyed and collided with a wire at about 30 ft AGL. According to the plt during the actual survey the acft is hovered at low alt. When the plt saw the wire ahead the reported airspeed was about 20 ktsthe collective was…NTSB FTW83LA184Accident · No injuriesLimited investigationFinal reportBell 206B · Hempstead, TXAcording to the pilot the aircraft was in level flight at 800 feet AGL when the pilot experienced severe yaws in rapid rapid succession. He noticed he torque fluctuating between 30 and 100 pounds, went into autorotation and selected a landing spot heading…NTSB ANC83FA066Accident · Serious injuriesField investigationFinal reportBell 206B · Stony River, AKThe plt was on an external load operation with a 100 ft long line. The long line had 4 remote hooks, of which, 3 had cable bags attached. While waiting for the 4th bag to be filled, he decided to land in an open area. He set the external load down & laid the…NTSB LAX83FA154Accident · 1 fatalField investigationFinal reportBell 206 B III · Salinas, CAPurpose of flt was to transport a technician & his equipment to a mountain top to service a microwave antenna site. Cloud coverage precluded a landing at the site, but the plt was able to land in a clearing on the eastern ridge line about 100 yds below the…NTSB CHI83LA085Accident · No injuriesLimited investigationFinal reportBell 206B · Cincinnati, OHThe Bell 206 helicopter experienced fuel exhaustion during approach for landing at a helipad. During autorotation the pilot moved left to avoid a pickup truck on the off ramp of I-75 and collided with a light pole at about 10 feet AGL. The aircraft yawed…NTSB SEA83FA040Accident · No injuriesField investigationFinal reportBell 206B · Newport, ORThe helicopter was lifting off when the left skid stuck in the dirt. The acft did a dynamic rollover when the left skid remained stuck as the pilot attempted to takeoff. The pilot had just on-loaded two passengers both on the left side. Weather was not a…NTSB DEN83FA045Accident · 1 fatalField investigationFinal reportBell 206B III · Sula, MTThe helicopter crashed tail low and rolled over in an open field during marginal weather. The pilot was flying on an expired student certificate and expired medical. According to a pilot who had worked with him the pilot had no helicopter rating. Witnesses…NTSB DEN83LA022Accident · No injuriesLimited investigationFinal reportBell 206B · Near Kalispell, MTAcft departed hospital at missoula in good wx to assist highway accident victim 5 mi east of clinton. Victim was placed aboard helicopter on stretcher for emergency flight to hospital. About 5-6 mi east of missoula plt noticed light snow falling & observed a…NTSB FTW83LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Port O'Connor, TXThe pilot reported that when he took off at 1348 CST, the weather was 400 ft overcast, 2 to 5 mi visibility with rain. About 10 min later, he arrived at the Port O'Connor jetty and could see across matagorda bay to Port O'Connor. About halfway across the bay,…NTSB FTW83FA017Accident · 3 fatalField investigationFinal reportBell 206B · Gulf Of MexicoN55AL had departed vermillion block 84 at about 0956 enroute to vermillion block 39 with an ETA of 1010. The plt called at about 1011 stating he would be landing in about 1 minute. N9914K had departed vermillion block 64 at about 1010 enroute to vermillion…NTSB FTW83FA017Accident · 3 fatalField investigationFinal reportBell 206B · Gulf Of MexicoN55AL had departed vermillion block 84 at about 0956 enroute to vermillion block 39 with an ETA of 1010. The plt called at about 1011 stating he would be landing in about 1 minute. N9914K had departed vermillion block 64 at about 1010 enroute to vermillion…NTSB CHI82FA335Accident · 1 fatalField investigationFinal reportBell 206B · Dublin, OHA flight of 2 helicopters proceeded without incident from cumberland to the vicinity of Dublin, OH without incident. After they circled the area to determine the direction and the location of obstacles, the first helicopter landed without incident. The pilot…NTSB FTW82FRJ17Accident · Serious injuriesFinal reportBell 206B · Jamestown, LAThe pilot was conducting aerial burning operations over a wooded area when he heard a loud bang from the engine area of the helicopter. At that time, the helicopter was approximately 20 ft above the tallest tree in the area with the aerial torch burning. The…NTSB FTW82DA342Accident · No injuriesFinal reportBell 206B · Port Mansfield, TXThe helicopter was being ferried to shore from an oil rig when the tailrotor gear box failed and separated from the aircraft. The pilot autorotated to the water. Upon water contact the helicopter rolled over. The pilot had called his skipper on the radio as…NTSB FTW82DA323Accident · Serious injuriesFinal reportBell 206B · Grand Isle, LAThe pilot was approaching an offshore platform for landing at about 100 ft AGL when he felt the helicopter shudder. He also heard an engine-out horn and a low-rotor-rpm warning. He turned away from the platform, popped the emergency floats and initiated an…
Back to Bell 206B