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 DEN86FA020Accident · 1 fatalField investigationFinal reportPiper PA-230-250 · Englewood, COThe plt had new avionics and autopilot system installed in the acft prior to the accident. Ntap data indicated that the acft did not attain the assigned alt of 8200 ft prior to reaching the outer marker. The acft did not get established on the localizer…NTSB LAX86LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Mammoth Lakes, CAThe plt reported that when he observed the arpt's wind sock in preparation for departure the wind was blowing down the rwy with occasional gusts that did not seem over 20 KTS. After taking off & climbing to abt 100 ft AGL, the acft encountered turbulence…NTSB ATL86LA016Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Charleston, WVThe flight departed Washington at about 1040 en route to Charleston, WV under instrument flight rules. The flight proceeded without incident, with occasional light to moderate turbulence during the climb. As the flight climbed through 26,000 feet the aircraft…NTSB ATL86LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Meridian, MSThe non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended for a flight to chattanooga, TN. The pilot was unable to maintain VFR conditions and attempted a precision approach. While being…NTSB NYC86LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Great Valley, NYAcft experienced windshear while landing at Great Valley, n.y. the plt attempted to make a go around, but was unsuccessful and landed in a corn field. The acft was substantially damaged, however, the private certificated plt was uninjured.NTSB FTW86FA019Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Ozona, TXThe acft was observed apchg the destination while flying under a cloud cover of aprx 1000 ft AGL. When it reached the vicinity of the arpt, the plt made a turn & subsequently entered the clouds. A witness heard what he described as variations in eng power.…NTSB NYC86FA027Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Landisburg, PAThe non-instrument rated pilot took off on a VFR crosscounty flight with no weather briefing. He flew into an area of adverse weather including low clouds, fog, drizzle & haze. The aircraft impacted near the top of a 2100 ft high hill in forested terrain.NTSB ATL86FA010Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Hamilton, ALAt 1450 CDT, while the plt was cruising at 11,000', ARTCC broadcast info concerning SIGMET 17C, warning plts of thunder-storms with tops to FL 450. At 1613, radar data showed the acft at 11,300'. When asked about his alt, the plt replied he was in a cell &…NTSB ATL86FA009Accident · 2 fatalField investigationFinal reportCessna 172N · Clayton, GAThe pilot and his passenger showed up for the second day in a row and checked the weather for the return trip to Florida. They found the weather VFR at the airport. An employee of the FBO took the pilot outside and pointed out that the mountains to the south…NTSB SEA86LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Ely, NVThe consensus of witnesses was that the plt & 2 pax had been awake all or most of the previous night & had consumed alcoholic beverages until at least 0100 PDT. One witness stated that the plt was 'cut off' from alcoholic drinks at 0100, but the 3 men…NTSB NYC86FA015Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Tobyhanna, PAAt about the time N4298K was departing pocono mountains mun icipal airport, recorded radar information from new york ARTCC displayed an aircraft in that area. The aircraft flew eastward and then northward. The aircraft disappeared from the radar screen about…NTSB MKC86LA013Accident · No injuriesLimited investigationFinal reportBeech H-18 · Osage Beach, MOOn fianl approach to land on rwy 14 at the linn creek/grand glaize airport the plt began to apply prw to the two engines to arrest the descent of the approach. The plt finally had full pwr applied but the acft impacted. The ground short of the rwy. The plt…NTSB FTW86FA015Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-2D · El Paso, TXThe plt canceled his IFR flt plan and attempted to fly VFR at a relatively low alt over mountainous terrain with low scattered clouds on a dark night. He reported a large lighted area as being downtown El Paso when in reality it was most likely coronado…NTSB FTW86FA011Accident · 2 fatalField investigationFinal reportCessna 180 · Cisco, TXNon-instrument rated pvt pilot proceeded into instrument weather conditions. Control was lost and the aircraft impacted steep nose down in city limits. No record of a wx briefing being received by the pilot was found. No evidence of pre- impact failure or…NTSB DEN86LA011Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Kalispell, MTThe plt stated that while on a return flt to calgary, alberta, Canada, over the mountainous terrain of glacier national park, he encountered a severe downdraft which forced the acft to the ground. The flt originated at kaispell, Montana.NTSB NYC86LA009Accident · No injuriesLimited investigationFinal reportMaule MX 7-235 · Westerly, RIThe acft groundlooped during lndg. The plt reported that a sudden gust of wind was the cause. The sind was reported as calm.NTSB DEN86FA009Accident · 4 fatalField investigationFinal reportCessna 180 · Eagle, COThe plt departed Eagle arpt with 3 pax to fly them to the white owl lake area for the reported purpose of looking for a possible camping site for hunting activities. The plt encountered IMC and lost control of the acft. He was not instrument rated. All…NTSB DEN86FA008Accident · 2 fatalField investigationFinal reportCessna 175A · Jal, NMA witness watched the acft takeoff and disappear in the darkness. The plt had intended to make 3 takeoffs and landings to regain currency for night flying. The acft never returned. The wreckage was found 2 miles north of the arpt the following morning. Wx was…NTSB FTW86FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Pecos, TXThe non-instrument rated pvt plt departed on a night flt with wx reported as 300 and 2 in fog and drizzle. Acft impacted terrain shortly thereafter in a 60 degree nose down attitude. The plt had told a friend that after depature he would acquire and then…NTSB DEN86LA005Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Fillmore, UTThe plt departed delta, UT on a VFR x-c flt after being advised by fss that VFR was not recommended due to IMC conditions on the proposed route of flt. He flew into an area of rising terrain, encountered IMC wx conditions, attempted to reverse course and…NTSB LAX86FA007Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Payson, AZThe passenger had a 10:00 medical appointment at the destination arot on the day of the accident. The non-instrument rated, recently certificated pvt plt, requested and received a weather briefing for a proposed VFR flt at 7500 ft MSL from mesa to holbrook,…NTSB NYC86LA003Accident · Serious injuriesLimited investigationFinal reportCessna C206 · West Dover, VTCessna aircraft, N9861Z overran runway 1, at West Dover, Vermont and landed on a golf course. The pilot stated that when the flight was about 50 feet above the runway and about 100 ft down the runway windshear was encountered, pulling the aircraft to the left…NTSB LAX86FA003Accident · 3 fatalField investigationFinal reportGulfstream AA-5B · Orinda, CAThe acft collided with rising terrain on a southerly heading. A VFR flt plan was filed. A witness near the accident site reported low ceilings and a forward ground visibility of 50 ft. aprx 15 minutes prior to the accident the acft was seen flying southeast…NTSB DEN86LA006Accident · Minor injuriesLimited investigationFinal reportSkypower GBN-41-100 · Pecos, NMFlt was participation in the 1985 balloon fiesta, a night helium-filled balloon race from albuquerque, new Mexico, to elkhart, Kansas. One hr after launch plt encountered small wind shear, causing loss of altitude, ballast, and helium. Plt then encountered…NTSB NYC86FA002Accident · 3 fatalField investigationFinal reportCessna C-377A · Breakabeen, NYThe plt was advised by several sources that bad wx was located along the intended route of flt. The plt stated that he intended to fly over the bad wx since wx at the destination was good. A mayday call from 24J was broadcasted over the emer. Freq. Witnesses…NTSB FTW86MA010Accident · 4 fatalMajor investigationFinal reportBeech V35 · Bridger, MTDrg a preflt wx briefing, the plt was advised that VFR flt was not recommended due to forecast frontal activity moving southbound along his route. Severe turbulence & icing had been reported just to the north of his course. He filed a VFR flt plan & took off…NTSB ATL86LLQ01Accident · Minor injuriesFinal reportCessna 172 · London, KYThe acft crashed during a forced landing after fuel exhaustion during a x-country flt. The plt had encountered wx and in attempting to reach an alternate arpt the acft ran out of fuel. The plt was not instrument rated and the wx at London was 600 ft overcast…NTSB ATL86FA002Accident · 4 fatalField investigationFinal reportGrumman American AA-5 · Hurricane, WVN9629U crashed in a wooded area near Hurricane, west Virginia while conducting a visual flight from millwood, WV to grundy, Virginia. The pilot and aircraft were certificated in accordance with current FARS. The pilot received a weather briefing for the…NTSB SEA85LA229Accident · No injuriesLimited investigationFinal reportCessna 185 · San Juan Island, WAThe pilot was attempting to depart his private airstrip to the north with trees bordering the north end of the airstrip. The wind was from 360 at 20 knots gusting to 30 knots. The pilot was unable to arrest his rate of sink and made a right turn to avoid…NTSB ANC85FA184Accident · 3 fatalField investigationFinal reportde Havilland DHC-2 · Merrill Pass, AKThe acft collided with terrain in a mountain Pass at an elevation of 3600 ft MSL. The plt obtained a wx briefing at 1329 gmt on 9/26/86 at which time Merrill Pass was forecast to be closed by 1100 adt due to deteriorating wx. The last radio communication with…NTSB ATL85FAMS2Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Gulfport, MSPlt contacted apch control for advisories. Asked about wx onroute of ELT. Was told that lines of showers existed across path. Plt advised he thought he had found a gap and that he thought he could get over wx. Later radioed that ride was bouncy and he was in…NTSB FTW85LA353Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Plainview, TXThe acft was substantially damaged during an emerg landing following an eng failure due to fuel exhaustion. Plt stated that during the 2nd leg of his flt, the ceiling and visibility deteriorated to the point that he was unable to find the arpt at his…NTSB MIA85FA254Accident · Serious injuriesField investigationFinal reportMooney M20F · Aripeka, FLThe student plt stated that after dinner, which included a small amount of wine, he went to the arpt to clean his acft, then elected to go for a short flt. He intended to stay within 25 mi of the arpt, but found himself over lakeland. He landed at a strip to…NTSB FTW85FA346Accident · 1 fatalField investigationFinal reportPitts SPL. S-1 · Mclean, TXThe plt had landed the Pitts special on the highway due to low fuel. After the fuel service the acft took off and the plt performed low altitude acrobatics then departed making slow rolls below a low overcast. A witness observed the acft flying low over the…NTSB ANC85LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Togiak, AKAcft crashed on mountainside after wx worsened. Marginal wx had been forecast & PIREP advised plt that VFR flt was not recommended.NTSB FTW85LA344Accident · 1 fatalLimited investigationFinal reportMooney M20J · Kraemer, LAAcft was descending from cruise alt when it entered a radar lvl 3 thunderstorm and control was lost during a night VFR flt. The acft impacted a swamp in a vertical attitude with the rt wing leading slightly. The lft wing was found about 10' south of the main…NTSB SEA85FA211Accident · 1 fatalField investigationFinal reportBell 206B · Emmett, IDNewly-licensed plt departed into mountainous terrain in thunderstrom conditions despite warnings from friends. The acft wreckagewas located two days later in rising terrain below power 11 miles from pt of departure. Investigation revealed high speed vertical…NTSB DEN85FA236Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Saint Mary, MTPlt received wx update enroute to kalispell, MT. He attempted to navigate through the glacier national park, following the 'going-to-the-sun' highway. The wx along the plt's route of flt included low cloud ceiling, limited visibility and mountain obscurement.…NTSB LAX85LA380Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Julian, CAThe acft collided with rising terrain on a local flt. The pax indicated that the plt was flying below the clouds and came too close to the mtn to avoid the collision.NTSB DEN85LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot said that during his approach to ldg he encountered a downdraft. He subsequently lost control of the a/c. the a/c stalled and impacted the grd hard causing subst damage.NTSB MKC85LA204Accident · Minor injuriesLimited investigationFinal reportGrumman AA5 · Boone, IAAfter departing laporte city airport the plt of the acft proceeded to his destination airport despite deteriorating weather conditions at this destination. The plt stated he should not have proceeded into poor weather conditions. Weather conditions at the…NTSB LAX85LA394Accident · No injuriesLimited investigationFinal reportGlasflugel ST Liebelle 201B · California City, CAThe glider landed off the arpt on a road and groundlooped after colliding with shrubbery. The plt complained of encountering a downdraft during the flt.NTSB DEN85FA233Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Ogden, UTThe plt and his party were en route from minden, NV to casper, WY and had stopped at Ogden, UT to refuel. The plt obtained an updated wx briefing fr fss and field an IFR flt plan. After takeoff the plt was told to climb in the holding pattern to 13000 ft.…NTSB NYC85FA227Accident · 2 fatalField investigationFinal reportCessna 150M · Danby, VTThe pilot of N66190 received a weather briefing from lebanon flight service station and was advised of low ceilings and also advised that visual flight rules flight was not recommended. At about the time N66190 was departing rutland, Vermont, a helicopter…NTSB DEN85LA234Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe plt attempted to land his Balloon in high winds resulting a hard ldg which threw him out of the basket the Balloon then began an immediate asent until a pax pulled the vent line and the Balloon settled rapidly until it hit the grd. Injuries to passengers…NTSB ATL85FA266Accident · 4 fatalField investigationFinal reportPiper PA-28-235-B · Rion, SCThe acft had been cruising at 10,500 ft for several min and then informed ATC that they were climbing to 12,500 ft due to VFR. Shortly there after the acft disappeared from the radar scope. Witnesses heard the engine making an unusual sound and looked up and…NTSB DEN85LA238Accident · No injuriesLimited investigationFinal reportCessna 182D · Monument Valley, UTThe pilot said that during app to ldg he encountered unfavorable winds in sheer or wind direction change causing the a/c to drop 4-5 ft onto the r/w resulting in substantial damage to the a/c.NTSB ATL85IA263Incident · Minor injuriesIncident investigationFinal reportBoeing 727-225 · Charleston, SCThe flight was level at 330 when it encountered turbulance and the arcraft moved an estimated 200 feet down then up before the crew could regain altitude control. Two flight attendents and several passengers initially complained of injuries. No documentation…NTSB ATL85LA259Accident · No injuriesLimited investigationFinal reportHughes 269C · Elizabethtown, KYAfter takeoff from off airport landing zone, the acft encountered heavy raninshowers and the plt attempted to return to the landing zone. Visibility was such that the plt was unable to see the ground and the tailrotor contacted a lake adjacent to the landing…NTSB BFO85FA071Accident · 2 fatalField investigationFinal reportCessna R182 · Browntown, VADrg a wx briefing, flt prctns for ocnl mtn obscn & IMC were relayed to the plt, but he was not provided a forecast for thunderstorms, nor advised VFR flt was not rcmdd. The route of flt was portrayed as marginal VFR, as was the destn at morgantown (mgm).…