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 LAX83FA083Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-60 · Scottsdale, AZThe acft diverted from Scottsdale AZ to a flt course to sedona because of thunderstorms & high winds at Scottsdale, but after a radio conversation with Scottsdale twr, the plt decided to reroute to land at Scottsdale. The plt did not read back the weather…NTSB DEN83LA054Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Jamestown, NDWhile en route, the plt encountered freezing rain and climbed to aprx 3500 ft to be on top of all weather. When he throttled back, the engine began surging and would not produce enough power for level flight. The pilot knew that the ground level in that area…NTSB DEN83FA053Accident · 4 fatalField investigationFinal reportCessna T210N · Minersville, UTThe acft impacted in a near vertical attitude near the top of a mountain & adjacent to a highway where witnesses had observed the acft flying at very low altitues under a low ceiling. There was no record of a preflight wx briefing or inflight advisories. No…NTSB ATL84LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe acft recontacted the ground during takeoff and bounced several times before coming to rest. The propeller, nose strut and firewall were damaged. The wind was reportedly from 250 degrees at 14 KTS gusting to 26 KTS. The ATC controllers on duty said the…NTSB LAX83FA438Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Redlands, CAAt 0638 PST, the plt received a wx briefing on a flt to sacramento, CA, and was advised that VFR was not recommended. At 0800, he received another briefing & filed a VFR flt plan to palm springs, CA. During flt, he advised palm springs tower that if he could…NTSB CHI83FA089Accident · No injuriesField investigationFinal reportCessna 172 · Rockford, ILThe acft collided into the 2nd floor of a building while making an ILS approach to runway 36 at Rockford, IL. The weather was IMC. An IFR flight plan was filed. A pilot weather briefing was not given. The pilot was instrument rated. An approach was attempted…NTSB LAX83LUQ01Accident · 2 fatalFinal reportCessna 152 · Castaic, CAAbout 3 hrs after he took off, the plt called burbank tower & advised he was lost & was at 4000 ft, heading southbound. Tower personnel advised him to contact burbank apch control on 121.5, but received no acknowledgement. A few minutes later, a helicopter…NTSB CHI83FA090Accident · 2 fatalField investigationFinal reportPiper PA-22-20 · Siren, WIWitnesses heard a sound of an acft eng, but because of low clouds & fog they could not see the acft. They heard the sound of the eng, a loud roar, the breaking of trees, & thena 'bang.' They then found the acft which had penetrated a wooded area at a 70 deg…NTSB FTW83FA097Accident · 2 fatalField investigationFinal reportBell 206L-3 · Goliad, TXThe helicopter collided with trees and the ground in an attempt to reverse directions at low alt & at night after encountering weather. The plt had received a weather briefing and knew the weather was bad with low ceilings and fog. Heradioed he could make it…NTSB ANC83FAG03Accident · 3 fatalFinal reportCessna A185F · Nyac, AKThe aircraft crashed after colliding with a tree near the destination airport at Nyac, AK. The pilot had tried this flight from aniak to Nyac the day before and had returned to aniak because of weather. The weather at the time of the accident was snowing and…NTSB ATL83LA089Accident · No injuriesLimited investigationFinal reportCessna 182M · Columbia, SCDuring arrival, the pilot entered the traffic to land at owens field, an uncontrolled airport. He stated that the wind sock was limp despite a weather briefing to expect northwesterly winds at 8 to 20 KTS. He stated that he had allowed for strong winds by…NTSB LAX83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Barstow, CAThe acft was damaged in an off arpt precautionary landing after an encounter with weather. The student pilot had left onthe second leg of a cross-country flt without checking the weather over the remaining route. Enroute he decided the weather was bad and…NTSB DEN83FA049Accident · 1 fatalField investigationFinal reportRobinson R22 · Sisseton, SDThe helicopter crashed in an open field shortly after takeoff in adverse weather. The pilot was not instrument rated andhad received weather briefings by telephone from a flight service station. The forecast was not favorable, but the pilotstated 'well I…NTSB FTW83LA090Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Belle Chase, LAThe acft encountered fog during landing rollout, the pilot lost control and ran into a fence. The air taxi pilot had off loaded his passengers at new orleans and was ferrying the acft to the accident arpt at Belle Chase la. The pilot wasnot injured in the…NTSB CHI83LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 RG · Green Bay, WIThe acft collided with the ground during an ILS approach. The weather was IMC at the time and an IFR flt plan was filed. The pilot was instrument rated and had received a weather briefing which forecast icing and freezing drizzle. The pilot told the weather…NTSB CHI83LA078Accident · No injuriesLimited investigationFinal reportMooney M20A · Ashkum, ILThe pilot made a precautionary landing in a plowed field during a ferry flight because of lowering ceiling and darkness,during the landing the gear collapsed from overload. The pilot was delayed in his departure for maintenance and service. Increasing clouds…NTSB SEA83LA209Accident · 2 fatalLimited investigationFinal reportBellanca 14-19-3 · Goldendale, WAThe pilot's inadequate preflight and in-flight planning, which resulted in flight into adverse weather conditions and clearance from trees not maintained. Factors contributing to the accident included the clouds, low ceilings, and turbulence.NTSB SEA83LA039Accident · Serious injuriesLimited investigationFinal reportBoeing 727 · Near Yakima, WADuring a climb to cruise, one passenger was injured when turbulence was encountered at about 20,500 ft MSL. The injured passenger was a 73 year old male, a retired priest and the only passenger not seated and wearing a seatbelt. As he exited the restroom, the…NTSB LAX83LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bakersfield, CAThe non-instrument rated pilot received a weather briefing before take-off and was advised that VFR flight was not recommended. During arrival at night, he circled twice over the airport and noticed that the runway lights were clear, then entered the pattern…NTSB NYC83FA049Accident · 2 fatalField investigationFinal reportPiper PA-30 · Atlantic City, NJThe plt had landed at Atlantic City, NJ at aprx 1545 while en route to oxford, CT. Before taking off, he contacted two fss's and both advised that VFR flt was not recommended. The non-instrument rated plt took off at aprx 1920 local time with no flt plan. At…NTSB CHI83FA076Accident · 3 fatalField investigationFinal reportCessna 172M · Hanover Park, ILThe aircraft crashed in an open field about one and one half miles from the departure airport. The weather was IMC with low ceilings and visibilty in fog and snow. There was no record that the pilot received a weather briefing. Ground witnesses near the site…NTSB SEA83FA038Accident · 5 fatalField investigationFinal reportCessna T303 · Willard, WABefore takeoff, the plt received a wx briefing & filed an IFR flt plan to Idaho falls, id at 1300 ft. he took off at 1804 PST. At 1814 PST, just prior to calling level at 13,000 ft, he reported he was encountering light turbulence & light rime ice. Aprx 4 min…NTSB DCA83AA010Accident · 2 fatalFinal reportCanadair CL-600-1A11 · Hailey, IDThe acft crashed into the side of a mountain ridge during a VFR attempt to land at an arpt with no instrument approach. The mountain ridge was obscured by broken clounds. The plt had cancelled his IFR clearance, & during the descent to the arpt, he had…NTSB FTW83IA072Incident · Minor injuriesIncident investigationFinal reportMcdonnell-Douglas DC-10-30 · Thermal, CAAt about 1458 PST, the aircraft encountered moderate to severe clear air turbulence for a period of 8 to 10 seconds while climbing through 35,500 ft. seven passengers and seven flight attendants received minor injuries. The seat belt sign had been turned on…NTSB MKC83FA046Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Bates City, MOThe aircraft crashed about 8 mi east of the departure airport after the non-instrument rated pilot took off on a dark night with fog and a low ceiling. The weather at the nearest reporting station was in part: 600 ft overcast, visibility 6 mi with fog.…NTSB FTW83LA067Accident · No injuriesLimited investigationFinal reportBeech C23 · Childress, TXDuring flight, freezing rain was encountered which began to accumulate on the windshield and wings. The pilot reported that he checked and found that the clouds had closed in behind. He diverted to Childress, TX. While en route, additional ice accumulated on…NTSB FTW83FRD01Accident · 3 fatalFinal reportPiper PA-28R-200 · Henderson, LAThe pilot and two passengers were on a flight from beaumont, TX to covington, LA. The non-instrument rated pilot departed on a special VFR clearance. At that time, the weather at beaumont was 300 ft overcast, visibility 12 mi. When the aircraft was about 10…NTSB FTW83FA087Accident · 7 fatalField investigationFinal reportPiper PA-32-300 · Animas, NMThe acft departed ague prieta, sonora, Mexico with no flt plan on a flt to janos, chihuahua, Mexico. Drg departure, the plt's son observed a dark threatening cloud bank in the direction of flt near a mtn range. When the acft did not arrive at the destination,…NTSB CHI83LA065Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot took off with an estimate 4 hrs of fuel on board. While en route, he encountered headwinds that were stronger than expected. After about 3 hrs and 48 min of flight, he was still about 27 to 28 mi from his destination and diverted to the Dayton…NTSB MKC83FA044Accident · 1 fatalField investigationFinal reportCessna R182 · 1 1/2 Mi.N. May, KSThe pilot received wx briefings at 1114 & 1220. He was advised against VFR flt due to low ceilings & visibilities in western Missouri, eastern & northeastern Kansas. At 1300 the plt received a special VFR clearance to depart. At 1330 witnesses observed the…NTSB FTW83FA066Accident · 3 fatalField investigationFinal reportBell 206B · San Antonio, TXThe acft departed brackettville at 0715 & at 0740 contacted uvalde UNICOM for their wx. When informed that uvalde was "zero-zero" the flt continued east. The acft was later observed & heard flying above the low indefinite ceiling shortly before impacting the…NTSB FTW83LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Nash, OKPilot encountered fog and decided to land in a wheat field looked frozen but was soft and aircraft nosed over. There were 3 local airports within 20 miles.NTSB SEA83FA033Accident · 2 fatalField investigationFinal reportBell 214B · Near Randle, WAThe acft departed a private heliport & impacted a mountain at the 3,400 ft level. The wreckage was located about one mile east from the heliport. The impact site was hidden behind a ridge & is not visible from the heliport or the access road to the heliport.…NTSB CHI83LA061Accident · No injuriesLimited investigationFinal reportCessna 310R · Gaylord, MIPrior to a flight from charleston, WV to sault ste marie, MI, the pilot was briefed to expect icing conditions. During the flight, mixed and rime icing conditions were encountered; however, the deicing equipment removed it satisfactorily. An update weather…NTSB SEA83FYM02Accident · 2 fatalFinal reportEnstrom 280C · North Plains, ORAt about 0530 PST, the pilot departed from his home at ridge field, WA on a flight to hillsboro, OR. According to the pilot's instructor, the normal route used for this trip would been to proceed on a southerly heading to cornelius pass, go through the pass,…NTSB SEA83LA032Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Chemult, ORThe flt encountered heavy snow enroute & the eng quit. During the autorotation the plt maneuvered to avoid hitting a railroad signal trestle but struck several railroad signal cables & crashed. The acft was not equipped with a particle separator, nor was the…NTSB NYC83FA041Accident · 1 fatalField investigationFinal reportCessna 177B · Starrucca, PADuring a weather briefing before takeoff, the student pilot was advised of icing conditions, turbulence, snowshowers and snow squalls along ridges north of the wilkes-barre/scranton, PA area. The weather briefer indicated that VFR flight was not recommended.…NTSB LAX83LA058Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Merced, CAThe transcript revealed that the plt was cleared for an ILS rwy 30 apch approximately 2 mi from the outer marker. The wx given to the plt at that time was indefinite ceiling zero, sky obscured & visibility zero with fog. The plt stated an instrument apch was…NTSB ATL83FA060Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Summerville, WVOn 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…NTSB LAX83IA056Incident · No injuriesIncident investigationFinal reportCessna 551 · Near Palm Sprin, CAShortly after takeoff and climbout, the autopilot malfunctioned after the aircraft entered an overcast and encountered rain and turbulence. The pilot returned to bermuda dunes, CA. After landing he had the electrical, avionics and auto pilot systems checked.…NTSB LAX83FA414Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Tahoe City, CAThe owner, a student plt, & an ATP plt departed olympia, WA at aprx 1111 PST on a flt to the lake Tahoe/reno area. When the acft did not arrive, a search was made until 12/22/82. On 8/28/83, the acft was found where it crashed on rising terrain (50 deg slope)…NTSB DEN83AA033Accident · 2 fatalFinal reportBell 206B · Larkspur, CON2752Y, a Bell 206B helicopter, crashed in hilly terrain while on a flt to obtain video tape news of an aircraft accident. Plt was warned by FBO personnel of adverse wx conditions. Another plt who had just landed tried to persuade the plt not to fly. After…NTSB FTW83FA054Accident · 2 fatalField investigationFinal reportBeech A36 · Midland, ARWhen the plt filed his VFR flt plan he was observed using an IFR enroute chart. About 7 minutes after takeoff the plt requested a frequency to call for a clearance to climb on top of the overcast. Approximately 5 minutes later, as the plt was giving his…NTSB ATL83IA050Incident · No injuriesIncident investigationFinal reportBoeing 737-201 · Winston-Salem, NCThe flt from buffalo was reported as choppy & the chop continued during the descent. Wx was noted on the airborne radar sw & nw of the arpt. As the acft approached the outer marker the crew observed cloud to ground lightning near the arpt & were infromed that…NTSB MKC83LA031Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Near Vichy, MOWhile enroute from cape girardeau, MO to rolla, MO, the pilot encountered an area of low ceilings and fog. While he was trying to remain VFR at low altitude, the aircraft struck trees on top of a hill. The pilot climbed abruptly, but the plane stalled,…NTSB NYC83LA038Accident · Minor injuriesLimited investigationFinal reportMooney M20F · North Caldwell, NYThe pilot stated that he encountered a fog bank while making a straight in landing at essex county airport. The pilot attempted to climb and still maintain visual contact with the ground, however the aircraft collided with a tree.NTSB CHI83FA050Accident · 1 fatalField investigationFinal reportCessna 177 · Medina, OHAt about 1430 EST, the pilot took off from freedom field, Medina, OH in VFR conditions. When he returned about 3 hrs later at dusk, the weather was estimated to be: 400 ft overcast, 3/4 mi visibility with fog. A flight instructor heard the plane fly over the…NTSB LAX83FUG07Accident · 3 fatalFinal reportCessna 172N · Near Rialto, CAThe pilot and his passengers had flown from van nuys, CA to palm spring, CA during the afternoon. After arrival, they spent several hours on the ground. At 1740, the pilot called a fss to obtain a weather briefing for a flight to concord, CA. During the…NTSB LAX83FA047Accident · 3 fatalField investigationFinal reportCessna 172N · 12nm East Of An, CADuring the preflight wx briefing from thermal fss the plt was advised that VFR flt was not recommended into the san diego area. Although the plt requested a briefing to san diego, it is believed that the initial destination was carlsbad to deplane the rear…NTSB LAX83FA042Accident · 2 fatalField investigationFinal reportCessna 152 · Ramona, CAThe aircraft crashed into rising terrain at the 3500 foot level in IFR weather. The pilot had been advised of bad weather along his route. His flight plan was VFR. No malfunctions to equipment was found.