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 SEA94LA110Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Lander, WYPoor in-flight planning decision. Factors to the accident were: whiteout conditions and inadvertent VFR into IMC.NTSB BFO94FA066Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Salem, OHVFR flight by the pilot into instrument meteorological conditions (IMC), his loss of aircraft control due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: darkness, the adverse weather…NTSB ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…NTSB LAX94FA185Accident · 1 fatalField investigationFinal reportCessna 172N · Julian, CAImproper planning/decision by the pilot(s). Factors related to the accident were: the high/mountainous terrain and adverse weather conditions.NTSB ATL94FA076Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Elizabethton, TNThe pilot's attempted VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the clouds and obscuration at the accident site.NTSB ATL94FA075Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Smithville, TNThe pilot's failure to obtain recent weather information to avoid flight into icing conditions. Factors in the accident were: management-induced pressure and the icing conditions.NTSB LAX94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Currie, NVthe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The snow, mountain obscuration, and icing conditions were factors in this accident.NTSB FTW94LA105Accident · No injuriesLimited investigationFinal reportCessna 150M · Steamboat Sprgs, COThe pilot's selection of too low an altitude in high mountainous terrain.NTSB LAX94LA167Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Stallion Spring, CAThe pilot's continued VFR flight into instrument meteorological conditions. His failure to obtain a weather briefing, the low clouds, and the mountainous terrain were factors in the accident.NTSB ATL94FA062Accident · 1 fatalField investigationFinal reportCessna 152 · Allendale, SCThe pilot's failure to maintain a proper altitude while in the VFR traffic pattern, resulting in a collision with trees. Factors were; his failure to comply with school directives by not obtaining a weather briefing prior to the accident flight, and the rain,…NTSB CHI94LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Harbor Springs, MIThe pilot's improper decision to continue flight into icing conditions after the conditions were first encountered. A factor related to the accident was the trees contacted during the landing roll.NTSB NYC94FA052Accident · 2 fatalField investigationFinal reportCessna 340 · Westhampton, NYThe pilot's inadequate inflight decision which resulted in ice accretion on the aircraft, degradation of aircraft performance, an aerodynamic stall, loss of control and inflight collision with the ground. Factors were icing conditions.NTSB ATL94FA056Accident · 4 fatalField investigationFinal reportCessna P210R · Bay Minette, ALThe pilot's failure to maintain control of the aircraft due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: the pilot's flight into known adverse weather conditions, overconfidence in…NTSB LAX94LA134Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350-B · Humuula, HIThe pilot's poor in-flight decision by failing to attain the best rate of climb speed and exceeding the helicopter's hover performance capability. The clouds and downdraft were factors in this accident.NTSB CHI94GA093Accident · 4 fatalFinal reportCessna 401A · Minot, NDFailure of the pilot to maintain proper altitude during a missed approach. Factors related to the accident were: the unfavorable weather and snow covered terrain.NTSB MIA94LA074Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Culebra, PRThe failure of the pilot-in-command(CFI) to initiate a go-around after encountering severe turbulence during landing flare and his decision to raise the flaps and reduce engine power to idle after directional control was lost resulting in the aircraft…NTSB LAX94LA141Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Pacific Ocean (Pacific Ocean)the failure of the chief steward to verify that all flight attendants had been informed, and were complying with the captain's instructions to remain seated with their seatbelts fastened.NTSB SEA94FA060Accident · 1 fatalField investigationFinal reportMooney M20K · Applegate, ORPoor in-flight planning/decision and icing conditions. Factors to the accident were: selected flight into known adverse weather, dark night, and mountainous terrain.NTSB ATL94IA048Incident · Minor injuriesIncident investigationFinal reportBoeing DHC-8-102 · Charlotte, NCAn inflight encounter with turbulence, and the flight attendant's failure to fasten her seatbelt.NTSB ANC94LA031Accident · No injuriesLimited investigationFinal reportCessna 207 · Kwigillingok, AKThe pilot-in-command's failure to maintain the proper airspeed which resulted in an inadvertent stall and his failure to initiate a go-around when the runway environment was not clearly defined. A factor in the accident was the fog.NTSB MIA94LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Leesburg, FLThe pilot-in-command's poor evaluation of the weather and failure to remain in visual meteorological conditions, resulting in an in-flight collision with water.NTSB MIA94LA061Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 B4-203 · Ormond Beach, FLThe failure of the passenger to follow the visual and oral instructions of the crew to be seated and fasten seat belts.NTSB CHI94FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Waseca, MNContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the ground. Factors related to the accident were: an inaccurate weather forecast by…NTSB FTW94FA059Accident · Serious injuriesField investigationFinal reportCessna 177RG · La Veta, COThe pilot's improper inflight decision to enter a mountain pass at an inadequate altitude, causing the aircraft's climb performance to be exceeded. Factors were turbulence and downdrafts.NTSB FTW94FA057Accident · 3 fatalField investigationFinal reportCessna 177RG · Van Horn, TXThe pilot exceeded the design stress limits of the aircraft after a loss of control which resulted from VFR flight into instrument meteorological conditions. Factors were the weather, the pilot's lack of instrument training and experience, and his failure to…NTSB LAX94LA079Accident · 1 fatalLimited investigationFinal reportAero Commander 100 · Chico, CAIssuance of an improper (special VFR) clearance by the tower controller, while the visibility was less than one mile, continued VFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain control of the…NTSB ATL94LA031Accident · 2 fatalLimited investigationFinal reportCarson Piel Emeraude CP305 · Morrison, TNThe pilot's inadvertent flight into instrument meteorological conditions (IMC), and failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and the pilot's improper…NTSB FTW94FA052Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Franktown, COWas the pilot's disregard of forecast icing conditions and delayed application of carburetor heat, resulting in structural and induction icing. Factors were the icing conditions and unsuitable terrain for a forced landing.NTSB CHI94LA056Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Mcintosh, SDwas continued VFR flight into IMC and the failure to maintain clearance with the terrain. Factors associated with this accident were an inaccurate weather evaluation by the pilot, snow and the rising terrain.NTSB FTW94LA054Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Madisonville, TXThe pilot's continued flight into adverse weather. Factors were weather conditions and collision with a sign.NTSB FTW94LA048Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · El Paso, TXThe pilot's inadvertent flight into clear air turbulence.NTSB SEA94FA038Accident · 1 fatalField investigationFinal reportPiper PA-24 · Ashland, ORVFR 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 weatheer conditions, and the pilot's lack of…NTSB BFO94FA021Accident · 1 fatalField investigationFinal reportPiper PA32R-301 · Butler, PAThe pilot's inadvertent flight into IMC conditions and his failure to maintain proper altitude. The weather conditions were a factor.NTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.NTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…NTSB FTW94IA035Incident · No injuriesIncident investigationFinal reportGrumman G159 · Pineville, LAAn encounter with a wet microburst, on final approach at 200 feet AGL, which exceeded the performance capability of the aircraft.NTSB LAX94LA045Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Florence, AZthe pilot's poor inflight planning and decision making by continuing the flight into adverse weather conditions. Factors contributing to this accident were: not obtaining a preflight weather briefing, not following the airplane flight manuals, and exceeding…NTSB ATL94FA012Accident · 2 fatalField investigationFinal reportMooney M20L · Hohenwald, TNThe pilot's impaired judgement and performance by flying while under the influence of drugs, that resulted in his continuation of VFR flight at night in instrument meteorological conditions (IMC) and his failure to maintain proper altitude (or clearance) from…NTSB LAX94FA028Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Simon, AZThe pilot's improper planning/decision, and his allowing the airplane to exceed its design stress limits, which resulted in overload failure of the right outboard wind section and left horizontal stabilizer. Factors related to the accident were: the adverse…NTSB DCA94GA010Accident · 3 fatalClass 1Final reportBeech 300/F · Front Royal, VAthe failure of the pilot-in-command to ensure that the airplane remained in visual meteorological conditions over mountainous terrain, and the failure of the Federal Aviation Administration executives and managers responsible for the FAA flying program to:…NTSB LAX94LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Murrieta, CAThe unexpected windsheer that was encountered on final approach. The surrounding mountain/hilly terrain was a factor in this accident.NTSB MIA94LA010Accident · Serious injuriesLimited investigationFinal reportBoeing 767-300 · Atlantic Ocean (Atlantic Ocean)Encounter with unforecasted weather (moderate turblence) resulting in injury to three passengers.NTSB NYC94FA014Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 369E · Richfield, OHAn in flight collision with power lines while the pilot was maneuvering the helicopter at a low altitude. A factor in this accident was reduced visibility due to foggy weather conditions.NTSB LAX94LA016Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Sunland, CAthe CFI's poor inflight planning/decision and failure to follow normal procedures. The tailwind was a factor in this accident.NTSB FTW94FA014Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Texarkana, ARThe pilot's continued VFR flight into instrument meteorological conditions. Factors that contributed to the accident were: the pilot's failure to obtain a weather briefing, the existing weather, his lack of instrument flying experience, and the dark night…NTSB ATL94FA006Accident · 2 fatalField investigationFinal reportMooney M20B · Bethpage, TNThe pilot's VFR flight into IMC, and his failure to maintain aircraft control. Factors were the pilot's failure to use a preflight briefing service, and the low ceilings and fog at the accident site.NTSB FTW94FA008Accident · 2 fatalField investigationFinal reportBalloon Works FIREFLY-7 · Albuquerque, NMThe p[ilot's improper decision to attempt continued flight under the existing wind conditions. The adverse wind was a contributing factor.NTSB ATL94LA002Accident · No injuriesLimited investigationFinal reportHughes 269B · Linville, NCThe pilot's failure to maintain airspeed that would have avoided a loss of tail rotor effectiveness (lte), and his improper compensation for tailwind condition. A factor was the lack of information in the pilot's operating handbook regarding the conditions…NTSB MIA93FA198Accident · 3 fatalField investigationFinal reportSocata TB 10 · Aguadilla, PRIn flight encounter with a level ii thunderstorm and flight into known advese weather by the pilot in command. Contributing to the accident was failure of the pilot in command to obtain a preflight weather briefing.NTSB ATL93LA159Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAWas the pilot's inaccurate evaluation of weather conditions which resulted in the flight entering an area of turbulence.