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 LAX93LA022Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX7-77 · Sierra Vista, AZThe flight's encounter with unforecast unfavorable winds.NTSB BFO93LA002Accident · No injuriesLimited investigationFinal reportBeech B24R · Waynesburg, PAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from the terrain/obstructions. Factors related to the accident were the pilot's lack of a preflight weather briefing, and the…NTSB SEA93LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Lind, WAThe aircraft encountered rough terrain during the landing roll after the pilot elected to perform a precautionary landing in an open field, due to deteriorating weather.NTSB NYC93FA028Accident · 2 fatalField investigationFinal reportBeech A36 · Middlebourne, WVThe pilot's decision to intentionally fly into known icing conditions which resulted in an inadvertent stall and uncontrolled descent into trees. A factor related to the accident was the icing conditions.NTSB ANC93FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Talkeetna, AKThe pilot's continued visual flight into instrument meteorological conditions at night which resulted in a loss of airplane control, spatial disorientation, and an inflight breakup. Factors which contributed to the accident were: the adverse weather and the…NTSB LAX93LA008Accident · No injuriesLimited investigationFinal reportCessna R172K · Picacho, AZThe pilot's encounter with the unforecasted cyclonic wind.NTSB ANC93LA006Accident · No injuriesLimited investigationFinal reportCessna 150F · Denali, AKThe inadequate preflight planning and preparation by the student pilot, the student pilot's continued flight into known adverse weather and the pilot's failure to maintain directional control on the roadway landing. Factors relating to the accident were: the…NTSB MIA93LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St Augustine, FLFailure of the instructor pilot (CFI) to assure adequate compensation for wind conditions. Factors related to the accident were: the crosswind and turbulent weather conditions.NTSB ANC92LA181Accident · No injuriesLimited investigationFinal reportCessna 185 · Petersburg, AKThe pilots inadequate compensation for wind during initial climb. A factor relating to accident was the gusty wind condition.NTSB MIA92LA191Accident · Serious injuriesLimited investigationFinal reportLet L-13 · New Smyrna Bch, FLThe pilot's inadequate compensation for wind conditions. The downdraft was a factor in the accident.NTSB ATL92FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Samantha, ALThe pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…NTSB CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.NTSB CHI92FA280Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pullman, MIThe pilot in command's exceeding the design stress limits of the aircraft.NTSB MIA92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · New Hope, FLPoor in-flight planning and decision and failure of the pilot to maintain aircraft control.NTSB BFO92FA133Accident · 2 fatalField investigationFinal reportCessna 182R · Westerly, RIInadvertent VFR 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: the adverse weather conditions, self-induced pressure…NTSB BFO92LA126Accident · 1 fatalLimited investigationFinal reportCessna 172E · Tuckahoe, NJVFR 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: the light conditions at dusk (or darkness), and the pilot's lack…NTSB ATL92LA172Accident · No injuriesLimited investigationFinal reportAyres S-2R · Douglas, GAThe pilot's failure to check weather prior to the flight. A factor was the dark night.NTSB LAX92LA373Accident · No injuriesLimited investigationFinal reportCessna 170A · Holtville, CAThe pilot's encounter with the unforecasted dust devil.NTSB ANC92FA141Accident · 4 fatalField investigationFinal reportCessna 185 · Whittier, AKPilot in command's intentional flight into known adverse weather conditions. Factors relating to the accident were: the pilot's disregard for adverse weather advisory, weather conditions (clouds) and mountainous terrain.NTSB DEN92FA085Accident · 3 fatalField investigationFinal reportPiper PA-32-301T · Kit Carson, COThe pilot becoming spatially disoriented and exceeding the design stress limits of the aircraft. Factors were: the pilot's failure to obtain a weather briefing, his attempted VFR flight into a level six thunderstorm, and his lack of instrument time.NTSB ATL92LA159Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Guntersville, ALThe pilot's inadequate evaluation of the in flight weather conditions, and his subsequent loss of aircraft control, which resulted in the design stress limits of the aircraft being exceeded. Factors were clouds, the associated turbulence, and the hail in the…NTSB NYC92FA153Accident · 2 fatalField investigationFinal reportDanny M Damron Long EZ · Front Royal, VAThe pilot's self induced pressure to complete the flight which resulted in intentional flight into IMC conditions, and a collision with trees. Factors related to the accident were the pilot's over confidence in his abilities, and the low clouds and fog which…NTSB LAX92LA337Accident · 2 fatalLimited investigationFinal reportCessna 310M · Honolulu, HILoss of aircraft control for an undetermined reason after the pilot took off at night and flew the aircraft into the area of a thunderstorm and lightning.NTSB DEN92FA083Accident · 1 fatalField investigationFinal reportBeech A36 · Camden, ARAn inflight breakup of the aircraft when the pilot flew into a level three thunderstorm.NTSB FTW92LA200Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Springfield, MOThe encounter with severe turbulence while deviating around convective activity.NTSB CHI92FA228Accident · 3 fatalField investigationFinal reportCessna 172H · Grayling, MIThe pilot's failure to maintain aircraft control.NTSB MIA92LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-26E · Ridgeland, SCThe pilot's inadequate inflight planning resulting in an encounter with a windshift on final approach.NTSB DEN92FA076Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Manville, WYA loss of control following flight into weather conditions containing thunderstorms, turbulence and icing conditions. Factors were: inaccurate weather evaluation and flight into known adverse weather by the pilot in command.NTSB FTW92FA180Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Tool, TXThe pilot exceeded the design stress limits of the airframe as a result of flight into known adverse weather conditions.NTSB ATL92FA139Accident · 2 fatalField investigationFinal reportBeech 58P · Greenville, GAContinued flight by the pilot into an area of known adverse weather, and his failure to maintain control of the aircraft, which resulted in exceeding the design stress limits of the plane and overload failure of the stabilizers and wings. The adverse weather…NTSB LAX92FA294Accident · 1 fatalField investigationFinal reportBell 206B · Twin Peaks, CAWas the pilot's decision to initiate the flight in known adverse weather and continued VFR flight into instrument meteorological conditions. Contributing to this accident was the low clouds and fog.NTSB LAX92LA290Accident · Serious injuriesLimited investigationFinal reportWhigham GW-4 · Warner Springs, CAThe pilot's inadequate preflight planning and preparation. Contributing to this accident was the downdrafts and mountainous terrain.NTSB SEA92FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Pierce, IDInflight loss of control when aircraft control was not maintained. Factors to the accident were: flight into known adverse weather and thunderstorm activity.NTSB SEA92LA144Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wenatchee, WAThe failure of the pilot to maintain directional control during landing, resulting in a ground loop and aircraft impact with terrain. A factor relating to the accident was the gusty wind conditions.NTSB CHI92LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Belmont, WIThe pilot's poor planning/decision making. Related factors are the low ceilings and fog, the dark night, the pilot's inaccurate weather evaluation and diverted attention, and the pilot's failure to maintain clearance from the higher terrain encountered.NTSB DEN92LA069Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pecos, NMAn encounter with high winds.NTSB CHI92LA206Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Janesville, WIThe captain's delay in issuing instructions to the flight attendants to take their seats, and his poor crew coordination. A factor in the accident was the turbulence in clouds.NTSB SEA92FA140Accident · 1 fatalField investigationFinal reportBeech A36TC · Ballantine, MTThe pilot-in-command's physical impairment and his continued VFR flight into instrument meteorological conditions. Factors relating to the accident were: the weather conditions and the hilly terrain.NTSB DEN92IA067Incident · No injuriesIncident investigationFinal reportBell 222UT · Scipio, UTAn encounter with clear air turbulence.NTSB FTW92LA167Accident · No injuriesLimited investigationFinal reportGlasflugel 201B · Briggs, TXThe inadvertent ground loop by the pilot. Factors were the downdraft and the rough/uneven terrain.NTSB SEA92LA126Accident · No injuriesLimited investigationFinal reportBeech K35 · Sula, MTPoor inflight planning/decision. Factors to the accident were: delayed remedial action, a white out weather condition and inadequate clearance.NTSB LAX92FA242Accident · 3 fatalField investigationFinal reportCessna 172I · Chino Hills, CAThe pilot's poor weather evaluation and inflight decision to continue flight into instrument meteorological conditions in mountainous terrain.NTSB NYC92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Danville, NYThe decision by the pilot to land during a heavy rain shower, which resulted in a long landing, and his attempted takeoff with insufficient available runway and subsequent loss of airplane control.NTSB NYC92LA100Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Malvern, PAThe pilot abruptly moved the cyclic rearward which resulted in the main rotor blades striking and separating the tail boom. A factor in this accident was the soft muddy field.NTSB FTW94LA288Accident · 1 fatalLimited investigationFinal reportBeech 35-C33 · Lake City, COFlight by the pilot into adverse weather conditions, and his subsequent loss of aircraft control due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument experience.NTSB SEA92LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Monarch, MTThe pilot in command's disregard of the weather forecast and failure to maintain clearance with trees/terrain. Factors contributing to the accident were: hilly/mountainous terrain, weather conditions: rain, low ceilings and downdrafts, trees and the pilot in…NTSB ATL92FA109Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Winnsboro, SCThe inadvertent flight into instrument meteorological conditions by the pilot. The dark night and fog were factors in the accident.NTSB ANC92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Funter Bay, AKThe pilot's attempted flight into known adverse weather.NTSB BFO92FA064Accident · 2 fatalField investigationFinal reportBeech 65 · Madison, VAThe pilot initiated VFR flight into known adverse weather conditions. Contributing to the accident was low ceiling, high terrain, and low altitude.NTSB FTW92LA142Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Palacios, TXThe flight's unexpected encounter with moderate turbulence.