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 CHI99LA203Accident · No injuriesLimited investigationFinal reportCessna 172R · Kokomo, INthe student pilot's failure to maintain directional control during landing. Factors to the accident were the pilot's lack of experience and the VOR station.NTSB SEA99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Winthrop, WAThe pilot/passenger's failure to maintain directional control. A contributing factor was the fence.NTSB SEA99LA096Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Nampa, IDDirectional control was not maintained. Diverted attention was a factor.NTSB CHI99LA199Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Kalamazoo, MIThe pilot's failure to maintain directional control of the airplane during landing. A factor was the variable wind condition.NTSB CHI99LA198Accident · No injuriesLimited investigationFinal reportMahler BD-4 · Baldwin City, KSThe pilot not maintaining directional control with the runway centerline during takeoff. A factor was the high vegetation off the left side of the runway.NTSB NYC99LA159Accident · Minor injuriesLimited investigationFinal reportDuci Lancair 235 · Hamilton, OHThe pilot's failure to maintain control of the airplane. Factors included the pilot's inexperience in the airplane and his failure to compensate for the crosswind condition.NTSB CHI99LA195Accident · No injuriesLimited investigationFinal reportCessna 150G · Fort Scott, KSThe pilot's failure to maintain directional control during the landing roll. A factor to the accident was the soft terrain condition.NTSB ANC99LA080Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · North Pole, AKThe pilot's inadvertent ground loop during a high speed taxi. A factor associated with the accident is the pilot's decision to taxi the airplane at an excessive taxi speed.NTSB DEN99LA115Accident · No injuriesLimited investigationFinal reportCessna 170 · Durango, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A factor was the high density altitude and the high vegetation (sagebrush).NTSB ANC99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot misjudged his altitude and airspeed, and his failure to maintain directional control of the airplane. Factors in the accident were a wet grass runway, and the pilot's excessive application of the brakes.NTSB ANC99LA079Accident · No injuriesLimited investigationFinal reportCessna 180K · Kotzebue, AKThe pilot's failure to maintain directional control during takeoff.NTSB CHI99LA192Accident · Minor injuriesLimited investigationFinal reportRussell Sport Trainer · Ft. Calhoun, NEthe pilot used an improper engine starting procedure in that he failed to reduce the throttle setting and to assure the airplane was adequately secured prior to starting.NTSB FTW99LA163Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Mckinney, TXThe pilot's failure to maintain directional control on landing. Contributing factors were the elevator control restriction, the pilot's inadequate preflight, the ditch, and gusty conditions.NTSB FTW99LA164Accident · No injuriesLimited investigationFinal reportCessna 172N · Spring, TXThe pilot's failure to maintain aircraft control during the takeoff roll. Factors were the crosswind condition and the pilot's lack of total experience in the make/model of aircraft.NTSB MIA99LA167Accident · Minor injuriesLimited investigationFinal reportCessna 150M · St. Augustine, FLThe student pilot's inadequate compensation for the crosswind condition. A factor associated with the accident was the crosswind.NTSB DEN99LA098Accident · No injuriesLimited investigationFinal reportNorth American SNJ-4 · Belen, NMEncounter with soft unsuitable terrain when the aircraft departed the side of the runway during landing roll due to binding in the right main landing gear wheel assembly. A factor was the binding in the main landing gear.NTSB DEN99LA097Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Glenwood Sprngs, COThe pilot-in-command's failure to maintain directional control. A related factor was the gusty quartering tailwind.NTSB IAD99LA049Accident · No injuriesLimited investigationFinal reportKucki Pitts S-1S · Mitchellville, MDwas the loss of braking action on the left side due to a broken brake caliper.NTSB FTW99LA159Accident · No injuriesLimited investigationFinal reportLuscombe 8E · New Iberia, LAThe pilot's inadvertent ground loop.NTSB DCA99MA060Accident · 11 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-82 · Little Rock, ARThe flight crew's failure to discontinue the approach when severe thunderstorms and their associated hazards to flight operations had moved into the airport area and the crew's failure to ensure that the spoilers had extended after touchdown. Contributing to…NTSB FTW99LA158Accident · No injuriesLimited investigationFinal reportCessna 210K · Mountain View, ARThe pilot's failure to maintain control during the landing flare/touchdown. Factors were the pilot's delay in aborting the landing and the fence post.NTSB DEN99LA091Accident · Serious injuriesLimited investigationFinal reportCrozier Emeraude · Delta, COThe pilot's failure to maintain directional control. Factors were the gusty tailwind and crosswinds reported, and the pilot's total lack of aeronautical experience.NTSB ANC99LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot's inadequate compensation for a crosswind. A factor associated with the accident is a crosswind.NTSB NYC99LA135Accident · No injuriesLimited investigationFinal reportMaule M7-235C · Bennington, VTThe pilot's inadequate pre-flight briefing which resulted in control interference by the right front seat passenger.NTSB DEN99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMThe pilot's excessive use of rudder while attempting to correct for loss of directional control. Factors were the pilot's loss of directional control, and his lack of experience in the type of airplane.NTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.NTSB SEA99LA074Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAThe pilot-in-command's failure to maintain directional control during the takeoff roll and overloading of the right landing gear strut. Contributing factors were the soft takeoff surface, confined (narrow) takeoff surface, and high vegetation.NTSB FTW99LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKThe pilot's loss of control due to his improper recovery from a bounced landing.NTSB FTW99LA149Accident · Serious injuriesLimited investigationFinal reportWeatherly 620B · Whiteface, TXThe pilot's selection of unsuitable terrain for takeoff. Contributing to the accident was the soft ground and the standing water on the runway.NTSB CHI99LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mineral Point, WIthe inadequate planning and decision by the pilot and the exceeded crosswind capability of the airplane. Contributing factors were the crosswind and the gusts.NTSB CHI99LA159Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Poplar Bluff, MOthe pilot selecting the wrong runway direction on which to initiate the takeoff and his failure to maintain directional control. Factors associated with the accident were the quartering tailwind condition, the rough terrain encountered, and fatigue.NTSB NYC99LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Churchville, MDThe pilot's failure to maintain directional control during the takeoff roll. Factors were the pilot's lack of recent experience, and the crosswind.NTSB LAX99LA196Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Santa Ana, CAThe pilot's failure to maintain directional control and his excessive use of the rudder to regain runway alignment.NTSB LAX99LA194Accident · No injuriesLimited investigationFinal reportCessna A185F · Elko, NVThe failure of the pilot to adequately compensate for the variable and gusty winds, and, to maintain directional control of the aircraft while landing.NTSB LAX99LA193Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Merced, CAThe pilot's improper/inadequate use of the rudders during the attempted recovery from a bounced landing and his subsequent failure to maintain directional control of the aircraft.NTSB LAX99LA191Accident · No injuriesLimited investigationFinal reportMaule M-4-210C · Lancaster, CAThe pilot's failure to maintain directional control during the landing rollout. A factor in the accident was the pilot's limited experience in conventional gear airplanes.NTSB SEA99LA076Accident · No injuriesLimited investigationFinal reportCessna A185E · Othello, WAThe pilot's inadequate compensation for wind conditions after landing. Factors include gusty winds.NTSB SEA99LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ORAircraft control was not maintained. The pilot's misjudged flare and inadequate remedial action, along with the flight instructors delayed remedial action were factors.NTSB NYC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Leesburg, VAThe pilot-in-command's (CFI) failure to maintain control of the airplane.NTSB NYC99LA115Accident · Serious injuriesLimited investigationFinal reportHammond Twinstar Gyroplane · Bloomsburg, PAThe pilot's failure to maintain sufficient takeoff rpm. Factors included crosswind gusts, and the FAA's lack of category and class rating requirements for pilots flying non-type-certificated experimental aircraft.NTSB CHI99LA168Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSthe student pilot's improper recovery from a bounced landing.NTSB CHI99LA154Accident · No injuriesLimited investigationFinal reportCessna R182 · Chesterfield, MOthe pilot's failure to attain clearance over the fence. Factors associated with the accident were the pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control, the crosswind, and the fence posts.NTSB ATL99LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Double Springs, ALThe pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.NTSB ANC99LA062Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Dillingham, AKThe inadequate preflight by the pilot, who left the rudder gust lock installed, making directional control not possible.NTSB FTW99LA142Accident · Minor injuriesLimited investigationFinal reportExtra Flugzeugbau EA 300/L · Edna, TXThe inadvertent stall by the pilot during a go-around. A factor was the pilot's failure to maintain directional control during the landing roll.NTSB CHI99LA151Accident · No injuriesLimited investigationFinal reportEngleman Pitts S1 · Mattoon, ILThe pilot's failure to maintain directional control and inadvertent ground loop/swerve. A related factor was the crosswind.NTSB ATL99LA091Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Brooksville, FLThe certified flight instructor's failure to recover from a porpoise during landing and his failure to maintain directional control.NTSB ANC99TA061Accident · No injuriesFinal reportPiper PA-18 · Nome, AKThe pilot's failure to maintain directional control during landing. A factor in this accident was the crosswind.NTSB LAX99LA184Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Buckeye, AZFailure of the pilot to maintain directional control of the airplane during the landing rollout.NTSB ATL99LA084Accident · No injuriesLimited investigationFinal reportCessna 195A · Tupelo, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground loop/swerve and subsequent nose over.