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 DEN00LA014Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bullfrog, UTThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the pilot's lack of total experience in type of aircraft and the fence.NTSB LAX00LA029Accident · No injuriesLimited investigationFinal reportCessna 170A · El Mirage, CAThe pilot's failure to maintain directional control of his airplane, which resulted in an inadvertent ground loop.NTSB CHI00LA019Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Benton, KSthe pilot's failure to maintain aircraft control, and the physiological impairment of the pilot due to a brain anomaly. The pilots improper decision to operate the airplane with a known medical deficiency, and the ditch were contributing factors.NTSB LAX00LA028Accident · No injuriesLimited investigationFinal reportCessna 305A · Torrance, CAThe pilot's loss of directional control during landing rollout due to the failure of the tail wheel control system. A contributing factor was the quartering tailwind condition.NTSB DEN00LA012Accident · No injuriesLimited investigationFinal reportBeech B-60 · Angel Fire, NMThe pilot's failure to maintain aircraft control, and the pilot's inadequate decision to attempt the takeoff. Factors were the strong left rear cross wind, and the dirt embankment.NTSB NYC00LA016Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Somerville, NJThe pilot's inadequate compensation for wind.NTSB DEN00LA011Accident · No injuriesLimited investigationFinal reportCessna 172B · Englewood, COThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the gusty crosswind and the runway light.NTSB SEA00LA009Accident · No injuriesLimited investigationFinal reportCessna 182B · Atlanta, IDDirectional control not maintained by the pilot in command.NTSB LAX00LA026Accident · No injuriesLimited investigationFinal reportBeech D55 · Corona, CAThe pilot's failure to maintain directional control of the aircraft during takeoff.NTSB SEA00LA016Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Bremerton, WALoss of directional control by the student pilot during landing. Factors include inadequate remedial action by the flight instructor, and an airport sign that was struck by the airplane, collapsing the left main landing gear.NTSB NYC00LA017Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orange, MAThe pilot's failure to maintain directional control during a sudden wind shift.NTSB FTW00LA027Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Terrell, TXThe pilot's failure to maintain aircraft control during landing.NTSB ATL00LA001Accident · No injuriesLimited investigationFinal reportCessna 305C · Morganton, NCThe pilot's inadequate compensation for a tailwind which resulted in the loss of control.NTSB SEA00LA003Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Laurel, MTThe pilot's inadequate compensation for wind conditions. Factors include a dust devil/whirlwind at the location where the pilot was trying to land.NTSB DEN00LA008Accident · No injuriesLimited investigationFinal reportFairchild M62A (PT-19) · Gallup, NMFailure by the pilot in command to maintain control of the aircraft during landing roll. Factors were a lack of experience of either pilot in kind and type of aircraft.NTSB SEA00LA002Accident · No injuriesLimited investigationFinal reportBeech F33A · Idaho Falls, IDThe pilot's failure to adequately compensate for wind conditions. Factors include gusty, turbulent, variable crosswinds, and a fence in the vicinity of the runway.NTSB NYC00LA027Accident · No injuriesLimited investigationFinal reportKolb Firestar · London, KYThe student pilot's inability to maintain control of the airplane after inadvertently allowing it to become airborne. A factor in the accident was his lack of total aviation experience.NTSB LAX00LA022Accident · No injuriesLimited investigationFinal reportCessna 210 · Enterprise, NVThe failure of the pilot to maintain directional control of the aircraft during the landing roll, which resulted in a collision with a ditch.NTSB FTW00LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Village, ARThe pilot's failure to obtain/maintain directional control during landing.NTSB CHI00LA011Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Grand Ledge, MIthe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind and the tree which the airplane contacted.NTSB DEN00LA004Accident · No injuriesLimited investigationFinal reportCessna 180D · Denver, COThe excessive taxi speed used by the pilot exiting the runway via a high-speed taxiway resulting in a loss of control. A factor was the crosswind.NTSB LAX00LA007Accident · No injuriesLimited investigationFinal reportPitts S2B · Salinas, CAThe pilot's inadequate compensation for the effects of torque and P-factor during a go-around from a bounced landing, which led to a loss of control and the inadvertent dragging of a wing.NTSB LAX00LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Yuma, AZThe pilot's inadequate compensation for the existing crosswind conditions.NTSB CHI00LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Pleasant Hills, MOThe pilot's loss of directional control during an aborted takeoff.NTSB NYC00LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Hoffmeister, NYThe pilot failure to maintain directional control while step-taxiing. A factor in the accident was gusty winds.NTSB DEN00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Las Cruces, NMThe pilot's inadvertent ground loop/swerve during landing. A factor was his attention being diverted by a malfunctioning throttle control.NTSB FTW00LA013Accident · No injuriesLimited investigationFinal reportChampion 7FC · Powderly, TXThe pilot's inadequate preflight inspection of the airplane, during which he failed to detect the disconnected tailwheel steering assembly.NTSB NYC99LA238Accident · No injuriesLimited investigationFinal reportBeech F33A · Wildwood, NJThe pilot's improper recover from a bounced landing. A factor related to the accident was the pilot's diverted attention due to the loss of a spouse.NTSB LAX99LA312Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Acampo, CAThe pilot's failure to maintain runway alignment, which resulted in the aircraft encountering high vegetation, the loss of directional control, and collision with trees.NTSB IAD99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's loss of directional control after landing. A factor in the accident were ruts in the turf runway that were hidden from view.NTSB DEN99LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Rifle, COThe pilot's failure to maintain aircraft control during landing roll. Factors were the strong crosswind weather conditions, and the runway sign that the airplane impacted.NTSB CHI99LA345Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Troy, MOthe failure of the pilot to maintain directional control during landing. Factors in the accident were the proper alignment not attained by the pilot and the trees.NTSB SEA99LA162Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Burley, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a taxiway marking sign located adjacent to the runway.NTSB DEN99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Greeley, COThe pilot's inadvertent ground loop during landing roll. Factors were the malfunctioning self centering locking device on the tail wheel, the right rear quartering tail wind, and the 3 to 4 inch high berm along the edge of the runway.NTSB MIA99LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · St. Petersburg, FLthe pilots improper use of the hand brake during the landing roll out and his failure to maintain directional control, which resulted in the airplane exiting the runway and incurring substantial damage.NTSB FTW99LA270Accident · No injuriesLimited investigationFinal reportAeronca 7-AC · Fort Worth, TXThe failure of the pilot to maintain directional control of the airplane during the landing roll.NTSB MIA99LA256Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, GAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during.NTSB SEA99LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Auburn, WALoss of directional control due to deficient brakes and tailwheel. Factors include leaking brake cylinder, loose tailwheel casting, and obstructions (VASI lights) in the path of the airplane as it left the runway.NTSB ANC99LA137Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Chugiak, AKA partial failure of the brake system. A factor associated with the accident was a leaking brake system.NTSB FTW99LA248Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Ada, OKThe pilot's failure to maintain directional control of the airplane during the landing flare/touchdown. Factors were the pilot's excessive approach speed and the partial failure of the seat guides for the pilot's seat.NTSB SEA99LA154Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTThe pilot's failure to maintain directional control. A wet runway surface was a factor.NTSB MIA99LA247Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeland, FLThe student pilots improper use of brakes on landing rollout resulting in a loss of directional control and subsequent collision with a ditch. Contributing to the accident was the certified flight instructors improper supervision of the student pilot.NTSB SEA99LA169Accident · No injuriesLimited investigationFinal reportBeech J-35 · Union, ORDirectional control not maintained. A rough/uneven landing area was a factor.NTSB LAX99LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Boulder City, NVthe student pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB FTW99LA244Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Seminole, TXThe pilot seat disengaging from the seat track resulting from inadequate AD compliance during the last annual inspection. A factor was the soft terrain.NTSB CHI99LA335Accident · No injuriesLimited investigationFinal reportBenson Sorrell SNS-7 · Mt. Vernon, ILthe pilot's inadequate compensation for the wind condition which resulted in an inadvertent ground loop. A factor associated with the accident was the gusty crosswind.NTSB CHI99LA318Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Watervliet, MIthe pilot not maintaining aircraft control during takeoff, and the pilot not correcting for the porpoise.NTSB CHI99LA316Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Osceola, WIthe pilot's improper preflight decision to attempt a takeoff with one engine inoperative.NTSB FTW99LA242Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Grapevine, TXThe pilot's failure to maintain directional control of the aircraft during landing.NTSB FTW99LA240Accident · Serious injuriesLimited investigationFinal reportBell 206-L3 · Main Pass 225aThe pilot's failure to maintain directional control of the helicopter. A factor was the tailwind condition.