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 CHI88FA087Accident · 2 fatalField investigationFinal reportBeech 35-C33A · Onamia, MNPilot's poor judgement in continuing VFR flight into IMC conditions, and his subsequent disorientation and failure to maintain aircraft control.NTSB SEA88LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Palmer, WAWhile on a VFR cross country flight the pilot encountered instrument meteorological conditions along his route. The aircraft was not instrument equipped, even though the pilot is instrument rated. The pilot had to make two precautionary landings prior to the…NTSB SEA88LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Ashland, ORDuring a dark night VFR flight, the acft encountered a severe downdraft and instrument meteorological conditions. With full power the acft descended, striking trees before it struck the ground. During the pilot's preflight briefing and in-flight briefing he…NTSB BFO88FA031Accident · 2 fatalField investigationFinal reportRyan Navion NA-4 · Fancy Gap, VAThe pilot failed to maintain visual contact and clearance with rising terrain after VFR flight encountered IMC.NTSB DEN88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Logan, UTThe plt reported that he was on a flight from Colorado springs to portland, Oregon. He said he planned to refuel in the Logan/malad city, Idaho area. After crossing a ridgeline in the mountainous terrain east of Logan, the flt encountered low ceilings and…NTSB CHI88IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 767-200 · Cimarron, NMWhile in normal cruise flight at FL 370, the flt crew was advised by ARTCC personnel that other aircraft were experiencing occasional severe turbulence at FL 370 along their route of flight. A descent was made to FL 330 to avoid turbulence. Later, as the…NTSB CHI88FA080Accident · 1 fatalField investigationFinal reportCessna 310Q · Servia, INThe pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident.NTSB BFO88FA026Accident · 3 fatalField investigationFinal reportCessna 210N · Quantico, VAThe acft was abt 25 mi south & inbound to dca when the plt rprtd an enctr with snowshwrs which were part of a cold front. He asked & was clrd to dscnd to 2500 ft so he could maint VMC. Radar data showed, the acft dscndd past 2500 ft to 1300 ft. abt 16 mi…NTSB ATL88FA104Accident · 2 fatalField investigationFinal reportBeech A36 · Bow, KYThe pilot had received two weather briefings. In both, he was advised of forecast and known icing conditions. The pilot reported ice build-up to ATC. Afterward he requested no further assistance from ATC to locate a suitable landing area. Wreckage examination…NTSB ATL88LA100Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Norwalk, OHThe plt rptd that he was cruising at 9,000 ft when he observed the EGT gauge indication dropping. The engine began to run rough and he noticed a fuel odor in the cabin. The carb air temp gauge was indicating 'well out of' the icing range. He selected carb…NTSB FTW88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Midland, TXEncounter with severe turbulence within tops of convective clouds. Leading to this was the pilot's failure to properly evaluate the potential danger of the convective activity, which he chose to penetrate.NTSB LAX88FA118Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Frazier Park, CAImproper maintenance performed previous to the accident flight which failed to identify a fault which rendered the airplane nonairworthy. Contributing to this accident was the pilot's exercise of poor judgement in disregarding weather forecasts indicating…NTSB ANC88LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kipnuk, AKThe pilot stated that during the initial climbout from the airport he encountered a complete whiteout condition. The pilot then elected to land on the frozen lake and during the rollout the aircraft struck a snowbank.NTSB DEN88LA075Accident · No injuriesLimited investigationFinal reportCessna 206G · Loveland, COA commercial plt was flying a group of parachutists for a skydiving club. The aircraft encountered turbulence during a climb to 4,500 feet AGL. As the second jumper was exiting, the aircraft dropped and the parachutist struck the horizontal stabilizer. The…NTSB MIA88LA109Accident · 3 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLBfr depg at ngt with no flt plan, non-inst rated plt was adzd of psbl clds forming at a low lvl. En route, he got radar flt flwg. Apchg his destn, he got vctrs & alt chgs to avoid wx & otr acft. At 2001:04, radar svc was trmtd with palm bchapch ctl to cont…NTSB SEA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Stevens Pass, WAPlanned flt was VFR transit of cascade mountains in daylight. Plt filed VFR flt plan; wx brief indicated VFR. Unforeseen delays resulted in arrival at planned mountain Pass over one hour late and wx no longer VMC. Plt could see alternate Pass to north…NTSB DEN88FA071Accident · 3 fatalField investigationFinal reportCessna 172M · Red Lodge, MTThe plt and two pax were returning to twin falls, id from billings, MT. The plt rec two wx briefings prior to dep. The wx forecast indicated low clouds, snow, turb and icing cond along the intended route of flight. The route of flight required the plt to…NTSB DEN88FA064Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Roswell, NMNTSB NYC88FA072Accident · 1 fatalField investigationFinal reportCessna 337E · Friedens, PAThe 24 year old unlicensed pilot made an unauthorized flight in his father's aircraft. The Cessna 337 was observed to manuever in the vicinity of the airport at a low altitude in and out of the clouds. The aircraft was then observed to come out of the clouds…NTSB LAX88FA101Accident · 2 fatalField investigationFinal reportCessna U206F · Lk Havasu City, AZPilot's decision to continue flight in forecast marginal VFR conditions in mountainous terrain. Contributing to this accident was the failure of the pilot to obtain an aviation weather briefing and his lack of recurrent training.NTSB DEN88LA073Accident · No injuriesLimited investigationFinal reportCessna 182R · Pueblo, COThe instrument rated pvt plt was completing a personal IFR flight from telluride, Colorado, to Colorado springs, Colorado, with three pax. The destination wx went below IFR minimums prior to the flight's arrival and the aircraft diverted to Pueblo, Colorado,…NTSB ATL88LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Barnwell, SCThe CFI and her student became lost on the last leg of a dual x-c flt after encountering rainshowers and low ceilings. After unsuccessfully attempting to locate their destination arpt, the CFI located another arpt and elected to land there. The engine…NTSB ATL88LA084Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Block Island, RIThe capt rptdly advised the flight attendants to secure the cabin and be seated due to turbulence expected during descent. About 5 minutes later, the airplane briefly encountered severe turbulence while passing through about FL230. A flight attendant…NTSB SEA88FA039Accident · 3 fatalField investigationFinal reportBeech B23 · Hamer, IDThe two non instrument rated pilots (owner/pilot in command and second pilot) as well as a passenger departed medicine hat, alberta, Canada, on a pleasure flight to las vegas, Nevada. Upon arrival at great falls, Montana, both pilots were briefed on the…NTSB MKC88DPG01Accident · 1 fatalFinal reportMeyer VARI-EZE · Little Rock Afb, ARPilot received a wx briefing and was told VFR was not recommended. The pilot did not file a flight plan and flew an aircraft not equipped for IFR into weather with 100-feet obscured ceiling and .3 mile visibility. The aircraft crashed into the ground at a…NTSB MIA88LA090Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-82 · Hickman, KYThe capt left the seat belt sign on after takeoff. The flight attendants made a followup announcement for the passengers to remain seated and keep their seatbelts fastened due to the turbulence they were encountering. A passenger elected to get up from her…NTSB LAX88LA091Accident · No injuriesLimited investigationFinal reportAerospatiale SA-341G · Bowie, AZNTSB CHI88LA044Accident · No injuriesLimited investigationFinal reportBeech A36 · St Paul, MNNTSB LAX88FA088Accident · 4 fatalField investigationFinal reportCessna 182L · Newhall, CAPilots decision to continue VFR flight after encountering instrument meteorological conditions.NTSB DEN88FA054Accident · 3 fatalField investigationFinal reportGulfstream American AA-5A · Elbert, COThe acft collided with slightly rising terrain with the rt wing slightly down and the nose attitude level. Following the first contact, the acft skipped about 90 ft and the 2nd impact was in a more pronounced rt wing low and nose down attitude. The canopy was…NTSB LAX88FA087Accident · 1 fatalField investigationFinal reportCessna T210N · Lost Hills, CAOn a dark night with light drizzle falling the pvt plt, who was not instrument rated, departed from an uncontrolled arpt for a x-c flt. The plt made a downwind departure, & his altitude on the x-wind leg was estimated by a passing truck driver at 200 ft AGL.…NTSB DEN88FA050Accident · 2 fatalField investigationFinal reportCessna T303 · Kiowa, COThe plt obtained two wx briefings and filed an IFR flt plan to el paso, TX. He was not instrument rated. The acft departed apa at 1959 and disappeared from radar at 2010. The crash site was 11- 1/2 mi se of the Kiowa VORTAC and 36 mi se of apa. Radar showed a…NTSB LAX88FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Napa, CAPilot's inflight loss of control of the aircraft while maneuvering in IFR conditions after becoming disoriented while executing an instrument approach procedure. Factors in the accident were the pilots lack of recent instrument flight experience and the…NTSB FTW88FA046Accident · Serious injuriesField investigationFinal reportBeech B36TC · Woodward, OKBefore tkof, the plt was briefed on flt precautions for IFR & snow; however, he was not adzd of icing conds in clouds & precip above the freezing lvl to 18,000' as cautioned in the current area forecast. While climbing after tkof, he enctrd clouds & 'some…NTSB LAX88LA079Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZNTSB NYC88FA062Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Burlington, VTDrg flt fm wilmington, de to rutland, VT, the plt diverted to binghamton after recg the albany wx & learning rutland wx was not available. After lndg, he told fss psnl he phoned rutland & was told the wx was good. He got 2 wx briefings bfr contg the flt & was…NTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…NTSB MKC88LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hays, KSDuring a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…NTSB ATL88FA067Accident · 1 fatalField investigationFinal reportBeech B23 · Crossville, TNN6571R crashed into trees near the VOR on top on hinch mtn at about 3000 feet MSL. Trees at the crash site indicated wings level with a descent angle of about 10 degrees. Weather in the area was IMC, characterized by low ceilings (lower than the mtn top…NTSB FTW88LA041Accident · No injuriesLimited investigationFinal reportCessna 172XP · Godley, TXDuring a cross country flight, the weather worsened. Visibility decreased and the ceiling lowered, forcing the pilot to descend in order to remain VFR. The pilot elected to perform a precautionary landing in a field. During landing roll the pilot noticed a…NTSB SEA88FA032Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Eastsound, WAThe plt depd south from an unattended island arpt at sea level & flew into marginal VFR conds with moderate snowfall. Acquaintances at the arpt rprtd the plt expressed an urgent need to return to snohomish, WA, despite the wx conds. When the acft did not…NTSB MIA88LA065Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Guvate, PRThe private pilot became separated from the formation of 4 aircraft and entered an area of deteriorating weather. He descended and attempted to maintain visual contact with the ground and struck trees and crashed. The pilot was not instrument rated and did…NTSB SEA88FA031Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Lakeport, CAAlthough weather conditions were marginally VFR at his departure point, and the pilot had access to a vehicle which could have been used to drive to his dest, he departed novato, CA, enroute to Lakeport, CA, without obtaining a wx briefing nor filing a flt…NTSB ATL88FA060Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Moultrie, GAThe plt was on a personal VFR flt with his wife and son. During the course of the flt, he entered deteriorating weather conditions. He was advised that there were scattered rain showers ahead. He continued on his track and advised apch control that he had…NTSB ANC88FA020Accident · 1 fatalField investigationFinal reportCessna 207A · Ambler, AKThe plt of the air taxi cargo flt was operg at night in marginal VFR conds when the acft struck rising terrain. The acft was fnd the next day at aprx 1000 ast, some 15 mi off the intended route. The plt was unconscious & suffering fm hypothermia & other…NTSB DEN88FA128Accident · 2 fatalField investigationFinal reportCessna 177RG · Afton, WYThe acft was not certified nor equipped for flt into icing conditions. The plt elected to depart even though he was advised by the crew of a C-182 that had just lndd to stay below the clouds because of icing. After tkof the acft cleared an 11000 ft mtn range…NTSB ATL88LA054Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Sewanee, TNThe plt rprtd that he obtained a wx briefing before takeoff & that the wx at his intended destination was rprtd as marginal. While en route, he encountered wx and climbed above it. Aprx 4 hrs after departure, he became concerned about the remaining fuel…NTSB MKC88FA023Accident · 2 fatalField investigationFinal reportCessna 180 · Springfield, NEAccording to witnesses on the ground, the aircraft was flying low, under the overcast, when the left wing struck the guy wires of a tv tower and the plane crashed out of control. It was destroyed by impact forces and a post-crash fire. Weather stations in the…NTSB LAX88LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Dunsmuir, CAA Piper PA-38-112 collided with terrain while on a night VFR cross country flight. Night instrument meteorological conditions prevailed at the time and no flight plan was filed. The pilot received a weather briefing prior to departure. His destination weather…NTSB SEA88LA026Accident · No injuriesLimited investigationFinal reportCessna 206 · Funter Bay, AKShortly after takeoff, with a right quartering tailwind of 20 knots gusting to 25 knots, a downdraft was encountered. The pilot flew the aircraft away from rising terrain but the aircraft settled into small trees at full power in the takeoff configuration.