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 ATL87FA243Accident · 1 fatalField investigationFinal reportAero Commander 112 · Middlefield, OHOn the previous flt, the plt made two unsuccessful IFR approaches before landing on the third attempt. The pax- configured acft was loaded with cargo. The plt filed an IFR flight plan and departed the arpt. Radio contact was established with ATC and the plt…NTSB DEN87FA226Accident · 1 fatalField investigationFinal reportCessna 172RG · Cubero, NMThe plt rcvd a wx briefing prior to departure. VFR flt was not recommended by the briefer. N5247V departed at 2005 hrs and at 2200 hrs the plt radioed abq ARTCC that he was descending from 9000 ft to 7500 ft to avoid wx. ARTCC radar track was lost shortly…NTSB NYC87LA239Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Bingham, METhe plt rprtd he was taking off from a lake & was climbing thru about 200-300 ft AGL when the acft enctrd a severe downdraft. Subsequently, the float plane collided with rising terrain. No preimpact part failure or malfunction was rprtd. The plt rprtd the…NTSB ATL87FA235Accident · 1 fatalField investigationFinal reportCessna 172A · Camilia, GAThis flt had been delayed several days due to poor weather in the area. On the day of the flt the plt waited until the local area fog had dissipated before departing the private air strip. The acft was heard above the clouds about five miles from the crash…NTSB ANC87LA121Accident · No injuriesLimited investigationFinal reportCessna 170 · Mi.70 Glenn Hwy, AKThe pilot stated the weather was deteriorating with visibility less than one mile and rainshowers. The pilot elected to make a precautionary landing on a state highway. During the landing roll the aircraft struck a road sign with the right wing of the…NTSB ATL87LA229Accident · Minor injuriesLimited investigationFinal reportBell 47G (TOM CAT) · Dothan, ALThe plt rprtd that while he was making a turn-around over trees after the 1st swath run, the helicopter enctrd a sudden wind change. He stated that the wind cond was from a cumulus buildup which put him in a tailwind situation. As he completed his turn with…NTSB DEN87FA213Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Last Chance, COWhile on a cross country flt the plt encountered IFR conditions and was neither trained nor qualified to fly IFR. Attempts by ATC to assist the plt and route the flt to an arpt were unsuccessful. The plt lost control of the acft and crashed in a field, the…NTSB LAX87LA297Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Redding, CADuring an air race, the plt was attempting a landing when on final approach the acft flew through updrafts. The plt landed the acft aprx 600 ft from the threshold and applied heavy braking. Just prior to running off the runway the pilot added full power and…NTSB ANC87FA115Accident · 1 fatalField investigationFinal reportPiper PA-18A · Coldfoot, AKThe pilot had unsuccessfully attempted to fly through atigun pass earlier in the day. Even though the pass was closed due to fog and cloud cover, the pilot attempted to fly through the pass a second time. The aircraft wreckage was locatedin atigun pass. The…NTSB FTW87FA183Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Kokomo, INThe plts preflt wx briefing revealed marginal VFR & IFR wx along his proposed route, with a precaution for thunderstorms. An IFR flt plan was filed and the acft departed. Later during flt the plt was radioed info about a convective SIGMET that contained a…NTSB ANC87LA113Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Happy Valley, AKThe aircraft struck the mountain at the 4000 foot level. At the time of the accident several witnesses stated that the weather was IFR, low ceiling, ground fog, and the prevailing visibility was less than one mile.NTSB SEA87FA149Accident · 4 fatalField investigationFinal reportAero Commander 560-A · Ashland, ORThe non-instrument rated pilot took off in overcast weather conditions and flew toward a mountain pass that was obscured in clouds. When the flight failed to arrive at the destination, a search was initiated and the wreckage located in a box canyon on the…NTSB SEA87FA145Accident · 2 fatalField investigationFinal reportCessna T210N · Avery, IDWhile in cruise at 15000 ft MSL, plt requested ATC deviation around tstm shown on acft stormscope. After passing, ATC gave vector to rejoin airway. Plt requested further deviation around another cell. Radio and radar contact were then lost. Investigation…NTSB DEN87FA188Accident · 1 fatalField investigationFinal reportCessna 210 · Coaldale, COThe ATP rated pilot was an airline captain on a Boeing 727 aircraft. However, the pilot had accumulated a total of only 140 hours in single engine aircraft with 20 hours in the Cessna 210. Moderate to severe turbulence had been forecast and reported in the…NTSB SEA87LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ashland, ORPlt was proceeding VFR, no flt plan, no record of wx brief, northbound through siskiyou pass along I-5 from calif into Oregon about 1400 PDT. Plt reported suddenly in clouds, then saw trees. Acft collided with rising terrain 1/2 mile west of point where I-5…NTSB NYC87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencer Lake, METhe flight originated at Spencer Lake and flew north then south to baker lake. South of hedgehog mountain the flight encountered downdrafts and a loss of altitude at 500-600 feet per minute. Upon turning right to return to Spencer Lake the aircraft continued…NTSB LAX87FA267Accident · 4 fatalField investigationFinal reportCessna T210L · Marina Del Rey, CAWeather at dept airport was clouds at about 900 ft with tops at 2,400 ft. based on ATC transcripts and the recorded radar flight path, the flt entered the clouds about 1 mile from the end of the runway. Shortly thereafter the flt entered the los angeles tca.…NTSB NYC87FA204Accident · 4 fatalField investigationFinal reportPiper PA-30 · Lincolnville, METhe plt was making an approach to knox county arpt, rockland me and after receiving a wx report from UNICOM that the local wx was below approach minimums he indicated that he would make a missed approach. There was no further communications from the acft. A…NTSB NYC87LA201Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Huntingdon, PAThe flight encountered poor visibility while at cruise altitude. The pilot decided not to continue flight and landed on a football field. During roll out, the right main gear fell into a drain hole to the side of the field causing the aircraft to turn right…NTSB MIA87IA204Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Washington, DCDrg arr, the acft's radar showed tstms in the area of the arpt. As the flt contd, ATIS info chgd. When the plts ctcd Washington apch ctl with old ATIS info, the ctlr did not correct the flt. They were adzd of hvy rain, strong wnds & a PIREP of wndshr nr the…NTSB DEN87FA178Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Hayden, COThe plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a…NTSB DEN87FA177Accident · Serious injuriesField investigationFinal reportCessna 152II · Parker, COThe instructor plt and his new student were on a local training flt when they encountered adverse wx. The instructor said that he attempted to turn back to the arpt but the winds forced the acft down until it impacted the ground.NTSB BFO87FA046Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Abingdon, VAFss advised the plt that VFR flight was not recommended due to obscured mountains along the flight route. There also were thundershowers west of the flight route. The plt said he had to leave to stay ahead of the thundershowers. He said that he would fly the…NTSB NYC87DNC06Accident · 1 fatalFinal reportEnstrom F-28A · Mason, NHThe loss of aircraft control after the tail rotor struck the trees and departed the aircraft. The pilot's poor judgement in flying in weather conditions beyond his capabilities was a factor.NTSB DEN87LA163Accident · No injuriesLimited investigationFinal reportCessna 182M · Livingston, MTThe plt and an observer were conducting a search and rescue flt near the face of crazy mountain. The plt reported encountering a downdraft and the acft inadvertently stalled. The acft hit trees near the ridge line.NTSB ATL87LA193Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Hamilton, OHThe plt rptd that he made a non-std rt-hand departure after t/o from rwy 29, to avoid traffic departing to the left. The acft began to sink as he attempted to climb over the lee side of a 200 ft-high ridge less than 1 mile northwest of the arpt. The acft…NTSB ATL87FA187Accident · 1 fatalField investigationFinal reportBeech V35A · Augusta, GAThe plt ctcd apch ctl for radar svc & wx info. The destn arpt had hvy rain & thunderstorm activity, but the plt rprtd he had the arpt in sight. Radar svc was terminated & the plt began a visual apch. Witnesses rprtd the visibility dropped to 1/2 mi in hvy…NTSB CHI87DET07Accident · 1 fatalFinal reportMcentee Stitsplaymate SA-11A · Rolling Prairie, INAircraft crashed in open rising field killing pilot and destroying aircraft. Homebuilt aircraft was not ifr-equipped or certified. Pilot had less than ten hours on aircraft. No flight plan filed. No record of weather briefing, or in-flight weather advisory.…NTSB ATL87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCThe acft encountered a strong downdraft in a thunderstorm and impacted the water during a beachside banner towing operation. The plt reported that he had observed thunderstorms developing inland about 1/2 hr prior to the accident and that his acft was…NTSB ATL87FA174Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Asheville, NCDuring a personal night x-country VFR flight over mountainous terrain the plt was informed by ATC that vip level 3 and 4 thunderstorms were positioned across the intended flt path. The 128 hour non-instrument rated private plt acknowledged and continued the…NTSB ATL87LA165Accident · No injuriesLimited investigationFinal reportCessna 172G · Steubenville, OHPIC rpted he flew over airport and noted wind direction as 290-300 degrees on wind indicator. He entered downwind for rwy 31 at uncontrolled field. Normal approach flown with full flaps on final with left crosswind correction. About 30-40 feet above rwy, acft…NTSB LAX87LA231Accident · Serious injuriesLimited investigationFinal reportMooney M-18L · Maricopa, CADuring a pleasure flight the plt stated that while on final approach to a private airstrip, he noticed some turbulence. On short final the plt stated that a severe wind shear dropped the acft into a ravine. The plt added full pwr, however, the acft did not…NTSB LAX87LA223Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oxnard, CAThe pilot departed Oxnard arpt on a VFR flt to whitemant arpt, los angeles, CA. Grnd witness obsvd the airplane enter clouds and fog after crossing the western edge of the arpt boundary. The airplane was then obsvd in a descending left turn south of the arpt.…NTSB SEA87LA107Accident · No injuriesLimited investigationFinal reportAerodynamics . Hawk Mkii · Ellensburg, WADespite warnings from the flight service station about turbulence, high winds aloft, severe low level wind shear, and low ceilings along the pilots intended route of flight, the pilot elected to depart the airport for his destination. Standing lenticular…NTSB SEA87LA105Accident · No injuriesLimited investigationFinal reportBeech BE18 · Glenns Ferry, IDWhile at crz, plt encountered turbulence. Shortly thereafter, experienced elevator control difficulties and yoke vibrations. Plt declared emerg, requested vector to closest airport. Mtn home afb rapcon gave vector to Glenns Ferry airport. On approach, plt…NTSB ATL87LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Erwin, NCThe acft impacted level grassy terrain short of rwy 04, while on short final during a practice short-field ldg. The CFI reported that the student plt had stabilized the acft on the appch at 70 mph; a high sink rate was subsequently encountered as the acft…NTSB SEA87FA102Accident · 3 fatalField investigationFinal reportSocata TB10 · Battle Mountain, NVAfter receiving a weather briefing calling for mountains occasionally obscured, occasional moderate icing from 18000 ft & below, and ceilings across north & central Nevada, the noninstrument rated pilot filed a VFR flight plan and departed salt lake city for…NTSB LAX87LA215Accident · No injuriesLimited investigationFinal reportCessna 150F · Bermuda Dunes, CAThe flt encountered strong head winds while cruising x-country at 6000 ft MSL. The engine lost power aprx 14 miles east of the intended destination and during descent toward the destination the power returned several times but could not be maintained. The…NTSB LAX87FA212Accident · 1 fatalField investigationFinal reportRockwell 114 · Los Gatos, CADrg a preflt wx briefing, the plt was adzd the forecast for oakland (19 mi nnw of his destn) was for a 3000' broken ceiling with occasional 3000' scattered, 5000' broken & a chance of light rain showers. He filed a VFR flt plan & depd. At 1347 PDT, the plt…NTSB NYC87DNC10Accident · 1 fatalFinal reportHuffman Quickie Q2 · Peterborough, NHAt 0939 EDT, the acft departed syracuse, NY, on a flt to nashua, NH. Subsequently, it was rprtd missing. A search was initiated, but the acft was not found until it was discovered by a hiker aprx 2 months later. The acft had crashed below a mtn top near…NTSB FTW87FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Porter, OKAcft was observed in a rt bank when it experienced an inflt breakup. Both wings, vert stab and rudder, and the horz stab and trim tab separated prior to impact. Wx was dark night with scattered to broken cloud cover, but VFR. Although a wx rpt 33 NM northwest…NTSB ATL87LA146Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sparta, NCThe plt attempted a precautionary ldg at a private grass airstrip he had located, after being advised of wx at his intended destination by ATC. Just prior to touchdown, he observed a balloon at mid-field and excuted a go-around. During climbout, he lost sight…NTSB MKC87FA106Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Sioux City, IAThe PIC had telephoned the fss at huron, s.d. for enr wx to Sioux City, IA, fm Sioux falls, s.d., late the evening of may 20. The fcst indicated IFR flt cond's with intermittent trsms along the rte throughout the fcst period. The PIC dptd Sioux falls, s.d. at…NTSB DEN87FA130Accident · 3 fatalField investigationFinal reportPiper PA-31T-620II · Cody, WYN2336X was on a business flt to Cody, WY. The pilot executed a missed approach on the first attempt of the vor-a approach. A pilot who landed at Cody minutes before the accident said the visibility had decreased to 3/4 of a mi when N2336X made the first…NTSB ATL87FA142Accident · 4 fatalField investigationFinal reportCessna T337G · Oxford, OHThe pilot was advised against attempting a visual flight with rain and thunderstorm activity along the intended route of flight. Approach control instructed him to maintain visual conditions and not to enter the clouds. The pilot lost control of the aircraft…NTSB ATL87DMG01Accident · No injuriesFinal reportGrumman G-164B · Beaufort, NCThe plt had just loaded the hopper with dylox chemical. As the acft became airborne, the plt stated, he experienced wind shear and the acft rolled to the right. The plt corrected by leveling the wings and immediately experienced a second more violent wind…NTSB DEN87LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Big Sky, MTThe private plt was flying cross country in deteriorating weather conditions. Fog was forecast and light rain was in progress. The flt encountered less than VFR conditions in a mountainous area and reversed course. Weather was below VFR on the reverse course…NTSB ANC87FA067Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Nightmute, AKThe aircraft was destroyed when the aircraft struck a 350 foot high hill along its route. This flight was a part 135 on-demand air taxi cargo flight. Several other air taxi operators and company aircraft elected to cancel their flights. Both ground reports…NTSB ATL87FA132Accident · 2 fatalField investigationFinal reportAeronca 7BCM · Georgiana, ALThe plts & pax of 2 acft were returning from an annual pleasure trip. Neither acft had a good comm radio. Shortly after takeoff, they enctrd fog. They flew above the wx until they were near their 1st refueling stop (greenville, AL). Both plts dscndd beneath…NTSB LAX87FA196Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Newhall, CAAt about 1440 PDT, the non-instrument rated plt depd antioch CA, on a flt to burbank, CA. No known in-flt communicationswere made until the plt contacted TRACON at 1725 PDT. At that time, he rprtd inbound at 7500' & requested a special VFR clnc to the arpt.…