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 LAX01LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Concord, CAThe pilot's inadequate compensation for wind conditions, resulting in a loss of directional control and the inadvertent ground loop.NTSB CHI01LA134Accident · No injuriesLimited investigationFinal reportAir Tractor G-164A · Casselton, NDThe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. A factor was the collapse of the right main landing gear.NTSB FTW01LA163Accident · No injuriesLimited investigationFinal reportBeech D35 · Houston, TXthe pilot's failure to maintain aircraft control during the takeoff roll.NTSB SEA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182P · Salmon, IDLoss of aircraft control while landing. Factors include soft/muddy terrain.NTSB NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.NTSB LAX01LA171Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Hollister, CAThe pilot's inadequate aircraft handling procedure and failure to maintain directional control while landing in a known crosswind.NTSB FTW01LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Decatur, TXthe flight instructor's failure to maintain directional control during the landing roll. A contributing factor was the left main wheel brake which was locked for an undetermined reason.NTSB DEN01LA097Accident · Minor injuriesLimited investigationFinal report1977 Colfer-Chan Steen Skybolt · Gallup, NMthe pilot's failure to maintain directional control during landing roll. Contributing factors were gusting crosswinds and the pilots's lack of experience in aircraft make and model.NTSB LAX01LA170Accident · No injuriesLimited investigationFinal reportAviat A-1B · Apex, NVThe pilot's failure to maintain directional control during landing rollout in a gusty and crosswind condition.NTSB LAX01LA169Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Angwin, CARight main landing gear brake lockup during landing rollout for undetermined reasons.NTSB LAX01LA183Accident · No injuriesLimited investigationFinal reportNorth American AT-6 D · Prescott, AZThe pilot's inadequate compensation for an existing crosswind condition.NTSB LAX01LA173Accident · No injuriesLimited investigationFinal reportAero Commander 112A · Riverside, CAFailure of the pilot to maintain directional control of the airplane during the landing roll. A factor was the worn nose wheel steering assembly.NTSB IAD01LA052Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Annapolis, MDpilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB FTW01FA107Accident · No injuriesField investigationFinal reportPiper PA46-500TP · Rockwall, TXthe loss of directional control during landing roll as a result of insufficient nose gear steering authority.NTSB IAD01LA047Accident · Serious injuriesLimited investigationFinal reportStinson 108 · White Post, VAthe pilot's failure to remove frost from the airplane prior to departure. A factor in the accident was the tall wet grass.NTSB NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.NTSB LAX01LA155Accident · No injuriesLimited investigationFinal reportCessna 180K · Glendale, AZThe pilot's loss of directional control during the landing roll resulting in a ground loop/swerve and collision with a runway marker sign.NTSB ANC01TA049Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot's inadequate compensation for wind conditions, and inadequate weather evaluation resulting in a loss of directional control during the landing roll. Factors in the accident were the presence of a quartering tailwind, and an inadvertent ground loop.NTSB NYC01LA105Accident · No injuriesLimited investigationFinal reportCessna 337F · Quinton, VAThe pilot's improper recovery from a bounced landing. Factors in the accident were the crosswind, and the pilot's lack of experience in make and model.NTSB LAX01LA150Accident · No injuriesLimited investigationFinal reportCessna 172P · Torrance, CAThe failure of the pilot-in-command to execute a proper landing flare, which resulted in an improper touchdown attitude and a subsequent loss of directional control. A factor in the accident was the difference between landing characteristics of the Katana and…NTSB MIA01LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Destin, FLfailure of the flight instructor to maintain directional control of the aircraft during the landing rollout while landing with a crosswind in gusty conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial…NTSB SEA01LA072Accident · Minor injuriesLimited investigationFinal reportMaule M-4-210C · Bonners Ferry, IDInadequate preflight inspection/preparation of the aircraft by the pilot and consequent foreign object fouling of the rudder control, rendering directional control impossible. A factor was the pilot's distraction/preoccupation with personal problems.NTSB MIA01LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Fayetteville, NCThe pilot's failure to maintain directional control of the airplane after encounter wind gusts during landing roll resulting in the airplane ground looping to the left and the right wing, right horizontal stabilizer, and right elevator contacting the runway…NTSB ANC01LA082Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Talkeetna, AKThe instructor pilot's lack of adequate supervision of the training flight, and subsequent loss of directional control during the landing roll out. Factors on the accident were the lack of brake pedals installed on the right pilot position of the airplane,…NTSB NYC01LA101Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kent, OHThe flight instructor's inadequate supervision during the landing. Factors were the improper use of the flight controls by the pilot/owner, the crosswind, and the muddy terrain.NTSB LAX01LA146Accident · No injuriesLimited investigationFinal reportArthur Lee Beer ALB Special · Santa Rosa, CAThe failure of the pilot to maintain directional control during landing roll.NTSB CHI01LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Grain Valley, MOThe normal brake system was inoperative due to undetermined reasons. A factor associated with the accident was the ditch that the airplane encountered.NTSB DEN01LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 1731A · Hobbs, NMthe pilot's failure to maintain directional control during flare/landing.NTSB MIA01LA118Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLthe flight instructor's inadequate supervision and the dual student's improper use of brakes which resulted in the loss of directional control and collision with a wind sock. Contributing to the accident was the flight instructor's failure to follow…NTSB MIA01LA116Accident · No injuriesLimited investigationFinal reportCessna 170B · Penrose, NCfailure of the pilot to maintain directional control of the aircraft during the landing rollout while landing in a crosswind which resulted in a ground swerve and substantial damage to the aircraft.NTSB LAX01LA142Accident · Minor injuriesLimited investigationFinal reportSchweizer 2-33A · Peoria, AZThe glider's encounter with a dust devil during takeoff that resulted in a loss of control.NTSB NYC01LA093Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falmouth, MAThe pilot's failure to maintain directional control while landing. Factors were the pilot's inadequate weather evaluation and a tailwind.NTSB LAX01LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · N. Las Vegas, NVThe pilot's inadequate compensation for the existing crosswind condition, and his failure to maintain runway alignment.NTSB FTW01LA105Accident · No injuriesLimited investigationFinal reportCessna 195B · Conroe, TXthe pilot's failure to compensate for the wind conditions during takeoff, which resulted in a ground loop.NTSB DEN01LA080Accident · No injuriesLimited investigationFinal reportFox Pegazair 100 · Angel Fire, NMthe pilot's failure to maintain directional control during takeoff. A contributing factors was the gusty crosswind condition.NTSB DEN01LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangely, COthe pilot's improper use of aileron and his failure to maintain directional control during landing. A contributing factor was the direct gusty crosswind.NTSB FTW01LA092Accident · No injuriesLimited investigationFinal reportBradley Midget Mustang · Orange, TXthe pilot's inadequate compensation for the crosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.NTSB LAX01LA130Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Holbrook, AZFailure of the rudder lower hinge attach point resulting in a loss of rudder control and steerable tailwheel control. A factor was the crosswind condition.NTSB DEN01LA079Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Las Vegas, NMthe pilot's failure to maintain directional control during landing roll. Factors were weather evaluation by the pilot and rough terrain off the side of the runway.NTSB DEN01LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Junction, COFailure by the pilot to maintain directional control during takeoff roll. A factor was a crosswind.NTSB IAD01LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJpilot's failure to maintain directional control during the landing roll-out. A factor was the crosswind.NTSB MIA01LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dyer, TNThe improper installation of the main landing gear tire (pinched tube) by company maintenance personnel resulting in a total loss of air pressure in-flight, loss of directional control on landing roll, and subsequent nose down.NTSB LAX01LA128Accident · No injuriesLimited investigationFinal reportCessna 305A · Winslow, AZThe student's inadvertent restriction of the rudder pedal's movement during landing rollout precipitated the loss of directional control and ground loop. A finding was that remedial action by the CFI was not possible due to the student’s control interference.NTSB FTW01LA089Accident · No injuriesLimited investigationFinal reportAviat A-1B Husky · Odessa, TXthe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB ANC01LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Soldotna, AKThe private pilot/student's inadequate compensation for crosswind conditions and subsequent loss of directional control of the airplane during a touch and go, and the instructor pilot's inadequate supervision of the flight. Factors in the accident were a…NTSB LAX01LA143Accident · No injuriesLimited investigationFinal reportBeech C35 · Fullerton, CAThe premature retraction of the landing gear and the failure of the CFI to properly supervise the flight.NTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.NTSB CHI01LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sidney, NEthe pilot's failure to maintain directional control during the landing. A factor relating to this accident was the berm.NTSB LAX01LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe pilot's failure to maintain directional control resulting in an encounter with terrain and a nose over.NTSB MIA01LA095Accident · No injuriesLimited investigationFinal reportCessna 172R · Cartersville, GAthe pilot's failure to maintain control of the airplane which resulted in the airplane veering off course and subsequent impact with trees.