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 LAX01LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · San Jose, CAThe failure of the pilot to maintain directional control during landing.NTSB NYC01LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Keene, NHThe pilot's failure to maintain directional control during the landing roll. A factor included the patchy snow on the runway.NTSB DEN01LA068Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Morgan, UTthe pilot's failure to maintain directional control during landing roll which resulted in a collision with a snow bank on the edge of the runway.NTSB FTW01LA075Accident · No injuriesLimited investigationFinal reportCessna 172F · Clovis, NMthe pilot's failure to maintain directional control during take off roll resulting in a ground loop. A contributing factor was the crosswind.NTSB MIA01LA092Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Sylacauga, ALThe pilot's failure to maintain directional control during landing rollout, and the subsequent runway excursion and collision with trees.NTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…NTSB DEN01LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Junction, COthe student pilot's failure to recover from a bounced landing, which resulted in porpoising and subsequently a nose over.NTSB DEN01LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control of the airplane during landing.NTSB MIA01LA088Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Sanford, NCThe failure of the pilot to maintain directional control of the airplane after the second touchdown following a bounced landing resulting in collapse of all landing gears.NTSB CHI01LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNThe student pilot's failure to maintain directional control during the landing. Factors relating to the accident were the student pilot's lack of total experience, the icy runway, the strong crosswind, the wind gusts, and the snowbank.NTSB LAX01LA106Accident · Minor injuriesLimited investigationFinal reportAscher Yakolev YAK 11 · Ione, CAThe failure of the pilot to maintain directional control during the takeoff run. A factor in the accident was the pilot's lack of total experience in the type aircraft.NTSB DEN01LA057Accident · No injuriesLimited investigationFinal reportEurocopter France AS-350-B2 · Powder River, WYThe pilot's failure to maintain aircraft control during aircraft shut down procedures. Contributing factors were: the snow and ice covered field and the confined landing areas unsuitable obstacle clearance.NTSB MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.NTSB LAX01LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · San Diego, CAThe pilot's failure to maintain directional control of the airplane during landing rollout.NTSB LAX01LA100Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · San Jose, CAThe pilot's inadequate compensation for the existing crosswind condition and subsequent failure to maintain directional control during the landing rollout.NTSB CHI01LA091Accident · No injuriesLimited investigationFinal reportCessna 206H · New Richmond, WIThe pilot was unable to maintain directional control of the airplane when it contacted a patch of ice during the landing roll. Factors associated with the accident were the ice and the snow bank which the airplane contacted and the pilot inadvertantly landed…NTSB CHI01LA092Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIAircraft control not maintained by the student pilot during the takeoff roll. Factors to the accident were the student pilot's lack of experience and the snowbank.NTSB LAX01LA096Accident · No injuriesLimited investigationFinal reportCessna 195A · Palm Springs, CAThe flight instructor's inadequate supervision of his dual student who lost directional control on landing.NTSB SEA01LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bozeman, MTThe pilot rated passenger's failure to maintain directional control during the landing. A factor was the snow berm which the aircraft rolled into during the landing.NTSB DEN01LA049Accident · No injuriesLimited investigationFinal reportCessna 180K · Clovis, NMThe pilot's failure to maintain directional control, which resulted in the subsequent swerve of the airplane. Contributing factors were the pilot's lack of experience in make and model and his diverted attention while attempting to adjust the trim.NTSB LAX01LA090Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Tombstone, AZThe pilot's lack of directional control on the landing roll, which resulted in a ground loop and inadvertent nose over.NTSB CHI01LA081Accident · No injuriesLimited investigationFinal reportCessna 172RG · Troy, MIthe excessive touchdown airspeed and the directional control not maintained by the pilot. The snow bank was a contributing factor.NTSB CHI01LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Charlevoix, MIThe pilot failed to maintain directional control of the airplane due to inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, the icy runway, and the snow bank.NTSB DEN01LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Junction, COFailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was lack of total pilot experience in aircraft make and model.NTSB ATL01LA032Accident · No injuriesLimited investigationFinal reportCessna 208 · Key West, FLThe airplanes' inadvertent collision with a swell during a water landing near a ferry boat that resulted the overload failure of the rear float/strut assembly.NTSB FTW01LA055Accident · No injuriesLimited investigationFinal reportSchmidt Questair Venture · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll. Factors were the crosswind and soft terrain condition.NTSB DEN01LA046Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COthe student pilot's inadequate compensation for the crosswind during landing roll. A contributing factor was the cross wind weather condition.NTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.NTSB LAX01LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Camarillo, CAThe failure of the pilot to maintain directional control during takeoff.NTSB NYC01LA069Accident · Minor injuriesLimited investigationFinal reportMooney M-20 · S. Charleston, WVThe pilot's failure to maintain runway alignment during the landing roll.NTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.NTSB NYC01IA068Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Jamaica, NYThe pilot's decision to perform an auto rollout on a snow contaminated runway, which had not been demonstrated, and which resulted in a loss of directional control, when the capability of the autoland system to maintain directional control was exceeded.…NTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.NTSB SEA01LA041Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Arlington, WAThe pilot's failure to maintain directional control during landing roll.NTSB ATL01LA025Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Columbus, MSThe pilots failure to maintain directional control of the airplane ,and subsequently resulted in the collapse of the right main landing gear.NTSB DEN01LA043Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Durango, COfailure by the pilot to maintain directional control of the aircraft during landing roll. A factor was the pilot's lack of experience in aircraft make and model.NTSB DEN01LA042Accident · No injuriesLimited investigationFinal reportCessna P210N · Pagosa Springs, COfailure to maintain directional control of the aircraft after an encounter with adverse weather during landing roll. A factor was ground fog.NTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.NTSB CHI01LA065Accident · No injuriesLimited investigationFinal reportLuscombe 8E · North Platte, NEThe inadvertent ground loop. Factors associated with the accident were the pilot selected the wrong runway on which to land, the quartering tailwind, the icy runway, and the snow bank which the airplane contacted.NTSB LAX01LA077Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Atwater, CAThe student's failure to maintain directional control while landing in a crosswind, his improper compensation for wind conditions, and the flight instructor's inadequate flight supervision.NTSB CHI01LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Mattoon, ILthe pilot's failure to maintain directional control. Factors were the crosswind, the pilots lack of total experience, and the snow covered terrain adjacent to the runway.NTSB SEA01LA038Accident · No injuriesLimited investigationFinal reportCessna 402B · Ontario, ORPilot's failure to maintain aircraft control while landing. Factors include a snow covered runway.NTSB SEA01LA036Accident · No injuriesLimited investigationFinal reportCessna 172K · Troutdale, ORThe pilot's failure to adequately compensate for wind conditions while taxiing the airplane.NTSB MIA01LA056Accident · Serious injuriesLimited investigationFinal reportMaule MXT-7-180A · Perry, FLThe loss of control on landing due to the student's improper recovery from a bounced landing, and the resulting nose over on the grass runway.NTSB IAD01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NHThe flight instructor's improper decision to land downwind on the snow and ice covered runway with a tailwind, and his failure to perform a go-around. Factors in the accident were the tailwind and the snow and ice on the runway.NTSB DEN01LA038Accident · No injuriesLimited investigationFinal reportAviat A-1A · Eden, UTthe pilot's failure to maintain aircraft control during a landing attempt. A contributing factor was his failure to check the snow conditions in the field before the flight.NTSB CHI01LA060Accident · No injuriesLimited investigationFinal reportCessna 172S · Sioux Falls, SDAircraft directional control not being maintained by the student pilot during the takeoff roll. Factors to the accident were the snow bank and the student pilot's lack of total experience.NTSB CHI01LA061Accident · No injuriesLimited investigationFinal reportMooney M20S · Port Huron, MIThe pilot failed to maintain directional control of the airplane and the runway selected resulted in a tailwind condition. Factors associated with the accident were the gusty crosswind and the snow bank.NTSB CHI01LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln, ILThe pilot's failure to maintain directional control on the runway. Factors relating to this accident were the aborted takeoff attempt, the pilot's improper in-flight planning/decision, and the snowbank.NTSB CHI01LA058Accident · No injuriesLimited investigationFinal reportCessna 172N · Elkhart, INThe loss of directional control by the student pilot and the inadequate remedial action and inadequate supervision by the certified flight instructor. Factors were the snow and ice covered runway and the snowbank.