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 SEA07CA162Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Nimbus-3DM · Minden, NVThe flight's encounter with severe downdrafts during cruise flight. Contributing factors were the pilot's inadvertent selection of unsuitable terrain with hidden obstructions.NTSB SEA07FA148Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Quilcene, WAThe pilot's continued flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain. Factors contributing to the accident included the low clouds which obscured the rising, mountainous terrain.NTSB ATL07GA087Accident · Serious injuriesFinal reportBell 206B · Cedartown, GAThe pilot's failure to maintain control of the helicopter while maneuvering. Contributing to the accident were strong gusty winds.NTSB DEN07LA098Accident · Serious injuriesLimited investigationFinal reportBoeing 757-251 · Denver, COThe inadvertent encounter with moderate turbulence during the approach which resulted in a serious injury to the flight attendantNTSB SEA07LA132Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Lake Elsinore, CAThe glider's encounter with a downdraft while in the traffic pattern, resulting in insufficient altitude to reach the airport. A contributing factor was the pilot's selection of an unsuitable off-airport landing area, which led to an on-ground collision with…NTSB DEN07CA092Accident · No injuriesData collectionFinal reportCentrair 101C · Alamogordo, NMThe pilot's inability to control the glider after encountering the downdraft causing the glider to land short of the dirt strip. Factors contributing to the accident were the downdraft and the runway marker.NTSB ANC07CA033Accident · No injuriesData collectionFinal reportCessna 185 · Cantwell, AKThe pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in a descent into high vegetation, and a nose over. Factors contributing to the accident were the pilot's inadequate weather evaluation and a downdraft.NTSB SEA07CA123Accident · No injuriesData collectionFinal reportPiper PA28-235 · San Jose, CAWind shear encounter during approach for landing.NTSB SEA07LA118Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Kayenta, AZThe overstress separation of both ruddervators during cruise flight. Contributing to the accident was the flight's encounter with turbulence.NTSB DFW07LA102Accident · 1 fatalLimited investigationFinal reportWalker Zenith Zodiac 601 XL · Canadian, TXThe pilot's improper pre-flight planning and decision to depart into deteriorating weather conditions, which resulted in a loss of control and subsequent in-flight break up.NTSB DEN07FA089Accident · 1 fatalField investigationFinal reportSchleicher Alexander ASH 26E · Castle Rock, COthe pilot's failure to maintain aircraft control resulting in an inadvertent stall/mush.NTSB MIA07LA086Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR 72-212 · San Juan, PRIn-flight encounter with turbulence that resulted in injuries to a flight attendant and a passenger.NTSB ATL07FA081Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Dawsonville, GAThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, with a low cloud ceiling, over mountainous terrain.NTSB NYC07LA105Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · La Plata, MDAn in-flight encounter with turbulence and the flight crew's failure to advise the cabin crew about potential forecast turbulence, as reported by the flight attendant.NTSB LAX07CA133Accident · No injuriesData collectionFinal reportJiran FJ-1 · Banks, ORthe pilot's misjudged distance/altitude that led to a failure to attain the proper touchdown point.NTSB MIA07LA084Accident · 5 fatalLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot's continued visual flight rules flight into known adverse weather conditions, resulting in an in-flight loss of aircraft control. Contributing to the accident were thunderstorms.NTSB SEA07FA106Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Tehachapi, CAThe pilot's VFR flight into IMC and his ensuing failure to maintain terrain clearance. Contributing factors were the cloudy weather conditions and the mountainous terrain.NTSB LAX07LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Los Angeles, CAThe flight's encounter with a turbulence event that occurred while the flight attendants were unseated. Contributing to the accident was the apparent conflicting information provided by the flight deck to the flight attendants and the flight attendants'…NTSB MIA07LA073Accident · 2 fatalLimited investigationFinal reportPiper PA-46-310P · Bird Cay, BahamasThe pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.NTSB DEN07LA082Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Luna, NMthe pilot's failure to activate the pitot heat while flying in the clouds and visible moisture, resulting in pitot tube contamination and the subsequent loss of air data for the primary flight display. Contributing to the accident was the icing conditions,…NTSB NYC07FA091Accident · 3 fatalField investigationFinal reportPiper PA-30 · Trappe, MDThe pilot's improper decision to fly into an area of thunderstorms, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the thunderstorm.NTSB ATL07LA067Accident · 1 fatalLimited investigationFinal reportPiper PA28-181 · New Tazewell, TNThe pilot's failure to maintain aircraft control. Contributing to the accident was the non-instrument rated pilot's continued flight from visual meteorological conditions into instrument meteorological conditions, and a low cloud ceiling.NTSB LAX07FA103Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Tooele, UTThe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight separation of the wings and horizontal stabilizers. Contributing to the accident were the night lighting conditions, clouds, turbulence and icing conditions.NTSB SEA07CA067Accident · Minor injuriesData collectionFinal reportCessna 182H · Jean, NVThe pilot's failure to adequately compensate for the wind conditions during final approach, which resulted in a loss of control and an in-flight collision with terrain. A contributing factor was the windshear condition encountered.NTSB CHI07LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 777 · Chicago, ILAn in-flight encounter with turbulence during cruise flight.NTSB DFW07CA079Accident · Serious injuriesData collectionFinal reportBuckeye Breeze XL · Buffalo City, ARThe pilot's failure to maintain control of the aircraft during approach. A contributing factor was the reported encounter with severe turbulence.NTSB CHI07FA073Accident · 4 fatalField investigationFinal reportCessna 340A · Council Bluffs, IAThe pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.NTSB DFW07FA067Accident · 2 fatalField investigationFinal reportCessna 414 · Rocksprings, TXThe pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.NTSB ATL07FA040Accident · 4 fatalField investigationFinal reportBeech A36 · Hinesville, GAThe pilot's failure to maintain aircraft control resulting in the in-flight breakup of the airplane due to aerodynamic overload. Contributing to the accident were airframe icing and the pilot's impairment by illegal drugs.NTSB ANC07CA019Accident · No injuriesData collectionFinal reportAero Commander 100 · Manokotak, AKThe pilot's continued VFR cruise flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain. Factors associated with the accident were fog, low ceilings, snow showers, and snow-covered terrain.NTSB ATL07FA038Accident · 2 fatalField investigationFinal reportCessna 172K · Bessemer, ALThe non-instrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions.NTSB LAX07CA077Accident · Serious injuriesData collectionFinal reportBombardier DHC-8-103 · Kaunakakai, HIan in-flight encounter with clear air turbulence, which resulted in a serious injury to a deadheading crewmember.NTSB NYC07CA060Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Bath, PAThe pilot's misjudged altitude/distance while on approach, which resulted in an in-flight collision with trees during an off airport landing. A factor in the accident was the loss of lift.NTSB DEN07CA056Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe pilot's improper flare during landing and failure to maintain directional control during the landing roll. Factors were the gusting winds and the crosswinds.NTSB DEN07FA054Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Centennial, WYthe pilot's inadvertent flight into adverse weather conditions resulting in a loss of aircraft control. Contributing factors include the pilot's improper preflight planning and decision making, the pilot's spatial disorientation, the pilot's lack of night…NTSB DEN07FA053Accident · 2 fatalField investigationFinal reportCessna 182R · Waltman, WYthe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC) and failure to maintain terrain clearance resulting in controlled flight into terrain. Contributing factors were the pilot's improper preflight and…NTSB DEN07FA045Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Manzanola, COthe pilot's failure to maintain control of the airplane after an inadvertent encounter with instrument meteorological conditions resulting in the subsequent impact with terrain. Contributing factors were the pilot's inadequate preflight planning, self-induced…NTSB DFW07FA049Accident · 3 fatalField investigationFinal reportCessna 172H · Armstrong, TXThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the dark night conditions, the clouds. low ceilings, and the pilot's limited night and instrument experience.NTSB ANC07CA010Accident · Minor injuriesData collectionFinal reportBeech BE-23 · Asheville, NCThe pilot's continued VFR cruise flight into instrument meteorological conditions, which resulted in a forced landing and collision with trees. Factors associated with the accident were fog and low ceilings.NTSB LAX07LA065Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Lake Hughes, CAThe pilot's inadequate preflight planning/preparation and attempted flight into known adverse weather during cruise, and his failure to maintain an adequate airspeed margin that resulted in a stall/spin. Turbulence was a factor.NTSB LAX07CA066Accident · Minor injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe flight's encounter with a low ceiling while on approach that necessatiated an off-airport precautionary landing on unsuitable terrain. Obstructions were a factor.NTSB CHI07FA046Accident · 2 fatalField investigationFinal reportRockwell International 114 · Jasper, TNThe pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…NTSB MIA07FA029Accident · 5 fatalField investigationFinal reportCessna 421B · Greenhead, FLThe pilot-in-command's improper planning/decision and continued flight into known adverse weather which resulted in an encounter with a level 5 thunderstorm.NTSB LAX07FA061Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bridgeport, CAThe pilot's attempted VFR flight into instrument meteorological conditions and subsequent failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was mountain obscuration.NTSB CHI07CA040Accident · No injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's unexpected encounter with wind shear and his inability to remain clear of the trees while on final approach to land.NTSB LAX07FA056Accident · 3 fatalField investigationFinal reportBell 412SP · Hesperia, CAThe pilot's inadvertent encounter with instrument meteorological conditions and subsequent failure to maintain terrain clearance. Contributing to the accident were the dark night conditions, fog, and mountainous terrain.NTSB SEA07LA028Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Bountiful, UTThe pilot's improper decision to fly up a mountain canyon at low level without knowledge of the wind conditions. Factors associated with the accident are gusty winds, downdrafts, and rough/uneven terrain.NTSB CHI07FA032Accident · 2 fatalField investigationFinal reportCessna 172 · Crookston, MNThe pilot's inadvertent flight into instrument meteorological conditions which led to his spatial disorientation and subsequent loss of control. Factors were the snow, the low ceiling, and the pilot's lack of instrument flight experience.NTSB DFW07CA014Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Ethel, ARThe pilot's failure to maintain clearance with the trees and terrain. Contributing factors were the prevailing fog and the dark night conditions.NTSB SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.