NTSB investigations
4,591 cases where the sequence of events included 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 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 DFW08CA174Accident · No injuriesData collectionFinal reportCessna 177 · Baldwin City, KSThe pilot's loss of directional control resulting from a hard landing and failure to recover from a bounced landing. Contributing to the accident was the crosswind.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 ANC08LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's failure to maintain directional control during the takeoff roll and liftoff, which resulted in a collision with trees and the ground.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 ANC08CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Anchorage, AKThe pilot's inadequate recovery from a bounced landing. Contributing to the accident was a crosswind.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.NTSB NYC08CA193Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control during takeoff. Contributing to the accident was a crosswind.NTSB LAX08CA156Accident · No injuriesData collectionFinal reportCessna 172P · Troutdale, ORThe student pilot's failure to maintain directional control, which resulted in collision with a runway light.NTSB NYC08CA191Accident · Minor injuriesData collectionFinal reportCessna 172M · Chuckey, TNThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was his failure to abort the takeoff.NTSB NYC08CA188Accident · No injuriesData collectionFinal reportPilatus PC-12 · Burnsville, NCThe pilot's failure to maintain directional control while landing. Contributing to the accident was the gusty wind conditions.NTSB CHI08CA138Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg. LC41-550FG · Columbus, OHThe pilot not maintaining directional control during the landing. Contributing to the accident were the gusty crosswinds and the airport sign that was impacted.NTSB LAX08CA148Accident · No injuriesData collectionFinal reportCessna 150H · Augusta, GAThe pilot's inadequate decision to taxi during thunderstorm activity and his failure to maintain aircraft control. Contributing to the accident were thunderstorms and wind gusts.NTSB DFW08CA151Accident · No injuriesData collectionFinal reportCessna CE-172M · San Antonio, TXThe student pilots improper short field landing procedure and excessive rate of descent. A contributing factor was the student pilots improper recovery from a bounced landing.NTSB CHI08CA148Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Delphi, INThe pilot's inadequate compensation for the gusting crosswind during landing rollout. Contributing to the accident was the gusting crosswind condition.NTSB ANC08CA069Accident · No injuriesData collectionFinal reportCessna 421 · Caldwell, NJThe pilot's failure to maintain directional control while landing. Factors in the accident were a hydroplaning condition, and a wet runway.NTSB ANC08CA068Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadequate compensation for a crosswind during landing. Contributing to the accident was the crosswind and an inadvertent ground loop.NTSB DFW08CA145Accident · No injuriesData collectionFinal reportWeatherly 201B · Nickerson, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB CHI08CA130Accident · No injuriesData collectionFinal reportCessna 150 · Pulaski, WIThe student pilot's failure to take remedial action in response to a porpoise/pilot-induced oscillation during landing. Factors were the porpoise, the pilot's lack of experience, and the separation of the nose landing gear.NTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.NTSB SEA08CA131Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Lakeview, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Contributing to the accident was the crosswind was a factor.NTSB SEA08CA132Accident · No injuriesData collectionFinal reportCessna 172 · Big Timber, MTThe student pilot's failure to maintain an adequate airspeed during landing which resulted in a stall.NTSB SEA08CA130Accident · No injuriesData collectionFinal reportBeech B19 · Burns, ORThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. The shifting wind was a factor.NTSB LAX08CA157Accident · No injuriesData collectionFinal reportPiper PA-34 · Blythe, CAThe pilot's failure to maintain directional control.NTSB ANC08CA064Accident · No injuriesData collectionFinal reportCessna 172 · Chugiak, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was an inadvertent ground loop/swerve.NTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.