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 MIA89LA236Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Milton, FLFlight in known adverse weather by the pilot. Turbulence from the nearby thunderstorm was a related factor.NTSB ANC89LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Bainbridge, AKContinued flight by the pilot into known adverse weather conditions, and his subsequent selection of unsuitable terrain for landing. Factors related to the accident were: adverse weather conditions and terrain conditions in the precautionary landing area.NTSB BFO89FA069Accident · 3 fatalField investigationFinal reportBeech B50 · Church Creek, MDVFR flight into IMC and pilot disorientation, which resulted in the loss of aircraft control. Contributing to the accident was the pilot's lack of instrument experience, darkness, and the adverse weather condition.NTSB BFO89LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Clendenin, WVInadequate preflight planning/preparation by the pilot which resulted in fuel exhaustion. The weather conditions, the pilot's delay in diverting to an alternate airport, and the light pole were contributing factors.NTSB MIA89LA228Accident · Serious injuriesLimited investigationFinal reportFokker F-28 MK4000 · Vero Beach, FLIn-flight encounter with unforecast turbulence, which resulted in injury of a flight attendant, who was not wearing a safety belt.NTSB MKC89FA179Accident · 3 fatalField investigationFinal reportMooney M20F · Mound City, KSThe pilot's continued VFR flight into an area of thunderstorms & heavy rain which resulted in a loss of control of the airplane. Factors related to the accident were thunderstorms and heavy rain.NTSB BFO89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAImproper planning/decision by the pilot which resulted in his inadvertent flight into instrument meteorological conditions (IMC), and his failure to maintain proper alignment, while landing at night on a road. The weather conditions, dark night, and…NTSB LAX89LA271Accident · No injuriesLimited investigationFinal reportBeech C23 · S Lake Tahoe, CAThe aircraft's encounter with a downdraft during takeoff. Contributing factors were related to the high density altitude condition which existed and the aircraft's deteriorated takeoff performance capability.NTSB LAX89FA268Accident · 1 fatalField investigationFinal reportPiper PA-601P · Ramona, CAThe pilot's VFR flight in instrument meteorologial conditions (IMC) and spatial disorientation, which resulted in an inadvertent descent into the ground. Factors related to the accident were: darkness, low ceiling, and the pilot's lack of a preflight weather…NTSB NYC89LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Hammonton, NJThe pilot overshooting a landing during a precautionary landing due to deteriorating weather conditions. Contributing factor(s) was: the pilot's decision to attempt the flight after being advised that VFR flight was not recommended and inadequate preflight by…NTSB ANC89FA137Accident · 1 fatalField investigationFinal reportCessna 402 · Nome, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his improper in-flight planning/decision. The weather and terrain conditions were considered to be contributing factors.NTSB DEN89LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Louisville, COThe pilot's failure to adequately evaluate the weather prior to takeoff. High winds developed during the Balloon flight which resulted in a rough landing.NTSB CHI89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIThe pilot-in-command failed to properly compensate for unfavorable wind conditions.NTSB MIA89FA214Accident · 1 fatalField investigationFinal reportCessna 210L · Marco, FLContinued VFR flight by the pilot into instrument meteorological conditions (IMC), his misjudgment of altitude and his physical impairment from use of drugs. Contributing factors were: the pilot's probable spatial disorientation, and the night/weather…NTSB NYC89LA189Accident · Minor injuriesLimited investigationFinal reportConvair CV-600-240D · Augusta, METhe failure of the propeller control system for undetermined reasons during a precautionary landing after encountering deteriorating weather conditions during a VFR ferry flight. Contributing factor(s) was: the adverse weather conditions, inadequate…NTSB FTW89LA142Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Littlefield, TXImproper planning/decision by the pilot & the severe turbulence.NTSB SEA89FA143Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Haines, AKImproper in-flight planning and decision by the pilot, which resulted in inadvertent flight into instrument meteorological conditions (IMC). The weather conditions and terrain were related factors.NTSB CHI89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Watertown, WIImproper planning/decision by the pilot and his misjudgement of distance and speed during the landing, which resulted in failure to attain a proper touchdown point. Contributing factors were: the weather conditions, the pilot's continued flight into…NTSB CHI89DEP08Accident · No injuriesFinal reportJames Eggleston Varieze · Cottage Grove, WIThe pilot misjudged altitude and distance to the runway and failed to attain the proper touchdown point for a landing. Factors related to the accident were: adverse weather conditions and uneven terrain short of the runway.NTSB LAX89LA257Accident · Minor injuriesLimited investigationFinal reportCessna 337H · Honolulu, HIAn unexpected and sudden encounter with severe turbulence while the aircraft was cruising over the pacific ocean in cumulus cloud conditions.NTSB NYC89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Stonington, CTThe pilot's inadvertent flight into instrument meteorological conditions (IMC) and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the environmental conditions (dark night & fog) and the pilot's lack of…NTSB ATL89LA184Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Alabaster, ALThe glider pilot's poor evaluation of area weather conditions during the flight, which necessitated an off-airport precautionary landing and led to a collision with rough terrain during the landing rollout. Factors contributing to the accident were the…NTSB ATL89FA190Accident · 4 fatalField investigationFinal reportMooney M20J · Suches, GAThe pilot elected to continue flight to the intended destination disregarding the recommendations of the in flight weather briefer. Contributing factor(s) was: the adverse weather conditions that existed at the time.NTSB DEN89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crested Butte, COFailure of the pilot to maintain sufficient altitude while flying over mountainous terrain. The terrain and weather conditions were related factors.NTSB NYC89FA166Accident · 3 fatalField investigationFinal reportPiper PA-28-236 · Thomasville, PAThe pilot's failure to fly the published approach procedure, which resulted in controlled flight into the terrain.NTSB NYC89FA167Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Hartleton, PAThe pilot allowed the design stress limits of the aircraft to be exceeded after encountering adverse weather conditions. Weather was a related factor.NTSB BFO89FA058Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Libertytown, MDContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), which resulted in the pilot's loss of aircraft control due to disorientation, and overload failure of the wings and stabilator due to the pilot exceeding…NTSB CHI89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Logansport, INPoor judgement of the pilot due to physical impairment from consumption of alcohol, his inadvertent flight into known adverse weather, and his inadequate control of the aircraft during a precautionary landing. Contributing factors were: the weather conditions…NTSB ATL89FA177Accident · Serious injuriesField investigationFinal reportCessna 172 · Townsend, TNImproper in-flight planning/decision by the pilot and his delay in initiating remedial action, when he encountered low ceilings over mountainous terrain, which resulted in his inability to maintain sufficient altitude. Contributing factors were: the pilot's…NTSB DEN89FA162Accident · 2 fatalField investigationFinal reportCessna 150K · Louisville, COInadequate supervision by the instructor pilot (CFI) and flight in known adverse weather conditions. Factors related to the accident were: inadequate preflight planning/preparation by the CFI, his lack of experience in the type of operation, and the weather…NTSB ATL89FA174Accident · 1 fatalField investigationFinal reportPiper PA-30 · Springfield, TNThe pilot's decision to continue flight into an area of known adverse weather which resulted in his ability to maintain control of the airplane. Contributing factor(s) was: the adverse weather conditions.NTSB MKC89FA159Accident · 6 fatalField investigationFinal reportCessna U206 · Pettigrew, ARImproper planning/decision by the pilot, his VFR flight into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related the accident were: the adverse weather conditions, high terrain, the…NTSB DEN89LA150Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Telluride, COInadequate compensation for wind conditions by the pilot and his failure to maintain runway alignment. Contributing factors were wind conditions, high density altitude, and trees.NTSB SEA89LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Snoqualmie Pass, WAImproper in-flight planning/descision by the pilot, which resulted in the aircraft entering a box canyon with insufficient speed and altitude to maneuver out of the confined area. Factors related to the accident were: the pilot's continued flight into known…NTSB LAX89LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Haleiwa, Oahu, HIThe pilot's failure to adequately compensate for wind conditions and the failure to maintain sufficient altitude to clear obstacles. Contributing to the accident were the downdrafts along the ridge line.NTSB FTW89DQG04Accident · No injuriesFinal reportCessna A188B · Vega, TXThe unfavorable wind condition (probable whirlwind or severe wind shear) that was encountered moments after lift-off.NTSB FTW89FA117Accident · 2 fatalField investigationFinal reportCessna 152 · Fort Worth, TXThe inadvertent stall of the airplane by the pilot. Factors contributing to the accident were the pilot's disregard of the weather advisory, the unfavorable windshift, and the thunderstorm outflow.NTSB MKC89LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Bemidji, MNThe continued approach and landing by the pilot in known adverse weather. Contributing factors were the weather conditions and the ditch.NTSB SEA89FA113Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Stanley, IDPilot continued VFR flight into IMC conditions in mountainous terrain. Factors were snow squalls and obscured mountainous terrain in the area.NTSB ATL89FA165Accident · 4 fatalField investigationFinal reportBeech B-60 · Gaston, SCThe pilot exercised questionable judgement in initiating a flight into an area of known thunderstorms. Further, either deliberately or inadvertantly entered a thunderstorm and overstressed the airframe structure resulting in an inflight separation of the…NTSB ATL89FA161Accident · Serious injuriesField investigationFinal reportLockheed L1011-385-1 · Jacks Creek, TNFailure of the passengers to remain seated with their seat belts fastened as the airplane encountered unforecast severe clear air turbulence.NTSB ANC89FA092Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Puntilla Lake, AKThe pilot continued VFR flight into instrument meteorological conditions (IMC) and failed to maintain sufficient altitude to clear the mountainous terrain. The weather and terrain conditions were contributing factors.NTSB BFO89FA043Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Myersville, MDContinued flight by the pilot into instrument meteorological conditions (IMC) and his inability to maintain control of the aircraft after becoming spatially disoriented. Contributing factors were hilly/mountainous terrain, weather conditions, the pilot's lack…NTSB CHI89IA104Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10 · Garden City, KSThe failure of some of the passengers to follow the captain's instructions to fasten their lap belts.NTSB CHI89LA105Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Ansonia, OHFlight into known adverse weather by the student pilot, and his inadvertent descent into the terrain. The adverse weather condition was a related factor.NTSB CHI89FA101Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Bristol, INContinued flight by the pilot into known adverse weather and his exceeding the design stress limits of the aircraft, which resulted in failure of the wing spars and separation of the right wing and empennage (stabilizers). Contributing factors were: continued…NTSB LAX89LA209Accident · No injuriesLimited investigationFinal reportAeronca 50F · Ontario, CAThe pilot's inability to compensate for existing wind conditions, resulting in the inability to maintain a climb.NTSB FTW89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Stratford, TXImproper planning/decision by the pilot, and his inadequate compensation for wind conditions, which resulted in a loss of aircraft control. The wind condition was a related factor.NTSB DEN89LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Angel Fire, NMThe pilot's failure to properly evaluate the existing weather conditions and the subsequent takeoff into adverse conditions which degraded the airplane's climb capability. The pilot performed an intentional gear up landing.NTSB FTW89LA104Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ardmore, OKThe flight instructor failed to recognize that the aircraft was developing a dangerous sink rate during the autorotation and take corrective action by executing a power recovery. Contributing to the accident were the gusty wind conditions.