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 FTW01FA098Accident · 1 fatalField investigationFinal reportCessna 172E · Bay City, TXthe pilot's delay in taking remedial action (contacting ATC) after he became lost/disoriented during a night cross country flight, which resulted in a forced landing due to fuel exhaustion. Contributing factors to the accident were the pilot's failure to…NTSB SEA01FA070Accident · 2 fatalField investigationFinal reportCessna 182P · Fairfield, WAThe pilot's failure to maintain altitude and/or clearance over trees, resulting in a collision with trees, separation of a wing and uncontrolled collision with terrain. Factors included the pilot's inadequate preflight planning and preparation, dark night…NTSB LAX01FA145Accident · 3 fatalField investigationFinal reportCirrus Design SR20 · Sierra Vista, AZthe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in an in-flight collision with mountainous terrain. Factors in the accident included the adverse weather conditions and the dusk lighting conditions.NTSB NYC01LA096Accident · Serious injuriesLimited investigationFinal reportDornier 328-100 · Springfield, VAAn inadvertent encounter with turbulence during descent.NTSB DEN01LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Telluride, COthe pilot's failure to maintain control of the airplane during initial climb. Factors include the gusty wind and high density altitude conditions.NTSB FTW01FA095Accident · 2 fatalField investigationFinal reportCessna 190 · Lurton, ARthe pilot's continued VFR flight into IMC, which resulted in spatial disorientation and the ensuing loss of aircraft control while in cruise flight. Contributory factors were the haze and fog weather conditions.NTSB ATL01FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Jasper, GAThe pilot disregarded preflight weather briefing information, and continued visual flight into known instrument weather conditions and collided with trees.NTSB LAX01FA134Accident · 2 fatalField investigationFinal reportCessna 172N · Rialto, CAThe pilot's intentional visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's improper weather evaluation and lack of total experience.NTSB ANC01LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's continued VFR flight into instrument metrological conditions during cruise flight. Factors associated in the accident were low ceilings, whiteout conditions, and snow-covered terrain.NTSB DEN01FA070Accident · 4 fatalField investigationFinal reportBeech A36 · Jackson Hole, WYthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inflight collision with terrain during cruise flight. Factors were the pilot's inadequate preflight planning in that he failed to familiarize himself with the…NTSB LAX01FA112Accident · 1 fatalField investigationFinal reportNorth American Navion · Santa Ysabel, CAthe pilot's continued VFR flight into IFR conditions, which resulted in a loss of control due to spatial disorientation.NTSB LAX01LA110Accident · 2 fatalLimited investigationFinal reportJones RV-6A · Inyokern, CAthe in-flight collision with mountainous terrain during a forced landing following a loss of engine power resulting from the pilot's inadequate weather evaluation, continued flight into icing weather conditions, his delay in carburetor heat use, and his delay…NTSB MIA01LA089Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300T · Gulfport, MSthe pilot's attempted flight into known adverse weather, resulting in an in flight loss of control, exceedance of design limits of the aircraft, and wing separation prior to collision with water.NTSB FTW01FA069Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Borger, TXthe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain obstacle clearance. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing and the dark night conditions.NTSB ATL01FA036Accident · 5 fatalField investigationFinal reportCessna 421 · Munford, ALThe pilot continued visual flight into instrument weather conditions that resulted in the inflight collision with a river bank. Factors were reduced visibility and dark night.NTSB CHI01LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mitchell, SDThe pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.NTSB ANC01LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Anvik, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent in-flight collision with terrain during descent. Factors in the accident were the presence of fog, and snow-covered terrain.NTSB DEN01FA045Accident · 2 fatalField investigationFinal reportCessna 182K · Elbert, COthe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC), which resulted in an in-flight collision with terrain. Contributing factors to the accident were the low clouds, reduced visibilities due to fog, and the…NTSB NYC01LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Falmouth, MAThe pilot's improper decision to takeoff and attempt VFR flight in IMC conditions.NTSB DEN01FA041Accident · 9 fatalField investigationFinal reportBeech 65-A90 · Lake Point, UTthe pilot's exercise of poor judgment and his failure to maintain a safe altitude/clearance above the water. Contributing factors were the weather conditions that included low ceiling and visibility obscured by snow and mist, an inadequately equipped airplane…NTSB CHI01FA064Accident · 2 fatalField investigationFinal reportCessna 172K · Martinsville, INThe pilots decision not to fly to the alternate airport, his decision to continue the flight in known adverse weather conditions, spatial disorientation by the pilot, and his failure to maintain aircraft control. Factors were the low ceilings, the dark night,…NTSB DEN01LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Spanish Fork, UTImproper weather evaluation by both the pilot and pilot/passenger, and the pilot's inadvertent VFR flight into IMC resulting in his spatial disorientation. Factors were the pilot rated passenger's spatial disorientation, fog, and night conditions.NTSB LAX01IA066Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Honolulu, HIthe electrical wire arcing and burning as result of insulation degradation, which more than likely resulted from improper clamping.NTSB FTW01LA041Accident · No injuriesLimited investigationFinal reportBeech BE-60 · Addison, TXThe pilot's misjudged flare of the airplane resulting from restricted forward visibility. Factors were the pilot's continued flight into known adverse weather conditions, the icing conditions, and the iced windshield.NTSB ANC01LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Deadhorse, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were clouds, fog, dusk light conditions, and the pilot's self-induced pressure to complete the flight prior to nightfall.NTSB DEN01FA030Accident · No injuriesField investigationFinal reportHawker Siddeley HS-125-700 · Jackson, WYThe pilot's failure to follow IFR approach procedures and perform a missed approach when the runway was not in sight below approach minimums. Contributing factors were the copilot's failure to follow current ILS approach procedures and use the correct…NTSB ANC01FA026Accident · 2 fatalField investigationFinal reportCurtis-Wright C46A · Kenai, AKThe flight crew's decision to continue VFR flight into instrument meteorological conditions. Factors associated with the accident are high winds, turbulence, and low ceilings.NTSB DEN01FA028Accident · 2 fatalField investigationFinal reportCessna 172 · Lusk, WYthe pilot's VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance, which resulted in an in-flight collision with terrain. Contributing factors were the pilot's failure to obtain a weather briefing, low…NTSB DEN01FA027Accident · 1 fatalField investigationFinal reportMooney M20K · Ogden, UTthe pilot's inadvertent VFR flight into IMC, which resulted in a collision with mountainous terrain. Contributing factors were the blowing snow, turbulence, dark night light conditions, and pilot fatigue due to the long flight day.NTSB NYC01FA056Accident · 1 fatalField investigationFinal reportCessna 310Q · Chesterfield, NHThe pilot's continued flight into icing conditions, and his failure to use alternate air. A factor was the icing conditions.NTSB LAX01LA052Accident · Serious injuriesLimited investigationFinal reportCessna 172H · San Diego, CAThe pilot's inadequate preflight planning and weather evaluation that resulted in the inadvertant entry into instrument meteorological conditions while conducting visual flight. A factor was fog and the night visual conditions.NTSB ANC01IA022Incident · Minor injuriesIncident investigationFinal reportBoeing 747-422 · Port Heiden, AKAn encounter with severe turbulence while in cruise flight. Factors in the incident were a delay in notification of the turbulence, and the lack of controller/pilot data link communications in the Anchorage ARTCC area.NTSB MIA01LA039Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Marathon, FLThe certified flight instructors disregard of an FAA weather forecast stating VFR flight not recommended resulting in VFR flight into known instrument flight conditions, loss of aircraft control due to spatial disorientation, and subsequent in-flight descent…NTSB DEN01FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Antimony, UTthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his VFR flight into IMC, lack of instrument certification, spatial disorientation, low ceiling, and snow.NTSB FTW01LA032Accident · 1 fatalLimited investigationFinal reportSmith Team Tango 2 · Dry Creek, LAthe pilot's VFR flight into IMC while in cruise, which resulted in his loss of control of the airplane due to spatial disorientation. Contributing factors were the clouds, and icing weather conditions, and the inadequate weather briefing.NTSB NYC01FA053Accident · 3 fatalField investigationFinal reportRobinson R-44A · Sandgap, KYthe pilot's improper weather evaluation, and his failure to maintain terrain clearance while operating over unlighted terrain at night. Factors were the isolated areas of fog, and night conditions.NTSB LAX01LA047Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Kaunakakai, HIThe pilot's improper assessment of in-flight weather conditions, his inadequate compensation for winds, and his failure to maintain sufficient altitude and clearance on the lee side of mountainous terrain.NTSB IAD01LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Boston, MAThe airplane's inadvertent encounter with severe turbulence.NTSB MIA01LA030Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Ashevelle, NCthe flight encountered forecasted turbulence, which resulted in serious injury to a flight attendant. Factors in this accident were; the captain's inadequate briefing to the cabin crew; and the insufficient information about the known turbulence that would be…NTSB FTW01FA021Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Houston, TXthe pilot's failure to maintain obstacle clearance while maneuvering, which resulted in an in-flight collision with objects. Contributing factors were the dark night and low ceilings.NTSB ANC01LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-790 · Anchorage, AKAn in-flight encounter with clear air turbulence.NTSB DEN01FA013Accident · 1 fatalField investigationFinal reportCessna 175 · Hanksville, UTthe pilot's failure to maintain control of the airplane while maneuvering at low altitude, and his physical impairment due to alcohol and drugs. A contributing factor was the downdraft.NTSB SEA01LA014Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Portland, ORAn inflight encounter with turbulence that occurred before flight attendants could finish stowing a beverage cart and return to their seats.NTSB LAX01FA023Accident · 2 fatalField investigationFinal reportMooney M-20J · Wheaton Springs, CAThe pilot's inadequate weather evaluation and attempted VFR flight into IMC, which resulted in the in-flight collision with mountainous terrain.NTSB IAD01LA008Accident · Minor injuriesLimited investigationFinal reportConn Sonerai II · Manassas, VAFuel starvation of the engine, caused by the fracturing of the fuel pump switches during a turbulence encounter.NTSB LAX01FA014Accident · 2 fatalField investigationFinal reportBeech 35-33 · Monterey, CAThe pilot's inadequate in-flight planning/decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain control of the airplane. Contributing factors were low ceiling, spatial disorientation and lack of…NTSB ANC01LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ekwok, AKThe pilot's inadequate compensation for a crosswind condition. A factor in the accident was a crosswind.NTSB LAX01FA001Accident · 4 fatalField investigationFinal reportBeech A36TC · San Juan Batist, CAthe pilot's in-flight decision to continue flight into instrument weather conditions at an altitude that did not maintain an adequate terrain clearance, which resulted in a collision with terrain. Factors were a dark night, clouds, fog, mountainous terrain,…NTSB FTW01LA004Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Jasper, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions, which resulted in his failure to maintain control of the helicopter. Factors were the fog and the pilot's lack of instrument flight experience.NTSB LAX00FA354Accident · 1 fatalField investigationFinal reportPiper PA-38 · San Luis Obispo, CAThe pilot's failure to maintain clearance from terrain while turning to reverse course following inadvertent nighttime flight into instrument meteorological conditions. A factor in the accident was the pilot's lack of experience in nighttime operations.