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 ANC91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the crosswind.NTSB DEN91LA080Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Santa Fe, NMA forward aft pilot seat adjustment locking mechanism failure.NTSB NYC91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dushore, PAThe pilot landed with excessive airspeed, which resulted in ineffective braking and a loss of control.NTSB ANC91LA064Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll. The unfavorable wind was a related factor.NTSB CHI91DCA01Accident · Serious injuriesFinal reportGremminger Kolb Twinstar · St. Genevieve, MOThe failure of the pilot to abort the takeoff and improper remedial action by the pilot rated passenger after assuming control of the airplane. A factor associated with the accident is the pilot losing directional control during the takeoff ground run.NTSB LAX91LA230Accident · No injuriesLimited investigationFinal reportCessna P210N · Palm Springs, CAFailure of the pilot to maintain directional control during the landing roll.NTSB CHI91LA176Accident · No injuriesLimited investigationFinal reportCessna 152 II · Holland, MIThe pilot's failure to maintain control of the airplane during the touchdown and landing roll on a sod runway. Factors in the accident are the uneven terrain at the runway intersection, and the pilot's improper recovery from a bounced landing.NTSB FTW91LA087Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Horseshoe Bend, ARThe pilot's failure to maintain directional control of the airlane. A factor was the crosswind.NTSB CHI91LA171Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIFailure of the pilot to maintain directional control during the takeoff ground run. A factor associated with the accident is the pilot's lack total experience.NTSB CHI91DEP05Accident · No injuriesFinal reportPiper PA-25-235 · Neenah, WIThe pilot in command's failure to attain sufficient airspeed to achieve flight, and his failure to abort the takeoff.NTSB ANC91LA062Accident · No injuriesLimited investigationFinal reportCessna 172-N · Egegik, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the high winds.NTSB CHI91LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Devils Lake, NDDirectional control not maintained by the pilot. A factor related to the accident was a crosswind condition.NTSB FTW91DPG11Accident · No injuriesFinal reportGrumman G-164A · Holly Grove, ARThe pilot's failure to maintain directional control. Factors were the wet runway and the ditch struck after control was lost.NTSB CHI91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · St. Charles, MOThe pilot's failure to maintain directional control of the airplane during the takeoff ground run. Factors related to the accident were the gusty crosswind conditions, the pilot's lack of total experience and the vehicles which the airplane contacted.NTSB NYC91LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Vergennes, VTThe pilot's excessive taxi speed, resulted in an on ground loss of control.NTSB SEA91LA113Accident · No injuriesLimited investigationFinal reportBeech B23 · Spanish Fork, UTThe pilot did not adequately recover from a bounced landing. Factors to the accident were: a poorly planned approach, and the pilot's lack of total flight experience.NTSB CHI91LA158Accident · No injuriesLimited investigationFinal reportCessna 180 · Scottsbluff, NEFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident were a crosswind condition and lack of total experience in type of aircraft by the pilot.NTSB DEN91LA073Accident · No injuriesLimited investigationFinal reportBeech D18-S · Englewood, COThe loss of directional control by the pilot. Factors were: the cross, failure of the pilot to lock the tail wheel, and the pilot's disregard of crosswind limitations.NTSB LAX91LA215Accident · No injuriesLimited investigationFinal reportTaylorcraft DC12-D · Las Vegas, NVThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilot's lack of total experience in this type of aircraft.NTSB CHI91LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe pilot's failure to maintain directional control during the landing roll. Related to the accident was the pilot's lack of total experience.NTSB CHI91LA150Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hillsbord, WIDirectional control was not maintained by the pilot. A factor related to the accident was a drainage ditch.NTSB SEA91LA102Accident · Minor injuriesLimited investigationFinal reportBoeing A-75 · Seattle, WAThe pilot did not maintain directional control during the landing roll. The factor to the accident was: the pilot's remedial action was inadequate.NTSB CHI91LA276Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monticello, MNThe pilot in command's (CFI) delayed remedial action. Related factors are the gusty crosswind, the student pilot's lack of total experience, inadequate compensation for crosswind conditions, and the cfi's failure to maintain directional control.NTSB LAX91LA201Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Madera, CAThat the pilot failed to properly recover from a bounced landing. Contributing to this accident was the pilot's lack of experience in the airplane.NTSB MIA91LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stuart, FLAn inadequate annual inspection which failed to detect corrosion on the rudder cable. The pilot lost direction control during landing when the rudder cable broke.NTSB SEA91LA100Accident · No injuriesLimited investigationFinal reportCessna A185F · Orting, WAThe pilot's failure to maintain directional control of the aircraft. Contributing to the accident was a vibration in the left main landing gear.NTSB SEA91LA096Accident · No injuriesLimited investigationFinal reportCessna 150J · Mulino, ORThe pilot's inadequate remedial action. Factors include nose-gear vibration.NTSB LAX91LA189Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Fresno, CAThe pilot-in-command's failure to maintain directional control and inadequate compensation for wind conditions during the landing touchdown. Contributing to the accident was the pilot-in-command's overconfidence in his ability while analyzing the forecast…NTSB MIA91LA130Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Leesburg, FLThe failure of the pilot to maintain directional control during the landig roll, and his failure to maintain airspeed during the attempted go-around which resulted in a descent and collision with two parked airplanes. Contributing to the accident was the…NTSB LAX91LA184Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Redlands, CAThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.NTSB LAX91LA183Accident · No injuriesLimited investigationFinal reportCessna 172N · Grass Valley, CAThe failure of the pilot to maintain directional control and to adequately compensate for the wind conditions resulting in an on ground loss of control and subsequent on ground collision with a drainage ditch.NTSB SEA91LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Vernal, UTThe pilot's impairment due to alcohol consumption and his failue to control the airplane during landing.NTSB CHI91LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hibbing, MNThe student pilot's improper flare of the airplane and the cfi's failure to maintain directional control during the recovery. A factor was the soft terrain.NTSB SEA91LA086Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Spokane, WAThe pilot-in-command did not maintain directional control of the airplane. Factors were: the pic's inadequate compensate for the wind, his limited flight expereince in this type of airplane, and the check airman's poor supervision.NTSB SEA91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTThe pilot did not maintain directional control of the airplane during the landing roll. Factors to the accident were: the landing surface was covered with slush, snow was falling and obscured the pilot's vision.NTSB NYC91LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Montgomery, NYThe pilot's inadvertent exit (falling) from the airplane, while attempting to recover an object from outside the airplane without setting the parking brake and/or shutting down the engine.NTSB DEN91LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Lehi, ARThe pilot's failure to maintain aircraft control. Factors were: the wet runway and resultant hydroplaning.NTSB NYC91LA111Accident · No injuriesLimited investigationFinal reportCessna 150G · Phillipsburg, OHThe failure of the pilot to compensate for crosswind conditions during landing, and allowing the airplane to drift off the runway onto soft terrain. A factor relating to the accident was the decision of the pilot to attempt a landing with strong crosswinds.NTSB BFO91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the unfavorable wind condition.NTSB NYC91LA108Accident · No injuriesLimited investigationFinal reportCessna 402A · Albany, NYA collapse of the nose gear due to a failure of the nose gear trunion.NTSB NYC91LA105Accident · No injuriesLimited investigationFinal reportCessna 170B · Newburyport, MAThe pilot failing to compensate adequately for adverse wind conditions during takeoff.NTSB LAX91LA231Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Julian, CAThe pilot's failure to maintain control of his experimental glider during takeoff. A contributing factor was the pilot's encounter with gusty winds.NTSB NYC91LA106Accident · No injuriesLimited investigationFinal reportCessna 172P · Burlington, CTThe failure of the pilot to maintain directional control during the landing. Factors related to the accident were: improper use of the flight controls by the pilot, his lack of recent experience and total time, and the crosswind.NTSB NYC91LA101Accident · No injuriesLimited investigationFinal reportBeech 56TC · New Haven, CTFailure of the pilot to maintain directional control after the nose wheel steering system failed.NTSB LAX91LA146Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Camarillo, CAThe failure of the pilot to maintain directional control of the helicopter and apply proper remedial action. Contributing to the accident was the improper selection of the touchdown point and the disregarding of company procedures.NTSB ANC91LA045Accident · No injuriesLimited investigationFinal reportStinson 108 · Fort Greely, AKUnsuitable terrain selected by the pilot for a precautionary landing.NTSB SEA91LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Ogden, UTThe pilot's poorly planned approached for landing. Factors to the accident were: an excessive airspeed, and the inadequacy of the pilot's recovery from a bounced landing.NTSB DEN91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Collins, COThe loss of directional control by the pilot in command.NTSB CHI91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burwell, NEDirectional control not maintained by the pilot. Factors related to the accident were a gusty crosswind and lack of recent experience by the pilot.NTSB ANC91LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kasigluk, AKThe pilot's failure to maintain directional control of the airplane on landing. Contributing to the accident was the snowbank.