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 SEA82DA090Accident · Minor injuriesFinal reportHughes 269B · Mt St Helens, WAThe pilot intended to proceed to Mt St Helens to land near spirit lake. The winds in the vicinity of the desired landing point were too strong for a safe landing. Therefore, an alternate spot was selected below the ridge line and presumably sheltered from the…NTSB CHI82FA214Accident · 2 fatalField investigationFinal reportPiper PA-32 · Charlevoix, MIThe acft departed the Charlevoix arpt & crashed 1 mile south of the arpt. Two persons tried to discourage the plt from leaving because of the poor weather. Witnesses described the weather as raining hard & visibility poor with an estimated visibility at 200…NTSB FTW82FA223Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Hartshorne, OKWhile on a cross-country flight, the pilot was advised by radio of a severe thunderstorm and tornado watch along his route. At 1613 CDT, he was advised of a line of radar returns about 10 miles ahead. He replied that it "looks like a soft spot through there,…NTSB SEA83FA196Accident · 1 fatalField investigationFinal reportMooney M-20 · Sandy, ORThe acft crashed into rising terrain in marginal weather conditions. No flt plan had been filed. The acft crashed 25 miles from the takeoff point on 6/12/82 and was missing until 9/9/83. The pilot had received a weather briefing from portland fss indicating…NTSB SEA82DA088Accident · No injuriesFinal reportPiper PA-38-112 · Oakley, IDAt about 1045 MDT, the pilot departed ogden, ut on a solo, cross-country flight to jackpot, NV, pocatello, ID and return. While en route to jackpot, he encountered turbulence and decreasing visibility over a mountainous area and descended from 8500 ft MSL to…NTSB ATL82DA162Accident · Serious injuriesFinal reportPiper PA-28-181 · Savannah, GAThe pilot obtained a weather briefing and filed a VFR flight plan before takeoff. He was advised that the weather was 6000 ft scattered, 6 miles visibility, possible storms gathering at palatka, FL. After takeoff, he was unable to contact the flight service…NTSB ATL82FA153Accident · 1 fatalField investigationFinal reportCessna 172M · Alabaster, ALAt 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…NTSB ATL82DA152Accident · Minor injuriesFinal reportCessna 150 · Red Oak, VAThe pilot reported that he was on a local flight when the weather began to deteriorate. He decided to make a precautionary landing in a large bean field. While on a landing approach, the aircraft struck a utility line, wrapping the wire around the propeller…NTSB NYC82FA110Accident · Serious injuriesField investigationFinal reportDouglas DC8-52 · Atlantic Ocean (Atlantic Ocean)The flt had been airborne about 25 min with the seat belt sign on because of the possibility of turbulence. Two flight attendants were preparing the beverage cart when turbulence was encountered. The acft suddenly dropped downward causing the two attendants…NTSB FTW82FRG33Accident · 4 fatalFinal reportCessna R182 · Bergheim, TXAt 0010 the plt contacted san antonio tower approximately 10 mi north of san antonio intl arpt. He stated he was at 3100 ft in the clouds. The controller instructed the plt to turn left heading 030, maintain 3,000, & asked the plt if hewanted an IFR…NTSB CHI82DA191Accident · No injuriesFinal reportConvair 240 · Detroit, MIThe captain stated that during an ILS approach, he saw the approach lights about 3 miles from the touchdown point. Reportedly, the plane was on the glide slope and localizer as he continued on final approach. After passing minumums, the aircraft went into a…NTSB DEN82IA098Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-61 · Near Goshen, INThis aircraft encountered unforecast severe clear air turbulance (cat) while in cruise flight at FL350 Near Goshen, IN. As a result of the encounter, the aircraft entered an uncontrolled descent which was arrested at 31,500 feet. A total of seventeen…NTSB CHI82FA186Accident · 2 fatalField investigationFinal reportCessna 172N · Milford, MIEarlier in the evening during a return flt from london, ontario to pontiac, MI the plt became disoriented & was radar vectored to detroit city arpt, the only arpt reporting VMC. The plt landed at about 2208. After landing the plt received two wx briefings at…NTSB NYC82FA103Accident · 2 fatalField investigationFinal reportCessna 150F · Delano, PAThe plt received wx briefings at 1111 & 1530 from the detroit, mi fss for a flt to new jersey. The plt was advised during the 1530 briefing that VFR flt was not recommended. The plt departed gross ile, mi at approximately 1700 & landedat williamsport, PA at…NTSB FTW82FQG18Accident · 1 fatalFinal reportCessna T337B · San Angelo, TXAt apprx 2015 CDT, the plt called the San Angelo tower and expressed concern that his acft might be damaged by hail from the wx that was bldg in the area, tower psnl relayed available wx info & provided phone numbers for the wx bureau & a local fss. A tornado…NTSB CHI82FA181Accident · 3 fatalField investigationFinal reportBeech A23 · Northville, MIAt 1701 EDT on 5/21/82, the non-instrument rated pilot called a flight service station and requested an IFR weather briefing. The briefing was for a flight from lapeer, Michigan to frankfort, Kentucky. The plane departed the next day at about 1200 EDT with no…NTSB ATL82DA142Accident · Serious injuriesFinal reportDouglas DC-9-15F · Memphis, TNBefore takeoff, the aircrew received weather data that included a forecast for a severe thunderstorm watch. While en route, the captain elected to leave the seat belt sign on for the entire flight. The flight was routine until a descent was started into the…NTSB CHI82DA180Accident · No injuriesFinal reportPiper PA-28 · Harrisburg, ILDuring a weather briefing, the pilot was advised that there were thunderstorms in the area of his destination at about 1415 CDT, he departed for a two hour flight. After flying over weather most of the way and overflying an airport (hulman regional), he…NTSB ATL82FA140Accident · 2 fatalField investigationFinal reportCessna T210M · Holly Springs, SCPrior to departing new bern at 1837 the plt called his office & stated he had received a wx report for scattered thunderstorms along his route of flt. At 2020 & 2052 he contacted atl flt watch for wx advisories. He was advised that the wx radar was out of…NTSB LAX82FA183Accident · 4 fatalField investigationFinal reportBeech A24R · Near Mt. Shasta, CAThe flight originated at reno, NV, but the pilot landed at red bluff, CA after receiving an in-flight weather briefing. After landing, he obtained another weather briefing and was advised that VFR flight was not recommended. He then filed a VFR flight plan…NTSB FTW82FA171Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Lorenzo, TXThe aircraft crashed while the pilot was trying to return to the departure airport after a night takeoff. Marginal VFR conditions were forecast with thunderstorms predicted. The aircraft accident occurred in area where a thunderstorm was in progress. His…NTSB CHI82FA160Accident · 1 fatalField investigationFinal reportCessna 172C · Sunburg, MNThe pilot received several weather briefings and was advised of a severe cold front and thunderstorms in an area on his route. Prior to takeoff, he was advised that VFR flight was not recommended. While en route, the pilot reported that he was "totally…NTSB LAX82FA167Accident · 2 fatalField investigationFinal reportCessna 172 · Morman Lake, AZThe acft departed winslow, AZ on a flt to long beach, CA with an en route stop scheduled for prescot, AZ. Before departing winslow, the plt was warned by another plt that he had encountered extreme turbulence in the vicinity of mormon mtn. The plt and pax's…NTSB FTW82FRG30Accident · 2 fatalFinal reportCessna 182E · Armstrong, TXBefore taking off, the pilot reviewed the weather in person at the college station fss, but declined an official weather briefing. He departed in good VFR conditions and flew into an area of known and forcasted low ceilings. While en route, his flight path…NTSB LAX82FA168Accident · 2 fatalField investigationFinal reportCessna T210M · Mt. Wilson, CAAt the fss the plt requested the current & forecast salt lake city wx. The wx was furnished & the specialist advised that VFR flt was not recommended. The plt did not wish a full briefing & was heard to say to his passenger "let's go check it out." The acft…NTSB DEN82DA076Accident · No injuriesFinal reportFunk B75L · Laramie, WYAccording to the pilot, when the aircraft was in a mountain pass about 10 mi from the departure point, it was caught by a downdraft. Reportedly, he was forced to land on a dirt trail. During the landing, the aircraft was substantially damaged.NTSB LAX82DA149Accident · No injuriesFinal reportCessna 172 · Litchfield Park, AZThe student was a private pilot who was practicing for a commercial certificate. During the flight, he elected to make a simulated emergency landing on a dirt strip. He stated that during the takeoff phase of a touch and go, he encountered a dust devil.…NTSB SEA82DYE06Accident · 1 fatalFinal reportBeech 23 · Greenwater, WAAt about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…NTSB FTW82FQD10Accident · 4 fatalFinal reportMooney M20K · Van Horn, TXN99996 departed riverside, CA on a flight to nacogdoches, TX the aircraft made a refueling stop in deming, NM, the last known en route position. The left seat pilot held a pvt certificate, the right seat pilot was a former FAA designated pilot examiner.…NTSB MKC82FA057Accident · 2 fatalField investigationFinal reportCessna 177RG · Ste. Genevieve, MODuring the day of the accident, the pilot received 7 weather briefings which described marginal VFR conditions for his route of flight. At about 1730 CST, he departed Kansas city on a VFR flight plan to farmington, MO. During the flight, he encountered…NTSB MIA82DA111Accident · 3 fatalFinal reportCessna 172N · Near Westbay, FLDuring the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & visbilities just east of panama city & along the gulf coast. At 2015, approximately 28 mi se of destin, the plt contacted eglin approach control(a/c) & was…NTSB FTW82DA136Accident · Minor injuriesFinal reportCessna 182P · Kendalia, TXThe pilot stated that the weather conditions along his route of flight deteriorated rapidly. He decided to make a precautionary landing on a short plowed field. During final approach, the aircraft struck a tree top and crashed.NTSB FTW82DA134Accident · No injuriesFinal reportMaule M-5-210C · Kirbyville, TXOn 4/17/82, N62003 departed woodville, TX under visual meteorological conditions on a flight to Kirbyville, TX. The pilot stated that the attitude gyro had always been slow to erect and was still showing 10 degrees right bank when he arrived at Kirbyville. He…NTSB ANC82FA037Accident · 1 fatalField investigationFinal reportMaule M-4-220C · Homer, AKThe pilot departed Homer airport on a special VFR clearance after being advised numerous times that VFR flight was not recommended. Shortly after takeoff (8 minutes) the aircraft dove out of the clouds and crashed near the airport. The pilot was not…NTSB DEN82DA068Accident · No injuriesFinal reportCessna 182A · 20mn Of Jackson, WYThe pilot reported that he became involved in a deteriorating weather condition while maneuvering in a mountainous area. He attempted to return to the departure airport, but the weather conditions (snowshowers) became worse. He elected to make a precautionary…NTSB ANC82FA035Accident · 2 fatalField investigationFinal reportSud SA 318C · Near Savoonga, AKAt 0746 LCL time, the plt activated his VFR flt plan for a round robin flt from nome, AK to Savoonga, NE cape, Savoonga, se cape, Savoonga & back to nome. After arriving at Savoonga, the helicopter was refueled. According to svrl villagers, the wx at that…NTSB ANC82FA036Accident · 3 fatalField investigationFinal reportHughes 369D · Near Tanana, AKThe aircraft crashed on a snow covered mountain slope while in a steep left bank/nose low turn. The 1754 ast weather at Tanana, AK (19 NM sse) was, in part: 1800 ft broken, 3500 ft overcast, visibility 7 mi with light snow, wind 320 deg at 18 KTS. Flight…NTSB ANC82DA033Accident · Minor injuriesFinal reportCessna 206 · Near Nightmute, AKThe pilot stated that during flight the aircraft inadvertently drifted north of his intended flight path into an area of higher terrain. When the aircraft encountered a whiteout condition the pilot elected to turn to the right toward what he observed as…NTSB DEN82FA056Accident · 3 fatalField investigationFinal reportCessna 320F · Missoula, MTDuring arrival for an ILS-2 approach to runway 11, the pilot was advised to hold at the kona NDB while snowplows finished clearing the runway. At that time, the Missoula weather was 1200 ft obscured, 2 mi visibility with light snow and fog, temperature and…NTSB DEN82FA057Accident · 2 fatalField investigationFinal reportMooney M20B · Near Salida, COAfter departing Salida at approximately 0820 the plt radioed over UNICOM that the clouds in the local area had bases of 12,500 ft MSL & tops at 16,500 ft MSL. About 15 min later the acft impacted a mountain at the 13,500 ft level. There were flt precautions…NTSB FTW82DQG17Accident · Serious injuriesFinal reportBalloon Works 7-B · Masterson, TXAfter making weather observations and obtaining a weather briefing, the instructor pilot (ip) briefed the chase crew of the expected northerly track. The ip and student took off at 0705 CST and ascended to 1200 to 15000 ft AGL and began tracking…NTSB ATL82FKG10Accident · 2 fatalFinal reportBeech A36 · Darien, GAThe pilot filed a VFR flight plan, but did not activate it after takeoff. While en route, he encountered deteriorating weather and obtained an IFR clearance. As he continued, he entered an area of thunderstorms, turbulence, and heavy rain. As the pilot was…NTSB DEN82FA054Accident · 4 fatalField investigationFinal reportBeech M35 · Lamar, CODuring the wx briefing the plt was advised that the wx along his proposed route of flt would be generally good VFR with the exception of possible turbulence & that blowing dust would be the big problem. There were pireps of 65K winds at 3,000 ft over Oklahoma…NTSB MIA82FA088Accident · 2 fatalField investigationFinal reportMooney M2OJ · Ormond Beach, FLThe non-instrument rated pilot had filed for an IFR climb to vfr-on-top. He took off after receiving a clearance to the bulli intersection with instructions to maintain 9000 ft, if not vfr-on-top by that altitude. At 1720 EST, the pilot transmitted that he…NTSB ATL82DA088Accident · No injuriesFinal reportPiper PA-24-250 · Macon, GAThe non-instrument rated pilot reported departing ft lauderdale, FL with 4 hrs of fuel on board on a 40 minute flight to okeechobee, FL. The next day, he departed okeechobee without refueling on a flight to Macon, GA. He reported that he had to climb to…NTSB FTW82DA104Accident · No injuriesFinal reportCessna T210N · Pampa, TXWhile en route, the pilot encountered icing conditions as he got near his destination and was unable to maintain altitude. Subsequently, he made an off airport landing and the plane was damaged.NTSB ATL82FA086Accident · 3 fatalField investigationFinal reportMooney M20F · Mchenry, MDAt 0635 the plt received a wx briefing which included forecasted icing conditions along his route of flt. At 1215 received an updated briefing & was informed that IMC existed along his route of flt & VFR flt was not recommended. At 1536 he called & received…NTSB NYC82DA065Accident · No injuriesFinal reportPiper PA-28R-180 · Perry Warsaw, NYThe pilot elected to takeoff at night with low visibility, rain, and fog. Soon after takeoff visual ground contact was lost due to what the pilot stated as quickly lowering ceilings and visibility. The pilot then decided to make a precautionary landing in a…NTSB FTW82FA103Accident · 6 fatalField investigationFinal reportBeech 58 · Magdalena, NMThe plt was advised of the icing conditions to be expected three different times during his wx briefing. At 1524 while enroute at 14,000 ft, the plt was advised of a PIREP of light to moderate icing between 14,O00 & 22,000 ft. the plt replied that was about…NTSB NYC82FA060Accident · 2 fatalField investigationFinal reportCessna U206G · Stratford, NHBefore takeoff, the pilot received a partial weather briefing by telephone. He was advised of reported icing conditions and was told that snow and rain showers were moving through the area causing marginal VFR conditions. Before terminating the conversation,…