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 LAX84FA339Accident · 2 fatalField investigationFinal reportCessna 152 · Rosamond, CAThe acft collided with rising terrain at the 4200 ft level about 3 miles south of elevations of 6800 ft. guards on duty within a mile of the accident site said the weather at the time of the accident was foggy with a light drizzle and northwinds of 35 KTS.…NTSB DEN84LA178Accident · No injuriesLimited investigationFinal reportBeech V35A · Dove Creek, COWhile en route, the plt encountered hazy wx after crossing the Continental divide. Near montrose, CO, he deviated about 50 mi north to avoid adverse wx. He was unable to get thru, so he proceeded back to montrose to skirt the southern edge of the wx. He…NTSB DEN84LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Cheyenne, WYBefore the flight the pilot obtained a weather briefing and was informed of an approaching thunderstorm which was 10 miles northwest of the airport. The pilot stated that after a normal takeoff he climed to a altitude of about 250 ft AGL, at 70 KIAS, when he…NTSB DCA84AA025Accident · No injuriesFinal reportBoeing 727-222 · Denver, COBefore takeoff, the crew of N7647U (ua flt 663) noted cumulus clouds & virga in the area. At 1327, a Dehavilland dash 7 crew rprtd a 25 kt loss of airspeed, but svrl other acft then took off without rprtg a problem. Due to radio conjestion,the captain did not…NTSB ATL84LA290Accident · 1 fatalLimited investigationFinal reportGlobe GC-1B · Rockwood, TNThe acft crashed in an area of rising terrain at about the 1800 ft level. About 1 mile away the ridge line rose to an elevation of 2500 ft. when the acft was observed overflying the Rockwood arpt aprx 3 miles from the accident site the ceiling was about 1200…NTSB LAX84LA327Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS1-26D · Lucerne Valley, CAThe plt reported that his glider was the 3rd to launch (using an auto tow) on a distance completion flt. He released the tow cable at about 900 ft & began searching for lift. No lift was found. After a short time, he attempted to return to the departure…NTSB LAX84LA320Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Boron, CAPlt stated that while soaring a 'heavy sink' was encountered. He attempted to reach borax airport but was unable to and landed in terrain 1/4 mile west of the airport. Lancaster, CA, fss stated pilot reports of 'moderate turbulence' were received throughout…NTSB LAX84LA318Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Woodland, CAAccording to the plt, the acft encountered a local whirlwind during a 90/270 ag maneuver & crashed.NTSB MKC84LA149Accident · No injuriesLimited investigationFinal reportCessna 172 · Hardy, ARThe acft collided with trees during an off arpt precautionary landing. The plt received a wx briefing that forecasted low ceilings and visibilities along his route. The plt elected to continue the flt. During the flt he encountered fog. He made a 180 and…NTSB FTW84LA250Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Arnett, OKAccording to the plt, the wx for his route of flt was forcast to remain VFR. En route, ceilings at 4000 to 5000 ft MSL were encountered in the vicinity of hobart, OK. As the flt continued the wx deteriorated. In order to maintain VFR conditions, the…NTSB FTW84FA242Accident · 1 fatalField investigationFinal reportBeech BE35G · Wewoka, OKThe plt was not current in IMC operations nor was the acft certified for instrument lft. After obtaining a wx briefing which forecast a chance of thunderstorms along his route, the plt departed on a x-country. En route the plt contacted Oklahoma city efas and…NTSB DEN84LA164Accident · No injuriesLimited investigationFinal reportCessna 210E · Livingston, MTWhile on a visual flight plan flight the non-instrument rated plt operated his unpressurized Cessna 210 above the clouds and up to an altitude of 16500 feet MSL. The plt stated that just after passing, 'crazy peak', he encountered extreme turbulence and the…NTSB DEN84FA155Accident · 1 fatalField investigationFinal reportCessna 180H · Broadus, MTDuring the initial takeoff climb in a westerly direction a severe wind gust from the south occurred at an alt of aprx 150 AGL. The plt turned the acft to the south and a rapid increase in alt of aprx 60-70 ft occurred. The wind stopped suddenly and the acft…NTSB SEA84FA111Accident · 4 fatalField investigationFinal reportStinson 108-3 · Portland, ORThe plt was briefed on the weather along his intended route of flt & VFR flt was not recommended. The acft departed vancouver, WA, and flew to tigard, OR. It was observed to depart tigard at about 1810 PDT. Numerous witnesses reported that at about 1815, they…NTSB LAX84LA308Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Kernville, CAAfter takeoff, the plt took a direct route (heading 150 deg) & began climbing to 7500 ft to cross over a 6300 ft pass. He encountered strong winds from the northeast & stated that he 'experienced severe downdrafts caused by mountain waves.' The plt initiated…NTSB DEN84IA152Incident · No injuriesIncident investigationFinal reportCessna U206G · Dulce, NMThe plt reported that the arpt was in a valley surrounded by mountains & the elevation was about 6800 ft. with the wind out of the northwest, rwy 33 was the most favorable for the takeoff. There was a ridge about 1/2 mi north of the arpt making it necessary…NTSB ATL84FA164Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Painter, VAAfter encountering low ceilings, the plt attempted a precautionary ldg. Upon realizing lights from the ground were on a house, a go-around was initiated with a climbing left turn. The acft then flew into trees one fourth to one half mile from the house.NTSB MKC84FA281Accident · 1 fatalField investigationFinal reportMooney M20C · New Blaine, ARDespite a wx briefing forecasting IMC and discouraging VFR flight, the non-instrument rated plt departed aprx 1 hour before the accident. Impact occurred in wooded rising terrain at an elevation of about 1,957 ft MSL at an aprx nose down attitude of 4 degs.…NTSB MKC84LA132Accident · No injuriesLimited investigationFinal reportCessna 175 · Imperial, NEWhile en route, the plt tried to circumnavigate an area of bad wx. He was in & out of rain & finally decided to reverse course. He said he inadvertently flew into a thunderstorm & lost control of the acft due to turbulence. The acft entered a steep dive, &…NTSB MKC84FA131Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Sheldon, IAAt about 1015 CDT, while en route, the plt radioed a fss & requested the Kansas city wx. VMC conditions were reported at Kansas city, but the plt was informed of an AIRMET, which provide a caution of low ceilings & reduce visibilities across his route of flt.…NTSB LAX84FA280Accident · 1 fatalField investigationFinal reportGrumman American AA-5B · Placerville, CAThe plt lived near the arpt & had been commuting to sacramento, CA for about 3 weeks. Rwy 27 was the prominant rwy & the arpt was surrounded by hills. Shortly after taking off, the acft crashed about 2 mi west of the arpt while in a right wing low attitude on…NTSB FTW84LA217Accident · No injuriesLimited investigationFinal reportHughes 500D · New Braunfels, TXDespite adverse wx which forced the plt to stop once enroute to his dest the flt was continued. Directional control was lost when the tail rotor contacted the terrain separating both tail rotor blades from the acft and torsionally shearing the tail rotor…NTSB FTW84FPJ01Accident · 2 fatalFinal reportPiper PA-22 · Byron, OKThe acft had impacted the ground at a 60 deg angle. The 1153 wx at ponca city, OK (60 mi east of the crash site) was ceilings obscured to vision & indefinite, with thunderstorms, rain & fog. The ceiling was estimated to be 200 ft obscured.NTSB DEN84LA139Accident · No injuriesLimited investigationFinal reportAerospatiale 316B · Near Dillon, COWhen the plt took off from a mountainous ski area, light to moderate snow was falling & the winds were coming up the valley at 5 to 10 KTS. During the flt, he encountered an estimated 35 kt upslope wind as he was proceeding on the upwind side of a ridge at an…NTSB CHI84FA169Accident · 4 fatalField investigationFinal reportCessna 172RG · Woodbury, MNThe acft collided with a radio antenna support cable at aprx 171 ft AGL during low altitude maneuvering in snow showers. One witness stated that the heaviest snow showers were in the vicinity of the accident site. A policeman saw the acft over a field near…NTSB LAX84FA374Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Lone Pine, CAWhen the acft did not return from a x-country flt, a search was initiated. However, the acft was not found until hikers discovered the wreckage on 6/29/84. Impact occurred at about the 9000 ft level in mountainous terrain. The outer wing panels & horizontal…NTSB ATL84FA151Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Maynardville, TNThe acft crashed in an uncontrolled state after the airframe failed in flt. Witnesses observed the acft spinning out of the clouds with parts of the airframe separating as it descended. The weather had been described to the plt in 2 wx briefings. At the time…NTSB DEN84LA138Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Albuquerque, NMThe acft had recently been sold & was being ferried to the buyer in Oklahoma. After a refueling stop at the coronado arpt, the plt took off & proceeded northeast to avoid rotor clouds associated with the sandia mountains about 8 mi east of Albuquerque, NM.…NTSB NYC84FA148Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Hopwood, PAThe ATP rated pilot obtained a complete wx briefing including forecasts of occasional moderate icing, a cleveland center wx advisory, winds aloft with temps at the flt planned alt of 6000 ft ranging from -1 to -4 deg c and pireps of moderate icing from 5000…NTSB MIA84FA149Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Panacea, FLAcft crashed in water shortly after takeoff. One witness stated the acft entered the water in a steep left bank at a high rate of descent. Witnesses also stated that at the time of the accident, the ceiling was about 50 to 200 ft MSL, visibility was less than…NTSB MIA84FA146Accident · Serious injuriesField investigationFinal reportDouglas DC-8-63 · Miami, FLThe acft encountered inflight turbulence while descending into Miami. Four people were taken to local hospitals. A flt attendant & two pax were treated & release. One pax remained in the hospital for 12 days due to back injuries. The flt attendants indicated…NTSB DEN84LA132Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Jackson, WYThe acft crashed during takeoff from Jackson airport. Investigation revealed that the plt and CFI were in the process of ferrying the acft to Washington state. The plt stated that during taxi the airport UNICOM reported the wind to be from the northeast at 18…NTSB DCA84AA022Accident · 1 fatalFinal reportMitsubishi MU-2B-60 · Burlington, CTThe acft was flown earlier in the day for a sales demonstration. On the return flt, when the landing gear were lowered, the plt thought he heard a noise emitting from the gear, although cockpit indications were normal. The acft landed at johnnycake arpt & was…NTSB LAX84FA460Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bakersfield, CAThe non-instrument rated plt departed imperial, CA on 4/18/84 at about 1845 PST. Two people reported that at 2100 to 2200 PST, they saw an acft circling in the area of cummings mountain, about 10 mi south of the accident site, but because the mountain tops…NTSB SEA84FA088Accident · 2 fatalField investigationFinal reportCessna 150L · Diamond Lake, ORThe acft was on a flt from sacramento, CA to vancouver, british columbia, via red bluff, klammath falls, eugene, portland & seattle. During a wx briefing at 0545 PST, the non-instrument rated plt was advised that VFR flt was not recommended. However, he filed…NTSB LAX84LA262Accident · No injuriesLimited investigationFinal reportMolino PIK-20B · El Mirage, CAThe plt reported that when he was 1/2 mi from the rwy at 835 ft AGL, his airspeed was 70 KTS. While descending through 400 ft AGL, his airspeed flickered 3 times to zero. The 3rd time, it stayed at zero & the glider dropped to the ground. The reported wind 11…NTSB LAX84LA257Accident · Serious injuriesLimited investigationFinal reportRaven S-55A-707 · Glendale, AZDuring a sight-seeing flt, the winds, outside air temp & propane gas burner temp began increasing, so the plt elected to land. He notified the chase crew, started a descent & anticipated making a 'drop line' landing. As the balloon began crossing over a dry…NTSB ANC84LA057Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe plt encountered IMC wx conditions & elected to make a water landing. Also, he stated that he encountered a white-out condition just prior to landing. Shortly after touching down, the acft struck a sand bar & nosed over.NTSB NYC84FA129Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Burlington, CTThe acft crashed in a steep right descending turn shortly after takeoff. The student plt flying the acft had been scheduled to fly that day but the instructor canceled the flt on account of weather. The acft was seen taxiing out ABOUT1230. After takeoff the…NTSB ATL84LA144Accident · 1 fatalLimited investigationFinal reportBrown, R. M. JR. Monnett Moni · Kill Devil Hill, NCThe acft was the 4th acft to take off of 7 scheduled to make a formation fly-by of the wright brothers national memorial. As the acft took off to join up for the flt, a thick low fog bank rolled in. The other acft departed the area, but the plt attempted to…NTSB LAX84LA249Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Fort Bidwell, CAAccording to the plt the wx blocked several of the mountain passes along the route of flight. When the wx continued to deteriorate the plt landed in a field. The main gear 'dug-in and the acft flipped on it's back.'NTSB LAX84FA251Accident · 4 fatalField investigationFinal reportGrumman AA-5A · Kamuela, HIThe acft with 4 occupants on board was being used on a sight-seeing flt to mauna loa volcano. The plt was in radio contact with hilo tower from 1503 to 1506 HST. He indicated concern about the clouds & decided not to proceed to the volcano. When the acft…NTSB ANC84LA053Accident · No injuriesLimited investigationFinal reportBeech BE-18D · Egegik, AKThe plt stated the engines loss power as a result of snow ingestion and carburetor icing upon entering clouds. According to the plt, he entered the clouds at 9000 ft MSL and encountered heavy snow. He remained IMC until approximately 100-300 ft AGL when he…NTSB SEA84FA078Accident · 2 fatalField investigationFinal reportBeech N35 · Baker, ORThe plt encountered airframe icing while en route during a x-country flt. He had filed an instrument flt plan to boise, ID, but en route, he changed destinations twice, 1st to ontario, OR, then later to Baker, ID. At 1820 PDT, he reported icing & turbulence…NTSB ATL84FA141Accident · 2 fatalField investigationFinal reportCessna 182Q · Nw.Of Abingdon, VAThe acft crashed into a mountain at the 4000 ft level about 100 ft below the crest en route to chattanooga, TN. The plt had received a pre-flt telephonic briefing that was considered current and appropriate for the flt without any special remarks. At…NTSB ANC84FA051Accident · 1 fatalField investigationFinal reportBeech F33A · Houston, AKThe acft collided with the ground in a near vertical dive. Prior to the accident, witnesses heard the eng at hi power until moments before impact. They reported the wx was cloudy & cool with light rain beginning to fall, mixed with snow. They reported the…NTSB ANC84LA050Accident · No injuriesLimited investigationFinal reportCessna U206G · Kodiak, AKAccording to the plt, he initiated a takeoff in a northerly direction, but the acft would not climb after lift-off. He chopped the pwr & the acft immediately touched down. Then the acft bounced, yawed left & the rt float hit the water sideways. The acft…NTSB FTW84FA180Accident · 4 fatalField investigationFinal reportCessna 210-5(205) · Beaumont, TXThe acft was flown into IMC wx after the flt had been advised by the wx service that VFR flt was barely feasible. No wx briefing by FAA was recorded & no flt plan was filed. The accident occurred during the hrs of darkness. A witness near the accident site…NTSB DEN84FA122Accident · Serious injuriesField investigationFinal reportCessna 414A · Douglas, WYDuring an approach for a downwind landing, the acft stalled & impacted the ground 192 ft short of rwy 28. The plane had encountered icing conditions during flt & ice was still adhering to the acft as the plt made an approach for landing. Instrument conditions…NTSB MKC84FA115Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Garden City, KSThe plt departed kendallville, IN, at about 1800 EST & made a refueling stop at topeka, KS. At topeka, he obtained a wx briefing for a flt to pueblo, CO, his intended destination, & was advised of marginal VFR to IFR conditions on his proposed route. He then…