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 LAX99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Santa Barbara, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain proper runway alignment during landing flare.NTSB IAD99LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-C · Caldwell, NJThe pilot-in-command's failure to maintain directional control resulting in a ground-loop.NTSB CHI99LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Cahokia, ILthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the quartering tailwind and the ditch that the airplane contacted.NTSB FTW99LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Tomball, TXThe student pilot's failure to maintain directional control of the airplane.NTSB LAX99LA021Accident · No injuriesLimited investigationFinal reportCessna 185E · Tucson, AZFailure of the pilot to properly secure the seat which subsequently slid back on the takeoff roll and lead to the pilot's loss of aircraft control.NTSB CHI99LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-150 · Mason, MIwas the pilot not maintaining control of the airplane. A factor in this accident was the pilots lack of total experience in the airplane.NTSB CHI99LA014Accident · No injuriesLimited investigationFinal reportCessna 182 · Weeping Water, NEthe pilot failed to maintain directional control. A factor was the uneven runway condition.NTSB MIA99LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Cartersville, GAFailure of the student pilot to maintain directional control during landing resulting in the aircraft running off the left side of the runway and colliding with a parked aircraft. Factors in the accident were his distraction while raising wing flaps during…NTSB IAD99FA008Accident · Minor injuriesField investigationFinal reportLearjet 45 · Wallops Island, VAThe failure of the pilot to obtain/maintain alignment with the water pool, which resulted in the loss of control. Factors in the accident were the inadequate preflight planning of the flight test facility and the airplane manufacturer which resulted in…NTSB SEA99LA008Accident · No injuriesLimited investigationFinal reportCessna 172K · Dillon, MTThe student pilot-in-command's failure to maintain directional control. Contributing factors were rough terrain and crosswind conditions.NTSB CHI99LA015Accident · No injuriesLimited investigationFinal reportCessna 195 · Rugby, NDthe pilot failed to maintain directional control.NTSB MIA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chamblee, GAThe pilot's excessive use of right wheel brake to correct for a left drift during landing rollout resulting in a ground loop to the right and the left wing contacting the runway.NTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.NTSB SEA99LA009Accident · No injuriesLimited investigationFinal reportPitts S-1 · Mccall, IDThe pilot-in-command's failure to maintain directional control. Contributing factors were the uneven taxiway, inadequate airport maintenance (temporary threshold marking) by the airport management, and a ditch alongside the taxiway.NTSB SEA99LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB MIA99LA011Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilot's decision to attempt a flight with an unairworthy condition (leaky brake) and improper use of brakes on landing rollout. This resulted in a loss of brake fluid, directional control, ground loop, and on ground collision with terrain.NTSB LAX99LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Carson City, NVThe pilot's failure to verify the wind direction and speed, his selection of the wrong runway for the existing wind conditions, and, his inadequate compensation for those wind conditions.NTSB NYC99LA001Accident · No injuriesLimited investigationFinal reportCessna 150M · Wiley Ford, WVWas the failure of the pilot to maintain directional control during an unforecast change in wind velocity. Factors were the gusts and the lack of recent experience for the pilot.NTSB FTW98LA416Accident · No injuriesLimited investigationFinal reportCessna 551 · Pueblo, COThe pilot's delayed flare, improper recovery from a bounced landing, and failure to maintain directional control. A factor was the rough uneven terrain.NTSB SEA98LA187Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Medford, ORDirectional control was not maintained.NTSB SEA98LA195Accident · No injuriesLimited investigationFinal reportEvarts Kitfox IV 1200 · Sula, MTAn excessive brake application by the pilot. Factors included a narrow landing area, the pilot's failure to maintain directional control during a 180-degree taxi turn, and a tailwind.NTSB LAX98LA313Accident · No injuriesLimited investigationFinal reportGrumman HU-16C · Sedona, AZThe pilot in command's selection of the wrong runway for the prevailing wind conditions, and the second pilot's inadequate compensation for the winds. Factors in the accident were the second pilot's lack of experience in the aircraft and the…NTSB ATL98LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Farmville, NCThe pilot's failure to maintain directional control of the aircraft and his improper use of the brakes, which led to the aircraft departing the left side of the runway. Contributing factors were the wet runway and the vehicle.NTSB ANC98LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's failure to maintain directional control. Contributing factors were the gusty crosswind conditions.NTSB FTW98LA418Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Alpine, TXThe pilot's failure to maintain directional control of the airplane for undetermined reasons. A factor was the loose gravel composition of the runway.NTSB ANC98LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadvertent activation of the brakes during the landing roll resulting in a ground loop/swerve.NTSB NYC98LA191Accident · No injuriesLimited investigationFinal reportBoeing PT-17 Stearman · So. Charleston, WVThe pilot's failure to maintain control of the airplane during landing.NTSB CHI98LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · West Lafayette, INthe student pilot's failure to maintain directional control during the touch and go takeoff.NTSB IAD98LA109Accident · No injuriesLimited investigationFinal reportRussell Rebel · Cadiz, OHThe pilot's inadequate compensation for winds.NTSB ANC98LA157Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's inadequate compensation for the gusty wind conditions, and his attempted flight into adverse weather. Factors associated with the accident are high and gusty winds.NTSB FTW98LA407Accident · No injuriesLimited investigationFinal reportSnow S2C · Bovina, TXThe pilot's failure to maintain directional control during the landing roll.NTSB ATL98LA126Accident · No injuriesLimited investigationFinal reportAeronca 65-TAC (L-3) · Dalton, GAThe pilots failure to maintain directional control of the airplane during landing. A factor was the pilot's lack of experience in the same make and model airplane.NTSB NYC98LA187Accident · Minor injuriesLimited investigationFinal reportAnkenbruck Searey · Chippewa Lake, OHEncounter with swells from a boat wake. A factor in the accident was the pilot's inadequate initial training.NTSB IAD98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Oxford, CTThe pilot's inability to maintain directional control during the landing roll due to separation of the tailwheel spring assembly.NTSB FTW98LA398Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Watkins, COGusting winds which blew the aircraft inverted during taxi.NTSB LAX98LA290Accident · No injuriesLimited investigationFinal reportWeber-Mustang II Diamond · Taft, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain proper runway alignment during the takeoff roll.NTSB LAX98LA288Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Los Banos, CAThe pilot's decision to takeoff in adverse wind conditions and inadequate compensation for the existing crosswind conditions, which resulted in a failure to maintain runway alignment.NTSB LAX98LA287Accident · No injuriesLimited investigationFinal reportCessna 170B · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional controlNTSB LAX98LA286Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Lihue, HIThe failure of the pilot to maintain directional control of the aircraft during the landing.NTSB FTW98LA387Accident · No injuriesLimited investigationFinal reportCessna 172M · Englewood, COThe pilot's failure to maintain directional control during landing. Factors were the runway light and the terrain conditions.NTSB IAD98LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Schroon Lake, NYThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the gusty wind conditions and trees.NTSB CHI98LA333Accident · No injuriesLimited investigationFinal reportCessna 150E · Cadillac, MIthe pilot's inadequate evaluation of the wind condition which resulted in landing on the wrong runway. A factor associated with the accident was the tailwind.NTSB FTW98LA382Accident · No injuriesLimited investigationFinal reportCessna T210M · Mcallen, TXThe pilot's inadequate compensation for the crosswind resulting in a loss of control. A factor was the crosswind.NTSB NYC98LA178Accident · No injuriesLimited investigationFinal reportMaule MX-7-160 · Skaneateles, NYThe pilot's failure maintain directional control and his delayed decision to abort the takeoff. Contributing factors were trees.NTSB ANC98LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's selection of an unsuitable area for takeoff. A factor associated with the accident is the pilot's premature liftoff.NTSB ANC98LA134Accident · No injuriesLimited investigationFinal reportCessna 185E · Talkeetna, AKThe pilot's failure to maintain directional control resulting in a inadvertent ground loop. A contributing factor was the induced pressure on the pilot by a sick passenger.NTSB ANC98LA132Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot's inadvertent ground loop/swerve. A factor associated with the accident was the pilot's inadequate recovery from a bounced landing.NTSB LAX98LA285Accident · No injuriesLimited investigationFinal reportMohr EAA Biplane P · Gilroy, CAFailure of the pilot to adequately compensate for the existing crosswind.NTSB SEA98LA171Accident · No injuriesLimited investigationFinal reportDornbos BD-4 · Kent, WADirectional control was not maintained by the pilot in command.NTSB ANC98LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · North Pole, AKThe student pilot's inadvertent ground loop/swerve during the landing roll.