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 LAX89FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Dinsmore, CAThe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain adequate terrain clearance. Contributing factors to the accident were: the pilot's failure to obtain weather information, his overconfidence in his…NTSB MIA89LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Okeechobee, FLThe pilot's poor preflight preparation when he failed to recheck weather conditions after he delayed takeoff because of thunderstroms. Also, the pilot's poor inflight decision to land off-airport rather than return to the departure airport.NTSB LAX89LA202Accident · 1 fatalLimited investigationFinal reportAyres S2R · Atlantic Ocean (Atlantic Ocean)The pilot's continued flight from VMC to IMC, with icing conditions, from which recovery was not successful.NTSB ATL89FA149Accident · 1 fatalField investigationFinal reportBeech S35 · Russellville, KYImproper planning/decision by the pilot, his continued flight into an area of known adverse weather, and his failure to maintain control of the aircraft. Contibuting factors were: the dark night, the adverse weather conditions, and the pilot's overconfidence…NTSB MKC89FA110Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Winslow, ARThe pilot flying into adverse weather conditions which resulted in the in-flight separation of a portion of the right wing. Contributing to the accident was the pilot's lack of total experience.NTSB SEA89LA085Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Ely, NVThe pilot's improper decision to continue flight into IMC. Contributing to the accident were snow, obscuration and mountainous terrain.NTSB LAX89LA191Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300-B4-203 · San Diego, CAAn unexpected encounter with clear air turbulence which seriously injured a passenger in the aft lavatory.NTSB LAX89FA192Accident · 1 fatalField investigationFinal reportBeech 200 · Azusa, CAImproper in-flight planning/decision by the pilot, which resulted in has inadvertent flight into instrument meteorological conditions (IMC) and subsequent collision with mountainous terrain. The weather and terrain conditions were considered to be related…NTSB LAX89FA189Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Dublin, CAThe pilot decided to continue VFR flight after encountering instrument meteorological conditions in an area of rising mountainous terrain. Factors in this accident were the pilots lack of experience and his failure to obtain a preflight weather briefing.NTSB LAX89FA182Accident · 3 fatalField investigationFinal reportCessna 172 · Industry, CAThe failure of the pilot to maintain an adequate altitude to ensure obstruction clearance. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's continued flight into adverse weather conditions.NTSB LAX89FA181Accident · 2 fatalField investigationFinal reportCessna 152 · Port San Luis, CAPilot failed to execute a 180 degree turn and inadvertently entered into instrument meteorological conditions.NTSB DEN89LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Durango, COInadequate inflight planning and inadequate compensation for wind conditions. Contributing to the accident were crosswind and turbulence encountered close to the ground and high density altitude conditions.NTSB MKC89LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wentzville, MOThe pilot's delay in aborting the landing, and his failure to maintain clearance from the power lines. Factors related to the accident were: the pilot's selection of the wrong runway, the adverse weather conditions, the pilot's failure to attain the proper…NTSB MKC89FA102Accident · 2 fatalField investigationFinal reportCessna 150H · Carnegie, OKContinued VFR flight by the pilot into instrument meteorological conditions, which resulted in subsequent collision with rising/hilly terrain. Related factors were: inadequate preflight planning/preparation by the pilot, dark night, adverse weather…NTSB FTW89FA090Accident · 2 fatalField investigationFinal reportCessna 172P · Burnet, TXContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions and the pilot's lack of…NTSB ATL89FA139Accident · 5 fatalField investigationFinal reportBeech B24R · Suches, GAThe pilot's flight into known adverse weather, and his failure to maintain clearance above the wooded terrain. The adverse weather condition, high terrain, and trees were related factors.NTSB MKC89FA099Accident · 3 fatalField investigationFinal reportMaule M-5 · Ainsworth, NEThe pilot continued flight into IFR conditions and the loss of aicraft control due to spatial disorientation. Contributing to the accident were the cloud conditions and fog.NTSB CHI89FA078Accident · Minor injuriesField investigationFinal reportCessna 208A · Mt. Zion, ILThe pilot's intentional flight into known adverse weather. Contributing factors were the pilot's poor evaluation of the weather information given him by the air traffic controllers.NTSB ANC89LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's continued VFR flight into instrument meteorological conditions and the inadvertant stall/mush of the airplane. Contributing factors are the pilot's overconfidence, self-induced pressure, mountainous terrain and whiteout conditions.NTSB SEA89FA074Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 · Pelican, AKImproper in-flight decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). The terrain and weather conditions were considered to be factors.NTSB FTW89FA151Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Junction, TXContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, which resulted in his failure to maintain control of the aircraft due to spatial disorientation. The weather conditions and his self-induced pressure were factors.NTSB DEN89LA109Accident · No injuriesLimited investigationFinal reportCessna 310E · Glenwood Spgs, COInadequate compensation for the wind conditions by the pilot, resulting in a loss of control of final approach. Contributing to the accident was the downdraft.NTSB SEA89LA070Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4 · Yamhill, ORPilot displayed poor inflight planning and preparation for the flight. The pilot did not adequately compensate for the wind conditions resulting in an intentional gear up landing.NTSB ATL89FA131Accident · 2 fatalField investigationFinal reportMooney M20F · Lynch, KYContinued VFR flight by the pilot into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions, terrain, and the pilot's lack of instrument experience.NTSB ATL89LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Xenia, OHThe pilot's improper in-flight planning/decision and improper use of the flaps. Contributing was the downdraft.NTSB LAX89FA157Accident · Serious injuriesField investigationFinal reportCessna 152 · Chino, CAThe pilot's failure to obtain an appropriate weather briefing in preparation for the cross country flight and his failure to maintain an altitude sufficient to clear the terrain along the indended route after entering reduced visibility conditions.NTSB SEA89FA186Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Enumclaw, WAAttempted flight into known adverse weather conditions. Factors include clouds, downdrafts, high winds.NTSB BFO89FA029Accident · 4 fatalField investigationFinal reportBeech C35 · Rupert, WVPilot inadvertantly flew into IMC while trying to maintain VFR and collided with trees during a steep turn during his attempt to turn away from IMC. The weather conditions that were determined to be factors in this accident were: low ceilings, obscuration,…NTSB DEN89FA149Accident · 1 fatalField investigationFinal reportCessna 182P · Steamboat Sprg., COThe plt's failure to discontinue the VFR flight when he encountered IMC; and the plt's failure to maintain adequate altitude to clear the mountainous terrain.NTSB DEN89FA101Accident · No injuriesField investigationFinal reportBell 206B-III · Park City, UTAn encounter with strong down-slope winds and gusts during a critiacal phase of flight which caused power required to exceed power available. Contributing factors to the accident was the downhill terrain and the downdraft conditions.NTSB ANC89GA055Accident · Minor injuriesFinal reportPiper PA-18 · Kotzebue, AKThe pilot continued flight into IFR conditions and failed to maintain the altitude. Contributing to the accident was the pilot's failure to obtain a weather briefing and the deteriorating weather conditions which were encountered.NTSB LAX89FA137Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Whitmore, CAThe pilot's decision to continue VFR flight with known forecast IMC along his route.NTSB FTW89FA073Accident · 4 fatalField investigationFinal reportCessna 172XP · Hondo, TXThe pilot's decision to depart into known adverse weather and his lack of instrument training and experience.NTSB NYC89IA107Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Albany, NYThe crew's failure to use full engine anti-ice systems which resulted in ice blocking the engine inlets.NTSB DEN89FA091Accident · 1 fatalField investigationFinal reportCessna 210D · Eugene, ORThe pilot's decision to continue VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: the terrain and weather conditions at the accident site, and the pilot's lack of instrument experience.NTSB ATL89FA113Accident · 1 fatalField investigationFinal reportBeech F33A · Ashland, ALThe pilot continued VFR flight into instrument meteorological conditions (IMC). Factors related to the accident were: high terrain, the adverse weather conditions, and trees.NTSB MIA89FA109Accident · 2 fatalField investigationFinal reportCessna 172M · Pascagoula, MSContinued flight by the pilot into instrument meteorological conditions (IMC). Contributing factors were: inadequate preflight planning, weather conditions, pilot's lack of instrument flight time, lack of visual cues at night, and trees at the crash site.NTSB MIA89FA108Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Holley, FLContinued flight by the plt into adverse wx, followed by spatial disorientation and loss of aircraft control. Lack of a preflight weather briefing, weather conditions, and lack of visual cues at night were considered contributing factors.NTSB NYC89FA099Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Southbridge, MAPoor judgement of the pilot by flying while physically impaired by alcohol, and his continued VFR flight into instrument meteorological conditions (IMC). Related factors were: the pilot's inadequate preflight planning/preparation, dark night, adverse weather…NTSB LAX89DVD03Accident · 2 fatalFinal reportStearns BD-4 · Leggett, CAThe pilot's continuation of VFR flight into instrument meteorological conditions (IMC), and his failure maintain proper altitude. Factors related to the accident were the adverse weather conditions, high terrain, and trees.NTSB SEA89LA054Accident · No injuriesLimited investigationFinal reportCessna 185 · Bellingham, WAThe pilot's failure to compensate for the loss of lift due to ice accumulation on the wings, his failure to control the rate of descent, and poor inflight decision making. Contributing to the accident was the pilot's fatigue.NTSB NYC89FA095Accident · 1 fatalField investigationFinal reportPiper PA-28 · Douglas Twsp, PAPoor judgement of the student pilot by flying while under the influence of alcohol, and his VFR flight in instrument meteorological conditions (IMC) without the required qualification or training. Factors factors related to the accident were: failure of the…NTSB ATL89FA095Accident · 1 fatalField investigationFinal reportBeech 95-B55 · St Marys Island, GAThe pilot continued into IMC conditions where he collided with trees.NTSB FTW89LA061Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Robstown, TXThe pilot delayed flight to an alternate destination, continued flight into instrument meteorological conditions (IMC), experienced spatial disorientation, and lost control of the aircraft. Contributing factors were: the pilot's inadequate preflight…NTSB BFO89FA019Accident · 1 fatalField investigationFinal reportBeech V35TC · Roanoke, VAThe pilot failed to maintain control of the aircraft due to spatial disorientation.NTSB NYC89FA097Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Lake Placid, NYThe pilot's departure into known adverse weather conditions and his continued VFR flight into instrument meteorological conditions. Contributing factor(s) was: the adverse weather conditions.NTSB NYC89FA088Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Washington, PAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) which resulted in his loss of aircraft control. Factors related to the accident was: the pilot's flight into known weather, the adverse weather, and trees at the accident sight.NTSB ATL89FA090Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Tipp City, OHImproper planning by the pilot resulting in fuel exhaustion. The pilots lack of equipment and ability to handle the weather situation was ignored by the pilot in his planning for the flight.NTSB MIA89FA090Accident · 2 fatalField investigationFinal reportCessna 172 · Blue Mountain, MSThe continuation of a VFR flight into night, instrument meteorological conditions and the spatial disorientation of the non-instrument rated pilot. Contributing to the accident were the adverse weather conditions and the overconfidence of the pilot.NTSB LAX89LA131Accident · Serious injuriesLimited investigationFinal reportAerostar Raven 560 · Tucson, AZBalloon entered into a severe down draft which resulted in a hard landing due to inadequate preparation and compensation for the conditions by the balloon pilot.