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 CEN14LA390Accident · No injuriesLimited investigationFinal reportBell 206B · Bennet, NEA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.NTSB WPR14CA319Accident · No injuriesData collectionFinal reportBell 206B · Salinas, CAThe pilot's failure to ensure adequate clearance from ground obstacles during takeoff which resulted in loss of aircraft control.NTSB CEN14LA296Accident · Minor injuriesLimited investigationFinal reportBell 206B · Decatur, TXThe flight instructor’s improper recovery from a practice autorotation, which resulted in a hard landing.NTSB WPR14LA113Accident · No injuriesLimited investigationFinal reportBell 206 · Bountiful, UTThe pilots' inaccurate assessment of the snow depth on the landing zone, which resulted in a landing on snow deeper than that for which the helicopter was equipped and led to dynamic rollover.NTSB CEN14CA098Accident · No injuriesData collectionFinal reportBell 206B · Temple, TXThe pilot's loss of control while landing on a mobile helipad.NTSB WPR14CA041Accident · No injuriesData collectionFinal reportBell 206B · Superior, MTThe pilot's failure to maintain aircraft control while maneuvering during a long-line operation.NTSB WPR14CA052Accident · Serious injuriesData collectionFinal reportBell 206B · Milo, ORThe pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.NTSB WPR13LA358Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chualar, CAMaintenance personnel's failure to properly tighten the bolts securing the main driveshaft to the transmission, which resulted in fatigue failure of the bolts and disconnection of the driveshaft during low-altitude flight.NTSB WPR13LA287Accident · Serious injuriesLimited investigationFinal reportBell 206B · Royal City, WAThe pilot's failure to maintain clearance from netting material during a low pass over trees, which resulted in a loss of helicopter control.NTSB CEN13WA329Accident · 4 fatalForeign investigationBell 206B · San Luis Potosí, MexicoNTSB CEN13LA378Accident · No injuriesLimited investigationFinal reportBell 206B · St Louis, MOThe loss of engine power due to the separation of compressor blades, which resulted from fatigue cracking.NTSB ERA13LA236Accident · No injuriesLimited investigationFinal reportBell 206B · Hartford, KYThe pilot’s failure to avoid a powerline that crossed a field that he was spraying. Contributing to the collision was the company’s failure to specifically mention that flight hazards be identified during a pre-work conference.NTSB WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.NTSB WPR13CA204Accident · No injuriesData collectionFinal reportBell 206B · Wells, NVThe pilot's failure to maintain clearance from an obstacle while maneuvering at a low altitude.NTSB WPR13GA128Accident · 1 fatalFinal reportBell 206B · Eureka, NVThe pilot’s failure to maintain clearance from a wire while maneuvering during low-altitude operations. Contributing to the accident was task- and/or work-related fatigue.NTSB CEN13LA158Accident · No injuriesLimited investigationFinal reportBell 206B III · Ponderosa, NMA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR13FA119Accident · 3 fatalField investigationFinal reportBell 206B · Acton, CAThe pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…NTSB CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.NTSB WPR12LA426Accident · No injuriesLimited investigationFinal reportBell 206 - B · Mammoth Lakes, CAThe pilot’s inability to maintain sufficient main rotor rpm while maneuvering in high density altitude conditions, which resulted in a precautionary landing and subsequent rollover.NTSB WPR12CA236Accident · No injuriesData collectionFinal reportBell 206B · Burbank, WAThe failure of maintenance personnel to properly torque an air tube fitting, which resulted in a total loss of engine power.NTSB ERA12LA366Accident · No injuriesLimited investigationFinal reportBell 206B · Longboat Key, FLUnknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.NTSB CEN12LA282Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flora, INThe pilot allowed the helicopter to settle with power.NTSB CEN12LA267Accident · Minor injuriesLimited investigationFinal reportBell 206B · Valley Falls, KSThe pilot’s inadequate compensation for the wind conditions during a hover maneuver, which resulted in a loss of tail rotor effectiveness.NTSB ERA12CA304Accident · Serious injuriesData collectionFinal reportBell 206B · Hershey, PAThe pilot's diverted attention while performing aerial application at low altitude, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to adjust the control friction to the position he was accustomed.NTSB CEN12LA258Accident · Minor injuriesLimited investigationFinal reportBell 206B · Amarillo, TXThe pilot's failure to maintain helicopter control during landing in gusty wind conditions associated with a thunderstorm, which resulted in a loss of tail rotor effectiveness.NTSB WPR12CA183Accident · No injuriesData collectionFinal reportBell 206B · Arvin, CAThe pilot did not maintain clearance from power lines during low altitude maneuvering.NTSB ERA12LA210Accident · Minor injuriesLimited investigationFinal reportBell 206B · Titusville, FLThe flight instructor's attempted takeoff in gusting wind conditions while the student pilot was adjusting her anti-torque pedals, which resulted in a dynamic rollover event.NTSB CEN12LA141Accident · No injuriesLimited investigationFinal reportBell 206B · Irving, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB ERA12MA122Accident · 3 fatalMajor investigationFinal reportBell 206B · Green Cove Springs, FLThe pilot’s improper decision to continue visual flight into night instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the pilot’s improper decision was his self-induced pressure to complete the trip.NTSB WPR12LA036Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodburn, ORThe pilot’s failure to maintain ground clearance while maneuvering with an external load line.NTSB ERA12MA005Accident · 2 fatalMajor investigationFinal reportBell 206B · New York, NYThe pilot's failure to anticipate and correct for conditions (high gross weight, low indicated airspeed, and a right downwind turn) conducive to loss of tail rotor effectiveness (LTE), which resulted in LTE and an uncontrolled spin. Contributing to the…NTSB CEN11LA646Accident · No injuriesLimited investigationFinal reportBell 206B · Spicewood, TXThe pilot did not maintain adequate rotor rpm during a low-altitude maneuvering flight.NTSB CEN11CA509Accident · No injuriesData collectionFinal reportBell 206B · Temple, OKThe pilot’s failure to maintain clearance from static power lines.NTSB WPR11TA274Accident · No injuriesFinal reportBell 206B · Franklin, CAThe student pilot's failure to maintain rotor rpm during the practice autorotation.NTSB WPR11CA243Accident · No injuriesData collectionFinal reportBell 206B3 · Glendale, AZThe certified flight instructor's failure to maintain adequate main rotor RPM during the autorotation.NTSB CEN11CA303Accident · Minor injuriesData collectionFinal reportBell 206 · Venice, LAThe pilot's improper use of the collective and cyclic control during taxi operations, which induced a dynamic rollover.NTSB WPR11CA101Accident · No injuriesData collectionFinal reportBell 206B3 · Three Forks, MTThe pilot’s inadequate use of throttle during the practice autorotation that resulted in a hard landing.NTSB ERA11LA083Accident · Minor injuriesLimited investigationFinal reportBell 206B · Isom, KYThe pilot's failure to maintain clearance from a known wire hazard during an aerial observation flight.NTSB CEN11FA053Accident · 1 fatalField investigationFinal reportBell 206 · Meeker, COThe pilot's failure to maintain clearance from electrical power lines during the low-altitude flight.NTSB CEN11GA020Accident · 1 fatalFinal reportBell 206B · Clarkson Valley, MOThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and decision-making, and his improper control inputs following the loss of engine power, which resulted in mast bumping and separation of the…NTSB WPR11LA016Accident · No injuriesLimited investigationFinal reportBell 206B · Auburn, CAThe pilot's failure to maintain clearance from a transmission line during flight.NTSB CEN11LA023Accident · Serious injuriesLimited investigationFinal reportBell 206B · Newton, TXThe pilot’s attempted takeoff with the fuel hose attached to the helicopter and the pilot and ground crew’s failure to accurately communicate.NTSB CEN10CA446Accident · Minor injuriesData collectionFinal reportBell 206 · St. Olaf, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.NTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.NTSB WPR10CA314Accident · No injuriesData collectionFinal reportBell 206B · Rickreall, ORA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to ensure that adequate fuel was aboard for the flight.NTSB ERA10TA292Accident · No injuriesFinal reportBell 206B · Memphis, TNThe pilot’s failure to maintain adequate rotor rpm and the certificated flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB WPR10CA100Accident · No injuriesData collectionFinal reportBell 206B · Kalispell, MTThe pilot's failure to maintain lateral drift control during landing.NTSB WPR10GA097Accident · 4 fatalFinal reportBell 206B · Auberry, CAThe pilot's failure to see and avoid a wire while maneuvering during low-altitude operations.NTSB ERA10LA032Accident · Serious injuriesLimited investigationFinal reportBell 206 · Eupora, MSA loss of engine power due to fuel contamination of the helicopter’s fuel supply.NTSB WPR09CA338Accident · No injuriesData collectionFinal reportBell 206B · Burlington, WAThe pilot’s failure to maintain control of the helicopter while attempting to lift off from a trailer. The helicopter subsequently impacted the ground and rolled over.
Back to Bell 206B