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 MKC85FA089Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Wakeeney, KSOn a x-country flt from dodge city, KS, to hill city, KS, the plt encountered IFR wx conditions around Wakeeney, KS. The IFR conditions were not forecast for his area of flt. A 2000 CST observation at hill city, KS, was indicating IFR conditions existing aprx…NTSB LAX85LA222Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Felton, CADuring the preflight of the acft, the plt said he observed the wind conditions at the airport as from the north at about '5 to 10 KTS, which indicated a left crosswind. The airport is immediately surrounded by pine trees which average about 60 ft in height.…NTSB NYC85FFA02Accident · Serious injuriesFinal reportCessna 177 · Claryville, NYThe acft impacted trees during a precautionary lndg due to the plts EST of a low fuel state. The flt had proceeded r enroute to an intended dest of oxford me from frederick MD without filling a flt plan. After aprx 3 hrs of flying on a 60 degree mag hdg the…NTSB CHI85FA174Accident · Serious injuriesField investigationFinal reportBoeing 727-223 · Little Rock, ARThe aircraft was paralleling a line of thunderstorms and needed to get on the other side of the line to get to his destination. The center controller suggested that he reverse course to fly around the closer end of the line but the pilot decided to penetrate…NTSB ATL85FA146Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dundee, MSPlt obtained three preflight wx briefings then filed IFR using an assumed name. Routine communications until 2117 CST when pilot reported in a cell and said he wanted to make a 180 degree turn. Cleared for right turn. Radar and comm contact with aircraft lost…NTSB MKC85FA088Accident · 2 fatalField investigationFinal reportCessna 310G · Mena, ARThe acft crashed out of control after an in-flt airframe failure. The plt had entered an area of thunderstorms after being advised that VFR flt was not recommended in that area. The plt was single eng rated and his flt time in this z eng acft was 18 hrs.NTSB LAX85FA214Accident · 1 fatalField investigationFinal reportBeech A45 · Fallbrook, CAThe plt was flying to his home arpt under visual flight rules (VFR) from his place of employment when he encountered low ceilings & visibilities. He contd at low alt along an interstate highway toward his original destination. A witness reported that the plt…NTSB SEA85LA094Accident · No injuriesLimited investigationFinal reportHelio H-295 · John Day, ORReportedly, the acft encountered airframe icing conditions during flt, & subsequently, mushed into trees on wooded terrain. Elevation of the crash site was about 4500 ft. about 95 mi west at redmond, OR, the wx was in part: 800 ft overcast, 3 mi visibility,…NTSB NYC85FA110Accident · 2 fatalField investigationFinal reportCessna R182 · Hamilton Twnshp, NJThe plt's original destn was bader field at atlantic city. However, during arrival, he diverted to the atlantic city arpt, since bader field was below mins. Vectors were provided for an ILS rwy 13 apch & the plt was cleared for the apch. He was then cleared…NTSB LAX85FA218Accident · 2 fatalField investigationFinal reportCessna 152 · Sunland, CAThe plt got his pvt plt cert 6 days prior to the accident & planned a local flt to a neighboring arpt just over a coastal mtn range from the dep aprt. 9 NM north of the deparpt, the accident site is almost on a direct line between the dep & dest arpts. The…NTSB LAX85FA215Accident · 5 fatalField investigationFinal reportPiper PA-28-235 · Castaic, CAThe pilot requested and received a weather briefing for the cross country flight. VFR flight was not recommended due to multiple cloud layers and mountain obscurement. The wreckage was located the following morning at the 3,500 foot elevation in mountainous…NTSB DEN85LA122Accident · Minor injuriesLimited investigationFinal reportBeech BE36 TC · Silver City, NMThe acft was substantially damaged during a wx encounter near Silver City, NM. Icing and turbulence in IFR conditions prevailed at the time. The plt initiated a climb from 15,000 ft to 17,000 ft because of rime ice conditions. The autopilot was used during…NTSB LAX85LA211Accident · No injuriesLimited investigationFinal reportCessna T210N · White Mountain, AZWhile cruising at 12,000 ft MSL, the acft began picking up ice. The plt continued flying toward his intended destination & climbed to 14,000 ft MSL. The acft's windshield completely iced over. The plt lost control of the acft & it went into an uncontrolled…NTSB NYC85LA107Accident · No injuriesLimited investigationFinal reportBeech D95A · Boston, MAAccording to the plt, the gear warning horn circuit breaker was pulled en route to stop the horn from sounding while the pwr was at a low setting because of turbulence. The circuit breaker was not reset prior to landing. During the apch,the plt lowered the…NTSB LAX85LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Moorpark, CAThe student plt became disoriented while on a solo x-country flt during wich he was on top of an overcast. Fuel exhaustion occurred while he was being radar vectored to an arpt. A forced landing was attempted on a freeway offramp and the acft's wing struck a…NTSB FTW85LA183Accident · No injuriesLimited investigationFinal reportMitsubishi MU2J · Patterson, LAOn visual final apch to the arpt at night the acft entered ground fog. Reflection of the landing lights in the fog was distracting. The acft landed in the adjacent seaplane landing area instead of on the hard surface rwy. A subsequent inspection of the aprt…NTSB LAX85FA198Accident · 1 fatalField investigationFinal reportCessna 140 · Petaluma, CAThe ATP plt initiated a short x-country flt at night in an acft with no attitude gyro instruments. Just before the acft crashed, witnesses heard the acft. They reported that the eng sounded like the plt was doing stunts or sharp turns. They said they could…NTSB DEN85LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Grant, NMThe acft crashed during takeoff from a dirt strip near Grant, NM, while on a pleasure flt. VMC conditions prevailed and no flt plan was filed. The plt & his 3 occupants were not injured. The plt reported that a dust devil caught the acft at an alt of 35-50 ft…NTSB LAX85LA196Accident · 1 fatalLimited investigationFinal reportCessna P210N · Santa Barbara, CAAfter receiving a special VFR clearance to depart the control zone to the northeast the non-instrument rated plt took off on a southeasterly heading over the water under low ceilings and in low visibility. A controller observed the acft start a right turn…NTSB NYC85FA100Accident · 2 fatalField investigationFinal reportCessna 150G · Acme, PAAt 1221 EST, the plt was advised by a fss that VFR flt was not recommended due to widespread IFR conditions along the route of flt & at the destination. The plt departed at aprx 1430 hrs. At 1700 hrs, witnesses saw the acft flying westbound at low altitude in…NTSB CHI85LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Port Huron, MIAfter a practice instrument apch, the plt (PIC) entered the traffic pattern to land on rwy 23. While in the pattern, theair became very turbulent. UNICOM reported the wind was from 270 deg at 20 gusting 35 KTS. On final apch with the flaps fully extended, the…NTSB CHI85FA157Accident · 4 fatalField investigationFinal reportCessna 210L · Muncie, INThe plt took off at 1125 EST after receiving a wx briefing. While en route, the forecast wx for the destn bcm worse & a SIGMET (1E) was issued. At 1444, the plt contacted ft wayne fss & had his VFR flt plan extndd 1 hr. He neither requestednor received…NTSB NYC85FA099Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Nantucket, MAAcft collided with trees during final approach to runway 24. No evidence of pre-impact failure or malfunction of the acft was found. Reported wx at crash site indefinite 100 feet sky obscured. RVR 2400 feet. Acft should have encountered a decreasing headwind…NTSB DEN85LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Garneill, MTThe plt reported that during a night x-country flt, he encountered marginal (obscured) wx & reversed course to return to the departure point. He stated that while he was returning, he 'dozed off a little bit' & when he awoke, he saw a mountain directly ahead.…NTSB CHI85FA156Accident · 3 fatalField investigationFinal reportCessna 172N · White Cloud, MIAt about 0250 EST, control tower psnl at the grand rapids arpt heard a 'mayday' call from N23TC, but when they tried to communicate with the acft, there was no response. The call was repeated svrl times. A check at the local arpt revealed there was an acft…NTSB CHI85FA153Accident · 1 fatalField investigationFinal reportBeech N35 · La Porte, INThe thousand hour plus instrument rated plt filed IFR into a known area of three and four level thunderstorms. While being drct by ATC it was noted that headings flown were very erratic. When questioned by ATC the pilot replied 'stand by'. Shortly afterward…NTSB NYC85LA096Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsfield, MADuring a preflt wx briefing, the plt was advised of possible moderate icing in clouds from the surface to 4000 ft. while in flt, structural icing conditions were encountered & rime ice accumulated on the windshield. Also, carb ice conditions were encountered…NTSB NYC85LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Red Hook, NYDuring flt, a Piper PA-32R-201, N2263Q, & a bainbridge jodel F-12, N5700, encountered structural icing conditions. The windshields of both acft became covered with ice which restricted the forward visibility of the occupants in both acft. N5700 landed 1st.…NTSB DEN85LA104Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Casper, WYBefore reaching the destination, the acft encountered turbulence & the passenger became ill. The plt tried to land on the east-west rwy, but the x-wind was too strong, so he then entered a pattern for rwy 3. After turning into the wind for a landing, the acft…NTSB DEN85FA103Accident · 1 fatalField investigationFinal reportGulfstream 681 · Calhan, CODuring a xcountry flt from WI to CA and return, the noninst, low experienced pvt plt, flew into IMC conditions. The acft impacted flat snow-covered grd, destroying the acft and fatally injuring his pax. Exam of wreckage revealed no evidence of pre-acc…NTSB MKC85FA078Accident · 2 fatalField investigationFinal reportCessna 182A · Onxy, ARAt 1230 CST on 3/27/85, the plt & his wife departed on a x-country flt, but did not arrive at their destination. When family members became concerned, a search was initiated. The wreckage was located on 3/31/85 where the acft collided with trees & crashed on…NTSB DEN85FA102Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Vail, COThe plt did not obtain a wx briefing, file a flight plan or refuel the acft prior to departing for eagle Colorado. The acft departed at 1800 under VFR cond. The plt reported over minturn co at 2019. Witnesses at Vail co stated that the wx cond were poor from…NTSB LAX85LA182Accident · 2 fatalLimited investigationFinal reportCessna P210N · Mountain Pass, CAThe non-instrument rated plt departed into a weather front. VFR flt was not recommended. Flt precautions existed for icing, turbulence & mt obscuration. The radar chart showed light to moderate rain with isolated thunderstorms. The acft was issued a clearance…NTSB NYC85FA083Accident · 1 fatalField investigationFinal reportCessna 401A · Dorset, VTThe plt was about 30 miles from rutland when he radioed the arpt for weather info. He was informed that clouds were 1500 ft broken and 2700 ft overcast with snow, light fog and 5 miles visibility. The plt responded that he would call again when he got closer…NTSB LAX85FA178Accident · 1 fatalField investigationFinal reportCessna 150F · Lee Vining, CAThe acft collided below the crest of an 8100 ft (MSL) mtn on a flt from mammoth-june lakes arpt (mmh), mammoth, CA, to reno, NV, while executing a left turn course reversal. There were no witnesses to the accident. Witnesses reported seeing the acft flying at…NTSB MIA85FA123Accident · 2 fatalField investigationFinal reportAronson Falco F8L · Gainesville, FLThe plt received a wx briefing & filed an IFR clnc, then departed VFR. Except for a hdwnd, the 1st part of the flt was normal. In the vcnty of macon, GA, the plt requested & received an IFR clnc. Later, he elected to divert to the gaines- ville rgnl arpt &…NTSB DEN85FA097Accident · 1 fatalField investigationFinal reportMooney M20F · Deming, NMDuring preflt & inflt wx briefings, the plt was advised that mountains along his route were obscured by clouds & precip. Also, he was cautioned about moderate icing in clouds & precip at or above the freezing lvl. While en route, the plt obtained clearance to…NTSB DEN85FA096Accident · 3 fatalField investigationFinal reportPiper PA-28 · Logan, UTThe plt (non-inst rated) & 2PAX dept Logan airport under extreme IMC conditions. Visability in ice fog was down to just a few feet. The a/c crashed during a rt turn after t/o.there were no survivors.NTSB MKC85FA070Accident · 2 fatalField investigationFinal reportCessna T210R · Eli, NEThere were no witnesses to the takeoff or the accident. A flt plan was not filed and no radar data on the flt was found. The owner of N6101U estimated the takeoff time to be 2130 CST, mar. 12 and the plt told the owner he was going to Utah. The wreckage of…NTSB ATL85FA112Accident · 4 fatalField investigationFinal reportBell 206L · Dauphin Island, ALPlt departed for offshore oil rig 3 times. Two times reported returning due to fog. After third report, plt said he was IFR. No further radio communication. Wreckage indicative of high speed water impact. Dense fog and low ceiling reported offshore south of…NTSB ATL85FA113Accident · 2 fatalField investigationFinal reportCessna 182 · Le Banon, VAThe acft impacted trees and came to rest 400 ft downslope from the top of clinch mountain. The non-instrument rated plt departed sprinfield, MO, with a ceiling of aprx 300-400 ft AGL. The plt then landed at cookeville, TN, where he received a wx briefing and…NTSB CHI85LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Lacon, ILWhile on final apch moderate turbulence was experienced. A 200 to 300 foot verticle loss of alt occurred. The plt added pwr and increased the pitch attitude. Before alt could be regained the acft contacted a utility pole. The apch was being made to rwy 18.…NTSB MIA85FA112Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Jacksonvile, FLThe single eng land, pvt plt had an instrument rating, but had no rating to fly multi-eng acft. While on an illegal flt with marijuana on board, he contacted jacksonville apch control & advised that he could not see the ground due to dense ground fog, the…NTSB MKC85FA066Accident · 3 fatalField investigationFinal reportPiper PA-23 · Cedar Rapids, IAPlt reported no forward vis due to ice on windshield. N1291P then diverted to cid which has rapcon. The temp at the surface was 32 degs f but was reported to be higher at 4,000 ft MSL. The flt climbed to 4,000 ft and began losing the ice but then reported…NTSB CHI85LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Lebanon, INThe non-instrument rated plt made a forced landing in a muddy fld due to a low fuel state and IFR conditions. The acft nosed over upon touchdown. There was no record found of the plt having received a wx briefing.NTSB ANC85LA050Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Moses Point, AKAprx 15 miles se of Moses Point the helicopter encountered deteriorating wx. A descent was made to 50 ft above the ice at an airspeed of about 50 KTS. At this time a white out condition was encountered and a right turn was initiated. The right skid contacted…NTSB ATL85FA106Accident · 1 fatalField investigationFinal reportCessna 152 · Warsaw, NCLow time, non-instrument rated plt delayed departure because of unexpected deterioration of weather. Fss briefer advised wx would improve, better toward destination arpt. Wx conditions continued to worsen after briefing, worse than fcst. Plt departed 3 hrs…NTSB CHI85LA124Accident · No injuriesLimited investigationFinal reportBeech A36 · Traverse City, MIAccording to the plt, no icing pireps or sigmets were received during his preflt wx briefing. However, the NWS briefer stated that he told him of one PIREP & one SIGMET concerning icing that affected his proposed route of flt. En route to his destination, the…NTSB NYC85LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, NYWhile en route, the plt encountered strong, gusty winds & moderate to severe turbulence. After arriving at the destination arpt, he made 3 approaches to rwy 21. He stated that wind shear caused up & downdrafts & that the acft hit the rwy hard & ballooned.…NTSB FTW85LA121Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Holmwood, LAThe acft was 1 of 2 that were being repositioned form 1 ag strip to another. While en route, the flt encountered dense fog & the lead plt initiated a 180 deg turn. During the turn, the 2nd acft (N60885) was about 100 ft in trail of the 1st acft at aprx 150 ft…