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 ATL00LA094Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Homosassa, FLThe pilot's inadvertent flight into instrument meteorological conditions and subsequently exhausting his fuel supply. Factors were his failure to obtain a weather briefing, the weather conditions which included clouds and obscuration, the residence and the…NTSB MIA00LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLan in-flight encounter with turbulence.NTSB MIA00LA267Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GAan in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.NTSB ATL00LA092Accident · Serious injuriesLimited investigationFinal reportBombardier CRJ · Atlanta, GAThe inadvertent flight into turbulent weather conditions.NTSB ANC00LA135Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Sparrevohn, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable winds, and a crosswind.NTSB SEA00LA154Accident · No injuriesLimited investigationFinal reportCessna 120 · Arco, IDThe pilot's inadequate compensation for the wind condition. Wind gust was a factor.NTSB MIA00GA264Accident · 2 fatalFinal reportBell UH-1H · Waynesville, NCAn in-flight encounter with ground level fog due to the pilot's decision to continue VMC flight into instrument conditions, resulting in an in-flight collision with trees.NTSB DEN00LA165Accident · Serious injuriesLimited investigationFinal reportGulfstream G-IV · Sheridan, WYthe pilot's inadvertent flight into unforecasted turbulent weather conditions. A contributing factor was the turbulence.NTSB NYC00LA251Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Wurtsboro, NYThe pilot's improper weather evaluation and decision to initiate a flight with an approaching rain shower. A factor in this accident was heavy rain, which reduced visibility.NTSB IAD00LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Halfmoon, NYThe pilot's inadequate preflight planning, and his continued flight into, and attempted landing during a thunderstorm. A factor was the thunderstorm.NTSB ANC00TA109Accident · Serious injuriesFinal reportPiper PA-18 · Port Heiden, AKThe pilot's inadequate weather evaluation and in-flight planning/decisions. Factors in the accident were turbulence, and a downdraft.NTSB LAX00FA324Accident · 2 fatalField investigationFinal reportBellanca 17-30 · Scottsdale, AZthe pilot's failure to maintain adequate terrain clearance during a cruise descent, which resulted in controlled flight into mountainous terrain during dark night conditions. Contributing factors were the rain, thuderstorm, and dust storm weather conditions,…NTSB FTW00LA244Accident · Serious injuriesLimited investigationFinal reportBoeing 757-223 · Gulf Of Mexicothe flight crew's inadvertent encounter with convective turbulence while in cruise flight. A factor was the rapidly developing convective activity.NTSB ANC00LA111Accident · No injuriesLimited investigationFinal reportCessna 172 · Alexander Creek, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were gusty winds, and a downdraft.NTSB ATL00FA081Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Lumber City, GAPilot's failure to follow instrument procedures and descended below approach minimums and collided with trees. A factor was low clouds.NTSB ANC00LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent stall. A factor in the accident was the gusty winds.NTSB LAX00LA292Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly II · Phoenix, AZThe pilot's failure to use pibals or other on site wind determination devices, and his subsequent failure to detect adverse wind conditions prior to launch of the balloon.NTSB FTW00LA225Accident · Minor injuriesLimited investigationFinal reportBrown/Morrison Rans S-12 · Bonham, TXThe pilot's failure to maintain control of the airplane while maneuvering to return to the airport. Factors were the gusty wind conditions and the pilot's lack of experience.NTSB MIA00FA229Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-200 · Raleigh, NCthe pilot's continued VFR flight into IMC conditions, by failing to maintain altitude, and descending from VFR conditions into IMC, which resulted in him subsequently impacting with trees. Factors in this accident were: reduced visibility due to dark night…NTSB FTW00LA220Accident · No injuriesLimited investigationFinal reportAero Tek Zuni · Uvalde, TXThe pilot's inadvertent flight into adverse weather conditions which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA281Accident · No injuriesLimited investigationFinal reportCessna 180 · North Las Vegas, NVThe pilot's improper recovery from a bounced landing and subsequent failure to maintain directional control of the aircraft. Wind shear on landing approach was a factor in the accident.NTSB CHI00FA227Accident · 4 fatalField investigationFinal reportCessna 182A · Sauk City, WIVFR flight into IMC encountered by the pilot and exceeding the design limits of the aircraf. A factor was flight to a destination alternate not performed by the pilot.NTSB ATL00LA072Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Charleston, SCThe pilot's inadequate evaluation of weather information, and his delay in taking remedial action that resulted in the in-flight encounter with severe weather.NTSB FTW00LA221Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kingfisher, OKThe pilot's failure to maintain aircraft control. A factor was the downdraft weather condition.NTSB LAX00MA273Accident · 7 fatalMajor investigationFinal reportAerospatiale AS 355F1 · Kahului, Maui, HIThe pilot's inadequate decision by which he continued visual flight rules flight into instrument meteorological conditions. Also causal was his failure to maintain terrain clearance resulting in a collision with mountainous terrain. A contributing factor was…NTSB DEN00FA118Accident · 1 fatalField investigationFinal reportCessna 152 · Karval, COthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's inadvertent flight into the clouds, and his becoming spatially disorientated.NTSB ATL00LA068Accident · No injuriesLimited investigationFinal reportDouble D Enterprises Rans S-12 · Baneberry, TNThe pilot's inadequate compensation for wind conditions. Factors were the trees, and gusting winds.NTSB CHI00FA171Accident · 1 fatalField investigationFinal reportCessna 210J · Sumner, IAfailure of the pilot to maintain clearance with the terrain after flight into adverse weather. Contributing factors were the thunderstorms and lack of instrument certification by the pilot.NTSB ANC00LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors in the accident were the presence of a tailwind, the pilot's inadvertent touchdown, and a short landing area bordered by high vegetation.NTSB ANC00TA075Accident · No injuriesFinal reportPiper PA-18 · Quinhagak, AKThe pilot's inadequate compensation for wind conditions during takeoff. Factors associated with the accident were the sudden windshift from a crosswind to a tailwind.NTSB ANC00FA076Accident · 1 fatalField investigationFinal reportCessna 172N · Tuntutuliak, AKThe pilot's disregard of the existing wind conditions, and an inadvertent stall. Factors associated with the accident are a tailwind, and wind gusts.NTSB ANC00LA073Accident · Minor injuriesLimited investigationFinal reportBlanc Glastar · Northway, AKThe pilot's continued flight into known adverse weather. A factor associated with the accident were low clouds.NTSB ANC00GA071Accident · 4 fatalFinal reportCessna 185E · Talkeetna, AKThe pilot's continued flight into known adverse weather conditions and subsequent in-flight break-up. Factors in the accident were weather conditions consisting of low ceilings, turbulence, and an occluded front with convective activity, and inadequate…NTSB ANC00LA070Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's inadequate compensation for wind conditions. A factor associated in the accident was a variable wind.NTSB LAX00LA220Accident · Serious injuriesLimited investigationFinal reportSikorsky HH-3F · Wellington, NVthe pilot's encounter with a wind shear while maneuvering at low altitude in mountainous terrain, which resulted in a high descent rate and inadvertent entry into a power settling condition.NTSB LAX00LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mesa, AZthe failure of the pilot to maintain directional control in that he failed to properly position the ailerons during his landing roll. Gusty, crosswind conditions, from a direction and velocity that equaled the aircraft's maximum demonstrated crosswind…NTSB MIA00LA187Accident · No injuriesLimited investigationFinal reportCessna 172M · Davis, NCThe pilot's inadequate compensation for wind. The crosswind was a contributing factor.NTSB SEA00FA095Accident · 3 fatalField investigationFinal reportCessna 414 · Monarch, MTThe failure of the pilot-in-command to ensure adequate airspeed for flight during a forced descent due to airframe icing, resulting in a stall. Factors included: freezing rain conditions, airframe icing, an improper decision by the pilot-in-command to turn…NTSB DEN00FA095Accident · 3 fatalField investigationFinal reportCessna T210K · Buena Vista, COthe pilot's disregard of the weather forecast, and his VFR flight into IMC. Contributing factors were snow showers, fog, and the mountainous terrain.NTSB FTW00FA144Accident · 2 fatalField investigationFinal reportCessna 210L · Mack, COThe pilot's continued VFR flight into instrument meteorological conditions. Factors were the mountain obscuration and the rising terrain.NTSB FTW00LA141Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Monument Valley, UTThe pilot's inadequate compensation for wind conditions and his delayed go-around, which resulted in the loss of aircraft control. A factor was the turbulent weather conditions.NTSB NYC00FA118Accident · 5 fatalField investigationFinal reportMooney M20J · Norton, VAThe pilot's improper weather evaluation, which resulted in a loss of aircraft control. Factors in this accident were icing conditions, and aircraft loading which exceed the airplane's weight and balance limitations.NTSB ANC00LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's intentional flight into known adverse weather. Factors associated with the accident were the variable crosswind conditions, and the pilot's inadequate compensation for those wind conditions.NTSB MIA00LA130Accident · Minor injuriesLimited investigationFinal reportScott Vans RV-4 · Natchez, MSan inadvertent stall at too low altitude to allow recovery. Factors in this accident were fog and low ceilings.NTSB IAD00TA040Accident · No injuriesFinal reportCessna 182RG · Cleveland, OHthe pilot's intentional flight into known icing conditions which resulted in an inadvertent stall/mush and hard landing. A factor in the accident was the icing conditions.NTSB ANC00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Aleknagik, AKThe first pilot's (pilot-in-command) inadequate evaluation of the weather, and failure to maintain an adequate altitude above the ground. Factors in the accident were low ceilings, and snow-covered terrain.NTSB LAX00LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Dallas, TXThe en route cruise encounter with forecast moderate turbulence.NTSB FTW00FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech M35 · Gulf Of Mexicothe pilot's continued flight of the airplane into known adverse weather conditions resulting in the pilot's loss of control of the aircraft. Contributing factors were the severe turbulence and windshear.NTSB FTW00FA113Accident · 2 fatalField investigationFinal reportVans RV-6T · Pettigrew, ARthe pilot's continued flight into known adverse weather and his failure to maintain obstacle clearance. Contributing factors were adverse weather conditions, and the pilot's disregard for the forecasted adverse weather.NTSB ANC00TA039Accident · No injuriesFinal reportBell 206B · Manokotak, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings and snow, and snow-covered terrain.