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 SEA91LA070Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Everett, WAThe pilot did not maintain control of the airplane during the landing roll. Factors tot he accient were the pilot inadequately planned the approach, and uncontrolled ground-loop, and the pilot's lack of total experience in this type of aircraft.NTSB CHI91LA117Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankton, SDFailure of the pilot to maintain directional control of the aircraft during landing. The adverse wind condition and the pilot's lack of total experience were related factors.NTSB CHI91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Grand Marais, MNFailure of the pilot to maintain directional control. The crosswind and snow covered runway were related factors.NTSB MIA91LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Clewiston, FLMisjudged wind direction resulting in incorrect runway selection and failure by the PIC to initiate a go-around after landing with a tailwind. Contributing to the accident was the lack of the pilot's total experience.NTSB MIA91LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe loss of control on the ground by the student pilot due to a lack of total experience and apprehension on his first solo flight.NTSB LAX91LA144Accident · No injuriesLimited investigationFinal reportHelio H391B · Prescott, AZThe pilot's failure to maintain directional control and improper use of the flight controls. Contributing to this accident was the cross wind and soft terrain, and the pilot's lack of experience in the airplane.NTSB CHI91LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Wichita, KSDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. Factors related to the accident were a gusty crosswind and a drainage ditch.NTSB MIA91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · La Belle, FLFailure of the student pilot to maintain directional control during the landing roll. Contributing to the accident was the fact that the pilot diverted his attention when he pulled the parking brake handle to apply the brakes.NTSB FTW91LA052Accident · Minor injuriesLimited investigationFinal reportMonocoupe D145 · Lafayette, LAThe pilot's failure to maintain directional control of the airplane.NTSB DEN91LA052Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Spring, COThe pilot's failure to maintain directional control of the aircraft. The gusty/quartering crosswind was a related factor.NTSB CHI91LA110Accident · No injuriesLimited investigationFinal reportBoeing A75 · North Platte, NEDirectional control was not maintained by the pilot resulting in a swerve and ground loop. A factor related to the accident was lack of total experience in type of aircraft by the pilot.NTSB FTW91LA051Accident · No injuriesLimited investigationFinal reportBeech A36 · Lubbock, TXThe pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB CHI91LA118Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Flushing, MIThe pilot's failure to attain proper runway alignment and not maintaining directional control which resulted in a ground loop. Factors relating to this accident were the gusty crosswind conditions which existed at the time.NTSB NYC91LA089Accident · No injuriesLimited investigationFinal reportCessna 150J · Angola, NYThe failure of the pilot to insure the magneto switch was off prior to moving the propeller.NTSB ATL91LA065Accident · No injuriesLimited investigationFinal reportHelio H-295 · Dunlap, TNFailure of the pilot to maintain control of the aircraft, which resulted in a ground loop/swerve. The crosswind was a related factor.NTSB ANC91LA035Accident · No injuriesLimited investigationFinal reportCessna 180K · Amos Lakes, AKThe pilot's selection of terrain that was rough, snow-covered and icy for takeoff.NTSB SEA91LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Gig Harbor, WAThe pilot's failure to maintain directional control on the ground. Factors include wind gusts.NTSB LAX91LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZThat the pilot improperly used the flight controls and brakes. Contributing to this accident was an existing cross/tailwind.NTSB CHI91LA107Accident · No injuriesLimited investigationFinal reportBeech 55 · Forest Lake, MNAn aborted landing not performed by the pilot. Factors related to the accident were a runway that was wet and ice covered.NTSB BFO91LA029Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Chesapeake, VAThe pilot's failure to maintain directional control. Contributing was the pilot's lack of experience.NTSB ANC91LA032Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Finger Lake, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the rough and uneven terrain.NTSB CHI91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Genesee, MIPositive liftoff airspeed was not attained, an aborted takeoff was not performed which resulted in a stall/mush descent to the terrain. Factors related to the accident were a dark raining night, soft, wet grass runway and a downwind surface wind.NTSB FTW91LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Friendswood, TXThe duel student's failure to maintain directional control during the landing and his inadvertent activation of the brakes. A factor was the ditch.NTSB ANC91DAG01Accident · No injuriesFinal reportPiper PA-20 · Anchorage, AKThe student pilot's failure to maintain aircraft control.NTSB CHI91LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Springfield, MOThe pilot's poor evaluation of high wind conditions and the subsequent inability to compensate for the winds. Related to the accident was the gusty crosswind conditions.NTSB SEA91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Townsend, WAThe pilot's failure to maintain aircraft directional control during landing roll. Factors relating to the accident were the crosswind weather conditions and the soft terrain beside the runway.NTSB ANC91LA031Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Flat Top Mtn., AKThe pilot's failure to maintain directional control of the airplane on landing roll out in unsuitable terrain. Contributing to the accident was the rough and uneven terrain.NTSB CHI91LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILFailure of the student pilot to maintain directional control during takeoff. Her lack of flying expereince was a related factor.NTSB ATL91LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Union Springs, ALThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.NTSB SEA91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot did not maintain directional control of the airplane during the landing roll.NTSB ANC91LA029Accident · No injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot-in-command's failure to maintain directional control.NTSB NYC91LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Easton, PAThe pilot's improperly executed approach, resulting in a landing with excessive airspeed.NTSB CHI91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrence, KSFailure of the student pilot to maintain directional control of the aircraft, which resulted in a ground swerve.NTSB SEA91LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Helena, MTThe pilot-in-command's failure to maintain directional control on landing. Contributing to the accident was the pilot's improper flare on landing inadequate recovery from a bounced landing, and the pilot's lack of total and recent experience.NTSB ANC91LA025Accident · No injuriesLimited investigationFinal reportCessna 172-P · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the terrain (snowbank).NTSB LAX91LA087Accident · No injuriesLimited investigationFinal reportWaco UIC · Santa Paula, CAThe brittle fracture of the left brake master cylinder tread end causing loss of directional control.NTSB DEN91LA027Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Durango, COThe pilot's failure to maintain directional control of the airplane. Contributing factors were the pilot's lack of experience in airplane type and crosswind conditions.NTSB DEN91LA038Accident · No injuriesLimited investigationFinal reportCessna 170A · Holly, COThe pilot's failure to maintain directional control. Factors were: a gusty crosswind condition and the pilot's lack of familiarity with the aircraft.NTSB LAX91LA083Accident · No injuriesLimited investigationFinal reportCessna 172P · Sedona, AZThe failure of the pilot to maintain directional control of the aircraft.NTSB CHI91LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · Rochester, MNInadequate compensation or wind conditions, and failure to maintain directional control by the pilot. Factors related to the accident are lack of total experience, and the crosswind conditions.NTSB CHI91LA082Accident · No injuriesLimited investigationFinal reportCessna 170B · Rochester, INThe pilot-in-command's inadequate compensation for wind conditions. A factor contributing to the accident was the crosswind.NTSB NYC91LA063Accident · No injuriesLimited investigationFinal reportCessna 152U · Stroudsburg, PAThe failure of the student pilot to maintain directional control of the airplane during landing, resulting in a collision with a snowbank. Factors related to the accident were: the pilot's lack of total flight experience and the unfavorable wind during…NTSB CHI91LA081Accident · No injuriesLimited investigationFinal reportCessna 172N · Lansing, ILInadequate compensation for wind conditions and failure to maintain directional control. A factor related to the accident is the snow covered runway.NTSB CHI91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIThe pilot's failure to maintain directional control.NTSB CHI91LA079Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MODirectional control was not maintained by the pilot. Factors related to the accident were: a lack of total experience by the pilot and the presence of a snowbank adjacent to the runway.NTSB LAX91LA077Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bakersfield, CAThat the pilot failed to properly compensate for the wind conditions. Contributing to this accident was the existing crosswind.NTSB CHI91LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Rolla, NDCompensation for wind was inadequate anad directional control not maintain by the PIC. Contributing factors were: snow covered runway, gusty crosswind, and a snowbank.NTSB SEA91LA042Accident · No injuriesLimited investigationFinal reportBeech 58P · Chelan, WAThe pilot's failure to maintain directional control during landing roll. A factor was the patchy ice on the runway.NTSB LAX91LA073Accident · No injuriesLimited investigationFinal reportBeech D-35 · Bullhead City, AZLoss of directional control on the ground.NTSB CHI91LA066Accident · No injuriesLimited investigationFinal reportCessna 140 · So. Sioux City, NEDirectional control not maintained by the pilot-in-command. Factors related to the accident were a snow covered runway and a lack of recent experience.