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 CHI05CA167Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Palmyra, WILoss of directional control by the dual student and delayed remedial action by the flight instructor resulting in the airplane nosing over.NTSB DFW05CA174Accident · No injuriesData collectionFinal reportLearjet 25 · Amarillo, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the prevailing crosswind.NTSB ATL05CA123Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Shorter, ALThe pilot's failure to maintain directional control, which resulted in the collapse of the left main landing gear.NTSB LAX05LA220Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Prescott, AZthe pilot's failure to maintain directional control during the landing rollout.NTSB SEA05CA135Accident · No injuriesData collectionFinal reportCessna 170B · Laurel, MTThe flight instructor's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop. A contributing factor was the flight instructor's diverted attention to talking with the student.NTSB CHI05CA157Accident · Minor injuriesData collectionFinal reportCessna 195 · Peru, ILThe pilot not maintaining directional control during the landing and the ground loop he encountered.NTSB IAD05LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Marysville, OHThe pilot's failure to maintain directional control during landing.NTSB CHI05LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Allegan, MIThe inadequate aircraft control by the PA-28-180 pilot while the airplane was stopped.NTSB SEA05CA131Accident · No injuriesData collectionFinal reportMaule M-7-235B · Hermiston, ORThe pilot's failure to maintain directional control during the takeoff ground roll which resulted in overload damage to the main landing gear. During the landing roll, it was not possible to maintain aircraft control due to the previously damaged gear.…NTSB IAD05CA086Accident · Minor injuriesData collectionFinal reportPorterfield CP-65 · Jaffrey, NHThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor in the accident was the drop off/descending embankment at the runway's edge.NTSB IAD05LA082Accident · No injuriesLimited investigationFinal reportBeech C35 · West Milford, NJThe pilot's failure to maintain directional control during landing, which resulted in a collision with a drainage ditch.NTSB DFW05CA173Accident · No injuriesData collectionFinal reportAyres S-2R · Eagle Lake, TXThe pilot's failure to maintain directional control during landing.NTSB ATL05CA112Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dunnellon, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB SEA05CA119Accident · No injuriesData collectionFinal reportAdkins Ridge Runner II · Pocatello, IDThe pilot's failure to maintain directional control during the takeoff roll, which resulted in an inadvertent ground loop/swerve.NTSB LAX05CA211Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Phoenix, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB ATL05CA129Accident · No injuriesData collectionFinal reportLuscombe 8E · Orangeburg, SCThe pilot's failure to maintain directional control during landing roll.NTSB DFW05CA161Accident · No injuriesData collectionFinal reportCessna A188B · Osceola, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the prevailing crosswind.NTSB ANC05CA083Accident · No injuriesData collectionFinal reportCessna 170B · Anchorage, AKThe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in a loss of control and an inadvertent ground-loop. A factor associated with the accident was a crosswind.NTSB IAD05LA074Accident · No injuriesLimited investigationFinal reportWaco GXE · Paducah, KYThe pilot's failure to maintain directional control during landing resulting in a ground loop and impact with the runway. A factor in the accident was the limited authority of the tailwheel steering system.NTSB DFW05CA154Accident · No injuriesData collectionFinal reportCessna 152 · Marietta, OKThe pilot's failure to maintain directional control while executing a soft field take off. A factor was the prevailing dark night conditions.NTSB ANC05LA082Accident · No injuriesLimited investigationFinal reportdeHavilland DHC-2 · King Salmon, AKThe pilot's failure to correct for torque/P-Factor during the takeoff run, and his delay in aborting the takeoff, which resulted in a loss of directional control and subsequent wing collision with the surface of the water. A factor contributing to the…NTSB ANC05LA081Accident · No injuriesLimited investigationFinal reportCessna 170B · Ninilchick, AKThe pilot's failure to maintain control of the airplane during the landing roll on a beach, which resulted in an on-ground collision with terrain. A factor associated with the accident is a tailwind.NTSB SEA05CA123Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ontario, ORThe pilot's failure to maintain aircraft control during landing roll. A contributing factor was the cross wind weather condition.NTSB LAX05LA194Accident · No injuriesLimited investigationFinal reportMaule 7-235 · Truckee, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB NYC05CA091Accident · No injuriesData collectionFinal reportAuster Mark 6 · Old Bridge, NJAn overload failure of the right tailwheel steering arm.NTSB NYC05CA090Accident · No injuriesData collectionFinal reportCessna 150G · Willimantic, CTThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control while landing.NTSB DFW05CA148Accident · No injuriesData collectionFinal reportAermacchi Bosbok AM 3-C · Marfa, TXThe pilot's failure to attain adequate airspeed, and his premature liftoff resulting in a loss of directional control.NTSB DFW05CA143Accident · No injuriesData collectionFinal reportLuscombe 8A · Wagoner, OKThe pilots failure to maintain directional control during landing and attempted go-around.NTSB LAX05CA191Accident · No injuriesData collectionFinal reportCessna 172N · Stockton, CAthe pilot's improper use of the brakes, and his failure to maintain directional control during the landing rollout.NTSB CHI05CA131Accident · Minor injuriesData collectionFinal reportCessna TU206G · West Bloomfield, MIThe pilot's inadvertent water landing with the amphibious-float wheels extended causing the airplane to nose over.NTSB ANC05LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate compensation for gusting wind conditions during landing, which resulted in a ground-loop, and structural damage to the airplane. Factors associated with the accident were a ground-loop, and wind gusts.NTSB DEN05IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe reason for the occurrence was not determined.NTSB CHI05CA123Accident · No injuriesData collectionFinal reportCessna C-172M · Madison, WIThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors were the gusty winds and the soft ground.NTSB SEA05LA101Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Driggs, IDThe pilot's failure to compensate for wind conditions, which resulted in a ground loop/swerve during the landing roll. A crosswind was a factor.NTSB DEN05LA115Accident · No injuriesLimited investigationFinal reportHepperlen RV-8 · Durango, COthe pilot's failure to maintain directional control during the ground roll.NTSB CHI05CA118Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Ypsilanti, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. Factors associated with the accident were the crosswind condition and the taxiway sign which was contacted. This case was modified October 12, 2006!!NTSB ANC05CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Dillingham, AKThe instructor pilot's inadequate supervision, and the dual student's failure to maintain directional control. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB ANC05LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident are a crosswind, and an inadvertent ground loop/swerve.NTSB SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.NTSB ANC05LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Homer, AKThe flight instructor's inadequate supervision of the flight during the landing roll, which resulted in a loss of control, and collision with a ditch. A factor associated with the accident was the student pilot's failure to maintain directional control.NTSB LAX05CA157Accident · No injuriesData collectionFinal reportCessna 182R · Camarillo, CAthe pilot's failure to maintain directional control during a touch-and-go landing. A contributing factor was the wet dirt at the runway edge.NTSB SEA05LA094Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, IDThe pilot's failure to maintain directional control during the landing roll. An inadvertent ground loop was a factor.NTSB LAX05LA154Accident · No injuriesLimited investigationFinal reportKittleson Quickie Q-200 · Santa Barbara, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB LAX05CA153Accident · Minor injuriesData collectionFinal reportAerotek Pitts S-2A · Tracy, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control, which resulted in a ground loop and nose over.NTSB MIA05CA099Accident · No injuriesData collectionFinal reportPiper PA32-301 · Brooksville, FLThe pilot-in-command failure to maintain directional control during takeoff after landing, which resulted in the airplane exiting the runway.NTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.NTSB LAX05CA148Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe student's failure to maintain directional control and the CFI's failure to adequately supervise the flight.NTSB DFW05CA108Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH-2000 · Panhandle, TXThe student pilot's improper compensation for existing wind conditions. Contributing factors were the crosswind and inadequate supervision by the flight instructor.NTSB CHI05CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · South Bend, INThe student pilot failed to compensate for the crosswind condition and failed to maintain directional control. Factors included the crosswind and the windsock.NTSB ANC05CA062Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, which resulted in a loss of control and the airplane nosing over. A factor associated with the accident was a crosswind, and an inadvertent ground loop.