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 MKC82DA168Accident · No injuriesFinal reportCessna 150B · Wyoming, IAThe pilot used his aircraft to commute to his place of employment at east moline, IL. After work, he prepared a flight to his home in Wyoming, IA. He obtained ATIS weather information which in part was: 900 ft overcast, 4 miles visibility, fog, temperature…NTSB MKC82FCQ14Accident · 2 fatalFinal reportCessna TRI82 · Bunker Hill, KSThe non-instrument rated pilot departed great bend, KS sometime after 2000 CDT on 9/6/83 on a flight to lucas, KS. On 9/9/83, the aircraft was found where it had crashed between great bend and lucas. No preimpact, mechanical failures were evident. The 2256…NTSB ATL82FA263Accident · 3 fatalField investigationFinal reportCessna 170A · Brunswick, GAThe non-instrument rated pilot was on a flight from ironton, oh to daytona beach, FL with an en route stop at columbia, SC. He obtained a weather briefing prior to departing ironton, but did not update it after landing at columbia. The aircraft crashed on the…NTSB LAX82DA330Accident · Serious injuriesFinal reportBell 206-L · Lihue, HIDuring a sightseeing trip to the west side of kapalaoa ridge area near punham crater, the pilot experienced a downdraft and then a severe updraft that put him in IFR conditions in the clouds. The helicopter is not equipped for instrument flight and the pilot…NTSB DCA82IA031Incident · Serious injuriesIncident investigationFinal reportBoeing 727 · Washington, DCThe announcement of the possibility of turbulence during the descent and approach was made. During the lulls in the turbulence the cabin attendants were attending their duties and were hurt when intermittent jolts of rough air were encountered while two of…NTSB ATL82FA261Accident · 1 fatalField investigationFinal reportCessna 170B · Lawrenceville, GADuring the return flt to stone mountain arpt, the plt contacted approach control & requested vectors to the gwinnett county arpt at Lawrenceville, GA. The plt reported that he had been going around thunderstorms & it was turning dark. Several minutes later…NTSB ATL82DA258Accident · Minor injuriesFinal reportHughes 269C · Louisville, KYThe pilot received a weather briefing before taking off on an aerial traffic patrol for a local radio station. He was issued a special VFR clearance to follow a pre-established route. However, after departing, he encountered thunderstorm activity. He returned…NTSB MKC82FA161Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Mediapolis, IADuring the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.…NTSB DEN82FA175Accident · Serious injuriesField investigationFinal reportConvair 340 · Del Norte, COAccording to the flight crew, VMC had deteriorated into IMC over the mountains. After entering IFR conditions the acft impacted a mountain ridge.NTSB ANC82DAG50Accident · No injuriesFinal reportCessna 150 · Kodiak, AKThe pilot took off from a gravel bar that was surrounded by higher terrain. Reportedly, the wind was calm until after lift-off, then a strong crosswind was encountered as the plane cleared higher terrain. The pilot reported that the plane was hit by the…NTSB CHI82DA320Accident · No injuriesFinal reportPiper PA-22 · Houston, MNThe pilot obtained a weather briefing before departing on a cross-country flight from west bend, WI to waseca, MN. Reportedly, the ceiling was 2500 to 3000 ft or better (as briefed) until after crossing the Mississippi river. The weather then began to…NTSB SEA82FA142Accident · 1 fatalField investigationFinal reportPiper PA32-300 · Shelton, WAWitnesses 3 miles west of the arpt heard the sounds of the departing acft. As the acft proceeded northbound, sounds of eng power cycling were heard, followed by increasing noise levels as if the acft was returning to the field. At the sudden sound of high…NTSB MKC82IA143Incident · Minor injuriesIncident investigationFinal reportBoeing 737-291 · North Platte, NEThe pilot stated that the first officer was hand flying the aircraft on the IFR approach. Both flight crew members saw the approach and runway lights and confirmed the cloud ceiling was 300 ft and visibility was 3/4 mile. The approach was continued and the…NTSB ATL82DA234Accident · No injuriesFinal reportGrumman American AA-5A · Providence, KYDense ground fog developed before the plt returned to land. He made two approaches & go-arounds before the accident, & each time he had to fly very low to see the rwy lights. The plt stated that during the third approach he was looking for the arpt & not…NTSB MIA82DA169Accident · No injuriesFinal reportCessna 172 · Moore Haven, FLThe student pilot was on the return portion of a cross-country flight when she deviated to avoid weather. She tried to circumnavigate around lake okeechobee, but in her opinion, the weather began to close in with the visibility decreasing in heavy rain. She…NTSB LAX82DA292Accident · Minor injuriesFinal reportCessna 172K · Hanapepe, HIJust prior to touchdown a strong gust of wind caused the acft to drift right of the rwy centerline. During the go-aroundthe left wing struck the ground causing the acft to cartwheel.NTSB ATL82FKW09Accident · 1 fatalFinal reportGrumman AA-1 · Lafayette, TNThe acft crashed while apparently trying to land in a field drg IFR conditions after loss of a top eng cowling. The plt had just made a may day transmission that he had lost his cowling. It could not be determined whether the cowling was lost before or after…NTSB FTW82FRG39Accident · 1 fatalFinal reportPiper PA-23-250 · Bandera, TXWhile returning from Mexico, the pilot landed at eagle pass, TX and cleared U.S. Customs. Without refueling or obtaining a weather briefing, he continued toward his home airfield at the flying l ranch near Bandera, TX. Local weather observations indicated…NTSB ATL82FA233Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Folkston, GAThe acft crashed into the okefenokee swamp in se Georgia. Thunderstorms, varying in magnitude from levels 3 to 5, were moving from west of jacksonville FL to an area north of the okefenoke swamp. The storms were moving nw at 20K.NTSB CHI82DA295Accident · No injuriesFinal reportBoeing Stearman A75-300N1 · Whitehall, WIThe pilot received a weather briefing before takeoff, and reportedly, was advised that VFR flight was not recommended. During the flight, the ceiling and visibility began to decrease. The pilot decided to make a precautionary landing in a field. He stated…NTSB CHI82DA294Accident · No injuriesFinal reportBreezy RLU1 · Milwaukee, WIThe pilot stated that he got a weather briefing before departing oshkosh, WI. While en route, he encountered fog and rain. The pilot attempted to continue to find timmerman or rainbow airport. The engine lost power due to fuel exhaustion. While landing on a…NTSB NYC82FA181Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Concord, NHThe plt was advised during the 0028 & 0203 wx briefings that VFR flt was not recommended. At 0304 the plt called fss to activate his flt plan & was again advised VFR flt was not recommended. At 0403 the flt was given Concord wx & at 0406WAS cleared into the…NTSB ANC82DAG40Accident · Minor injuriesFinal reportAeronca 7GC · Tyonek, AKThe plt stated he departed anchorage for the kustatan river. He encountered ground fog enroute & landed on a beach. About 1-1/2 hrs later the fog cleared & he took off. He again encountered fog at the mcarther river, but it looked clearon the other side.…NTSB NYC82FNC13Accident · 1 fatalFinal reportPiper PA-28-140 · Beans Purchase, NHThe acft impacted an obscured mountain. An observation log & a pilot-certificated witness confirmed that IFR conditions existed at the time of the accident.NTSB NYC82FA176Accident · 1 fatalField investigationFinal reportCessna 150L · West Brattlebor, VTAt 2036 the plt contacted bradley approach control (a/c) on freq 121.5 & stated he was lost, at an altitude of 4,000 ft & in "almost IFR weather." Since the acft was not transponder equipped a/c had the plt use VOR orientation procedures to determine his…NTSB ANC82DAA10Accident · No injuriesFinal reportCessna 180A · Manley Hot Spri, AKThe pilot reported that the weather at the departure point was 1500 ft broken, visibility 20 miles wind from the southwest at 5 to 10 KTS. After taking off in a float plane, he elected to follow a slough. After turning a corner about 1 1/2 miles from the…NTSB CHI82DA315Accident · No injuriesFinal reportPiper PA-38 · New Haven, ILThe pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…NTSB SEA82FYK11Accident · 2 fatalFinal reportCessna T210M · Cottage Grove, ORThe aircraft crashed while receiving radar vectors from eugene approach control to the vor-dme runway 34 approach at eugene, OR. Investigation revealed that the aircraft impacted tree tops in a level, nose down attitude and traveled approximately 180 yard…NTSB ANC82DAG54Accident · No injuriesFinal reportCessna 185F · Mcgrath, AKThe pilot departed Mcgrath, AK at 2200 adt on a flight to bear creek, AK. He reported that the weather became rainy and hazy, and he could not land at bear creek due to the deteriorating weather. He started to divert back to Mcgrath, but low clouds prevented…NTSB DEN82FTM16Accident · 2 fatalFinal reportVarieze · Milcreek Canyon, UTThe aircraft crashed into trees in a Canyon at an elevation of 9300 MSL. The weather was reported as marginal VFR. No flight plan was filed. VFR flight was not recommended. A toxicological check of the pilot's blood showed an alcohol level of 91 mg%; however,…NTSB ATL82DA217Accident · Minor injuriesFinal reportCessna 172 · Laurinburg, NCThe weather briefing forecast thunderstorms however the pilot took off on a cross country and circumnavigated two cells. The air became turbulent so the pilot decided to land in a plowed field. A downdraft caught the plane and it landed nosedown and nosed…NTSB CHI82DA275Accident · Minor injuriesFinal reportErcoupe 415C · Port Sheldon Tw, MIDuring a VFR flight along lake Michigan shoreline the pilot encountered a decrease in ceiling height. The pilot chose to make a 180 degrees maneuver and return to the airport but during the turn encountered a fog bank. The pilot decended to avoid the fog bank…NTSB LAX82FA275Accident · 2 fatalField investigationFinal reportPiper PA-601P · South Of Wicken, AZAt about 1005 MST the plt received a wx briefing for a flt to Florida with an overnight stay in Texas. Thunderstorm activity was forecast along the proposed route of flt. The briefer advised the plt to get an updated briefing before departure because of the…NTSB FTW82DA305Accident · No injuriesFinal reportAlon A2 · Poyen, ARAs the pilot approached his destination, malverne, AR, he descended into hazy conditions under a cloud layer. As he continued, he mistook Poyen, AR for malverne. He was unable to find the airport and elected to make a precautionary landing before dark. He…NTSB CHI82FA266Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Hartsburg, ILAt 1223 CDT the plt contacted peoria approach control & requested radar vectors to the Mt. Hawley arpt located just northof the peoria arpt. At 1227 CDT he stated the weather was getting bad & he would like to fly to the logan county arpt. One witness stated…NTSB LAX82AA259Accident · Serious injuriesFinal reportMcdonnell Douglas DC-10-10 · Morton, WYWhile flying in good wx over central Wyoming, the captain noted a gentle wave motion that caused the autothrottles to react. Therefore, he disengaged the autothrottles and autopilot. The acft had lost 250 ft drg the wave motion, so the captain turned on the…NTSB NYC82FA155Accident · 4 fatalField investigationFinal reportCessna 177RG · Cross Fork, PAAt 2132 the plt contacted fss reporting his position, lightning to his east & requested wx around his position. He was advised of thunderstorm activity, deteriorating conditions & that VFR flt was not recommended. He was also advised to reverse course. At…NTSB NYC82FA148Accident · 1 fatalField investigationFinal reportGulfstream American AA-5B · Newburg, PAThe pilot on a personal cross-country flew into trees on a slope of blue mountain, PA at the 2284 foot level. The weather in the area was foggy and the mountain tops were obscured in clouds. There is no record of a weather briefing or communication by the…NTSB DEN82AA132Accident · 1 fatalFinal reportPiper PA-24-250 · Billings, MTPlt decided to land enroute due wx. At 0803 he contacted Billings fss & was advised Billings wx was 5,000 ft broken. At 0809 he called Billings approach control (a/c) & advised he was 20 mi for landing. Enroute to arpt he was unable to locate the arpt due wx…NTSB LAX82FA240Accident · 2 fatalField investigationFinal reportBeech V35B · 37 Nm Nw. Of Re, CADuring a weather briefing before takeoff, the pilot was advised of flight precautions for turbulence, IFR conditions, and icing. While en route at 12,000 ft, the pilot reported that he was picking up rime ice. He was cleared to 11,000 and then 10,000 ft. when…NTSB FTW82DA256Accident · No injuriesFinal reportCessna 150A · Fabens, TXThe pilot reported that on a flight from midland to el paso, TX, he encountered marginal weather. Flight watch had reported rain and thunderstorm activity about 30 miles east of el paso. As the weather on his route worsened and became more turbulent, he…NTSB LAX82FA236Accident · 3 fatalField investigationFinal reportCessna 182 · Trinity Center, CAThe plt contacted the redding, CA tower & stated he was on top & 41 mi from the redding VOR. He then reported he was going into the clouds & requested radar service. He then contacted oakland ARTCC who provided assistance until the plt stated he had found a…NTSB LAX82FUG13Accident · Serious injuriesFinal reportBeech 95-C55 · Ontario, CAWhile descending near banning, CA, the pilot lowered the gear after becoming aware of a popped circuit breaker. At the destination, there was an overcast with the tops at 4500 ft, so he diverted toward burbank, CA with the gear down. The overcast extended…NTSB ATL82DA175Accident · No injuriesFinal reportCessna 150M · Christiansburg, VAAfter flying from blacksburg, VA to monroe, NC. The pilot took off on a return flight to blacksburg without refueling. The pilot stated that before takeoff, he took the fuel tank caps off to visually check the fuel. However, he did not use the dip stick that…NTSB ATL82DA174Accident · No injuriesFinal reportCessna R182 · Abbeville, SCDuring flight, the pilot encountered adverse weather conditions and elected to make a precautionary landing at a nearby airport. He reported that he landed about 700 ft from the approach end of the runway at 70 knots, hydroplaned, and continued off the…NTSB LAX82FA226Accident · Serious injuriesField investigationFinal reportCessna 172 · Granada Hills, CAThe student pilot departed van nuys, CA at about 1530 PDT on a round-robin, cross-country flight to turlock, CA. It was a combination personal and training flight. His instructor pilot (CFI) had verbally approved the flight, but did not endorse the student's…NTSB MKC82DA109Accident · No injuriesFinal reportBalloon Works Firfly 7 · Ballwin, MOThe student pilot was demonstrating his ability to make 3 landings to meet the flight requirements for a private pilot rating. The first 2 landing were without incident. After the third takeoff, an increase in the wind velocity was encountered. For the third…NTSB CHI82DA218Accident · Serious injuriesFinal reportMooney M20J · Duluth, MNPlt wx briefed at 2148 by kenora fss, ontario, Canada. Area & terminal forecasts indicated VFR conds to exist at Duluth. Subsequently, at 2151, Duluth arpt notamed closed, all rwy & approach lites out. The ILS rwy 9 g/s later went out of service, but not…NTSB ATL82DA169Accident · Minor injuriesFinal reportCessna 182B · Tuscaloosa, ALThe pilot had flown from eutaw to seale, AL to participate in a parachute activity. Although the plane was equipped for parachuting, it was not used for that purpose on that trip. Before returning to eutaw, the pilot used a dipstick to check the fuel and…NTSB NYC82DA130Accident · No injuriesFinal reportStinson 180-2 · Richland, NYWhile on a local flight, the pilot observed a front moving in, so he decided to return to the airport and land. He reported that there was no turbulence while he was on downwind or base and the wind sock was favoring runway 16. However, on final approach,…