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 LAX97LA025Accident · No injuriesLimited investigationFinal reportLuscombe 8A · El Cajon, CAunfavorable weather condition(s), which caused the aircraft to descend at a rate that exceeded its climb capability.NTSB SEA97LA021Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Laramie, WYVFR flight by the pilot into instrument meteorological conditions (IMC), his misjudged speed/distance on final approach for landing, and his failure to attain the proper touchdown point during the landing. Factors relating to the accident include snow, low…NTSB ANC97FA001Accident · 3 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKcontinued flight by the pilot into adverse weather condition, and his failure to maintain adequate altitude/clearance from mountainous terrain. Factors related to the accident were the high/mountainous terrain, and weather conditions that included low…NTSB LAX97LA013Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAthe student pilot's impairment of judgment and performance due to alcohol, his subsequent flight into adverse weather conditions, and his failure to maintain clearance from obstructions (power lines). Factors related to the accident were: darkness, low…NTSB NYC97FA004Accident · 2 fatalField investigationFinal reportBeech F33A · Doylesburg, PAcontinued VFR flight by the pilot into instrument meteorological conditions, and his failure to maintain altitude and/or clearance from high terrain. Factors relating to the accident were: darkness, low ceiling, fog, and high (mountainous) terrain along the…NTSB ANC97LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Ashton, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the crosswind and wind gusts.NTSB FTW96FA399Accident · 1 fatalField investigationFinal reportAyres S2R-T45 · Granger, TXthe pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…NTSB FTW96LA393Accident · No injuriesLimited investigationFinal reportCessna 177RG · Boulder, COFailure of the flight instructor to maintain airspeed above stall speed during initial climb and loss of control on the ground after aborting the takeoff. Factors were inadequate preflight planning and preparation, inaccurate weather evaluation, and high…NTSB ANC96LA159Accident · No injuriesLimited investigationFinal reportPzl-Mielec 104-80 · Aniak, AKThe pilot's improper glide path on final approach, and his inadequate compensation for the gusty wind conditions. Factors associated with the accident are the gusty winds and a downdraft.NTSB FTW96FA390Accident · 1 fatalField investigationFinal reportCessna 320C · Waco, TXVFR flight by the pilot into instrument meteorological conditions, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident were: inadequate preflight by the pilot, his failure to obtain a weather…NTSB FTW96IA389Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie AE 340-300 · San Antonio, TXturbulence, and failure of passengers to properly fasten their seat belts and properly hold lap children after the captain announced expected turbulence.NTSB ANC96LA154Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cantwell, AKthe pilot's continued VFR flight into instrument meteorological conditions (IMC). The terrain conditions, low ceiling, fog, and whiteout conditions were related factors.NTSB NYC96FA182Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Frankford Twnsp, NJthe pilot's inadequate preflight planning/preparation by not obtaining a preflight weather briefing, his VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatial disoriented.…NTSB ANC96LA146Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Iliamna, AKthe pilot's inadequate weather evaluation and inadequate compensation for wind conditions. The adverse weather condition was a related factor.NTSB FTW96FA368Accident · 2 fatalField investigationFinal reportCessna 150F · Jones, LAVFR flight into instrument meteorological conditions (VMC), and failure of the pilot (PIC) to maintain control of the airplane after becoming spatially disorientation. Factors relating to the accident were: darkness, the adverse weather condition (fog and…NTSB ANC96FA137Accident · Serious injuriesField investigationFinal reportPiper PA-32 · Haines, AKthe pilot's inadvertent flight into instrument meteorological conditions (IMC) failure to maintain adequate altitude/clearance from terrain, while maneuvering to reverse the direction of flight. Factors associated with the accident were: the pilot's…NTSB FTW96LA366Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Conchas, NMThe pilot's inadvertent flight into hail which shattered the pilot's windshield and resulted in his incapacitation due to hypoxia.NTSB MIA96LA220Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Chattanooga, TNclear air turbulence, which was encountered during cruise flight and resulted in injuries to passengers.NTSB MIA96FA218Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Lagrange, GAthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in a pasture. Contributing factors in this accident were the pilot's inadequate pre-flight and in-flight…NTSB ANC96FA131Accident · 2 fatalField investigationFinal reportMaule M-7 · Barrow, AKthe pilot's inadequate weather evaluation and resultant flight into adverse weather conditions. Factors associated with the accident were: high winds and terrain induced turbulence.NTSB ANC96LA122Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Northway, AKThe pilot's inadequate in-flight planning during a low pass of a remote airstrip and his inadequate compensation for wind conditions. A factor in the accident was unfavorable wind conditions.NTSB MIA96LA208Accident · 1 fatalLimited investigationFinal reportBeech A36 · Atlantic Ocean (Atlantic Ocean)an inflight collision with the terrain (water) for undetermined reason(s). Factors relating to the accident were: failure of the pilot to obtain a preflight weather briefing, his failure to obtain in-flight weather avoidance assistance, and his resultant…NTSB CHI96FA284Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Muncie, INthe inadvertent flight of the airplane by the pilot-in-command into a thunderstorm. The weather was a factor.NTSB ANC96LA120Accident · No injuriesLimited investigationFinal reportCessna 185 · Kaktovik, AKThe pilot's inadequate compensation for the existing wind conditions. A factor associated with the accident was the windshear.NTSB ANC96LA119Accident · No injuriesLimited investigationFinal reportAviat A-1 · King Salmon, AKThe pilot's inadequate weather evaluation, inadequate compensation for the existing wind conditions, and failure to maintain directional control. A factor associated with the accident was the gusty wind.NTSB IAD96LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Waverly, OHthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) with subsequent loss of visual contact and collision with the ground. Darkness and fog were related factors.NTSB ANC96LA112Accident · No injuriesLimited investigationFinal reportCessna 172K · Nikiski, AKThe pilot's inadequate compensation for wind conditions. A factor was the windshear.NTSB SEA96FA175Accident · 2 fatalField investigationFinal reportMooney M20E · Purdy, WAThe noninstrument-rated pilot's continuation of VFR flight into instrument meteorological conditions which led to pilot spatial disorientation and loss of control of the aircraft. Factors were: pilot self-induced pressure, night conditions, low ceilings, and…NTSB LAX96FA294Accident · 1 fatalField investigationFinal reportMooney M20K · Grand Canyon, AZdue to an in-flight loss of control resulting from a probable incapacitation for unknown reasons. The loss of control occurred while the aircraft was being flown in close proximity to a level 6 thunderstorm. The failure of the pilot to obtain current weather…NTSB ANC96LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Mc Carthy, AKThe pilot's inadequate weather evaluation, and his inadvertent flight into instrument meteorological conditions.NTSB MIA96LA195Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Wedowee, ALThe failure of the pilot to obtain a preflight weather briefing and his failure to maintain directional control during the landing roll following a precautionary landing due to adverse weather encountered during the flight.NTSB CHI96LA259Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Hazelton, NDinadvertent VFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude control of the airplane, which resulted in a collision with the terrain. Factors relating to the accident were:…NTSB ANC96FA109Accident · 2 fatalField investigationFinal reportCessna 180B · Iliamna, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and failure of the pilot to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the adverse weather condition (low ceiling and…NTSB NYC96FA158Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Sea Bright, NJthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane, due to spatial disorientation, which resulted in a collision with water. Factors relating to the accident were the pilot's…NTSB LAX96FA275Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Tennant, CAthe pilot's continued flight into known adverse weather conditions.NTSB FTW96LA292Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Gunnison, COThe pilot's improper planning/decision. The weather condition (sudden high wind) was a related factor.NTSB IAD96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Beckley, WVThe pilots decision to continue flying from VFR to IMC conditions which subsequently forced him to make a precautionary landing onto unsuitable terrain.NTSB MIA96LA171Accident · No injuriesLimited investigationFinal reportBeech B35 · Kissimmee, FLthe pilot was operating the airplane at an indicated airspeed that exceeded the design speed for maximum gust intensity (VB), when clear air turbulence was encountered.NTSB CHI96LA222Accident · 1 fatalLimited investigationFinal reportPiper J3C-90 · Racine, WIwas improper remdial action by the pilot after encountering a stall when the elevator back pressure was not removed and the ailerons were positioned for a right bank by that increasing the airplane's left yaw/roll action. Factors in this accident were a stall…NTSB FTW96LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 737-201 · Granite, COAn encounter with clear air turbulence.NTSB FTW96FA267Accident · 4 fatalField investigationFinal reportBeech 58 · Castle Rock, COfailure of the pilot to maintain sufficient altitude and/or clearance from terrain, while reversing course to exit adverse weather conditions. Factors relating to the accident were: the adverse weather conditions (thunderstorm, low ceiling and reduced…NTSB FTW96FA250Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Monument, COThe pilot's VFR flight into instrument meteorological conditions in an aircraft which not instrument-equipped. Factors were clouds, low ceiling, and rain.NTSB FTW96IA237Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Albuquerque, NMthe flightcrew's inadvertent encounter with windshear at low altitude. Factors were: variable winds, high density altitude, and the FAA's inadequate location/height of the LLWAS sensor.NTSB IAD96FA090Accident · 1 fatalField investigationFinal reportCessna 320C · Winslow, MEthe pilot's continued flight into known adverse weather conditions, and his loss of aircraft control, which resulted in an uncontrolled descent into terrain (river). The known icing condition was a related factor.NTSB FTW96IA235Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Childress, TXThe aircraft's encounter with unforcasted and unreported severe turbulence.NTSB CHI96IA173Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146 · Des Moines, IAfailure of the flight crew to follow proper procedures, which resulted in an accumulation of ice and subsequent loss of engine power. Factors relating to the incident were: thunderstorms, turbulence, icing conditions, and the inaccurate method that was…NTSB LAX96FA200Accident · 1 fatalField investigationFinal reportCessna 414 · Kernville, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from rising/mountainous terrain. Factors relating to the accident were: the terrain and weather conditions.NTSB IAD96LA083Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Woodbine, MDThe pilot's decision to fly with inadequate research of forecast weather.NTSB CHI96GA154Incident · No injuriesFinal reportBeech 200 · Peoria, ILthe pilot's intentional flight into known adverse weather conditions and the lightning strike.NTSB NYC96FA101Accident · 2 fatalField investigationFinal reportCessna P210N · Ridgefield, CTimproper planning/decision by the pilot, which led to flight into icing conditions; and his failure to use all anti-ice and deicing equipment, as specified by the airplane operator's manual for inadvertent flight into icing conditions. This resulted in loss…