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 ERA09CA249Accident · No injuriesData collectionFinal reportBell 206 · West Palm Beach, FLThe pilot’s failure to maintain aircraft control during taxi, which resulted in a dynamic rollover.NTSB ERA09WA183Accident · No injuriesForeign investigationBell 206B · St. Maarten, NTNone.NTSB ERA09LA047Accident · Minor injuriesLimited investigationFinal reportBell 206B · Boynton Beach, FLA loss of engine power due to an undertorqued air line fitting to the fuel control.NTSB WPR09LA010Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cougar, WAThe pilot's failure to maintain clearance between his external load and trees while maneuvering. Contributing to the accident were hilly terrain and trees.NTSB SEA08LA213Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woods Landing-Jelm, WYThe pilot's encounter with a loss of tail rotor effectiveness event and his failure to maintain directional control while maneuvering. Contributing to the accident were the tailwind condition and the sloping, uneven terrain.NTSB NYC08CA309Accident · No injuriesData collectionFinal reportBell 206B · Eutaw, ALThe pilot's inadequate preflight inspection.NTSB SEA08CA091Accident · No injuriesData collectionFinal reportBell 206B · Oxnard, CAThe pilot's failure to maintain clearance with terrain during an aerial application.NTSB ANC08LA004Accident · Serious injuriesLimited investigationFinal reportBell 206B · Prudhoe Bay, AKFuel starvation due to the blockage of fuel inlet screens, and improper service procedures by ground personnel.NTSB CHI08CA021Accident · Minor injuriesData collectionFinal reportBell 206B-III · Medora, NDThe pilot failed to maintain clearance from the fence while maneuvering at a low altitude, which resuled in the helicopter rolling over and impacting the terrain. A factor associated with the accident was the fence.NTSB SEA07CA258Accident · Minor injuriesData collectionFinal reportBell 206-B2 · Rosamond, CAThe pilot's inadequate compensation for gusting variable winds encountered after landing. Factors include gusting, suddenly shifting winds, and a hangar near the spot where the helicopter had landed.NTSB MIA07FA147Accident · 2 fatalField investigationFinal reportBell 206B · Nokomis, FLThe pilot's failure to maintain clearance from the water.NTSB MIA07LA148Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lakeland, FLThe failure of company maintenance personnel to replace the tail rotor drive shafts following tail rotor blade damage in 1999, the failure of maintenance personnel to replace the tail rotor drive shafts in 2004, following their knowledge that the tail rotor…NTSB NYC07LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Warrenton, VAThe flight instructor's failure to maintain adequate rotor rpm during touchdown.NTSB DEN07LA132Accident · Minor injuriesLimited investigationFinal reportBell 206B · Broomfield, COThe pilot's failure to maintain control of the helicopter, resulting in an inadvertent dynamic rollover.NTSB CHI07CA244Accident · Minor injuriesData collectionFinal reportBell 206B · Columbia, MOThe pilot's failure to maintain control of the helicopter, which resulted in impact with terrain during takeoff. A factor in the accident was the tall grass.NTSB SEA07CA200Accident · Minor injuriesData collectionFinal reportBell 206B II · Sheep Mountain, MTThe external load net, attached directly to the cargo hook without the use of a long line, oscillated and made contact with the tail rotor system while maneuvering.NTSB CHI07CA181Accident · No injuriesData collectionFinal reportBell 206B · Grand Forks, NDThe certified flight instructor's inadequate compensation for the gusting wind conditions and failure to maintain control of the helicopter during a hover for takeoff. A factor contributing to the accident was the gusting wind conditions.NTSB DFW07CA143Accident · Minor injuriesData collectionFinal reportBell BH206B-3 · Sand Springs, OKThe pilot's failure to maintain clearance with ground obstacles, which resulted in a blade strike. A contributing factor was the low altitude selected by the pilot.NTSB ATL07GA087Accident · Serious injuriesFinal reportBell 206B · Cedartown, GAThe pilot's failure to maintain control of the helicopter while maneuvering. Contributing to the accident were strong gusty winds.NTSB DFW07LA111Accident · Minor injuriesLimited investigationFinal reportBell 206B · Horseshoe Bay, TXThe pilot's loss of control as result of dynamic rollover while attempting to takeoff. Facrots were the landing skid becoming snagged and the soft terrain.NTSB DFW07LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · E. Cameron 219The pilot's failure to establish a climb and maintian directional control of the helicopter while departing the offshore platform.NTSB ATL07CA076Accident · No injuriesData collectionFinal reportBell 206-B · Sevierville, TNThe pilot's improper use of the flight controls while at a hover that resulted in the tail colliding with the ground, a subsequent hard landing, and collapse of the skids.NTSB NYC07CA084Accident · Minor injuriesData collectionFinal reportBell 206B · Lewes, DEThe pilot's inadequate visual lookout, which resulted in an in flight collision with utility wires during takeoff, and a subsequent impact with terrain.NTSB SEA07CA069Accident · No injuriesData collectionFinal reportBell 206 B3 · Custer, MTThe pilot’s failure to maintain clearance between the tail rotor of his helicopter and a piece of farm equipment during the landing sequence.NTSB LAX07CA034Accident · No injuriesData collectionFinal reportBell 206B · Boulder City, NVthe pilot's inadequate planning and decision in his failure to reduce the engine throttle to ground idle prior to exiting the helicopter.NTSB ANC06CA122Accident · No injuriesData collectionFinal reportBell 206B · Orlando, FLThe pilot's failure to refuel the helicopter prior to the accident flight, which resulted in a loss of engine power during cruise flight, and a hard landing.NTSB MIA06LA123Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLThe pilot's improper landing flare during a precautionary landing. A factor in the accident was the unusual noise as a result of an improper repaired air conditioner compressor system.NTSB CHI06FA173Accident · 1 fatalField investigationFinal reportBell 206B · Walford, IAThe pilot's failure to maintain clearance from powerlines. The powerlines were a factor.NTSB LAX06LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chino Hills, CAA loss of aircraft control for undetermined reasons.NTSB DFW06CA112Accident · No injuriesData collectionFinal reportBell 206B · Vinita, OKThe pilot's improper pre-flight planning, which resulted in a total loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06TA071Accident · No injuriesFinal reportBell 206B · Sprague, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering. Mountainous terrain was a factor.NTSB NYC06LA062Accident · Serious injuriesLimited investigationFinal reportBell 206B · Big Creek, KYThe pilot's inadvertent settling with power during a descent. Contributing to the accident was mechanical turbulence in the lee of an obstruction in windy conditions.NTSB MIA05CA160Accident · No injuriesData collectionFinal reportBell 206B3 · Titusville, FLThe flight instructor's improper flare resulting in a hard landing and main rotor contact with tail boom.NTSB CHI05CA271Accident · No injuriesData collectionFinal reportBell 206B · Elk Point, SDThe loss of directional control for undetermined reasons which led to the pilot not being able to maintain clearance from the embankment during the forced landing. The rising embankment was a factor.NTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB LAX05LA289Accident · Serious injuriesLimited investigationFinal reportBell 206B · Long Beach, CAthe pilot's decision not to release the banner when it became entangled on itself, which resulted in the banner tow rope becoming ensnarled with the tail rotor system.NTSB DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.NTSB DFW05FA217Accident · 2 fatalField investigationFinal reportBell 206B · Gulf of MexicoThe loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel calculations.NTSB MIA05CA134Accident · No injuriesData collectionFinal reportBell 206B · San Juan, PRThe inadequate preflight/planning by the pilot for his initiation of the flight with inadequate fuel supply, and his failure to maintain main rotor rpm following a total loss of engine power due to fuel exhaustion which resulted in a hard landing.NTSB DFW05LA123Accident · Serious injuriesLimited investigationFinal reportBell 206B · Huffman, TXThe pilot's inadequate preflight and his failure to disconnect the external load cable prior to takeoff.NTSB MIA05LA095Accident · Serious injuriesLimited investigationFinal reportBell 206B · Coral Springs, FLThe pilot encountered dynamic rollover while lifting off from an area in the everglades with 6-7 foot tall sawgrass nearby.NTSB ANC05CA049Accident · No injuriesData collectionFinal reportBell 206B · Elim, AKThe pilot's continued flight into adverse weather conditions, and his failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident are flat light, whiteout conditions,…NTSB DFW05FA086Accident · 3 fatalField investigationFinal reportBell 206B-3 · Shelbyville, TXThe pilot's failure to maintain altitude and clearance for undetermined reasons.NTSB MIA05FA055Accident · 1 fatalField investigationFinal reportBell 206B · Bonifay, FLThe pilot's failure to maintain a climb after takeoff and his continued descent which resulted in an in-flight collision with the ground. A factor in the accident was the dark night.NTSB NYC05CA047Accident · No injuriesData collectionFinal reportBell 206B · Lancaster, PAThe pilot's loss of lateral control while attempting to transition to a hover from the ground. A factor was the bright sunlight conditions.NTSB DFW05LA066Accident · No injuriesLimited investigationFinal reportBell 206B · Pinehurst, TXThe flight instructor's delay in taking remedial action, which resulted in a hard landing.NTSB DEN05LA024Accident · No injuriesLimited investigationFinal reportBell 206B3 · Eureka, UTthe pilot's improper in-flight planning and decision making and failure to maintain obstacle clearance, resulting in contact with a power transmission line. Contributing factors include the intentional low-level maneuver, the power transmission line, and the…NTSB DFW05LA017Accident · Serious injuriesLimited investigationFinal reportBell 206B · S.Timbelier 187The loss of engine power for undetermined reasons.NTSB ATL05CA003Accident · Minor injuriesData collectionFinal reportBell 206 B · Eutaw, ALThe pilots inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB MIA04LA129Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Starkville, MSThe operator's inadequate maintenance inspections and the pilot's inadequate preflight inspection, which resulted in the helicopter being operated with a contaminated fuel system, that resulted in fuel starvation, and the loss of engine power.
Back to Bell 206B