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 DEN88LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gallup, NMThe private plt & his wife were starting a cross-country personal transportation flt. The acft was loaded to near max gwt, & the fss had reported a density alt of 9,600 ft to the plt. After takeoff on a 6,300 x 100 ft, asphalt rwy, the plt said the acft…NTSB LAX88LA255Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Pilot Hill, CADuring a local sightseeing flight, just prior to touchdown, the Pilot reported that a gust of wind caught the balloon. The Pilot made a high wind landing. The balloon was dragged several feet before coming to rest. The Pilot stated that afterward the winds…NTSB DEN88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallup, NMPrior to takeoff from the 6469 ft MSL airport, the pilot leaned the mixture at 2000 RPM. Density altitude was aprx 9100 ft MSL. The 10-DEG flap takeoff and climbout to 300 ft AGL was said to be normal initially; then the aircraft began losing altitude…NTSB MKC88FA124Accident · 1 fatalField investigationFinal reportCessna 172G · Sarcoxie, MOWitnesses at the acdnt site characterized the wx as having a low ceiling with fog. They rprtd they saw the acft 'appear out of clouds' in a steep descent. The acft then began to 'pull up;' however, during recovery from the dive, the acft struck trees &…NTSB NYC88LA178Accident · No injuriesLimited investigationFinal reportChampion 7GBC · Staten Island, NYThe pilot stated that after flying into a thunderstorm he encountered strong turbulence, heavy downdrafts and rain, which forced him into the water. When he realized that he was going down he dropped the banner he was towing 'but the airplane didn't want to…NTSB MKC88FA119Accident · 4 fatalField investigationFinal reportCessna 320 · Atwood, KSThe PIC had deptd the denver metro area carrying pax to vacation in Indiana. No flt plan was filed and there was no record of a preflt wx brief. The flt progrsd without any known difficulty until reaching the colorodo/kansas border. The PIC rqstd and rcvd wx…NTSB LAX88FA246Accident · 1 fatalField investigationFinal reportCessna 152 · Verdi, NVFailure of the pilot to gain sufficient altitude prior to negotiating mountainous terrain with forecast high winds. Contributing to this accident was the weather phenomena known as 'mountain wave' which created downdrafts that exceeded the aircraft's climb…NTSB DEN88LA146Accident · No injuriesLimited investigationFinal reportCessna 188 · Sentinel Butte, NDThe pilot took off from his private airstrip near Sentinel Butte, ND, en route to beach, ND. He said there was a narrow cloud ahead, approximately 5-8 miles long, and emitting lightning, but it did not appear to him to threaten flight safety. The pilot said…NTSB ATL88FA254Accident · 1 fatalField investigationFinal reportCessna T207 · Petros, TNNTSB SEA88FA120Accident · 2 fatalField investigationFinal reportCessna 150F · Skykomish, WAThe noninstrument rated pilot was attempting to follow us highway 2 westbound across the cascades mountains. According to several witnesses upon cresting the stevens pass area at an altitude of 4300 feet MSL (approximately 250 feet AGL) he encountered low…NTSB DEN88FA141Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Capitan, NMNTSB FTW88FA125Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Anson, TXInadequate weather evaluation-pic; flight into known adverse weather, inadvertent-pic; design stress limits exceeded by PIC; thunderstormNTSB DEN88FA138Accident · 2 fatalField investigationFinal reportDouglas A-26C · Cimarron, NMThe plt rcvd a wx briefing before takeoff, but did not file a flt plan. Drg the flt, the acft (Douglas A-26C, N4813E) crashed in mountainous terrain at an elev of about 11,200' near baldy mountain. Scouting personnel, who were camped in the vicinity, rprtd…NTSB BFO88LA061Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Salisbury, MDBefore the flt, the crew received a severe wx warning concerning wx along the route of flt. The captain informed the flight attendants to be prepared to have passenger service completed early and to be seated before the descent. Before encountering…NTSB SEA88LA115Accident · Minor injuriesLimited investigationFinal reportPeterson J-4 · Ephrata, WAThe glider plt was maneuvering for a thermal when he encountered a downdraft. The plt said insufficient altitude remained for an airport landing. An off-airport landing on rough terrain resulted in damage to the glider.NTSB LAX88LA221Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103A · Fremont, CADuring a local flt, the glider encountered a windshear and lost altitude. The pilot was unable to regain the lost altitude and a forced landing was made where during the landing roll the glider collided with rough terrain.NTSB ATL88FA191Accident · 1 fatalField investigationFinal reportCessna 421B · Knoxville, TNNTSB SEA88LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Wenatchee, WAAirframe ice was accumulating on the aircraft at 13,000 feet so the pilot requested an altitude of 14,000 feet. At 14,000 feet the pilot lost control of the aircraft and descended down to 6,500 feet before recovering. The pilot had stated that he felt he had…NTSB DEN88DTK01Accident · Serious injuriesFinal reportEagle DW-1 · Ferney, SDThe ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and…NTSB LAX88FA215Accident · 4 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAInflight encounter with forcasted severe icing and turbulence beyond the capability of either the aircraft or the pilot , which led to an inflgiht loss of control. Factors in the accident were the pilots lack of understanding of high altitude flight aspects…NTSB LAX88FA197Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pinecrest, CAPilots decision to continue VFR flight through a mountain area after encountering instrument meteorological conditions.NTSB DEN88FA112Accident · Serious injuriesField investigationFinal reportTaylorcraft BC12-D · Albuquerque, NMThe pilot and his passenger decided to make a local personal flight. The pilot said he saw a squall line approaching the airport, but thought he could get off the ground before it arrived. He took off and started a left crosswind turn. A gust of wind lifted…NTSB MIA88IA177Incident · Minor injuriesIncident investigationFinal reportBritish BAC-111-203 · Orlando, FLThe flt was descending thru 13000 ft when turbulence was encountered. Four passengers and two flight attendents were injured. The passengers were injured when their seatbelts' end fittings detached from their seats' tie-down shackles and the passengers struck…NTSB FTW88IA109Incident · No injuriesIncident investigationFinal reportBoeing 737-3T0 · New Orleans, LAA double engine flameout due to water ingestion which occurred as a result of an inflight encounter with an area of very heavy rain and hail. A contributing cause of the incident was the inadequate design of the engines and the FAA water ingestion…NTSB ATL88LA181Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1A · Blue Ridge, GAThe plt reported that he encountered deteriorating wx conditions during the flt. He made a 180 degree turn and other course changes in an attempt to return to better wx, but was unable to maintain VFR flt. He subsequently elected to make a precautionary ldg…NTSB SEA88LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ritzville, WAWhile on an aerial applications flight, the pilot was climbing to clear power lines when a whirlwind was encountered. The aircraft struck a power pole and descended onto the ground.NTSB DEN88FA109Accident · 5 fatalField investigationFinal reportCessna T210N · Albuquerque, NMNTSB DEN88LA108Accident · No injuriesLimited investigationFinal reportCessna 210L · St. George, UTNTSB FTW88LA098Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Sour Lake, TXThe acft struck trees and the grnd during a night cross country in marginal weather. The non-instrument rated pvt plt stated that he was flying in cruise flt at 1250' MSL when he hit trees. The closest wx station recorded 1200 overcast with 5 miles…NTSB LAX88FA192Accident · 2 fatalField investigationFinal reportBeech 35 · Santa Paula, CAPilot's failure to maintain an airspeed at which the aircraft is controllable and above the stall speed.NTSB CHI88LA108Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Minneapolis, MNThe pilot was executing a downwind takeoff, the winds reportedly gusting to 25 knots, loaded with two passengers, when just after takeoff the pilot stated the helicopter experienced a loss of power. The pilot then attempted to execute an autorotation, but…NTSB SEA88LA088Accident · No injuriesLimited investigationFinal reportCessna 172M · Hood River, ORPlt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…NTSB MIA88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Freeport, BahamasThe pilot's inadvertent encounter with adverse weather.NTSB NYC88LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Jamestown, NYThe Piper PA-28-181 departed with two pilots onboard. About one hour after takeoff, the PIC got very sick and could not continue flying. She experienced a severe headache and vomitting. The non-instrument rated pilot continued the flight. The aircraft made…NTSB MKC88LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55 · Burlington, IAWhile attempting to land the balloon during a commercial operation, a dust devil was encountered. The balloon and gondola twisted and pitched violently. During a hard landing, the PIC was thrown from the aircraft, and the aircraft continued to bounce along…NTSB SEA88FA084Accident · 1 fatalField investigationFinal reportMaule M5-210C · Bend, ORPlt filed VFR after advised VFR not recommended. Witness observed acft on course for dest at low alt over hiway. Witness EST ceiling at 100 feet, visibility poor in mod snow. Acft observed to execute sharp left turn amd impact rising terrain. Corrective…NTSB DEN88FA100Accident · 2 fatalField investigationFinal reportCessna 182J · Rapid City, SDThe plt received a wx briefing prior to departure from miles city, MT. The briefing indicated wx conditions less than VFR with icing conditions. The plt departed and landed approximately 1 hour later to remove ice from his acft. The plt departed a second time…NTSB LAX88FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Essex, CAFailure of the pilot to maintain sufficient altitude to ensure terrain clearance while mountain flying.NTSB LAX88FA163Accident · 2 fatalField investigationFinal reportAerospatiale AS355F · Cajon, CAPilot's failure to maintain altitude.NTSB SEA88FA078Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300T · Port Angeles, WADrg arr, the flt was handed off to whidbey island apch ctl at whidbey island (nuw) naval air stn (nas). Nuw was 35 mi NE of the destn (fairchild intl arpt/clm), at Port Angeles, which had no operg ctl twr. The plt was given the nuw wx, which was 400 scat,…NTSB LAX88FA161Accident · 4 fatalField investigationFinal reportCessna 172G · Los Banos, CAFailure of the pilot to maintain control of his aircraft to avert a collision with the ground.NTSB DEN88FA098Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Pintura, UTThe plt and two pax departed overton, NV destined for sundance, WY. Witnesses stated that the acft took off under an overcast and followed interstate 15 northbound. A witness driving on the interstate said that he saw N2738R at aprx 600 ft AGL over the…NTSB DEN88FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Milford, UTThe plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…NTSB ATL88DMG05Accident · 2 fatalFinal reportBellanca 14-19-3A · Boone, NCNTSB ATL88LA135Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Briceville, TNThe plt stated that he had departed coffeyville, KS on apr 5 for an airplane delivery ferry flt to lincolnton, NC he landed at cape girardeau and remained overnight due to enroute weather. He deptd cgi the following morning following a wx brief that indicated…NTSB LAX88FA148Accident · 5 fatalField investigationFinal reportPiper PA-31-325 · Orinda, CABefore the acdnt, witnesses observed the acft circling in a valley beneath a low cloud layer & below the surrounding hilltops. They estimated the ceiling was 400' obscured. Two witnesses said the acft entered clouds before it crashed. A 3rd witness, who was a…NTSB ATL88FA136Accident · 7 fatalField investigationFinal reportPiper PA-32R-301T · Middlesboro, KYThe plt received preflt wx briefing that stated VFR flt was not recommended due to low pressure system affecting proposed flt path. Wx forecast included tornadoes, hail, thunderstorms to 42,000', moderate rime icing, moderate turbulence, wind gusts to 70 KTS,…NTSB MKC88FA070Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Springfield, MOWhile enroute to a vehicle accident the pilot encountered instrument flight conditions. As a result of flying into fog and turning on his night scanner light, the pilot experienced spatial disorientation and failed to maintain aircraft control. The pilot…NTSB ATL88FA131Accident · 1 fatalField investigationFinal reportMooney M20G · Jasper, GABefore depg blairsville, the plt reqd the current atlanta wx for the dekalb-peachtree arpt & for an afternoon outlook. He told the briefer that he had received a previous wx briefing. He was informed that the forecast was for instrument conds until noon with…NTSB FTW88FA084Accident · 1 fatalField investigationFinal reportCessna 172M · Hope, ARThe non-instrument rated pilot initiated the flight into known adverse weather after being advised during a preflight weather briefing that VFR flight was not recommended. About 40 minutes before the crash, he called el dorado (Arkansas) radio and requested…