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 ANC98FA006Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Juneau, AKThe pilot's intentional flight into adverse weather. Related factors were the low ceilings, mountainous terrain, and self induced pressure by the pilot to complete the flight and return for the evening.NTSB SEA98FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Leadore, IDthe pilot's inadvertent entry into instrument meteorological conditions, and his failure to maintain clearance from wooded terrain in the area where he was maneuvering. Factors relating to the accident include: darkness, low ceiling, and high/mountainous…NTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.NTSB LAX98FA006Accident · 1 fatalField investigationFinal reportCessna 152 · Julian, CAThe pilot's inadequate in-flight planning which resulted in VFR flight into instrument meteorological conditions and the loss of aircraft control. Contributing was the pilot's overconfidence in his ability, clouds, and rain.NTSB CHI98LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Williston, NDthe pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.NTSB DCA98MA002Accident · 9 fatalMajor investigationFinal reportCessna 208B · Montrose, COthe pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…NTSB MIA98LA002Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Cross City, FLThe in-flight encounter with turbulence associated with a nearby level 6 thunderstorm with moderate rain while deviating.NTSB NYC97LA187Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 · Long Island, NYAn in-flight encounter with clear air turbulence and the passenger's failure to comply with the fasten seatbelt sign.NTSB LAX97FA331Accident · 1 fatalField investigationFinal reportCessna 172K · Sandy Valley, NVthe pilot's intentional VFR flight into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from mountainous/hilly terrain. Related factors were: the high/mountainous/hilly terrain, and the adverse weather condition (low…NTSB FTW97LA358Accident · No injuriesLimited investigationFinal reportMooney M20C · Pettigrew, ARThe pilot's improper in-flight decision. Factors were the prevailing low ceilings, the inaccurate flight and navigation instruments as result of the failure of the engine accessories vacuum pump and the lack of suitable terrain for the pilot to execute the…NTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.NTSB MIA97FA249Accident · 2 fatalField investigationFinal reportCessna 177RG · Sebring, FLcontinued flight by the pilot into adverse weather conditions, and his failure to maintain aircraft control, which resulted in an uncontrolled descent until impact in a lake. The adverse weather condition (thunderstorm) was a related factor.NTSB CHI97LA292Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Grand Forks, NDThe flight attendant's seat belt was not secured. A factor was turbulence in the clouds.NTSB ANC97LA160Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gulkana, AKThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control after touchdown. A factor associated with the accident was the gusty wind conditions.NTSB CHI97FA283Accident · 1 fatalField investigationFinal reportCessna 177B · Crump, MIContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…NTSB ANC97LA134Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's inadequate evaluation of the weather conditions. Factors in the accident were a downdraft, crosswind conditions, and rough/uneven terrain.NTSB ANC97GA126Accident · 1 fatalFinal reportBell BH-206B · Dillingham, AKThe pilot's intentional VFR flight into instrument meteorological conditions (IMC). Factors associated with the accident are the pilot's failure to activate the cabin heating system, the lack of an operable windshield defogger, the pilot's overconfidence in…NTSB FTW97LA310Accident · No injuriesLimited investigationFinal reportWaco KNF · Wamsutter, WYThe pilot's failure to maintain directional control during the precautionary landing. A factor was a wind gust.NTSB ANC97FA121Accident · 3 fatalField investigationFinal reportCessna U206G · Halibut Cove, AKThe pilot's improper evaluation of the weather conditions which led the pilot to maneuver within the confines of the lake to avoid surrounding terrain and a subsequent inadvertent stall. Factors were the terrain-induced turbulence and gusts.NTSB ANC97LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Farewell, AKthe pilot's failure to maintain adequate control of the airplane resulting in an inadvertent stall/mush at low altitude. Factors to the accident were the pilot's low altitude flight maneuver and the gusty winds.NTSB FTW97FA295Accident · 2 fatalField investigationFinal reportLancair 320 · Dillon, COthe pilot's inadequate preflight planning/preparation, VFR flight into instrument meteorological conditions (IMC) conditions, and failure to maintain sufficient altitude/clearance from terrain. Factors relating to the accident were: low ceiling, rain, and…NTSB FTW97FA292Accident · 2 fatalField investigationFinal reportBeech F35 · Richards, MOThe pilot's continued flight into adverse weather and the loss of aircraft control which resulted in the aircraft exceeding its design stress limits. Factors were the pilot's failure to obtain a weather briefing and the adverse weather.NTSB FTW97FA286Accident · 1 fatalField investigationFinal reportDurbin Glasair R · Chama, NMflight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the low ceiling, rain, fog, and high/mountainous terrain.NTSB NYC97LA155Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean)Failure of the aft flight attendant to secure her seat belt. Related factors were turbulence in clouds, and the flight attendant not receiving the crew briefing.NTSB ANC97LA109Accident · No injuriesLimited investigationFinal reportCessna 208 · Naknek, AKThe pilots decision to continue the landing into adverse weather conditions and failure to maintain runway alignmet. A factor was the rain shower which resulted in reduced forward visibility.NTSB ANC97LA108Accident · No injuriesLimited investigationFinal reportGoode Avid Flyer MK-IV · Nikiski, AKThe pilot's inadequate compensation for wind conditions. Factors were the sudden windshift, and the pilot's lack of seaplane certification.NTSB MIA97LA211Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Eustis, FLan in-flight separation of the right wing, and subsequent impact with trees. Factors in this accident were thermal lift and turbulence in clouds.NTSB FTW97IA261Incident · Minor injuriesIncident investigationFinal reportBoeing 757-223 · Dickinson, NDan encounter with unforecast convection induced turbulence (CIT). Related factors were: the flight crew's improper evaluation of the weather, and an inaccurate preflight weather briefing by company weather personnel.NTSB LAX97LA236Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Susanville, CAthe pilot's inadvertent encounter with unfavorable weather conditions during the landing, and his failure to maintain runway alignment. The sudden onset of crosswind gusts beyond the capability of the aircraft was a related factor.NTSB NYC97FA139Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Jones Beach, NYVFR flight by the pilot into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain (water). Related factors were: the adverse weather…NTSB ANC97LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-160 · Cantwell, AKThe pilot's failure to maintain sufficient altitude to clear terrain. Factors were exceeding the airplane's maximum allowable gross weight, and downdrafts and turbulence associated with wind flowing across a mountain ridge.NTSB IAD97FA095Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Penobscot, METhe pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.NTSB NYC97LA127Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Rochester, VTThe pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.NTSB LAX97LA211Accident · Serious injuriesLimited investigationFinal reportMaule M-4-220C · Gualala, CAcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from tall trees. The weather conditions (low ceiling and fog) were related factors.NTSB FTW97LA217Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Weston, COthe pilot's improper in-flight planning/decision and failure to maintain adequate altitude and/or clearance from rising mountainous/hilly terrain. The unfavorable wind condition and low airspeed were related factors.NTSB FTW97LA215Accident · Serious injuriesLimited investigationFinal reportBoeing 737-291A · Albuquerque, NMthe sudden encounter with clear air turbulence.NTSB LAX97FA202Accident · 1 fatalField investigationFinal reportCessna 206 · Saugus, CAthe pilot's failure to maintain an adequate terrain clearance altitude while attempting VFR flight into instrument meteorological conditions.NTSB CHI97FA146Accident · 2 fatalField investigationFinal reportHenry Barracuda · Antonia, MOinadvertent flight by the pilot into instrument meteorological conditions (IMC), spatial disorientation of the pilot, which led to his loss of aircraft control, and the pilot exceeding the design stress limits of the airplane, which led to an in-flight…NTSB ANC97LA076Accident · Minor injuriesLimited investigationFinal reportCessna 180F · Ketchikan, AKthe pilot's inadequate compensation for wind conditions. A factor relating to the accident was: the unfavorable wind condition with gusts and downdrafts.NTSB SEA97LA113Accident · No injuriesLimited investigationFinal reportCessna 207 · Roche Harbor, WAThe pilot's inadequate remedial action upon encountering a downdraft on final approach. The downdraft was a factor.NTSB LAX97LA185Accident · 1 fatalLimited investigationFinal reportBell 206B · Hilo, HIthe noninstrument-rated pilot flew into instrument conditions and failed to maintain adequate terrain clearance, while attempting to descend through an overcast. The adverse weather conditions and mountainous terrain were related factors.NTSB NYC97FA092Accident · 1 fatalField investigationFinal reportCessna T337G · North Dansville, NYthe pilot's improper decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance from rising/wooded terrain. The adverse weather conditions and rising wooded terrain were related factors.NTSB ATL97LA064Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Atlanta, GAThe failure of the flight crew to alert the cabin crew to the possibility of turbulence, leading to a serious injury when severe turbulence was encountered..NTSB MIA97LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Augusta, GAflight by the pilot into known adverse weather conditions, which resulted in a loss of aircraft control during the landing flare, and collision with the terrain. The adverse weather with nearby thunderstorm activity, crosswind, and gusts was a related factor.NTSB FTW97FA166Accident · 1 fatalField investigationFinal reportSocata TB-20 · Pagosa Springs, COinadvertent flight by the pilot into known adverse weather conditions, and his failure to maintain altitude or clearance from terrain. Factors relating to the accident were: low ceiling, rain, snow, icing conditions, and mountainous terrain.NTSB NYC97LA071Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-232 · Newark, NJan encounter with unforecasted turbulence, during cruise flight, which resulted in serious injury to the flight attendant.NTSB ANC97LA047Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Teller, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control during the landing. Factors related to the accident were: a crosswind, a downdraft, the pilot's delayed go-around, improper raising of the flaps, and…NTSB ATL97LA055Accident · Serious injuriesLimited investigationFinal reportDassault Falcon 900B · Chamblee, GAan encounter with clear air turbulence, which led to injury of the flight attendant. A factor associated with the accident was: that the flight attendant was not being restrained by a seat belt.NTSB ATL97FA054Accident · 3 fatalField investigationFinal reportBeech V35 · Marco Island, FLinadvertent flight by the pilot into adverse weather conditions (severe thunderstorms), which led the design stress limits of the airplane being exceeded, subsequent in-flight break-up of the airplane, and an uncontrolled collision with water.NTSB SEA97FA075Accident · 4 fatalField investigationFinal reportCessna T210L · Dillon, MTflight by the pilot into adverse weather conditions, and his failure to maintaint altitude/clearance from terrain. The adverse weather condition was a related factor.