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 LAX08CA074Accident · Minor injuriesData collectionFinal reportCessna 172M · Richfield, UTThe pilot's improper use of the flight controls and failure to maintain directional control.NTSB DEN08CA063Accident · No injuriesData collectionFinal reportPiper PA-22 · Nickerson, KSthe pilot's failure to maintain directional control during the landing roll resulting in a departure from the runway environment. Contributing to the accident was the soft runway surface.NTSB SEA08CA086Accident · No injuriesData collectionFinal reportMaule M-4 · Jerome, IDThe failure of both pilots to maintain directional control of the airplane during takeoff.NTSB NYC08CA126Accident · No injuriesData collectionFinal reportMorrison Vans RV-8 · Port Orange, FLThe airplane's inadvertent encounter with a crosswind gust during the landing roll, which resulted in the pilot's loss of directional control.NTSB MIA08CA071Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Norwood, MAThe failure of the flightcrew to maintain directional control of the airplane.NTSB LAX08CA072Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Tucson, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB CHI08CA089Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Scribner, NEThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. A contributing factor was the crosswind.NTSB CHI08CA090Accident · No injuriesData collectionFinal reportCessna 172 · Apple River, ILThe pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. Contributing factors were a crosswind and a snow bank.NTSB MIA08CA069Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's failure to maintain directional control of the airplane during an aborted takeoff.NTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.NTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.NTSB DEN08LA061Accident · No injuriesLimited investigationFinal reportHardy Midget Mustang M-1 · Buena Vista, COThe pilot's failure to maintain directional control. Contributing to the accident was the gusty crosswind.NTSB NYC08CA125Accident · No injuriesData collectionFinal reportCessna 140 · Halls, TNThe flight instructor's inadequate remedial action. Contributing to the accident was the student pilot's failure to maintain directional control during the landing roll.NTSB NYC08CA108Accident · No injuriesData collectionFinal reportAviat A-1B · Winder, GAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the gusty crosswind condition.NTSB NYC08CA105Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll.NTSB LAX08CA062Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kalispell, MTThe pilot's failure to maintain alignment with the runway while landing and executing a go-around.NTSB LAX08CA061Accident · No injuriesData collectionFinal reportPiper PA-22 · El Cajon, CAThe failure of both pilots to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.NTSB MIA08CA061Accident · Minor injuriesData collectionFinal reportStephen F. Graves SG-3 · Fort Pierce, FLThe failure of the student to maintain directional control during a cross wind takeoff. A factor in the accident was inadequate supervision by the CFI.NTSB CHI08CA084Accident · No injuriesData collectionFinal reportCessna 150G · Viroqua, WIThe pilot not maintaining directional control during the landing and the ground loop the pilot encountered. A factor was the crosswind.NTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.NTSB SEA08CA076Accident · No injuriesData collectionFinal reportCessna 182 · Livermore, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing.NTSB SEA08CA074Accident · No injuriesData collectionFinal reportMaule M-7-235 · Red Lodge, MTThe pilot's inadequate compensation for the crosswind and failure to maintain directional control during the landing roll.NTSB NYC08CA095Accident · No injuriesData collectionFinal reportSonex Waiex · New Smyrna Bch., FLThe pilot's failure to maintain directional control during the takeoff. Contributing was the crosswind.NTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.NTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.NTSB ANC08CA034Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · McGrath, AKThe pilot's failure to maintain directional control of the airplane during an aborted takeoff.NTSB NYC08CA089Accident · No injuriesData collectionFinal reportCessna 210G · Bessemer, ALThe pilot's failure to properly secure the airplane before attempting to hand-prop the engine.NTSB NYC08CA094Accident · Minor injuriesData collectionFinal reportPiper J3-C65 · Hollywood, FLThe pilot's failure to maintain directional control while landing. Contributing was the gusty crosswind condition.NTSB MIA08CA047Accident · No injuriesData collectionFinal reportCessna 150J · Dawson, GAThe pilot's failure to maintain directional control during landing roll out.NTSB SEA08LA067Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Hollister, CAThe dual student's failure to maintain aircraft control while taxiing from the active runway and the delayed remedial action by the flight instructor. A contributing factor was the unfavorable high wind condition.NTSB CHI08CA069Accident · No injuriesData collectionFinal reportCessna 172N · South St. Paul, MNThe student pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident were the snow-covered runway and the gusty wind conditions.NTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.NTSB LAX08CA048Accident · Minor injuriesData collectionFinal reportWaltermire Glastar · Vacaville, CAThe pilot's failure to maintain directional control during landing and a lack of experience in conventional gear airplanes.NTSB DEN08CA051Accident · No injuriesData collectionFinal reportPiper PA-32-301XTC · Taos, NMThe pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.NTSB DFW08CA072Accident · No injuriesData collectionFinal reportBeech 58P · Hereford, TXThe pilot's loss of control on landing. A factor was a gusting crosswind component.NTSB MIA08CA042Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Atlanta, GAThe failure of the pilot-in-command to maintain directional control of the airplane during landing.NTSB DEN08LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Pine Bluffs, WYThe pilot's failure to maintain control of the airplane. Contributing factors in this accident were the unfavorable wind and the snow bank.NTSB LAX08CA044Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Exeter, CAThe pilot's failure to maintain directional control.NTSB MIA08CA037Accident · No injuriesData collectionFinal reportCessna 170A · Ellsworth, METhe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's selection of an unsuitable landing area.NTSB CHI08CA062Accident · Minor injuriesData collectionFinal reportMcGuire RAF2000 · Valparaiso, INThe pilot's inadequate compensation for wind conditions during the landing roll. A factor was the gusting crosswind.NTSB DFW08CA054Accident · No injuriesData collectionFinal reportMicco MAC-145B · Arcola, TXThe pilot's failure to maintain directional control. A contributing factor was the prevailing crosswind.