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 CHI91LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Maple Lake, MNDirectional control was not maintained by the pilot. A factor related to the accident was the pilot's lack of total experience.NTSB NYC91LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Greenville, MEInadequate compensation for gusting winds by the pilot-in-command.NTSB NYC91LA190Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Thomasville, PAThe pilot's improper use of flight controls during the landing roll, which resulted in a loss of airplane control. Factors related to the accident were: the loose nose wheel shimmy dampener and the pilot's lack of flight experience in this make and model of…NTSB CHI91LA229Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lake Geneva, WIAircraft control was not maintained by the pilot. Factors related to the accident were a quartering tailwind.NTSB SEA91LA188Accident · No injuriesLimited investigationFinal reportWaco KNF · Wendover, UTPilot installed an improper 'o' ring which restricted normal landing gear extension and subsequent loss of control by the pilot.NTSB LAX91LA327Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Reno, NVThe pilot's failure to maintain directional control of his airplane and his inadequate compensation for the crosswind condition. A contributing factor related to the presence of the crosswind.NTSB ANC91LA106Accident · No injuriesLimited investigationFinal reportCessna 206 · Cube Cove, AKA complete failure of the brake system due to a crack in the brake lines. Contributing to the accident was that the brakes were not adequately maintained by company maintenance personnel.NTSB NYC91LA187Accident · No injuriesLimited investigationFinal reportMeyers MAC-145 · Elyria, OHThe failure of the pilot to maintain directional control during landing. Factors related to the accident were a strong wind shear during landing; unavailability of wheel brakes for the co-pilot; and inadequate supervision of the co-pilot during landing.NTSB CHI91LA225Accident · No injuriesLimited investigationFinal reportCessna 305A · Keokuk, IADiverted attention by the pilot resulting in directional control not being maintained. A factor related to the accident was crosswind.NTSB ANC91LA108Accident · No injuriesLimited investigationFinal reportCessna 185 · Clarks Point, AKThe loss of directional control on the ground caused by the failure of the left brake disc. Contributing to the accident was the pilot-in-command's intentional ground loop of the airplane.NTSB MIA91LA190Accident · No injuriesLimited investigationFinal reportCessna 150M · Tunica, MSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The quartering crosswind and soft terrain were related factors.NTSB LAX91LA285Accident · Minor injuriesLimited investigationFinal reportCessna 172RG/A · Vacaville, CAThe private pilot PIC failed to maintain directional control during landing rollout. The CFI pilot failed to take remedial action.NTSB SEA91LA185Accident · No injuriesLimited investigationFinal reportCessna 180 · Cody, WYPilot's failure to maintain proper runway alignment. Factors were diverted attention, and gusty crosswinds.NTSB CHI91LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILDirectional control was not maintained by the cfi/pic. Factors related to the accident were a gusty cross wind and an airport facility, VASI light.NTSB ANC91LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Jago River, AKThe pilot's loss of directional control of the airplane during the landing roll. Contributing to the accident was the wet surface of the airstrip, the curve in the airstrip, and the vegetation which covered the entire airstrip.NTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.NTSB NYC91LA179Accident · No injuriesLimited investigationFinal reportRobinson R-22B · White Plains, NYThe failure of the pilot to ensure the helicopter had no lateral motion upon touchdown.NTSB SEA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chehalis, WAThe pilot's failure to maintain proper runway alignment. Factors include gusty winds and crosswinds.NTSB SEA91LA173Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Toledo, WADirectional control was not maintained.NTSB NYC91DHM01Accident · Minor injuriesFinal reportAirnew Questair · Lincoln Park, NJA failure of the nose gear fork, which caused the pilot to lose steering control of the airplane and veer off the left side of the runway.NTSB CHI91LA213Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stockton, IACompensation for wind conditions not performed, wrong runway selected and aircraft control not maintained by the pilot. Factors related to the accident were a tailwind/crosswind component and a rough runway.NTSB SEA91LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Richland, WAPartial engagement of the parking brake (locking the right brake) for an undetermined reason.NTSB ANC91LA082Accident · No injuriesLimited investigationFinal reportCessna 185F · Farewell, AKThe pilot-in-command's failure to maintain directional control during the landing roll. Factors relating to the accident were the collapsed left main landing gear, failed left brake, and the low level of hydraulic brake fluid.NTSB NYC91LA163Accident · No injuriesLimited investigationFinal reportLearjet LR25B-XR · Columbus, OHThe failure of the pilot to maintain visual reference with the runway during a landing, which resulted in a loss of directional control. Also causal to the accident was the pilot's failure to initiate a go-around, after he lost sight of the runway during the…NTSB ATL91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lebanon, TNThe pilot's excessive touchdown speed, his failure to maintain a proper touchdown point, and his failure to execute a go-around when a safe landing could not be made. Factors in the accident were: the wet runway conditions at the airport and the crosswind…NTSB ANC91LA088Accident · No injuriesLimited investigationFinal reportCessna 170B · Cordova, AKThe pilot's failure to maintain directional control during the takeoff ground run and the intentional ground loop by the pilot. The crosswind was a factor in the accident.NTSB ANC91LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKWas the pilot-in-command's loss of control during the takeoff run, thereby allowing the airplane to stray from the runway's centerline and to strike some high vegetation.NTSB LAX91LA283Accident · No injuriesLimited investigationFinal reportBoeing E75 · San Luis Obispo, CAThat the pilot failed to properly compensate of the existing quartering tailwind, improperly using the flight controls and brakes.NTSB FTW91LA111Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Clinton, ARThe loss of directional control due to locked wheel brake on the left landing gear.NTSB DEN91LA093Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COThe pilot's failure to compensate for the crosswind. Factors were: a crosswind condition, and the pilot's total lack of experience.NTSB SEA91FA143Accident · Serious injuriesField investigationFinal reportSikorsky S-64E · Index, WAThe control interference by the mechanic when he inadvertently raised the collective pitch and the copilot's failure to attend the flight controls. Factors relating to the accident were the motion sickness of the mechanic, inadequate collective pitch control…NTSB ANC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of control during the takeoff sequence caused by the failure of the tail wheel steering spring. Factors contributing to the accident were the gusty wind conditions and soft terrain.NTSB SEA91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yakima, WAThe loss of control by the private pilot and failure of the instructor pilot to perform remedial action.NTSB NYC91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Endicott, NYThe failure of the pilot to attain the proper airspeed during an aborted landing, which resulted in a stall and loss of airplane control. Factors related to the accident were: the loss of directional control during landing, and the lack of recent flight…NTSB NYC91LA156Accident · No injuriesLimited investigationFinal reportBoeing PT-17A75N1 · Limington, METhe improper handling of the airplane while taxiing, which resulted in a loss of control. A factor was the limited experience of the pilot in this model.NTSB CHI91LA200Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olathe, KSDirectional control was not maintained by the pilot. A factor related to the accident is crosswind.NTSB MIA91LA167Accident · No injuriesLimited investigationFinal reportSwearingen SA227-TT · Tupelo, MSThe improper installation of the nose steering actuator arming valve by a mechanic which resulted in failure of the actuator and on ground loss of directional control by the pilot during landing rollout.NTSB ANC91LA080Accident · No injuriesLimited investigationFinal reportCessna 170A · Kakeen, AKThe pilot's failure to maintain directional control of the airplane during the aborted takeoff. Contributing to the accident was the soft, rough, and uneven terrain.NTSB ANC91LA079Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Beluga, AKWas the pilot-in-command's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the rough, uneven terrain and crosswind.NTSB MIA91LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooksville, FLFailure of the student pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was his lack of total experience.NTSB CHI91LA198Accident · No injuriesLimited investigationFinal reportCessna 180 · Grayling, MIThe pilot in command's failure to maintain directional control during landing roll.NTSB SEA91LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Vancouver, WAA hard landing by the pilot due to improper bounced landing recovery.NTSB DEN91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Englewood, COThe pilot's failure to maintain visual lookout. A factor was: the pilot's improper use of the throttle controls and brakes.NTSB FTW91LA102Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Lancaster, TXThe pilot's failure to recover from a bounced landing. A factor was the gusting winds.NTSB ATL91LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNStudent pilot's failure to maintain directional control during the landing roll.NTSB LAX91LA261Accident · No injuriesLimited investigationFinal reportCessna T-210 · San Carlos, CAThe pilot-in-command's failure to maintain directional control on landing. Factors related to the accident were the pic's inadequate compensation for wind conditions and improper recovery procedures from a bounced landing.NTSB DEN91LA086Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Deming, NMThe pilot's failure to maintain directional control. Factors were: a crosswind condition and a soft shoulder alongside the runway.NTSB CHI91LA191Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Eagle Bend, MNThe pilot in command's failure to attain proper alignment with the runway. Factors contributing to this accident were an unreliable airspeed indicator and the pilot's decision to operate with this known deficiency.NTSB CHI91LA190Accident · No injuriesLimited investigationFinal reportCessna 195 · Detroit, MIFailure to maintain directional control, and inadequate aircraft preflight. A factor related to the accident is the instructor pilot's lack of experience in the type aircraft.NTSB LAX91LA256Accident · No injuriesLimited investigationFinal reportWeaver WACO-ASO · Montague, CAFailure of the pilot to maintain directional control of the airplane and improper use of the brakes.