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 ('1181522')
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 ('1181522')
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 WPR24LA319Accident · No injuriesClass 3 · LimitedFinal reportBell 206L · Fern Prairie, WAAn aeroelastic interaction between the helicopter’s main rotor blades and nodal beam system, which resulted in oscillations that exceeded the design limits of the tailboom. Contributing to the accident was the failure of the main rotor blade manufacturer to…NTSB ERA16FA144Accident · 5 fatalField investigationFinal reportBell 206 · Pigeon Forge, TNAn inflight loss of engine power due to a failure of the engine fuel pump, which resulted in a collision with trees and terrain during the subsequent autorotation. The failure of the engine fuel pump resulted from the absence of adequate grease leading to…NTSB ANC08LA040Accident · Minor injuriesLimited investigationFinal reportBell 206L · Nikolai, AKThe pilot's inadequate compensation for wind conditions, and an inadvertent loss of tail rotor effectiveness while maneuvering. A factor contributing to the accident was wind gusts.NTSB NYC05FA099Accident · Serious injuriesField investigationFinal reportBell 206L · New York, NYThe pilot's inadequate preflight planning, which resulted in an attempted takeoff with an overweight helicopter, and subsequent impact with a pier and water. Factors were a high ambient temperature and unfavorable winds.NTSB MIA04LA132Accident · No injuriesLimited investigationFinal reportBell 206L · Gulf of MexicoA loss of engine power for undetermined reasons while on short final to land on an oil platform in the Gulf of Mexico, which resulted in the pilot ditching the helicopter into the water.NTSB SEA02FA008Accident · 3 fatalField investigationFinal reportBell 206L · Anchorage, AKThe pilot's failure to maintain clearance from the surface of an open body of water while intentionally attempting to maintain a very low altitude while in cruise flight. Factors include falling snow, low ceilings, whiteout/greyout conditions, and flat/glassy…NTSB FTW01IA061Incident · No injuriesIncident investigationFinal reportBell 206-L3 · Wc 368fuel exhaustion during approach due to the pilot's failure to refuel.NTSB CHI99LA298Accident · No injuriesLimited investigationFinal reportBell 206L · Cape Girardeau, MOThe inadequate preflight planning/preparation by the pilot, in that the auxiliary power unit cord was not removed. The brick wall was a contributing factor.NTSB CHI98FA159Accident · 4 fatalField investigationFinal reportBell 206L-1 · Arlington Hgts, ILLoss of helicopter control for unknown reasons.NTSB MIA95LA084Accident · No injuriesLimited investigationFinal reportBell 206L · Miami, FLThe failure of the pilot-in-command to maintain adequate engine power while maneuvering, his failure to take remedial action to recover from the resulting descent, and his decision to make a precautionary landing on the water.NTSB CHI95LA093Accident · No injuriesLimited investigationFinal reportBell 206L · Maryland Hts, MOFatigue failure of two attachment bolts that connected the driveshaft to the geared portion of a driveshaft coupling. Factors relating to the accident were: inadequate maintenance, uneven terrain in the touchdown area for the forced landing, and the…NTSB MIA94LA100Accident · Serious injuriesLimited investigationFinal reportBell 206L · Orlando, FLThe pilot's failure to cross-check a faulty engine speed indication with other engine performance indications to verify whether an engine malfunction had actually occurred, and his failure to maintain adequate rotor RPM during an emergency landing. The…NTSB LAX93FA316Accident · Serious injuriesField investigationFinal reportBell 206L1 · Tusayan, AZFailure of the pilot of N444CR to maintain adequate main rotor clearance from N38903, and the operator's failure to provide adequate or recommended safe helipad dimensions. A factor in the accident was the lack of visual reference to the rotating blades of…NTSB SEA92T#A05Accident · No injuriesClass 3Final reportBell 206L · Enterprise, ORNTSB NYC90FA067Accident · 1 fatalField investigationFinal reportBell 206L · New York City, NYThe pilot's misjudgement of the wind resulting in a downwind takeoff. Additionally the loss of lift when the helicopter flew off the heliport platform, prior to reaching effective translational lift, resulted in the helicopter settling into the water.NTSB MIA89LA024Accident · Minor injuriesLimited investigationFinal reportBell 206L · St. ThomasThe plt autorotated the helicopter into the water after a loss of power while transitioning from fwd flight to a hover. While landing with the emergency floats armed, he attempted to deploy the floats but was unable. The plt & pax evacuated. The helicopter…NTSB LAX88LA325Accident · No injuriesLimited investigationFinal reportBell 206L · Lihue, HIDuring a local sightseeing flight, the pilot reported that while on final approach for landing, the audio and light for low RPM sounded and illuminated. The helicopter was autorotated. It initially bounced when it touched down, then landed hard. The engine…NTSB NYC88DHD01Accident · No injuriesFinal reportBell 206L · Trenton, NJThe loss of engine power due to fuel starvation, and the pilot's poor aircraft handling during the autorotation.NTSB NYC87LA164Accident · Minor injuriesLimited investigationFinal reportBell 206L · Port Washington, NYThe plt of a Bell 206L made a downwind tkof with the acft loaded more than 100 lbs over the maximum allowable gross tkof weight. At an altitude of approx 100 ft, while complying with noise abatement tkof procedures, the plt experienced decreasing main rotor…NTSB MIA87LA133Accident · Minor injuriesLimited investigationFinal reportBell 206L · Miami, FLUnlicensed pilot lost control of helicopter while in hover while attempting to steal the helicopter. The aircraft crashed to earth and rolled over. The pilot was on probation for attempting to steal a helicopter on a previous occasion. The plt received minor…NTSB FTW87LA016Accident · Minor injuriesLimited investigationFinal reportBell 206L · Galveston, TXThe plt was attempting to hover in a tailwind of 35 KTS which exceeded the acft manufacturers performance limitiations for operations in allowable relative wind. The plt lost control of the acft on lift-off. The acft rolled over and came to rest on its right…NTSB MKC86FA037Accident · 3 fatalField investigationFinal reportBell 206L · Ainsworth, NEThis med-evac helicopter was being positioned to pick up a patient. The plt obtained a wx briefing which included a forecast for a chance of marginal VMC along the planned route, although at the time of the briefing the dest weather was VMC. The flt departed…NTSB ATL85FA170Accident · 2 fatalField investigationFinal reportBell 206L · Duluth, GAAfter loading a seriously burned patient in the helicopter, the plt started the eng & lifted off from the hospital parking lot. Immediately after lift-off, he started forward translational flt. About 65 ft from the lift-off point, an advancing main rotor…NTSB LAX85FA217Accident · Minor injuriesField investigationFinal reportBell 206-L1 · Kailua/Kona, HIA revenue sight-seeing helicopter flight operating under 14 CFR 91 collided with lava rock while attempting a forced landing on the summit of muana loa volcano after a partial loss of power. The pilot stated that while in a shallow downwind turn at aprx 200…NTSB ATL85FA112Accident · 4 fatalField investigationFinal reportBell 206L · Dauphin Island, ALPlt departed for offshore oil rig 3 times. Two times reported returning due to fog. After third report, plt said he was IFR. No further radio communication. Wreckage indicative of high speed water impact. Dense fog and low ceiling reported offshore south of…NTSB ATL82DA257Accident · No injuriesFinal reportBell 206L · Greenville, SCThe pilot reported that he was making an approach to a new helipad that was still under construction when he felt a severe vibration. After landing and shutdown, he discovered that the tail rotor had struck the glass cover of a heliport perimeter light.NTSB NYC82FHJ04Accident · Minor injuriesFinal reportBell 206L · New York, NYThe accident involved two Bell 206L helicopters that were parked beside one another, but headed in opposite directions. When the pilot of N49575 arrived, the other helicopter, N16696, was operating with the rotors at about 60% RPM (flight idle) while…NTSB FTW81DA129Accident · Serious injuriesClosedBell 206L · Leeville, LANTSB FTW80FA069Accident · 2 fatalClosedBell 206L-1 · Gibson, LANTSB CHI79DEX01Accident · No injuriesClosedBell 206 · Rockville, INNTSB OAK79FJA01Accident · Minor injuriesClosedBell 206L · Waimea Cnyn, HINTSB OAK78FJA09Accident · Minor injuriesClosedBell 206L · Lihue Kauai, HINTSB NYC78FA020Accident · 3 fatalClosedBell 206L · Courtney, PANTSB ANC78DA004Accident · Minor injuriesClosedBell 206-L · Deadhorse, AKNTSB NYC77FHD30Accident · Minor injuriesClosedBell 206L · Hightstown, NJNTSB IAD77IA057Incident · No injuriesClosedBell 206L · Poolesville, MDNTSB ANC77FA017Accident · Serious injuriesClosedBell 206L · Anchorage, AK
Back to Bell 206L