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 CHI96FA038Accident · 4 fatalField investigationFinal reportPiper PA-28-201T · Belvidere, SDthe pilot's attempted visual flight into instrument meteorological conditions, his failure to maintain control of the airplane, and exceeding the design stress limits of the airplane. Factors in the accident were: the snow and fog, and the aft airplane center…NTSB SEA96FA021Accident · 3 fatalField investigationFinal reportCessna 210D · Yellow Pine, IDimproper planning/decision by the pilot, his resultant VFR flight into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance from mountainous terrain. Factors relating to the accident were: the adverse weather…NTSB ANC96LA014Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Yakutat, AKThe pilot's attempt to fly into known adverse weather, not maintaining a proper forward visual lookout, and not maintaining a proper altitude while maneuvering the airplane for landing.NTSB CHI96FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Fond Du Lac, WIthe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.NTSB MIA96LA019Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Pensacola, FLThe passenger failure to follow the instructions to be seated and utilize a seatbelt. Contributing to the accident was the in flight encounter with turbulence.NTSB FTW96LA035Accident · Serious injuriesLimited investigationFinal reportHelio HT-295 · Llano, TXThe pilot's encounter with a downdraft and his inability to outclimb rising terrain. Factors were the rising terrain and high winds.NTSB ANC96LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions, and failure to maintain sufficient altitude/clearance from mountainous/hilly terrain.NTSB CHI96FA017Accident · 1 fatalField investigationFinal reportCessna 421C · Battle Creek, MIthe pilot's decision to fly in adverse weather (icing) conditions; the accumulation of airframe ice; and the pilot's failure to maintain adequate airspeed for the situation, which resulted in a loss of aircraft control. The icing condition was a related…NTSB ANC96LA006Accident · Minor injuriesLimited investigationFinal reportBeech B24R · Ninilchik, AKThe pilot's improper inflight planning/decision and inadequate compensation for the wind conditions. Turbulence and downdrafts were related factors.NTSB LAX96LA013Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Pacific Ocean (Pacific Ocean)an inadvertent encounter with unreported and unforecasted severe turbulence. A factor in the accident was the passengers' non-use of seat belts during cruise flight.NTSB NYC96LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Honsdale, PAthe pilot's improper evaluation of the weather briefing, and his decision to fly into known forecasted moderate to severe icing conditions. Factors in the accident were the adverse weather conditions encountered during the flight and landing.NTSB NYC96LA011Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102CS · Lake Placid, NYthe pilot's inadequate evaluation of the weather. Contributing factors were the high winds and downdrafts.NTSB NYC96FA004Accident · 1 fatalField investigationFinal reportCessna P206A · Fishkill, NYThe pilot's VFR flight into instrument meteorological conditions. Contributing factors were the fog and dusk light conditions.NTSB FTW96FA004Accident · Serious injuriesField investigationFinal reportAeronca 7AC · Roanoke, TXthe pilot's inadequate weather evaluation and encounter with a sudden windshift and tailwind. The wind gusts and turbulence were factors.NTSB FTW96LA001Accident · No injuriesLimited investigationFinal reportAerostar S60A · Baton Rouge, LAThe pilot's failure to compensate for wind conditions and maintain adequate clearance from the power lines during the approach. A factor was the sudden wind gust.NTSB MIA95LA237Accident · 1 fatalLimited investigationFinal reportAerotek Pitts - S2S · Clarksville, VAcontinued flight by the pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and his inability to control the airplane. The weather condition and the lack of instruments in the airplane were related factors.NTSB FTW95FA402Accident · 5 fatalField investigationFinal reportPiper PA-24B-260 · Westcliffe, COVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the light conditions at dusk, the adverse weather…NTSB BFO95LA098Accident · No injuriesLimited investigationFinal reportCessna 182 · Annapolis, MDThe pilot's failure to maintain control of the airplane during the landing roll. Related factors were the sudden thunderstorm, the high gusty winds, and the sudden windshift to a tailwind during the touchdown/landing roll.NTSB FTW95FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-502A · Coleman, TXthe pilot's continued flight into adverse weather resulting in spatial disorientation and loss of control. A factor was the pilot's improper weather evaluation and the weather.NTSB CHI95FA328Accident · 1 fatalField investigationFinal reportCessna 421B · Coldwater, MIfailure of the pilot to maintain adequate airspeed, while maneuvering (turning) at low altitude, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the adverse weather conditions, and the lack of…NTSB ANC95LA172Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Aniak, AKThe pilot's inadequate weather evaluation. Factors associated with the accident were: the box canyon, rising terrain, wind gusts, and downdrafts.NTSB CHI95LA327Accident · Minor injuriesLimited investigationFinal reportBell 206L · Ware, ILthe pilot's failure to maintain control of the helicopter. A factor in the accident was the pilot's inadvertent VFR flight into IMC conditions.NTSB FTW95LA376Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colorado Spgs, COAn encounter with a wind shift during landing.NTSB LAX95LA311Accident · Serious injuriesLimited investigationFinal reportElan Glaser Dirks DG-300 Elan · Truckee, CAthe pilot misjudged his planned approach by selecting a touchdown point close to the runway's approach end that did not provide sufficient clearance to safely maneuver when forcast turbulence and downdrafts were encountered. The pilot's early extension of…NTSB SEA95LA185Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Thompson, UTthe pilot's continued flight into instrument meteorological conditions, and his failure to maintain altitude and clearance from the mountainous terrain. Factors contributing to the accident were the fog, low ceilings, and downdraft.NTSB CHI95FA285Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ardoch, NDthe pilot-in-command's continuing flight into adverse weather. Factors were the pilot-in-command's failure to obtain a weather observation and the adverse weather.NTSB SEA95LA181Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · St. Mary, MTThe pilot-in-command's failure to maintain proper altitude while maneuvering in high, mountainous, terrain. The terrain and the downdrafts were factors.NTSB SEA95LA173Accident · No injuriesLimited investigationFinal reportCessna TU206F · Ennis, MTThe pilot-in-command's inaccurate weather evaluation and continued flight into adverse weather. The microburst was a factor.NTSB SEA95LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sekiu, WAThe pilot's continued flight into adverse weather necessitating a landing on a highway. The weather was a factor.NTSB NYC95LA182Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Owego, NYThe pilot's inadequate evaluation of weather conditions which resulted in an encounter with a downdraft, inflight loss of control, and a collision with a vehicle.NTSB CHI95LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Detroit, MIthe flight's encounter with turbulence.NTSB NYC95FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Rehoboth, MAThe pilot's inadvertent flight into hazardous weather, which subsequently resulted in exceeding the design stress limits of the airplane and an in-flight breakup. Factors relating to the accident were: embedded thunderstorms, turbulence, and failure of the…NTSB ANC95LA124Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Chickaloon, AKThe pilot's inadvertent encounter with adverse weather conditions and failure to maintain sufficient altitude/clearance from the terrain to compensate for such conditions. Factors related to the accident were: downdrafts, the proximity of mountainous terrain,…NTSB LAX95LA275Accident · 1 fatalLimited investigationFinal reportBeech P35 · Elko, NVthe failure of the pilot to maintain airspeed in a turn during high wind conditions while executing a go-around at a low altitude, which resulted in an inadvertent stall and an uncontrolled descent into the ground.NTSB FTW95LA326Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Red River, NMThe pilot's lack of compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the lack of thermal lift and the tailwind.NTSB CHI95LA235Accident · No injuriesLimited investigationFinal reportCessna 172 · Springfield, MOimproper in-flight planning/decision by the pilot, and his continued flight into adverse weather conditions, which resulted in an uncontrolled altitude deviation and collision with terrain. Factors relating to the accident were: the adverse weather conditions.NTSB ATL95LA144Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Allendale, SCThe pilot's failure to see and avoid the guy wire. Factors in the accident were the weather and the pilot's unfamiliarity with the terrain.NTSB FTW95FA308Accident · 1 fatalField investigationFinal reportBell 206-L3 · Borger, TXThe pilot's loss of control due to an encounter with a dust devil/whirlwind and the turbulence and high wind associated with thunderstorm outflow.NTSB LAX95GA264Accident · 3 fatalFinal reportMcdonnell Douglas 369D · Hauula, HIthe pilot's poor judgement by intentionally flying into adverse weather conditions in mountainous terrain with an external load and no observer which resulted in loss of aircraft control. Factors were pressure from the conditions/events and a lack of total…NTSB SEA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mccall, IDImproper planning/decision by the pilot, which resulted in his failure (or inability) to remain clear of terrain after initiating a go-around. Factors relating to the accident were: the unfavorable terrain and wind conditions (including downdrafts).NTSB MIA95FA175Accident · 2 fatalField investigationFinal reportMooney M20F · Cedar Key, FLContinued flight by the pilot into known adverse weather (vip level three thunderstorm). The thunderstorm was a related factor.NTSB FTW95LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Colorado Spgs, COAn inadvertent windshear encounter. A factor was the high density altitude.NTSB ANC95FA090Accident · 4 fatalField investigationFinal reportPiper PA-32-301 · Kodiak, AKThe pilot's attempt to fly VFR into IMC conditions and his failure to maintain clearance from terrain. Factors include fog and low ceilings.NTSB FTW95LA276Accident · No injuriesLimited investigationFinal reportCessna 150F · Garfield, COThe pilot's delayed decision to deviate away from the deteriorating weather. Factors were his inadequate evaluation of the weather, high density altitude, and the resultant inadvertent operation of the airplane beyond the climb performance limitations of the…NTSB FTW95FA261Accident · 2 fatalField investigationFinal reportCessna 182Q · San Angelo, TXThe pilot's decision to attempt flight into known adverse weather conditions, and his loss of aircraft control due to spatial disorientation. Factors relating to the accident were: conditions of darkness, thunderstorm and lightning, and the pilot's lack…NTSB CHI95IA204Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Green Bay, WIthe weather condition (turbulence in clouds). A factor was the flight crew's abrupt control of the airplane.NTSB MIA95LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Rosewood, FLThe failure of the pilot-in-command to maintain speed and distance on final approach resulting in an overrun and collision with trees. A contributing factor was the failure of the pilot to obtain an adequate weather briefing prior to flight.NTSB MIA95IA157Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-B4-103 · Atlantic Ocean (Atlantic Ocean)Failure of the passengers and flight attendants to comply with the flightcrew's instruction to fasten their seatbelts.NTSB ANC95LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Anaktuvuk, AKThe pilot's inadvertent flight into instrument meteorological conditions. Factors relating to the accident were: the pilot's inadequate weather evaluation, and the weather and terrain conditions.NTSB BFO95FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Frederick, MDthe pilot's continued flight into known adverse weather during descent, which resulted in in-flight collision with terrain. Related factors were the pilot's disregard of a hazardous weather advisory, and the low ceilings, fog and drizzle.