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 CHI05CA022Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Morris, ILThe pilot's inadequate preflight planning in that he failed to assure that the airplane was properly secured prior to hand propping the engine. Factors associated with the accident were the broken tie down rope and the other airplanes which were contacted.NTSB DEN05CA021Accident · No injuriesData collectionFinal reportTemco GC-1B · Angel Fire, NMthe pilot's failure to maintain directional control and his inadequate compensation for wind. Contributing to the accident was the crosswind.NTSB IAD05LA009Accident · No injuriesLimited investigationFinal reportCessna 120 · Willimantic, CTthe pilot's loss of directional control due to his uneven application of brakes. A factor in the accident was the tailwind.NTSB CHI05CA027Accident · No injuriesData collectionFinal reportCessna T182T · Morris, ILThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control. Factors associated with the accident were the gusty crosswind condition and the runway sign which the airplane contacted.NTSB MIA05CA038Accident · No injuriesData collectionFinal reportSteven W. Jones KR2 · Zellwood, FLThe failure of the pilot to maintain directional control during landing resulting in the on-ground collision with a drainage ditch.NTSB LAX05CA019Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Vacaville, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB ANC05CA011Accident · No injuriesData collectionFinal reportChampion 7FC · Talkeetna, AKThe instructor pilot's inadequate supervision of the student, which resulted in a loss of control during the landing roll, and subsequent nose over.NTSB DEN05CA016Accident · No injuriesData collectionFinal reportCessna 152 · Santa Teresa, NMthe student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.NTSB LAX05CA017Accident · No injuriesData collectionFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane veering off of the runway surface and nosing over.NTSB DFW05CA011Accident · No injuriesData collectionFinal reportPiper PA-28 · Abilene, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the wet runway surface and rain.NTSB LAX05LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mesa, AZthe student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.NTSB DFW05CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Reserve, LAThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the strong crosswind.NTSB DFW05CA003Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Coahoma, TXThe pilot's failure to maintain directional control during landing. A contributing factor was the lack of suitable terrain for landing.NTSB LAX05CA005Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Winslow, AZthe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.NTSB DFW05CA001Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Hearne, TXThe excessive taxi speed by the pilot in command resulting in the pilot's loss of control. A contributing factor was the quartering tailwind.NTSB FTW05LA003Accident · Minor injuriesLimited investigationFinal reportLockheed 18-56 · Midland, TXThe pilot's failure to maintain directional control during takeoff. Contributing factors were the choice of runway used and the prevailing tailwind.NTSB SEA05CA003Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Medford, ORThe pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.NTSB ATL04CA197Accident · No injuriesData collectionFinal reportCessna 150M · Sevierville, TNThe pilot's failure to maintain directional control during an attempted takeoff, which resulted in the on ground collision with high vegetation and a subsequent nose over. Factors were a foggy windshield and windshield defrost not activated.NTSB CHI04CA289Accident · No injuriesData collectionFinal reportArganbright Vans RV-4 · Custer, SDThe pilot's failure to maintain directional control during the landing. Factors were the sudden wind shift and the embankment.NTSB ANC04CA119Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Haines, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a premature liftoff and subsequent uncontrolled descent and collision with the runway.NTSB NYC04LA217Accident · 1 fatalLimited investigationFinal reportFirefly Galaxy 9 · Lewisburg, WVThe pilot's improper decision to attempt to board the balloon while it was ascending.NTSB CHI04CA296Accident · No injuriesData collectionFinal reportPiper PA-16 · Port Huron, MIThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the overload failure of the right main landing gear.NTSB NYC04LA209Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Oxford, CTThe pilot's improper recovery from a bounced landing.NTSB CHI04CA259Accident · No injuriesData collectionFinal reportSchroeder Wichawk · New Hudson, MIThe pilot failed to maintain directional control during takeoff roll. A factor was the VASI light.NTSB CHI04CA242Accident · No injuriesData collectionFinal reportAeronca Champion 7GCBC · Mullen, NEthe failure of the pilot to maintain direction control during gusty wind conditions on landing.NTSB ANC04CA108Accident · No injuriesData collectionFinal reportBailey Merlin GT · Kenai, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in an in-flight collision with terrain during the subsequent aborted landing. A factor associated with the accident was a gusty wind condition.NTSB SEA04LA187Accident · Minor injuriesLimited investigationFinal reportWSK PZL Warzawa-Okecie PZL-104 Wilga 80 · The Dalles, ORAircraft control was not maintained by the tow plane pilot and the glider pilot did not maintain a proper climb rate during the initial climb. A direct crosswind and wind gusts were factors.NTSB ATL04CA180Accident · No injuriesData collectionFinal reportWood/Thorpe T-18 · Olive Branch, MSThe pilot's failure to maintain directional control of the airplane during landing.NTSB ATL04CA182Accident · No injuriesData collectionFinal reportMaule M4-210C · Gainesville, FLThe pilot-rated passenger's inadvertent interference with the flight controls during landing, which resulted in a loss of control and the airplane nosed over.NTSB DEN04FA134Accident · 1 fatalField investigationFinal reportMooney M20D · Pagosa Springs, COthe pilot's inadequate preflight planning and his failure to maintain directional control. Contributing factors were the pilot's failure to abort the takeoff, and the rough and uneven runway surface.NTSB ANC04LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Kenai, AKThe pilot's selection of an unsuitable landing/takeoff site, which resulted in a loss of control and a nose over during an aborted takeoff. Factors in the accident were soft terrain, and the pilot's failure to maintain directional control.NTSB ANC04CA105Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with vegetation and a nose over. A factor contributing to the accident was a tailwind.NTSB IAD04LA044Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Penn Yan, NYthe pilot's loss of directional control during landing which resulted in excessive side-loads and failure of the right main landing gear wheel.NTSB CHI04LA249Accident · Serious injuriesLimited investigationFinal reportJohnson-Moore Zenith CH 701 · Galena, MOA loss of directional control for undetermined reasons. A factor associated with the accident was the tree that the airplane contacted.NTSB CHI04CA247Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grant, NEDirectional control not attained and the control interference encountered by the pilot during landing roll. The ditch was a contributing factor.NTSB ANC04LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, and his failure to maintain directional control which resulted in a loss of control, an encounter with a ditch, and the airplane nosing over. A factor in the accident was a crosswind.NTSB LAX04CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Williams, AZThe pilot's inadequate compensation for the wind condition and his failure to maintain directional/airplane control during landing rollout. Contributing factors were the gusty crosswind and the pilot's inadequate remedial action.NTSB IAD04CA042Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Ocean City, NJThe pilot's deliberate delay of rotation during the takeoff roll, and his subsequent loss of directional control.NTSB CHI04CA244Accident · Minor injuriesData collectionFinal reportBeech BE-18 · Lakeville, MNThe pilot's inadequate flare, the improper recovery from a bounced landing, the loss of directional control, and inadequate compensation for the crosswind. A factor was the crosswind.NTSB NYC04LA221Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Cynthiana, KYThe inoperative left main landing gear brake check valve, which resulted in a loss of directional control during the takeoff.NTSB SEA04CA174Accident · No injuriesData collectionFinal reportLuscombe 8A · Nampa, IDThe pilot's failure to maintain directional control during the landing roll. Factors include the pilot's very low total time in this make and model aircraft (one hour), and the soft terrain the aircraft encountered along the side of the runway.NTSB SEA04LA176Accident · No injuriesLimited investigationFinal reportCessna 150K · Richland, WAThe pilot's failure to maintain aircraft control during landing. Wind gusts, inadequate compensation for wind conditions, and an airport marker sign were factors.NTSB SEA04CA171Accident · Minor injuriesData collectionFinal reportCessna 182P · Hillsboro, ORThe pilot's failure to maintain aircraft directional control during landing roll. A contributing factor was the right-quartering tail wind.NTSB NYC04LA195Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Pittsfield, PAImproper installation of the tailwheel assembly and the inadequate annual inspection which resulted in a loss of directional control during landing.NTSB ANC04CA094Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll due to the restricted movement of the rudder pedals from his headset cord, which resulted in the airplane exiting the runway and nosing down.NTSB NYC04CA196Accident · No injuriesData collectionFinal reportWahl S-51D · Louisville, KYThe pilot's failure to maintain directional control on the runway during landing.NTSB CHI04CA240Accident · No injuriesData collectionFinal reportStinson V77 · Howell, MIThe pilot's failure to maintain directional control which resulted in a ground loop. A factor was the pilot's lack of familiarity with the airplane.NTSB SEA04LA172Accident · No injuriesLimited investigationFinal reportTubbs PA-18-225 DD · Salmon, IDDirectional control not maintained during the takeoff roll resulting in a runway excursion and subsequent nose over. Factors include a drainage ditch.NTSB LAX04CA298Accident · No injuriesData collectionFinal reportBerry Hatz CB-1 · Upland, CAthe pilot's inadequate recovery following a bounced landing, improper use of the rudder control, and failure to maintain directional control.NTSB FTW04CA218Accident · No injuriesData collectionFinal reportBeech BE-58 · Groveton, TXThe pilot's intentional ground loop to avoid colliding with deer that entered the runway during the landing roll. A contributing factor was the tall grass adjacent to the runway that prevented detection of the deer.