NTSB investigations
3,567 cases where the first occurrence was “In flight encounter with weather”.
Cases, newest first
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 LAX86LA187Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Hemet, CAA glider struck wires while on final apch to a field. The plt indicated that he was towed to an alt of 5,000 ft MSL (aprx 3,500 ft AGL). On release, he encountered a downdraft of more than 500 ft per minute and was only able to stay airborne 6 to 7 minutes.…NTSB SEA86LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Bonners Ferry, IDThe plt utilized updrafts to climb to 7800 ft to clear a mountain ridge which was covered with 'cap clouds'. On the lee side of the ridge a downdraft was experienced and the acft descended into the 'fog'. The plt reported the acft instruments were used to…NTSB MKC86LA094Accident · No injuriesLimited investigationFinal reportBeech A-90 · West Memphis, ARThe plt made a landing to a rain slick rwy at West Memphis, Arkansas. The plt stated the acft hydroplaned and that braking was negligible. The pic's attempts to use the reversers resulted in the acft yawing. Wind shifts in the rain showers extended the acft's…NTSB LAX86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Colusa, CAThe pilot reported that while on a pipeline aerial observation flight he encountered moderate to severe turbulence, snow showers and freezing rain. When he attempted to depart the area the aircraft began to shudder and vibrate to the extent that any further…NTSB LAX86FA178Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Beaumont, CAWhen the non-instrument rated plt departed for the flt at about 2110 hrs, the wx conditions were marginal and deteriorating in the area. No record of a wx briefing was found. For unkn reasons, the plt was returning to the arpt after about 1 hr and 20 mns,…NTSB NYC86LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westhampton Bch, NYThe instrument instructional flight returned to the airport late at night and successfully completed two instrument approaches with missed approaches. The pilots had been advised of a low layer of fog on the airport. On the third and final approach, after…NTSB DEN86LA116Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Wall, SDAccording to the plt he was making a precautionary landing due to wx, when the acft he was piloting encountered an unexpected crosswind just prior to touchdown. The plt said the left wing dipped & made contact with the ground. The impact resulted in…NTSB SEA86LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Pioche, NVWhile on a quarter mile final to runway 06 with winds from 150 degrees at 15 knots gusting to 30 knots the pilot experienced turbulence. The pilot reported he retracted the flaps from 10 degrees and added full power. The aircraft climbed approximately 20 feet…NTSB MKC86LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · St. Louis, MOThe plt reports that a wind squall passed over the arpt as he was landing. He said the acft encountered windshear at about 100 ft AGL on final apch and began to sink. The plt added pwr but could not stop the sink and the acft landed in a plowed field about 20…NTSB FTW86FA063Accident · 1 fatalField investigationFinal reportCessna 177RG · Dallas, TXThe pilot was advised by the FAA weather briefer, prior to flight, against making this flight due to present and forecast weather conditions. After arriving in the general area of his destination the plt observed the weather conditions and commented on thier…NTSB SEA86FA100Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Lone Pine, IDAfter an initial weather briefing the plt departed coeur dalene, Idaho, for his destination of Idaho falls, Idaho, with a planned passenger pickup at missoula, Montana. During the second leg of the flt he misnavigated while avoiding weather which resulted in…NTSB SEA86FA098Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Fort Hall, IDRadar track showed acft made normal climb on course from airport (elev 4488 ft MSL) to 9400 ft. MSL, then executed a left turn of about 90 degrees, climbing to 9700 ft MSL as shown by next-to-last radar tgt. 29 secs later, final radar tgt showed 6900 ft MSL.…NTSB DEN86FA112Accident · 3 fatalField investigationFinal reportCessna T-210N · Jay Em, WYThe non-instrument rated plt took off on a VFR flt into an area of forecast adverse wx. Radar track of the acft at 9,700 feet MSL was lost in the vicinity of the accident site at 0930 MST, 4/9/86. The acft wreckage was located at 1155 MST, 4/10/86 and was…NTSB NYC86LA101Accident · Serious injuriesLimited investigationFinal reportDouglas DC-10-30 · Jamestown, NYA sabena world airlines DC-10-30 descending from FL 410, enroute from detroit, mi to boston ma, encountered high altitude windshear as it was descending through FL 404. The pilot, passengers and flight attendents state that they felt vibrations prior to an…NTSB BFO86FA021Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Chesapeake, VABefore the flt, the plt was observed drinking in a bar. He & 3 others then drove to the arpt, where rprtdly, the wx was bad & the visibility was restricted by fog. After awhile, the plt stated he was going to taxi the acft around the arpt & invited the others…NTSB LAX86LA159Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Pheonix, AZThe Balloon collided with the terrain during a sight seeing tour. The plt noticed the dust signature of ground turbulent wx phenomena known as rotors or dust devils arpx 3 miles ahead. He elected to make an immediate precautionary landing and descended to an…NTSB LAX86FA160Accident · 2 fatalField investigationFinal reportBeech C35 · Etiwanda, CAThe flt was receiving radar advisories & was routine until the acft was aprx 15 mi east of the destination arpt. After radar svc was terminated, the acft subsequently turned toward the northwest & flew into rising terrain at an elevation of about 3000 feet.…NTSB DEN86LA107Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider L53 · Colorado Spring, COThe acft was making a landing due to an approaching thunderstorm. On final, the glider encountered moderate to severe turbulence and at 300 ft AGL, the glider was forced onto the ground by a microburst.NTSB FTW86LA048Accident · No injuriesLimited investigationFinal reportBeech H35 · Talihina, OKAcft had a long descent from cruise alt of 7500' MSL at reduced power setting due to plt's desire to avoid the moderate turbulence at lower altitudes. On short final, over tall trees, the acft encountered a downdraft. The plt stated that when he applied power…NTSB CHI86FA108Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Boyne Falls, MIAfter the plt was cleared for an rnav-b apch, the acft crashed on hilly trrn aprx 3 mi se of the arpt at an elev of 750'MSL. Impact occurred after the acft had turned to the sse & was dscndg. Min dscnt alt (mda) for the apch was 1680'. No preimpact mechanical…NTSB FTW86LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Waco, TXThe pilot of a Cessna 172, N758KU, over-shot his approach to a privately owned grass strip. The runway is 05/23, 3180 foot long and 100 foot wide with an approximate 300 ft. displaced threshold at east end. The wind was variable from 300 degrees at 8 knots at…NTSB LAX86FA140Accident · 3 fatalField investigationFinal reportBeech A36TC · Woodfords, CAThe wx deteriorated while the acft was cruising in IMC at 17,000 ft. moderate turbulence & icing conditions in the layered clouds were reported by other nearby flying acft. The plt informed ARTCC that he 'lost the autopilot,' & the acft's course began…NTSB ATL86LA096Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Stone Mountain, GAShortly after taking off at ngt, the plt encountered low visibility (vis) in fog. He attempted to return to the arpt for lndg, but the acft crashed in a wooded area aprx 3/4 mi from the arpt. A check of the plt's blood showed an alcohol lvl of 0.17 grams…NTSB DCA86AA021Accident · 3 fatalFinal reportEmbraer EMB-110P1 · Alpena, MIDrg arrival at 2125 EST, simmons airline flt 1746 was adzd by wurtsmith afb apch ctl that the 2052 EST wx at phelps collins arpt was: sky partially obscd, ceiling 100' overcast, vis 1/2 mi with lgt drizzle & fog, & to expect an ILS apch. However, at 2119, a…NTSB ATL86FA092Accident · 1 fatalField investigationFinal reportPiper PA-23 · Toledo, OHN3124P crashed while attempting an ILS approach to rwy 07 at express airport in Toledo, OH. The pilot had attempted an approach at metcalf airport but missed the approach because of the weather. The aircraft crashed about 1 mile short of the airport in a…NTSB DEN86FA098Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Truth&Consequen, NMThe plt took off on a night IFR flt after being briefed on adverse wx which included severe turbulence and moderate mixed icing conditions. The acft was not equipped for flt in icing conditions. Radio and radar contact with the flt was lost in the vicinity of…NTSB DEN86LA096Accident · No injuriesLimited investigationFinal reportCessna R172K · Ft. Bridger, WYAccording to the plt, he and his passenger were ferrying an acft back to the point of origin after a sar mission for the civil air patrol, when they encountered IMC weather. The plt stated he was making a precautionary landing on a dirt road when the acft…NTSB LAX86LA134Accident · No injuriesLimited investigationFinal reportBurkhart Grob 102 · Tehachapi, CAGrob 102 glider collided with trees 6 mi s of the apt. The plt was soaring 2 mi s of the apt at 5900 ft MSL and 6200 ft MSL in 'weak lift.' He elected to fly further s in the vic of a ridgeline with an elev approx 6000 ft MSL. Again the plt experienced 'weak…NTSB CHI86FA096Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Honolulu, HIThe scheduled passenger flight from Honolulu to chicago encountered clear air turbulence (cat) about 500 NM east of Honolulu while in cruise flight at flight level 330. The turbulence was unexpected, had not been forecast, and the fasten seat belt was not…NTSB LAX86FA130Accident · 2 fatalField investigationFinal reportEnstrom 280C · Ontario, CABfr deptg tucson, AZ on a return flt to long beach, CA, 2 student helicopter plts (the owners) were advised VFR flt was not rcmdd due to low ceiling/vis at the destn. Neither plt was endorsed for x-country flt. En route, they lndd/refueled at gila bend &…NTSB FTW86LRG15Accident · Minor injuriesFinal reportBalloon Works 8B · Round Rock, TXThe Balloon was damaged during landing in a wind of 15 KTS gusting to 40 KTS. The plt said that the surface wind increased during the flt. The Balloon was blown about 900 yds while dragging the basket across a grass field during the landing.NTSB SEA86LA067Accident · No injuriesLimited investigationFinal reportGulfstream 690C · Ketchikan, AKWhile at 4700 ft MSL, on a DME hold awaiting clearance for an ils/dme apch, severe turbulence was encountered. The plt was aware of turbulence in the area.NTSB NYC86LA079Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Lyndonville, VTAfter the pilot performed a run up and all appeared normal a ground run was commenced. About 700' down the runway trim was set to climb out at about 76IAS. However, the pilot stated that a bad downdraft was encountered. A check of the airspeed was ok. At 200…NTSB SEA86LA064Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mount Baldy, IDThe pilot allowed the aircraft to enter into instrument meteorological conditions. The artificial horizon was inoperative as well as the turn portion of the turn and bank. A tree was struck with the aircraft then striking the ground.NTSB ATL86FA081Accident · 1 fatalField investigationFinal reportRobinson R22 · Greenville, TNThe flt was last seen to depart rwy 23 at the Greenville arpt & enter a low cloud layer at ngt. A witness estimated the helicopter entered the clouds at about 300 to 400 ft AGL. No flt plan was filed. The wreckage was found the next day, located about 1/4 mi…NTSB SEA86LA065Accident · No injuriesLimited investigationFinal reportCessna 206G · Icy Point, AKA precautionary landing was made due to deteriorating weather. Landing was accomplished onto a frozen slough. During touch down during high gusty crosswinds the aircraft veered right with the right gear breaking through the ice. The aircraft bounced up onto…NTSB SEA86LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-15 · Mount St.Helens, WAThe pilot was attempting to fly inside a volcanic crater around the lava dome above 6000 feet m.s.l.. The aircraft has a 75 horsepower engine. High winds entering the crater from the northeast flowing across the lava dome created a downdraft that the aircraft…NTSB SEA86LA060Accident · No injuriesLimited investigationFinal reportCessna 340 · Burns, ORThe aircraft encountered airframe icing on a descent for a VOR approach. 1/8 to 1/4 inch of ice was present during landing. The pilot allowed a stall to occur prior to touch down with a hard landing resulting.NTSB DEN86LA079Accident · Minor injuriesLimited investigationFinal reportBell 47G3 B-2 · Grand Junction, COThe plt stated that while turning to the intended landing area, the helicopter he was piloting encountered both downdrafts & tailwind. The plt indicated the helicopter settled until grnd contact.NTSB ATL86FA074Accident · 1 fatalField investigationFinal reportCessna 303 · Shippenville, PAN4877V arrived over clarion county airport at about 2100 hours, and commenced a visual approach for landing. Marginal visual weather conditions prevailed at the time of the accident. The flight was observed by another pilot waiting on the ground for the…NTSB SEA86FA056Accident · 3 fatalField investigationFinal reportMcDonnell Douglas 369D · Cougar, WAThe helicopter departed the landing area after a night photography session across the valley floor from the Mt. St. Helens volcano. Prior to departure the plt reported the weather was closing in and getting 'nasty'. Wx conditions as reported prior to…NTSB ANC86MA027Accident · 3 fatalMajor investigationFinal reportCessna 207 · Nome, AKThe acft departed during a break in the wx after having waited for a special VFR departure. His departure radio call was the last communication from the flt. The wx remained marginal with icing in the clouds and freezing drizzle. The acft was on a flt to…NTSB LAX86LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Joshua Tree, CAOn feb 28 1986, at 0830 PST, a Piper PA-28 collided with a Tree after a forced landing. IMC prevailed at the time. A/c flew into deteriorating weather conditions enroute and climbed to 11,000 feet MSL to get above it. During the climb IMC was encountered.…NTSB DCA86IA017Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Harlingen, TXWhile en route, the company dispatcher notified American flt 844 (via acars) that Harlingen (hrl) had unforecast fog & was 300' obscd with 1/2 mi vis. At 2335, as the flt bgn a dscnt fm FL 310, the same ceiling & vis were rprtd. However, as the flt was clrd…NTSB LAX86FA106Accident · 1 fatalField investigationFinal reportBell 206B · Young, AZThe plt & his daughter planned to fly to their ranch for the purpose of hiring a manager. Upon arriving at their destination ground fog prevailed. The plt, familiar with the area, attempted to find an area where he could descend below the fog. The fog was at…NTSB DEN86FA071Accident · 1 fatalField investigationFinal reportCessna 180 · Kalispell, MTThe plt received a wx briefing and filed an IFR flt plan to Boeing field, seattle, WA. He departed Kalispell, MT, at 1135 MST. When the plt arrived in the spokane area, he obtained wx reports for seattle and decided to turn around and return to Kalispell. Wx…NTSB LAX86FA102Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bridgeport, CADrg flt over mountainous terrain, the plt encountered instrument meteorological conditions along his route of flt. A witness observed the acft flying at about 200 ft AGL under a cloud layer, then it disappeared in a snow shower. A search was initiated & the…NTSB LAX86FA099Accident · 1 fatalField investigationFinal reportCessna 172A · Strathmore, CAUpon returning to his home airport, the non-instrument rated pilot was unable to see the runway due to heavy fog covering the area. He entered a right descending turn in an attempt to descend under the fog. The aircraft collided with orange trees…NTSB LAX86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Lake Havasucity, AZOn January 25, 1986 a Cessna 182 collided with the runway surface after the nose wheel collapsed on runway 5 at lake havasu city airport, Arizona. VMC prevailed at the time with the UNICOM reported winds from 270 degrees at 17 knots and gusting. The…NTSB FTW86LRA07Accident · Serious injuriesFinal reportBell 206L-1 · Sabine Pass, TXAcft encountered deteriorating weather enroute from shore to an oil rig that was under tow in the gulf of Mexico. Upon encountering IMC conditions, the plt climbed to 600' AGL for better obstacle clearance and turned back toward the beach. During a subsequent…