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 LAX87FA101Accident · 2 fatalField investigationFinal reportMooney M20E · Dunsmuir, CADuring a pleasure flight, the airplane was seen flying low and disappeared into instrument meteorological conditions, consisting of low clouds, gusty winds and snow which lasted throughout the day. The airplane was found on the side of a hill in a descending…NTSB SEA87LA052Accident · No injuriesLimited investigationFinal reportCessna 182R II · Spokane, WAPlt attempted instrument approach in conditions conducive to structural icing; I.e., fog, light snow, temp 32F. Acft not equipped for deice. Structural ice accretion during approach and climb-out following missed approach degraded acft performance so that…NTSB NYC87FA063Accident · 1 fatalField investigationFinal reportMooney M20C · Highgate, VTAccording to the surviving pax, a snowshower was enctrd, so the plt reversed course & diverted to another arpt. Drg a ngt apch to lnd, the pax noted a white light on the left side of the rwy. (A VASI light sys was installed for that rwy.) The plt aborted the…NTSB LAX87LA092Accident · No injuriesLimited investigationFinal reportCessna 172M · Oakdale, CADuring a solo instructional flight the student pilot was practicing touch and go landings. Upon take-off on runway 28, the wind was light from 100 degrees. On the first landing the wind had changed to a right cross wind from the north. The pilot compensated…NTSB ATL87IA062Incident · No injuriesIncident investigationFinal reportDornier DO228 · Cleveland, OHA piece of ice penetrated a pax cabin window immediately forward of the rt engine prop arc and the ice strike plate. The acft mfr subsequently issued a service bulletin recommending the replacement of the standard windows installed forward of the prop arc(s)…NTSB LAX87FA096Accident · 2 fatalField investigationFinal reportMorrisey 2150A · Mt. Baldy, CADuring a local flt, the airplane was seen circling over a ridge four times. On the fifth pass, the airplane disappeared northbound into the clouds. A witness reported that at the time the mt tops were covered with fog and that blizzard conditions existed.…NTSB ANC87FA023Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKWx conds on the day of the acdnt were rprtd to be extremely variable. Initially, when the plt obtained a wx briefing, VFR flt was not rcmdd. Later, the wx improved & the plt elected to proceed on the flt. While en route, he enctrd snow showers & dscndd to…NTSB CHI87LA062Accident · No injuriesLimited investigationFinal reportMooney M20J · Kalamazoo, MIAfter requesting clearance to Kalamazoo county airport (azo) due to icing problems, the plt was given radar vectors to the ILS runway 35 approach. Four minutes later the plt stated that it was 'probably going to be a dead stick landing.' When asked what he…NTSB SEA87FA062Accident · 2 fatalField investigationFinal reportCessna 150 · Ellensburg, WAThe two commercially certificated instrument rated flight instructors departed Ellensburg at approximately 1120 PST on a local flight. Both pilots had appointments at 1300 hours PST. VFR conditions prevailed in lower terrain near Ellensburg, however, a…NTSB DEN87FA041Accident · 1 fatalField investigationFinal reportCessna T210M · Albuqerque, NMThe plt elected to takeoff from abq international arpt during the passage of a severe wx system. Although his departure was successful his flt path was heading toward the mountains east of abq. He was observed turning north up a canyon. Shortly after turning,…NTSB MIA87MA064Accident · 6 fatalMajor investigationFinal reportCessna T210N · Jasper, FLDrg flt in an area of IFR conditions & rain showers, the plt reqd & recd clnc to dscnd from 9000' to 7000'. Later, he recd clnc for further dscnt to 5000'. After a freq chg at 2237 EST, the plt inquired about radar indcns of adverse wxahead. The ctlr adzd…NTSB CHI87FA057Accident · No injuriesField investigationFinal reportPiper PA-32-301 · Wheeling, ILThe pilot attempted flight although pirep's for icing had been issued during weather briefing from fss and aircraft was not equipped for icing conditions. Shortly after takeoff, pilot reported to ATC problems with aircraft flight instruments and then reported…NTSB LAX87LA070Accident · Serious injuriesLimited investigationFinal reportRaven S55A/AX7 · Peoria, AZPrior to lift-off the pilot noted that the wind conditions were calm. During the flight, the surface winds began to increase. The pilot prepared his passengers for a high wind landing and began to lightly vent off hot air. The balloon began descending at…NTSB ATL87LA046Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Dublin, VAWhile clbg to FL 350, usair flt 95 enctrd cont 'light chop,' so crew lvld at FL 310 & left the seat belt sign on. They inquired about turbc ahead & were adzd of rprtd lgt/mod chop & 1 enctr with svr turbc at FL260. Clnc was rcvd to dscnd to FL 240. Drg dscnt,…NTSB CHI87FA054Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · West Chicago, ILAt 0850 CST, the plt got a wx briefing for a flt to the dupage arpt. At that time, the current dupage wx was in part: partial obscn, 2 mi vis with fog; also, the plt was given svrl pireps for lgt to mod icing in southern Wisconsin. At 1231, he got a wx…NTSB DEN87FA039Accident · 1 fatalField investigationFinal reportCessna 172E · Crossroads, NMThe student plt with no simulated or actual instrument and a total of 9 hours night flt time called the amarillo FAA fss, who briefed him on wx for a flt from borger, Texas, to big spring, Texas, located 210 NM south. He was briefed on marginal VFR wx en…NTSB LAX87FA066Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot encountered clouds and temperatures below freezing during a cross country flight at 17,500 feet above mean sea level. The engine failed shortly after the encounter with the weather. The pilot was unable to restart the engine during the forced…NTSB FTW87FA032Accident · 1 fatalField investigationFinal reportCessna 340A · Tomball, TXThe pilot took off in fog and light rain and climbed into clouds at about 300-400 feet above the ground while both landing lights were extended and illuminated. Also the airport's rotating beacon (located aobut a mile from the accident site) was flashing on…NTSB DCA87IA015Incident · No injuriesIncident investigationFinal reportATR ATR-42 · Detroit, MIDrg arr, the flt was vectored for an ILS rwy 3R apch. At that time, ATIS info indcd mod mixed icing in clds. The capt rprtd the acft entered the cloud tops at 5500', was in the clds aprx 5 min & accumulated abt 1.5' of rime ice. He statedice accumulation was…NTSB SEA87FA036Accident · No injuriesField investigationFinal reportSwearingen SA227AC · Salt Lake City, UTThe f/o was at the controls for the ILS apch to slc. Fog seeding was in progress, producing variable visibilities. The apch commenced with RVR well above cat I mins. At decision height(dh), the capt called 'lights in site'. The f/o continued the apch descent…NTSB ANC87FA021Accident · Serious injuriesField investigationFinal reportBoeing 727-222 · Anchorage, AKAbout 10 min before arrival, the acft suddenly encountered turbulence which one occupant described as a single tremendous jolt. The mishap occurred while the acft was aprx 39 miles east of Anchorage intl arpt and was descending thru 10,000 ft. the seat belt…NTSB FTW87FA031Accident · 2 fatalField investigationFinal reportCessna 172K · El Reno, OKPrivate pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…NTSB CHI87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mcgrath, MNAfter descending to maintain VFR and accumulating clear ice on both the structure and windscreen, the plt decided to make a precautionary landing. During landing in an open area, the left wing struck two apple trees and the acft became airborne again. After…NTSB NYC87LA012Accident · 1 fatalLimited investigationFinal reportEnstrom 280C · Newport, RIAircraft descended and collided with water when the pilot attempted to regain visual ground reference when weather deteriorated. No plt acc report was received. Plt time was not reported or available.NTSB CHI87FA048Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · N. Manitou Isl., MIThe plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake.NTSB FTW87FA029Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Petersburg, TXAcft impacted in a 95 deg nose down attitude following a loss of control in IMC conditions while the non-instrument rated pvt plt was being vectored to the final app crs. Plt had filed IFR and had experienced difficulties thru out the flt. As he was given…NTSB SEA87MA034Accident · 3 fatalMajor investigationFinal reportBell 206L-1 · Pendleton, ORThe helicopter departed Pendleton on an emerg med svc/med-evac (EMS) flt to transport a patient to portland. After delivering the patient, the plt took off on the rtn flt with 2 med psnl aboard. Drg arrival at 1658 PST, he requested a special VFR (svfr)…NTSB ATL87MA035Accident · 4 fatalMajor investigationFinal reportBell 206L-1 · Jamestown, TNThe helicopter was being used in an emerg med svc/med-evac (EMS) opn. At 0230, the plt obtained a partial wx briefing. He was advised of flt prctns for IFR wx thru-out the area with low ceilings, fog, precip & mtns obscd. The flt departed nashville at 0245 &…NTSB MKC87FA027Accident · 1 fatalField investigationFinal reportCessna 177RG · Colby, KSThe non-instrument rated pilot filed an IFR flight plan after being briefed. There was freezing drizzle to the west that was moving toward the departure area. The airplane took off into a low ceiling with near freezing temperature. Pilot attempted to climb to…NTSB DEN87LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellicott, CODuring the initial climb phase of takeoff the plt encountered a wind shear with strong gusty tail winds. The acft entered an uncontrolled descent from 25 feet AGL, struck a wire fence off the end of the rwy and nosed over.NTSB DEN87FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Stugis, SDThe plt agreed to ferry the acft for another plt who was not IFR rated & who had been forced to land at kadoka on the previous evening due to low fuel & apchg darkness. IMC prevailed thru-out the area. The commercial/ifr rated plt did not obtain a wx briefing…NTSB CHI87DEX03Accident · 3 fatalFinal reportCessna 172N · Raymond, OHThe accident aircraft impacted in an open field shortly after a predawn departure from an unattended airport. IMC prevailed an no flight plan was in effect. In a conversaton held the day before with a local pilot the pilot of the accident aircraft stated his…NTSB SEA87FA031Accident · 1 fatalField investigationFinal reportCessna 177RG · Republic, WAA witness observed the acft taxi out ot the rwy in light snow showers and taxi to the north end of the rwy. During the takeoff the area was covered with a heavy snow shower, with winds from the north gusting T0 20-25 mph. The acft was observed to depart to…NTSB MIA87LA036Accident · 2 fatalLimited investigationFinal reportPiper PA-34-200T · Isabela, PRThe acft was reported missing while on a personal flight from san juan PR to aguadilla PR. The plts last radio contact was with aguadilla tower requesting an alternate arpt to land because they were in heavy rain. The coast guard initiated a search and found…NTSB ATL87MA028Accident · 2 fatalMajor investigationFinal reportBell 206B · Cincinnati, OHThe owner/operator (oper) of a flying service provided acft for broadcasting stations in the area. A radio station had contracted with the oper to provide a helicopter (helo, N59610) & a plt to take a news rprtr on a local traffic watch. The oper rprtd that…NTSB MKC87FA022Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Summersville, MOThe PIC had flown his acft fm springfield, MO to olathe, Kansas to have some repair work accomplished and was to return that same day. The PIC never returned to springfield. The PIC had flown to salem, ill where witnesses stated they observed that he was…NTSB ATL87LA022Accident · No injuriesLimited investigationFinal reportCessna 402C · Fremont, OHThe plt reported that he was about five feet above the rwy when he encountered a gust of wind. The acft rocked from side to side during the apch and touched down hard.NTSB MKC87FA020Accident · 1 fatalField investigationFinal reportCessna 182A · Bluff City, KSThe plt stated that he was cruising at 2,500 ft MSL en route southbound to enid, Oklahoma, when he encountered fog but flew for 15 to 20 minutes before executing a 180DEG northerly turn back to hutchinson, KS. According to the plt, he was in the clouds trying…NTSB BFO87FA009Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Danville, VAThe aircraft was observed flying around the airport as the weather deteriorated. The pilot had elected to depart at about 2345 EST after obtaining a weather briefing 6 & 1/2 hours before. The plt had a total of about 83 hours flying time and did not have any…NTSB CHI87LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, ILThe plt rprtd he enctrd IFR conds at aprx 400' AGL drg takeoff. He elected to 'fly out of it' & 'was in the clear' afterclbg to 4500' MSL. He elected to return to the arpt & indcd he could see the arpt 'on and off' thru brkn clds. On an apch to lnd, the acft…NTSB ATL87LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Lexington, NCDuring a local instructional flight, the CFI was demonstrating a simulated emergency landing to a field to a 5 hour pre-solo student pilot. During recovery the aircraft was reportedly affected by a downdraft and collided with a wire. The acft began losing…NTSB SEA87FA019Accident · 2 fatalField investigationFinal reportBeech BE35K · Marysville, WAA witness observed the acft impact in an open field during a heavy rain. Rain, fog, and turbulence in the clouds were reported in the area at the time. The acft impacted in a right turn. The new instrument rated plt was getting complex acft time in…NTSB DEN87FA017Accident · Serious injuriesField investigationFinal reportPiper PA-32-301T · Cheyenne, WYThe plt and his two pax were on a VFR x-country to scottsbluff, NE, when IMC was encountered near grand junction, CO. The plt then called ATC and obtained an IFR clearance. The plt elected to land at Cheyenne, WY. Wx was reported to be 500 overcast, 1/4 mi…NTSB MIA87FA025Accident · 2 fatalField investigationFinal reportCessna 152 · Woodville, FLThe non-instrument rated private plt had received his certificate two days prior to the accident. The flight was receiving stage three radar service when it advised that it was in the clouds and was turning around. Radar contact was lost moments later and the…NTSB LAX87LA033Accident · Minor injuriesLimited investigationFinal reportBeech K35 · San Diego, CAAt the end of a night cross country flight, the pilot attempted an instrument approach to the montgomery airport after being advised the weather was below basic VFR minimums. He was cleared for an ILS approach and reported that he had the runway in sight at…NTSB DEN87FA016Accident · 1 fatalField investigationFinal reportCessna 421C · Butte, MTPlt was attempting the vor-b instrument apch to Butte, MT arpt. Plt reported over the coppertown VORTAC inbound on the arpt. The procedure turn inbound course to the VORTAC is 124 degrees. The inbound course to the arpt is 094 degrees. The acft wreckage was…NTSB DCA87MA010Accident · 1 fatalClass 1 · MajorFinal reportPiper PA-23-150 · Tampa, FLAt aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…NTSB LAX87FA200Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Flagstaff, AZThe plt & his wife desired to return to their Flagstaff, AZ, home following a weekend at stockton, CA., & they departed sck in VFR weather conditions. The weather at the destination arpt had been below VFR minimums all morning & it was forecast to remain poor…NTSB LAX87LA032Accident · No injuriesLimited investigationFinal reportLearjet 24 · Lake Tahoe, CAAt the end of a cross country flight, the pilot experienced light to moderate turbulence on short final while executing a down wind approach to the Lake Tahoe airport. Approximately 50 feet AGL over the runway, the aircraft exited the turbulence and touched…NTSB NYC87FA025Accident · 1 fatalField investigationFinal reportBell 206B · Brattleboro, VTThe helicopter crashed into a wooded ridge aprx 2 NM from it's liftoff location. Persons who reside under the flt path were awakened by the acft as it was descending into IMC at what sounded like full power. The plt's heliport was at an elevation of 950 ft…