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 BFO91LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · New Market, VAThe pilot's inadequate inflight decision that resulted in VFR flight into IMC.NTSB ATL91LA123Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Alma, GATurbulence in clouds, which was associated with a dissipating thunderstorm.NTSB ANC91LA089Accident · No injuriesLimited investigationFinal reportCessna 170B · Prospect Creek, AKContinued VFR flight into instrument meteorological conditions (IMC) by the pilot, and his delay in reversing course (remedial action). The terrain and weather conditions were related factors.NTSB NYC91LA164Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300-605R · Newark, NJThe inadvertent encounter with in-flight turbulence, resulting in serious injuries to a crewmember and a passenger.NTSB FTW91LA114Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus CM · Marfa, TXThe pilot misjudged the approach. Factors were the high density altitude, the downdraft, and the dteriorted climb performance.NTSB BFO91FA061Accident · 1 fatalField investigationFinal reportMooney M20J · Waynesboro, VAThe pilots failure to maintain aircraft control which resulted in overstress of the airplane. Contributing was VFR flight into IMC and thunderstorms.NTSB MIA91LA174Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Brooker, FLFailure of the noncertificated pilot to obtain a weather briefing before departure & failure to maintain directional control after the precautionary landing. Contributing to the accident was lack of suitable terrain.NTSB LAX91FA280Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-36A · Goleta, CAThe pilot's failure to maintain directional control of the airplane after becoming spatially disoriented. Factors related to the accident were: darkness, low overcast cloud condition, the pilot's decision to continue VFR flight into instrument meteorological…NTSB DEN91LA091Accident · Minor injuriesLimited investigationFinal reportBoeing E75N1 · Vail, COA severe downdraft. A factor was: the pilot's failure to obtain a weather briefing.NTSB ATL91FA124Accident · 2 fatalField investigationFinal reportPiper PA-28 · Mt. Berry, GAThe pilot's inadequate preflight planning, his poor inflight decision to continue into deteriorating weather conditions, and his inadvertent flight into IMC. Factors in this accident were: the clouds obscuring the mountain at the time of the accident, and the…NTSB FTW91LA119Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-6 · Boerne, TXThe pilot's failure to release at a higher altitude prior to looking for thermal activity and the pilot's poor in-flight planning. Factors were the downdraft and the tall grass encountered during landing.NTSB SEA91LA134Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Rock Springs, WYThe pilot's inadequate preflight planning and decision to attempt flights in unfavorable environmental codnitions. The environmental conditions were factors in the accident.NTSB BFO91LA055Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Philadelphia, PAFailure of the pilot to ensure cabin crew members were prepared for an encounter with turbulence.NTSB CHI91LA189Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Wausa, NEThe pilot's delayed decision to turn around after encountering IFR flight conditions. Factors were restricted forward visibility and power lines.NTSB LAX91FA247Accident · 1 fatalField investigationFinal reportCessna C-172 · Lakeside, CAThe failure of the pilot to request radar assistance to avoid low ceilings in high terrain and the pilot's inadequate visual outlook which ultimately resulted in an inflight collision with high terrain. Contributing to the accident were the weather conditions…NTSB LAX91LA245Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Williams, AZThat the flight encountered windshear and that aircraft control was not possible.NTSB CHI91DTG01Accident · 1 fatalFinal reportCessna 172P · Bismarck, NDSpatial disorientation. Factors related to the accident are failure to obtain a preflight weather brief, vrf flight into IMC conditions and lack of total experience.NTSB NYC91FA145Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Wallingford, CTThe pilot attempting a VFR flight in adverse weather conditions, at an altitude that was insufficient to clear trees along his route of flight. Factors related to the accident were the pilot's lack of instrument rating, and his overconfidence to fly in…NTSB CHI91IA175Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-32 · Kansas City, MOInadequate design by the manufacturers. Factors associated with the incident are inadequate certification/approval by the federal aviation administration and clear air turbulence.NTSB SEA91FA119Accident · 2 fatalField investigationFinal reportStinson 108-2 · Gold Bar, WAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to remain clear of the obstacles (trees). The adverse weather condition (fog) was a related factor.NTSB NYC91DGT04Accident · No injuriesFinal reportGeorge E Heide, JR. Moni Motorglider · Annville, PAThe pilot's intentional landing on unsuitable terrain due to a loss of altitude precipitated by a downdraft.NTSB LAX91LA220Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Gasquet, CAThe pilot's decision to attempt VFR flight in a narrow mountain valley in conditions of low ceilings and mountain obscurement.NTSB DEN91LA069Accident · 1 fatalLimited investigationFinal reportChallenger II · Silt, COAn in flight encounter with wind conditions which exceeded the aircraft performance capability. A factor was: the pilot's failure to obtain available en route weather information.NTSB LAX91LA202Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ojai, CAThe pilot's inadequate compensation for the wind condition. A factor related to the accident was the downdraft weather condition.NTSB LAX91LA192Accident · No injuriesLimited investigationFinal reportCessna 180 · Truckee, CAThat the pilot improperly used the flight controls and brakes to arrest the runway excursion. Contributing to this accident was encountering unfavorable winds, crosswind conditions, and lack of experience in this type of airplane.NTSB ATL91LA091Accident · Serious injuriesLimited investigationFinal reportBoeing B767-287ER · Memphis, TNThe delayed inflight decision by the pilot to maneuver the aircraft away from thunderstorm activity.NTSB LAX91FA190Accident · 4 fatalField investigationFinal reportMooney M20F · Quincy, CAThe pilot's inadvertent flight into IMC and thereafter his failure to maintain directional control of his airplane. Factors which contributed to the accident related to the pilot's improper weather evaluation which resulted in his delayed emergency procedure,…NTSB FTW91LA075Accident · No injuriesLimited investigationFinal reportCessna 337D · Alpine, TXThe pilot's failure to maintain directional control of the airplane. A factor was the pilot's continued takeoff in unfavorable wind.NTSB CHI91LA145Accident · No injuriesLimited investigationFinal reportAeronca 7EC · O'Neill, NEThe pilot's selection of unsuitable terrain for a precautionary landing. Factors were the pilot's disregarding the weather briefing and his intentional flight into adverse weather.NTSB LAX91FA181Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Carpenteria, CA1) Inadequate weather evaluation by the pilot, 2) poor inflight decision to try and continue VMC flight, and 3) the pilot's lack of total experience.NTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…NTSB SEA91LA260Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Grangeville, IDThe improper decision by the pilot to continue VFR flight in IMC weather conditions in mountainous terrain, resulting in pilot disorientation and inadvertent flight into a box canyon. Factors relating to the accident were the rain showers and low ceiling…NTSB LAX91LA177Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · Gualala, CAThat the pilot failed to properly use the flight controls and to maintain directional control. Contributing to this accident were the gusty crosswind conditions that existed at the time of the accident.NTSB NYC91FA115Accident · 2 fatalField investigationFinal reportCessna 172G · New Bedford, MAThe pilot's improper planning/decision and failure to maintain proper altitude after encountering adverse weather at low altitude. The adverse weather (fog) was a related factor.NTSB CHI91FA126Accident · 2 fatalField investigationFinal reportBeech F.33A · Chippewa Falls, WIThe first pilot's continued flight in known adverse weather. Factors in the accident were the first pilot's poor weather evaluation, the second pilot's complacency and the first pilot's self induced pressure to complete a checkout in model.NTSB LAX91LA163Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Lake Cobb, CAThat the pilot's visual lookout was improper. Contributing to this accident was the unmarked transmission wire.NTSB CHI91DCG01Accident · 1 fatalFinal reportAkins Stinger · Blairstown, MOAn inflight breakup after the pilot encountered weather, lost control inflight, & exceeded the design limits of the airplane. A factor was the pilot's decision to fly into known adverse weather.NTSB NYC91FA099Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Naples, NYFlight by the pilot into known icing conditions, which resulted in structural (wing) ice and subsequent loss of aircraft control. The weather condition was a related factor.NTSB LAX91LA155Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26-D · Warner Springs, CAThat the pilot used poor planning/decision and failed to maintain flying speed. Contributing to his accident was the loss of thermal lift and lack of experience in this type of aircraft.NTSB ATL91FA073Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Franklin, TNThe pilot's failure to select a proper fuel tank for flight, resulting in fuel starvation to the engine, and subsequent engine stoppage. Factors were the pilot's inadequate evaluation of the weather conditions along his route of flight, and his flight into…NTSB MIA91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · New Port Richey, FLIn-flight encounter with wind gusts while flaring to land and failure of the pilot to maintain directional control and failure to perform a goaround.NTSB DEN91FA056Accident · 5 fatalField investigationFinal reportCessna 421C · Cortez, COThe pilot's improper IFR procedures. Factors were: the existing weather conditions and the pilot's failure to obtain a preflight briefing.NTSB ANC91FA042Accident · 4 fatalField investigationFinal reportCessna 206 · Homer, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude, while maneuvering over water. Factors related to the accident were: the snow shower and probable whiteout conditions.NTSB ANC91LA038Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Saint Marys, AKThe pilot-in-command's failure to maintain VFR flight in instrument meteorological conditions while maneuvering on a VFR flight plan. Factors related to the accident was the pic's failure to evaluate the weather conditions that existed.NTSB MIA91FA107Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Chassahowitzka, FLThe pilot in commands continued VFR flight into IFR conditions resulting in an inflight loss of control and an inflight collision with the ground.NTSB ATL91FA069Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Ashland, ALContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficience altitude/clearance above the wooded terrain. Factors related to the accident were: the adverse weather conditions, high terrain, and the…NTSB LAX91FA138Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Vacaville, CAThe pilot's continued VFR flight at night under low clouds, and his failure to maintain sufficient altitude over rising terrain. Factors related to the accident were: darkness, the adverse weather and terrain conditions, and the controller's inaccurate…NTSB BFO91FA031Accident · Serious injuriesField investigationFinal reportCessna 182F · Princeton, WVThe pilot's inadequate inflight decision which resulted in airframe icing.NTSB LAX91FA133Accident · 3 fatalField investigationFinal reportCessna 320D · Gorman, CAVFR flight into instrument meteorological conditions (IMC) by the pilot, and his failure to maintain sufficient altitude/clearance from mountainous terrain. Factors related to the accident were: the terrain and weather conditions.NTSB ANC91LA034Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Atigan Pass, AKThe pilot continued to fly VFR into IFR conditions. Related to the accident were: low ceilings, whiteout conditions, and the mountainous terrain.