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 NYC84FA074Accident · 3 fatalField investigationFinal reportCessna P210N · Groton, CTThe acft was blown off course during a procedure turn for an ILS approach. The plt made a missed approach because of themisalignment and tried a non standard means of orientation for the 2nd attempt and intercepted the middle marker unexpectedly. Radar shows…NTSB FTW84LA118Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Venice, LAAbout 10 min after departing an offshore platform, the plt encountered an area of fog. He descended to aprx 200 ft, slowed to 40 KTS & started turning back. As he was turning, he was looking to the right to locate a petroleum production facility to use as a…NTSB LAX84LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Kelseyville, CAThe plt became disoriented while in IMC and could not locate the arpt. The ple stated that due to lights on the ground he thought that he was over the peninsula, which is an area of low terrain. He attempted a 180 deg turn after descendingto 500 ft MSL. The…NTSB LAX84FA152Accident · 1 fatalField investigationFinal reportCessna 182Q · Soledad, CAThe acft crashed into the side of a hill at about 1500 ft MSL in a 50 degree nose down attitude. The plt had encounteredweather on a night VFR flt. He was attempted to return the acft for a scheduled club flt the next morning. He had previously planned an…NTSB DEN84IA070Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · Durango, COAccording to the captain, the coplt was making the landing & crossed the threshold at 50 to 60 ft AGL at 110 to 115 KTS. He said a slightly higher airspeed was used to compensate for a small abount of ice that remained on the leading edge of the wings. In the…NTSB ATL84LA081Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Dalton, GAPlt received a wx briefing aprx 1 hr prior to flt during which '...a chance of light icing' was forecast. Aprx 30 mins after takeoff at 6000 ft MSL light rain was encountered. The plt stated that a small amount of ice began to form on the strut and he…NTSB LAX84FA142Accident · 3 fatalField investigationFinal reportCessna 182R · Yorba Linda, CAThe acft was seen to descend in a near-vertical high speed descent out of the clouds and disappear into a canyon. A search party found the acft on the floor of the canyon. The acft had departed an arpt 18 miles away on a VFR x-country flight. Investigation…NTSB FTW84LA116Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Vencie, LAAccording to the plt, he took off from a came site to pick up duck hunters at several locations. During the flt, he encountered fog & turned toward venice, LA to land. He then saw an oil field structure & some land & elected to make a precautionary landing.…NTSB ANC84LA030Accident · No injuriesLimited investigationFinal reportCessna 206 · Wasilla, AKThe acft crashed into a heavely wooded area after encountering IMC weather conditions and losing power on the engine. Heavy icing and freezing rain were reported in the area. The plt stated that he could not maintain VFR conditions on top due to raising cloud…NTSB LAX84FA136Accident · 1 fatalField investigationFinal reportCessna 185 · Union City, CAThe acft crashed into hilly terrain in an almost vertical high speed power on descent. A witness about 64 miles north of the accident site had seen an acft that met the description of the accident acft 'scud running', or flying beneath the low cloud bases…NTSB DEN84LA069Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Alamosa, COThe plt reported the wx deteriorated en route & he decided to land at a small arpt due to the fog & poor visibility. The arpt beacon was operating, but the rwy lights were not illuminated. During a 2nd apch, he encountered fog & started to go-around. The acft…NTSB SEA84LA035Accident · No injuriesLimited investigationFinal reportHughes 269C · Almo, IDThe plt stated, he was attempting to depart with visibility of 1/8 to 1/4 mi in fog. Shortly after departure the visibility dropped to approximately 50 to 100 ft. he attempted a slow runing landing and landed hard.NTSB SEA84FA036Accident · 3 fatalField investigationFinal reportCessna C172N · Arco, IDAccording to company personnel, the flt was operated as a charter. The plt, also the company director of operations, was not authorized to conduct FAR 135 flights under instrument flight conditions. He was reported to have stated that he was going to 'get a…NTSB NYC84LA067Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Monson, MEOn a crosscountry VFR flight the pilot inadvertently encountered instrument conditions. During a climb to clear surrounding mountains the acft struck trees and crashed. The pilot had been briefed on the deteriorating weather prior to the flight. The pilot and…NTSB LAX84FA134Accident · 4 fatalField investigationFinal reportCessna P206 · Redding, CAWhile en route, the plt contacted a fss & was advised that the Redding arpt was below minimums due to fog. He then contacted the benton UNICOM (7 mi nw of Redding muni) & reported that he could not see the rwy lights at the benton arpt, but that he would…NTSB FTW84FA107Accident · 2 fatalField investigationFinal reportAerospatiale AS-355F · Morgan City, LAThe plts in a helicopter encountered foggy weather during a positioning flt and crashed into a lake about 4 mi from the departure point, a fisherman who witnessed the accident said the acft descended into the water in a nose low attitude. The acft skipped and…NTSB LAX84FA129Accident · 2 fatalField investigationFinal reportYaple, Robert G. VARI-EZE · Bowie, AZDespite 2 wx briefings forecasting marginal VFR conditions with reports of icing, the plt departed on a flt in the non-ifr equipped acft. Just prior to the accident, transmissions between the plt & ATC indicated that the acft was in a snow shower between…NTSB DEN84LA059Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COThe acft collided with the ground after the pilot flew into a fog bank on final for runway 29R. The pilot was non-instrument rated and had not received a weather briefing or filed a flt plan. The acft was only airborne for a aboutan hour. The weather was 200…NTSB MIA84LA052Accident · Serious injuriesLimited investigationFinal reportBoeing 737-201 · Near Tampa, FLPrior to departure, the captain reviewed available wx reports & was aware of the wx conditions, including current sigmets. He decided to fly a course that was parallel to a frontal sys until he could get to an area where he could continue to his destination.…NTSB LAX84AA132Accident · No injuriesFinal reportBoeing 727-224 · New York, NYDuring apch the crew was advised of a windshear on final apch of +10 to -15 KTS at 700 ft & 400 ft AGL. Winds were reported 170 deg at 26 KTS gusting to 40 KTS. The plt added 20 KTS to his v-ref speed of 132 KTS & selected auto-spoilerdeployment. Prior to…NTSB ATL84FA078Accident · 2 fatalField investigationFinal reportBeech BE-36 · St. Catherines, GAThe plt received a wx briefing at 1037 EST before departing on an IFR x-country. At 1051, a severe thunderstorm warning (#537) was issued by the national wx svc. When the plt requested an IFR clearance at 1107, he was advised of the frontal activity. About 3…NTSB FTW84FA104Accident · 4 fatalField investigationFinal reportBeech 58 · Marquez, NMThe acft was flown at altitudes up to 15000 ft in areas of forecast icing. The acft was not equipped with oxygen. The acft was flown above 14000 ft for about 20 minutes after which it descended into icing conditions. Shortly thereafter, the acft made a climb…NTSB DEN84FA049Accident · 1 fatalField investigationFinal reportBeech P35 · Near Dove Creek, COThe acft collided with mountainous terrain about 30 miles northwest of cortez co. the plt was on an IFR flt plan and had been advised before flt of hazardous icing conditions enroute. When the acft iced up the plt reversed course and even though descending…NTSB ATL84LA074Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Pennington Gap, VAEnroute at 7,000 ft MSL the acft started picking up heavy ice. The plt make a 180 deg turn & descended to 6,000 ft. he was able to see the ground through breaks in the clouds. Upon sighting lee county arpt the plt elected to make a precautionary landing.…NTSB LAX84FA114Accident · 3 fatalField investigationFinal reportCessna 182E · Humbolt, NVWhile on a x-country flt in a mountainous area, the acft crashed into the side of a snow covered mountain. Impact occurred at the 8200 ft level in prince royal canyon. The canyon sloped upward to the south & terminated at an elevation of about 8900 ft. the…NTSB DEN84LA046Accident · Serious injuriesLimited investigationFinal reportGates Learjet 25D · Eagle, COWhile en route, the aricrew encountered stronger headwinds than expected. They realized there would not be enough fuel reserved for an IFR flt to aspen, so the elected to divert to Eagle, CO. However, their landing at engle was delayed due to a snowplow (with…NTSB CHI84LA065Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Detroit, MIWhile receiving vectors for an ILS apch, the acft encountered rime icing conditions. The left windshield began icing over & would not clear when the plt adjusted the windshield heat from normal to high. Since the autopilot was engaged, he moved to the right…NTSB ATL84LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waverly, KYAbout 8 mi from his destination the plt encountered freezing rain. He decided to retrieve a flashlight from his briefcase in the back seat to use in checking for ice on the wings & in consulting his charts. While leaning over the back seat, the plt lost his…NTSB ANC84LA025Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe plt reported that during flt, he encountered freezing rain. Although he applied carburetor heat, the eng ceased operating. During a forced landing, the right main gear collapsed & the right outboard wing panel was damaged. The plt reported that freezing…NTSB DEN84FA225Accident · 3 fatalField investigationFinal reportPiper PA-32 · Alma, COThe plt, his brother & his sister-in-law were on a flt to attend his mother's funeral. Before taking off, the pilot received a wx briefing & was advised that VFR flt was not recommended. The plt then asked for wx reports for a southerly route & he was advised…NTSB FTW84LA097Accident · No injuriesLimited investigationFinal reportBeech A-36 · Harrison, ARThe acft entered an area of icing and did not notify the ATC center of the icing problem. Although an emergency was not declared the plt did say he could not climb to an assigned alt after descending to try and lose ice accumulation. During the landing the…NTSB ATL84FA064Accident · 1 fatalField investigationFinal reportPiper PA-24-260B · Mcdonald, TNThe plt received 2 wx briefings before takeoff & was provided flt precautions of IMC to continue beyond 0900 EST. Also, he was advised that the mountains would be occasionally obscured & icing could be expected to the west below 6000 ft. during both…NTSB NYC84FA052Accident · 1 fatalField investigationFinal reportCessna 425 · Newburgh, NYDuring arrival, there were indefinite delays at white plains, NY, so the plt diverted to Newburgh, NY. He was vectored for an ILS rwy 9 apch. While en route, the plt requested & was given the ILS freq, mins for the apch, the arpt elevation(491 ft MSL), the…NTSB FTW84LA092Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Washington, OKAbout 15 min after tkof the plt became aware that the ground below was covered with fog. The plt found a hold in the obscured ceiling, descended and established visual contact with a field. After circling the plt landed in the field. About halfway down the…NTSB FTW84LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Winslow, ARDuring a wx briefing before takeoff, the plt was advised that VFR flt was not recommended. About 12 to 15 min after takeoff, he was forced to descend to maintain visual contact. He deviated south to avoid a rain shower. Subsequently, the plt realized he had…NTSB CHI84FA058Accident · 4 fatalField investigationFinal reportCessna 207 · Put-In-Bay, OHThe plt & 3 passengers took off at night on an over water flt to an island in lake erie to provide help to a heart patient. No flt plan was filed & no record of a wx briefing was found. Reportedly, after takeoff, the acft disappeared in a cloud or haze. Also…NTSB MKC84FA033Accident · 1 fatalField investigationFinal reportBeech TC-45J · Kansas City, KSThe acft was a Beech TC-45J that had been modified into a hamilton turboliner under STC SA-1821-WE. During arrival, the plt reported that he encountered moderate icing at 4000 ft. he made a localizer-only apch to rwy 35. An ATC specialist stated that they saw…NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB CHI84FA054Accident · 1 fatalField investigationFinal reportBeech 77 · Sidney, OHThe aircrew took off on an IFR flt from dayton to piqua & Sidney, OH to practice apch's, then they intended to return to dayton. The copilot stated that they entered the clouds at 700 to 800 ft AGL & he did not see the ground again on this flt. He reported…NTSB LAX84LA092Accident · No injuriesLimited investigationFinal reportSchweizer I-26D · Black Canyon, AZThe glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft…NTSB FTW84FA083Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Hebbronville, TXThe flt proceeded without incident until the plt contacted houston ARTCC. The plt requested the destination wx & was told that the entire area was IFR. The closest arpt reporting VFR conditions was at mcallen, TX, aprx 80 mi southeast. The plt then advised…NTSB DEN84FA038Accident · Serious injuriesField investigationFinal reportBell 206B · Ft. Morgan, COThe helicopter was owned & operated by a tv station & was being used for transportation to a news event. While en route, clouds & reduced visibility due to fog were encountered. The plt elected to land in a field covered with powdered snow. During the…NTSB NYC84FA046Accident · 1 fatalField investigationFinal reportCessna 172H · Hershey, PAPrior to takeoff the plt was advised that 'a storm was moving in.' The plt replied he knew that & was only going up for a short flt. Shortly after takeoff snow began to fall, & the acft was observed flying perpendicular to the rwy below traffic pattern…NTSB LAX84FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Holtville, CAThe plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time…NTSB FTW84LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ardmore, OKThe plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…NTSB DEN84LA036Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Cokeville, WYThe plt reported that snow had been falling regularily for the previous few days before the flt. He departed the staging area with 12 drill crew members. At that time, the visibility was 2 to 3 mi & a ceiling of 800 to 1000 ft. the plt flew 9 of the…NTSB DEN84FA031Accident · 1 fatalField investigationFinal reportChampion 7GC · Douglas, WYThe plt took off on an aerial observation flt to spot cattle in a mountainous area. When he failed to return, a search was initiated. The plane was found in a valley between 2 mountain ranges. An investigation revealed that the acft had crashed while in a…NTSB MIA84FA036Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Kathleen, FLThe acft impacted in a swampy area in a fast dive which separated about 6 ft of the left wing. The acft was being vectored on radar when it suddenly began to steer erratically and go off the radar scope. The plt had radioed that he 'must have gone over some…NTSB DEN84FA039Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Moose, WYThe acft crashed shortly after takeoff in IFR weather. The plt failed to follow established departure procedures and in fact he did not even call in the fact that he had departed or his departure time as instructed by salt lake center. Attempts by salt lake…NTSB FTW84FA077Accident · 4 fatalField investigationFinal reportCessna 172L · Simpson, LAThe acft collided with the ground in a steep nose down altitude at a high rate of speed after the plt encounterd low ceiling and rain during a x-country flt. In attempting to fly IFR and follow radar vectors the non-instrument rated plt lost countrol of his…