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 ANC91LA002Accident · No injuriesLimited investigationFinal reportCessna 185B · Koyuktolik, AKPilot-in-command's failure to properly execute a stabilized approach to the first 1/3 of the runway. Contributing to the accident was the excessive airpseed maintained during the approach and landing.NTSB DEN91LA004Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Englewood, COThe pilot's inadequate preflight inspection.NTSB BFO91LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Westminster, MDThe pilot's failure to maintain positive directional control during the landing. Improper crosswind compensation and a variable, gusty crosswind were contributing factors.NTSB CHI91LA004Accident · No injuriesLimited investigationFinal reportBeech E-18 · Minneapolis, MNFailure of the pilot-in-command to maintain directional control of the aircraft during landing roll.NTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.NTSB ATL90LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe student pilot's selection of the wrong runway and the subsequent loss of directional control during takeoff. The pilot's improper usage of flight controls, presence of crosswind conditions, and his overall lack of experience were factors in the accident.NTSB ATL90LA180Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Fayetteville, TNThe pilot's premature flare which resulted in a loss of directional control at touchdown.NTSB ANC90FA187Accident · No injuriesField investigationFinal reportPiper PA-18A · Birchwood, AKThe pilot-in-command's failure to correctly analyze the wind and its effect on the airplane during the landing; thereby failing to maintain proper directional control.NTSB LAX90LA342Accident · No injuriesLimited investigationFinal reportPiper J-3C-115 · Wickenburg, AZThe pilot's failure to maintain directional control.NTSB BFO90LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Maryville, KYThe failure of a hydraulic brake line which resulted in a loss of fluid, and an inoperative brake system during landing roll.NTSB SEA90LA196Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Twin Falls, IDThe pilot's inability to maintain directional control during a takeoff in strong crosswind conditions.NTSB MIA90LA188Accident · No injuriesLimited investigationFinal reportCessna 150M · Florida City, FLLoss of control during the take off roll from the dirt road followed by an on ground collision with shrubs.NTSB MIA90LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · Pompano Beach, FLThe failure of the pilot to initiate a go-around due to being high on final approach and as a result, failure to attain the correct point of touchdown and his excessive application of brakes which resulted in failure of the right main tire and loss of…NTSB FTW90LA184Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Fort Worth, TXThe pilot in command's failure to maintain directional control. The crosswind was a factor.NTSB SEA90LA193Accident · No injuriesLimited investigationFinal reportCessna 170 · Havre, MTThe selection of the wrong runway by the owner/student pilot and his failure to compensate for the wind during landing ground roll.NTSB DEN90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Marietta, OKThe loss of directional control by the pilot. The selection of unsuitable terrain is a factor.NTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.NTSB LAX90LA323Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Montague, CAThe pilot's failure to maintain directional control during landing rollout. A contributing factor was the student pilot's lack of experience performing landings.NTSB ANC90LA176Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Heiden, AKThe pilot-in-command's failure to maintain aircraft control during a strong crosswind.NTSB FTW90LA180Accident · No injuriesLimited investigationFinal reportMooney M-10 · Roscoe, TXThe pilot's loss of directional control. A factor was: rough/uneven terrain.NTSB ANC90LA171Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot-in-command's failure to maintain directional control of the airplane during the takeoff roll. The rough/uneven gravel bar was a related factor.NTSB SEA90LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Dillon, MTPilot misjudged the flare that resulted in a bounced landing.NTSB DEN90DTE08Accident · No injuriesFinal reportPiper PA-25-235 · Idalia, COThe encounter with an unfavorable wind, a dust devil. A factor was the inability of the pilot to maintain directional control.NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.NTSB SEA90LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Lummi Island, WAThe pilot's failure to maintain directional control while applying brakes after landing.NTSB ANC90LA169Accident · No injuriesLimited investigationFinal reportBeech H-18S · Deering, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB NYC90LA207Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTThe pilot lost control of the airplane during a cross wind landing, subsequently running off the side of the runway and collided with the terrain.NTSB FTW90FA170Accident · No injuriesField investigationFinal reportAir & Space 18A · Shreveport, LAFailure of the pilot in command to follow published takeoff procedures.NTSB CHI90LA248Accident · No injuriesLimited investigationFinal reportCessna 172G · Bloomington, INThe pilot's failure to compensate for wind conditions and maintain directional control. The crosswind was a factor.NTSB ANC90LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.NTSB NYC90LA201Accident · No injuriesLimited investigationFinal reportCessna 150 · Circleville, OHThe misuse of the flight controls by the pilot and improper bounced landing recovery procedure.NTSB DEN90LA179Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeview, ARThe pilot's failure to maintain alignment during landing.NTSB LAX90LA299Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Petaluma, CAThe pilot's failure to maintain directional control.NTSB ANC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kodiak, AKThe pilot-in-command's failure to maintain directional control and failure to maintain airplane control on landing.NTSB FTW90LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Joseph, LAThe pilot's failure to maintain directional control and his use of excessive braking.NTSB ANC90LA152Accident · No injuriesLimited investigationFinal reportCessna 185 · Nenana, AKThe pilot's poor judgement, due to consumption of alcohol, and his failure to maintain directional control of the aircraft during the takeoff run.NTSB LAX90LA297Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Chico, CAThe student pilot failed to maintain directional control during landing roll and the CFI failed to take remedial action.NTSB LAX90LA294Accident · No injuriesLimited investigationFinal reportCessna 180H · San Carlos, CAThe pilot's failure to maintain directional control of the aircraft during the landing. Contributing to the accident was the pilot's lack of total experience in tailwheel aircraft.NTSB NYC90LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Norfolk, MAThe pilot in command's failure to maintain airspeed during an aborted landing resulting in an inadvertent stall and descent into trees.NTSB ATL90LA160Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrencevile, GAThe pilot's failure to maintain directional control during the landing roll.NTSB LAX90LA291Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Weaverville, CAThe pilot's failure to maintain directional control of the aircraft. The existing wind conditions and the ditch that was located near the runway were factors in the accident.NTSB CHI90DCA02Accident · No injuriesFinal reportFisher Flying Products Classic BI Plane · Memphis, MOThe failure of the pilot to maintain directional control of the airplane during the landing roll. The pilot's lack of total aviation experience was a related factor.NTSB ANC90LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Igiugig, AKThe pilot-in-command's failure to maintain directional control on landing. Contributing to the accident was unsuitable terrain selected by the pilot for landing.NTSB NYC90LA194Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Burdett, NYThe pilot did not properly compensate for the cross wind and failed to maintain directional control during takeoff.NTSB CHI90LA230Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hawley, MNThe failure of the PIC to retain control of the airplane during the landing sequence.NTSB ANC90LA141Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gustavus, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC90LA150Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Ivishak River, AKPilot lost directional control during landing. Contributing to the accident was the pilot's delayed attempt to go-around.NTSB ANC90LA133Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Tetlin, AKThe pilot's failure to mountain directional control during the landing roll.NTSB NYC90LA186Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Mt. Bethel, PAThe pilot failed to maintain directional control of the airplane. Factors were wet grass and poor braking action.