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 DEN90LA168Accident · Serious injuriesLimited investigationFinal reportGulfstream G-II · Cheyenne, WYAn unforeseen encounter with clear air turbulence.NTSB NYC90LA057Accident · Serious injuriesLimited investigationFinal reportCameron AX-8 · Schodack, NYThe inflight encounter with unforecast high winds.NTSB LAX90FA260Accident · 1 fatalField investigationFinal reportBeech B36TC · Santee, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions, and his loss of control due to spatial disorientation. Factors contributing to the accident were: the pilot's failure to obtain a weather briefing, the existing weather…NTSB CHI90LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe instructor's inability to control the airplane during its landing roll.NTSB MIA90LA155Accident · Serious injuriesLimited investigationFinal reportBoeing 727-223 · Fort Myers, FLUnforecasted encounter with weather. The airplane encountered severe turblence during enroute descent, resulting in one flight attendant sustaining serious injury, and one passenger sustaining minor injury.NTSB MIA90LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeland, FLThe improper use of the carburetor heat control resulting in the loss of engine power due to carburetor ice.NTSB NYC90LA159Accident · No injuriesLimited investigationFinal reportCessna 310R · Hyannis, MAA hard landing due to the pilot stalling the airplane during the landing flare. Contributing to this accident was gusty wind conditions.NTSB MIA90LA152Accident · Serious injuriesLimited investigationFinal reportBoeing 747-136 · Miami, FLThe inadvertent encounter with severe turbulence while operating in an area of thunderstorm activity.NTSB ANC90FA116Accident · Minor injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to maintain flying speed during climbout which resulted in a stall.NTSB LAX90LA253Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Springerville, AZThe encounter with a downdraft beyond the climb capability of the aircraft.NTSB BFO90FA063Accident · 1 fatalField investigationFinal reportBeech P35 · Disputanta, VAThe pilot's indequate inflight decision which resulted in flight into adverse weather condition. Contributing to the accident was thunderstorms and the pilot exceeding the design limits of the airplane.NTSB DEN90LA151Accident · No injuriesLimited investigationFinal reportCessna 172XP · Tooele, UTThe flights encounter with turblence on final which resulted in a loss of control and a subsequent collision with the ground.NTSB CHI90IA166Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILThe pilot-in-command's inadequate weather evaluation. Factors in the incident were the weather and artcc's failure to issue a weather advisory.NTSB SEA90LA111Accident · Minor injuriesLimited investigationFinal reportCallair A-3 · Burley, IDAn encounter with meteorological conditions that exceeded the aircraft's ability to climb or maintain level flight. The high density altitude and lack of suitable terrain were factors related to the accident.NTSB ANC90LA095Accident · No injuriesLimited investigationFinal reportBell B-47G2A · Dutch Harbor, AKThe pilot in commands continued VFR flight into IMC conditions and his failure to maintain altitude while manuevering to avoid terrain.NTSB CHI90LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Brookville, OHThe pilot's failure to maintain positive control of the aircraft while encountering gusty, shifty winds and windshear during the initial climbout after takeoff.NTSB NYC90LA131Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Augusta, MEPoor judgement of the pilot, his decision to attempt VFR flight in instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the pilot's lack of proper certification…NTSB NYC90FA129Accident · 2 fatalField investigationFinal reportCessna 337G · Harrison, NYThe pilot's decision to continue VFR flight into IMC and his subsequent loss of control of the airplane. The weather conditions and the pilot's lack of instrument flight experience were factors in the accident.NTSB SEA90FA171Accident · 3 fatalField investigationFinal reportLake LA-4 · Onalaska, WAImproper in-flight planning/decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather and terrain conditions.NTSB MKC90LA122Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salina, KSInadvertent flight from VFR into IMC by the pilot in command.NTSB ANC90LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Circle Hot Spgs, AKThe pilot's continued flight into adverse weather conditions. The weather, and surrounding terrain, were factors.NTSB LAX90LA214Accident · No injuriesLimited investigationFinal reportBeech 77 · Taft, CAThe pilot's improper remedial action. Related to this accident was the pilot's inadvertent encounter with unfavorable winds.NTSB ATL90LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Greenwood, SCThe pilot's failure to maintain flying speed during the flare phase of the approach/landing. Contributing to the accident was a sudden increase in winds.NTSB FTW90DRD10Accident · No injuriesFinal reportGrumman G-164B · Mamou, LAPilot misjudged wind information. Factors contributing to the accident were the tailwind, the trees and the levee.NTSB BFO90FA054Accident · 2 fatalField investigationFinal reportCessna 172RG · Onego, WVVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate clearance (altitude) from mountainous terrain. The terrain and adverse weather conditions were related factors.NTSB DEN90FA119Accident · 1 fatalField investigationFinal reportCessna 152 · Longmont, COThe pilot continued into hazardous weather conditions.NTSB ANC90LA082Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Broad Pass, AKThe pilot's continued flight into known adverse weather, and his delay in reversing course (improper in-flight planning/decision). Factors related to the accident were: terrain and weather conditions.NTSB NYC90FA117Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Rome, PAAn inflight loss of control due to spatial disorientation. Contributing to the accident was the pilot's lack of an instrument rating, and his decision to make the flight after receiving three separate briefings where he was told 'VFR flight not recommended.'NTSB LAX90LA200Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Cucamonga, CAThe pilot's continuing VFR flight into instrument meteorological conditions resulting in collision with terrain.NTSB LAX90LA190Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Waialua, HIThe failure of the pilot to maintain an adequate clearance from clouds.NTSB DEN90LA114Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Erie, COCfi's failure to ensure that the student pilot maintained sufficient airspeed, resulting in the inadvertent stall/mush. A factor was the downdraft experienced at low altitude after takeoff.NTSB ATL90FA118Accident · 1 fatalField investigationFinal reportCessna 182RG · Highland, NCThe pilot's attempted VFR flight in IMC. Factors in the accident are the pilot's inaccurate weather evaluation and poor in flight decision.NTSB LAX90FA181Accident · 2 fatalField investigationFinal reportLuscombe 8A · Strawberry, CAThe pilot's decision to continue VFR flight in a confined mountain pass area which was in instrument meteorological conditions; and the pilot's inflight loss of control while attempting a course reversal in the narrow confined canyon.NTSB LAX90FA180Accident · 2 fatalField investigationFinal reportCessna 172N · Salinas, CAThe pilot's failure to maintain clearance with terrain while attempting visual flight in instrument meteorological conditions. Self induced pressure to adhere to the proposed flight route in instrument meteorological conditions was a factor.NTSB MKC90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Dubuque, IAWeather evaluation misjudged resulting in uncontrolled descent by the pilot in command and aircraft control not maintained by the pilot in command.NTSB NYC90FA107Accident · 1 fatalField investigationFinal reportCessna 182D · Numidia, PAInflight collision with trees while attempting to maintain visual reference with the ground in instrument meteorological flight conditions. Contributing to the accident was the pilot's decision to continue the flight in deteriorating weather conditions in an…NTSB LAX90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 172 · California City, CAThe pilot's improper landing flare. A factor related to accident was the gusty wind condition.NTSB BFO90LA043Accident · Serious injuriesLimited investigationFinal reportBoeing B-737 · Washington, DCThe aircraft encountered turbulence, resulting in injury to a flight attendant.NTSB BFO90FA045Accident · 6 fatalField investigationFinal reportCessna 210N · Shady Grove Cor, VAVFR flight by the non-instument rated pilot into instrument meteorological conditions (IMC), his loss of aircraft control, due to spatial disorientation, and his exceeding the design stress limits of the aircraft, while recovering from an uncontrolled…NTSB SEA90FA072Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Jean, NVSevere downdrafts/windshear which exceeded the airplane's performance capabilities.NTSB LAX90LA206Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 · Napa, CAThe pilot's improper flare technique which resulted in a hard landing. A factor in the accident was the sudden appearance of a high wind condition.NTSB NYC90FA099Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Fredericksburg, PAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure (or inability) to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: adverse weather conditions, and…NTSB LAX90LA157Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Mammoth Lakes, CAPilot's encounter with a strong downdraft while cruising at an inadequate altitude. A contributing factor was the high altitude which limited available engine power for recovery.NTSB NYC90LA093Accident · No injuriesLimited investigationFinal reportCessna C-150 · Turbotville, PAThe pilot to maintain sufficent flying speed for takeoff when strong winds were encountered.NTSB DEN90FA103Accident · 6 fatalField investigationFinal reportPiper PA-32C-300 · Leadville, COVFR flight into instrument meteorological conditions (IMC) by the pilot, and his failure to maintain sufficient altitude and clearance from mountainous terrain. Factors related to the accident were: the terrain and weather conditions, the pilot's…NTSB NYC90LA092Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Unionville, PAThe loss of thermal lift which necessitated a forced landing on unsuitable terrain covered by trees and high obstructions.NTSB FTW90FA100Accident · No injuriesField investigationFinal reportLearjet 25D · Uvalde, TXFailure of the pilot to obtain a pre-flight weather briefing, and his improper in-flight planning/decision, which resulted in an in-flight encounter with severe weather and subsequent engine flameouts. Factors related to the accident were: darkness, the…NTSB ATL90LA104Accident · No injuriesLimited investigationFinal reportBalloon Works 7B · Lexington, KYThe overload failure of several jumper cords. Factor(s) were inadvertent encounter with unfavorable wind (dust devil). Subsequently, the pilot was unable to control the rate of descent.NTSB MKC90FA091Accident · 2 fatalField investigationFinal reportPiper PA32RT-300 · Mansfield, ARThe non-instrument rated pilot's decision to continue VFR flight into IMC. Contributing to the accident were the low ceilings, rain, and turbulence encountered at low altitude, and the pilot's lack of instrument training/experience.NTSB FTW90LA095Accident · No injuriesLimited investigationFinal reportHughes 369HS · Junction, TXThe pilot in command's inadequate execution of the autorotation following a engine failure which resulted from his failure to refuel the aircraft with the proper grade of fuel when he ran short during the flight.