NTSB investigations
100 cases where NTSB found Thunderstorm.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03033010')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03033010')) 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 ERA15LA249Accident · No injuriesLimited investigationFinal reportBeech B 55 · Clearwater, FLThe pilot's delayed completion of the before landing checklist, including the extension of the landing gear, during an approaching thunderstorm, which resulted in a landing with the landing gear in transit and the subsequent collapse of the landing gear.NTSB CEN15FA268Accident · 1 fatalField investigationFinal reportPiper PA 32 · Cuba, MOThe pilot's continued flight into thunderstorm activity, which resulted in his loss of airplane control, the exceedance of the airplane's design limits, and its subsequent in-flight breakup. Contributing to the accident was the pilot's reliance on onboard…NTSB DCA15CA131Accident · Serious injuriesData collectionFinal reportBombardier CL600 2D24 · McCook, NEinadvertent encounter with turbulence while deviating around an area of known convective activity.NTSB CEN15FA245Accident · 3 fatalField investigationFinal reportBeech A36 · Plainview, TXThe pilot’s decision to take off ahead of an approaching severe thunderstorm, which resulted in an encounter with hazardous weather conditions that led to a loss of airplane control.NTSB CEN15LA241Accident · No injuriesLimited investigationFinal reportGarratt Mansfield W IV-P · Hamilton, TXThe pilot’s decision to continue flight into known severe thunderstorm conditions, which resulted in the loss of engine power during the descent due to the engine’s ingestion of water and ice and a subsequent forced landing.NTSB ERA15FA215Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Saltville, VAThe pilot’s flight into developing rain showers and updrafts, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident were the pilot’s continued flight into forecast adverse weather conditions, and his reliance on…NTSB ERA15CA116Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Deland, FLThe pilot's inadequate preflight weather planning and decision to land in an area with known convective wind gusts, which resulted in a loss of control and subsequent hard landing.NTSB ERA14CA334Accident · No injuriesData collectionFinal reportCessna 172N · Edgewater, MDThe pilot's inadvertent encounter with an unanticipated convective gust front or low-level wind shear while landing, which resulted in a loss of control and subsequent hard landing.NTSB CEN14FA300Accident · 3 fatalField investigationFinal reportPiper PA 46-310P · Lehman, TXThe pilot's improper decision to enter an area of known adverse weather, which resulted in the loss of airplane control. Contributing to the accident was the air traffic controller's failure to provide critical weather information to the pilot to help him…NTSB CEN14LA065Accident · No injuriesLimited investigationFinal reportAero Commander 500 - B · Lubbock, TXThe pilot's failure to complete a landing checklist and extend the landing gear, which resulted in a gear-up landing. Contributing to the accident was the pilot's diverted attention to the weather during approach.NTSB ERA13FA402Accident · 2 fatalField investigationFinal reportCessna T-50 · Lenox Twp., PAThe pilot's intentional visual flight into night instrument meteorological conditions and thunderstorms and his improper decision to takeoff without getting updated weather information after a briefer cautioned him during a previous flight that visual flight…NTSB CEN13CA410Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Elbert, COThe pilot's failure to maintain aircraft control while landing in gusting crosswind conditions. Contributing to the accident was the pilot's delayed return to the airport.NTSB ERA13CA181Accident · No injuriesData collectionFinal reportCessna 172 · Tistusville, FLThe pilot's loss of airplane control while taxiing in gusting wind conditions associated with nearby thunderstorm activity.NTSB CEN13FA131Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Paris, TXThe pilot's encounter with convective weather, which resulted in a loss of airplane control.NTSB CEN13FA073Accident · 1 fatalField investigationFinal reportCessna 421C · Wells, TXThe pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.NTSB ERA12CA547Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a takeoff in gusty crosswind conditions. Contributing to the accident was the pilot's decision to take off in gusty wind conditions associated with approaching…NTSB WPR12FA378Accident · 2 fatalField investigationFinal reportAircraft Mfg & Development CH 2000 · Nephi, UTThe pilot's inability to maintain airplane control due to an encounter with a microburst/downdraft that exceeded the climb performance capabilities of the airplane.NTSB ERA12CA521Accident · Minor injuriesData collectionFinal reportCessna 152 · Deland, FLThe pilot’s failure to maintain airplane control on final approach in gusting wind conditions. Contributing to the accident was the pilot’s decision to operate in an environment of thunderstorms and rapidly deteriorating weather.NTSB ERA12LA500Accident · No injuriesLimited investigationFinal reportBeech V35B · Effingham, SCThe pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…NTSB ERA12FA433Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · New Site, MSThe pilot's decision to operate into a known area of adverse weather, which resulted in the inadvertent penetration of a severe thunderstorm, a subsequent loss of control, and in-flight breakup of the airplane.NTSB CEN12FA421Accident · 1 fatalField investigationFinal reportBeech E90 · Karnack, TXThe pilot's inadvertent flight into thunderstorm activity, which resulted in the loss of airplane control and the subsequent exceedance of the airplane's design limits and in-flight breakup. Contributing to the accident was the failure of air traffic control…NTSB ERA12FA376Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Macon, MSThe pilot's decision to continue flight into an area of known thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the pilot's lack of experience in actual instrument meteorological conditions and his reliance on datalink…NTSB CEN12LA258Accident · Minor injuriesLimited investigationFinal reportBell 206B · Amarillo, TXThe pilot's failure to maintain helicopter control during landing in gusty wind conditions associated with a thunderstorm, which resulted in a loss of tail rotor effectiveness.NTSB OPS12IA303Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Farmersville, TXThe flight's continued operation through an area containing substantial convective weather activity. Contributing to the accident was the air traffic control/traffic management unit's lack of awareness and recognition of the effect of weather movement on the…NTSB CEN12FA108Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Bryan, TXThe pilot’s inadvertent encounter with severe weather, which resulted in the airplane’s left wing failing in positive overload. Contributing to the accident was the pilot’s reliance on outdated weather information that he received on his in-cockpit…NTSB ERA11FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-140The non-instrumented rated pilot’s flight into instrument meteorological conditions for undetermined reasons, resulting in an in-flight loss of control, uncontrolled descent, and collision with the water.NTSB CEN11FA500Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Rantoul, ILThe pilot did not maintain airplane control during takeoff with approaching thunderstorms. Contributing to the accident was the pilot's decision to depart into adverse weather conditions.NTSB ERA11FA376Accident · 5 fatalField investigationFinal reportCessna A185F · Yabucoa, PRThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with a thunderstorm and subsequent loss of control.NTSB ERA11LA344Accident · No injuriesLimited investigationFinal reportBeech A100 · Gray, TNAn encounter with convectively-induced turbulence and icing, which resulted in an in-flight upset and a loss of airplane control.NTSB ERA11LA330Accident · No injuriesLimited investigationFinal reportBeech C90 · Camden, SCThe pilot's in-flight decision to continue toward his destination, through known significant weather, when safer alternatives were available.NTSB ERA11FA036Accident · 2 fatalField investigationFinal reportBeech B36TC · Rienzi, MSThe pilot's continued flight into known adverse weather conditions. Contributing to the accident was the air traffic controller's failure to provide precipitation information to the pilot as required.NTSB ERA10LA511Accident · 2 fatalLimited investigationFinal reportBallonbau Worner NL-1000/STU · Adriatic Sea, A1The crew's intentional flight into known adverse weather conditions, which resulted in destruction of the balloon envelope by lightning strike and the subsequent uncontrolled descent to the sea.NTSB WPR10LA259Accident · 1 fatalLimited investigationFinal reportSocata TB-20 · Happy Camp, CAThe pilot’s inadequate preflight planning and decision to continue to operate under visual flight rules into instrument meteorological conditions, which resulted in an encounter with an embedded thunderstorm and rain showers and moderate to severe turbulence,…NTSB CEN10LA240Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Fort Dodge, IAThe flight crew's inadequate separation from convective activity that resulted in serious injury to an unrestrained flight attendant.NTSB ERA10MA188Accident · 3 fatalMajor investigationFinal reportEurocopter AS-350-B3 · Brownsville, TNThe pilot's decision to attempt the flight into approaching adverse weather, resulting in an encounter with a thunderstorm with localized instrument meteorological conditions, heavy rain, and severe turbulence that led to a loss of control.NTSB CEN10FA028Accident · 4 fatalField investigationFinal reportBeech B100 · Benavides, TXThe pilot's failure to avoid severe weather, and the air traffic controller's failure to provide adverse weather avoidance assistance, as required by Federal Aviation Administration directives, both of which led to the airplane's encounter with a severe…NTSB ERA09FA487Accident · 2 fatalField investigationFinal reportSocata TB20 · Pavo, GAThe pilot’s continued visual flight into instrument meteorological conditions, with embedded intense thunderstorms, heavy rain, and severe to extreme turbulence, resulting in an in-flight separation of the left wing due to overstress.NTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.NTSB ERA09LA392Accident · 1 fatalLimited investigationFinal reportNoles Vance L Vans RV7A · Sanderson, FLThe pilot's continued visual flight into instrument meteorological conditions with convective activity and thunderstorms. Contributing to the accident was his failure to get an adequate weather briefing.NTSB ERA09FA389Accident · 5 fatalField investigationFinal reportCessna 421C · Gulf of MexicoThe pilot’s decision to operate into a known area of adverse weather, which resulted in the inadvertent penetration of a severe thunderstorm, a subsequent loss of control, and in-flight breakup of the airplane.NTSB ERA09LA400Accident · Serious injuriesLimited investigationFinal reportApollo Monsoon · Kanona, NYThe pilot's loss of control while landing in convective weather conditions. Contributing to the accident was his misjudgment of the approaching weather.NTSB CEN09FA369Accident · 2 fatalField investigationFinal reportCessna R182 · Dougherty, TXThe pilot’s improper decision to continue flight into known adverse weather conditions resulting in his inability to maintain aircraft control after penetrating the thunderstorm gust front. Contributing to the accident was the pilot’s lack of preflight…NTSB CEN09CA361Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Trumann, ARThe pilot's failure to maintain aircraft control in flight. Contributing to the accident was his decision to fly with known hazardous weather conditions in the vicinity.NTSB CEN09CA269Accident · No injuriesData collectionFinal reportLet L-23 Super Blanik · Adrian, MIThe flight instructor's inadequate compensation for the strong, gusting crosswind during landing. Contributing to the accident was the flight instructor's decision to attempt flight with known adverse weather approaching the airport.NTSB ERA09FA074Accident · 2 fatalField investigationFinal reportBeech 35-B33 · Homosassa Spgs., FLThe pilot’s continued flight into known adverse weather conditions.NTSB CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.NTSB NYC08FA260Accident · 2 fatalField investigationFinal reportPiper PA-23 · Highlands, NCThe pilot's improper decision to fly into an area of thunderstorms, which resulted in an in-flight breakup. Contributing to the accident was the air traffic controller's failure to comply with FAA directives regarding issuance of precipitation location and…NTSB CHI08LA158Accident · 1 fatalLimited investigationFinal reportMaggs Lancair 4P · Alhambra, ILThe pilot's decision to continue the flight into an area of known thunderstorm activity and the in-flight structural failure of the airplane.NTSB LAX08CA148Accident · No injuriesData collectionFinal reportCessna 150H · Augusta, GAThe pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.NTSB DEN08LA074Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5A · Beaumont, TXThe pilot's inability to maintain aircraft control in cruise flight and encounter with a thunderstorm. Contributing to the accident was an inadvertent stall/spin.