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 DCA89MA026Accident · 10 fatalMajor investigationFinal reportCessna 402B · Corona, CAThe pilot's failure to properly preflight and plan for flight and his intentional flight into IMC conditions. Factors contributing to the accident were the low ceiling conditions in conjunction with the mountainous terrain.NTSB MKC89FA061Accident · 2 fatalField investigationFinal reportBeech 58 · Hamburg, ARThe pilot continued VFR flight into IMC conditions and failed to maintain sufficient altitude above the wooded terrain. Weather conditions, low light conditions at or near dusk, lack of visual cues (visual perception) by the pilot, and trees were contributing…NTSB FTW89LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Seminole, TXThe pilot's delay in updating his weather and diverting to an alternate destination, which resulted in fuel exhaustion from lack of fuel. Contributing factors were: the pilot's inadequate preflight planning/preparation at the en route stop, the weather…NTSB FTW89FA049Accident · 3 fatalField investigationFinal reportMBB BK-117 A-1 · Tyler, TXThe pilot's failure to execute the published inadvertent IMC procedures when he encountered adverse weather conditions.NTSB LAX89FA106Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Julian, CAThe pilot's poor judgement of intentionally flying into an area of known forecast icing conditions which resulted in a loss of control and an inflight breakup of the aircraft. Contributing factors were the pilot's overconfidence in his personal ability by…NTSB NYC89FA080Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Lyon Mountain, NYThe pilot decided to fly in weather conditions that were beyond his and the aircraft's capabilities.NTSB CHI89FA049Accident · 3 fatalField investigationFinal reportCessna 172RG · Mosinee, WISpatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.NTSB LAX89LA104Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Phoenix, AZThe pilot displayed poor preflight planning and preparation by not properly evaluating the weather conditions.NTSB LAX89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Ynez, CAThe failure of the pilot to obtain an adequate preflight weather briefing or to obtain inflight weather advisory information, and the failure of the pilot to maintain flying speed while descending in a downdraft.NTSB FTW89LA057Accident · Minor injuriesLimited investigationFinal reportCessna U206 · San Angelo, TXFailure of the pilot to maintain adequate altitude during continued flight into known adverse weather. The weather conditions and dark night were contributing factors.NTSB MKC89LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Ainsworth, NEThe loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.NTSB MIA89LA074Accident · Minor injuriesLimited investigationFinal reportBeech G-35 · Panacea, FLPilots loss of control when entering the fog bank during the takeoff, due to spatial disorientation.NTSB ATL89LA083Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Cumming, GAThe pilot's decision to attempt VFR flight in adverse meteorological conditions at night with an inoperative attitude indicator and insufficient fuel reserve for the intended flight.NTSB NYC89FA073Accident · 4 fatalField investigationFinal reportGrumman GA-7 · Spartansburg, PAThe pilots decision to disregard the weather forecast and attempt flight into known icing conditions. After the wings started to ice up, the pilot initiated a climb but could not maintain airspeed and inadvertantly stalled the aircraft which entered an…NTSB FTW89FA042Accident · 1 fatalField investigationFinal reportCessna 150L · Zachary, LAThe pilot's loss of aircraft control due to spatial disorientation after encountering instrument meteorological weather conditions (IMC) shortly after takeoff, his intentional takeoff into adverse weather conditions, and the operator's inadequate supervision…NTSB SEA89FA036Accident · 2 fatalField investigationFinal reportde Havilland DHC-3 · Ketchikan, AKThe pilot's inadvertant flight into IFR conditions and the stall which occurred during the turn to reverse course. Contributing to the accident were the snow conditions encountered.NTSB MKC89LA053Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Malmo, MNThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), which resulted in his loss of aircraft control, due spatial disorientation. A related factor to the accident was: the adverse weather condition.NTSB CHI89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Valparaiso, INInadequate preflight preparation by the pilot, which resulted in inadvertent flight in icing conditions and rapid accumulation of airframe ice, and the pilot's failure to maintain sufficient airspeed to flare during the landing. Factors related to the…NTSB ATL89LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Russells Point, OHThe pilot's inaccurate evaluation of weather condition, and his failure to use available weather briefing resources. As a result, the pilot encountered structural icing which covered the windscreen, blocking forward visibility.NTSB LAX89FA082Accident · 3 fatalField investigationFinal reportBeech 35-B33 · Ripon, CAContinued flight by the pilot into known icing conditions and structural (wing) icing, which subsequently resulted in an uncontrolled stall. A contributing factor was the icing condition.NTSB ATL89LA068Accident · Serious injuriesLimited investigationFinal reportBeech B-90 · Paducah, KYPilot failed to maintain proper altitude while maneuvering to land. Probable contributing factors were inoperative weather radar, thunderstorms, lightning, an undetermined electrical problem, dark night, the pilot's improperly planned approach and visual…NTSB LAX89FA091Accident · 1 fatalField investigationFinal reportCessna 172M · Oxnard, CAContinued VFR flight by the pilot into instrument meteorlogical conditions which resulted in an in-flight collsion with terrain. Related factors were: failure of the pilot to use a preflight briefing service, his decision to initiate flight into known adverse…NTSB MKC89DCG02Accident · 1 fatalFinal reportWells Varieze · Macon, MOContinued flight by the pilot into known adverse weather and his failure to maintain sufficient altitude/clearance above obstacles. Contributing factors were: low ceiling, fog, rain, pilot delaying flight to an alternate destination, his lack of recent flight…NTSB LAX89FA078Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · San Bernardino, CAThe pilot's decision to continue VFR flight after encountering instrument meteorological conditions while attempting to transit through a mountain pass. Contributing factors was: the pilot's self-induced pressure knowing that a co-worker was probably waiting…NTSB DEN89LA057Accident · No injuriesLimited investigationFinal reportBumgartner/Hirt Steen Skybolt · Quemado, NMFailure of the pilot to select a suitable landing strip/area. Factors related to the accident were: high terrain and low ceiling along the route of flight, haze, and the soft condition of the selected landing strip.NTSB DEN89FA056Accident · Serious injuriesField investigationFinal reportCessna 208B · Aspen, COPilot's improper IFR procedure. Contributing factors included moderate turbulence, low ceilings, obscuration and snow.NTSB CHI89FA039Accident · 2 fatalField investigationFinal reportCessna 210D · Alvin, ILContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude. Factors related to the accident were: darkness, adverse weather conditions, the pilot's lack of instrument…NTSB LAX89FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Wrightwood, CAAccording to the passenger, during a cross country flight the airplane encountered instrument meteorological conditions. The pilot flew the airplane toward a mountain range and entered a valley with rising terrain. Still in IMC, just prior to the accident,…NTSB SEA89LA030Accident · 1 fatalLimited investigationFinal reportCessna 205 · Cottage Grove, ORThe student pilot took off on a solo flight from an uncontrolled airport at Cottage Grove in marginal weather conditions. Shortly after takeoff, he transmitted to eugene tower (which was approximately 15 miles north) that he had encountered 'white-out'…NTSB LAX89FA074Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Yucca, AZPilot's failure to maintain directional control. Contributing factors included the pilot's improper in-flight decision which was related to his overconfidence in his personal ability, spatial disorientation upon encountering inclement weather during the…NTSB ATL89FA061Accident · 2 fatalField investigationFinal reportCessna 210B · Mt Airy, NCThe pilot attempted to locate the destination airport in instrument meteorological conditions, and his failure to maintain a sufficient altitude to avoid the terrain in the area. Factors contributing to the accident were the pilot' overconfidence in his…NTSB ATL89FA059Accident · 2 fatalField investigationFinal reportCessna 172 · Wadsworth, OHPIC & future son-in-law came to arpt to fly acft. Wx was low ceilings & viz due to fog. PIC did not have instrument rating. The son-in-law, an army captain, was sked to leave for overseas assignment shortly. Closest arpt which rpted wx, 15 miles southeast,…NTSB LAX89LA068Accident · Serious injuriesLimited investigationFinal reportBoeing 747SP-21 · Midway Islands (Pacific Ocean)Aircraft's encounter with unforecast severve clear turbulence.NTSB ATL89FA058Accident · 2 fatalField investigationFinal reportCessna 414 · Bloomville, OHNTSB MKC89FA043Accident · 3 fatalField investigationFinal reportBell 206L-1 · Cape Girardeau, MOThe helicopter was dispatched at night on an emerg med svc (EMS) flt fm a hospital at Cape Girardeau, MO. Purpose of theflt was to transport a patient fm a hospital at marion, IL, to Cape Girardeau. Wx at Cape Girardeau deteriorated after the acft departed.…NTSB CHI89IA034Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42 · Mosinee, WIStall induced by the accretion of moderate to severe clear icing.NTSB LAX89LA073Accident · 1 fatalLimited investigationFinal reportBell 206L-1 · Oakland, CAPilots intentional flight into known adverse weather condititions from which he inadvertently descended into the water at a high rate of speed. Contributing to the accident was the pilot's failure to obtain a weather briefing; lack of recent instrument flying…NTSB DEN89FA041Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Arvada, WYThe pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when…NTSB MIA89FA048Accident · Serious injuriesField investigationFinal reportCessna 150J · Gainesville, FLPlt obtained weather briefing prior to departure at which time he was told the possibility of IFR conditions on arrival at destination existed due to fog. Plt failed to obtain en route weather briefing. Near his destination, the plt encountered IFR…NTSB ATL89FA047Accident · 3 fatalField investigationFinal reportBeech P35 · Bakersville, NCDuring the VFR business flight radar data indicated the acft descended from 9,500 to approx. 5,500' MSL where it collided with a mountain. Clouds were present in the area. There were no witnesses to the accident. The wreckage was located by ELT signal. The…NTSB MIA89LA046Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Atlantic Ocean (Atlantic Ocean)The student pilot contacted ifss at miami, FL and filed an intl flight plan to the Bahamas. He did not request a weather briefing and none was given. The pilot later contacted controllers and stated that he was in instrument meteorological conditions and…NTSB DEN89FA038Accident · 1 fatalField investigationFinal reportCessna 150L · Fairplay, CONTSB MIA89FA044Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Molino, FLBefore takeoff, the plt was adzd of an apchg cold front in the Florida panhandle as well as a forecast of hvy thunder- storm activity in the area of pensacola. En route, he was provided VFR flt following from pensacola apch ctl while cruising at 6500 ft.…NTSB DEN89FA036Accident · 5 fatalField investigationFinal reportCessna T210F · Cortez, COThe plt obtained a wx briefing from las vegas fss and was told that flt under VFR was not recommended for the proposed flt to durango (dro). The plt filed a VFR flt plan and departed las vegas. Over page, AZ, he filed a PIREP and was again told VFR flt not…NTSB BFO89FA012Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Meadows Of Dan, VAThe pilot conducted VFR flight into IMC because of inadequate inflight planning/decision. The aircraft experienced inflight brakup when the pilot was unable to maintain flight within the design stress limits of the aircraft.NTSB NYC89FA036Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Gans, PAPilot's bad judgement in flying in weather conditions beyond the capabilities of his aircraft. The pilot overstressed the aircraft and sheared the left wing by making an abrupt turn in turbulent air above the design maneuvering speed (VA). The accumulation of…NTSB FTW89FA022Accident · 2 fatalField investigationFinal reportCessna 150M · Fort Worth, TXFailure to the flight instructor and the student pilot to obtain a weather briefing prior to departure, and he flight instructor's failure to observe the deteriorating weather conditions in sufficient time return to the airport prior to instrument…NTSB BFO89LA011Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Port Royal, VAThe plt received a wx briefing which forecast IFR after 1800 EST. He departed dca in light drizzle conditions. Arpx 35 NM from dca, radar service was terminated and the plt attempted to contact ATC to no avail. He reported that near the brook VOR the VOR…NTSB NYC89LA027Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Montauk, NYLoss of control, inflight, while landing, due to low level wind shear.NTSB MIA89MA023Accident · 3 fatalMajor investigationFinal reportRockwell 1121A · Oak Grove, PAFailure of the pilot in command to observe the rapid accretion of ice on the airplane due to his attention being diverted.