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 ANC97TA096Accident · No injuriesFinal reportPiper PA-18 · Nenana, AKfailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground loop and a collapsed main landing gear. His lack of experience in tailwheel airplanes was a related factor.NTSB LAX97LA229Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Page, AZThe pilot's inadequate compensation for crosswind gusts and his failure to maintain directional control.NTSB LAX97LA256Accident · No injuriesLimited investigationFinal reportCessna 150F · Casa Grande, AZFailure of the student pilot to maintain directional control.NTSB CHI97LA191Accident · No injuriesLimited investigationFinal reportCessna 402B · Springfield, MOThe pilot-in-command's (CFI) inadequate supervision and failure to take remedial action. A factor was the dual student's failure to maintain directional control.NTSB SEA97LA153Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Halls Crossing, UTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting crosswinds.NTSB FTW97LA241Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clovis, NMThe pilot's failure to maintain aircraft control. A factor was an unexpected gust of wind during landing touch down.NTSB LAX97LA223Accident · No injuriesLimited investigationFinal reportCessna 140 · Columbia, CAthe student pilot's failure to maintain directional control of the aircraft during a bounced landing recovery.NTSB CHI97LA184Accident · Minor injuriesLimited investigationFinal reportWeatherly 201C · Buffalo, NDthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control of the airplane. Water on the runway and the soft terrain were related factors.NTSB ANC97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hoonah, AKThe pilot's failure to maintain directional control while landing.NTSB MIA97LA191Accident · No injuriesLimited investigationFinal reportSherman Powell Kitfox IV · Concord, NCFailure of the pilot-in-command to maintain directional control and his poor preflight planning preparation for allowing the pilot rated passenger to manipulate the throttle control. Contributing to the accident was the pilots total lack of experience in make…NTSB DCA97MA053Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Honolulu, HIThe pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…NTSB CHI97LA177Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot not maintaining aircraft control shortly after it had touched down during its liftoff. A factor in this accident was the premature liftoff during takeoff by the pilot.NTSB MIA97LA187Accident · No injuriesLimited investigationFinal reportSpencer Pitts S-1S · Greenwood, MSloss of directional control during the landing rollout for undetermined reason(s), resulting in the airplane veering to the right and subsequently nosing over.NTSB LAX97LA216Accident · No injuriesLimited investigationFinal reportCessna 120 · Hollister, CAthe pilot's excessive use of right rudder during the initial stages of the takeoff ground roll, which resulted in his failure to maintain directional control. The unfavorable wind was a related factor.NTSB CHI97LA169Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Minneapolis, MNthe student pilot's improper recovery from a bounced landing and failure to maintain proper runway alignment during a go-around (aborted landing). Factors relating to the accident were: the pilot's improper flare for landing, the reduced light conditions at…NTSB NYC97LA120Accident · No injuriesLimited investigationFinal reportBoccher P51 Mustang · North Rose, NYwas the failure of the pilot to maintain directional control during takeoff which resulted in the airplane striking trees.NTSB SEA97LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wendover, UTThe pilot's failure to maintain directional control. Factors include the pilot's improper decision to continue his flight into an area where he had observed thunderstorms, and a thunderstorm outflow which created strong wind gusts that the aircraft…NTSB CHI97LA170Accident · No injuriesLimited investigationFinal reportWaco YMF · Longville, MNfailure of the pilot to maintain directional control of the airplane. Factors relating to the accident were: the gusty wind condition and the ditch.NTSB LAX97LA208Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Salome, AZthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the aircraft. The gusty crosswind condition was a related factor.NTSB IAD97LA091Accident · No injuriesLimited investigationFinal reportAeronca S15AC · Laconia, NHThe pilot's inadequate compensation for a crosswind, which resulted in the loss of aircraft control. A factor in the accident was the gusting winds.NTSB SEA97LA135Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau 1.131 Jungmann · Cottage Grove, ORfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve and gear collapse. The wet runway surface was a related factor.NTSB LAX97LA203Accident · No injuriesLimited investigationFinal reportCessna 180 · Hollister, CAThe pilot's improper use of the elevator and his subsequent failure to maintain directional control during a touch-and-go landing. A factor in the accident was the pilot's application of full power following the loss of directional control, which increased…NTSB NYC97LA110Accident · No injuriesLimited investigationFinal reportWaco YMF · Ocean City, MDThe pilot's failure to maintain directional control and his improper compensation for the wind conditions. Contributing factors were the lack of recent experience in the airplane, and gusty wind conditions.NTSB LAX97LA201Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Lemoore, CAfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a ground swerve and subsequent overload failure of the main landing gear. Related factors were a left crosswind and partial loss of the right wheel…NTSB SEA97LA127Accident · No injuriesLimited investigationFinal reportCessna 182 · Brigham City, UTfailure of the pilot to maintain proper runway alignment during the landing. The gusty quartering crosswind was a related factor.NTSB CHI97LA158Accident · No injuriesLimited investigationFinal reportKohles Kitfox III · Meadow Grove, NEfailure of the pilot to maintain directional control of the airplane during an aborted takeoff. A factor was the pilot's lack of recent experience in the make and model of airplane.NTSB ANC97LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Healy, AKthe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane and runway alignment. Factors relating to the accident were: the crosswind, and the proximity of a creek (ravine) to the runway.NTSB NYC97LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Elkton, MDThe pilot's failure to maintain directional control, which resulted in the airplane veering right, and striking trees.NTSB CHI97LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe student pilot's failure to maintain directional control of the airplane by overcompensating with the rudder. Factors associated with the accident were the excessive airspeed and the soft terrain.NTSB SEA97LA122Accident · No injuriesLimited investigationFinal reportNoe SA-300 · Bountiful, UTthe pilot's failure to maintain directional control of the airplane. Related factors include: an area of standing water on a portion of the runway, and soft terrain just off the edge of the runway.NTSB LAX97LA196Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tinian, Sarkthe pilot's improper takeoff abort. Contributing to the accident was the pilot's improper preflight planning and preparation.NTSB FTW97LA204Accident · No injuriesLimited investigationFinal reportCessna 180 · Olney, TXthe pilot's inadequate compensation for the crosswind, which resulted in a loss of dirctional control, a ground loop, and a collapsed main gear. The crosswind was a related factor.NTSB FTW97LA205Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Englewood, COfailure of the pilot to maintain directional control of the airplane during the landing roll. The gusty crosswind condition was a related factor.NTSB CHI97LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Angola, INthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the tailwind, the pilot's selection of runway, and the misjudged landing flare.NTSB ANC97LA072Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKfailure of the pilot to maintain directional control of the airplane during a touch-and-go landing. Factors associated with the accident were: the rough/uneven runway, and a berm.NTSB LAX97LA188Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Henderson, NVthe pilot's attempt to land the aircraft under crosswind conditions that exceeded the performance capability of the aircraft.NTSB MIA97LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Ball Ground, GAfailure of the pilot to maintain directional control during the takeoff roll and his failure to abort the takeoff before colliding with an embankment.NTSB CHI97LA141Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, WIthe pilot's inadequate compensation for wind conditions which resulted in a loss of directional control of the airplane. Factors associated with the accident were the gusty, crosswind conditions and the VASI lights.NTSB MIA97LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · Vero Beach, FLfailure of the pilot to ensure all articles in the aircraft were secured before flight, and subsequently, an oil can becoming lodged under the rudder pedals and preventing her from controlling the aircraft during landing.NTSB CHI97LA131Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Sheboygan, WIthe pilot's failure to maintain control of the airplane during the landing roll. A factor associated with the accident was the sudden change in wind conditions.NTSB FTW97LA186Accident · No injuriesLimited investigationFinal reportSnow S2C · Hondo, TXThe pilot's failure to maintain directional control while landing.NTSB CHI97LA132Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Correctionville, IAthe pilot's inadequate compensation for wind conditions, while taxiing, which resulted in loss of aircraft control, an encounter with terrain, and subsequent failure of the left main landing gear. The unfavorable wind condition was a related factor.NTSB CHI97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dickinson, NDthe student pilots failure to maintain directional control of the airplane. A factor associated with the accident was the pilot's runway selection.NTSB FTW97LA182Accident · Minor injuriesLimited investigationFinal reportMooney M20K · N Little Rock, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's failure to use the proper aborted landing procedures.NTSB FTW97LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe pilot's loss of control due to delayed landing flare. A factor was the porpoise encountered during landing.NTSB SEA97LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTThe pilot's failure to adequately compensate for wind conditions during the landing roll. Factors contributing to the accident were gusts and crosswinds.NTSB CHI97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rogers City, MIthe disconnection of the tailwheel spring which resulted in the pilot's inability to maintain directional control of the airplane.NTSB SEA97LA100Accident · No injuriesLimited investigationFinal reportCessna TR182RG · Ennis, MTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting winds, and the presence of a ditch on the edge of the landing area.NTSB CHI97LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochelle, ILthe student pilot's delay in aborting the takeoff and the use of excessive braking after deciding to abort the takeoff. A factor was the pilot's failure to maintain runway alignment during the landing.NTSB MIA97LA153Accident · No injuriesLimited investigationFinal reportCessna 182P · Mobile, ALthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during landing rollout, which resulted in a collision with a runway light.