NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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\" = 260) 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" = 260) 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 LAX99LA179Accident · No injuriesLimited investigationFinal reportHamilton Pitts Special SC-1 · Sacramento, CAThe pilot's misjudged flare, which led to bounced landing, and his failure to maintain directional control of the aircraft during the bounced landing recovery.NTSB MIA99LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rock Hill, SCThe pilot's failure to maintain directional control. Related factors were the crosswind and the pilot's lack of experience.NTSB CHI99TA149Accident · Minor injuriesFinal reportCessna 180J · Necedah, WIThe pilot's failure to maintain compensation for the wind conditions. A factor was the gusting tailwind.NTSB CHI99LA146Accident · No injuriesLimited investigationFinal reportPiper PA-18-L21B · Vincennes, INthe pilot's failure to maintain directional control after landing. Factors which contributed to this accident were the pilot's long touchdown, the rough area on the runway, and the wheat field.NTSB LAX99LA171Accident · Minor injuriesLimited investigationFinal reportWidner RV-3A · Casa Grande, AZThe pilot's inadequate compensation for the existing crosswind condition and his subsequent failure to maintain directional control during the takeoff roll. The pilot's distraction in looking for the aircraft which announced an intention to land in the…NTSB LAX99LA170Accident · No injuriesLimited investigationFinal reportWsk Pzl Warzawa-Okecie PZL-104 Wilga 80 · Reno, NVThe flight instructor's improper supervision of the pilot trainee and his failure to make timely control inputs in order to maintain aircraft control.NTSB NYC99LA106Accident · No injuriesLimited investigationFinal reportCessna 305 · Grundy, VAThe pilot's failure to maintain directional control during the landing roll.NTSB LAX99LA168Accident · No injuriesLimited investigationFinal reportR.M. Bishop Aero Spec 2150 · Payson, AZThe pilot's inadequate use of the rudder controls to maintain directional control during the takeoff roll, which resulted in veering off the runway and ground looping in tall vegetation.NTSB ANC99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Talkeetna, AKThe pilot's inadequate compensation for the wind conditions, and an inadvertent ground loop. A factor in the accident was a quartering tailwind.NTSB SEA99LA065Accident · No injuriesLimited investigationFinal reportBoeing Stearman 1B75A · Olympia, WAThe pilot's failure to adequately compensate for wind conditions. A factor contributing to the accident was a crosswind during the landing roll out.NTSB SEA99LA064Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Chehalis, WADirectional control was not maintained after the right brake locked up for undetermined reasons. An uncontrolled ground loop was a factor.NTSB ANC99LA057Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Healy, AKThe pilot's selection of an unsafe/hazardous area for landing. Factors in the accident were the presence of a tail wind, the pilot's inadequate evaluation of the wind conditions, and a narrow airstrip.NTSB ATL99LA075Accident · No injuriesLimited investigationFinal reportBeech 36 · Williamston, NCThe pilot's inadequate evaluation of winds that resulted in the loss of directional control during an attempted takeoff with a tailwind. A factor was the tailwind condition.NTSB CHI99LA132Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lake Geneva, WIthe student pilot's failure to maintain directional control during the landing. Factors contributing to this accident were the variable winds and the ditch.NTSB CHI99LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Morris, ILthe directional control not maintained by the pilot. Contributing factors were the wind gusts, crosswind and runway light.NTSB LAX99LA163Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Fitiuta, Australiathe mechanical separation of the left engine beta control linkage during landing rollout, which resulted in asymmetrical decelerative action and the pilot's subsequent inability to maintain directional control. The separation of the linkage was due to the…NTSB ANC99LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot's failure to maintain directional control. A factor associated with the accident was an inadvertent ground loop.NTSB LAX99LA158Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Hollister, CAThe pilot's inadequate compensation for the crosswind condition, and his failure to maintain directional control during landing.NTSB LAX99LA152Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Casa Grande, AZThe pilot's decision to continue flight into a known adverse weather condition, and, his failure to adequately compensate for the crosswind gust condition and maintain directional control during the landing rollout.NTSB ANC99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB SEA99LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Boulder, MTThe pilot-in-command's failure to maintain directional control after encountering a dust-devil during landing rollout, resulting in a ground loop and collapse of the main landing gear. Factors include the dust-devil.NTSB IAD99LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Zelienople, PAThe pilot's inadequate preflight planning to practice crosswind landings in wind that exceeded the airplane's demonstrated capability and his failure to maintain directional control. A factor in the accident was the high wind.NTSB ATL99LA069Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Nashville, TNThe pilot's inflight decision to land on a runway with a strong cross wind, rather then on a runway into the wind. A factor was the strong cross wind conditions.NTSB FTW99LA106Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Kingston, OKThe failure of the pilot-in-command to maintain control of the airplane during the landing roll. A factor was the gusty wind conditions.NTSB ANC99LA041Accident · No injuriesLimited investigationFinal reportMaule M-5 · Talkeetna, AKThe pilot's inadequate compensation for the crosswind during landing. Factors associated with this accident were the left crosswind, and the snowbank on the edge of the runway.NTSB NYC99LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Leonardtown, MDThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB LAX99LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Novato, CAThe failure of the pilot to adequately compensate for the wind conditions and to maintain directional control of the aircraft while landing. A factor is the airport's failure to follow proper procedure in ensuring adequate obstacle and object free clearance…NTSB ATL99LA063Accident · No injuriesLimited investigationFinal reportCessna 185 · Hilton Head, SCThe pilot's inadequate evaluation of weather information that resulted in his failure to maintain directional control during landing. Factors were gusting winds, and a tail wind.NTSB FTW99LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ada, OKThe pilot's excessive application of the wheel brakes.NTSB CHI99LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ankeny, IAThe student pilot's failure to maintain directional control during landing.NTSB ATL99LA065Accident · No injuriesLimited investigationFinal reportCessna 206 · Fayetteville, NCThe pilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB LAX99LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Scottsdale, AZFailure of the student pilot to maintain directional control of the aircraft while retracting the flaps during a touch-and-go.NTSB CHI99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Marquette, MIthe pilot's inadequate compensation for the wind conditions which resulted in his failure to maintain directional control. Factors associated with the accident were the gusty crosswind conditions and the taxiway sign which the airplane contacted.NTSB ATL99LA060Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Dahlonega, GAThe pilot's failure to maintain directional control during takeoff.NTSB MIA99LA111Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Zephyrhills, FLThe student pilot's improper use of flight controls (cyclic and collective) during a takeoff to a hover. This resulted in the helicopter encountering dynamic rollover and rolling over on its right side.NTSB CHI99LA114Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAthe pilot's failure to maintain directional control.NTSB LAX99LA126Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Mesa, AZThe pilot's inadequate compensation for the gusty and variable crosswind condition, which led to a loss of directional control and an inadvertent ground loop.NTSB FTW99FA094Accident · 2 fatalField investigationFinal reportEurocopter AS-350-B2 · Eugene Is. 193the loss of control as a result of the spring-steel extension becoming entangled with the hatch door handle during takeoff. A contributing factor was the flat design of the spring-steel extension.NTSB LAX99LA118Accident · No injuriesLimited investigationFinal reportCessna 305A · Coalinga, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane.NTSB ATL99LA051Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Finley, TNThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the gusting winds.NTSB CHI99LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · South St. Paul, MNthe student pilot's failure to maintain directional control of the airplane during takeoff. Factors associated with the accident were the student's lack of experience and the snowbank.NTSB CHI99LA091Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe loss of directional control by the pilot. Factors to the accident were the lack of total experience of the pilot, the snow covered runway condition, the snowbank, and the flight instructor not verifying the runway snow removal with the Duty Instructor…NTSB CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.NTSB LAX99LA114Accident · No injuriesLimited investigationFinal reportCessna 180F · Inyokern, CAthe pilot's inadequate compensation for the variable and gusting winds during a wheel landing, which led to a loss of directional control.NTSB CHI99LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILthe pilot's inadequate directional control during landing roll. A factor was the snow bank.NTSB FTW99LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange, TXThe student pilot's failure to maintain directional control during landing touchdown. A factor was the muddy drainage ditch.NTSB FTW99LA087Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor was the crosswind.NTSB MIA99LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot's failure to maintain directional control during the landing roll. A related factor was the pilot's diverted attention.NTSB MIA99LA090Accident · No injuriesLimited investigationFinal reportCessna 172P · Pelion, SCThe pilot's loss of directional control during landing roll as a result of improper recovery from a bounced landing and the subsequent excursion from the runway, collision with the adjacent terrain, and collapse of the nose landing gear.NTSB SEA99LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Hillsboro, ORThe pilot's failure to maintain directional control of the aircraft. A related factor was the crosswind condition.