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 LAX89LA028Accident · 1 fatalLimited investigationFinal reportRobinson R22 · Lower Lake, CADuring a local solo instructional flight, the helicopter collided with the terrain in an open field aprx 3 miles from the airport. It was reported to have contacted the ground at considerable downward speed with high rotor RPM. No preimpact mechanical failure…NTSB DEN89LA021Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Fort Peck, MTThe plt enctrd hvy snow at night & turned back to find a nearby landing strip that he was familiar with. He recognized a ranch house associated with the strip, but was unable to find the landing area. He began to circle in hopes that someone would turn on the…NTSB LAX89FA022Accident · 2 fatalField investigationFinal reportCessna 172N · Petaluma, CAPilot used poor judgement when he attempted v.f.r. flight during instrument meteorological conditions and that he encountered spatial disorientation when he entered into the clouds.NTSB MKC89FA007Accident · 2 fatalField investigationFinal reportCessna T210F · Rogers, ARContinued flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain aircraft control after becoming disoriented. Contributing factors were: dark night, low ceilings, fog, drizzle, obscuration, and failure of the pilot to…NTSB DEN89FA019Accident · 2 fatalField investigationFinal reportBell 206L-3 · Deckers, COWhile on a corporate flt thru a canyon in marginal wx conds, the helicopter collided with the static portion of a power transmission line & crashed. The acdnt occurred where a 2,554 ft span of the power line crossed the south platte river. The power line…NTSB DEN89FA017Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Garfield, CONTSB ATL89FA015Accident · 3 fatalField investigationFinal reportCessna 177A · La Follette, TNThe plt departed knoxville in VFR conds. There was an area of IFR wx to the north & northwest of knoxville. The wx was forecast to be marginal along his route of flt. The plt rprtd he wanted to depart knoxville on a heading of 360 deg & would be at 2500'. The…NTSB DEN89LA013Accident · Minor injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe plt, with two pax aboard a hot air balloon, participated in the 1988 Albuquerque, NM international balloon fiesta. The plt said he received a wx briefing and then departed in VFR wx conditions. After aprx 45 min of flt, the plt said he encountered…NTSB DEN89FA009Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMBefore dawn, witnesses (who were preflighting an acft) saw N732QP taxiing to rwy 4. They heard an eng run-up; however, they were unable to see the acft takeoff due to heavy fog that had just moved over the arpt. (The witnesses decided to cancel their flt due…NTSB DEN89FA007Accident · 3 fatalField investigationFinal reportMooney M20E · Walsh, COThere is no record plt obtained wx briefing, filed flt plan, or obtained in-flt wx advisories. Plt and two pax departed san marcos, TX, at 1400 CDT in VMC, enroute to springfield, CO. Acft was seen by two witnesses at aprx 1630 MDT, 11 mi w of Walsh, CO,…NTSB CHI89LA001Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Tell City, INThe pilot flew a VOR approach to the airport, but was too high to land on the approach runway. He executed a circling VFR pattern to land on the reciprocal runway, then flew into the ground fog in the descending base turn. The left wing struck a tree while in…NTSB BFO88FA085Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Clarksville, VAInflight loss of control as a result of pilot disorientation when the pilot tried to conduct VFR flight into IMC. Low clouds, poor visibility, fog and poor decision are contributing factors.NTSB SEA88LA189Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Toledo, WAThe plt took off from an uncontrolled strip in marginal wx conds, believing he could affect a departure to good VFR conds. Shortly after takeoff, he enctrd solid IMC & momentarily lost control of the acft. After regaining control & having lost altitude, he…NTSB ATL88LA255Accident · No injuriesLimited investigationFinal reportCessna 150 · Bessemer City, NCThe pilot reported that he had observed a cloud layer forming along his flt route. At about the same time, the acft VOR rcvr failed. The plt elected to continue vfr-on-top to his planned destination based on VFR wx reported by an ATIS broadcast from an arpt…NTSB SEA88LA188Accident · 2 fatalLimited investigationFinal reportSvensson Bushby Mustang II · Everett, WAJust prior to the acdnt, witnesses saw the acft in a steep, high speed descent. Impact occurred in soft, marshy terrain & much of the wreckage was buried. No mechanical reason was found for a loss of control; however, the acft was extensively damaged drg…NTSB SEA88LA186Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Seattle, WAPlt received ATIS info which advised of gusty crosswind conditions and low level wind shear and recommended contacting Seattle radio(fss) for further info. Plt did not contact fss and initiated takeoff. At 100-200 ft AGL, acft encountered turbulence, pitched…NTSB SEA88LA183Accident · 1 fatalLimited investigationFinal reportCessna 150L · Hadlock, WAThe recently certificated pilot departed on a two hour round-robin flight to attend a meeting and was advised to expect fog on return. The aircraft was flown for one hour prior to this flight and was not refueled. No record of a wx brief was found. Prior to…NTSB MKC88FA176Accident · 1 fatalField investigationFinal reportBeech C23 · Belle Plaines, IAThe non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered…NTSB DEN88FA213Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Curtin, OROn 9/20/88, the plt & his wife depd montaque, CA, on a flt to silverdale, WA, with a planned refueling stop at cottage grove, OR. When the acft did not arrive, a search was made, but to no avail. On 1/24/90, a tree planting crew found the acft, where it had…NTSB FTW88FA164Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Okmulgee, OKNon-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…NTSB NYC88FA236Accident · 2 fatalField investigationFinal reportCessna 172N · Adams, MAPilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper.NTSB SEA88LA180Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Wenatchee, WAAfter takeoff, plt noted wind increasing. Plt then made downwind 300 ft AGL survey run of field to be sprayed abutting columbia river. In procedure turn over river at completion of run, acft encountered 'sinkhole' wihch plt could not counter with full power…NTSB NYC88FA235Accident · 3 fatalField investigationFinal reportCessna 182RG · Greenville, METhe non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the…NTSB MIA88FA267Accident · 4 fatalField investigationFinal reportBeech K35 · Morriston, FLThe student pilot was about 47 miles from home and nearing completion of a x-c flt with his wife, father, and mother. The plt had reqsted VFR flight following & had been cruising at 6500 ft. the plt advised ATC they were down to 6250 ft & needed to descend…NTSB SEA88FA169Accident · 4 fatalField investigationFinal reportCessna 172E · Petersburg, AKPlt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions.NTSB FTW88FA161Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · Carthage, TXDrg a night arrival, the plt rprtd he could make a visual apch. At 2341:37 CDT, the ARTCC controller informed him the destn arpt was straight ahead at 12 mi & requested that he rprt when the arpt was in sight. At 2343:30, he rprtd the rwyin sight & the…NTSB ATL88IA241Incident · Minor injuriesIncident investigationFinal reportBoeing 737-387 · Savannah, GAWhile cruising at FL 310, usair flight 333 encountered severe turbulence. The pilot reported observing the thunderstorm activity on the airborne radar. The flight was within 20 miles of the cell before action was taken to avoid the encounter. The recommended…NTSB LAX88LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Dunsmuir, CAJust after takeoff, the airplane gained just enough altitude to clear trees at the end of the runway. The pilot turned up a valley to gain altitude. The airplane was gaining altitude at 150 fpm, however, the valley turned into a box canyon and the airplane…NTSB ATL88FA239Accident · Serious injuriesField investigationFinal reportBoeing 767 · Charleston, SCNTSB LAX88FA297Accident · 1 fatalField investigationFinal reportMooney M20J · Inyokern, CAPilots inflight loss of control after encountering a level four thunderstorm on a night VFR cross country. Contributing to the accident was the pilot's failure to obtain a preflight weather briefing.NTSB ATL88FA233Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Pittsboro, NCThe plt had an instrument plt accompany him on the flight to myrtle beach in the event the wx required IFR for the return flt. When they arrived at myrtle beach, the plt decided that they would remain overnight. After visiting some night spots and doing some…NTSB LAX88LA288Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-236 · Camarillo, CADuring a cross country flight, the pilot reported that he was 'scud running' to the airport. The pilot was following a road that ran near the airport, however, the pilot lost sight of the road. The pilot decided to divert to another airport and then the…NTSB ATL88FA231Accident · 1 fatalField investigationFinal reportCessna 172 · Adel, GAThe pilot had been briefed on the weather conditions along the intended route of flight. VFR flight was not recommended. The pilot elected to land at his alternate, and had reported visual contact. Local witnesses reported low ceilings and reduced visibility.…NTSB SEA88FA154Accident · 2 fatalField investigationFinal reportCessna 210E · N Bonneville, WAWhile on a flt from oroville to orchards, WA, the acft was about 25 to 30 mi east of the destn when it collided with trees & crashed. Impact occurred aprx 100 ft below the top of a ridgeline at an elev of about 1755 ft. a witness, who heard the crash, rprtd…NTSB MKC88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOThe plt rprtd that during the flt, he enctrd thunderstorm activity, as well as a downdraft, which resulted in a loss of about 400 ft of alt. Subsequently, the acft was landed in a corn field & was damaged. About 13 mi se at st louis, the visibility was rprtd…NTSB DEN88LA178Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Clinton, MTThe plt rprtd that drg takeoff from rwy 25, the winds were from 270 deg at 10 gusting 15 KTS. He stated that drg the initial climb, the airplane enctrd a severe windshear. Subsequently, he lost control & the acft struck the ground in a 40 deg nose down, 70…NTSB ATL88LA228Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Burkesville, KYThe plt reported that the airplane encountered heavy rain and extreme turbulence while flying over a black cloud at 8,500 ft. he stated that it was as if an 'invisible tornado had reached out' and grabbed the airplane; excessive climb & descent rates were…NTSB DEN88LA172Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Guffey, CONTSB DEN88LA171Accident · No injuriesLimited investigationFinal reportCessna 150 · Albuquerque, NMThe instructor (CFI) & student plt were on an instructional flt. The CFI rprtd that while climbing thru aprx 150' AGL, the acft enctrd a downdraft. He took the controls, but the acft descended to about 10 ft AGL. The CFI elected to land immediately to avoid a…NTSB BFO88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisonburg, VAThe plt encountered clouds during a night VFR flight. He decided to make a precautionary lndg on what he thought was a lighted farm landing strip. However, he later learned the strip was actually a row of lighted turkey barns. According to the plt, as he made…NTSB NYC88FA196Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pocantico Hills, NYThe non-instrument rated private pilot departed in instrument flight conditions against the advice of several people he talked to. Approximately 1 hour and 30 minutes after departure the first of four or five mayday calls were heard by bridgeport radio and an…NTSB FTW88IA141Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Kenton, DEA flameout of the #1 engine occurred due to water ingestion when the aircraft penetrated a vip level 5 thunderstorm and encountered heavy rain while descending with the throttles a flight idle. The engine suffered overtemperature damage to the turbine section…NTSB MIA88LA236Accident · 1 fatalLimited investigationFinal reportPiper PA-60-700P · Cocoa Beach, FLFlt entered near vertical descent while flying in area of level 1 and 2 thunderstorms just after plt had called requesting permission to deviate around rain showers. A level 5 thunderstorm was present 8 miles west. The acft descended at rates up to 13,800…NTSB LAX88DUJ05Accident · Minor injuriesFinal reportGrumman G-164B · Parker, AZDuring an aerial application flight, the pilot dispensed the load and was returning to the airstrip due to an approaching thunderstorm. Enroute, the visibility was reduced to near zero from blowing dust. The pilot lost control of the airplane and collided…NTSB FTW88DPJ08Accident · Minor injuriesFinal reportCessna 152 · Heavener, OKDuring a cross country training flight, the non-instrument rated pilot flew into IMC conditions while descending. The pilot attempted to climb into VFR conditions but when that was not successful a descent was begun in an effort to breakout into VFR…NTSB NYC88LA189Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Saltsburg, PAThe plt launched on a local Balloon sight-seeing flight at 1850 local time with the forecast of thunderstorm activity to commence in the area after midnight. After 40 mins of smooth flt, the temp dropped sharply and shortly thereafter turbulence was…NTSB MIA88FA224Accident · 2 fatalField investigationFinal reportBeech 95 · Destin, FLPlt reported arpt in sight and was cleared for visual approach. Witnesses reported seeing acft on left downwind & said it flew into a thundershower. The flt was not heard from again. The acft's wreckage was found in the bay 1 1/4 miles north of the runway.…NTSB NYC88LA188Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions AX-7 · Wellsville, NYAbout 35 hot air balloons were entered in the great Wellsville balloon rally. At 0625 EDT, the plt (of c-gdgk) attended a wx briefing that was given to the plts by the balloonmeister. The plt said the balloonmeister indicated that there would be suitable…NTSB MIA88FA223Accident · Serious injuriesField investigationFinal reportRockwell 100-180 · Paxton, FLPlt's license was suspended at time of accident and his medical certificate was expired. Plt failed to get weather briefing prior to departure. Plt continued flt into deteriorating weather conditions and while attempting to land at a private airport due to…NTSB SEA88LA132Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Wrangell, AKPlt attempted flight through a mountain pass in the presence of low clouds and fog. Visual ground reference was lost and the acft collided with a snow bank. Plt cited personal and company-induced pressures as factors. Operator completed accident report.