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 ANC94LA103Accident · No injuriesLimited investigationFinal reportBell 206B · Chuit River, AKThe pilot's failure to maintain tail rotor effectiveness during hover.NTSB ANC94LA094Accident · Serious injuriesLimited investigationFinal reportBell 206 · Kenai, AKThe pilot attempting to operate the helicopter in an environment which exceeded the aircraft's performance envelope.NTSB SEA94FA190Accident · 1 fatalField investigationFinal reportBell 206B III · Syracuse, UTUndeterminedNTSB LAX94T#A06Accident · No injuriesClass 3Final reportBell 206-B3 · Tucson, AZNTSB MIA94LA144Accident · Minor injuriesLimited investigationFinal reportBell 206B · St. Petersburg, FLThe failure of the number five bearing, shaft, or thomas coupling for undetermined reasons. Contributing to the accident was the pilot-in-command's delayed response in conducting the emergency procedure by not reducing the throttle to idle position, and…NTSB CHI94LA161Accident · No injuriesLimited investigationFinal reportBell 206B · Winnebago, ILa wire strike due to failure to maintain proper altitude, and improper visual lookout by the pilot-in-command.NTSB LAX94T#A04Accident · No injuriesClass 3Final reportBell 206B · Overton, NVNTSB SEA94LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · Summerville, ORThe pilot did not maintain clearance from the wires. The overcast sky condiiton was a factor.NTSB MIA94LA116Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mayaguez, PRLoss of engine power for undetermined reasons which resulted in a descent and ditching.NTSB SEA94FA096Accident · 4 fatalField investigationFinal reportBell 206B3 · Lamoille, NVThe ingestion of foreign material (snow) in the engine, which resulted in a flameout (loss of engine power). Factors related to the accident were: the adverse weather conditions (snow falling & high density altitude), the lack of snow covers to protect the…NTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.NTSB ANC94LA042Accident · Minor injuriesLimited investigationFinal reportBell 206B · Wrangell, AKThe pilot-in-command's failure to assure that he had the proper clearance from obstructions prior to landing on the platform. A factor in the accident was the high obstruction (tree strump).NTSB MIA94WA094Accident · Serious injuriesForeign investigationBell 206BIII · Corozal, HondurasNTSB FTW94LA093Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Lake Charles, LAThe failure of the pilot to adequately perform a preflight. A factor was the soft terrain.NTSB SEA94LA057Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cathlamet, WALoad jettison was not performed.NTSB LAX94LA090Accident · 1 fatalLimited investigationFinal reportBell 206B · Coolidge Dam, AZthe pilot's selection of a cruise altitude insufficient to ensure adequate obstacle clearance and his inadequate visual lookout. A factor in the accident was the inconspicuousness of the power lines.NTSB LAX94LA075Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flagstaff, AZThe pilot's improper initiation of an emergency autorotation into unsuitable terrain and subsequent hard landing and rollover. A false annunciator indication, a failure of the N1 tach generator, the pilot's continued flight with a known aircraft defect, and…NTSB FTW94LA021Accident · 1 fatalLimited investigationFinal reportBell 206B · W. Cameron 240The pilot's failure to maintain proper altitude while maneuvering. Factors were his continued flight into known adverse weather and his self-induced pressure to complete the flight.NTSB FTW94LA019Accident · Minor injuriesLimited investigationFinal reportBell 206B · High Island 467Were the pilot's inadequate preflight inspection and his failure to remove all of the aircraft tie-downs.NTSB FTW93GA269Accident · No injuriesFinal reportBell 206B · Wht Sands Mr, NMThe pilot's failure to land an adequate distance away from the unsecured parachute.NTSB LAX93LA375Accident · 2 fatalLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)a loss of engine power for undetermined reasons.NTSB ANC93T#A05Incident · No injuriesClass 3Final reportBell BH-206B · Kantishna, AKNTSB MIA93T#A03Accident · No injuriesClass 3Final reportBell 206B · Cooper City, FLNTSB FTW93LA228Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXPilot's failure to maintain proper rotor RPM, the delayed flare, and improper touchdown. Factors were total failure of the power turbine due to oil starvation to the #8 bearing assembly.NTSB ANC93LA095Accident · No injuriesLimited investigationFinal reportBell B-3 · Annette Bay, AKThe failure of the tail rotor drive shaft coupling and the inadequate inspection of the tail rotor drive system by company maintenance personnel after the first tail rotor strike.NTSB LAX93LA258Accident · No injuriesLimited investigationFinal reportBell 206B3 · Stoneyford, CAthe pilot's inadequate compensation for the existing wind conditions during a hover operation. A factor in the accident was the high density altitude and the gusting, variable wind conditions.NTSB FTW93FA137Accident · 2 fatalField investigationFinal reportBell 206B III · Austin, TXAircraft control not maintained by pilot in command. Factors were unfavorable winds and pilot's lack of recent experience.NTSB FTW93TA#03Accident · No injuriesFinal reportBell 206B · Dallas, TXNTSB FTW93LA090Accident · Minor injuriesLimited investigationFinal reportBell 206B · Oklahoma City, OKThe passengers inadvertent control interference. A factor was the pilot's inadequate supervision of the passengerNTSB LAX93LA107Accident · Serious injuriesLimited investigationFinal reportBell 206B · Parks, AZ1) The pilot not obtaining forecast weather for his route of flight nor his destination 2) the pilot's inflight decision to fly into snow with the helicopter's engine air induction particle separator kit not installed, as required by the Bell 206B pilot's…NTSB LAX93FA093Accident · 2 fatalField investigationFinal reportBell 206B · Hayward, CAThe pilot's continued flight into known adverse weather conditions and continued VFR flight into instrument meteorological conditions. Contributing to the accident were dark night light conditions and rain.NTSB SEA93FA048Accident · 4 fatalField investigationFinal reportBell 206B3 · Ogden, UTThe pilot's continuation of VFR flight into instrument meteorological conditions, and his decision to continue his landing attempts under the adverse weather conditions. Factors contributing to the accident were the low clouds, fog and mountainous terrain.NTSB LAX93LA050Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Hilo, HIThe pilot's intentional flight in and near a volcanic gas cloud which induced a partial loss of engine power due to a lack of combustible oxygen in the atmosphere.NTSB ANC93LA015Accident · No injuriesLimited investigationFinal reportBell 206B III · Elf Point Camp, AKThe pilot misjudged clearance and dragged an external load longline cable while landing.NTSB CHI92FA232Accident · 2 fatalField investigationFinal reportBell 206B · St. Charles, MOThe pilot-in-command's failure to see and avoid the wires, and his physical impairment due to alcohol consumption. A factor which contributed to the effect of the alcohol impairment was the medicine.NTSB FTW92FA189Accident · 1 fatalField investigationFinal reportBell 206B3 · Block 651aThe pilot's failure to maintain the proper glidepath during the approach which led to an excessive nose high attitude during the landing flare.NTSB LAX92FA294Accident · 1 fatalField investigationFinal reportBell 206B · Twin Peaks, CAWas the pilot's decision to initiate the flight in known adverse weather and continued VFR flight into instrument meteorological conditions. Contributing to this accident was the low clouds and fog.NTSB ATL92LA132Accident · 1 fatalLimited investigationFinal reportBell 206B · Bessemer, ALThe pilots failure to maintain clearance from wires.NTSB FTW92GA080Accident · No injuriesFinal reportBell 206B III · Falfurrias, TXThe pilot's failure to maintain directional control due to his ability to maintain an adequate visual lookout being restricted. Factors were the observer's delay in informing the pilot of the rearward drift and the dark night conditions.NTSB LAX92LA134Accident · No injuriesLimited investigationFinal reportBell 206BIII · Glenbrook, NVFailure of the pilot-in-command to follow the helicopter's performance data while translating out of translational lift to and out of ground effect.NTSB SEA92FA045Accident · 2 fatalField investigationFinal reportBell 206B · Wellington, UTThe pilot's continued flight into adverse weather conditions and an excessive rate of descent. Factors contributing to the accident were fog, rain, low ceilings, night conditions, snow covered terrain and pilot disorientation.NTSB LAX92FA047Accident · 3 fatalField investigationFinal reportBell 206BIII · Davis, CAThe decision of the pilot to continue night low level flight in forecasted adverse weather conditions. Contributing to the accident was the foggy weather and dark night conditions which restricted the pilot's visual outlook.NTSB LAX92LA041Accident · Serious injuriesLimited investigationFinal reportBell 206B · Hilo, HIThe inadvertent encounter with a loss of tail rotor effectiveness phenomena and the resultant pilot inflight loss of control.NTSB SEA92FA016Accident · 1 fatalField investigationFinal reportBell 206B · Salt Lake City, UTThe pilot failed to maintain directional control. Factors to the accident were: inadeqaute remedial action, over confidence in personal ability, and lack of recent expereince.NTSB LAX92LA029Accident · 3 fatalLimited investigationFinal reportBell 206B · Vallejo, CAThe pilot's intentional flight into known adverse weather, continued flight into instrument meteorological conditions, and improper altitude. Contributing to the accident was low ceilings, poor visibility, and restricted visual lookout.NTSB SEA91FA184Accident · 1 fatalField investigationFinal reportBell 206B · Toutle, WAFailure of the pilot to maintain airspeed and correct for the right yawing condition. Factors to the accident were: inadequate compensation for wind conditions, diverted attention, and lack of total expereince in type of aircraft.NTSB FTW91LA121Accident · No injuriesLimited investigationFinal reportBell 206B · Freeport, TXThe pilot's failure to maintain sufficient rotor RPM during the autorotation. Factors were the fuel exhaustion induced power loss due to the pilot's improper pre-flight inspection.NTSB MIA91LA229Accident · No injuriesLimited investigationFinal reportBell 206B · Vero Beach, FLThe pilot-in-command's failure to maintain the proper descent rate resulting in a hard landing.NTSB DEN91FA068Accident · Serious injuriesField investigationFinal reportBell 206B-3 · Houston, TXEngine mount delamination and lack lubrication, causing the drive shaft to fail. Poor servicing of the helicopter was a related factor.NTSB LAX91LA205Accident · Minor injuriesLimited investigationFinal reportBell 206 · Searchlight, NVCannot be determined in that the helicopter was stolen and the certainty of the resulting damage to the helicopter may have been intentional or accidental.
Back to Bell 206B