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 SEA91LA018Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Bremerton, WAThe pilot did not maintain altitude.NTSB SEA91FA019Accident · 1 fatalField investigationFinal reportCessna 206 · Pullman, WAThe pilot displayed inadequate inflight planning and decision making. Factors to the accident were: the weather was obscured, the dark night condition, and a proper altitude not maintained.NTSB CHI91FA026Accident · 1 fatalField investigationFinal reportCessna 182D · Walker, MIVFR flight into IMC conditions. Factors related to the accident are failure to obtain a preflight weather briefing, becoming lost/disoriented, induction air filter icing, excessive workload, and lack of total experience in type of operation.NTSB FTW91FA012Accident · 5 fatalField investigationFinal reportPiper 601P · Nacogdoches, TXFailure of the pilot to follow IFR procedures and maintain the proper altitude. Factors related to the accident were: the adverse weather conditions, dark night, low fuel state of the aircraft, and trees at the accident site.NTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.NTSB SEA91LA014Accident · No injuriesLimited investigationFinal reportCessna 402B · Pocatello, IDThe loss of engine power due to a burned piston resulting from arcing and partial failure of the left magneto because of improper overhaul, the contamination of the right magneto and improper adjustment of the fuel system at the last major engine overhaul;…NTSB NYC91FA025Accident · 2 fatalField investigationFinal reportBeech A36 · Bradford, PAThe pilot's failure to maintain adequate terrain clearance while maneuvering to land during an instrument approach. Factors related to the accident were: the pilot's failure to obtain a weather briefing prior to departure, his delayed decision to make an…NTSB CHI91LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Latham, KSFailure of the pilot to maintain a proper altitude.NTSB DEN91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Abilene, TXAn in flight encounter with turbulence. Factors were the pilot's inadequate aircraft preflight.NTSB LAX91LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe failure of the flight instructor to ensure that an adequate airspeed was maintained during the final approach for the existing wind conditions; to adequately supervise the conduct of the flight; and to arrest the rate of descent prior to touch down.NTSB SEA91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mullan, IDThe pilot's VFR flight into instrument meteorological conditions (IMC). The adverse weather and terrain conditions were related factors.NTSB SEA91LA004Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Hamilton, MTThe pilot's inadequate compensation for wind conditions.NTSB FTW91LA005Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's decision to enter an area of forecast thrunderstorms. The factor was the severe downdraft encountered.NTSB DEN91LA007Accident · Minor injuriesLimited investigationFinal reportBalloon Works AX9 · Cedar Crest, NMPilot's delayed precautionary landing and the subseuqent fuel exhaustion. A factor was the encounter with high winds in flight.NTSB MIA91LA005Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Cape Canaveral, FLFailure of the captain to follow procedures, his improper in-flight planning/decision by allowing the aircraft to continue into the overhang (anvil) of a thunderstorm, failure of the passengers to abide by procedures/instructions concerning use of seat belts,…NTSB DEN91FA002Accident · 1 fatalField investigationFinal reportCessna T210N · Gypsum, COThe pilot flying into known adverse icing and thunderstorm weather conditions which resulted in the loss of control of the aircraft.NTSB CHI91LA002Accident · No injuriesLimited investigationFinal reportGulfstream American 690B · Willow Springs, MOThe airplanes encounter with a static discharge, turbulence and a downdraft in the clouds which were associated with severe meteorological conditions.NTSB DEN91LA001Accident · No injuriesLimited investigationFinal reportRaven S-60A · Harrison, ARThe student pilot's improper inflight planning and inaccurate evaluation of the surface weather. A factor was the unfavorable wind.NTSB ANC90LA189Accident · 1 fatalLimited investigationFinal reportMaule M-4-210C · 60 E Of Bethel, AKContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance above mountainous terrain. Factors related to the accident were: darkness, adverse terrain and weather conditions, the…NTSB FTW90LA187Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Greers Ferry, ARThe pilot's decision to penetrate adverse weather and the resultant spatial disorientation. Factors were the weather conditions and the pilot's lack of instrument training/experience.NTSB LAX90LA340Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Vacaville, CAThe Balloon's encounter with a sudden increase in wind speed accompained by a strong down draft beyond the compensation capability of the Balloon.NTSB ATL90LA182Accident · Serious injuriesLimited investigationFinal reportHelio HST-550A · Mobile, ALThe pilot's intentional attempted takeoff with a known tailwind component. Factors relating to the accident were the tailwind, trees and utility lines on the departure end of the takeoff area.NTSB NYC90FA225Accident · 4 fatalField investigationFinal reportPiper PA-30 · Berlin, VTThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and…NTSB CHI90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Wayne, INThe failure of the pilot of the accident airplane to maintain sufficient speed for flight. The pilots lack of total experience and the crosswinds that were present during the approach and the attempted go-around are contributing factors to the accident.NTSB ATL90LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Midfield, ALThe pilot's inadequate assessment of deteriorating weather conditions and his resultant flight into areas of low clouds. The safety board believes that the pilot's overall lack of experience was a factor in the accident.NTSB LAX90FA331Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Flagstaff, AZVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude during the approach to land. Factors related to the accident were: darkness, the adverse weather conditions, and failure of…NTSB NYC90FA223Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Livingston, NYThe pilot failed to maintain control of the aircraft while maneuvering for an ILS approach. Factors related to the accident were the pilot's lack of recent instrument flight experience, low cloud ceilings and fog, and failure to follow IFR procedures.NTSB LAX90LA326Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Mount Wilson, CAThe pilot's inadvertent flight into IMC. Contributing factors related to the pilot's failure to request in-flight weather avoidance assistance and his misjudged evaluation of the en route weather.NTSB SEA90LA186Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Kamas, UTPoor inflight planning by the pilot. The airplane encountered a possible downdraft condition while maneuvering in mountainous terrain which resulted in an inflight collision with trees.NTSB SEA90LA187Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Park City, UTThe pilot's lack of understanding of aircraft performance and meteorological conditions when flying at high density altitude in close proximity to mountainous terrain.NTSB NYC90FA220Accident · 2 fatalField investigationFinal reportCessna 152 · Plain City, OHPoor judgement of the pilot due to consumption of alcohol, flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: darkness,…NTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.NTSB LAX90LA325Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Hemet, CAImproper compensation for wind conditions.NTSB DEN90LA181Accident · No injuriesLimited investigationFinal reportCessna T210N · Durango, COThe loss of control of the airplane when the pilot encountered turbulence on short final to land.NTSB ANC90FA164Accident · 5 fatalField investigationFinal reportCessna P206C · Talkeetna, AKThe pilot-in-command's continued VFR flight into instrument meteorological conditions, and failure to maintain adequate altitude for terrain clearance. Factors to the accident were the adverse weather conditions, mountainous terrain, and the dark night.NTSB BFO90FA073Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Richland, VAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) and failure to maintain proper clearance from high terrain. Darkness and the adverse weather conditions were related factors.NTSB SEA90FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Salem, ORThe pilot allowed the design stress limits of the aircraft to be exceeded. Factors related to the accident concerned inadvertent flight by the pilot into known adverse weather conditions.NTSB LAX90LA301Accident · No injuriesLimited investigationFinal reportCessna 180 · Calexico, CAThe aircraft's encounter with unfavorable wind, a dust devil, that rendered the aircraft uncontrollable.NTSB LAX90LA286Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Vacaville, CAFailure of the pilot to maintain adequate altitude resulting in an inflight encounter with an unfavorable wind at a low altitude in a hilly terrain.NTSB ANC90LA143Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Aniak, AKPilot lost control of the airplane as a result of encountering severe weather either during takeoff or landing. Contributing to the accident was the severe weather, rough water surface, and self-induced pressure to fly by the pilot.NTSB FTW90LA156Accident · Serious injuriesLimited investigationFinal reportBoeing B-737-300 · Corpus Christi, TXThe airplane's unexpected encounter with clear air turbulence.NTSB LAX90LA280Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Napa, CAThe flight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the Balloon.NTSB LAX90LA279Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Napa, CAThe flight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the Balloon.NTSB LAX90LA278Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB LAX90LA277Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 SLI · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB SEA90LA155Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Chehalis, WAThe pilot's inadequate compensation for wind conditions. The gusty crosswind ws a related factor.NTSB BFO90LA072Accident · 1 fatalLimited investigationFinal reportCessna A152 · Hyden, KYThe pilot intentionally continuing VFR flight into instrument meteorological conditions which resulted in spatial disorientation and loss of aircraft control. Factors contributing to the accident were the thunderstorms and the pilot's lack of instrument…NTSB LAX90LA264Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Sparks, NVThe inability of the pilot to maintain control of the glider as a result of injuries sustained during an inflight encounter with turbulence. Contributing to the accident was turbulent weather condition encountered.NTSB CHI90LA210Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Clay Banks, WIPilot's failure to maintain an adequate visual lookout during the descent. Contributing factors are the pilot's poor weather evaluation, and continued VFR flight into IFR conditions.NTSB ATL90LA152Accident · No injuriesLimited investigationFinal reportCessna 177 · Windsor, NCThe pilot's failure to maintain control of the airplane during the flare phase of the approach. Contributing to the accident was the gusty wind condition on final caused by thunderstorm activity in the vicinity of the landing area. The pilot did not…