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 ATL92LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Goldsboro, NCThe failure of the pilot to maintain directional control of the aircraft during taxi.NTSB ANC92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kugururak River, AKThe failure to maintain directional control during takeoff. Factors include rough/uneven terrain.NTSB CHI92LA202Accident · No injuriesLimited investigationFinal reportCessna 172P · Waukegan, ILThe student pilot's failure to maintain airplane directional control. Related factors are the student's lack of total flight experience, and improper aircraft control.NTSB DEN92LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COFailure by the pilot to maintain directional control.NTSB CHI92LA200Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Grain Valley, MOThe pilot's excessive application of wheel brakes after touchdown.NTSB CHI92LA199Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOThe improper use of the aircraft brake system by the pilot in command.NTSB LAX92LA277Accident · No injuriesLimited investigationFinal reportO'Donnell Lancair 235 · Winnemucca, NVThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB BFO92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Moneta, VAFailure of the student pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's improper recovery from a bounced landing and proximity of the tree.NTSB LAX92LA269Accident · No injuriesLimited investigationFinal reportCessna 180 · Glendale, AZThe failure of the left main gear inner tube due to dry rot, and, the inadequate maintenance and preflight inspections conducted on the aircraft.NTSB LAX92LA268Accident · No injuriesLimited investigationFinal reportCessna 172 · Lake Havasu, AZThe failure of the pilot to adequately compensate for the existing wind conditions and to maintain directional control of the aircraft.NTSB FTW92LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Wichita Falls, TXThe pilot's failure to maintain directional control.NTSB NYC92LA135Accident · No injuriesLimited investigationFinal reportPiper J3 · Waynesville, OHThe pilot's failure to maintain control of the airplane on the ground due to his lack of experience in type of aircraft. This resulted in an unsuccessful aborted takeoff, the airplane veering off the runway and nosing over. A factor in this accident was the…NTSB NYC92LA131Accident · No injuriesLimited investigationFinal reportPitts S1S · Hornell, NYThe misjudged landing by the pilot and his subsequent improper recovery from a bounced landing, which resulted in a loss of airplane control.NTSB CHI92LA189Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Oxford, IAWas the pilot's failure to maintain directional control of the airplane during the landing. Factors related to the accident were the pilot's lack of experience in tail wheel airplanes and the gusty wind conditions.NTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.NTSB CHI92LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Wichita, KSA loss of directional control and remedial action not performed by the pilot. Factors related to this accident were a swerve encountered by the pilot and the pilot's lack of overall experience.NTSB LAX92LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · El Monte, CAThe student pilot's failure to maintain directional control and improper use of the brakes.NTSB CHI92DCA02Accident · No injuriesFinal reportCessna 188B · Risco, MOThe pilot in commands failure to maintain directional control of the airplane during the aborted takeoff. The pilot's inadequate evaluation of the wind was a factor.NTSB ANC92LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Elmendorf Afb, AKThe pilot's failure to maintain directional control. Factors contributing to the accident were his psychological condition.NTSB FTW92LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Walnut Ridge, ARThe inadvertent ground loop. A factor was the pilots total lack of experience in type airplane.NTSB NYC92LA112Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indian Head, MDThe pilot improperly compensated for the wind conditions and lost control of the airplane after touchdown which resulted in the airplane departing the runway. An additional cause of the accident was, the delayed remedial action on the part of the flight…NTSB NYC92LA111Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Lewisburg, WVThe failure of the instructor pilot to take proper remedial action during a takeoff resulting in a loss of airplane control and subsequent inadvertant stall. Factors related to the accident were the instructor's lack of total, recent and instructional flight…NTSB NYC92LA116Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Greenville, METhe pilots decision to initiate a step turn into the wind. Factors related to the accident were the crosswind and gusts.NTSB CHI92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Liberty, MOThe pilot-in-commands failure to maintain aircraft control. Related factors are the pilot's lack of total experience and improper recovery from a bounced landing.NTSB NYC92LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Woodbine, MDThe student pilot's failure to maintain directional control of the glider during takeoff, which resulted in a ground loop. Factors related to the accident were the student's lack of total flight experience, the instructor's lack of flight experience in this…NTSB NYC92LA105Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Buffalo, NYThe pilot's failure to maintain airspeed during a go around, which resulted in an inadvertent stall and in flight collision with terrain. Contributing to the accident was the pilot delayed the go around and lack of recent flight expereince.NTSB NYC92LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Dexter, MEA failure of the top torque link bolt on the nose landing gear which resulted in a landing with a flat strut and misaligned wheel.NTSB MIA92LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Opa Locka, FLThe pilot's inadequate compensation for wind condition and failure to maintain runway alignment during the landing roll. A contributing factor was a shifting crosswind.NTSB DEN92LA056Accident · No injuriesLimited investigationFinal reportNorth American Harvard MK-II · Watkins, COThe pilot inadvertently stalling the airplane. Factors included: the pilot's failure to maintain directional control on takeoff, and inadequate airspeed.NTSB ATL92LA119Accident · No injuriesLimited investigationFinal reportChampion 8KCAB · Wallace, NCThe failure of the pilot to maintain directional control during the crosswind landing. A factor was the crosswind condition.NTSB SEA92LA119Accident · No injuriesLimited investigationFinal reportMooney M20K · Stanley, IDThe failure of the pilot to maintain runway alignment and his loss of directional control during takeoff ground roll, resulting in a swerve off the 150 ft wide runway and impact with a fence. Factors relating to the accident were the lack of runway lights,…NTSB LAX92LA226Accident · No injuriesLimited investigationFinal reportCessna 152 · Delano, CAThe failure of the student pilot to adequately compensate for gusting cross wind conditions and his failure to maintain directional control during the landing roll.NTSB ANC92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Alexander Creek, AKThe pilot's failure to maintain directional control during landing flare/touchdown. A factor relating to the accident was the crosswind weather condition.NTSB CHI92DCD06Accident · Minor injuriesFinal reportRonnie Baker BEE 2 · Lake Mills, IAExcessive taxispeed and inadvertent liftoff at an airspeed below stalling speed by the pilot in command.NTSB SEA92LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Pleasant, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: weather (gusts) and terrain (berm).NTSB LAX92LA215Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Live Oak, CAThe pilot's failure to maintain directional control and improper use of the brakes.NTSB CHI92LA158Accident · No injuriesLimited investigationFinal reportAeronca O-58B · Oshkosh, WIThe inadequate inspection by other maintenance personnel, and an inadequate preflight inspection by the pilot in command. A factor contributing to the accident was the reversal of the aileron cables.NTSB BFO92LA073Accident · No injuriesLimited investigationFinal reportCessna 172P · Poughkeepsie, NYThe pilot failed to maintain directional control.NTSB ANC92LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mcgrath, AKThe pilot's failure to maintain directional control, and his inadequate remedial action.NTSB CHI92LA159Accident · No injuriesLimited investigationFinal reportBeech 77 · Moline, ILThe student pilot's failure to maintain directional control.NTSB CHI92LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osage City, KSThe pilot's failure to maintain directional control. Factors in the accident were the rough/uneven runway surface and the inadequate maintenance of the runway surface.NTSB BFO92LA068Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Carollton, OHThe pilot's inadequate starting procedure.NTSB FTW92LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe failure of the left brake which led to a loss of directional control. A factor was the rough terrain immediately adjacent to the runway.NTSB DEN92LA051Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COLoss of directional control during landing roll by the pilot under instruction. A factor was: inadequate supervision by the certified flight instructor.NTSB CHI92LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Greenbay, WIA fractured rod end bolt which resulted in an unsteerable nosewheel.NTSB CHI92LA144Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Berlin, WIThe pilot's inadequate compensation for the crosswind during the takeoff roll.NTSB ANC92LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Twin Hills, AKDirectional control was not maintained. A factor to the accident was: a bird.NTSB SEA92LA093Accident · No injuriesLimited investigationFinal reportAviat A-1 · Arco, IDThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. Factors contributing to the accident were: crosswinds and gusts.NTSB ANC92LA072Accident · No injuriesLimited investigationFinal reportCessna C-180J · Seldovia, AKThe improper in-flt planning/decision by the pilot to land on a short gravel airstrip in tailwind wx conditions and his failure to correct a gnd loop/swerve during landing roll. Factors relating to the accident were the gusty, tailwind weather conditions.NTSB SEA92LA094Accident · No injuriesLimited investigationFinal reportFairchild 24W-40 · Toledo, WAThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. A factor contributing to the accident was crosswinds.