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 LAX00LA120Accident · No injuriesLimited investigationFinal reportCessna 150E · Reedley, CAA loose seat latch which permitted the seat to move aft to a position where the pilot could no longer reach the controls.NTSB LAX00LA119Accident · No injuriesLimited investigationFinal reportStearman A-75 · Imperial, CAThe failure of the pilot-in-command to maintain directional control of the aircraft during landing roll.NTSB NYC00LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · West Milford, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the gusty crosswind conditions.NTSB ANC00LA032Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Fairbanks, AKThe pilot's inadvertent ground loop.NTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB CHI00LA084Accident · No injuriesLimited investigationFinal reportCessna 150M · Marshall, MOthe go-around not performed, the improper flare, and recovery from a bounced landing not performed by the pilot. The crosswind was a contributing factor.NTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.NTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.NTSB CHI00LA081Accident · No injuriesLimited investigationFinal reportCessna 172R · Waterford, MIthe directional control not obtained/maintained by the dual student and the remedial action not performed by the certified flight instructor. Contributing factors were the crosswind and the snow bank.NTSB CHI00LA078Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Saginaw, MIthe pilots failure to maintain directional control of the aircraft. Factors were the icy runway and the snowbank.NTSB CHI00LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Wisconsin Rapid, WIThe student pilot's failure to maintain directional control. Factors were the pilot's lack of total experience and the snowbank.NTSB ATL00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nashville, TNThe pilot's failure to maintain directional control during the landing roll.NTSB FTW00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Weir, TXThe delayed aborted takeoff by the pilot. Factors were the pilot's intentional ground loop/swerve and the tail wind.NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB CHI00FA071Accident · No injuriesField investigationFinal reportBeech 1900D · Escanaba, MIthe failure of the flightcrew to maintain directional control due to unsafe/hazardous conditions on the runway that was not relayed to them. Factors were the uneven snow covered runway and the snowbank.NTSB NYC00LA080Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F19 · West Lafayette, OHwas a delayed decision of the pilot to abort the landing. Factors were the wet runway, and the tail winds that prevailed in the area.NTSB NYC00LA074Accident · No injuriesLimited investigationFinal reportGrumman American AA1 · Wildwood, NJThe student pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB MIA00LA086Accident · No injuriesLimited investigationFinal reportCessna 172R · Olive Branch, MSThe student pilot's failure to maintain directional control during landing and the subsequent collision with a taxiway sign and collapsed right main landing gear.NTSB LAX00LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bermuda Dunes, CAFailure of the student pilot to maintain directional control of the airplane during takeoff.NTSB DEN00TA049Accident · Minor injuriesFinal reportCessna A185F · Loveland, COFailure of the pilot in command to maintain directional control, resulting in an inadvertent ground loop. A factor was the crosswind.NTSB LAX00LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Honolulu, HIThe pilot's improper use of the brakes during the landing rollout. The pilot's self induced pressure and the quartering tailwind were factors in the accident.NTSB LAX00LA092Accident · No injuriesLimited investigationFinal reportLutes Kitfox II · Livermore, CAThe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain runway alignment.NTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.NTSB LAX00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Barbara, CAThe dual student's loss of directional control and the flight instructor's inadequate supervision of the flight.NTSB LAX00LA079Accident · No injuriesLimited investigationFinal reportRobinson R22B · Piru, CAFailure of the pilot to maintain control after encountering a dynamic rollover.NTSB FTW00LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Sand Springs, OKThe pilot's failure to maintain aircraft control during landing roll.NTSB IAD00LA016Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Waynesburg, PAthe pilot's failure to maintain aircraft control during the landing roll-out.NTSB MIA00LA061Accident · No injuriesLimited investigationFinal reportEaa Chapter 229 Zenair 601 · Kissimmee, FLThe pilot's failure to maintain directional control on landing resulting in the airplane going off the side of the runway and colliding with a barricade.NTSB NYC00LA060Accident · No injuriesLimited investigationFinal reportBeech C-23 · Manassas, VAThe pilot's inadequate remedial action to recover the airplane from porpoising during the landing roll out.NTSB ATL00LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Oakland, ALThe pilot's failure to verify that his seat was locked prior to takeoff. The subsequent bounce on takeoff enabled the seat to shift aft thereby reducing the pilot's access to controls leading to the inadvertent loss of control and ground impact with trees.…NTSB LAX00LA056Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Oxnard, CAThe pilot's inadequate compensation for the variable crosswind condition and subsequent failure to maintain directional control of the airplane.NTSB CHI00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Alexandria, MNThe pilot's inadequate inflight decision to continue flight into icing conditions. An additional cause was the directional control not maintained by the pilot. Contributing factors were the viewable area of the aircraft's heated windshield panel, in-flight…NTSB MIA00LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCThe certified flight instructor (CFI) failure to maintain directional control on rough terrain on takeoff. This resulted in the airplane veering to the left, colliding with bushes after the airplane became airborne, and subsequent in-flight collision with…NTSB LAX00LA053Accident · No injuriesLimited investigationFinal reportCessna 172A · Shoshone, CAThe pilot's inadequate compensation for the existing strong and gusting wind conditions and his subsequent failure to maintain directional control.NTSB FTW00LA050Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXThe student pilot's failure to maintain control of the airplane during the landing roll.NTSB ATL00FA016Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Geneva, ALThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall and the subsequent collision with trees.NTSB SEA00LA029Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Port Townsend, WACompensation for wind conditions was inadequate. Gusting wind conditions were a factor.NTSB LAX00LA048Accident · Serious injuriesLimited investigationFinal reportOehling Questair Venture · Auburn, CAThe owner/builder's failure to properly bleed the brake system following replacement of the right brake line, which caused the right brake to not function and led to the pilot's inability to maintain directional control.NTSB MIA00LA037Accident · No injuriesLimited investigationFinal reportCessna 150M · Morristown, TNThe pilot's failure to maintain directional control during the takeoff phase of a touch and go landing, and the subsequent skid off the runway and collapsed nose landing gear during the attempt to abort the takeoff.NTSB MIA00LA035Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Daytona Beach, FLThe pilot's failure to maintain directional control during an attempted go-around, and the subsequent wing tip strike of the ground and collision with a tree. A factor in the loss of control was the crosswind conditions present during the landing attempt.NTSB LAX00LA046Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Sedona, AZThe pilot's inadequate compensation for the crosswind conditions and subsequent failure to maintain directional control of the airplane.NTSB NYC00LA043Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Grove City, PAThe flight instructor's failure to maintain control of the airplane during the landing rollout.NTSB NYC00LA032Accident · Minor injuriesLimited investigationFinal reportStatz Kitfox II · Ebensburg, PAwas the failure of the pilot to maintain directional control during a bounced landing recovery. A factor was the pilot's lack of experience in make and model.NTSB IAD00LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Hopedale, MAwas the student pilot's improper flare that resulted in a bounced landing and the flight instructor's delay in taking remedial action.NTSB LAX00LA032Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, CAThe pilot's failure to maintain directional control of the airplane during the touch-and-go takeoff.NTSB FTW00LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Rose Hill, TXThe pilot's failure to maintain directional control during takeoff roll, which resulted in an inadvertent ground loop.NTSB CHI00LA030Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Saint Charles, MOthe pilot's failure to maintain directional control on landing. A factor was the crosswind.NTSB ATL00LA011Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Hollandale, MSThe certified flight instructor's inadequate supervision of the landing and the student pilot's failure to relinquish the flight controls when the certified flight instructor attempted to recover from a bounced landing.NTSB CHI00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Hannibal, MOthe pilot not maintaining directional of the airplane. Factors were the crosswinds and gusts.NTSB MIA00LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Raleigh, NCThe pilot's failure to maintain directional control on landing rollout for undetermined reasons. This resulted in the airplane veering off the runway and colliding with an airport sign.