NTSB investigations
3,846 cases where the defining event was Loss of control on ground.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '230') 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 ANC08LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to maintain directional control during the landing flare/touchdown, which resulted in a runway excursion and collapse of the nose gear.NTSB ANC08LA093Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control during an aborted landing.NTSB LAX08CA257Accident · No injuriesData collectionFinal reportCessna 150M · Phoenix, AZThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB ANC08CA090Accident · No injuriesData collectionFinal reportCessna 180G · Anchorage, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was an inadvertent ground-loop.NTSB SEA08CA169Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Helena, MTThe failure of the pilot receiving instruction to adequately compensate for the crosswind condition and failure to maintain directional control. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB CHI08CA221Accident · Minor injuriesData collectionFinal reportCessna 150G · Grand Rapids, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the crosswind and wind gusts.NTSB CHI08CA207Accident · Minor injuriesData collectionFinal reportTuth RV-3 · Oshkosh, WIThe compensation for wind conditions disregarded by the pilot and the inadequate in-flight planning/decision making by the plot during approach to the destination airport. A contributing factor was the quartering tailwind.NTSB SEA08CA166Accident · No injuriesData collectionFinal reportCessna 180 · Lewistown, MTThe pilot's inadequate compensation for the variable and gusting winds, and his failure to maintain directional control. Contributing to the accident were variable winds that were gusting to 25 knots.NTSB LAX08CA232Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ogden, UTThe pilot's failure to maintain directional control of the airplane during landing.NTSB CHI08CA198Accident · No injuriesData collectionFinal reportRockwell S2R · Carthage, ILThe pilot failed to maintain directional control during the takeoff roll. Contributing to the accident were the uneven runway, the runway edge, and the cornfield.NTSB CHI08LA195Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Frankfort, KYThe student pilot's improper landing flare and the flight instructor's delayed remedial action.NTSB NYC08LA247Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Culpeper, VAThe pilot's failure to maintain directional control of the airplane while landing in a quartering tailwind.NTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.NTSB MIA08LA138Accident · 2 fatalLimited investigationFinal reportColyaer SL Freedom S100 · Limestone, ALThe pilot's loss of aircraft control for undetermined reasons while making a water landing.NTSB LAX08CA222Accident · No injuriesData collectionFinal reportCessna 172R · Byron, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX08CA243Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Canyon City, ORThe pilot's failure to maintain directional control. Contributing to the accident was the gusting tailwind.NTSB CHI08CA181Accident · No injuriesData collectionFinal reportBeech C23 · Schaumburg, ILThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Contributing to the accident were the gusting crosswind, and the embankment.NTSB CHI08CA187Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lake In The Hil, ILThe directional control not maintained/obtained by the pilot during landing.NTSB DFW08CA181Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Peyton, COLanding gear collapse during the landing roll for undetermined reasons.NTSB LAX08CA208Accident · No injuriesData collectionFinal reportPipistrel Virus 912 · Bend, ORThe pilot's improper flare, inadequate bounced landing recovery, and his failure to maintain directional control.NTSB NYC08CA233Accident · No injuriesData collectionFinal reportCessna T182T · Lincoln Park, NJThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the wet runway and hydroplaning conditions.NTSB LAX08CA218Accident · No injuriesData collectionFinal reportCessna 180G · Heber, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was the crosswind weather conditions.NTSB LAX08CA204Accident · No injuriesData collectionFinal reportAeronca 7DC · Elk River, IDThe pilot's failure to maintain directional control.NTSB LAX08CA207Accident · No injuriesData collectionFinal reportCessna T206H · Fullerton, CAThe pilot's failure to maintain control of the airplane during the landing touchdown, resulting in the wings contacting the runway surface and a propeller strike.NTSB DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.NTSB LAX08LA197Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Driggs, IDThe pilot's failure to maintain directional control during landing. Contributing to the accident was wind gusts.NTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.NTSB LAX08CA192Accident · No injuriesData collectionFinal reportCessna 172M · San Diego, CAThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB DEN08LA112Accident · No injuriesLimited investigationFinal reportCessna 195 · Houston, TXThe pilot's failure to maintain directional control, causing the design stress limits of the airplane to be exceeded. Excessive sideloads incurred caused the right main landing gear wheel and strut to fail.NTSB LAX08CA194Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Angwin, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB NYC08CA229Accident · No injuriesData collectionFinal reportPiper PA-18-105 · Fayetteville, NCThe pilot's failure to maintain directional control during the landing roll out.NTSB ANC08LA082Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Chugiak, AKThe flight instructor's lack of remedial action to maintain directional control of the airplane during the landing roll, which resulted in a collision with a berm. Contributing to the accident was the pilot's failure to maintain aircraft control, and his lack…NTSB SEA08CA153Accident · No injuriesData collectionFinal reportHammond MH1 · McCall, IDThe pilot's failure to maintain directional control during the landing roll, resulting in a inadvertent ground loop. Contributing to the accident were variable winds that resulted in a landing tailwind, and rough terrain.NTSB NYC08CA220Accident · No injuriesData collectionFinal reportCessna 172P · Lancaster, PAThe student pilot's failure to maintain directional control during the landing rollout.NTSB CHI08CA167Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Wadena, MNThe pilot's failure to maintain control of the tail wheel airplane during the landing roll. A factor associated with the accident was the pilot's lack of recent experience in tail wheel airplanes.NTSB LAX08CA180Accident · No injuriesData collectionFinal reportCessna 207 · Page, AZThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the crosswind weather conditions and the high density altitude conditions.NTSB LAX08CA169Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe student pilot's failure to maintain directional control during landing rollout.NTSB CHI08CA159Accident · No injuriesData collectionFinal reportCessna 172P · Athens, OHThe student pilot's failure to maintain directional control during landing. A factor contributing to the accident was a nose wheel vibration.NTSB MIA08CA112Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Roseboro, NCThe pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.NTSB DFW08CA159Accident · No injuriesData collectionFinal reportBeech E-18 · Guymon, OKThe pilot's failure to maintain directional control during landing roll out. Contributing to the accident was the crosswind.NTSB SEA08CA148Accident · No injuriesData collectionFinal reportAviat A-1B · Ogden, UTThe pilot's failure to maintain directional control during landing. A contributing factor was the variable wind condition.NTSB DEN08CA099Accident · No injuriesData collectionFinal reportPiper Seneca · Plaquemine, LAThe certified flight instructor's poor decision to simulate a loss of engine on takeoff with a wet runway and the pilot's failure to maintain directional control. Contributing to the accident was the dew covered runway surface and the ditch.NTSB NYC08CA203Accident · No injuriesData collectionFinal reportCessna 180 · Kutztown, PAThe pilot's failure to maintain aircraft control.NTSB CHI08CA142Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's failure to maintained directional control during the aborted landing. Contributing to the accident was the student pilot's total lack of experience in the type of airplane.NTSB LAX08CA158Accident · No injuriesData collectionFinal reportCessna T182T · Vandenberg, FLThe pilot's unstabilized approach and failure to maintain directional control during landing, which resulted in a veer off the runway.NTSB ANC08CA070Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was a gust of wind.NTSB CHI08CA149Accident · Serious injuriesData collectionFinal reportMischanko Buckeye Breeze · Walkerton, INThe directional control of the parachute not obtained/maintained by the pilot during the takeoff roll. A contributing factor was separation of the nose landing gear.NTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.NTSB DFW08CA156Accident · No injuriesData collectionFinal reportAyres S-2R · McDonald, KSThe pilot's failure to maintain aircraft control during the takeoff. Contributing to the accident was the soft terrain.