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 NYC87LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Portland, METhe pilot of the PA-23 was attempting an NDB approach into the Portland, ME. Int'l jetport. The wx was rpt'd as moderate turbulence and moderate or greater icing, the icing level was rpt'd from the surface to 16000 ft. prior to this NDB approach the pilot had…NTSB LAX87DJA06Accident · Serious injuriesFinal reportSchweizer SGS2-33 · Mokuleia, HIDuring a local sightseeing flt along a ridge line, while maneuvering around a cloud build-up, the acft entered a windshear that suddenly nosed the acft over in an aprx 75 deg vertical dive. Just prior to colliding with trees, the plt was able to regain some…NTSB LAX87LA180Accident · No injuriesLimited investigationFinal reportCessna 182M · Mammoth Lakes, CAAt the end of a pleasure cross country flt, while on long final to the rwy, the plt had to add pwr to compensate for a crosswind. Prior to reaching short final the plt had reduced pwr again. Upon reaching the threshold, the acft was aprx 300 ft AGL. The plt…NTSB MKC87FA078Accident · 2 fatalField investigationFinal reportLake LA-4-200 · Nixa, MOThe normal procedure for operating at this airstrip was to always take off to the east and land to the west when winds were not excessive. Winds elsewhere in area were from southeast at 13 knots while at this strip, they were from the east at 30 knots. After…NTSB LAX87LA168Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZDuring a pleasure Balloon ride, the Balloon lifted off in a southerly direction then shifted to a south easterly direction. The plt felt that the balloons response time for adequate lift took too long. The Balloon began drifting toward 50 to 60 ft power…NTSB DEN87LA079Accident · No injuriesLimited investigationFinal reportNorth American Navion · Los Alamos, NMThe instructor plt was giving cross wind instruction to a pre-solo student plt. During a cross wind landing attempt, the acft touched down hard, breaking off the right main landing gear. The winds were observed at the time of touchdown to be 150 degrees at 12…NTSB DEN87FA081Accident · Serious injuriesField investigationFinal reportPiper PA-22-150 · Morgan, UTThe plt departed Morgan arpt with an acft near gross weight, in a relatively strong cross wind. After a successful takeoff at about 100 AGL, he said he encountered moderate turbulence and a downdraft. Altitude and airspeed could not be maintained. The acft…NTSB ATL87FA104Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Rhine, GAThe non-instrumented rated plt continued into an area of known wx conditions. The left wing separated in flight. Failure of it was typical of overload fractures. The wreckage was scattered over an area about 3500 feet long and 200 feet wide.NTSB ATL87LA103Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Oliver Springs, TNThe plt reported that the acft encountered heavy turbulence and a strong gusty x-wind close to the ground while on short final to his private airstrip. The plt attempted a go-around and encountered 'extremely heavy turbulence' during a turning climbout…NTSB CHI87FA106Accident · Serious injuriesField investigationFinal reportAirbus Industrie A300B4-203 · Indianapolis, INWhile cruising at ngt in clr air (well abv clds), eastern ai lines flt 477 was in light chop at FL 310 with the seat belt sign on. The captain stated that when the turbulence increased to a moderate cond, he made an announcement for the flt attendants (f/a's)…NTSB SEA87LA071Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Issaquah, WADuring a local training flight a downdraft was encountered. At about two miles from the airport the acft was at about 200 feet MSL. The instructor plt decided to land the acft on a field. On short final the acft struck a barbed wire fence prior to touchdown.NTSB DEN87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Cavalier, NDThe pilot was landing with a cross wind. The aircraft bounced and drifted into snow bank along the right edge of the runway. The nose gear was broken off in the collision with the snow bank and the engine was pushed into the firewall.NTSB MKC87IA066Incident · No injuriesIncident investigationFinal reportCessna 172 · Neosho, MOThe acft had just been purchased & was being ferried from st louis, MO to san carlos, CA. The plt rprtd he was flying from springfield to tulsa, when he encountered unforecast wx & elected to divert to Neosho or return to springfield. He began a left turn…NTSB LAX87LA152Accident · No injuriesLimited investigationFinal reportCessna 182Q · Palm Springs, CADuring a pleasure cross country flt, the aircraft encountered approximately 50 knot headwinds. The plt had diverted once to refuel and had expected to fly direct to the final destination. However, while enroute on the final leg of the flight, the aircraft was…NTSB LAX87LA160Accident · Serious injuriesLimited investigationFinal reportBalloon Works Barnes FF-8-24 · Phoenix, AZDuring a local sightseeing flight, the pilot reported that upon lift-off the weather conditions were clear and calm. During the flight, however, the wind conditions had increased from a westerly direction at a velocity of 12 knots, gusting to 15. The pilot…NTSB CHI87FA099Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Attica, INAfter completing a cable patrol flt, the plt landed at sullivan, IN, to refuel before starting a night flt to reposition the acft at lafayette, IN. The plt departed in clear wx. However, as he was arriving at lafayette, he advised the tower controller that…NTSB BFO87DIG02Accident · Serious injuriesFinal reportBoeing 727-200 · Charleston, SCThe flight encountered clear air turbulence at FL 350 during cruise flight. The pilot said he was aware beforehand of existing turbulent conditions. According to the plt the seat belt sign was on, the flight attendant and passengers were asked to be seated.…NTSB LAX87FA149Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Jamestown, CADuring the night cross country flt, the accident acft, in company with 2 others, was trying to land at the dest airport in hilly terrain. As the 3 acft approached the airport they encountered bkn to ovrcst conditions of about 400 ft AGL and vis of 2 mi in…NTSB FTW87LA082Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Midland, TXWhile penetrating a line of thunderstorms at 35,000 en route to Midland, TX, from dallas, TX, severe turbulence was encountered. One flight attendant had just sat down but had not fastened his seat belt and was thrown to the floor sustaining serious injuries.NTSB MKC87LA062Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mason City, IAThe pilot stated that he had obtained a full weather briefing and an IFR clearance from grand marais, Minnesota to des moines, Iowa prior to departure; and that the flight was uneventful, except for stronger than forecasted headwinds aloft. Enroute, the pilot…NTSB MIA87LA113Accident · Serious injuriesLimited investigationFinal reportKenny Deward B-8M · Escatawpa, MSWhile practicing power off landings downwind the flight encountered a gust at which time the pilot lost control. The aircraft descended rapidly striking the ground and then cartwheeling.NTSB FTW87FA078Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Kerrville, TXThe non-instrument pilot continued VFR flight into IMC conditions. The acft struck top of ridgeline while traveling at a high rate of speed and was demolished. No evidence of a pre-impact failure or malfunction of the acft was found.NTSB LAX87LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Saugus, CAUpon contacting ATC, the plt requested an ILS apch and that he was low on fuel. The controller cleared the plt to the ILS. Just inside the outer marker the controller advised the plt that he was dangerously low and to climb immediately. The plt was observed…NTSB DEN87FA066Accident · Serious injuriesField investigationFinal reportRockwell 680FL · Basalt, CON4581E was operating under 14 CFR 135 carrying cargo. The plt stated that he departed VFR and had '7 to 10' mi vis at the acdt site. Witnesses at and near the acdt site stated that heavy snow was falling at the time of the acdt and the vis was 1 mi or less.…NTSB ATL87FA087Accident · 1 fatalField investigationFinal reportCessna 150H · Oneida, TNThe pilot contacted the fss several times during the morning for weather along his proposed route of flight. Shortly after lunch he departed without a flight plan. He reported to one fss that he was VFR only but continued although VFR was not recommended for…NTSB ANC87LA045Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kotzebue, AKThe pilot stated that he encountered a complete whiteout condition and during the emergency landing on the frozen lake he lost directional control of the aircraft causing the left wing to strike the ground.NTSB DEN87LA065Accident · No injuriesLimited investigationFinal reportRaven S60A · Grand Lake, COThe balloon encountered turbulence during normal cruise at 100 to 150 feet AGL, while crossing a ridgeline. Gusts extinguished both burner plt lights and partially collapsed the envelope. The balloon began an uncontrolled descent. The plt re-ignited both…NTSB LAX87FA136Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Lebec, CAPrior to the flt, the plt rcvd 2 wx briefings & was adzd of low ceilings, restricted visibilities & mtn obscurement along the route. Also, he was adzd that VFR flt was not recommended. The surviving pax said that after entering the mtn area, they contd 'in…NTSB LAX87FA134Accident · 1 fatalField investigationFinal reportMooney M20J · Weed, CABefore takeoff, the plt was adzd that strong head winds, mod to svr turbc, mtn obscurement, multiple layers of icing & deteriorating wx were forecast along his route of flt. He filed an IFR clnc & took off at 1115 PST. While en route, he reqd the medford wx &…NTSB LAX87LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Oatman, AZAt the end of a cross-country flight, the pilot reported that while on final approach, the aircraft encountered moderate turbulence. The pilot set up for a full stall to land in a three point attitude. During the flare, a gust of wind from the right rear blew…NTSB LAX87FA142Accident · 2 fatalField investigationFinal reportCessna P206B · Green Valley, CAA Cessna P206B collided with mountainous terrain. Instrument meteorological conditions prevailed at the time. An unoffical weather observation taken the day of occurrence 12 miles east of the accident site indicated an indefinite 100 foot ceiling, 1/4 mile…NTSB LAX87FA121Accident · 4 fatalField investigationFinal reportBeech F33A · Anza, CAThe non-instrument rated plt & 3 pax planned a pleasure flt to mx. The weather was below VFR minimums however the plt elected to attempt the flt. Several minutes after departure the acft was observed to enter an area where it was snowing, the cloud base was…NTSB LAX87LA120Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Tucson, AZDuring a pleasure flight, the pilot reported that upon take-off, the wind was calm. While in-flight the wind increased and the pilot prepared for a high wind landing. The balloon touched-down hard and hit a bush. The pilot and one passenger were ejected from…NTSB ATL87FA074Accident · 2 fatalField investigationFinal reportCessna 182P · Crossville, TNThe rental acft collided with the top of a mountain at substantial airspeed in level flt. VFR flt was not recommended by fss due to low ceilings, rain and fog. No flt plan was filed. The plt had not logged a flt for a five month period prior to the accident.…NTSB MIA87LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar Key, FLThe plt was attempting to go around after landing fast, due to a tail wind that was stronger that anticipated. Unable to climb, the acft was then blown off the rwy, collided with trees, & came to rest in the gulf of Mexico.NTSB MIA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Smyrna Bch, FLWhile in cruise flt at an alt of aprx 800 feet the plt reported that the eng began to lose RPM. Unable to maintain alt a forced landing was made on a road. The acft then ground looped due to contact with scrub oak trees, which resulted in severing of the left…NTSB ATL87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Nashville, TNThe plt reported that he conducted an ILS appch behind mixed jet and turboprop traffic; the acft encountered an 'extreme downdraft' while on appch and the acft vertical speed went from about 500 fpm to about 1200 fpm. He attempted to recover by adding full…NTSB DEN87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Carrizozo, NMThe acft entered clouds over mountainous terrain. The plt's next visual contact was a mountain in his flt path. During maneuvering to avoid a crash the acft struck rough terrain and nosed over.NTSB MIA87FA084Accident · Serious injuriesField investigationFinal reportCessna 152 · Ochopee, FLThe student pilot while on a cross-country flight encountered poor weather conditions. During a turn and descent to maintain visual contact with terrain the aircraft collided with the ground.NTSB LAX87FA117Accident · 1 fatalField investigationFinal reportCessna 180J · Newhall, CABased on available evidence, it is believed that the accident occurred between 0700 and 0830 hrs during a period of low ceilings and restricted visibilities in the area where the accd took place. The accd site is located in a mountain pass area between two…NTSB BFO87FA022Accident · 2 fatalField investigationFinal reportRobinson R22 · Myersville, MDThe non-instrument rated commercial pilot departed hgr in a Robinson helicopter that was not equipped to fly in instrument conditions. The pilot had not logged any instrument time and elected to depart in IFR conditions under a special VFR clearance. ATC…NTSB CHI87FA070Accident · 3 fatalField investigationFinal reportMooney M20J · Waskish, MNDuring the preflight wx briefing the non-instrument rated pilot was advised that VFR flight was not recommended. Shortly before the accident, the acft was observed flying over a state highway under a low overcast in poor visibility. The acft was witnessed to…NTSB LAX87LA109Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Vacaville, CADuring a local sightseeing flight, the pilot was flying south approximately 300-500 ft above the ridge looking for lift. The pilot could not find sufficient lift in the area east of the ridge so he flew to the west side where the glider encountered a strong…NTSB FTW87FA064Accident · 2 fatalField investigationFinal reportCessna 210N · Diboll, TXAcft was destroyed when it impacted the ground in an uncontrolled attitude at high speed. The non-instrument rated pvt plt had filed IFR and departed into M80VC 5 l-f weather with tops above 8,000'. About 20 minutes after departure, the plt reported to the…NTSB CHI87LA079Accident · No injuriesLimited investigationFinal reportCessna 150K · Clear Lake, MNThe plt stated that near the touchdown point a gust 'jarred' the acft and the throttle in the forward position. According to the plt, the acft 'took a steep left' and he leveled the wings, however there was not time to avoid trees which were about 100-150…NTSB FTW87FA059Accident · 2 fatalField investigationFinal reportSikorsky S-76A · Angleton, TXShortly after tkof, the plt contacted his company (opns) & said he had inadvertently enctrd IFR conds. He asked opns to relay info to him fm the apch plate for the ILS rwy 17 apch to brazoria county arpt. After rcvg the info, he contacted houston apch ctl &…NTSB DEN87FA050Accident · 1 fatalField investigationFinal reportCessna TR-182 · Moran, WYThe pilot received several weather briefings prior to departure. Briefings included reports of icing conditions, low clouds and turbulence. VFR flight was not recommended. Plt departed VFR and filed IFR enroute to jackson. The pilot was issued instructions…NTSB LAX87FA103Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Gualala, CAThe student plt, flying his own acft, took off under VFR conditions for an intended 45 min solo cross country flt. The plt encountered deteriorating wx & attempted to return to the departure airport. A witness observed the aircraft enter clouds, turn left &…NTSB LAX87FA102Accident · 2 fatalField investigationFinal reportCessna 172P · Cuyama, CAThe plt rcvd a preflt briefing before a morning dep fm monterey. At that time, the forecast was for 3000' to 5000' broken clouds with widely scattered rain showers by 1600 & with a gen outlook of VFR. The plt flew to santa barbara to attend a meeting & depd…NTSB DEN87LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Taos, NMThe non-instrument rated plt inadvertently flew into IMC wx; snow, fog, freezing temperatures and low visibility, in mountainous terrain. He made a forced landing on a trail due to lowering visibility, 15 miles southwest of the destination arpt. The terrain…