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 LAX05FA311Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Baker, CAThe pilot's continued VFR flight into adverse weather conditions that resulted in a collision with mountainous terrain. Contributing to the accident was the obscuration of mountainous terrain by rain and low clouds, moderate turbulence, and the pilot's…NTSB IAD05LA137Accident · 1 fatalLimited investigationFinal reportPiper PA-24-260 · Tiffin, OHThe pilot's decision to takeoff in weather below the published takeoff minimums, which resulted in spatial disorientation and the airplane's collision with trees and terrain. Factors in the accident were the instrument meteorological conditions, and the…NTSB SEA05LA194Accident · No injuriesLimited investigationFinal reportCessna 182P · Yellow Pine, IDThe pilot's improper preflight planning/preparation during takeoff. A factor was the windshear.NTSB DEN05LA140Accident · No injuriesLimited investigationFinal reportCessna A185F · Boulder, COthe pilot's improper flare which resulted in a hard landing and his subsequent failure to recover from the bounced landing. Contributing factors were the pilot's improper in-flight decision to land in deteriorating weather conditions, turbulence associated…NTSB LAX05CA297Accident · No injuriesData collectionFinal reportBeech C23 · Jiggs, NVthe pilot's encounter with a downdraft.NTSB ATL05LA154Accident · 2 fatalLimited investigationFinal reportSamson Seawind 3000 · Wrightsville Bh, NCThe pilot's improper preflight decision to attempt night VFR flight into IMC, which resulted in an inflight encounter with weather and the pilot's subsequent loss of control of the airplane due to spatial disorientation.NTSB DEN05FA128Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Vail, COthe pilot's improper in-flight planning and decision making and failure to maintain clearance from the terrain. Contributing factors include the pilot's attempt to takeoff from the highway, high density altitude, the downdrafts, and the sign.NTSB DEN05CA129Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Cedaredge, COthe pilot's failure to maintain aircraft control, and the pilot's improper in-flight planning. Contributing to the accident was the wind shift, resultant tailwind, and the inadvertent stall.NTSB ATL05FA148Accident · 2 fatalField investigationFinal reportBeech A36 · Jamestown, TNThe pilot's decision to continue flight into an area of known thunderstorm activity, which resulted in loss of aircraft control and collision with trees and the ground during the result uncontrolled descent.NTSB DFW05CA211Accident · No injuriesData collectionFinal reportSchleicher ASW-27b · Encinal, TXThe pilot's misjudgment of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB ATL05FA142Accident · 1 fatalField investigationFinal reportBeech V35B · Ellijay, GAThe pilot's continued cruise flight under visual flight rules into known adverse weather, which resulted in his loss of control of the airplane due to spatial disorientation, and an uncontrolled descent and collision with terrain. A factor associated with the…NTSB MIA05CA144Accident · Minor injuriesData collectionFinal reportGrumman American G-164 · Sabana Grande, PRThe pilot's inadvertent encounter with a downdraft in mountainous terrain resulting in an uncontrolled descent and collision with the terrain.NTSB LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…NTSB NYC05CA127Accident · No injuriesData collectionFinal reportYakovlev 55M · New Marlboro, MAThe pilot's improper weather evaluation which resulted in a precautionary off airport landing; and his improper flare which resulted in a hard landing. A factor in this accident was weather associated with thunderstorm activity.NTSB DEN05CA116Accident · No injuriesData collectionFinal reportCessna 210E · Saratoga, WYthe pilot's failure to maintain aircraft control and the pilot's improper preflight planning/preparation. Contributing factors include the pilot's failure to maintain airspeed resulting in an inadvertent stall/mush, the pilot's failure to calculate a weight…NTSB DFW05CA198Accident · Minor injuriesData collectionFinal reportAmateur Built Varieze · Alco, ARThe pilot's pilots failure to refuel the airplane. Contributing factors were the low ceilings and the lack of suitable terrain for the precautionary landing.NTSB DEN05FA114Accident · 3 fatalField investigationFinal reportBeech N35 · West Jordan, UTthe pilot's improper preflight planning, his attempted flight into adverse weather conditions, and the stall resulting in the loss of control and subsequent crash. Factors contributing to the accident were the pilot's inadequate evaluation of the weather…NTSB DEN05LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Grand Junction, COthe pilot's failure to maintain aircraft control during aborted landing and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the encounter with wind shear during final approach and landing.NTSB DCA05MA083Accident · Serious injuriesMajor investigationFinal reportBoeing 767-232 · Raleigh-Durham, NCAn inadvertent in-flight encounter with clear air turbulence.NTSB DEN05LA109Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Canon City, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors include the crosswind and windshear conditions.NTSB MIA05CA125Accident · No injuriesData collectionFinal reportCessna 152 · Williston, FLThe inadequate weather evaluation by the pilot-in-command which resulted in the in-flight encounter with rain and thunder that resulted in a precautionary landing and subsequent on-ground collision with a ditch.NTSB LAX05LA216Accident · Serious injuriesLimited investigationFinal reportCessna 337G · Mojave, CAthe pilot's encounter with a downdraft or wind shear during takeoff the initial climb.NTSB ATL05LA105Accident · 1 fatalLimited investigationFinal reportCessna T182T · Naples, FLThe pilot continued flight into known thunderstorm activity that resulted in the loss of control and the subsequent collision with water. A factor was the controller's failure to provide the pilot with convective intensity.NTSB ATL05FAMS1Accident · 3 fatalMissing aircraftFinal reportPiper PA-23 · Ft Pierce, FLThe pilot's continued flight into known thunderstorm activity that resulted in the loss of control and the subsequent collision with water. A factor was the controller's failure to provide the pilot with convective intensity.NTSB LAX05FA213Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Mt. Shasta, CAThe pilot's continued cruise flight into instrument meteorological conditions, which resulted in the pilot's controlled flight into high mountainous terrain (CFIT).NTSB NYC05CA101Accident · No injuriesData collectionFinal reportValentin Taifun 17E · Waterbury, CTThe pilots inadvertent encounter with a downdraft, which resulted in the airplane impacting trees.NTSB ATL05CA100Accident · No injuriesData collectionFinal reportGoodyear GZ-20A · Coral Springs, FLThe pilot's inadequate in-flight planning/decision which resulted in an in-flight encounter with weather (thunderstorm outflow), and downdrafts, loss of control and subsequent collision with trees and transmission wires.NTSB ANC05LA088Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Anchorage, AKA lightning strike during a normal descent for landing, which resulted in structural damage to the airplane's left aileron.NTSB DEN05LA090Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-319-114 · Scottsbluff, NEthe inflight encounter with moderate turbulence.NTSB CHI05LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Mapleton, NDThe pilot's continued flight into instrument meteorological conditions and his failure to maintain clearance from an object during the precautionary landing. The heavy rain and the unknown object were factors.NTSB CHI05LA135Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · New Chicago, INThe inadvertent encounter with convectively induced turbulence (CIT) while the aircraft was descending into the terminal area.NTSB ATL05CA092Accident · Minor injuriesData collectionFinal reportCessna 172 · Crossville, TNThe pilot's continued VFR flight into IMC conditions which resulted in an in-flight collision with trees. A related factor was the clouds.NTSB LAX05CA190Accident · No injuriesData collectionFinal reportS.A. Centrair Pegase 101D · Williams, CAloss of thermal lift during flight that resulted in a forced landing in an area without suitable landing terrain. Also causal was the pilot's inadequate compensation for the existing crosswind.NTSB DFW05CA137Accident · Minor injuriesData collectionFinal reportPZL-Mielec M18 · Clover Bend, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the dust devil (whirlwind) encountered.NTSB LAX05FA184Accident · 2 fatalField investigationFinal reportBellanca 14-13-3 · Caliente, CAThe pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…NTSB LAX05LA171Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Jean, NVthe pilot's in-flight decision to continue a flight with weak thermal lift activity, and his delayed recognition of a loss of altitude while attempting to find a thermal in which to soar. A factor in the accident was the lack of suitable terrain for the…NTSB NYC05MA083Incident · No injuriesMajor investigationFinal reportBoeing 717-200 · Union Star, MOA loss of reliable airspeed indication due to an accumulation of ice on the air data/pitot sensors. Contributing to the incident was the flight crew's improper response to the erroneous airspeed indications, their lack of coordination during the initial…NTSB LAX05FA167Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Elko, NVThe pilot's continued VFR cruise flight into instrument meteorological conditions in mountainous terrain, and his failure to maintain clearance from terrain. A contributing factor was mountain obscuration and clouds.NTSB DEN05FA074Accident · 4 fatalField investigationFinal reportCessna T210G · Ouray, COthe pilot's inadvertent flight into adverse weather conditions, loss of control, and resulting exceedence of the design stress limits of the aircraft. which led to an in-flight structural failure. Factors in the accident included the pilot's inadequate…NTSB LAX05CA161Accident · No injuriesData collectionFinal reportSchempp-Hirth Discus 2b · Peoria, AZthe glider pilot encountered a downdraft that forced him to land in rough terrain.NTSB NYC05CA078Accident · No injuriesData collectionFinal reportCessna 150F · China, METhe pilot's improper inflight decision to land in a field instead of a nearby airport, after encountering deteriorating weather conditions. A factor was the deteriorating weather conditions.NTSB DFW05LA112Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Little Rock, ARAn encounter with moderate turbulence during cruise flight.NTSB LAX05LA144Accident · Serious injuriesLimited investigationFinal reportBishop RV6A · Dulzura, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising mountainous terrain.NTSB CHI05FA103Accident · 1 fatalField investigationFinal reportCessna 150M · Festus, MOThe pilot's inadequate preflight weather evaluation and his failure to maintain aircraft control during the landing approach. A contributing factor to the accident was the pilot's inadvertent flight in close proximity to a severe thunderstorm associated with…NTSB NYC05CA072Accident · No injuriesData collectionFinal reportCessna 172B · Collegeville, PAThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident was the downdraft wind conditions.NTSB LAX05LA143Accident · Serious injuriesLimited investigationFinal reportFirefly Balloon Firefly 11 · Saint Helena, CAThe pilot's encounter with wind shear during landing, which resulted in a hard touchdown.NTSB CHI05CA092Accident · No injuriesData collectionFinal reportMooney M20M · Lincoln, NEThe pilot inadvertently exceeded the design limits of the airplane during the recovery from the loss of control due to the unanticipated severe turbulence. Factors to the accident were the turbulence in clouds and the main landing gear collapse.NTSB ATL05CA072Accident · No injuriesData collectionFinal reportSchleicher ASW19b · Henderson, NCThe pilot's misjudgment of the landing area which resulted in overshooting the touchdown point. A factor was the in-flight encounter with weather (No thermal lift).NTSB DEN05CA067Accident · No injuriesData collectionFinal reportCessna 182M · Cortez, COthe pilot's failure to maintain aircraft control during the landing flare. Contributing factors include the pilot's improper in-flight planning/decision making, the crosswind and the gusty surface winds.NTSB LAX05FA132Accident · 3 fatalField investigationFinal reportCessna T210L · Tranquility, CAthe pilot's in-flight loss of control due to spatial disorientation and a likely accumulation of airframe ice that led to a high speed descent and a structural breakup once the aerodynamic forces exceeded the strength limits of the structure. A factor in the…