NTSB investigations, 1987
176 cases where the first occurrence was “In flight encounter with weather”.
Cases per year
| 1982 | 244 |
|---|---|
| 1983 | 255 |
| 1984 | 241 |
| 1985 | 209 |
| 1986 | 207 |
| 1987 | 176 |
| 1988 | 158 |
| 1989 | 187 |
| 1990 | 154 |
| 1991 | 143 |
| 1992 | 121 |
| 1993 | 98 |
| 1994 | 74 |
| 1995 | 114 |
| 1996 | 110 |
| 1997 | 94 |
| 1998 | 110 |
| 1999 | 101 |
| 2000 | 99 |
| 2001 | 75 |
| 2002 | 85 |
| 2003 | 122 |
| 2004 | 115 |
| 2005 | 100 |
| 2006 | 87 |
| 2007 | 88 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1987
AND 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 year(c."eventDate") = 1987 AND 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 NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…NTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…NTSB MKC88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hays, KSDuring a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…NTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…NTSB FTW88LA041Accident · No injuriesLimited investigationFinal reportCessna 172XP · Godley, TXDuring a cross country flight, the weather worsened. Visibility decreased and the ceiling lowered, forcing the pilot to descend in order to remain VFR. The pilot elected to perform a precautionary landing in a field. During landing roll the pilot noticed a…NTSB SEA88FA032Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Eastsound, WAThe plt depd south from an unattended island arpt at sea level & flew into marginal VFR conds with moderate snowfall. Acquaintances at the arpt rprtd the plt expressed an urgent need to return to snohomish, WA, despite the wx conds. When the acft did not…NTSB MIA88LA065Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Guvate, PRThe private pilot became separated from the formation of 4 aircraft and entered an area of deteriorating weather. He descended and attempted to maintain visual contact with the ground and struck trees and crashed. The pilot was not instrument rated and did…NTSB SEA88FA031Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Lakeport, CAAlthough weather conditions were marginally VFR at his departure point, and the pilot had access to a vehicle which could have been used to drive to his dest, he departed novato, CA, enroute to Lakeport, CA, without obtaining a wx briefing nor filing a flt…NTSB ATL88FA060Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Moultrie, GAThe plt was on a personal VFR flt with his wife and son. During the course of the flt, he entered deteriorating weather conditions. He was advised that there were scattered rain showers ahead. He continued on his track and advised apch control that he had…NTSB ANC88FA020Accident · 1 fatalField investigationFinal reportCessna 207A · Ambler, AKThe plt of the air taxi cargo flt was operg at night in marginal VFR conds when the acft struck rising terrain. The acft was fnd the next day at aprx 1000 ast, some 15 mi off the intended route. The plt was unconscious & suffering fm hypothermia & other…NTSB DEN88FA128Accident · 2 fatalField investigationFinal reportCessna 177RG · Afton, WYThe acft was not certified nor equipped for flt into icing conditions. The plt elected to depart even though he was advised by the crew of a C-182 that had just lndd to stay below the clouds because of icing. After tkof the acft cleared an 11000 ft mtn range…NTSB ATL88LA054Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Sewanee, TNThe plt rprtd that he obtained a wx briefing before takeoff & that the wx at his intended destination was rprtd as marginal. While en route, he encountered wx and climbed above it. Aprx 4 hrs after departure, he became concerned about the remaining fuel…NTSB MKC88FA023Accident · 2 fatalField investigationFinal reportCessna 180 · Springfield, NEAccording to witnesses on the ground, the aircraft was flying low, under the overcast, when the left wing struck the guy wires of a tv tower and the plane crashed out of control. It was destroyed by impact forces and a post-crash fire. Weather stations in the…NTSB LAX88LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Dunsmuir, CAA Piper PA-38-112 collided with terrain while on a night VFR cross country flight. Night instrument meteorological conditions prevailed at the time and no flight plan was filed. The pilot received a weather briefing prior to departure. His destination weather…NTSB SEA88LA026Accident · No injuriesLimited investigationFinal reportCessna 206 · Funter Bay, AKShortly after takeoff, with a right quartering tailwind of 20 knots gusting to 25 knots, a downdraft was encountered. The pilot flew the aircraft away from rising terrain but the aircraft settled into small trees at full power in the takeoff configuration.NTSB BFO88FA009Accident · 1 fatalField investigationFinal reportCessna 182D · South Hill, VAThe plt was on the third leg of a trip between tampa, FL and sussex, NJ. The previous two stops were made because of adverse wx conditions. Before this flight he was advised by fss that VFR flight was not recommended. He filed a VFR flight plan but did not…NTSB MKC88LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Springdale, ARDrg a wx briefing bfr tkof, the plt was adzd that VFR flt was not rcmdd due to low ceiling & icing conds. He was adzd the freezing lvl was forecast to be at 4000' over little rock & to slope down to the surface in se Missouri. Also, he was briefed on pireps…NTSB NYC88FA045Accident · 4 fatalField investigationFinal reportCessna T210N · Skaneateles, NYPrior to departure from holland, mi the pilot received a briefing which included flight precautions for IFR conditions over his entire route of flight and occasional light to moderate rime and/or mixed icing in clouds below 18,000 feet. The pilot elected to…NTSB FTW88FA032Accident · 3 fatalField investigationFinal reportBeech H35 · Port Mansfield, TXThe plt rcvd svrl wx briefings bfr tkof & was adzd of convective activity along the initial route of flt north of the arpt. The planned dep route was twd the wx. While discussing altn routing possibilities, the plt indcd he would ask ATC for deviation arnd…NTSB ATL88FA043Accident · 1 fatalField investigationFinal reportCessna 172N · Blanchester, OHThe aircraft departed before dawn from a private sod airstrip owned by the pilot, and collided with trees shortly thereafter. The pilot's wife said that the airstrip was not foggy when her husband took off, but the witness reported that the fog at the…NTSB SEA88FA021Accident · 1 fatalField investigationFinal reportCessna 210E · Port Townsend, WAThe aircraft flew into the side of maynard mountain, the point of a coastal land mass, while on a night VFR flight in IMC wx conditions. Radar data showed the aircraft on a straight course at cruise airspeed.NTSB MIA88FA042Accident · 2 fatalField investigationFinal reportCessna 152 · Okeelanta, FLThe acft crashed into a wildlife management area in a steep nose down attitude with about 20 degs flaps extended. The stated purpose of the flt was to spot deer & a suitable area in which to hunt. Torsional damage to the airframe suggested that the acft was…NTSB MKC88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mena, AROn the day of this accident, there was a well-publicized weather system affecting the weather along the pilot's route: warm moist gulf air was moving northward toward a cold front that extended from Mexico to Canada. Residents in the area said the region had…NTSB SEA88FA024Accident · 2 fatalField investigationFinal reportCessna 180G · Cambridge, IDDuring a fuel stop at elko, NV the pilot requested a weather briefing for VFR flight to lander, WY or to couer d'alene, ID. The FAA fss briefed him on adverse weather to both destinations, with flight advisories for mountain obscurations, occasional severe…NTSB NYC88DGM03Accident · 1 fatalFinal reportPiper PA-28-161 · Spartansburg, PAThe pilot landed at the franklin, PA airport after encountering fog. After making several phone calls and remaining on the ground for about 37 minutes he departed. About 30 minutes later the aircraft was seen circling at a low altitude, flying in and out of…NTSB FTW88FA028Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Lancaster, TXThe pilot received a weather report indicating that IFR conditions prevailed. After takeoff the airplane traveled approximately 1/2 mile before it crashed. Pilot was not instrument rated and had very little total time. He did have three hours of night time…NTSB SEA88LA016Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Turner, ORWhile on a short cross country flight the pilot encountered a rain storm and low clouds. The pilot made a 180 degree turn and then elected to make a precautionary landing in a field. Although the pilot visually inspected the area prior to landing, he did not…NTSB MIA88FA032Accident · Serious injuriesField investigationFinal reportAirbus Industrie A310 · Atlantic Ocean (Atlantic Ocean)The capt said he expected some wx drg the 1st 2 hrs of flt. After lvlg at FL 330, the acft was in clear wx, but lgt turbc contd for a time. After the turbc had stopped & there were no wx rtrns on the radar, the seat belt sign was turned off, although the capt…NTSB MIA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · West Palm Beach, FLThe plt stated that while enroute to West Palm Beach, she encountered severe turbulence. The aft cabin door popped open but remained attached and the flt was continued and lndd w/o further incident. As the plt attempted to restart the engs for the return trip…NTSB ATL88LA034Accident · Serious injuriesLimited investigationFinal reportBoeing 737-232 · Raleigh, NCThe acft encountered moderate to severe turbulence during the nighttime flt, when it passed through clouds momentarily at FL225. A flt attendant sustained a broken ankle. The captain rptd that radar gave no indication of any wx ahead prior to the encounter.…NTSB CHI88LA019Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Cumberland, WIAt 0112 CST, the plt telephoned the fss & requested a wx outlook for a 0600 CST departure. The wx briefer adzd the wx to the south was deteriorating & that the destn would be IFR by about the planned departure time. Also, the briefer suggested the plt could…NTSB DEN88FA023Accident · 3 fatalField investigationFinal reportCessna 172RG · Pintura, UTBfr takeoff, the plt was briefed abt lgt to mod rime icing in clds & precip abv the frzg lvl. The frzg lvl was forecast to be at 7000' to 9000' in the area of prescott, sloping downward to the north. The plt did not file a flt plan, but did rcv VFR flt flwg…NTSB MIA88LA026Accident · No injuriesLimited investigationFinal reportLearjet 35A · Orlando, FLThe acft made a hard ldg during heavy rain & after being advised of wind shear. The crew stated that at one point, the acft was thrown into a 60 deg bank with airspeed fluctuations plus or minus 20 KTS about 400 to 600 ft AGL. The plt stated that at 100 to…NTSB FTW88FA023Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Fulton, TXAcft departed in conditions of low ceiling and visibility with a student plt and pax on board. Witnesses at the arpt estimated the ceiling as 150 to 300 ft ovc with 1/8 to 1/4 mile vis in fog. After lift off the acft entered the fog in a rt climbing turn and…NTSB LAX88FA028Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Buttonwillow, CAA Piper PA-24-250 collided with terrain while on an IFR flight. The pilot received a wx briefing from fss. While en route, radio and radar contact was lost, then regained. The pilot stated to ATC that the acft had been struck by lightning. He elected to…NTSB SEA88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Snoqualamie Pss, WAThe pilot was advised that with his proposed route of flight VFR was not recommended due to low clouds and marginal visibility. The pilot elected to fly through the area at night and encountered low clouds and marginal visibility. While attempting to climb…NTSB FTW88LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Brownsville, TXDuring initial climb into IFR conditions, the non-multiengine, non-instrument rated mexican certificated private pilot diverted his attention from flying the aircraft to adjust the mixture control on the left engine. The aircraft impacted the ground and…NTSB LAX88FA020Accident · 1 fatalField investigationFinal reportCessna 208A · Fairfield, CAPilot's encounter with severe turbulence which precipitated a loss of aircraft control.NTSB FTW88LA020Accident · No injuriesLimited investigationFinal reportCessna 152 · New Caney, TXAcft took off in marginal VFR conditions on a pipeline patrol flt. En route, the plt encountered deteriorating wx conditions and experienced a rough running eng, due to what he suspected was carb ice. His attempts to remedy the roughness were unsuccessful and…NTSB FTW88FA009Accident · 2 fatalField investigationFinal reportCessna 172RG · Llano, TXThe pilot departed lubbock, Texas in VFR conditions. As the flight progressed the ceiling and visibility deteriorated and the pilot encountered instrument meteorological conditions. No evidence was found to indicate that the pilot obtained a weather briefing…NTSB SEA88FA011Accident · 3 fatalField investigationFinal reportCessna 180K · Walton, ORWitnesses observed the aircraft flying westbound toward a pass at a low altitude above the ground near the base of low stratus clouds. The aircraft struck a tree at the top of a ridgeline in mount/hilly terrain on a northeasterly heading, traveled 1/2 mile…NTSB DEN88FA014Accident · 1 fatalField investigationFinal reportCessna 340A · Bailey, COThe aircraft crashed on the side of a mountain during visual meteorological conditions. The pilot had been in voice and radar contact with air traffic control until the aircraft disappeared from radar. The pilot reported severe turbulence and a rough running…NTSB LAX88LA018Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Carpenteria, CAThe pilot encountered deteriorating weather as he approached his destination. After descending to 1,500 feet MSL, he attempted to follow a highway to the ocean but inadvertently encountered fog. The pilot attempted to turn, after spotting lights from houses…NTSB NYC88LA010Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Henryville, PAOn takeoff from a private airport, the flight encountered downdrafts and the left wing dropped. As the pilot attempted to level the wings, he realized that the aircraft was no longer climbing but descending at a rapid rate. The aircraft crashed on rising…NTSB FTW88FA006Accident · 3 fatalField investigationFinal reportCessna 172RG · Refugio, TXThe plt continued VFR flt into wx that was IMC. The acft impacted the terrain in an extremely nose low attitude. There was no record of the pilot receiving any pre-flt or in flight weather briefings or forecasts for this flight. A witness reported normal…NTSB ATL88FA010Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, SCThe plts trip home had been delayed one day due to wx enrt. He had called the fss early for a briefing and had been advised that there should be no trouble for a noon depart time. He deptd clemson about 1000 and activated his VFR flt plan. He then contacted…NTSB LAX88FA014Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Mount Baldy, CABfr tkof, the plt filed a VFR flt plan & rcvd a wx briefing which included an AIRMET. The AIRMET contained precautionaryinfo abt instrument conds (IMC), icing & mtn obscuration in calif. When the plt opened his flt plan with the fss, he wasagain briefed on…NTSB FTW88DQG01Accident · No injuriesFinal reportBoeing A75N1 · Fort Stockton, TXThe pilot stated that during the flare for a full stall landing in the tail wheel equipped aircraft, a whirlwind was encountered. He said he applied full power & full left aileron & rudder, but could not recover. Subsequently, the aircraft struck an…NTSB LAX88LA011Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Luis Obispo, CAThe non-instrument rated pilot became disoriented when he inadvertently flew into a layer of fog while making an enroute descent for landing at his destination. The aircraft collided with trees while the pilot was attempting to execute a climbing course…NTSB MIA88FA001Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Everglades City, FLThe non-instrument rated plt attempted a VFR flt over the Everglades during the hrs of darkness. The acft crashed into a swampy area at a high rate of speed while in a 90 degree left bank. The acft disintegrated on impact. A convective SIGMET was issued about…