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 LAX02LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Chandler, AZFailure of the student pilot to maintain directional control during landing.NTSB IAD02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, NYThe CFI's delayed remedial action, which resulted in a loss of control during landing rollout and impact with a parked airplane.NTSB LAX02LA021Accident · No injuriesLimited investigationFinal reportCessna 182S · Palm Springs, CAThe failure of the pilot-in-command to maintain directional control of the airplane after encountering a dust devil during landing roll.NTSB CHI02LA038Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hawley, MNthe failure of the pilot to maintain directional control. A factor was the trees.NTSB CHI02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Decatur, ILThe excessive braking performed by the flight instructor.NTSB LAX02LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Prescott, AZThe CFI's improper remedial action and failure to maintain directional control during landing in a strong crosswind condition.NTSB ATL02LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Wales, FLThe pilot's improper decision to land on a wet sod runway which resulted in a loss of directional control during landing. Factors were the wet grass strip which allowed the airplane to hydroplane.NTSB NYC02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Buckhannon, WVThe student pilot's failure to maintain directional control while landing. A factor related to the accident were the gusting wind conditions.NTSB NYC02LA015Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-105 · Morgantown, WVThe passengers failure to remain in the balloon basket after landing which resulted in the inadvertent lift-off of the balloon and subsequent injury to the pilot. A factor related to the accident was the pilot's failure to perform a passenger briefing prior…NTSB LAX02LA011Accident · No injuriesLimited investigationFinal reportCessna A185E · Winnemucca, NVThe pilot's inadequate compensation for the wind conditions, failure to maintain directional control and use of excessive braking, which resulted in the airplane nosing over.NTSB NYC02LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Farmville, VAThe CFI's failure to maintain directional control during the takeoff. A factor in the accident was the CFI's decision to conduct the flight from the airplane's right seat, which was not equipped with brakes.NTSB ATL02LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Goldsboro, NCThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB CHI02LA011Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ann Arbor, MIThe pilots failure to maintain directional control during the landing. Factors were the gusty crosswind and the terrain drop-off.NTSB FTW02LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Midlothian, TXthe pilot's failure to maintain control of the aircraft while taxiing from a landing. A contributing factor was the gusty wind conditions.NTSB LAX02LA005Accident · Minor injuriesLimited investigationFinal reportAero Commander 690 · Temecula, CAa misrigging of the engine controls that resulted in an asymmetric reverse thrust condition.NTSB SEA02LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Boardman, ORThe pilot-in-command's inability to maintain control of the aircraft while taxiing from landing resulting in a nose over. Contributing factors were high winds, crosswind conditions during taxi, and gusty wind conditions.NTSB CHI02LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Beaver Island, MIThe pilot not maintaining directional control of the airplane during landing. The gusty crosswind and the berm were factors.NTSB ANC02TA001Accident · No injuriesFinal reportCessna 185F · Bethel, AKThe pilot's inadequate compensation for wind conditions. Factors associated in the accident were a crosswind, and a worn tailwheel steering horn.NTSB MIA02LA002Accident · No injuriesLimited investigationFinal reportCessna 172R · Wauchula, FLthe pilot's failure to maintain directional control of the aircraft while attempting to take off after executing a touch-and-go landing, in gusty wind conditions, which resulted in a ground swerve, and the aircraft exiting the runway, and incurring…NTSB SEA01LA176Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Estacada, ORThe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. A tailwind, fence and the pilot's lack of total experience in the type of aircraft were factors.NTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…NTSB DEN01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Deming, NMthe pilot's failure to maintain aircraft control during takeoff roll. A contributing factor was the gusting crosswind weather condition.NTSB CHI01LA333Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Duluth, MNThe pilots failure to maintain directional control during the landing. Factors were the crosswind and the soft terrain.NTSB ANC01LA150Accident · No injuriesLimited investigationFinal reportSlepcev Storch SS-MK4 · Anchorage, AKThe pilot's failure to maintain directional control and an inadvertent ground loop/swerve during the landing roll.NTSB SEA01LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDThe pilot's inadequate compensation for wind conditions. A factor was variable winds.NTSB CHI01LA323Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Clear Lake, MNThe pilot not maintaining directional control of the airplane during the takeoff. A factor was the soybean crop.NTSB NYC01LA230Accident · No injuriesLimited investigationFinal reportCarver RAF 2000 GTX SE · Barre, VTThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident were wind gusts.NTSB DEN01LA160Accident · No injuriesLimited investigationFinal reportCessna 177RG · St. George, UTbrake system failure for reasons undetermined, which resulted in a loss of control on landing.NTSB CHI01LA304Accident · No injuriesLimited investigationFinal reportBeech C23 · St. Helen, MIThe pilot's failure to attain the proper airspeed which resulted in a premature lift-off and subsequent stall/mush. A factor to the accident was the fence.NTSB LAX01LA301Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Bridgeport, CAThe failure of the pilot to maintain directional control of the tail wheel equipped aircraft during landing roll which resulted in a ground loop.NTSB CHI01LA306Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Pierre, SDThe pilot not maintaining directional control of the airplane during landing.NTSB DEN01LA155Accident · No injuriesLimited investigationFinal reportVans RV-6A · Pagosa Springs, COThe pilot's inadequate airplane preflight inspection which led to the subsequent lateral control of the airplane on the ground not being possible. A contributing factor was the unavailability of rudder control due to a headset blocking the rudder control…NTSB ANC01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKA failure of the pilot to maintain directional control of the airplane during the takeoff run.NTSB IAD01LA088Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's operation of the airplane with known deficiencies. Also causal was the loss of brake pressure, which resulted in the failure of the right brake, and subsequent loss of control of the airplane.NTSB NYC01LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Danbury, CTAn inoperative airspeed indicator and the pilot's improper recovery from the bounced landing.NTSB LAX01LA293Accident · No injuriesLimited investigationFinal reportChampion 7FC · Reno, NVThe failure of the pilot to maintain directional control during the landing roll.NTSB CHI01FA292Accident · Minor injuriesField investigationFinal reportBoeing 737-3G7 · Kansas City, MOThe second in command failed to maintain proper runway alignment, directional control, and landed long. The pilot in command failed to execute a go-around and failed to provide adequate supervision. Additional factors included the thunderstorm, the dark…NTSB FTW01LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ardmore, OKthe student pilot's failure to maintain directional control during takeoff roll.NTSB CHI01LA282Accident · No injuriesLimited investigationFinal reportHoskins Quickie Q2 · Carbondale, ILThe failure of the tailwheel spring. A factor was the directional control not possible by the pilot.NTSB SEA01TA152Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Ukiah, ORAn inadequate recovery from a bounced landing and directional control was not maintained during landing. A high flare and a fence were factors.NTSB ANC01LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Anchorage, AKThe pilot's inadvertent ground loop during the landing roll.NTSB SEA01LA151Accident · No injuriesLimited investigationFinal reportPitts Special SC-1 · Jerome, IDThe pilot's failure to maintain directional control during landing. Factors included: an incorrectly manufactured or adjusted rudder travel setting, resulting in restricted movement of the left brake; the mechanic's failure to adjust the rudder travel to the…NTSB CHI01LA289Accident · No injuriesLimited investigationFinal reportCessna 177 · South Haven, MIThe pilot not maintaining aircraft control during the landing. Factors to the accident were the pilot not performing a go-around and the ditch.NTSB ANC01LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's failure to maintain directional control during the landing roll. A factor associated with the accident is rough and uneven terrain at the off-airport landing site.NTSB IAD01LA092Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S2 · Xenia, OHThe airplane's excessive airspeed during the approach, which resulted in the pilot's failure to maintain directional control during landing.NTSB CHI01LA277Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Marlette, MIGround crew personnel improperly connected the tow winch cable prior to takeoff which resulted in one side of the winch cable coming disconnected. Factors associated with the accident were the ditch and the tree branch which the airplane contacted.NTSB NYC01LA195Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Hanson, MAThe pilot's failure to maintain aircraft control during the takeoff.NTSB NYC01LA197Accident · Minor injuriesLimited investigationFinal reportPalmer/Wilgus Fokker F1 · Rhinebeck, NYThe pilot's failure to maintain directional control while landing, resulting in an inadvertent ground-loop. A factor related to the accident was the crosswind conditions.NTSB NYC01LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · West Milford, NJThe student pilot's failure to maintain directional control while landing. Factor’s in this accident were a wind gust and the rocks located off the left side of the runway.NTSB LAX01LA260Accident · No injuriesLimited investigationFinal reportCessna 140 · San Luis Obispo, CAThe pilot's failure to maintain directional control during landing that resulted in dragging the wing and nosing over.