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 BFO85FA070Accident · 2 fatalField investigationFinal reportCessna 120 · Afton, VAThe plt and his wife departed waynesboro arpt in reported VFR wx conditions at aprx 1700 hrs. According to the assistantarpt mgr the ceiling was about 2500 ft however, the mountain tops were obscured in the direction the acft flew towards. At about 1710 hrs…NTSB ATL85LA258Accident · No injuriesLimited investigationFinal reportBeech C23 · Clarksburg, WVThe pilot ran into less than VFR weather and turned around and attempted to make an airport. He became boxed in by weather all around and attempted to land on the highway. He did not make a pss over his intended landing area. When he was on short final, a car…NTSB DEN85LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Rocklake, NDThe student plt got lost during her 1st solo x-country flt. She subsequently attempted a lng on a gravel road but swerved the a/c off the road to avoid an oncoming car & the a/c received substantial damage.NTSB DEN85LA221Accident · No injuriesLimited investigationFinal reportBeech E18S · Billings, MTThe plt stated that he encountered a 'wind draft' and the acft was struck by lightning. The rt eng mount failed and the rt eng was deflected downward. Plt was unable to maintain alt and executed a forced landing in an open field. Post crash exam of the welded…NTSB MKC85FA180Accident · 1 fatalField investigationFinal reportRyan ST-A · Versailles, MOThe plt of another (accompanying) acft, had briefed the plt of N17351, on wx that could be expected en route. Instead of following the other acft as he had been briefed, the plt of N17351 got in the lead. While en route, he was observed to fly under the edge…NTSB DCA85AA031Accident · 135 fatalFinal reportLockheed L-1011-385-1 · Dallas/Ft Worth, TXThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-86/05. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Psbl…NTSB NYC85LA210Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Stormville, NYAccording to the pilot, during the second touch and go landing, at abut 30 feet from touchdown, a wind gust lifted and veered the aircraft left of the runway centerline. The pilot attempted to go around applied full power; however, the left wing collided with…NTSB DEN85LTM05Accident · Serious injuriesFinal reportInterstate S-1A · Rock Springs, WYWhile on a x-country flt, the acft encountered turbulence & downdrafts. The plt stated that at 1st, he was not concerned, but then it became apparent that the acft may impact the ground. The acft had limited power (75 HP) & the terrain elevation in that area…NTSB NYC85FA201Accident · 1 fatalField investigationFinal reportCessna C-177B · Macungie, PAWitnesses saw the acft descend in a near nose dive attitude during a severe thunderstorm. The plt was not in radio communication with gnd facilities. Examination of the acft did not disclose evidence of malfunction. There was no evidence of plt impairment or…NTSB ATL85LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Clanton, ALThe acft collided with a fence & a ditch during a precautionary off-arpt landing in a pasture. The plt reported that following the completion of aerial application operations, thunderstorms were blocking his return to the arpt. He had elected to land to await…NTSB DEN85FA203Accident · 2 fatalField investigationFinal reportCessna C-182 · La Salle, COThe plt and his girlfriend t/o from a pvt airfield north of denver co in a C182 in heavy fog conditions. The pilot was not inst rated. Shortly after t/o the aircraft hit the ground and was destroyed. Both occupants rec'd fatal injuries.NTSB SEA85FYM03Accident · 2 fatalFinal reportCessna 170B · Manzanita, ORAircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport.NTSB DEN85FA202Accident · 1 fatalField investigationFinal reportCessna 172RG · Wilsall, MTThe plt obtained a wx briefing that forecast IMC. He filed a VFR flt plan and departed polson, Montana at 0830 en route to powell, Wyoming. The plt said he encountered low ceilings, low visibilities, and drizzle just past helena, Montana but he continued. The…NTSB ANC85FA138Accident · 4 fatalField investigationFinal reportCessna 172M · Red Devil, AKShortly after the plt took off on a ngt flt to bethel, the acft crashed just north of the east/west rwy in a nose down attitude & on a southwesterly heading. The acft was destroyed during impact, but contd sliding aprx 35 yds to the north edge of the rwy,…NTSB SEA85LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jarbridge, NVShortly after departure the left wing was raised by a gust of wind. During correction the aircraft then yawed right. Almost full aileron was used to maintain level flight. The aircraft then descended to the ground. Inspection of the aircraft revealed no…NTSB DEN85FA200Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Rosa, NMThe plt departed dalhart, TX on a night x-country to quemedo, NM. En route he stopped and picked up a friend at hereford, TX. He did not file a flt plan. He was lost off of radar just west of Santa Rosa, NM, where the wreckage was later found. The acft was…NTSB FTW85MA297Accident · 3 fatalMajor investigationFinal reportBeech H35 · El Reno, OKThe acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…NTSB ANC85FA135Accident · 2 fatalField investigationFinal reportStinson SR6 · Port Lions, AKThe pilot continued the flight into less than visual conditions; became spatially disoriented and crashed while the aiplane was out of control.NTSB LAX85FA322Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phelen, CAAfter receiving a preflight weather briefing 1 hour and 20 minutes before takeoff, that cautioned of lowering ceilings and thunderstorms along his proposed flt route, the plt took off under VFR. A flt plan was not filed. As the acft climbed to its cruise alt…NTSB NYC85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Spring Valley, NYThe plt decided to divert to the rampa valley arpt due to wx. He over flew the arpt 2 times, then made an apch to land, but the acft was high & fast, so he made a go-around. He stated that he made a normal landing on the next apch. However, he was unable to…NTSB MKC85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Springfield, MODuring a wx briefing, the plt was advised of possible thunderstorms at his destination. While en route, he was told that thunderstorm activity at his destination was confirmed by radar. During the last 40 min of the flt, the plt flew past aprx 15 arpts where…NTSB MKC85LA154Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Camdenton, MON5593C took off on rwy 25 which has a hill off the west end. The wind was from the west at 10 to 13 knots and the temperature was 95 deg f. the plt said the acft encountered a downdraft as it approached the hill during the initial climb. The plt became…NTSB SEA85FA162Accident · 2 fatalField investigationFinal reportBeech B36TC · Idaho City, IDThe plt failed to obtain a preflt wx briefing prior to departing both butte, MT, and salmon, ID. En route at FL180 he entered instrument and icing conditions which he attempted to avoid by climbing to FL200. During the climb, the plt reported encountering…NTSB BFO85LA054Accident · No injuriesLimited investigationFinal reportCessna 172-RG · Thurmont, MDUpon encountering a low ceiling, precipitation, and haze at approximately 1500 feet MSL, the plt descended in order to locate a suitable landing area. The plt observed a grass airstrip below him, and executed a hard landing. The aircraft bounced once, and…NTSB BFO85LA053Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Warrenton, VAAfter liftoff both the PIC and the plt getting checked out in the Schweizer sgs 2-33A stated that they encountered moderate turbulence in the area. When the sailplane reched approximately 200 ft AGL the tom rope separated from the aircraft and N65818 was…NTSB NYC85LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Cambria, NYThe glider, while returning to land after a pleasure flt, encounter a rainshower and strong downdraft. The plt made a landing in a farmers fld. During the landing the right wing caught and the acft ground looped, incurring substantial damage.NTSB FTW85LA269Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Pearsall, TXA commercially rated CFI departed on a part 135 air taxi flt, but encountered deteriorating weather conditions. Circling his destination he reported that rain clouds closed in. Anticipating that he would be unable to file IFR in the air, he elected to land in…NTSB SEA85LA152Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Burns, ORDuring aerial applications the pilot cleared a rise, got a down draft, struck trees and then stalled striking the ground with little forward motion. An intense explosion and fire followed. The fire origin was in the area of the fiberglass fuel tank. An…NTSB ATL85FLT08Accident · Serious injuriesFinal reportCessna A188B · Marks, MSThe plt reported that while he was on an aerial application flt, a rain storm suddenly began & forced him to quickly return & land. He reported that the rain was so heavy that he could only see straight down. He contacted his ground crew & asked them to help…NTSB NYC85LA153Accident · Minor injuriesLimited investigationFinal reportCessna R-182RG · Spring Valley, NYDuring the final approach to runway 25, the aircraft encountered a downdraft and began to descend, the pilot added power but but unable to recover prior to the aircraft contacting the trees.NTSB DEN85FA167Accident · 8 fatalField investigationFinal reportCessna 402B · Bailey, COGround witnesses observed the acft enter low clouds going south, then emerge from clouds going went. Acft collided with mountain in wings-level and powered attitude. Mountains were reported to be obscured by clouds and fog.NTSB MIA85LA194Accident · Serious injuriesLimited investigationFinal reportBoeing B-737-201 · Vero Beach, FLThe acft was deviating around thunderstorm cells when it encountered heavy turbulence. The cabin attendants were conducting beverage service at the time. The passengers andybeen advised to gasten their seat belts and the 'fasten seat belts' lights were on.…NTSB MIA85LA190Accident · Serious injuriesLimited investigationFinal reportCessna 150J · New Smyrna Bch, FLWhile performing a banner towing flight the pilot encountered severe turbulence in the area of a thunderstorm and lost control of the acft. He stated he jettisoned the banner just before impact but still could not control the acft. The acft struck a small…NTSB NYC85FA141Accident · 2 fatalField investigationFinal reportBeech BE-200 · Hamptonburgh, NYPlt filed IFR for 2 flight legs; baltimore, MD to teterboro, NJ & teterboro to montgomert, NY (orange co arpt). The plt received a preflight wx briefing & was advised that the forecast for stewart, NY, about 10 mis form montgomery was sky partially obscured…NTSB FTW85FA244Accident · 1 fatalField investigationFinal reportCessna 152 · Bogalusa, LAA few minutes after departure the student plt flew into the ground in an effort to return to the arpt about 1400 ft n of rwy 18 in aprx a 15 deg nose down and 35 deg left angle of bank. The afct slid about 80 ft when it rotated about it's right wing flipping…NTSB NYC85FHD02Accident · Serious injuriesFinal reportCessna 210F · Princeton, NJThe acft collided with trees & crashed after overflying mercer cty arpt on a special VFR clearance. The acft had descended to 900 ft to overfly mercer and was attempting to proceed VFR to Princeton arpt to land when it contacted trees and crashed. The wx was…NTSB MIA85FA178Accident · Serious injuriesField investigationFinal reportAirbus Industrie A-300B4-2C · Atlantic Ocean (Atlantic Ocean)While established in cruise flight conditions the commercial airliner encountered an area of forecast thunderstorms. The captain elected to attempt to fly through the area. As the airliner was attempting to avoid the thunderstorms it encountered one rapid up…NTSB SEA85FA233Accident · 2 fatalField investigationFinal reportCessna 172N · Remote, ORDuring a wx briefing, the non-instrument plt was adzd that VFR flt was not recommended due to low clouds & adverse wx along the route. However, he filed a VFR flt plan & depd arcata, CA at 1240 PDT. At 1339, in the vcnty of wilderville, OR, the plt got a wx…NTSB ATL85FA171Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Charleston, WVThe acft collided with the terrain about 1 mile short of the rwy threshold during an IFR apprch on a dark night in IMC wx. The plt had been briefed on the wx and was given the ceiling at his destination as below VFR minimums . The non-instrument rated plt…NTSB NYC85LA128Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ellington, CTThe acft colldied with a stump during a landing attempt at Ellington arpt. The acft had touched dwn about 25 ft short of the rwy. The left aileron was damaged but the acft made a go-around & returned to westover air base & landed. According to the plt,…NTSB ANC85FA085Accident · 2 fatalField investigationFinal reportCessna C-207A · Golovin, AKAccording to the pilot-in-command, he was attempting to fly through a mountain saddle. As he turned towards the mountain and began his climb the weather deteriorated rapidly with ceilings zero, visibility zero and severe turbulence. The airplane struck the…NTSB SEA85FA113Accident · 2 fatalField investigationFinal reportCessna 177RG · Murphy, IDPlt received a preflight wx brief indicating a recent frontal passage in the area with strong winds and trubulence associated with thundershowers along the initial route of flight until clear of the owyhee mountains. No flt plan was filed. Radar tracked the…NTSB ATL85FA157Accident · 3 fatalField investigationFinal reportMooney M20J · Covington, TNAfter takeoff, the flt progressed normally, except one ARTCC controller had difficulty communicating with the plt during the early part of the flt. After cruising at 11,000 ft for aprx 2 hrs, the plt obtained updated wx info & requested clearance to descend…NTSB SEA85LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Rexburg, IDWhile en route, the plt circumnavigated around several storms. When the acft was about 20 mi from the destination arpt, fuel exhaustion ocurred. Subsequently, the acft nosed over during a forced landing on soft uneven terrain.NTSB LAX85FA252Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ocotillo Wells, CAAccording to witnesses on a dune buggy & a honda trx 200, the acft was flying at low alt in strong winds when it seemed to encounter turbulence & go out of control. Some of the witnesses said it temporarily leveled at about 200 ft AGL. All agreed that it was…NTSB NYC85LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Vincentown, NJThe acft collided with tree tops during a lndg in gusty winds. The plt said a gust of wind lifted the rt wing during the flare. As the acft veered to the left the plt said he considered a go-around but there was not room enough to clear the trees. The left…NTSB NYC85LA116Accident · No injuriesLimited investigationFinal reportCentrair 101A · Barre, MAThe acft encountered windshear during the approach to land and landed in trees. By the time the plt realized his situation it was too late and his wing tip hit a tree top. The acft camp to rest in trees.NTSB FTW85FA203Accident · 2 fatalField investigationFinal reportBeech B 55 · Brownwood, TXThe professional pilot was familiar with his destination. He had made the same trip many times in the last year. Destination weather information was not available that early in the morning, and although he indicated over the radio that he was aware of the…NTSB SEA85LA099Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Funter Pass, AKPrior to the flt, the plt had obtained a briefing thru the company weather reporting sys & VFR wx had been forecast. While en route, he encountered snow showers in the area of Funter Pass. He reported that he became trapped by two snow showers with the…NTSB MIA85FA159Accident · 4 fatalField investigationFinal reportBeech C35 · Tampa, FLWitnesses observed the acft takeoff on rwy 36 in foggy conditions. They reported that during the initial climb after lift-off, the acft pitched up & rolled into a steep left bank, then entered a descent & crashed on an aprx heading of 060 deg. Impact occurred…