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 FTW98FA380Accident · No injuriesField investigationFinal reportBoeing 767-34AF · Houston, TXThe flight crew's decision to land with convective activity over the airport with a prevailing crosswind to a quartering tailwind, on an ungrooved, flooded runway, which resulted in hydroplaning and a loss of directional control. Factors contributing to the…NTSB NYC98FA180Accident · 5 fatalField investigationFinal reportBeech A23-24 · Shunk, PAThe pilot-in-command's attempted flight into known adverse weather conditions, his failure to maintain control of the aircraft, and his exceeding the airframe design limits resulting in separation of the outboard left wing. Contributing factors were clouds,…NTSB IAD98FA106Accident · 5 fatalField investigationFinal reportPiper PA-46-350P · Centerville, NYThe pilot's inadvertent flight into adverse weather conditions. Factors related to the accident were the pilot's failure to use weather detection equipment and use of airspeeds in excess of limitations.NTSB LAX98FA282Accident · 1 fatalField investigationFinal reportSimons Lancair 235 · Llano, CAPilot's inadvertent VFR flight into instrument meteorological conditions , which resulted in spatial disorientation and a subsequent loss of aircraft control.NTSB LAX98LA279Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Big Bear, CAThe pilot's encounter with an unfavorable wind condition, which caused the aircraft to descend at a rate that exceeded the aircraft's climb capability.NTSB CHI98FA343Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Beaver Dam, WIThe continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…NTSB ANC98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident were gusty winds.NTSB LAX98FA264Accident · 2 fatalField investigationFinal reportNorth American Navion · Salinas, CAthe pilot's attempt to continue visual flight operations into an area of known instrument meteorological conditions resulting in controlled flight into rising terrain.NTSB CHI98FA309Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · New Hampton, IAThe pilot's inadequate preflight/planning inspection and his continued flight into known adverse weather conditions that led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the airplane causing…NTSB FTW98LA352Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Huntsville, UTThe flight instructor's failure to ensure adequate altitude/clearance with terrain, resulting in an encounter with a downdraft, loss of airspeed, onset of a stall/mush, and collision with high terrain.. Contributing factors were high density altitude,…NTSB ANC98LA105Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cantwell, AKThe pilot's intentional continued VFR flight into IMC. Factors were the scattered to broken clouds, and the mountainous terrain.NTSB ANC98LA113Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kodiak, AKThe pilot's inadequate weather evaluation and compensation for wind conditions. Factors associated with the accident are wind gusts, a sudden windshift to a tailwind, the pilot's failure to abort the takeoff, and an inadvertent stall/mush.NTSB FTW98FA339Accident · 2 fatalField investigationFinal reportBeech H35 · La Veta, COThe pilot's poor judgment by intentionally flying into instrument meteorological conditions without proper certification. Factors were his failure to obtain a weather briefing, and the existing weather conditions that included clouds, rain, and obscuration.NTSB MIA98FA205Accident · 2 fatalField investigationFinal reportCessna 310Q · Port Orange, FLThe pilot's inadequate weather evaluation and his continued visual flight into instrument meteorological conditions which resulted in in-flight collision with trees. A related factor was the fog.NTSB ANC98LA108Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot's delay in aborting the takeoff prior to reaching the end of the lake. A factor associated with the accident was a downdraft.NTSB FTW98LA327Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COAn encounter with unanticipated windshear or a downdraft.NTSB ANC98LA103Accident · No injuriesLimited investigationFinal reportCessna 206 · Palmer, AKThe pilot's inadequate compensation for wind conditions, and inadequate clearance from mountainous terrain. Factors were the downslope winds and downdrafts.NTSB FTW98LA326Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS 4A · Salina, UTThe pilot's selection of unsuitable terrain to conduct a landing. Contributing was the loss of thermal lift and high vegetation.NTSB FTW98FA299Accident · 1 fatalField investigationFinal reportGrumman American AA-1A · Larkspur, COThe pilot inadvertently stalling the airplane and entering an unrecoverable spin. A factor was clear air turbulence.NTSB FTW98LA295Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Watkins, COThe pilot's inadequate evaluation of the weather which resulted in an encounter with a microburst. Contributing was the airplane's climb capability exceeded by the microburst, and rising terrain.NTSB IAD98LA074Accident · No injuriesLimited investigationFinal reportAmerican Blimp ABC-A-60 · Lock Haven, PAthe pilot's encounter with unforecasted downdrafts.NTSB LAX98FA211Accident · 6 fatalField investigationFinal reportEurocopter AS-350-BA · Mt. Waialeale, HIThe pilot's decision to continue VFR flight into deteriorating weather conditions consisting of lowering ceilings and visibility in mountainous terrain, which resulted in the inadvertent entry into instrument meteorological conditions and a collision with a…NTSB ATL98GA086Accident · No injuriesFinal reportEctor 305A (L-19) · Morganton, NCThe inflight encounter with a downdraft which led to a stall/mush and an inflight collision with the ground. Factors were the inadequate training in mountain flying and inadequate guidelines provided by the North Carolina Forest Service.NTSB MIA99FA050Accident · 2 fatalField investigationFinal reportCessna 172L · Macclenny, FLThe student pilot's attempted VFR flight into instrument meteorological conditions, resulting in a subsequent in-flight collision with trees and terrain. Contributing factors were, haze/smoke, the student pilot's failure to obtain a preflight weather…NTSB IAD98FA072Accident · 1 fatalField investigationFinal reportCessna 172M · Hebron, CTThe pilot's failure to obtain a weather briefing which resulted in inadvertent flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in this accident were low ceilings and…NTSB SEA98FA105Accident · 1 fatalField investigationFinal reportCessna 340 · Lincoln, MTThe pilot's improper or inadequate use of the aircraft's weather avoidance equipment, resulting in penetration of a Level 4 thunderstorm and subsequent loss of aircraft control from which the pilot did not recover. Factors included a thunderstorm and the…NTSB FTW98LA262Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-6A · Green River, UTThe pilot's failure to maintain airspeed. Factor's were the unforecasted weather (tail wind) and the inadvertent stall/spin.NTSB IAD98FA068Accident · 2 fatalField investigationFinal reportBeech F33A · Delaplane, VAThe pilot's inadequate in-flight decision which led to VFR flight into instrument meteorological conditions. Also causal was the pilot's failure to maintain adequate terrain clearance resulting in collision with mountainous terrain. Contributing factors were…NTSB MIA98LA180Accident · No injuriesLimited investigationFinal reportRobert E. Bean Wittman Tailwind W10 · Daytona Beach, FLThe pilot's poorly planned approach for not planning the intended touchdown point farther down the runway to avoid an area of known turbulence caused by terrain. Contributing to the accident was the turbulence.NTSB LAX98FA188Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Bangor, CAThe pilot's attempted flight into instrument meteorological conditions, loss of spatial orientation, and the resultant loss of airplane control. Contributing factors were his improper preflight and in-flight decisions, overconfidence in his personal ability,…NTSB LAX98LA187Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Descanso, CAthe certified flight instructor's disregard of the weather briefings and forecasted en route weather conditions, and, his failure to maintain adequate altitude/clearance in mountainous terrain. Contributing to the accident were instrument meteorological…NTSB MIA98FA182Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Statesville, NCThe pilot's attempted flight into adverse weather, resulting in a loss of control in flight. Contributing factors were the pilot's failure to obtain updated weather information, rain, and fog.NTSB FTW98FA256Accident · 3 fatalField investigationFinal reportEurocopter AS350BA · La Gloria, TXthe pilot's continued flight into adverse weather conditions resulting in a loss of control due to spatial disorientation. Contributing factors were the dark night illumination, the lack of visual cues, the pilot's lack of total instrument time, and the…NTSB NYC98FA124Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Dalton, MAThe pilot's decision to continue the flight into instrument meteorological conditions, resulting in a loss of control, and airplane stress limits to be exceeded. Factors in the accident, the pilot's decision to disregard the preflight weather briefing, and…NTSB LAX98LA180Accident · 1 fatalLimited investigationFinal reportVickers MK XVI · Blue Canyon, CAthe pilot's failure to maintain adequate terrain clearance and his VFR flight into instrument meteorological condition. Mountainous terran and obscurations are contributing factos. inadvertent flight into instrument meteorological conditions in mountainous…NTSB ANC98LA060Accident · No injuriesLimited investigationFinal reportCessna U206 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are variable winds, and windshear.NTSB ANC98LA057Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Tyonek, AKThe pilot's continued flight into adverse weather conditions, and his inadequate in-flight planning/decision. Factors in the accident were weather conditions consisting of a mountain wave, and downdrafts.NTSB LAX98LA175Accident · No injuriesLimited investigationFinal reportMooney M20F · Las Vegas, NVThe pilot's improper remedial action in controlling the aircraft during a go-around in a crosswind which resulted in a collision with a runway light and separation of the landing gear.NTSB FTW98LA243Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2B7 · Wichita, KSThe severe turbulence encountered as a result of the flightcrew's inadvertent flight into a rapidly developing thunderstorm.NTSB ATL98FA080Accident · 5 fatalField investigationFinal reportBell 206L-3 · Indian Trail, NCThe pilot's failure to maintain altitude while operating in adverse weather. A contributing factor was the incoming fog and high tension static wire.NTSB FTW98LA246Accident · No injuriesLimited investigationFinal reportMooney M20F · Moriarty, NMthe unfavorable wind condition, and failure of the pilot to adequately compensate for the wind condition during the landing flare.NTSB FTW98LA244Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Briggs, TXThe pilot's misjudgment of the distance and altitude. Factors were the lack of thermal lift and his diverted attention while on downwind.NTSB FTW98LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Longmont, COThe pilot's failure to properly position his foot for a high wind landing. Factors were high winds and windshear.NTSB FTW98LA224Accident · No injuriesLimited investigationFinal reportMooney M20F · Telluride, COThe pilot exceeded the crosswind capability performance of the aircraft, and his delayed response in initiating a go around. Factors were gusty, crosswind and tailwind conditions, and high density altitude.NTSB FTW98LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot's failure to maintain directional control of the aircraft during landing. Factors were gusty, crosswind conditions, the pilot's lack of experience in type of operation and geographic area, mountainous terrain, and high density altitude.NTSB ANC98FA048Accident · 2 fatalField investigationFinal reportCessna 172M · Palmer, AKThe pilot's intentional flight into known adverse weather conditions. Contributing factors were the terrain induced turbulence, clouds, the pilot's overconfidence in his abilities, and mountainous terrain conditions.NTSB MIA98LA160Accident · 2 fatalLimited investigationFinal reportM2 Sport 1000 · Semmes, ALThe pilot's failure to maintain control of the aircraft after an encounter with turbulence during initial climb out. A related factor was the turbulence.NTSB LAX98LA155Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Holbrook, AZThe pilot's failure to maintain directional control during a go-around after encountering a gust of wind.NTSB DCA98MA045Accident · Serious injuriesMajor investigationFinal reportDouglas DC-9-32 · Calhoun, GAThe failure of the flight crew to maintain adequate separation from hazardous meteorological conditions. Factors contributing to the accident were: (1) the failure of AirTran Airlines to provide adequate crewmember training and guidance regarding hazardous…NTSB SEA98LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Enumclaw, WAThe pilot's continued VFR flight into IMC conditions and his failure to maintain clearance from terrain. Clouds and mountainous terrain were a factor.