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 LAX98LA215Accident · No injuriesLimited investigationFinal reportZimmerman Kitfox 4-1200 · Fountain Hills, AZThe failure of the pilot to maintain directional control during the landing roll in a crosswind.NTSB CHI98LA229Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Portland, NDthe pilot's not maintaining directional control. Factors were landing on a roadway and tall grass.NTSB FTW98FA283Accident · 1 fatalField investigationFinal reportMontgomery Quickie TRI-Q/200 · Fort Worth, TXThe pilot's failure to maintain aircraft control when an excessive taxispeed resulted in an inadvertent lift-off of the airplane. A factor was the pilot's lack of total experience in the make and model of aircraft.NTSB CHI98LA221Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILthe pilot's inadequate compensation for the wind conditions which resulted in a lack of directional control of the aircraft. Factors to the accident were the two airport signs and the crosswind.NTSB ATL98LA085Accident · No injuriesLimited investigationFinal reportStroud SKY Bolt · Mocksville, NCThe pilot's loss of directional control during landing roll when the front seat occupant inadvertently got his foot 'jammed' between the strut bungee and the rudder/brake peddle. A factor was the inadequate design of the rudder/brake peddle system.NTSB ANC98LA084Accident · Minor injuriesLimited investigationFinal reportBeech A-35 · Skagway, AKThe pilot's inadequate in-flight planning/decision to ensure the rudder pedals were locked in an operable position.NTSB ANC98TA083Accident · No injuriesFinal reportPiper PA-18 · Cold Bay, AKThe pilot's inadequate compensation for crosswind conditions. The presence of a crosswind was a factor in the accident.NTSB CHI98LA215Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grays Lake, ILthe pilot's not performing a recovery from a bounced landing and his not maintaining directional control. A factor was soft terrain.NTSB LAX98LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Markleeville, CAThe failure of the pilot to maintain control of the aircraft on the landing roll. A factor is the pilot's neglect to lower the flaps and reduce his speed prior to landing.NTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.NTSB ANC98LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Anchorage, AKThe pilot's failure to correct engine/propeller torque and P factor, and the subsequent loss of directional control during the takeoff roll. Factors associated with the accident are the narrow, confined, takeoff area, and bordering high vegetation.NTSB LAX98LA203Accident · No injuriesLimited investigationFinal reportCessna 177B · Fallon, NVThe pilot's improper use of rudder controls on a short field takeoff and his failure to maintain runway alignment.NTSB CHI98LA203Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Jefferson, IAthe pilot's lack of total experience in this type of aircraft and his failure to maintain directional control during an aborted takeoff. A factor was the ditch.NTSB LAX98LA226Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Manuel, AZThe failure of the certified flight instructor to maintain directional control while landing with a sudden windshift.NTSB FTW98LA271Accident · No injuriesLimited investigationFinal reportCessna 150C · Collinsville, OKThe pilot's failure to maintain directional control during landing roll. A factor was the pilot's diverted attention.NTSB FTW98LA265Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Midland, TXThe inadvertent ground loop during the landing roll. A factor was the sudden windshift.NTSB FTW98LA267Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Edna, TXThe pilot's inadequate compensation for the existing wind conditions. Factors were the crosswind, the dust devils, and the confined landing area.NTSB ANC98LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Naknek, AKThe pilot's inadequate compensation for wind conditions. A factor associated with this accident was a crosswind.NTSB SEA98LA087Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hailey, IDThe disconnection of the rear right-main brake pedal from the brake master cylinder, and the overloading of the right main landing gear. A factor was the oscillation of the tailwheel.NTSB ANC98LA050Accident · No injuriesLimited investigationFinal reportCessna 170B · Russian Mission, AKThe pilot's inadequate compensation for wind conditions while landing. A factor associated with the accident was the presence of a tailwind condition.NTSB MIA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180D · Natchez, MSThe pilot's improper use of brakes on landing rollout. The tailwind was a factor.NTSB FTW98LA251Accident · No injuriesLimited investigationFinal reportCessna 170B · Los Alamos, NMThe pilot's inadequate compensation for the wind conditions. Contributing factors were the crosswinds, the fence, and the ditch.NTSB LAX98LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Victorville, CAThe installation of incorrect washers for the brake manifold by maintenance personnel, which resulted in the left brake locking up, which made it impossible for the pilot to maintain directional control of the aircraft.NTSB LAX98LA177Accident · No injuriesLimited investigationFinal reportRans S6EX Coyote II · Delano, CAThe pilot's inadequate compensation for wind conditions, failure to maintain directional control, and his failure to maintain aircraft controlNTSB IAD98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Wadsworth, OHThe flight instructor's failure to maintain control of the airplane which resulted in his intentional ground loop. A factor in the accident was the flight instructor's lack of currency in tailwheel airplanes.NTSB LAX98LA173Accident · No injuriesLimited investigationFinal reportJohn H. Korb Jr. Kitfox III · Carson City, NVThe failure of the right landing gear shock cord because of ultraviolet deterioration in an area of abraded outer fabric, that resulted in a loss of directional control on landing and subsequent ground collision. Factors were the owner/builder's failure to…NTSB FTW98LA237Accident · No injuriesLimited investigationFinal reportCessna 170A · Provo, UTfailure of the pilot to maintain directional control of the airplane. A related factor was the right quartering tailwind gust.NTSB LAX98LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sedona, AZThe pilot's failure to maintain directional control during the landing rollout. A factor was the gusty wind.NTSB ANC98LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cold Bay, AKThe pilot's inadequate compensation for wind conditions. A factor associated with this accident was the presence of a crosswind.NTSB CHI98LA230Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Red Lake Falls, MNa locked brake for undetermined reasons.NTSB FTW98LA233Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Sheridan, ARThe inadvertent engine start due to the pilot's failure to ensure that the magneto switch was in the OFF position when he was attempting to clear the flooded engine. A factor was the pilot's improper starting procedure, which resulted in flooding the engine.NTSB SEA98LA075Accident · No injuriesLimited investigationFinal reportCessna 170 · Auburn, WAThe pilot's inadequate compensation for gusty crosswind conditions. A related factor was gusty crosswinds.NTSB FTW98LA228Accident · Minor injuriesLimited investigationFinal reportAeronca 65-C · Ozark, ARThe pilot's failure to maintain aircraft control.NTSB FTW98LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albuquerque, NMThe flight instructor's failure to maintain directional control of the aircraft. Factors were crosswind, high wind conditions, insufficient demonstrated crosswind component information provided by the manufacturer, and insufficient aircraft…NTSB ANC98LA049Accident · No injuriesLimited investigationFinal reportCessna U206G · Iliamna, AKThe pilot's inadequate compensation for quartering tailwind conditions. A factor in the accident is the presence of a quartering tailwind.NTSB FTW98LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Searcy, ARThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the certified flight instructor's inadequate supervision.NTSB FTW98LA230Accident · No injuriesLimited investigationFinal reportCessna 180 · Abilene, TXThe pilot's improper compensation for the crosswind conditions resulting in a ground loop. A factor was the crosswind condition.NTSB ANC98LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions. A factor was the gusting crosswind.NTSB ANC98LA044Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Talkeetna, AKthe pilot's inadequate aircraft preflight. A factor was the inadvertent activation of the parking brake.NTSB ATL98LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Key West, FLfailure of the student pilot to maintain directional control of the airplane during the landing roll. The student pilot's lack of experience in the make and model of airplane was a related factor.NTSB FTW98LA209Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Usaf Academy, COThe pilot exceeding the airplane's crosswind component, and his failure to maintain directional control. Factors were the crosswind and gusts.NTSB FTW98LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COthe student pilot's improper use of the rudder controls, which resulted in loss of directional control, a ground swerve, an encounter with soft terrain, and a nose over. The soft terrain was a related factor.NTSB NYC98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAfailure of the pilot to maintain directional control of the airplane during the takeoff roll; and/or his failure to abort the takeoff, while there was sufficient space available to do so without hitting trees.NTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.NTSB SEA98LA067Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Arlington, WAThe pilot's failure to maintain directional control during the landing roll, and his delayed remedial action when the aircraft started to drift off the side of the runway.NTSB MIA98LA146Accident · No injuriesLimited investigationFinal reportCessna 172RG · Greenville, SCThe pilot's use of full flaps while landing in a strong crosswind resulting in loss of directional control during the landing roll.NTSB LAX98LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Henderson, NVThe pilot's decision to attempt a landing in crosswind conditions at or above the demonstrated capability of the aircraft, and his subsequent failure to maintain proper runway alignment.NTSB LAX98LA142Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulare, CAThe malfunction of the nose wheel steering for undetermined reasons.NTSB IAD98LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Downsville, NYThe pilot's failure to maintain directional control of the airplane.NTSB MIA98LA147Accident · No injuriesLimited investigationFinal reportWaco 10 GXE · Americus, GAThe pilot's failure to maintain directional control and his improper compensation for wind. Contributing was a crosswind.