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 LAX93FA160Accident · 4 fatalField investigationFinal reportCessna 172P · Livermore, CAThe pilot's decision to attempt VFR flight into instrument meteorological conditions. Factors that contributed to this accident were: the pilot's lack of recent instrument experience, the rain and high wind conditions in the area.NTSB DCA93MA033Accident · No injuriesClass 1 · MajorFinal reportBoeing 747-121 · Anchorage, AKThe lateral separation of the no. 2 engine pylon due to an encounter with severe or possibly extreme turbulence that resulted in dynamic multi-axis lateral loadings that exceeded the ultimate lateral load-carrying capability of the pylon, which was already…NTSB LAX93FA165Accident · 1 fatalField investigationFinal reportCessna 152 · Dunsmuir, CAAn inadvertent encounter with rain and icing conditions. Factors in this accident included environmental conditions consisting of rain, icing, and darkness, and the pilot's overconfidence in his abilities to deal with the encountered weather conditions.NTSB MIA93LA093Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Panacea, FLThe pilot's inadeqaute compensation for wind conditions. The downdraft was a factor.NTSB BFO93FA061Accident · 1 fatalField investigationFinal reportCessna A152 · Revere, PAThe CFI failed to adequately supervise the operation. Related factors were dark night, lost/disorientation of the pilot, and her lack of experience in type of operation (night flying).NTSB SEA93LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Jordan Valley, ORThe pilot continued the VFR flight into IMC and failed to maintain clearance from obstacles on the ground. Factors relating to the accident were the clouds, low ceiling, and rain.NTSB BFO93LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lewisburg, OHThe pilot experienced spatial disorientation. Contributing to the accident was the dark night and inadvertent flight into instrument meteorological conditions.NTSB MIA93LA090Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Jacksonville, FLThe operator's lack of adequate instructions to crewmembers as to when flight attendants can resume cabin duties after being told to be seated by the captain.NTSB BFO93FA049Accident · Minor injuriesField investigationFinal reportBritish Aerospace BAE 3101 · Beckley, WVFailure of the captain to assure proper alignment with the plowed portion of the runway (or perform a missed approach). Factors related to the accident were: darkness, the adverse weather condition, inadequate removal of snow from the runway with snow along…NTSB DEN93FA033Accident · 3 fatalField investigationFinal reportHiller UH-12E · Applegate, ORThe pilot initiating flight into known adverse weather. Factors were: low ceiling, fog, and turbulence.NTSB LAX93LA143Accident · No injuriesLimited investigationFinal reportE.L. Erickson Tierra II · Rio Linda, CAThe flight's encounter with a downdraft. A factor relating to this accident was the trees.NTSB BFO93LA048Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-7-102 · Philadelphia, PAAn encounter with turbulence during final approach. A factor related to the accident was that the flight attendant was not seated with a seat belt fastened.NTSB BFO93FA033Accident · 1 fatalField investigationFinal reportBeech E18S · Lemont, PAImproper inflight planning decision by the pilot, and his failure to maintain proper altitude during the approach. Factors related to the accident were darkness, adverse weather conditions, and high terrain.NTSB BFO93FA030Accident · 1 fatalField investigationFinal reportAmerican General AG5B · Vergennes, VTVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from snow covered terrain after becoming spatially disoriented in whiteout conditions. The adverse weather and snow covered…NTSB LAX93FA119Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Truckee, CAThe pilot's continued VFR flight into instrument meteorological conditions. The adverse weather conditions contributed to the accident.NTSB CHI93LA077Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIThe pilot's failure to properly align the aircraft with the landing area.NTSB SEA93LA054Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Fruit Heights, UTVFR flight into IMC conditions was attempted by the pilot. Factors include rain, snow, and fog.NTSB BFO93FA050Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Ligonier, PAVisual flight rules (VFR) flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude from the wooded terrain. The terrain and adverse weather conditions were related factors.NTSB CHI93LA070Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Susank, KSThe pilot's continued flight into adverse weather and the owner's representation that the airplane met the requirements for flight into icing conditions. The weather and airframe ice were factors in the accident.NTSB MIA93LA045Accident · Serious injuriesLimited investigationFinal reportBoeing 767-323ER · Sarasota, FLThe in-flight encounter with weather and the failure of the passengers to comply with the instructions of the flightcrew.NTSB SEA93FA048Accident · 4 fatalField investigationFinal reportBell 206B3 · Ogden, UTThe pilot's continuation of VFR flight into instrument meteorological conditions, and his decision to continue his landing attempts under the adverse weather conditions. Factors contributing to the accident were the low clouds, fog and mountainous terrain.NTSB MIA93FA058Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brilliant, ALThe pilot-in-command's intentional flight into adverse weather which resulted in a loss of control. In addition, the pilot was overconfident in his ability. Factors which contributed to the accident were the weather conditions and the dark night.NTSB LAX93FA086Accident · 2 fatalField investigationFinal reportRockwell 690B · Herlong, CAAn inadvertent encounter with severe turbulence which exceeded the design strength of the airplane's structure.NTSB DEN93FA021Accident · 3 fatalField investigationFinal reportCessna 210 · Aurora, COCollision with terrain when the pilot inadvertently flew into fog while conducting a visual approach. Factors were: inaccurate weather evaluation by the pilot and lack of familiarity with the geographic area.NTSB FTW93FA055Accident · 2 fatalField investigationFinal reportMooney M20C · Deridder, LAThe pilot's loss of control of the airplane in IMC. A factor was his lack of recent instrument flight experience.NTSB DEN93FA017Accident · 1 fatalField investigationFinal reportRockwell 690C · Golden, COThe pilot flying the aircraft beyond the design maneuvering speed and exceeding the design stress limits. A factor was: clear air turbulence.NTSB SEA93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Moran Junction, WYThe pilot in command's attempting flight into known adverse weather conditions and his subsequent inability to maintain altitude. Factors contributing to the accident were icing conditions and trees.NTSB DEN93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to evaluate changing weather conditions.NTSB CHI93FA054Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Gaylord, MIThe pilot-in-command exceeded the airplane's design stress limits.NTSB CHI93FA053Accident · 1 fatalField investigationFinal reportPiper PA-30 · Bowman, NDThe non instrument rated private pilot's failure to maintain adequate terrain clearance after inadvertent VFR flight into instrument meteorological conditions.NTSB SEA93FA033Accident · 1 fatalField investigationFinal reportBeech 35-33 · Riverton, UTTerrain clearance was not maintained. Factors to the accident were: snow and flight into known adverse weather.NTSB DEN93FA015Accident · No injuriesField investigationFinal reportDouglas DC-8-52 · Denver, COAn encounter with severe clear air turbulence.NTSB MIA93FA025Accident · 1 fatalField investigationFinal reportCessna 152 · Ocala, FLThe pilot-in-command becoming lost and disoriented and his failure to maintain altitude.NTSB CHI93LA047Accident · No injuriesLimited investigationFinal reportBeech A36 · Frankfort, ILFailure of the pilot in command to maintain an airspeed above stall during a landing flare.NTSB LAX93LA056Accident · 2 fatalLimited investigationFinal reportCessna 182K · Flagstaff, AZThe pilot's continued flight into instrument meteorological conditions and improper remedial action by descending into high terrain. Contributing to this accident were the prevailing cloud condition.NTSB FTW93LA043Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Washington, OKThe pilot's failure to maintain proper clearance over the fence.NTSB CHI93LA041Accident · Serious injuriesLimited investigationFinal reportAero Commander 500-B · Mccook, NEThe pilot's improper decision to depart in known adverse weather conditions. The icing conditions and structural ice were factors.NTSB SEA93FA026Accident · 6 fatalField investigationFinal reportBeech A60 · Snoqualmie Pass, WAFailure of the pilot to maintain control of the aircraft, his failure to prevent the aircraft from exceeding the never exceed speed (vne), and subsequent exceeding of the design stress limits of the aircraft. Factors related to the accident were: weather…NTSB DEN93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Kersey, COInadvertent stall and loss of control due to structural icing. Factors were: icing conditions, and flight into known adverse weather.NTSB ATL93FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Blairsville, GAThe pilot's decision to continue the flight into adverse weather conditions which resulted in the inflight collision with high terrain. Factors were high wind and rain.NTSB FTW93FA039Accident · 1 fatalField investigationFinal reportCessna 172M · Snook, TXThe pilot's intentional flight into instrument meteorological conditions as a result of his alcoholic and drug impairment of efficiency and judgement. Factors contributing to the accident were: the pilot's failure to obtain weather information, the dark night…NTSB BFO93FA005Accident · 3 fatalField investigationFinal reportCessna 177B · War, WVVFR flight by the pilot into instrument meteorological conditions, his failure to maintain control of the airplane due to spatial disorientation, and the pilot allowing the design stress limits of the aircraft to be exceeded. Factors related to the accident…NTSB FTW93LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Jayton, TXThe pilot failed to maintain flying speed while maneuvering for landing and allowed the a/c to stall. Factors were the low ceilings, the pilots disregard of the forecast weather, the carburetor icing conditions, and the pilots delayed application of…NTSB ANC93FA013Accident · 3 fatalField investigationFinal reportCessna 402C · Kiana, AKThe pilot in command's attempt to fly VFR into IMC conditions. Factors were snow, whiteout conditions, and mountainous terrain.NTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.NTSB LAX93LA031Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIThe flight's encounter with unforecasted unfavorable winds (loss of thermal lift) and downdrafts while on final approach to the runway.NTSB SEA93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Evanston, WYThe pilot's disregard of hazardous weather advisory, resulting in flt into forecast icing conditions in an acft not equipped or certified for the flt, and the improper inflt planning by pilot during the VFR approach that resulted in impact with terrain short…NTSB LAX93LA027Accident · No injuriesLimited investigationFinal reportBeech 36TC · Sedona, AZThe pilot's poorly planned approach and delay in executing the appropriate remedial action. Contributing to this accident was the pilot's failure to maintain the proper glidepath and encountering a downdraft.NTSB SEA93LA017Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Green River, UTThe inadequate preflt planning/preparation by the pilot resulting in inflt encounter with weather and his failure to maintain proper rate of descent during an emergency forced landing. A factor relating to the accident was the turbulent weather conditions.NTSB CHI93FA024Accident · 2 fatalField investigationFinal reportCessna U206F · Valentine, NEThe pilot-in-command's intentional flight into an area of low ceilings, and his failure to maintain an altitude sufficient for terrain clearance. Factors which contributed to the accident were: the pilot's overconfidence, the low ceiling and the dark night…