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 SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.NTSB CHI92LA004Accident · No injuriesLimited investigationFinal reportBeech 95 · Elkhart, INThe inadequate amount of hydraulic fluid present in the normal brake system.NTSB ANC92LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Amber Bay, AKThe pilot's loss of directional control during the landing roll. Contributing to the accident was the unfavorable wind.NTSB DEN92LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Erie, COThe pilot's failure to maintain directional control land his inadequate compensation for wind conditions. Factors were: crosswind conditions and the pilot's total lack of experience.NTSB ATL92LA001Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Cartersville, GAThe failure of the pilot to maintain control of the aircraft during the landing roll and the improper remedial action taken by the pilot to regain control of the airplane.NTSB CHI92LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Taylor, MOThe pilot-in-command's failure to attain proper compensation for the crosswind. A factor contributing to the accident was the crosswind.NTSB NYC91LA253Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Manchester, NHThe pilot's failure to maintain control. A factor was the unforecasted strong cross winds.NTSB LAX91LA403Accident · No injuriesLimited investigationFinal reportCessna 180K · Mammoth Lakes, CAThe pilot-in-command failed to maintain directional control. Contributing to this accident was the pic's lack of experience in the airplane and the soft terrain.NTSB LAX91LA409Accident · No injuriesLimited investigationFinal reportCessna 206 · Jamul, CAThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident was the soft wet runway condition.NTSB CHI91LA296Accident · No injuriesLimited investigationFinal reportCessna 150H · New Hudson, MIFailure of the pilot to maintain directional control during landing roll in a crosswind.NTSB CHI91LA295Accident · No injuriesLimited investigationFinal reportCessna 152 · Marion, INFailure of the pilot to maintain directional control during the takeoff ground run from a touch-and-go landing.NTSB LAX91LA397Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Phoenix, AZThe pilot's improper remedial action. Contributing to this accident was the pilot's improper use of the brakes and rudder and his lack of experience in the accident airplane's make and model.NTSB SEA91LA241Accident · No injuriesLimited investigationFinal reportCessna 172N · St George, UTImproper planning/decision by the student pilot. The crosswind and the student's lack of experience were related factors.NTSB LAX91LA396Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's failure to maintain directional control of the airplane. Contributing factors related to the dark, night light condition and to the pilot's inexperience in the type of nighttime takeoff operation.NTSB ANC91LA149Accident · No injuriesLimited investigationFinal reportChampion 7AC · Skwentna, AKThe pilot's failure in not maintaining aircraft control on landing. Contributing to the accident was the rough, uneven terrain and a wet and slick landing area.NTSB CHI91DCA03Accident · No injuriesFinal reportSchweizer G164B · Gideon, MOA binding landing gear brake. A factor related to the accident was the pilot's subsequent inability to maintain directional control.NTSB CHI91LA289Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kansas City, MOThe pilot's misjudgement of the landing flare and not maintaining directional control during a landing touchdown and roll. A factor was the pilot's lack of total expereince.NTSB LAX91LA384Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Hayward, CAThe failure of the pilot to maintain directional control of the aircraft while correcting an unwanted deviation.NTSB CHI91LA285Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOA premature liftoff and improper remedial action by the pilot during a takeoff ground run.NTSB CHI91LA286Accident · No injuriesLimited investigationFinal reportCessna 170B · Frankfort, ILThe pilot in command's failure to maintain directional control. A contributing factor was a crosswind.NTSB ATL91LA165Accident · Serious injuriesLimited investigationFinal reportIcard, Claude M. Sonerai II LT · Morganton, NCThe pilot's failure to maintain directional control of the airplane on the runway, and the inadvertent rotation of the airplane, resulting in an unplanned flight.NTSB CHI91LA277Accident · No injuriesLimited investigationFinal reportClassic YMF5 · Hart, MIFailure of the pilot to maintain directional control of the airplane during a takeoff ground run.NTSB ANC91LA137Accident · No injuriesLimited investigationFinal reportCessna 185-F · Cordova, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB DEN91LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Smyer, TXDirectional control not maintained. Factors were: crosswind, soft ground, and high vegetation.NTSB SEA91LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Heber City, UTThe pilot's failure to maintain directional control during landing ground roll. A factor relating to the accident was the crosswind weather conditions.NTSB MIA91LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 7EA · Venice, FLThe pilot's loss of control of the airplane on takeoff ground roll due to his lack of experience and flight time in this type of airplane. A contributing factor is an on-ground encounter with a crosswind.NTSB LAX91LA370Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Wallace, CAThe pilot's failure to properly align his airplane with the runway and his failure to maintain directional control during takeoff. Contributing factors related to the presence of rough and downhill terrain adjacent to the runway.NTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.NTSB ANC91LA133Accident · No injuriesLimited investigationFinal reportBeech B-18H · White Mountain, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB FTW91LA156Accident · No injuriesLimited investigationFinal reportCessna 150J · Tomball, TXAn improper recovery from a bounced landing.NTSB FTW91LA152Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ward, ARThe pilot's failure to maintain directional control.NTSB CHI91LA268Accident · No injuriesLimited investigationFinal reportCessna 150 · St. Clair, MODirectional control was not maintained by the pilot.NTSB ANC91LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague Island, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor was the unsuitable terrain selected for landing by the pilot, which was loose gravel, rough and uneven.NTSB ANC91LA127Accident · No injuriesLimited investigationFinal reportCessna 180A · King Salmon, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB ANC91LA125Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Ugashik, AKWas the pilot-in-command's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB CHI91DCA02Accident · Minor injuriesFinal reportManville Avid Flyer · Mexico, MOFailure of the pilot to maintain directional control during a landing roll. A factor associated with the accident is the pilot's lack of familiarity with the accident airplane.NTSB NYC91LA208Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Butler, PAThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway and impacted with the terrain.NTSB NYC91LA206Accident · No injuriesLimited investigationFinal reportCessna 172L · Magnolia, OHThe pilot's improper starting procedure.NTSB LAX91LA354Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Monterey, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB CHI91DCD02Accident · 1 fatalFinal reportCanadian Car & Foundry Harvard Mark IV · Ida Grove, IAThe pilot's failure to maintain airspeed.NTSB ANC91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the pilot's weather evaluation misjudgment, the high wind, and rough water encountered during takeoff.NTSB CHI91LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mount Pleasant, MIDirectional control was not maintained by the pilot. Factors related to the accident were a wet, grass runway and buildings adjacent the runway.NTSB ANC91LA120Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Eureka, AKThe pilot-in-command's failure to mantain directional control of the airplane during the takeoff roll. Contributing to the accident was the crosswind.NTSB ANC91LA116Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Gulkana, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the unsuitable terrain selected by the pilot for landing which was rough, uneven and soft.NTSB NYC91LA204Accident · No injuriesLimited investigationFinal reportCessna 150J · Burgettstown, PAThe pilot-in-command's failure to maintain control of the airplane on the landing roll, resulting in an on ground collision with a tree. Factors related to the accident was the pilot's improper use of the brake system.NTSB CHI91LA255Accident · No injuriesLimited investigationFinal reportCessna 180 · Walker, MNDirectional control after landing was not maintained by the pilot. Factors related to the accident were a gusty crosswind and a downhill embankment (ditch).NTSB CHI91LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILInadequate compensation for wind conditions and directional control was not maintained by the pilot. Factors related to the accident were a gusty crosswind landing environment and a ditch.NTSB CHI91LA239Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Bridgewater, SDDirectional control was not maintained by the pilot. A factor related to the accident was a fence.NTSB CHI91LA238Accident · No injuriesLimited investigationFinal reportCessna 140 · Cadillac, MIImproper compensation for wind conditions resulting in aircraft control not being maintained. Factors related to the accident were a gusty crosswind condition and lack of total experience by the pilot.NTSB FTW91LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · Marietta, OKThe pilot's failure to maintain directional control. A factor was his attempt to takeoff without using all available runway.