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 LAX85LA090Accident · No injuriesLimited investigationFinal reportBeech C45H · Littlefield, AZThe plt stated that he encountered low ceilings & fog in the mountain passes. After several unsuccessful attempts to cross the mountains he believed he did not have sufficient fuel on board to reach any airports to the south so he selected a flat mesa &…NTSB DEN85FA040Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas DC-9-30 · Denver, COWhile en route from las vegas, NV to minneapolis, MN at FL330, the acft had been in smooth air for at least 30 min when clear air turbulence (cat) was encountered. The flt crew turned on the 'fasten seat belt' sign. A flt attendant, attempting to buckle into…NTSB FTW85LA068Accident · No injuriesLimited investigationFinal reportCessna T310R · Lubbock, TXAccording to the plt icing conditions were encountered during the asr apch. Deicing equipment was utilized several times during the apch and worked normally. The acft broke out at 400 ft AGL. Ice accumulation on the wings resulted in an excessive rate of…NTSB LAX85LA057Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Rialto, CAAt about 0730 PST, witnesses near the lytle creek ranger station, located northwest of Rialto, CA, heard an acft circling low in the area, then heard the sound of impact nearby. The wx at the time was described as overcast with zero visibility in fog & light…NTSB FTW85FA065Accident · 2 fatalField investigationFinal reportCessna 182B · Brownsville, TXThe acft hit the stabilization wires on a 300 ft fm radio transmission tower followed by a collision with power- lines. Investigation revealed the plt & passg were enroute to the Brownsville, TX, airport to fly a DC-3 cargo acft to Mexico. At 1453 CST,…NTSB ATL85LA045Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Ahoskie, NCWhile on a night VFR local area flight the pilot noticed haze obscuring the lights on the ground. He returned to the airport and activated the REIL lights, he lost sight of the lights as he entered the traffic pattern. During the left turn to base, he entered…NTSB FTW85FA343Accident · 1 fatalField investigationFinal reportMooney M20J · Bethel, OKDespite a wx brief discouraging VFR flt the non-instrument rated plt departed at about 1330 CST. His stated dest was ft. worth, TX which is due north. After takeoff in VMC the acft flew NE toward an unknown dest. A wx study indicated conditions along the…NTSB DEN85FA034Accident · 4 fatalField investigationFinal reportCessna P206 · Wagon Mound, NMPlt received 3 wx briefings before flt and informed of possibility of diminishing conditions. Acft collided with terrain 1 1/2 mi from I-25 that goes from raton to albuquerqe. Local residents described wx at aprx time of accident as heavy snow, high winds,…NTSB MIA85FA044Accident · 4 fatalField investigationFinal reportCessna 210 · Clermont, FLDespite 5 pre-flt wx briefings from the local fss, warnings from a plt who had just landed in a corporate jet, and questioning from the ATCT regarding the plt's knowledge of existing conditions. The plt departed at 1138 EST. The acft impacted inverted and the…NTSB LAX85FA051Accident · 2 fatalField investigationFinal reportCessna 172G · Kingman, AZAircraft collided with the face of a shear cliff about 30 feet below its crest. It impacted with the left wing 15 degs down and with the nose up at about 5 degs. Impact occurred at 3500 ft MSL. Local authorities indicated that the weather at the time of the…NTSB LAX85FA048Accident · 2 fatalField investigationFinal reportCessna 172M · Lake Isabella, CAAcft departed arpt in mountain valley (elev 2,614) generally direct toward a saddle pass (elev 6,500) about 1 mi nw & on the lee side of the valley. Tops of the mountains around the valley average about 7,000 ft MSL. Flt encountered updrafts during climb…NTSB LAX85FA059Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Independence, CAThe non-instrument rated plt received two wx briefings before the flt during which he was informed that VFR flt was not recommended. Flt departed at 1308 PST and a search was inititated when acft failed to arrive at it's destination. Ntap print out indicated…NTSB FTW85LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Pampa, TXPreflight weather briefing showed closest reporting station to destination below dest apch minimum of I mile visibility but fcst to improve to 1/2 mi by arrival. Area freezing level fcst at 3-4000 ft. flt to dest at 6000 ft was on top of clouds and…NTSB ATL85FA041Accident · Serious injuriesField investigationFinal reportCessna 172K · Lineville, ALPlt obtained 2 wx briefings stating VFR flight not recommended along intended route. Plt requested local wx only during 3rd wx briefing. Reporting stations upwind and downwind of mountains were forecasting ceilings to be below mountain tops. Route of flt was…NTSB MIA85FA040Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Freeport, FLPreflt wx brief included advisory for scattered showers/thunderstorms along route of flt. Departed in VFR conditions but encountered deteriorating wx enroute, received inflt wx advisory to expect low clngs and reduced visibility ahead. Plt stated he 'would…NTSB CHI85IA039Incident · No injuriesIncident investigationFinal reportRockwell NA-265-25 · Chicago, ILAcft control was temporarily lost when 36 degrees of flaps were added due to ice build-up behind heated leading edge of the wing. Raising the flaps to 20 degs alleviated the control problem and an uneventful landing was accomplished at a higher than normal…NTSB BFO85FA005Accident · 2 fatalField investigationFinal reportDouglas AD-4NA · Syria, VAThe plt had obtained two wx briefings bfr the flt both indicating VFR not recommended. He said he would fly VFR as long as he could along a northern route that was forecast to be VFR deteriorating to MVFR. The plt was not instrument rated. The acft was…NTSB NYC85LA017Accident · No injuriesLimited investigationFinal reportCessna 172P · Andes, NYAccording to the plt, he encountered deteriorating visibility due to haze & he elected to land in an unimproved field. The 1st approach was aborted; however, the acft touched down on the 2nd approach. After touching down, the plt realized the field was too…NTSB MKC85FA012Accident · 3 fatalField investigationFinal reportMooney M20E · Carbondale, KSThe flt was en route from little rock, AR, to topeka, ka. Ten miles south of topeka's frobes field the plt requested wx info and was told that a current observation was being taken & he would be advised. Contact between the tower and the flt could not be…NTSB FTW85LA070Accident · No injuriesLimited investigationFinal reportCessna P210N · Big Lake, TXEn route to his destination the plt was advised of IMC at the destination and elected to return to the arpt from which he had departed. The acft collided with the rwy gear up because the plt delayed gear extension during the landing.NTSB ATL85LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cumming, GADespite a fss forecast of thunderstorm activity for the next 24 hours the plt departed in order to evaluate wx situation for himself. Conditions were as forecasted and the plt elected to return to the arpt from which he had departed. Due to the movement of…NTSB CHI85FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Joliet, ILA pvt plt invited a CFI to accompany the x-country flt because he was not instrument rated and marginal wx was forecast. On return trip from atlanta the CFI filed an IFR flt plan. During the flt, the rt fuel tank was run dry. Upon reaching the chicago area,…NTSB NYC85FA014Accident · 2 fatalField investigationFinal reportCessna 150M · Providence, RIAcft collided with the waters of narragansett bay at a location aprx 1 mile from boys town arpt (destination of record),in water aprx 8 ft deep. The wx was IMC at departure (1845 EDT) and the ATP instrument rated plt had requested and been granted a special…NTSB DEN85LTG02Accident · 1 fatalFinal reportPiper PA-38-112 · Berthold, NDThe student solo plt was on a cross-country flt and was appropriately endorsed. Impact occurred at aprx 80 degrees nose down. Wx in the vicinity of the accident was reported to be 300 ft ceilings with visibility of 1/4 mi in fog and rain.NTSB DEN85FA019Accident · 1 fatalField investigationFinal reportCessna TR182RG · Milan, NMThe pilot departed farmington,NM in the early morning darkness en route to grants, NM. The airplane struck the rock face of a 8399-foot mesa at about the 8150-foot level. According to one local resident, weather at that time consisted of a low ceiling, poor…NTSB DEN85FA017Accident · Serious injuriesField investigationFinal reportCessna 414 · Cheyenne, WYThe acft collided with the ground during a turn to final from a circling approach (IFR) at Cheyenne airport. According to ATC, the acft was a VFR 'pop up' & was subsequently issued an IFR clearance for an approach into the airport. Examination of the acft at…NTSB DEN85FA015Accident · Serious injuriesField investigationFinal reportCessna 414-8 · Cheyenne, WYThe acft departed the airport in IFR conditions (snowing) & was observed staggering into the air. Shortly after takeoff the acft struck power lines & crashed into homes in a residential area. Investigation revealed that the acft had accumulated ice & in…NTSB DEN85FA014Accident · 1 fatalField investigationFinal reportMooney M20C · Cheyenne, WYThe a/c with a non-instrument rated pilot at the controls, departed the Cheyenne, WY airport at night in light snow showers. Several minutes later he crashed in an open field north of cheyene impact forces and a post acc fire dest the a/c. evidence indicated…NTSB ATL85LA014Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-8-71 · Hamilton, ALN825E, operated as delta air lines flt 977 heavy, encountered turbulence during descent. One flt attendant suffered serious injuries, two flt attendants & two passengers had minor injuries. Even though the seat belt sign was illuminated the flt attendants…NTSB ATL85FA011Accident · 1 fatalField investigationFinal reportBeech QU-22A 1074 · Fancy Gap, VAAt about the 2,800 ft level the acft flew into the mountainous terrain which was obscured by clouds. Witnesses observed 2 previous attempts to fly over the rising terrain under the cloud layer. Departure and dest arpt, plt identity, and acft owner are all…NTSB SEA85FA012Accident · 4 fatalField investigationFinal reportCessna 182B · Tiller, ORThe acft collided with rising terrain about 1800 ft below the crest of a ridge while on a personal flt in wx which had multiple cloud layers obsuring the mountains. A cap acft on a search mission in the same area at the aprx time reported multiple cloud…NTSB MKC85FA008Accident · 2 fatalField investigationFinal reportCessna 182F · Hiattville, KSThe acft crashed during a night x-country flt. Ground witnesses who saw the flash from the ground impact stated that there was a thunderstorm in the area at the time of the accident. They also stated that they had difficulty in locating the wreckage due to…NTSB DEN85FA010Accident · 2 fatalField investigationFinal reportCessna T210-H · Englewood, COThe plt received a weather briefing prior to departure from scottsdale. He encountered IMC shortly after takeoff. The flt progressed uneventfully until in the vicinity of Colorado springs when the plt rpted a problem with his directional gyro. The plt…NTSB SEA85LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Lapine, ORPlt recieved inflt wx brief. Present location and next reporting station were VFR, no known adverse wx between. En route, plt encountered IMC. Fuel comsumed in maneuvering to aviod wx precluded return to known VFR airfield. Plt elected to make a precautionary…NTSB MKC85FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Beeler, KSAt 1805 CDT the pilot received a wx brief for the first leg of what was intended to be a round trip flight. No wx briefing was obtained for the return trip. Despite VMC at the nearest observation facility, witnesses reported haze and low clouds at the time of…NTSB CHI85FA014Accident · 1 fatalField investigationFinal reportCessna 172N · Hoopeston, ILThe plt landed short of destination & reported to fss that he did so because of thunderstorms in the area. After receiving a wx briefing the non-inst plt cancelled his VFR flt plan. One hour later the plt called fss & was re-briefed on the wx. The wx at his…NTSB LAX85LA011Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Gorman, CAThe acft collided with high tension wires about 5 miles south of Gorman, CA. The plt stated that while enroute he 'stayed beneath' the prevailing broken cloud condition until entering the mountainous area at which time he saw a hole in the clouds & began to…NTSB DEN85FA009Accident · 1 fatalField investigationFinal reportBellanca 14-19-3A · Pinehill, NMLeft wing failed inflight. Thunderstorms in area at time of crash. Pilot was enroute from California to new jersey, had been flying 4 hours, 18 minutes. Awake at least 7 hours. Transited 1 time zone. No record of weather briefing or flight plan filed. Pilot…NTSB LAX85MA012Accident · 3 fatalMajor investigationFinal reportBell 206B · Riverside, CAThe acft departed fullerton, CA (elev 96') at O958 PDT on a flt to big bear, CA (elev 6750'). There was no record of the plt obtaining a wx briefing. At aprx 1015, a witness heard the helicopter circling above the bottom of 'an early morning fog hanging over…NTSB FTW85FA006Accident · 2 fatalField investigationFinal reportCessna 152 · Monroe, LAPrior to dep the plt contacted the Monroe fss twice requesting a wx briefing. Both times VFR flt was not recommended due to IFR conditions with low ceilings en route and forecast fog at the dest. During the second call the plt stated that it was clear at the…NTSB SEA85FA001Accident · 3 fatalField investigationFinal reportCessna R182 · Austin, NVDeteriorating wx was encountered as the plt followed a highway to his dest on an easterly heading. On scene evidence indicated that the acft impacted left wing tip first on a northerly heading near the east end of a box canyon. The impact flight path angle…NTSB DEN84LA302Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Corona, NMAt 0809 hrs, plt obtained telephone weather briefing & was advised VFR flt not recommended for intended route. At 1310 hrs, plt obtained second briefing, VFR flight again not recommended, no improvement expected prior to noon of following day. At 1428 hrs plt…NTSB LAX84LA492Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Marana, AZThe plt delayed his descent/approach to his destination due to wx. He was unable to reach his destination because of downdrafts encountered in the descent. During the approach (off airport) the right wing tip contacted the ground resulting in a collision with…NTSB FTW84LA405Accident · No injuriesLimited investigationFinal reportCessna 152 · Ponder, TXPlt acknowledged initiation of flight into low ceiling and visibility conditions with no wx briefing. Shortly after takeoff, conditions deteriorated even more and acft entered thick fog. Breaking out momentarily, plt elected a precautionary lndg on a road.…NTSB DEN84FA300Accident · 3 fatalField investigationFinal reportBeech V35 · Missoula, MTOn sept 21, 1984, a Beech 35, N3736Q crashed into the side of a mountain 16 miles NE of Missoula, MT while on a VOR/DME8INSTRUMENT approach. The plt reported icing, turbulence, and intermittant vor-dme reception. The last reported altitude by the plt was 8500…NTSB DEN84FA295Accident · 3 fatalField investigationFinal reportCessna 205 · Highwood, MTAt 0053 MDT, the plt radioed great falls fss & requested wx info. He was advised of IFR conditions & was provided the latest observation. The plt requested & was provided a special VFR clearance to depart to the east. He took off at 0100 MDT & reported over…NTSB SEA85FA016Accident · 1 fatalField investigationFinal reportCessna 172M · Aberdeen, WAAcft wreckage indicates impact was nose down inverted. No evidence was found of acft failure/malfunction. Plt departed on night cross-country after an evening out with friends. Wreckage found two months later, no toxicological tests possible.NTSB ATL84FA286Accident · 1 fatalField investigationFinal reportPiper 602P · Dayton, TNOn arrival at destination, plt found airport obscured by fog, reported by UNICOM as 1 mi visibility. Plt circled to await improvement. 15 min later, visibility improved to 1-1/2 mi. Acft observed briefly through breaks, then heard manuvering to north and seen…NTSB MKC84FA271Accident · Serious injuriesField investigationFinal reportCessna R182 · Ottumwa, IAThe acft entered IMC weather, the plt became disoriented & cruised without ATC navigational assistance after failing to make radio contact or file a flt plan. The non-instrument rated private plt flew until acft power was lost due to fuel exhaustion. The…NTSB CHI84LA384Accident · Serious injuriesLimited investigationFinal reportHarris Goldwing · Greenville, ILPlt was performing touch and go landings below 1100 ft overcast sky. Passing north end of field at 800 ft, plt noted rain shower at south end & elected to land to the south. During apch turn the left wing dropped abruptly to a near-inverted acft attitude. Plt…