NTSB investigations
244 cases where the first occurrence was “On ground/water 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\" = 330) 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" = 330) 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 BFO92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dayton, OHAn encounter with a strong wind gust which resulted in loss of control and nose over.NTSB LAX92LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Douglas, AZAn encounter with an unforecasted high velocity wind gust which caused the airplane to nose over to an inverted position.NTSB ATL92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Aiken, SCThe unexpected, gusting crosswind.NTSB MIA92LA092Accident · No injuriesLimited investigationFinal reportCessna 170A · Miami, FLFailure of the pilot in command to maintain directional control. Contributing to the accident was the unfavorable wind (windshift).NTSB SEA92LA054Accident · Serious injuriesLimited investigationFinal reportMichael Conner Avid Flyer · Nampa, IDThe pilot's inadequate weather evaluation. A factor in the accident was the unfavorable wind.NTSB ATL92LA046Accident · No injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe unfavorable wind conditions encountered by the flight during taxi.NTSB NYC92LA058Accident · No injuriesLimited investigationFinal reportPiper PA60-700P · Wooster, OHThe pilot allowed the airspeed to decay, delayed the go-around, and prematurely rotated the airplane which resulted in the airplane over running the runway. Factor in the accident were the pilot inadequately planned the approach; freezing drizzle and runway…NTSB ANC92IA030Incident · No injuriesIncident investigationFinal reportPiper PA-31-T3 · Anchorage, AKThe pilot's continued taxi after becoming lost or disoriented. Factors relating to the accident were the whiteout conditions caused by the freshly falling and blowing snow and the inadequate snow removal by airport personnel.NTSB MIA92LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bunnell, FLImproper handling of the aircraft by the pilot-in-command and failure to maintain directional control. Contributing to the accident was the lack of total experience of the pilot-in-command.NTSB ATL91LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Knoxville, TNThe pilot's failure to accurately evaluate the weather conditions before attempting a takeoff and his delay in aborting the takeoff procedure. A factor was the dark night.NTSB MIA91LA173Accident · No injuriesLimited investigationFinal reportCessna 172N · Punta Gorda, FLFailure of the pilot to observe the windsock before landing resulting in failure to maintain directional control after landing with a quartering tailwind. The airplane collided with a ditch. Contributing to the accident was lack of total experience of the…NTSB LAX91LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Crescent City, CAThe failure of the pilot to employ proper flight control positioning to maintain control of the airplane during taxi.NTSB NYC91LA131Accident · No injuriesLimited investigationFinal reportCessna 185C · New Hanover, PAThe loss of directional control by the pilot during a crosswind takeoff and subsequent collision with rough terrain. A factor related to the accident was the pilot's lack of experience in this make and model airplane.NTSB LAX91LA208Accident · No injuriesLimited investigationFinal reportCessna C172M · Coalinga, CAThe pilot's encounter with a dust devil which resulted in his loss of control during landing rollout.NTSB SEA91LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Drewsey, ORThe pilot delayed in going-around.NTSB MIA91LA133Accident · No injuriesLimited investigationFinal reportCessna 150L · Lake Wales, FLFailure of airport personnel to perform airport maintenance which resulted in inaccurate wind information due to a deteriorated windsock, and failure of the student pilot to maintain directional control during the landing roll with a tail wind. Also,…NTSB MIA91LA119Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Bay, FLLoss of control during the landing roll due to failure of the pilot to apply aileron control to prevent the airplane from drifting off the runway due to a crosswind and failure to maintain directional control. Contributing to the accident was the pilot's lack…NTSB MIA91LA097Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hattiesburg, MSOn ground encounter with a wind gust and failure of the pilot to maintain directional control of the airplane during the landing roll, resulting in the collision with a ravineNTSB NYC91LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe instructor pilot's failure to maintain control of the airplane during landing in a strong crosswind.NTSB NYC91LA082Accident · Minor injuriesLimited investigationFinal reportLatham Pitts Special S-1C · Glens Falls, NYA loss of control on the ground due to the improper operation of flight controls by the pilot. A factor related to the accident was the variable wind.NTSB NYC91LA076Accident · No injuriesLimited investigationFinal reportGulfstream G-1159 · Cleveland, OHThe pilot's improper in flight decision to land on a snow covered runway. The lack of adequate braking action resulted in the pilot intentionally ground looping the airplane and overloading the main landing gear. Factors related to the accident were snow…NTSB MIA91LA081Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plant City, FLFailure of the pilot to maintain proper alignment during the landing roll, excessive rudder input, and loss of directional control resulting in the collapse of the right main landing gear.NTSB SEA91LA052Accident · No injuriesLimited investigationFinal reportCessna 182Q · Anacortes, WAThe pilot improper planning/decisions. The high wind was a factor.NTSB LAX91LA043Accident · No injuriesLimited investigationFinal reportCessna 172 · Tonopah, NVThe airplane's encounter with a wind gust while taxiing from landing. Contributing factors related to the pilot's improper weather evaluation and his lack of experience in making weather evaluations.NTSB MIA91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fort Myers, FLThe failure of the pilot to maintain directional control while landing with shifting gusty winds.NTSB SEA90LA195Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Enumclaw, WAThe pilot did not maintain directional control of the airplane during the landing roll in gusting wind condition.NTSB NYC90LA217Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Red Hook, NYThe pilot's loss of directional control and departure off the side of the runway during the landing roll, resulting in a collision with a tree. Contributing to the accident was the pilot's lack of expereince in the aircraft.NTSB ANC90LA179Accident · No injuriesLimited investigationFinal reportCessna U206 · Twin Lake, AKInadequate compensation for wind condition.NTSB MIA90LA172Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Destin, FLThe pilots failure to obtain accurate wind information resulting in the airplane being blown off the runway on landing when a gust which exceeded the crosswind capability of the airplane was encountered.NTSB CHI90LA224Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Sturgis, SDPoor planning/decision, flight into known adverse weather conditions and over confidence in personal ability by the PIC. Contributing factors were thunderstorms, turbulence and unfavorable wind.NTSB LAX90LA273Accident · No injuriesLimited investigationFinal reportCessna 172P · Mammoth Lakes, CAInadvertent encounter with high velocity winds.NTSB DEN90LA132Accident · No injuriesLimited investigationFinal reportLund Mustang II · Hamilton, MTThe inadequate compensation for the wind conditions by the pilot.NTSB LAX90LA207Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Colusa, CAThe pilot's failure to maintain directional control during touchdown.NTSB CHI90LA125Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Akron, OHPilot's failure to maintain aircraft control while taxiing in gusty crosswind conditions.NTSB FTW90LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · San Angelo, TXThe student failed to maintain directional control of the aircraft during takeoff in variable wind conditions.NTSB LAX90LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Soledad, CAPilot's failure to maintain directional control during takeoff. Contributing factors were the gusty wind and the crosswind conditions.NTSB DEN90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COThe pilot's encounter with severe turbulence during landing, and his failure to divert to an alternate airport after becoming aware of the wind conditions. Contributing to the accident was the pilot's low level of experience.NTSB NYC90LA058Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Roxbury, MEPilot factor in that he failed to plan the approach for gusty wind conditions and impacted trees short of the runway.NTSB DEN90LA038Accident · No injuriesLimited investigationFinal reportCessna 182M · Pierre, SDInadequate compensation for the wind conditions by the pilot. An on ground encounter with wind gusts is considered an additional cause.NTSB SEA90LA033Accident · No injuriesLimited investigationFinal reportCessna 172A · Reno, NVThe pilot's improper use of the flight controls. Factors in the accident were the high, gusty wind conditions, the pilot's self induced pressure to arrive at work on time, and his lack of total pilot experience.NTSB CHI90LA037Accident · No injuriesLimited investigationFinal reportCessna 172G · Savoy, ILImproper planning/decision by the pilot, which resulted in his inability to maintain control of the aircraft. A factor related to the accident was: the adverse wind condition.NTSB CHI90LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's inadequate compensation for wind conditions. Factors related to the accident were: inadequate supervision by the student's flight instructor (CFI), the student's failure to obtain weather information (use a preflight briefing service)…NTSB NYC90LA012Accident · No injuriesLimited investigationFinal reportCessna 180H · Niagara Falls, NYThe pilot's loss of directional control during takeoff roll due to strong wind gusts.NTSB MIA90FA008Accident · 1 fatalField investigationFinal reportMcdonnell Douglas DC-9-31 · Orlando, FLInadequate weather evaluation and inadequate supervision of the ground guide (mechanic) by company/operator/management personnel, failure of the ground guide to follow safety procedures, and the weather condition (lightning).NTSB ANC89LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's overconfidence in himself and the aircraft, and the strong/gusty wind conditions.NTSB LAX89LA306Accident · No injuriesLimited investigationFinal reportCessna A185F · Big Bear City, CAThe pilot's inadequate compensation for the unfavorable wind conditions.NTSB MIA89LA215Accident · No injuriesLimited investigationFinal reportCessna 188 · Canton, MSThe pilot's attempted flight in known adverse weather conditions. Factors related to the accident were: adverse weather conditions and the presence of the parked aircraft near the runway.NTSB CHI89LA159Accident · No injuriesLimited investigationFinal reportCessna 170A · Brookfield, WIThe pilot-in-command's failure to take proper corrective action after encountering a wind gust on landing.NTSB FTW89LA110Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Midland, TXImproper planning/decision by the pilot, which resulted in a loss of aircraft control. The high, gusty, crosswind condition was a related factor.NTSB MIA89LA161Accident · No injuriesLimited investigationFinal reportCessna 182R · Tutwiler, MSLoss of control of the aircraft due to an encounter with a dust devil while on the ground.