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 LAX95LA221Accident · No injuriesLimited investigationFinal reportCessna 172 · Yerington, NVThe pilot's improper in-flight decision to enter mountainous terrain at an insufficient altitude to safely escape adverse weather conditions. Factors relating to the accident were: the terrain and weather conditions.NTSB CHI95LA195Accident · No injuriesLimited investigationFinal reportCessna 172 · St Cloud, MNThe pilot's improper inflight planning/decision, which resulted in continued flight into adverse weather. Factors relating to the accident were: the thunderstorm outflow, and inadequate weather evaluation by the pilot.NTSB CHI95LA188Accident · Serious injuriesLimited investigationFinal reportBoeing 767-222 · Champagne, ILan in-flight encounter with turbulence.NTSB LAX95LA211Accident · 1 fatalLimited investigationFinal reportHarmon Dolphin · Paso Robles, CAThe pilot's decision continue VFR flight into instrument meteorological conditions (IMC), loss of aircraft control due to spatial disorientation, and exceeding the design stress limits of the airplane. The weather condition was a related factor.NTSB LAX95FA210Accident · 1 fatalField investigationFinal reportCessna P210N · Mammoth Lakes, CAthe pilot's continued flight into instrument meteorological conditions during dark nighttime over mountainous terrain; and his failure to maintain an adequate altitude to ensure terrain clearance. Thw weather and terrain were factors.NTSB BFO95FA064Accident · 3 fatalField investigationFinal reportPiper PA-31P-350 · Cedar Bluff, VAthe pilot's improper planning/decision, and his allowing the airplane to exceed its maximum design/stress limitation. Factors relating to the accident were: the adverse weather conditions, and the pilot's continued flight into adverse weather.NTSB NYC95LA132Accident · No injuriesLimited investigationFinal reportBeech 33 · Franklin Twp, PAThe pilot's improper planning/decision, his continued flight into adverse weather conditions, and his delay in reversing course (diverting to a new destination). The adverse weather with thunderstorms was a related factor.NTSB ANC95LA074Accident · Serious injuriesLimited investigationFinal reportChampion 11BC-S · Anchorage, AKThe pilot's improper compensation for the wind conditions. Factors associated with the accident are gusty winds and associated downdrafts.NTSB BFO95LA059Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncy Valley, PAthe non-instrument rated pilot's failure to maintain clearance from terrain after inadvertently entering instrument meteorological conditions. The weather conditions (haze and fog) were a factor in the accident.NTSB MIA95FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Gainesville, FLThe pilot's loss of aircraft control due to spatial disorientation after continuing the VFR flight into instrument meteorological conditions. Factors relating to the accident were: the existing weather conditions and dark night that contributed to the pilot's…NTSB MIA95FA142Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Corinth, MSThe pilots decision to continue his VFR flight into instrument meteorological conditions after being advised that VFR flight should not be attempted, resulting in spatial disorientation and loss of control. Factors in the accident were: the pilot's…NTSB FTW95FA222Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Byers, COThe pilot's continued VFR flight into instrument meteorological conditions and the subsequent loss of control due to spatial disorientation. Factors were the low ceilings, the dark night conditions, and the pilot's lack of total instrument time.NTSB SEA95LA108Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Terreton, IDThe pilot's failure to maintain an adequate altitude to overcome the downdraft. The downdraft was a factor.NTSB ANC95FA056Accident · 1 fatalField investigationFinal reportCessna 150 · Wasilla, AKThe student pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) and failure to maintain clearance (or altitude) from the mountainous terrain.NTSB MIA95LA133Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Tallahassee, FLThe failure of a passenger to comply with flight crew instructions to remain seated with her seat belt fastened which resulted in her being injured while walking in the aisle during a turbulence encounter.NTSB SEA95FA101Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cheyenne, WYfailure of the pilot to maintain sufficient altitude/clearance from rising terrain. Factors relating to the accident were: low light conditions at dusk, low ceilings with thunderstorms in the area, and continued flight by the pilot into adverse weather…NTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.NTSB LAX95LA183Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's inflight loss of control due to his delay in releasing the glider after the towed glider experienced an unplanned altitude gain on takeoff when it encountered a dust devil.NTSB ANC95FA073Accident · 2 fatalField investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall. The pilot's failure to obtain a weather briefing and an encounter with turbulence were factors in the accident.NTSB SEA95FA093Accident · 2 fatalField investigationFinal reportCessna 152 · Snoqualmie Pass, WAThe pilot's attempt to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance with the terrain.NTSB BFO95FA048Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Louisa, VAthe non-instrument rated private pilot's continued VFR flight into IMC and failure to maintain adequate altitude/clearance from terrain/obstacles. Related factors were the pilot's lack of total experience in IMC operations, his failure to obtain a preflight…NTSB ATL95FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Atlanta, GAThe pilot's impairment of judgment and performance due to a drug, VFR flight into instrument meteorological conditions, and failure to remain clear of the obstacle (towering smoke stack). Factors relating to the accident were: the adverse weather conditions.NTSB FTW95LA176Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · Utopia, TXClear air turbulence encountered.NTSB SEA95LA080Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Wheatland, WYThe pilot's continued flight into known adverse weather conditions. A factor in the accident was the airframe icing encountered during the flight.NTSB LAX95FA161Accident · 2 fatalField investigationFinal reportHelio H-250 · Round Mountain, CAthe pilot's poor preflight planning/preparation and in-flight decision by continuing VFR flight into instrument meteorological conditions. The pilot's delay in returning to the departure airport, the low clouds, and low visibility were factors in this…NTSB LAX95FA157Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Pollack Pines, CAThe pilot's disregard of a hazardous weather advisory; his decision to fly into known adverse weather conditions; his failure to maintain control of the airplane with an accumulation of airframe ice; and his improper use of the flight controls during recovery…NTSB NYC95FA080Accident · 1 fatalField investigationFinal reportCessna 172P · Naples, NYThe pilot's continued VFR flight into instrument meteorological conditions. Factors contributing to the accident were: the night conditions, fog, low ceiling, and hilly terrain.NTSB FTW95FA150Accident · 1 fatalField investigationFinal reportCessna 177RG · Dalhart, TXThe pilot's VFR flight into IMC conditions and the ensuing spatial disorientation. Factors were the pilot's self-induced pressure to reach his destination, his failure to obtain a weather briefing for the flight, and the weather conditions.NTSB LAX95FA148Accident · 3 fatalField investigationFinal reportBeech 35-C33 · Toms Place, CAthe pilot's decisions to initially attempt and then continue flight into known forecast and observed adverse weather. Factors in the accident were: the pilot's inadequate preflight planning and his use of a drug.NTSB ATL95LA069Accident · Minor injuriesLimited investigationFinal reportAerotek Zuni · Morganton, NCThe pilot's poorly planned approach which resulted in the loss of control of the aircraft because of gusty wind conditions.NTSB MIA95FA087Accident · 2 fatalField investigationFinal reportCessna 337F · Vero Beach, FLThe pilot's failure to avoid a thunderstorm. The thunderstorm was a factor.NTSB ATL95LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Alma, GAThe aircraft's encounter with unforecast clear air turbulence.NTSB FTW95FA130Accident · 4 fatalField investigationFinal reportCessna 421C · El Prado, NMThe pilot's decision to continue flight into known adverse weather conditions and the ensuing inadvertent stall due to airframe ice. Factors were the weather conditions.NTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.NTSB FTW95LA128Accident · Serious injuriesLimited investigationFinal reportBeech 58P · Montrose, COThe pilot's failure to refuel the airplane resulting in a forced landing. The adverse weather conditions were factors.NTSB LAX95LA123Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 Astir CS · Jean, NVthe pilot's decision to fly in known adverse weather conditions which resulted in a wind shear encounter at low altitude during the takeoff initial climb.NTSB CHI95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Minneapolis, MNan inadequate windshield deicing system for the inflight icing encountered, airframe icing, and the pilot's inability to maintain a proper descent rate. Factors associated with this accident were an inadequate weather forecast and icing conditions.NTSB FTW95FA116Accident · 5 fatalField investigationFinal reportBell 206L-4 · East CameronInadvertent flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the helicopter after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and the pilot's…NTSB FTW95FA114Accident · 2 fatalField investigationFinal reportRockwell 690A · Guthrie, OKThe pilot's failure to maintain adequate airspeed due to airframe ice, which resulted in a loss of control. Factors contributing to the accident were the pilot's continued flight into adverse weather, his failure to obtain weather information either before or…NTSB ATL95FA050Accident · 1 fatalField investigationFinal reportBeech B60 · Gatlinburg, TNThe pilot's continued visual flight into instrument weather conditions that resulted in a collision with rising terrain.NTSB FTW95FA111Accident · 1 fatalField investigationFinal reportCessna 177RG · Larkspur, COThe pilot's decision to continue VFR flight into instrument meteorological conditions after being advised that VFR flight was not recommended. The weather and dark night were factors in the accident.NTSB FTW95LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Howard, COThe pilot's flight into known adverse weather over mountainous terrain at an inadequate altitude to recover from turbulence/downdraft. Factors related to the accident were: inadequate preflight planning/preparation by the pilot, his inadequate weather…NTSB LAX95LA098Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Red Bluff, CAthe flight instructor's poor in-flight decision to continue flight into a reduced visibility area, his failure to execute a 180-degree turn in a timely manner, and his failure to maintain clearance from the terrain.NTSB LAX95LA094Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sedona, AZthe pilot's improper compensation for the prevailing wind conditions, and his improper remedial action by raising the flaps before applying the power. The downdraft was a factor.NTSB BFO95LA027Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Clarion, PAThe failure of the right wing de-ice boot during operation in conditions of ice accumulation, which resulted in a loss of aircraft controllability during the approach/landing. The icing condition was a factor.NTSB LAX95FA079Accident · 2 fatalField investigationFinal reportBell 206B · Los Angeles, CAThe pilot's continued VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's and operator's failure to follow their established dispatch procedures, the pilot's poor judgment in initiating the flight,…NTSB ATL95FA044Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Spring City, TNThe pilot's inadequate preflight planning, and his continued VFR flight into instrument weather conditions which resulted in the collision with the mountain. A factor was low ceilings.NTSB MIA95LA055Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Monroe, LAan in-flight encounter with weather during a climb, resulting in an injury to a flight attendant who got out of her seat to perform a duty.NTSB LAX95FA072Accident · 1 fatalField investigationFinal reportCessna A185F · Tehachapi, CAThe noninstrument-rated pilot's continued flight into known adverse weather, and his failure to maintain adequate airspeed while maneuvering to reverse direction. Factors relating to the accident were: the mountainous terrain, and adverse weather conditions.NTSB MIA95LA052Accident · Minor injuriesLimited investigationFinal reportCessna 152 · New Smyrna Bch., FLIntentional flight into known instrument meteorological conditions by a noninstrument-rated pilot, and the pilot's subsequent spatial disorientation. Contributing to the accident was the pilots' overconfidence in his personal ability.