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 ATL03LA046Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Morristown, TNThe pilot's inadequate preflight planning/decision to initiate flight into known adverse weather conditions, resulting in the in-flight encounter with weather and subsequent in-flight collision with terrain. A factor was airplane performance deteriorated due…NTSB MIA03LA061Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · Miami, FLThe non instrument-rated pilot-in-command's improper inflight planning/decision, and continued VFR flight into instrument meteorological conditions, which resulted in a loss of control during descent, and impact with water.NTSB DEN03LA043Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Aspen, COthe dual student's failure to maintain aircraft control and the inadequate supervision by the flight instructor. Contributing factors include the tailwind and the turbulence.NTSB CHI03FA071Accident · 1 fatalField investigationFinal reportCessna 172N · Wellington, KSSpatial disorientation experienced by the pilot and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing prior to the return flight, his attempted flight into…NTSB SEA03LA037Accident · No injuriesLimited investigationFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision of the flight. Contributing factors were the rime icing conditions, and the soft terrain encountered on the off runway rollout.NTSB LAX03FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Kalaupapa, HIthe student pilot's inadvertent VFR flight into IMC, which resulted in his in-flight collision with mountainous terrain while maneuvering. A contributing factor was the low ceiling weather condition.NTSB LAX03FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Mather, CAloss of engine power in the left engine for undetermined reasons. Also causal was the pilot's failure to correctly configure the airplane for a single engine missed approach, which resulted in a negative climb performance. A factor was the pilot's decision to…NTSB FTW03FA089Accident · Serious injuriesField investigationFinal reportCessna 208B · San Angelo, TXThe flight crew's failure to cycle the deice boots prior to conducting a simulated forced landing and their failure to maintain adequate airspeed during the maneuver, which resulted in an inadvertent stall and subsequent loss of control. A contributing factor…NTSB FTW03LA088Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Oak Grove, LAThe pilot's continued flight into adverse weather conditions, and his improper landing flare resulting in a hard landing. A contributing factors was the fog.NTSB SEA03LA029Accident · Serious injuriesLimited investigationFinal reportDassault Falcon 900EX · (Pacific Ocean)The aircraft's encounter with moderate turbulence in cruise.NTSB FTW03FA082Accident · 2 fatalField investigationFinal reportAgusta A-109-K2 · Salt Lake City, UTThe pilot's delayed remedial action and continued flight into known adverse weather conditions which resulted in his failure to maintain clearance with the ground. Contributing factors were the prevailing fog, and the pressure to complete the mission induced…NTSB LAX03FA069Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Flagstaff, AZthe pilot's failure to comply with his instrument clearance route instruction and to maintain his assigned altitude. A factor in the accident was the poor quality of radio communications due to the severance of underground fiber optic voice and data lines for…NTSB ATL03LA028Accident · No injuriesLimited investigationFinal reportCessna 172F · Stuart, FLThe pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.NTSB SEA03LA019Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC-135 P1 · Loon Lake, WAThe pilot's inadvertent flight into instrument meteorological conditions (IMC) while in cruise flight, and an excessive descent rate. Factors include falling snow, whiteout conditions and dark night conditions.NTSB LAX03FA051Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Anaheim Hills, CAthe pilot's encounter with forecast severe turbulence during an inadvertent penetration of an intense weather cell, which resulted in the pilot exceeding the design structural limits of the airplane. A factor in the accident was the pilot's inadequate…NTSB MIA03LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Cashiers, NCThe pilot's inadequate in-flight decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain terrain clearance. Contributing factors were a low ceiling and mountainous terrain.NTSB FTW03FA057Accident · 1 fatalField investigationFinal reportCessna 210L · Harrison, ARThe pilot's failure to maintain control of the aircraft and the exceedance of the manufactured limits, which resulted in an in flight break-up. Contributing factors were the dark night conditions and the clouds.NTSB FTW03LA056Accident · No injuriesLimited investigationFinal reportCessna 172M · Vici, OKThe pilot's departure and continued flight into adverse weather conditions. Contributing factors were the icing conditions, and the lack of suitable terrain for the precautionary landing.NTSB DEN03LA019Accident · Serious injuriesLimited investigationFinal reportCameron Balloons O-70 · Montrose, COthe unforecasted increase in wind velocity. A contributing factor was the fence that the basket struck, subsequently spilling the occupants onto the ground.NTSB SEA03FA013Accident · 2 fatalField investigationFinal reportCessna 172P · Malaga, WAThe pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…NTSB FTW03LA049Accident · 2 fatalLimited investigationFinal reportGirard RV-4 · Homer, LAThe pilot's VFR flight into IMC conditions and his failure to obtain/maintain altitude/clearance from trees during the initial climb after takeoff. Contributing factors were fog and trees.NTSB FTW03FA048Accident · 2 fatalField investigationFinal reportBeech A36 · Salem, UTThe pilot's inadequate inflight planning/decision to continue flight from visual to instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain while in cruise flight. A low ceiling, obscuration, mountainous terrain…NTSB NYC03FA024Accident · 1 fatalField investigationFinal reportSocata TB-20 · Massena, NYThe pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.NTSB NYC03IA027Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Rockville, VAThe PIC's inadvertent encounter with turbulence while operating in an area of forecast occasional severe turbulence.NTSB NYC03FA022Accident · 2 fatalField investigationFinal reportCessna 182D · NewPhiladelphia, OHThe pilot's improper decision to disregard the weather briefing, and to conduct an intentional flight into known icing conditions, with an airplane not equipped for that flight, and his failure to maintain airspeed. Factors were the clouds and icing…NTSB DEN03FA012Accident · 4 fatalField investigationFinal reportCessna 208B · Parks, AZthe pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…NTSB ATL03LA014Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Orlando, FLThe airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.NTSB FTW03FA029Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · Las Vegas, NMThe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain clearance with the terrain. A contributing factor was the pilot's failure to obtain an updated preflight weather briefing.NTSB FTW03LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fort Stockton, TXThe pilot's decision to conduct VFR flight into IMC and his failure to maintain terrain clearance. Contributing factors were the dark night, clouds, fog, and the lack of suitable terrain.NTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.NTSB ATL03LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Laurel Bloomery, TNThe pilot's failure to maintain clearance with terrain, which resulted in an inflight collision with mountainous terrain. Factors were the pilot's inadequate preflight planning and failure to obtain weather information, which resulted in an inflight encounter…NTSB ATL03FA010Accident · 3 fatalField investigationFinal reportCessna R182 · Greensboro, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with the ground. Factors were low ceilings and fog.NTSB FTW03FA016Accident · 6 fatalField investigationFinal reportPiper PA-32-301 · Paron, ARThe pilot's failure to maintain altitude/clearance from terrain. Contributing factors were the low ceiling, the pilot's decision to fly in known adverse weather conditions, and his lack of an instrument rating.NTSB ANC03LA003Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235 · Wrangell, AKThe pilot's inadequate weather evaluation, his continued flight into instrument meteorological conditions (IMC), and his failure to maintain adequate altitude/clearance from terrain/water, which resulted in a collision with water while maneuvering. Factors…NTSB CHI03LA008Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lake Elmo, MNThe pilot's failure to maintain aircraft control. Factors to the accident included the gusting wind conditions and the encountered windshear, which resulted in the inadvertent stall at a low altitude and subsequent in-flight collision with the transmission…NTSB FTW03LA011Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Vinson, OKThe pilot's inadvertent flight into adverse weather conditions during cruise resulting in his failure to maintain control of the helicopter, and his failure to maintain rotor rpm. Contributing factors relating to the accident included the frontal activity…NTSB MIA02FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Yeehaw Junction, FLthe pilot's continued flight into known severe weather, resulting in an in-flight separation of the right wing, vertical stabilizer and the stabilator. Factors in this accident were heavy thunderstorm, and failure of the FAA controllers to provide the pilot…NTSB ATL02LA170Accident · 1 fatalLimited investigationFinal reportMikoyan Gurevich Mig-15 · Whiteville, NCThe pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation which resulted in a loss of control and the subsequent collision with the ground .NTSB NYC02LA193Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28-B2 · Blairstown, NJThe second pilot's improper in-flight decision to perform a release from the towplane, which did not allow for successful completion of the flight. A factor was the downdrafts.NTSB LAX02FA278Accident · 1 fatalField investigationFinal reportBeech A36 · Grand Canyon, AZthe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…NTSB DEN02GA102Accident · 1 fatalFinal reportCessna A185F · Howard, COthe pilot's failure to maintain clearance of the terrain. Contributing factors were the clear air turbulent weather condition, and the high density altitude condition.NTSB ATL02FA162Accident · 2 fatalField investigationFinal reportAmerican General AA-5B · Zephyrhills, FLThe pilots continued visual flight into instrument conditions (fog), and subsequent collision with a tree and a residence.NTSB ANC02LA110Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Port Alsworth, AKThe pilot's inadequate evaluation of the area weather conditions, and his subsequent inability to maintain terrain clearance upon encountering a downdraft, which resulted in an in-flight collision with tree-covered mountainous terrain. A factor in the…NTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…NTSB FTW02LA237Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Hobbs, NMthe pilot's inadvertent flight into adverse weather conditions which resulted in the loss of thermal lift. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD02FA075Accident · 1 fatalField investigationFinal reportBeech S-35 · Clear Spring, MDThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising terrain. Factors included dense fog and mountainous terrain.NTSB CHI02LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Central City, NEThe pilot was not able to maintain clearance with the trees when the airplane encountered a downdraft at a low altitude. An additional cause was the pilot's inadequate evaluation of the approaching weather conditions. Factors associated with the accident were…NTSB ATL02LA144Accident · 5 fatalLimited investigationFinal reportPiper PA-32RT-300 · Atlantic Ocean, BahamasThe pilot continued VFR flight into IMC and thunderstorm conditions which resulted in spatial disorientation and subsequent loss of control of the airplane.NTSB NYC02FA142Accident · 2 fatalField investigationFinal reportBeech C24R · Grindstone, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.NTSB FTW02CA206Accident · Serious injuriesData collectionFinal reportAero Commander Callair A-9B · El Paso, TXthe loss of control due to the encounter with the dust devil.