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 CHI84FA383Accident · 2 fatalField investigationFinal reportCessna 172N · Lisle, ILAt 0029 CDT the plt contacted a local ATCT stating that he was in IMC with 0 visibility requesting assistance and desiring to land at the closest arpt. The non-instrument rated plt was at 2,000 ft and was given a climb to 2,500 ft. the controller stated that…NTSB SEA84FA223Accident · 2 fatalField investigationFinal reportCessna T210M · Skamania, WAA witness, located 3 mi se of the accident site, reported hearing the acft 'rev up to a scream followed by a crash that sounded like a miniature sonic boom.' The acft contacted the terrain in an uncontrolledd descent at an elev of 2100 ft MSL. Inspection of…NTSB MKC84LA270Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grain Valley, MOThe landing gsar collapsed as a result of a hard landing in gusty wind conditions. Although the airport wind sock was tattered, sufficient wind information was available from fss and UNICOM to alert the pilot to the need for compensation on approach. The…NTSB MKC84FA264Accident · 2 fatalField investigationFinal reportCessna 177B · Bloomfield, MON30755, collided with a radio tower guy wire and crashed three miles east of Bloomfield, MO, while on a business flight. Instrument meteorological conditons prevailed at the time of the accident. Witness stated that the low clouds obscured the top of the 80…NTSB DEN84MA266Accident · 4 fatalMajor investigationFinal reportAero Commander 690 · Little America, WYAbout 10 min after takeoff at 1005 MDT, the plt was cleared to climb to FL 190. This was atc's last communication with the acft. At 1030:39, the controller attempted to contact the plt to advise that he had lost radar contact & to recycle the transponder &…NTSB LAX84FA453Accident · 5 fatalField investigationFinal reportCessna 320C · Monterey, CAThe flt arrived in Monterey, CA, that afternoon. After dinner the flt was returning to the point of original departure. When the plt contacted the twr for taxi instruction he was informed that Monterey wx was below VFR minimums. After a discussion of wx…NTSB LAX84FA452Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Vista, CAAccording to a statement from the passenger who initially survived, the acft encountered fog shortly after takeoff and the plt was attempting to head inland to get out of the fog by reference to street lights. Shortly thereafter, while in a climb, ground…NTSB SEA84LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Juneau, AKOver a mountain pass the acft encountered turbulence the plt described as 'severe'. The acft lost 500 to 1,000 ft and turned 180 deg. A 180 deg climbing turn was initiated and the acft again flew into the turbulence. After the second encounter aileron and…NTSB ATL84FMG05Accident · No injuriesFinal reportBeech A36 · Banner Elk, NCAccording to the plt, he took off & climbed to about 4800 ft where 'a cloud bank rolled in on us without warning.' He attempted to climb & clear the mountains. However, the left wing tip 'clipped a tree' & subsequently, he crash landed. The elevation of the…NTSB NYC84FNA02Accident · No injuriesFinal reportAir & Space Gyroplane 18A · Harwich, MACruising at 500 ft over water the plt encountered fog. In an effort to maintain visual contact with the shoreline the plt began a descent and began a turn to avoid the fog. During the descending turn the acft got low and slow and the plt was unable to control…NTSB FTW84FA344Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Reed, OKArpt manager reported preflight discussion with plt concerning weather to south (intended direction of flight) but plt stated he didn't think there would be any trouble. Mgr observed acft takeoff and disappear into clouds to the south. Witnesses reported…NTSB CHI84FA342Accident · 1 fatalField investigationFinal reportPiper PA28-140E · Montmorenci, INThe acft crashed while on a x-country personal transportation flt. Prior to departure, the plt telephoned a relative at the destination, 118 miles away, & had been informed that the flt conditions (wx) at brazil were good. The plt did not obtain a wx briefing…NTSB DEN84LA256Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Kennebec, SDThe plt stated that shortly after takeoff when the aircraft was 25 feet in the air a downdraft was encountered near a small hill at the end of the runway. The descent caused by the downdraft could not be arrested and the aircraft collided with the ground. The…NTSB ATL84FA248Accident · 4 fatalField investigationFinal reportCessna 421C · Kennesaw, GAAccording to witnesses, the acft entered clouds at low alt during the initial climb after takeoff. They reported that the acft then turned sharply back toward the arpt & descended below the clouds. It rolled out in the direction of the crash site with the…NTSB FTW84LA341Accident · No injuriesLimited investigationFinal reportMooney M20 · Thibodaux, LAAt 0729 CDT the plt filed a flight plan and obtained a wx brief forecasting moist unstable air with several scattered and broken cloud layers beginning at 1,500 ft. the briefer further advised the plt of thunderstorm activity at various locations along the…NTSB SEA85FA065Accident · 2 fatalField investigationFinal reportCessna 177A · Ely, NVThe acft collided with rising terrain during a night x-country. No flt plan was filed. Radio communications were normal during the short (40 mile) flt, until the plt was asked to change transponder codes. The transponder signal ceased instead. The crash site…NTSB FTW84LA339Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW12 · Georgetown, TXOn final apch the plt encountered a 20 to 40 mph gust & subsequent 600 fpm downdrafts. Unable to reach the clear zone atthe apch end of the rwy. The plt attempted to stall into a tree but caught the left wing and slid down the side of the tree impacting the…NTSB CHI84FA374Accident · 2 fatalField investigationFinal reportPiper PA-28-180F · Cable, WIThe acft collided with trees & ground during IMC wx at night. The plt obtained a wx briefing at 1731 hrs CDT by phone from hibbing fss. He was advised that VFR flt was not recommended. No other wx briefing for this flt was recorded. Witnesses at the arpt of…NTSB ATL85FA039Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Petros, TNThe flt departed ft. lauderdale, FL, on 8-2-84 at aprx 0815 EDT for cincinnati, OH. The acft wreckage was found on 11-17-84 on an up slope of big fodder stack mountain. The acft had contacted a 25 ft tall tree located 200 ft west of the main wreckage. The…NTSB DEN84MA247Accident · 3 fatalMajor investigationFinal reportCessna 421C · Fort Lupton, CODuring a preflt wx briefing, the plt was advised of thunderstorms & intense rain showers on the route of flt. However, he filed an IFR flt plan & took off. During flt, the ATC controller advised the plt of a level 6 cell ahead & noted that he had no report on…NTSB CHI84LA323Accident · Serious injuriesLimited investigationFinal reportFairchild BC12-D · Hessel, MIAcft departed in VFR conditions for short x-country flt. No weather briefing was obtained. On initial encounter with deteriorating ceiling and visibility conditions, plt reduced altitude in attempt to maintain ground reference. Course reversal not initiated…NTSB ANC84LA127Accident · No injuriesLimited investigationFinal reportNorth American Navion · Atigun Pass, AKThe acft encountered a downdraft while flying through a mountain Pass. The terrain would not allow the plt to make a 180DEG turn so he elected to land on a road with the landing gear retracted.NTSB ANC84LA123Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Chicken, AKWhile en route to dawson city, Canada, the plt encountered deteriorating wx. The clouds were near the tops of the ridges & the acft was beneath the cloud layer in a slow flt configuration. The plt said that he tried to make a 180 deg turn, but the acft…NTSB FTW84FA326Accident · 1 fatalField investigationFinal reportBeech S35 · Bedias, TXThe non instrument rated plt penetrated a severe thunderstorm in which turbulence was labeled as severe or greater. There was no pre or in-flt wx briefing. The aircraft broke up in-flt and was consumed by post crash fire. Investigation revealed evidence of…NTSB DEN84LA237Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wessington, SDPlt stated that during loading for aerial application, he failed to note approaching roll cloud which usually signifies localized turbulence and strong, gusting winds. On takeoff roll, wind shift noted and at 100 ft altitude, heavy turbulence was encountered.…NTSB ATL84LA235Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Augusta, GADuring a turbulence encounter a pax standing in the rear of the cabin fell and suffered a fractured leg. The seat belt sign was illuminated for the entire flt. At the direction of the capt, in-flt service by the flt attendants was terminated. The injured pax…NTSB MIA84LA229Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-8-51 · Key West, FLThe captain reported that the seat belt sign was left on for the entire flt from Mexico city to miami. Aprx 50 mi from Key West, the flt began a descent from FL370. While descending thru about 11,500 ft, the acft encountered severe turbulence. At that time,…NTSB MIA84FA206Accident · 5 fatalField investigationFinal reportBeech A36 · Zolfo Springs, FLDuring the pre-flt wx briefing, the non-instrument rated plt was advised of numerous thunderstorms along his proposed route of flt & that VFR flt was not recommended. While en route, he contacted miami center, requested flt following & was instructed to…NTSB DEN84FTM02Accident · Minor injuriesFinal reportAmateur Built Thorp T-18 · Salt Lake City, UTThe plt was on a x-country to Salt Lake City. Approaching Salt lake he saw thunderstorms in the area. At this point he said he had 1/4 of a tank of gas so he diverted to ogden then tried for morgan where he was waved off by 3 people on therwy. Plt then…NTSB BFO84FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Selbyville, DEThe student pilot and one passenger departed on the flight without a wx briefing despite the existence of low ceilings and rain. Witnesses related hearing the engine accelerate and seeing the acft start a climb before it broke up and impacted the ground.…NTSB ANC84FA119Accident · 4 fatalField investigationFinal reportGrumman G-21A · Ouzinkie, AKN2021A departed kodiak, AK, at 0904 AKDT under a special VFR clearance. Two other plts stated N2021A was then circling over monashka bay while waiting for the wx over the narrow strait to clear. At 0920 AKDT the plt of N2021A stated to one of the other plts…NTSB FTW84LA314Accident · No injuriesLimited investigationFinal reportAerospatiale AS-355F · El Paso, TXThe helicopter encountered turbulence and downdrafts during landing. The acft impacted the asphalt ramp slightly nose low and bounced 2-3 ft into the air. The nose dipped more and full aft cyclic was applied. The main rotor blades hit the ground and the acft…NTSB NYC84FA247Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Newcomb, NYThe flight was operating in accordance with f.a.r. part 135.the plt filed a VFR flt plan and was cruising at an altitude of 5,500 ft when clouds were encountered. The plt attempted to descend to 3,500 but collided with the santanonimountain at an elevation of…NTSB ANC84FA120Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cantwell, AKImpact occurred at the 3,600 ft level on a steep slope of mountainous terrain. Instrument meteorological conditions were reported by pilots as well as ground personnel in the area. Loose and unstable terrain conditions limited the investigative effort.NTSB NYC84LA242Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Thomaston, CTThe glider made an off-arpt landing after encountering unexpected strong head winds in a rapidly changing flow of marineair. The acft cleared obtacles on final but yawed and landed in a crab condition damaging the fuselage and wing tip wheel.NTSB CHI84LA283Accident · No injuriesLimited investigationFinal reportPitts S-1C · Port Sanilac, MIThe acft was on a VFR x-country when the weather began to deteriorate. The plt overflew sandusky arpt with wx 0F 1000 ftovercast and visibility 3 miles in fog. He said he 'inspected' the arpt as a possible landing site but continued the flt. Following a road…NTSB CHI84FA280Accident · 2 fatalField investigationFinal reportCessna 172M · Walbridge, OHDuring flt, the acft encountered heavy rain & the plt attempted to land at a nearby arpt. However, due to another acft on the rwy, he made a go-around. The surviving passenger (a boy) reported that the acft encountered turbulence, black clouds & rain.…NTSB MIA84FA199Accident · 2 fatalField investigationFinal reportCessna 172M · St. CroixShortly after takeoff, the acft crashed aprx 200 yards off the northwest shore of St. Croix, U.S. Virgin islands. Witnesses stated the acft appeared to be in straight & level flight with the eng running until it suddenly pitched straight down into the ocean.…NTSB CHI84FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 172P · St. Joseph, MIPieces of wreckage and the body of the plt were recovered from lake Michigan aprx 4 mi sw of st Joseph. Wx at the dep arpt was VFR but deteriorated along the route of flt over the lake due to fog becoming IMC. A caution statement printed on the chicago…NTSB LAX84FA375Accident · 2 fatalField investigationFinal reportCessna 182Q · Yorba Linda, CAAfter filing a VFR flt plan, the non-instrument rated plt took off during darkness. The tower was not in operation when he departed. After taking off, the acft was observed maneuvering at an estimated alt of about 200 ft. witnesses reported there was no wind,…NTSB SEA84LA148Accident · No injuriesLimited investigationFinal reportGlasflugel 604 · W Silver Spring, NVThe glider plt was returning to the Douglas country arpt after a 470 mi x-country flt. While at about 10,000 ft, he encounter a downdraft that was associated with a nearby thunderstorm & lost about 7000 ft in 7 miles. He elected to land on a highway. Just as…NTSB MKC84LA182Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Overland Park, KSPrior to a sight-seeing flt, the plt orbained a wx briefing & released test balloons to check the wind spd & drctn. The prevailing wind was in a southerly direction at about 8 KTS. The plt of N4070W initiated his departure from a school yard after another…NTSB LAX84LA364Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Lee Vining, CAThe plt reported that after entering tioga pass, he made a left turn to follow the center of the pass & the acft began to sink. He applied full power & went to the best angle of climb speed, but was unable to stop the sink. The acft then hit an electrical…NTSB DCA84IA029Incident · No injuriesIncident investigationFinal reportBoeing 707-323C · Chicago, ILAbout 26 min before landing crew received SIGMET 1C advising of line of thunderstorms from milwaukee to st. louis movingse at 15 KTS. They also became aware of a thunderstorm west of arpt. At about 20 mi NE of arpt they could see the storm visually & on radar…NTSB CHI84LA268Accident · No injuriesLimited investigationFinal reportBarnes AX-7 · Batavia, ILThe plt received a wx briefing before the flt. The 1950 surface observation reported winds from 090 deg at 4 KTS. During flt, the winds suddenly picked up & the plt attempted a landing. A rapid rate of descent developed & the balloon collided with trees…NTSB ATL84LA207Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Parsons, WVThe acft collided with a tree and crashed after becoming lost in IMC weather during a night x-country. The plt had descended after seeing lights below him. He circled the town and made a turn to approach a road for landing on which he said the police had…NTSB NYC84FA214Accident · 3 fatalField investigationFinal reportAerospatiale AS-350D · Island Beach, NJThe on-demand air taxi flt departed for garden city with one pax. The reported weather at the aprx time of the accident indicated low clouds, thunderstorm activity including rain and lighting. One witness stated that he observed the helicopter flying at an…NTSB DCA84AA028Accident · Minor injuriesFinal reportMcdonnell Douglas DC-9-31 · Detroit, MIDuring arrival, the aircrew (visually & by use of wx radar) noted thunderstorms (tstms) west & southwest of the arpt. The crew elected to continue & make an ILS apch. At 1636, a spcl wx obsn had tstm info, but was not noted. At 1650, the vis dropped to 1/4 mi…NTSB SEA84LA128Accident · No injuriesLimited investigationFinal reportCessna 172K · Pendleton, ORThe plt said he initiated his takeoff on rwy 25 with the wind from 220 deg at 35 gusting 42 KTS. Just after lifting off, at about 10 ft AGL, the stall warning horn sounded & the plt noticed that the airspeed had dropped to about 45 mph. The acft then drifted…NTSB MKC84LA162Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Kansas City, MOAs a large jet was departing from the threshold of rwy 19, the plt of a Cessna 206, N9967M, was cleared onto the rwy to hold. Reportedly, the Cessna plt held short of the rwy until the jet had rolled about 1000 ft. as the Cessna was taxied onto the rwy, it…