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 NYC92LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Gansevoort, NYThe pilot's improperly planned approach, resulting in a landing on an icy runway at excessive speed; and unable to stop on the available runway and subsequent collision with trees. Factors related to the accident were the pilot's failure to obtain a weather…NTSB DCA92MA011Accident · 9 fatalMajor investigationFinal reportBeech 400 · Rome, GAThe captain's decision to initiate visual flight into an area of known mountainous terrain and low ceilings and the failure of the flightcrew to maintain awareness of their proximity to the terrain.NTSB CHI92LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rochester, MNImproper use of autopilot during approach which resulted in proper alignment not maintained by the pilot. Factors related to the accident were turbulence and crosswinds, over confidence in aircraft's capability and overconfidence in personal ability.NTSB FTW92LA032Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Hamilton, TXThe inadvertend encounter with icing conditions. Factors were the unavailability of an airport weather observation facility and the deteriorated aircraft performance.NTSB CHI92LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Carthage, MOContinued flight by the pilot into known icing conditions, and his improper planning/decision, which resulted in an overrun of the runway after he diverted to an alternate airport. The adverse weather condition, icy runway, and chain link fence near the end…NTSB FTW92LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Morse, TXThe pilot's attempted VFR flight into IMC conditions. Factors were, the pilot's lack of instrument qualification, his failure to obtain a weather briefing prior to the flight, and dark night conditions.NTSB CHI92FA035Accident · 4 fatalField investigationFinal reportCessna 172RG · Litchfield, MNPilot factor in that he had spatial disorientation. Factors related to the accident are; VFR flight into IMC, disregarding hazardous weather advisories, performing flight into known adverse weather conditions, and overconfidence in personal ability by the…NTSB CHI92LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Marquette, MIFlight into known adverse weather conditions by the pilot, which resulted in airframe (wing) icing and the inability to maintain altitude. The adverse weather conditions and darkness were related factors.NTSB LAX92FA047Accident · 3 fatalField investigationFinal reportBell 206BIII · Davis, CAThe decision of the pilot to continue night low level flight in forecasted adverse weather conditions. Contributing to the accident was the foggy weather and dark night conditions which restricted the pilot's visual outlook.NTSB BFO92LA007Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Spanishburg, WVThe pilot's intentional flight into instrument meteorological conditions. Contributing to the accident was the low ceiling in conjunction with the mountainous terrain and the pilot's over confidence.NTSB FTW92LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Springer, NMThe pilot's poor judgement in attempting flight into forcasted adverse weather, his disregard for the hazardous weather advisory received which resulted in partial loss of engine power as a result of a blocked induction system due to ice and snow, and the…NTSB MIA92LA019Accident · No injuriesLimited investigationFinal reportBeech C-45H · Fort Lauderdale, FLHard landing due to failure of the pilot-in-command to maintain the proper descent rate. Contributing to the accident was the turbulence encountered during the apch.NTSB DEN92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Ellicott, COA power loss for undetermined reasons, the pilot's poorly planned approach, and excessive airspeed. Factors were: the pilot's intentional flight into IMC, accumulation of wing ice and his becoming lost disoriented.NTSB CHI92LA019Accident · No injuriesLimited investigationFinal reportCessna 182U · Rolla, MOThe pilot in command's failure to attain a proper flare on landing. A factor contributing to the accident was the pilot in command's inadvertent encounter with instrument meteorological conditions.NTSB LAX92LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Willits, CAThe pilot's poor in-flight decision to continue his flight in deteriorating weather, and his misjudged weather evaluation.NTSB ATL92LA009Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Whitesburg, GAA sudden wind shift during initial climb which resulted in an uncontrolled descent.NTSB ATL92FA008Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Spring Lake, NCThe inadvertent flight from visual flight rules flight conditions into instrument flight rules flight conditions by the non-instrument rated pilot, and his subsequent failure to maintain control of the aircraft.NTSB CHI92FA009Accident · 2 fatalField investigationFinal reportBeech A36 · Lakeville, MNThe pilot-in-command's decision to continue flight into known adverse weather. Contributing to the accident was the encounter with weather conditions favorable for formation of airframe icing.NTSB DEN92LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COThe pilot flying the aircraft at a height above ground level which was inadequate for recovery from an encounter with down drafts. A factor was: down draft encounter.NTSB MIA92FA004Accident · 1 fatalField investigationFinal reportAero Commander 100 · Carrabelle, FLThe non instrument-rated pilot-in-command's decision to continue flight into known instrument meteorological conditions (thunderstorm) and failure to maintain airspeed (vso) while maneuvering. Contributing to the accident was the pilot-in-command's failure to…NTSB FTW92LA004Accident · No injuriesLimited investigationFinal reportCessna 210C · Leander, TXThe pilot's disregard for the hazardous weather advisories received. A factor was the weather.NTSB FTW92LA001Accident · Serious injuriesLimited investigationFinal reportBoeing 727-243 · Little Rock, ARThe pilot's failure to specifically warn the flight attendants of the hazardous conditions warnings. A factor was the turbulence.NTSB MIA92LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Brooksville, FLThe pilot's inadvertent flight into IMC conditions, and his selection of unsuitable terrain for his attempted precautionary landing.NTSB SEA91FA258Accident · 2 fatalField investigationFinal reportCessna 182Q · Lincoln, MTThe improper inflight planning/decision by the pilot to continue VFR flight into IMC conditions. Factors relating to the accident were the mountainous terrain in the area, and the low ceilings and clouds obscuring the mountains.NTSB LAX91LA406Accident · Serious injuriesLimited investigationFinal reportCallair A-3 · Williams, AZThe pilot's encounter with a strong and gusty cross-wind which suddenly developed in the area and his subsequent loss of control. Factors which contributed to the accident were the pilot's inadequate airspeed and inability to adequately compensate for the…NTSB ANC91LA151Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Koliganek, AKThe pilot's failure to maintain airspeed. Contributing to the accident was the unfavorable wind conditions.NTSB DEN91FA130Accident · 3 fatalField investigationFinal reportCessna 182G · Elida, NMThe pilot's improper preflight planning/preparation for the flight and his subsequent flight into instrument meteorological conditions. A factor was: heavy fog and low ceiling.NTSB ANC91LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Telida, AKThe pilot getting disoriented during flight due to his inattentiveness, the airplane's low fuel level, the fss specialist's giving the pilot an incorrect heading to fly, poor radio communications between the fss and the pilot, the strong crosswind, and the…NTSB SEA91FA235Accident · 1 fatalField investigationFinal reportPiper PA32RT-300T · Mayfield, UTPoor in flight planning/decision. Factors to the accident were: flight into known adverse weather, inadvertent VFR flight into IMC and inadequate clearance.NTSB DEN91LA124Accident · No injuriesLimited investigationFinal reportBoeing A 75N1 · Lordsburg, NMUnexpected encounter with adverse wind (downdraft).NTSB CHI91LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Emporia, KSThe pilot's VFR flight into instrument meteorological conditions (IMC), and his delay in taking remedial action. The weather (fog) was a related factor.NTSB SEA91LA226Accident · No injuriesLimited investigationFinal reportRyan Navion · Chelan, WAPoor in flight planning/decision by the pilot in command. Factors to the accident were: down drafts, proper alignment was not maintained and inadequate remedial action.NTSB SEA91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Corbett, ORThe pilot's improper in-flight planning/decision, his delay in taking remedial action, and his failure to maintain clearance from trees on rising terrain. The weather and terrain conditions were related factors.NTSB MIA91IA207Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300-600R · Atlantic Ocean (Atlantic Ocean)The in flight encounter with turbulence, and the failure of the passengers to comply with instructions to return to their seats and utilize their seatbelts.NTSB MIA91LA206Accident · Serious injuriesLimited investigationFinal reportFriling Amtr · Land O' Lakes, FLThe poor in flight decision of the pilot to fly near thunderstorms and their associated turbulence resulting in an uncontrolled descent and in flight collision with terrain.NTSB SEA91FA207Accident · 6 fatalField investigationFinal reportPiper PA-32 · Gustavus, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors related to the accident were: the adverse weather and terrain conditions.NTSB ATL91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waxhaw, NCThe spatial disorientation experienced by the pilot in IMC, his failure to maintain aircraft control, and the exceeding of the design stress limits of the aircraft. Factor(s) in this accident were: the pilot's inadequate preflight planning, the VFR flight…NTSB LAX91FA342Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Reno, NVFailure of the pilot to maintain proper airspeed by employing an excessive angle of attack during the takeoff climb during a go-around resulting in an aerodynamic stall and subsequent inflight loss of control. Contributing to the accident was the pilot's poor…NTSB NYC91FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Fogelsville, PAThe improper decision by the non-instrument rated pilot to attempt VFR flight in instrument meteorological conditions, which resulted in a loss of airplane control. Factors related to the accident were: the pilot's overconfidence in his ability, his lack of…NTSB SEA91LA194Accident · No injuriesLimited investigationFinal reportLet L-13 · Wallsburg, UTThe in flight encounter with downdraft winds and the lack of suitable terrain in the area for a landing.NTSB CHI91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Sheboygan, WIThe pilot's failure to maintain aircraft control. Factors are the pilot's lack of total expereince, his inadequate recovery from the bounced landing and the crosswind condition.NTSB FTW91DPJ03Accident · 2 fatalFinal reportGrimm Cavalier SA102.5 · Mcalester, OKThe pilot's attempted flight into IMC and his subsequent loss of control due to spatial disorientation.NTSB DEN91LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Fountain, COThe pilot's selection of unsuitable terrain on which to make a landing. Factors were: the pilot's inadequate preflight planning, and weather conditions that included low ceiling, obscuration, fog, and drizzle.NTSB DEN91FA113Accident · 1 fatalField investigationFinal reportCessna 182P · Redstone, COAn inflight collision with terrain after the pilot continued the flight into an area of clouds and rain.NTSB CHI91DCQ07Accident · No injuriesFinal reportGrumman G-164A · Sharon Springs, KSAircraft takeoff performance exceeded and disregard of performance data by the pilot. A factor associated with the accident is high density altitude.NTSB MIA91LA186Accident · Minor injuriesLimited investigationFinal reportLucky GN-1 Aircamper · Cross City, FLInadequate preflight briefing and inadvertent stall mush during normal cruise flight after encountering turbulence near the destination.NTSB ANC91LA093Accident · Minor injuriesLimited investigationFinal reportHelio H-295 · Port Alsworth, AKFailure of the pilot to maintain sufficient altitude and clearance from mountainous terrain. Factors related to the accident were: the rising terrain and a downdraft.NTSB NYC91FA174Accident · 3 fatalField investigationFinal reportGulfstream American AA5B · Columbia, CTThe decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…NTSB ANC91LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Merrill Pass, AKThat the pilot failed to maintain an airspeed above stall speed. Contributing to the accident was the turbulence.NTSB LAX91LA289Accident · No injuriesLimited investigationFinal reportHughes 369D · Napa, CAThe pilot's failure to maintain the proper altitude. Contributing to the accident was the pilot's improper in flight decision to fly in the below VFR weather conditions and his misjudged weather evaluation.