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 DEN02LA075Accident · Serious injuriesLimited investigationFinal reportAmerican General AA5B · Worland, WYthe pilot's selection of an inadequate altitude for crossing mountainous terrain, resulting in a collision with trees. A contributing factor was the downdraft.NTSB ANC02LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's inadequate weather evaluation, which resulted in a turbulence encounter and subsequent collision with a river embankment during maneuvering flight. A contributing factor was the presence of terrain induced turbulence.NTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.NTSB SEA02LA162Accident · Serious injuriesLimited investigationFinal reportInfinity Powered Parachute · Lewistown, MTInadequate preflight planning and inadvertent flight into adverse weather conditions. High wind conditions was a factor in the accident.NTSB ANC02FA057Accident · 1 fatalField investigationFinal reportHughes OH-6A · Central, AKThe pilot's intentional flight into adverse weather conditions, and his failure to maintain altitude/clearance, which resulted in an in-flight collision with terrain. Factors contributing to the accident were the snow and whiteout weather conditions.NTSB SEA02LA101Accident · No injuriesLimited investigationFinal reportCessna 182Q · Yellow Pine, IDCompensation for wind conditions inadequate during the approach for landing. A downdraft was a factor.NTSB MIA02FA111Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Osteen, FLthe pilot's inadequate weather evaluation and his failure to maintain control of the airplane after entering an area of thunderstorms resulting in an in-flight separation of the right wing and right horizontal stabilizer and impact with the ground during an…NTSB DEN02TA052Accident · No injuriesFinal reportBeech 58P · Grand Junction, COthe pilot's inadvertent flight into adverse weather conditions. A factor contributing to the accident was the terrain-induced turbulence.NTSB FTW02LA177Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Nederland, COthe pilot's inadvertent in-flight encounter with severe turbulence, which resulted in main rotor-tailboom contact and the separation of the tailrotor drive shaft.NTSB DEN02LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver, UTthe pilot's selection of unsuitable terrain on which to make a forced landing. Contributing factors were mountain waves (wind shear) and crosswind.NTSB ANC02FA042Accident · No injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's selection of a fuel tank that did not contain a usable quantity of fuel. Factors associated with the accident are the dirt berm, meteorological conditions conducive to carburetor icing, and carburetor ice.NTSB NYC02FA106Accident · 2 fatalField investigationFinal reportCessna A185F · Pleasant Mount, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.NTSB MIA02FA102Accident · 1 fatalField investigationFinal reportBeech F33A · Conway, SCThe failure of the pilot to request in-flight weather avoidance assistance and his poor in-flight planning/decision for flying into a Level 5 thunderstorm resulting in an in-flight loss of control, uncontrolled descent, and subsequent in-flight collision with…NTSB ATL02LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Atlanta, GAIn-flight encounter with turbulence during descent, that resulted in an serious injury to the flight attendant.NTSB LAX02FA179Accident · 1 fatalField investigationFinal reportCessna 182P · Pleasanton, CAThe pilot's inadvertent flight into adverse weather and his failure to maintain clearance. Contributing factors included the pilot's inadequate preflight planning, the low ceilings, and the dark night conditions.NTSB NYC02LA103Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Roxbury, NYThe airplane encountering an unanticipated downdraft that exceeded the climb performance of the airplane.NTSB ANC02FA038Accident · 2 fatalField investigationFinal reportPiper PA-18 · Lime Village, AKThe pilot's inadequate evaluation of weather and his inability to maintain aircraft control. A contributing factor was high winds due to thunderstorm outflow activity.NTSB ANC02LA039Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of weather conditions, which precipitated an in-flight loss of control and subsequent collision with terrain. A factor contributing to the accident was the tailwind.NTSB NYC02LA092Accident · No injuriesLimited investigationFinal reportBlanik L-13 · Saratoga Spring, NYThe glider encountering an unanticipated downdraft, which resulted in insufficient altitude to reach a suitable landing area.NTSB LAX02LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)An in-flight encounter with clear air turbulence and wind shear, which resulted in a serious injury to a flight attendant.NTSB NYC02LA088Accident · Serious injuriesLimited investigationFinal reportBoeing 767-224 · Atlantic OceanThe airplane's inadvertent encounter which clear air turbulence during cruise flight.NTSB CHI02LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Springfield, MOThe flightcrew's failure to follow weather avoidance prcedures and their delay in activating the seat belt sign. Factors were the turbulent thunderstorm weather conditions, and the failure of the National Weather Service to issue an applicable in-flight…NTSB MIA02FA084Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-35 · Carolina, PRThe failure of the pilot to maintain airspeed (Vs) while maneuvering following inadvertent encounter with clouds resulting in an inadvertent stall and uncontrolled descent and subsequent in-flight collision with trees, a wall, and a building.NTSB LAX02LA138Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-114 · Reno, NVThe failure of an undetermined cabin crewmember to securely close an aft galley compartment door, which necessitated the injured crewmember leaving her seat to secure the compartment door.NTSB FTW02FA118Accident · 2 fatalField investigationFinal reportCessna T182 · Amarillo, TXThe pilot's failure to maintain clearance with the power plant while maneuvering, and his intentional flight into adverse weather conditions. Contributing factors were low clouds, fog, the power plant, and low altitude flight.NTSB ATL02FA077Accident · 1 fatalField investigationFinal reportBeech E35 · Blowing Rock, NCThe pilot's continued VFR flight in to known IMC, which resulted in an in-flight collision with trees in mountainous terrain. A factor was low ceiling.NTSB LAX02FA131Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Three Rivers, CAthe pilot's attempt to continue visual flight in instrument meteorological conditions in mountainous terrain. Contributing factors were low ceiling and mountainous terrain.NTSB DEN02LA036Accident · No injuriesLimited investigationFinal reportBell 206B-III · Leadville, COthe pilot's inadvertent flight into adverse weather, which resulted in a collision with terrain. A contributing factor was the downdraft.NTSB NYC02IA076Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Jefferson, NYAn in-flight encounter with lightning, which severed two of the four elevator cables.NTSB FTW02LA101Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Lamar, COthe pilot's delay in taking immediate remedial action after the flight encountered icing conditions, which resulted in a collision with terrain. A contributing factor to the accident was the icing condition.NTSB ANC02FA025Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Manokotak, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with terrain during cruise flight. Factors in the accident were low ceilings, snow, and mountainous snow-covered terrain.NTSB DCA02MA029Accident · Serious injuriesMajor investigationFinal reportMcDonnell Douglas DC-10-30 · int'l watersThe flight attendant's injuries were a result of her unsecured lap belt and shoulder harness for undetermined reasons, and the oscillations of the airplane, which were caused by turbulence and large control column inputs by the first officer. Contributing to…NTSB FTW02FA095Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Marianna, ARThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain while maneuvering. Factors were, the low cloud and mist weather conditions, and the dark night light conditions.NTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.NTSB ANC02LA021Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Whittier, AKThe pilot's Failure to maintain a proper descent rate during landing. Factors associated with the accident are variable wind conditions, and the pilot's improper approach to the landing site.NTSB ANC02FA020Accident · No injuriesField investigationFinal reportCessna 208B · Barrow, AKThe pilot's continued flight into adverse weather conditions, and an inadvertent stall. Factors associated with the accident are fog, obscuration, and icing conditions.NTSB ATL02FA051Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Vero Beach, FLThe flight's encounter with isolated severe to extreme turbulence that resulted in an in-flight breakup of the airplane and subsequent impact with terrain.NTSB ATL02LA050Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Blowing Rock, NCThe pilot's in-flight decision to continue flight into an area with high winds that resulted in an in-flight encounter with a downdraft and subsequent loss of control of the airplane and collision with terrain.NTSB NYC02LA065Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Beaumont, TXAn inadvertent encounter with convective induced turbulence, which injured a flight attendant. Factors were the failure of the airline to supply direction to the flight crew to indicate when the flight attendants could begin cabin service, and the convective…NTSB MIA02LA061Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Belle Glade, FLthe pilot continued flight into known adverse weather resulting in a loss of control and subsequent impact with the ground.NTSB ATL02FA048Accident · 2 fatalField investigationFinal reportBell 206L-1 · New Smyrna Bch., FLThe pilot continued visual flight into instrument conditions that resulted in the in-flight collision with trees. Factor were the pilot's alcohol impaired condition, and low cloud conditions.NTSB DEN02LA029Accident · Serious injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Broomfield, COthe flight attendant's failure to fasten his seatbelt when warned of possible turbulence. A contributing factor was the severe turbulence.NTSB ANC02FA014Accident · 1 fatalField investigationFinal reportCessna 206 · Bethel, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate ground clearance, which resulted in an in flight collision with terrain. Factors associated with the accident were flat light conditions, and…NTSB CHI02LA070Accident · 2 fatalLimited investigationFinal reportBellanca 17-30A · Alexandria, MNThe pilot's disregard of the weather evaluation and his attempt to fly into known adverse weather without an instrument rating. Factors in the accident were the low ceiling, the low visibility, and the icing conditions.NTSB LAX02LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Groveland, CAthe pilot's improper preflight planning and improper weather evaluation.NTSB FTW02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-46T · Albuquerque, NMThe pilot's failure to obtain/maintain proper runway alignment. Contributing factors were the pilot's inadvertant flight into adverse weather conditions, the pilot not performing a missed approach, and the low ceiling and snow weather conditions .NTSB ATL02FA031Accident · 5 fatalField investigationFinal reportCessna 441 · Rio Grande, PRThe pilot continued visual flight flight into instrument flight conditions resulting in an in-flight collision with terrain. Low clouds were a factor.NTSB ATL02LA027Accident · No injuriesLimited investigationFinal reportFlugzeugbau DG-200 · Benton, TNThe pilot's inadvertent encounter with a downdraft while maneuvering in a ridge lift during a turn resulting in an in-flight collision with trees.NTSB LAX02LA053Accident · No injuriesLimited investigationFinal reportCessna T210N · San Diego, CAThe pilot's failure to land on the runway with sufficient runway remaining as a result of his improper IFR procedure by his failure to maintain visual contact with the runway environment, and to execute a missed approach.NTSB FTW02LA053Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Sierra Blanca, TXthe pilot's inadverent VFR flight into instrument meteorological weather conditions which resulted in an in-flight collision with terrain. Contributing factors were the night light conditions and the clouds.