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 DEN90LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Edgemont, SDThe failure of the pilot to maintain directional control during the landing rollout.NTSB NYC90LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Marshfield, MAThe pilots failure to maintain directional control during an aborted landing. Factors related to the accident were: the pilots limited experienced in type of airplane, and variable winds.NTSB NYC90LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Blossvale, NYFailure of the pilot to maintain directional control during landing. Factors related to the accident were: a gusty quartering tailwind.NTSB NYC90LA089Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bridgeport, CTThe pilot failed to maintain directional control during a crosswind landing.NTSB BFO90LA035Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Frederick, MDThe pilot failed to maintain directional control, and used excessive braking trying to regain control.NTSB MKC90LA086Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Eden Prairie, MNDirectional control was not maintained by the pilot in command.NTSB ANC90LA057Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Bethel, AKPilot-in-command's failure to maintain control of the helicopter during touchdown.NTSB ANC90LA056Accident · No injuriesLimited investigationFinal reportBell 206B · Drift River, AKThe pilot failed to maintain control of the helicopter during lift-off.NTSB CHI90LA111Accident · No injuriesLimited investigationFinal reportCessna 172RG · Romeoville, ILThe failure of the instructor to correct a loss of directional control during a landing roll in a timely manner.NTSB ANC90FA053Accident · No injuriesField investigationFinal reportCessna 172-K · Anchorage, AKPilot-in-command used poor judgement when he elected to take off on rough & uneven frozen lake which resulted in a failed nose ski.NTSB LAX90LA140Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Auburn, CAPilot failed to attain the proper touch down point and the remedial action was improper. Contributing to this accident was that the pilot allowed the aircraft to porpoise during the landing rollout.NTSB NYC90LA085Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Hudson, NYThe pilots improper operation of the flight controls which resulted in the loss of control of directional control of the airplane during a touch and go landing. Factors related to the accident were the pilot's lack of total experience.NTSB CHI90LA110Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Lodge, ILFailure of the pilot to maintain directional control during takeoff. The crosswind and the soft/uneven terrain were factors related to the accident.NTSB CHI90LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Savanna, ILImproper planning/decision by the pilot. The strong/gusty crosswind was a related factor.NTSB ANC90FA052Accident · No injuriesField investigationFinal reportAeronca 11AC · Chugiak, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind and snow covered terrain beside the runway.NTSB ANC90FA051Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot lost directional control during the landing roll as a result of improper braking.NTSB NYC90DFJ02Accident · 1 fatalFinal reportRobbins Breezy CG-1 · Horseheads, NYThe loss of aircraft control during high speed taxi for an unknown reason.NTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.NTSB SEA90LA062Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hillsboro, ORPilot displayed poor starting procedures by proceeding with known deficiencies with the parking brake and the inadequacies of the tie down. The pilot did not attain assistance for this procedure which resulted in the airplane getting away and colliding with…NTSB SEA90LA061Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boise, IDPilot did not maintain directional control of the airplane during the landing roll.NTSB LAX90LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Rosa, CAFailure of the student pilot to maintain adequate control of the airplane during the takeoff roll.NTSB SEA90LA059Accident · No injuriesLimited investigationFinal reportStearman 4E · Burns, ORThe pilot's failure to maintain directional control.NTSB MIA90LA098Accident · Minor injuriesLimited investigationFinal reportWaco YMF-5 · Marathon, FLFailure of the pilot to maintain directional control during takeoff, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the pilot's excessive compensation for the wind condition, and his lack of experience in…NTSB ANC90LA050Accident · No injuriesLimited investigationFinal reportMaule M-4 · Anchorage, AKThe pilot's improper compensation for wind conditions and failure to maintain directional control. The unfavorable (variable) wind and snow covered terrain were related factors.NTSB MKC90LA077Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Minneapolis, MNFailure of the pilot to maintain directional control of the aircraft during the landing. The failed (flat) right main tire was a related factor.NTSB LAX90LA131Accident · No injuriesLimited investigationFinal reportCessna 172M · Groveland, CAThe pilot improperly used the flight controls during the landing roll-out.NTSB SEA90LA058Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Redmond, ORPilot did maintain directional control of the airplane during the takeoff ground run. The pilot was unable to adequately correct the situation before the airplane exited the runway and ground looped resulting in the collapse of the main landing gear.NTSB DEN90LA081Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6G · Grand Junction, COThe pilot's failure to correct a swerve during landing roll.NTSB MKC90LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Hyannis, NEFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and a subsequent nose over. Factors related to the accident were: the pilot's lack of experience in this aircraft, and the soft terrain.NTSB LAX90LA126Accident · No injuriesLimited investigationFinal reportCessna 180H · San Carlos, CAThe pilot's failure to maintain directional control of the aircraft during the landing.NTSB DEN90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T210J · Englewood, COThe pilot's loss of directional control during an aborted takeoff.NTSB SEA90LA055Accident · No injuriesLimited investigationFinal reportPiper PA18-160 · Reno, NVThe pilot failed to maintain directional control during landing roll.NTSB ANC90LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot failed to maintain directional control during landing. Contributing factors were the rough terrain, and the pilot's lack of total and recent experience in that model airplane.NTSB MKC90LA071Accident · No injuriesLimited investigationFinal reportCessna 185 · Minneapolis, MNAircraft control not maintained by the pilot in command. His lack of experience in the type of aircraft was a factor.NTSB CHI90LA100Accident · No injuriesLimited investigationFinal reportCessna 150B · Shelbyville, INThe private pilot's failure to maintain directional control of the aircraft during the landing. The crosswind was a related factor.NTSB MKC90LA073Accident · No injuriesLimited investigationFinal reportBeech B35 · Hartington, NEDirectional control not maintained by the pilot in command.NTSB ATL90LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Louisburg, NCThe pilot's failure to maintain directional control of the airplane during the take off roll.NTSB MKC90LA064Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Elaine, ARImproper planning/decision by the pilot and his failure to maintain directional control. Factors related to the accident were: the unfavorable weather conditions, runway condition, and the pilot's overconfidence in himself and the aircraft.NTSB DEN90LA061Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Englewood, COTo be a failure of the pilot to maintain directional control.NTSB LAX90LA114Accident · No injuriesLimited investigationFinal reportPiper J3 · Palo Alto, CAThe failure of the pilot to maintain directional control by not compensating for changing wind conditions.NTSB NYC90LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Glens Falls, NYPilot factor in that he lost directional control during takeoff and subsequently collided with a snowbank.NTSB CHI90LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Alpena, MIStudent pilot's failure to maintain positive directional control during the takeoff roll. The student pilot's lack of flight experience was a contributing factor in this accident.NTSB MKC90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Lonoke, ARFailure of the pilot to maintain directional control of the aircraft. His lack of experience in the type of aircraft was a related factor.NTSB ATL90LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Rockingham, NCPilot's failure to maintain directional control while attempting a landing.NTSB MKC90LA059Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · El Dorado, ARFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind.NTSB MKC90LA058Accident · No injuriesLimited investigationFinal reportCessna 195 · Garden City, KSDirectional control not maintained by the pilot in command.NTSB CHI90LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILPilot's inability to maintain directional control of the aircraft during the touchdown and landing roll phases of flight, due to deposits of slush frozen on the left landing gear brake.NTSB CHI90IA089Incident · No injuriesIncident investigationFinal reportFokker F-27-200 · Marquette, MIThe pilot-in-command's failure to maintain directional control of the aircraft during touchdown and rollout.NTSB SEA90LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's selection of unsuitable terrain. Factors related to the accident were: the runway conditions and the tree.NTSB CHI90IA090Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Cleveland, OHThe improper taxi speed to be able to negotiate a safe turn off the snow covered runway.