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 CHI92LA264Accident · No injuriesLimited investigationFinal reportCessna 170A · Angola, INFailure of the pilot to maintain directional control during landing rollout.NTSB BFO92LA122Accident · No injuriesLimited investigationFinal reportCessna 185 · Dover Foxcroft, MEInadequate servicing of the aircraft which resulted in the lack of hydraulic fluid and the consequent loss of brake presure.NTSB MIA92LA171Accident · No injuriesLimited investigationFinal reportCessna 172M · Hernando, MSThe failure of the pilot in command to compensate for the crosswind condition, resulting in a ground loop. Contributing to the accident was the pilot's lack of experience in the type of aircraft.NTSB BFO92LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Great Barringto, MAThe pilot's failure to recover from a bounced landing. Factors related to the accident were the pilot's inadequate flare and failure to maintain directional control.NTSB ANC92LA151Accident · No injuriesLimited investigationFinal reportCessna 185E · Yakutat, AKThe pilot in command not maintaining directional control of the airplane.NTSB LAX92LA371Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Casa Grande, AZThe pilots inadequate compensation for the existing wind conditions. The gusty nature of the cross wind condiitons encountered was a factor.NTSB LAX92LA370Accident · No injuriesLimited investigationFinal reportCessna 150G · Woodland, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. Factors in the accident were the students lack of total experience and the soft nature of the recently plowed field the aircraft encountered.NTSB CHI92LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INThe pilot's failure to maintain directional control during the landing roll.NTSB LAX92LA364Accident · No injuriesLimited investigationFinal reportCessna 140 · Reedley, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll and his excessive use of the brakes.NTSB SEA92LA186Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Morgan, UTPoor inflight planning/decision by the pilot in command. Factors contributing to the accident were: the gravel/dirt bank, night environmental conditions, and runway lighting unavailable.NTSB LAX92LA363Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Bakersfield, CALeakage of brake fluid from an unknown source onto the brake lining and drum.NTSB NYC92LA172Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · West Mifflin, PAThe pilot inadvertently ground looped the airplane which resulted in the main landing gear collapsing. A factor in this accident was the pilot's limited flight time in this make and model airplane.NTSB LAX92LA359Accident · Minor injuriesLimited investigationFinal reportTBM TBM 700 · So. Lake Tahoe, CAThe failure of both pilots to adequately anticipate and compensate for the variable cross wind condition, and, the pilot in command's inadequate supervision of the flight. A factor in the accident was the left seat pilot's limited total experience and…NTSB ANC92LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKThe pilot's improper preflight planning/preparation, his improper compensation for wind conditions, and his failure to maintain directional control during the takeoff run. Contributing to the accident was the crosswind.NTSB LAX92LA358Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Laveen, AZThe failure of the pilot to maintain directional control of the aircraft during the landing roll.NTSB FTW92LA214Accident · No injuriesLimited investigationFinal reportCessna A185F · Amelia, LAThe pilot's selection of unsuitable terrain for takeoff.NTSB ATL92LA161Accident · No injuriesLimited investigationFinal reportCessna 172N · New Bern, NCThe student pilot's failure to maintain directional control on the landing roll. Factors were the pilot's lack of total experience and the crosswind conditions at the airport.NTSB LAX92LA353Accident · No injuriesLimited investigationFinal reportFleet II · Long Beach, CAThe pilot's improper compensation for the wind condition, and improper use of the flight controls. Contributing to this accident was the crosswind condition and the collapsing of the main landing gear due to overload.NTSB FTW92DRD06Accident · No injuriesFinal reportCessna A188B · Mathew, LAThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot's lack of experience in the type operation.NTSB SEA92LA179Accident · No injuriesLimited investigationFinal reportCessna A185F · Ennis, MTDirectional control was not maintained. Factors to the accident were: a loose gravel airstrip, wind gusts and inadequate remedial action.NTSB NYC92LA158Accident · No injuriesLimited investigationFinal reportStinson ST-75 · Sussex, NJThe pilot failed to maintain control of the airplane during the landing roll, and inadvertently swerved and ground looped into two parked airplanes. A factor in this accident was the pilot's lack of expereince in this make and model airplane.NTSB ATL92LA158Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ft. Payne, ALThe pilot's improper procedure, in that he failed to raise the flaps following the short field landing, as prescribed in the pilot's information manual, which resulted in a loss of directional control. Factors were the tall grass adjacent to the runway, the…NTSB NYC92LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainville, CTFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. The embankment beside the runway was a related factor.NTSB FTW92DPG12Accident · No injuriesFinal reportGrumman G-164A · Mc Crory, ARThe pilots failure to maintain directional control.NTSB CHI92LA239Accident · No injuriesLimited investigationFinal reportCessna 182BTW · Plymouth, MIAn inadvertent ground loop.NTSB SEA92LA175Accident · No injuriesLimited investigationFinal reportCessna 172H · Lakeview, ORThe pilot's failure to maintain directional control. Factors include soft terrain.NTSB LAX92LA339Accident · No injuriesLimited investigationFinal reportBeech D17S · Bishop, CAThe pilot's failure to maintain directional control; improper use of the rudder and excessive braking. Contributing to this accident was the pilot's lack of experience in the accident airplane make and model.NTSB CHI92LA235Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Paul, MNThe pilot's inattentiveness and improper use of the airplanes brakes. A factor which contributed to this accident was the incorrect brake system installed on the airplane.NTSB ANC92LA121Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCS12-D · Sitka, AKThe pilots failure to maintain directional control of the airplane. Contributing to the accident were the crosswind and the large boulders (objects) beside the runway.NTSB ANC92LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Ketchikan, AKThe pilot in command/instructor pilot failed to maintain directional control of the airplane during the ground run.NTSB ANC92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the unfavorable wind, the trees, and the fence.NTSB NYC92LA143Accident · No injuriesLimited investigationFinal reportPitts S-1S · Galion, OHThe pilot's failure to maintain directional control after landing and the subsequent loss of airplane control.NTSB ATL92LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocracoke, NCThe student pilot's failure to maintain directional control during the landing roll. Factors were the pilot's lack of recent total experience, and the crosswind conditions, and the dirt bank adjacent to the runway.NTSB DEN92LA079Accident · No injuriesLimited investigationFinal reportRobert D. Waldron Kitfox III · Fort Collins, COLoss of control which resulted in dragging a wing tip during flare for landing which ended with a ground loop. A factor was: a tail wind.NTSB SEA92LA172Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe pilot misjudged the landing flare. Factors include a lack of total pilot expereince.NTSB LAX92LA320Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Las Vegas, NVThe loss of directional control due to the students excessive use of the rudder controls, and, the instructors inadequate supervision of the flight.NTSB LAX92LA318Accident · No injuriesLimited investigationFinal reportChapuis Spezio Sport · Wells, NVThe pilot's inadequate compensation for the existing wind conditions and his subsequent failure to maintain directional control of the aircraft. A factor in the accident was the variable and gusty nature of the wind conditions at the airport.NTSB LAX92LA317Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Lovelock, NVThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the presence of dust devils in the vicinity of the airport.NTSB SEA92IA164Incident · 1 fatalIncident investigationFinal reportSmith Vari EZE · Terry, MTThe pilot in command's exceeding liftoff speed during a taxi test.NTSB BFO92LA113Accident · No injuriesLimited investigationFinal reportStinson JR.SR. · Hanson, MAThe pilot inadequate compensation for wind which resulted in the loss of directional control.NTSB ANC92LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKAn inoperative tailwheel.NTSB ATL92LA142Accident · No injuriesLimited investigationFinal reportCessna A185F · Maxton, NCThe pilot's inadequate compensation for wind condition and the pilot-in-command's inadequate supervision of the pilot in training.NTSB BFO92LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pikesville, KYThe pilot's failure to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's improper flare. And objects near the runway.NTSB LAX92LA304Accident · No injuriesLimited investigationFinal reportCessna 182Q · Montague, CAThe pilot failure to maintain directional control.NTSB FTW92LA186Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gould, ARThe aircraft crosswind landing capability was exceeded. A factor was the the gusting crosswind.NTSB SEA92LA155Accident · No injuriesLimited investigationFinal reportHelio H-295 · Laramie, WYThe pilot's failure to maintain runway alignment, and an inadvertent ground-loop. Factors include crosswinds.NTSB FTW92LA179Accident · No injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXThe pilot's failure to maintain directional control. Factors were the inadvertent porpoise of the airplane and the pilot's lack of total experience in the type airplane.NTSB BFO92LA098Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bally, PAThe pilot failed to maintain directional control during takeoff.NTSB ANC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Watana Lodge, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the pilot's failure to attain the proper touch down point, and the loose object (large rock) on the landing strip.NTSB SEA92LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAThe improper recovery from a bounced landing and the improper use of brakes by the CFI. A factor relating to the accident was the failure of the dual student to touchdown properly.