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 LAX07FA021Accident · 4 fatalField investigationFinal reportCirrus SR22 · Meadview, AZThe pilot's inadequate weather evaluation and continued flight into forecasted icing conditions. Contributing to the severity of the accident was the pilot's failure to follow proper operating procedures and deploy the CAPS when the airplane entered a spin.…NTSB ANC07LA003Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Tuntutuliak, AKThe pilot's misjudgment of distance/altitude during the landing approach, which resulted in an undershoot and in-flight collision with a river embankment. Factors contributing to the accident were reduced visibility due to rain and mist.NTSB ATL07CA006Accident · No injuriesData collectionFinal reportMcCullough J-2 · Indian Trail, NCThe pilot's inadequate compensation for gusting wind conditions and his improper landing flare during an emergency landing after takeoff resulting in a hard landing.NTSB ATL07FA005Accident · 1 fatalField investigationFinal reportBeech BE-19A · Gunthertown, ALThe pilot's continued flight from VMC into IMC conditions which resulted in an in-flight collision with rising terrain.NTSB ANC07LA001Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Alsworth, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control while maneuvering, and an in-flight collision with tree covered terrain. Factors associated with the accident are the pilot's inadequate evaluation of weather…NTSB ANC06CA133Accident · No injuriesData collectionFinal reportPiper PA-18 · Koliganek, AKThe pilot's failure to maintain adequate altitude/clearance from rising terrain while maneuvering at a low altitude, which resulted in an in-flight collision with terrain. Factors associated with the accident were a downdraft, the pilot's intentional low…NTSB NYC06LA223Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Hastings, NEThe airplane's in flight encounter with thunderstorm related turbulence.NTSB ANC06FA131Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. A factor associated with the accident was a low cloud ceiling.NTSB DEN06FA132Accident · 4 fatalField investigationFinal reportBeech 35-C33 · Telluride, COThe pilot's inadvertent flight into mountain wave turbulence resulting in the airplane's loss of control and subsequent impact into mountainous terrain. Factors contributing to the accident were the mountain wave turbulence and high winds.NTSB DEN06FA131Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Maybell, COThe pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…NTSB NYC06FA215Accident · 2 fatalField investigationFinal reportCessna 150G · Penhook, VAThe pilot's failure to maintain aircraft control during climb, which resulted in exceeding the design stress limits of the airplane, and an in-flight breakup. Factors associated with the accident were the pilot's continued visual flight rules flight into…NTSB NYC06LA214Accident · 1 fatalLimited investigationFinal reportCessna 150K · Shelby Gap, KYThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.NTSB DEN06MA119Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Argyle, FLthe pilot's inadvertent flight into thunderstorm activity that resulted in the loss of control, design limits of the airplane being exceeded and subsequent in-flight breakup. A contributing factor was the failure of air traffic control to use available radar…NTSB NYC06MA208Accident · 2 fatalMajor investigationFinal reportMitsubishi MU-2B-40 · Bunnell, FLThe pilot's inadvertent encounter with thunderstorms.NTSB DEN06CA117Accident · No injuriesData collectionFinal reportGordon Vans RV-6 · Erie, COthe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the crosswind.NTSB CHI06FA275Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kulm, NDThe non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.NTSB ANC06LA119Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Whittier, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with terrain while maneuvering to reverse direction in a pass. A factor contributing to the accident was clouds in the pass.NTSB DEN06FA114Accident · Serious injuriesField investigationFinal reportCirrus Design SR20 · Kremmling, COThe pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…NTSB SEA06FA159Accident · 3 fatalField investigationFinal reportRobinson R44 II · Warrenton, ORThe pilot's intentional flight into instrument meteorological conditions while maneuvering which resulted in an in flight collision with terrain/water.NTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…NTSB DEN06FA109Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Mosca, COa non-mechanical partial loss of engine power due to carburetor ice, and the pilot's failure to maintain clearance from terrain. Contributing factors in this accident were weather conditions conducive to carburetor icing and the pilot inadvertently flying…NTSB LAX06LA249Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Independence, CAthe pilot's inadequate preflight and in-flight planning regarding the selection of the altitude and route of flight, which resulted in a collision with terrain in a box canyon after encountering mountain wave.NTSB LAX06LA247Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Flagstaff, AZthe pilot's inadequate preflight planning decision to take off under a low ceiling into an area of mountainous terrain that resulted in an encounter with lowering clouds and forced the pilot to land in unfavorable terrain.NTSB DFW06FA193Accident · 2 fatalField investigationFinal reportMooney M20J · Newellton, LAThe pilot's continued flight into adverse weather conditions. Contributing factors were the prevailing thunderstorms, the dark night conditions, and Air Traffic Control's failure to issue hazardous weather information to the pilot.NTSB ATL06CA112Accident · No injuriesData collectionFinal reportCessna 170B · Griffin, GAAn in-flight encounter with weather on initial take off climb resulting in a loss of directional control and collision with the ground.NTSB LAX06CA248Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAthe pilot's inadequate compensation for the existing wind conditions and failure to maintain an adequate airspeed.NTSB DFW06FA186Accident · 3 fatalField investigationFinal reportBeech BE58P · Jeanerette, LAThe pilot's continued flight into adverse weather condition and his delayed attempt to abort the landing. A contributing factor was the prevailing thunderstorm.NTSB NYC06CA177Accident · No injuriesData collectionFinal reportBeech A36 · Somerville, NJThe pilot's continued flight into known adverse weather.NTSB ANC06CA088Accident · No injuriesData collectionFinal reportCessna 206F · Fairbanks, AKThe pilot's inadequate weather evaluation, which resulted in the airplane encountering a severe downdraft during takeoff initial climb, and an in-flight collision with terrain. Factors associated with the accident were a thunderstorm and a downdraft.NTSB DEN06LA095Accident · Serious injuriesLimited investigationFinal reportAirbus A319-131 · Masonville, COthe flight's encounter with unexpected turbulence, which resulted in a passenger sustaining a fractured ankle.NTSB ANC06FA089Accident · 1 fatalField investigationFinal reportPiper PA-28 · Manley Hot Spng, AKThe pilot's continued cruise flight into known adverse weather conditions, his failure to maintain aircraft control while maneuvering, and his exceeding the design stress limits of the airplane, which resulted in an in-flight break-up. Factors associated with…NTSB DFW06CA161Accident · No injuriesData collectionFinal reportLindstrand Balloons 105A · Frisco, TXThe pilot's failure to maintain the proper glidepath while landing. Contributing factors were the prevailing high winds and the downdraft encountered on final approach.NTSB DEN06CA089Accident · No injuriesData collectionFinal reportCessna TU206G · Alamosa, COthe pilot's failure to maintain aircraft control during the landing. Contributing factors include the gusty winds, the crosswind, and the pilot exceeding the maximum demonstrated crosswind component for the airplane.NTSB DEN06CA088Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Cokeville, WYthe pilot's failure to maintain directional control resulting in a ground loop. Contributing factors included the high winds and crosswind.NTSB DEN06CA087Accident · No injuriesData collectionFinal reportPiper PA-28-150 · Antonito, COthe pilot's failure to attain a safe altitude before attempting to cross mountainous terrain. Contributing factors were the downdrafts and the high density altitude conditions.NTSB DEN06CA086Accident · Serious injuriesData collectionFinal reportRolladen-Schneider LS-3 · Buena Vista, COthe pilot's failure to maintain aircraft control resulting in an inadvertent stall/mush. Contributing to the accident was the downdraft.NTSB SEA06FA115Accident · 2 fatalField investigationFinal reportCessna TU206G · Mullan, IDThe pilot's VFR flight into IMC and his subsequent failure to maintain terrain clearance. The pilot's inadequate inflight planning/decision, mountain obscuration, trees and high terrain were factors.NTSB SEA06LA112Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Townsend, WAThe pilot's misjudgment of the airplane's height above the water during a precautionary landing which resulted in a hard landing. Contributing factors were glassy water conditions, fog, and the pilot's inadvertent VFR flight into IMC.NTSB ANC06LA066Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Juneau, AKThe pilot's failure to maintain adequate altitude/clearance from terrain while maneuvering in adverse weather conditions. Factors associated with the accident are the pilot's decision to continue flight into adverse weather, fog, whiteout and flat light…NTSB NYC06FA133Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Manahawkin, NJThe noninstrument-rated pilot's inadvertent VFR cruise flight into instrument meteorological conditions, and his subsequent loss of aircraft control, which resulted in his exeeding the design stress limits of the airplane, and an in-flight separation of the…NTSB SEA07CA138Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Williams, CAThe loss of thermal lift during cruise flight that resulted in a forced landing.NTSB LAX06FA186Accident · 3 fatalField investigationFinal reportCessna T182T · Burney, CAthe pilot's decision to continue VFR flight into instrument meteorological conditions and his failure to maintain clearance from mountainous terrain.NTSB DFW06CA129Accident · Minor injuriesData collectionFinal reportMahoney Evans VP-1 · Corpus Christi, TXThe pilot's failure to maintain control of the airplane. A contributing factor was the dust devil/whirlwind.NTSB ATL06FA076Accident · 2 fatalField investigationFinal reportPiper PA60-602P · Camp Hill, ALThe pilot's continued flight into known thunderstorms resulting in an in-flight break up. A factor in the accident was air traffic controller's failure to issue extreme weather radar echo intensity information displayed on the controller's radar to the pilot.NTSB MIA06FA098Accident · 2 fatalField investigationFinal reportBeech A24R · Okeechobee, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation and an in-flight break up. Contributing to the accident were the dark night and thunderstorms.NTSB DFW06LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 777-233ER · DFW Int'l Apt, TXThe in-flight encounter with turbulence in clouds resulting in a flight attendant being injured.NTSB LAX06FA148Accident · 2 fatalField investigationFinal reportCessna T337C · Wrightwood, CAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions, which resulted in controlled flight into mountainous terrain.NTSB MIA06CA096Accident · Minor injuriesData collectionFinal reportEurocopter Deutschland EC135T2 · Bonifay, FLThe pilot's failure to maintain main rotor rpm and proper descent rate resulting in a hard landing. A related factor in this accident was inadvertent encounter with clouds.NTSB CHI06MA115Accident · 1 fatalMajor investigationFinal reportCessna 210A · Ludville, GAThe pilot's failure to obtain updated en route weather information, which resulted in his continued instrument flight into a widespread area of severe convective activity, and the air traffic controller's failure to provide adverse weather avoidance…NTSB DEN06FA065Accident · 1 fatalField investigationFinal reportCessna T310R · Heber City, UTthe pilot's loss of aircraft control due to the loss of engine power due to induction icing. Contributing factors include the in-flight encounter with structural icing, the severe turbulence, and the pilot's increased workload.