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 LAX82FVG17Accident · Serious injuriesFinal reportCessna 182 · Folsom, CAThe pilot visually checked the fuel before takeoff and was aware that the tanks were not full. He reported that he would only use 80/87 octane fuel because the engine was not equipped with valves that would accept 100 octane fuel. During the flight, he…NTSB ATL82FA080Accident · 1 fatalField investigationFinal reportCessna 172N · Francisco, NCThe non-instrument rated pilot received a partial weather briefing by telephone, but hung up when he obtained the information that he requested. FBO personnel stated that he looked and acted tired before taking off at 0022 EST. Subsequently, the plane was…NTSB LAX82FA111Accident · 5 fatalField investigationFinal reportCessna 401 · Sunflower, AZAt 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route…NTSB LAX82FA110Accident · 1 fatalField investigationFinal reportMooney M20K · Alpine, CAAfter being cleared from 8000 feet down to 6000 feet the air traffic controller realized that the aircraft was in trouble when the mode c altitude indicated 3600 feet. He received no understandable response from the pilot when asked about altitude or heading.…NTSB FTW82FRG26Accident · 2 fatalFinal reportPiper PA-24-260 · Kingsville, TXOn 3/17/82 a wx briefer advised the pilot all of Texas would be under instrument meteorological conditons on the morningof 3/18/82. There was no record of a flt plan filed by the pilot of N8988P and the departure time from Kingsville could not be determined.…NTSB SEA82DA038Accident · No injuriesFinal reportCessna 340 · Idaho Falls, IDThe pilot reported that during an ILS approach, he broke out at about 500 ft AGL. He stated that he did not properly arrest the sink rate and struck the runway. He also stated that there probably was some ice under the wings that had accumulated during…NTSB NYC82DA057Accident · No injuriesFinal reportPiper PA-28RT-201 · Avoca, PAThe pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…NTSB LAX82FA109Accident · 3 fatalField investigationFinal reportCessna 340A · 12 N.E. Burbank, CAAfter takeoff, the pilot was cleared to proceed on an IFR flight plan. After being cleared to 15,000 ft MSL, he reported having trouble maintaining his airspeed and subsequently declared an emergency. Shortly after that, radar contact was lost. The aircraft…NTSB FTW82FPJ14Accident · 1 fatalFinal reportCessna 172N · Hulen, OKThe pilot departed lawton, Oklahoma at 0902 local time on a flight to inspect mineral property. At about 0931, the pilot contacted ft. sill approach control and requested vectors to lawton. He was instructed to fly a heading of 320 degrees. After flying that…NTSB ATL82FA072Accident · 1 fatalField investigationFinal reportCessna 150 · Tilghman Island, MDThe student pilot/owner of the aircraft was endorsed to fly the plane and would fly it from his farm on Tilghman Island to easton, MD for dual instruction. Several days before the accident, he had asked his instructor (ip) to schedule some time for an early…NTSB DEN82DA046Accident · No injuriesFinal reportBell 206B · Marble, COThe purpose of the flight was to transport ski guides to the top of a 13,000 ft mountain ridge. After climbing in moderate to high winds, the pilot approached the intended landing area from the lee side at an angle of about 45 degrees to the ridgeline. He…NTSB CHI82DA090Accident · No injuriesFinal reportCessna 182 · Bremen Township, MNDuring a VFR flight, the pilot encountered deteriorating weather and elected to make a precautionary landing on a snow covered, cultivated field. The pilot reported that during a soft field approach for landing, the aircraft flipped over when it contacted the…NTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…NTSB CHI82DA078Accident · No injuriesFinal reportPiper PA-30 · Valparaiso, INThe pilot reported encountering severe icing conditions after he had canceled his IFR flight plan and had the airport in sight. At that point, he felt that the safest alternative was to continue the approach. The approach was flown at 120 mph with no flaps.…NTSB LAX82FA088Accident · 6 fatalField investigationFinal reportCessna T21OL · Verdi, NVPrior to the acft's departure from truckee-tahoe arpt, an inbound plt recommended via radio that the flt not go because he had just flown thru the donner pass & the wx was terrible. He reported the wind 25-35K, gusting 40-45K. The flt received a wx briefing…NTSB MIA82DA061Accident · No injuriesFinal reportCessna 172L · Lake City, FLWhile enroute, the pilot encountered an area with restricted visibility and with an estimated ceiling of 300 ft. after reversing course, he saw a forest road and elected to land. He reported that during the landing roll, a gust of wind was encountered causing…NTSB ATL82FA066Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Bradley, SCBefore takeoff, the pilot telephoned his brother in north carolina and asked about the weather. He was told that there was an overcast. The pilot replied that he would "come on and skirt the mountains." No flight plan was filed and there was no FAA record of…NTSB FTW82FA071Accident · 1 fatalField investigationFinal reportRobinson R22 · San Marcos, TXThe helicopter was observed rotating in a counter clockwise motion. A small explosion was seen at the tail section with pieces flying off. The outboard sections of the t/r blades were found about 800 ft from the main wreckage. Examination of the fractures…NTSB NYC82DA049Accident · No injuriesFinal reportCessna 421C · Westerly, RIThe aircraft touched down hard during a night landing after the pilot encountered icing conditions in flight. Several witnesses reported that the aircraft had 1/2 to 3/4 inch of ice on the leading edges of the wings and verticle stabilizer. The gross landing…NTSB LAX82FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Truckee, CAThe non-instrument rated pilot was on a return flight from livermore, CA to Truckee. The aircraft crashed on a dark night at an elevation of about 6700 ft MSL in mountainous terrain. The angle of impact was about 25 degrees downward on a down hill slope. A…NTSB DEN82FA062Accident · 2 fatalField investigationFinal reportBellanca 14-19-3A · Selfridge, NDOn the previous day the plt received a wx briefing for the flt. He was advised the wx would be marginal VFR in the bismarck area in the morning due to low ceilings & snow. There is no record that the plt received an updated wx briefingprior to departure. The…NTSB NYC82DA039Accident · No injuriesFinal reportPiper PA-44-180T · Mount Pocono, PABefore takeoff, the pilot got a weather briefing and called the airport manager at the destination. Reportedly, the destination airport was open and usable at that time. In flight, the pilot asked ATC about reports of icing in the mt Pocono area and got a…NTSB CHI82DA058Accident · No injuriesFinal reportBeech 58 · St. Charles, ILDuring an IFR approach the pilot stated he picked up about 1/2 to 1 inch of ice on the leading edge of the wings after activating all icing equipment. After breaking out of the clouds the pilot descended with full flaps at 110 to 115 knots. He began to flare…NTSB ATL82FA057Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hytop, ALThe pilot filed and departed VFR into forecast marginal flight conditions. While en route the destination went IFR and this information was passed on to the pilot. The pilot replied that he was going to continue on and get as close to chattanooga as possible.…NTSB DEN82FA034Accident · No injuriesField investigationFinal reportPiper PA-23 · Mitchell, SDAs the pilot approached sioux falls he received information that it was below minimums, so he started to divert. As he passed over sioux falls he could see Mitchell, SD, which appeared to be clear, therefore, he elected to land there. It continued to look…NTSB CHI82DA057Accident · No injuriesFinal reportBeech 90 · Columbus, OHWith OAT 25 degrees below zero and the aircraft flying through heavy rain the pilot reported the elevator trim tab became inoperative. While attempting to stabilize the aircraft manually during an ILS approach the aircraft descended below glideslope and…NTSB MIA82DA047Accident · No injuriesFinal reportCessna 172 · San Juan, PROn final approach the tower controller told the flight that other aircraft had reported wind shear below 800 feet. The pilot landed the aircraft and ran off the right side of the runway. The pilot reported wind gusts to 21 knots.NTSB LAX82FA078Accident · 4 fatalField investigationFinal reportCessna 172K · Hollister, CAThe aircraft flew into the side of a mountain in level cruise. The accident happened during weather in which VFR flight had not been recommended. Clouds were obscuring the mountains. The aircraft was on the return leg of a cross-country flight. No flight plan…NTSB LAX82FA073Accident · 2 fatalField investigationFinal reportRockwell 112A · Near Los Banos, CADuring a preflight briefing, the pilot was advised that the mountains were obscured by clouds, the outlook was for marginal VFR ceilings, and the weather conditions in northern California were deteriorating faster than forcasted. The pilot took off at 1333…NTSB LAX82FA071Accident · 4 fatalField investigationFinal reportBeech J35 · Gilroy, CAThe plt was advised during the wx briefing that VFR flight was not recommeded across the mountains & that san jose was reporting 3,000 ft scattered; 4,000 ft broken; 9,000 ft overcast with 10 mi visibility with light rain. Approximately 36 min after takeoff…NTSB LAX82FA069Accident · 2 fatalField investigationFinal reportBeech 95-C55 · Twentynine Palm, CAAt 1605, the flt called blythe fss stating he was 25 mi east for landing. When he heard that his business associates in another acft were preparing to depart blythe for Twentynine palms, the plt cancelled his landing intentions & stated that they will be…NTSB LAX82FA072Accident · 4 fatalField investigationFinal reportCessna P210N · 6 Nm North Of S, AZThe pilot was advised that VFR to flagstaff was not recommended. He advised the briefer that he had just recently flown from sedona and knew he could return VFR. At about 1938 MST, the plane departed phoenix with no flight plan. While en route, the pilot…NTSB LAX82FA070Accident · 1 fatalField investigationFinal reportCessna 172N · Santa Ysabel, CADrg wx briefings at 1024 & 1247 the plt was advised that VFR flt was not recommended due to low ceilings & icing conditions. At about 1418 the acft departed. At 1439 the plt contacted flight watch (fw) & reported picking up leading edge ice 6.4 mi east of the…NTSB ATL82FA047Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Lambsburg, VAThe aircraft was on an air taxi flight to transport 2 prisoners and was to be operated on a VFR flight plan in VFR conditions only. Prior to takeoff, the pilot had obtained 12 weather briefing. In 2 of the briefings, VFR flight was not recommended. At about…NTSB NYC82FHD06Accident · No injuriesFinal reportTed Smith Aerostar 600 · Toms River, NJThe pilot stated that during a VOR approach, he broke out at 600 ft and got the runway in sight. He reported that the visibility dropped frequently, but he was able to keep the runway in sight until he was about 200 yards from the runway. He stated that the…NTSB NYC82AA028Accident · Serious injuriesFinal reportBeech 99 · Groton, CTAfter crossing the mondi intersection inbound for an ILS rwy 5 apch, the captain felt that a proper descent was not possible due to a strong tailwind & their present altitude. They turned & proceeded outbound to loose altitude. The crewthen established…NTSB FTW82FQG14Accident · 2 fatalFinal reportCessna 182 · Pampa, TXN58947 was purchased by the pilot the day of the accident. According to a flight instructor who sold the aircraft, the pilot received dual instruction for a checkout in the aircraft and currency for night flight. According to witnesses, the pilot did not…NTSB MKC82DA024Accident · Serious injuriesFinal reportBeech 36 · Malden, MOThe pilot was briefed on the enroute weather prior to departure. Records indicate that sigmets on icing and turbulence along the route were provided to the pilot. When the pilot encountered icing conditions in flight, he continued instead of turning back to…NTSB MKC82FA023Accident · 1 fatalField investigationFinal reportCessna 172N · 5m E. Greensbur, KSThe plt received a wx briefing for a flt to dodge city,KS. The fss specialist asked the plt if he was proposing his flight under IFR since his destination was reporting IMC. The plt replied that he was. A ground witness at haviland,KS located about 5 miles…NTSB LAX82FVM09Accident · 1 fatalFinal reportPiper 28-151 · Los Gatos, CAThe pilot prepared to depart on a scheduled courier run in a Piper PA-32, but was unable to start the engine. After consulting with company personnel, he rented a Piper PA-28-151, transferred the cargo and departed monterey, CA on a flight to oakland, CA.…NTSB ANC82DAG16Accident · 2 fatalFinal reportCessna 182M · Bethel, AKThe pilot filed a VFR, round robin, flight plan. When the time on the flight plan had elapsed, a search was initiated. Later, the plane was found where it had crashed on a frozen lake surrounded by low terrain. An examination of the wreckage revealed that the…NTSB NYC82FNA10Accident · Minor injuriesFinal reportCessna 172 · Taunton, MAThe student pilot took off at night on an unsupervised pleasure flight. His passenger did not hold any type of pilot certificate. After takeoff, the pilot encountered fog. He used the nbd for orientation and was able to return to the airport. He reported…NTSB CHI82FA032Accident · 1 fatalField investigationFinal reportBeech A23A · London, OHThe pilot received two weather briefings for a flight from columbus to springfield, Ohio. VFR flight was not recommended. The pilot took off after the tower closed at 2300 EST. At about 2341 a witness near the crash site heard the loud sound of an aircraft…NTSB MKC82FA019Accident · 1 fatalField investigationFinal reportCessna 402A · North Kansas Ci, MOThe pilot received 2 weather briefings. Most of the first briefing was spent finding an alternate. The forecast includedimc with low ceilings, low visibilities with light snow, fog, and possible freezing drizzle. The aircraft was not certificated for flight…NTSB LAX82FA050Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · 10nm N. Of Mcna, AZWhile on a cross country flight the pilot flew into weather which included severe to moderate icing conditions. Although the weather was forecast for the intended route of flight in a SIGMET it was not provided to the pilot during the initial weather…NTSB LAX82FA045Accident · 3 fatalField investigationFinal reportCessna 182N · Escondido, CABefore takeoff, the pilot received a complete weather briefing. The briefer warned him that the weather system in southern California was extremely hazardous and advised him several times not to go. The briefing included numerous pilot reports that confirmed…NTSB ATL82FLT02Accident · 1 fatalFinal reportGrumman AA-1 · New Albany, MSThe airport manager stated that he heard the aircraft takeoff, turn right, then turn back left. A few seconds later he heard the engine rev up and shortly after it hit the trees. He further stated that there was fog in the area and the ceiling was no more…NTSB LAX82FA048Accident · 2 fatalField investigationFinal reportBeech 58 · Cherry Valley, CAAt 0702 the plt received a weather briefing for a VFR flight to fresno. The area forecast contained flight precautions for obscured mountains & IMC in the sierra nevadas, and occassional moderate icing below 15,000 ft. the flight departed at 0728. The…NTSB DEN82FTA09Accident · 1 fatalFinal reportCessna 177B · Wolf Pt., MTThe pilot reported that he encountered a snow squall while cruising at 5000 ft MSL on a VFR flight plan at night. He stated that he descended to 4000 ft MSL to try to get under the squall and continue. He was unable to remember what happened after descending…NTSB ATL82FA037Accident · 4 fatalField investigationFinal reportCessna 210L · Madison County, ALThe aircraft departed destin, FL at 1554 CST on a flight to tullahoma, TN. The estimated time en route was listed on the flight plan as 2.5 hrs with 4.5 hours fuel on board. During arrival at tullahoma, the pilot initiated a vor/dme-b approach, but executed a…