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 ATL93LA154Accident · No injuriesLimited investigationFinal reportCessna 177RG · Valdosta, GAThe pilot's inadequate evaluation of inflight weather conditions which resulted in the inflight encounter with severe turbulence and subsequent overstress of the airframe.NTSB ATL93LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Roxboro, NCThe pilot's inadequate compensation for the wind conditions at the time of the takeoff. Factors were the wind gusts and windshear existing at the airport.NTSB ATL93FA151Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Laurinburg, NCThe pilot's VFR flight into instrument meteorological conditions (IMC), failure to maintain control of the aircraft after becoming spatially disoriented, and inadvertently exceeding the design stress limits of the aircraft. Factors related to the accident…NTSB SEA93FA187Accident · 3 fatalField investigationFinal reportCessna 180 · Cheyenne, WYImproper in-flight planning/decison by the pilot, which resulted in exceeding the design stress limits of the aircraft after encountering adverse weather. The weather conditions were related factors.NTSB SEA93FA179Accident · 1 fatalField investigationFinal reportCessna 172N · Lake Fork, IDPoor judgment of the pilot by flying while under the influence of alcohol and a drug, his continued flight into an area of adverse weather, and his failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors related to the accident…NTSB MIA93LA175Accident · Serious injuriesLimited investigationFinal reportRotec Engineering Rotec Rally 3 · Jay, FLFailure of the pilot in command to maintain airspeed (vs), inadvertent stall/mush by the pilot in command, and altitude insufficient for recovery. Contributing to the accident was lack of total experience by the pilot in command and in flight encounter with…NTSB DEN93FA101Accident · Serious injuriesField investigationFinal reportThunder and Colt 240A · Woody Creek, COAn inflight encounter with high winds which required a precautionary landing.NTSB DEN93FA100Accident · 6 fatalField investigationFinal reportCameron N-145 · Woody Creek, COFailure by the pilot in command to maintain proper altitude and visual lookout. A factor was high wind.NTSB ATL93LA142Accident · 1 fatalLimited investigationFinal reportWM. D. Butterill Mustang M1 · Wadesboro, NCThe pilot's intentional flight into IMC without the proper instrumentation, which resulted in the pilot's loss of aircraft control, and in flight breakup of the airplane.NTSB ATL93FA143Accident · 4 fatalField investigationFinal reportBeech C-90 · Augusta, GAWas the pilot's failure to adequately evaluate inflight weather conditions which resulted in a loss of control when the airplane encountered a thunderstorm.NTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…NTSB FTW93LA226Accident · Serious injuriesLimited investigationFinal reportSukane KR-2 · Clines Corners, NMThe pilot's inadvertent VFR flight into IMC and failure to maintain proper altitude. Factors were fog, rain, and the pilot's failure to obtain a weather brief.NTSB DEN93FA097Accident · 1 fatalField investigationFinal reportCessna 172M · Clines Corners, NMThe pilot's failure to maintain a safe and proper altitude. Factors were the pilot's failure to obtain a preflight weather briefing, dark night condition, and weather conditions that included obscuration, fog, and drizzle.NTSB ATL93LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Pelion, SCThe pilot's improper weather evaluation prior to commencing the flight. Factors were the fog and low ceiling weather conditions, and the rough, uneven terrain at the landing siteNTSB MIA93LA157Accident · Serious injuriesLimited investigationFinal reportBoeing 767-322ER · Caribbean SeaTurbulence encountered during cruise flight after entering Cirrus clouds.NTSB BFO93LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob Speed Astir II · Chester, VTThe pilot's inadequate inflight planning and an in flight encounter with a downdraft while on final approach.NTSB SEA93LA147Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Heber City, UTThe pilot's improper in-flight planning/decision and failure to maintain runway alignment during the go-around. The weather conditions were related factors.NTSB LAX93FA272Accident · 1 fatalField investigationFinal reportBell 47G2-M · S. Sn Francisco, CAThe pilot's inadequate preflight planning/preparation which resulted in flight into high winds, turbulence and windshear.NTSB ANC93LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Juneau, AKThe pilot continuing VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the mountainous terrain, the cloudy weather conditions in the pass, the pilot becoming disoriented, his lack of familiarity with the…NTSB CHI93FA200Accident · 2 fatalField investigationFinal reportBeech A-36 · Tony, WIthe pilot's decision to continue flight into known adverse weather and exceeded the design strees limits of the airplane. Factors associated with the accident were inadequate preflight planning/preparation, clouds, turbulence, icing conditions, and the lack…NTSB LAX93LA244Accident · 1 fatalLimited investigationFinal reportBeech K-35 · Eureka, NVThe pilot disregarding the advice that visual flight rules were not recommended; the pilot's inadequate weather evaluation along his route of flight; the pilot attempting flight into known adverse weather conditions; the pilot's loss of aircraft control due…NTSB LAX93FA242Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Diablo, CAThe pilot in command's continued flight into instrument meteorological conditions, and the improper in flight planning and decision making by the pilot.NTSB LAX93FA246Accident · 4 fatalField investigationFinal reportBeech S35 · Lovelock, NVThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the adverse weather conditions and mountainous terrain.NTSB FTW93FA176Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Texhoma, TXThe pilot's flight into known adverse weather conditions. Factors were the weather, the dark night, the airplane's lack of flight and navigational equipment, and the pilot's lack of instrument training and experience.NTSB DEN93LA065Accident · No injuriesLimited investigationFinal reportCessna 182A · Stratton, COThe selection of unsuitable terrain for a precautionary landing by the pilot in command. A factor was: misjudging the deteriorating weather.NTSB FTW93FA168Accident · 1 fatalField investigationFinal reportCessna 182M · Hebbronville, TXThe pilot's continued flight into IMC conditions. Factors were the low cieling and dark night conditions.NTSB ATL93LA097Accident · No injuriesLimited investigationFinal reportLet L-13 · Elberta, ALThe pilot's inadequate preflight planningNTSB LAX93LA228Accident · No injuriesLimited investigationFinal reportWSK PZL KR-03A · Avenal, CAThe glider's encounter with the downdraft. Contributing to this accidents were the turbulence and the powerlines.NTSB DEN93FA063Accident · 2 fatalField investigationFinal reportMooney M20E · Westcliffe, COThe pilot's loss of aircraft control as he attempted to turn away from a line of thunderstorms. Factors were thunderstorms and associated turbulence.NTSB LAX93FA223Accident · 2 fatalField investigationFinal reportCessna 172N · Lompoc, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude (or clearance) from mountainous terrain. Factors relating to the accident were: the low ceiling, fog, drizzle, obscuration, and mountainous…NTSB ANC93LA066Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot in commands improper compensation for the wind condition. A factor in the accident was the unfavorable wind.NTSB BFO93FA093Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Hancock, MDImproper planning/decision by the pilot, his initiation of VFR flt into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were fog, rain, the pilot's self induced…NTSB CHI93LA170Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Oconto, NEThe pilot's inability to maintain altitude after encountering a downdraft.NTSB BFO93LA084Accident · No injuriesLimited investigationFinal reportCessna A150M · Tarentum, PAFailure of the pilot to maintain directional control and proper runway alignment. The adverse weather condition and proximity of the parked aircraft were related factors.NTSB SEA93LA106Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Fort Benton, MTInadequate inflight planning/decision. Factors to the accident were: turbulence, downdrafts, poor weather evaluation and altitude not maintained.NTSB MIA93LA111Accident · No injuriesLimited investigationFinal reportCessna 172P · Orlando, FLThe pilot-in-command's failure to compensate for wind drift while landing, resulting in the aircraft going off the side of the runway and colliding with a pond.NTSB MIA93LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Miami, FLThe failure of the pilot-in-command to anticipate turbulence in observed weather and request that flight attendants be seated, before encountering the observed weather.NTSB DEN93FA047Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inflight encounterwith a microburst at an altitude insufficient to effect recovery.NTSB LAX93FA185Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Twin Peaks, CAThe pilot's inadvertent flight into IMC, the radar controller's issuance of incorrect terrain information, the controller's failure to issue a low altitude safety alert, and the controller's failure to provide emergency services.NTSB ATL93IA079Incident · Minor injuriesIncident investigationFinal reportShort Brothers SD 3-60 · Charlotte, NCThe failure of the operator to provide applicable weather information to the flight crew. Factors were the clear air turbulence, and the captain's failure to use the weather information and assistance that was available to her.NTSB DEN93FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Elbert, COThe pilot's inadvertent VFR flight into IMC. Factors were his lack of instrument training/experience, existing weather, and dark night conditions.NTSB DEN93FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Falcon, COInadequate supervision of the student pilot by the flight instructor. Factors were: IMC weather conditions, dark night, inaccurate weather evaluation by both the flight instructor and student pilot, and inadequate training of the student pilot.NTSB CHI93FA137Accident · 2 fatalField investigationFinal reportCessna 177B · Rensselaer, INThe pilot-in-command's failure to maintain aircraft control. Factors were fog and drizzle, and the pilot-in-command's continuing VFR flight into IMC conditions.NTSB FTW93FA128Accident · 2 fatalField investigationFinal reportCessna 172M · Hobart, OKInadvertent stall. Factors were the instructor pilot's spatial disorientation, his lack of total instrument time, the weather, and the dark night conditions.NTSB NYC93FA080Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Lapeer, NYThe pilot's improper inflight decision to continue flight into known icing conditions. Factors which contributed to the accident were: the pilot's failure to obtain updated weather information prior to departure, the icing conditions, and the degraded…NTSB CHI93FA135Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Kinsley, KSThe pilot initiated VFR flight into instrument meteorological conditions which resulted in a loss of aircraft control due to spatial disorientation. The adverse weather conditions were factors which contributed to the accident.NTSB SEA93LA095Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS4A · Wenatchee, WAMisjudged weather evaluation. Factors include high winds encountered on approach.NTSB DEN93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Llano, TXThe pilot's continued VFR flight into IMC. Factors were: low ceiling, dark night, and the pilot's lack of total instrument time.NTSB LAX93LA163Accident · No injuriesLimited investigationFinal reportCessna 177RG · Imperial, CAThe flight's encounter with a dust devil.NTSB ATL93MA068Accident · 4 fatalMajor investigationFinal reportFairchild SA227-TT · Blountville, TNFailure of the pilot to follow procedures concerning use of the engine inlet anti-ice system and/or continuous ignition while operating in icing conditions, which resulted in probable ice ingestion and loss of engine power; and the pilot's failure to maintain…