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 CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.NTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.NTSB CEN12CA201Accident · No injuriesData collectionFinal reportJoy Vans RV-6 · McKinney, TXThe pilot did not maintain control of the airplane during takeoff, which resulted in a ground collision with airport construction materials.NTSB WPR12CA145Accident · No injuriesData collectionFinal reportRockwell International 690C · Conrad, MTThe pilot did not maintain directional control of the airplane due to ice and slushy snow on the runway during the landing roll.NTSB WPR12CA142Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jean, NVThe student pilot did not maintain directional control during the landing roll.NTSB ERA12CA245Accident · No injuriesData collectionFinal reportAeronca 7AC · Clearwater, FLThe pilot's failure to maintain airplane control during takeoff and the flight instructor's inadequate supervision, which resulted in a runway excursion.NTSB CEN12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Indianapolis, INThe student pilot did not maintain directional control while practicing a soft-field takeoff.NTSB ERA12CA235Accident · No injuriesData collectionFinal reportPiper J3C-65 · Douglas, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing to the accident was the pilot's lack of experience in the tailwheel-equipped airplane.NTSB CEN12CA193Accident · No injuriesData collectionFinal reportBellanca 17-30A · Branson, MOThe pilot did not maintain directional control of the airplane while landing with a gusting crosswind.NTSB CEN12CA190Accident · No injuriesData collectionFinal reportCessna A185F · Fort Worth, TXThe pilot did not maintain directional control of the airplane while landing in gusty wind conditions.NTSB ERA12FA225Accident · 5 fatalField investigationFinal reportCessna 501 · Franklin, NCThe pilot's failure to achieve a stabilized approach, resulting in a nose-first, bounced landing. Contributing to the accident was the pilot's activation of only one thrust reverser, resulting in asymmetrical thrust.NTSB ERA12CA232Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Dover, TNThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a collision with an object and a landing gear collapse during the subsequent landing.NTSB WPR12LA135Accident · Minor injuriesLimited investigationFinal reportCook Smith AVN Replica SU · St. Johns, AZThe pilots’ failure to maintain directional control when the right brake locked up during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12CA127Accident · No injuriesData collectionFinal reportCessna 172N · Kelso, WAThe pilot did not maintain directional control during the landing flare.NTSB ERA12CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Hollandale, MSThe pilot's failure to maintain directional control while taxiing in gusty wind conditions.NTSB ANC12IA024Incident · No injuriesIncident investigationFinal reportBombardier Learjet 35A · Anchorage, AKThe flightcrew's loss of visual reference to the runway after encountering severe in-flight icing conditions, which resulted in a loss of control while landing and exceedence of the capabilities of the airplane's windscreen anti-ice systems. Contributing to…NTSB WPR12LA122Accident · Serious injuriesLimited investigationFinal reportBowers Fly Baby 1-A · Fallbrook, CAThe pilot did not maintain directional control of the airplane during the takeoff roll.NTSB WPR12CA132Accident · No injuriesData collectionFinal reportCessna 170B · San Jose, CAThe pilot did not maintain directional control during the landing roll.NTSB ERA12CA220Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Beverly, MAThe pilot's loss of airplane control during takeoff, which resulted in a runway excursion.NTSB WPR12CA121Accident · No injuriesData collectionFinal reportSiai-Marchetti SF.260TP · Corona, CAThe pilot did not maintain runway alignment during landing in a gusting crosswind.NTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.NTSB ERA12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Americus, GAThe failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.NTSB CEN12LA168Accident · No injuriesLimited investigationFinal reportCessna 180H · Conroe, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed intervention and the pilot’s lack of experience in tailwheel airplanes.NTSB WPR12CA114Accident · No injuriesData collectionFinal reportAeronca 7BCM · Woodland, CAThe pilot did not maintain directional control during landing.NTSB CEN12LA176Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Bowling Green, OHThe pilot’s failure to maintain directional control during landing.NTSB ERA12CA189Accident · No injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe student pilot’s loss of directional control during a crosswind landing.NTSB CEN12CA160Accident · No injuriesData collectionFinal reportCessna 180 · South Fork, COThe pilot's loss of directional control while landing on a patchy snow-covered runway.NTSB WPR12CA112Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not maintain directional control while landing on a snow-contaminated runway.NTSB ERA12CA213Accident · No injuriesData collectionFinal reportZenair CH 2000 · Warrenton, VAThe student pilot's failure to follow instruction and to relinquish control of the airplane to the flight instructor in a timely manner, which resulted in a runway excursion.NTSB WPR12CA101Accident · No injuriesData collectionFinal reportLearjet 31A · Wheatland, WYThe flight crew’s loss of directional control during landing on an ice- and water-contaminated runway, which resulted in a runway excursion.NTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.NTSB CEN12CA159Accident · No injuriesData collectionFinal reportMaule MX-7-235 · Tea, SDThe pilot did not maintain directional control of the airplane during a crosswind landing.NTSB ERA12CA173Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Winter Haven, FLThe flight instructor’s delayed remedial action to prevent the airplane from hitting the hangar door. Contributing to the accident was the student pilot's misuse of the airplane's throttle, and his incorrect use of the wheel brakes.NTSB ERA12CA172Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Greenville, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.NTSB WPR12CA095Accident · No injuriesData collectionFinal reportAlon A2 · Forks, WAThe pilot's incorrect placement of the throttle prior to starting the airplane by hand. Contributing to the accident was that the pilot did not ensure that the airplane was restrained in a manner that would keep it from moving forward.NTSB CEN12FA151Accident · No injuriesField investigationFinal reportGates Lear Jet 35 · Pueblo, COThe captain's failure to maintain airplane control during an attempted crosswind takeoff on a contaminated runway.NTSB CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.NTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.NTSB ERA12CA167Accident · No injuriesData collectionFinal reportRemos G-3/600 · Sarasota, FLThe student pilot’s loss of directional control during the landing roll.NTSB WPR12CA083Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Santa Barbara, CAThe pilot did not maintain directional control during takeoff.NTSB WPR12CA082Accident · No injuriesData collectionFinal reportCessna 172P · Honolulu, HIThe student pilot’s improper landing flare and inadequate directional control while performing an aborted landing.NTSB WPR12CA079Accident · No injuriesData collectionFinal reportCessna 172M · Richland, WAThe student pilot's improper landing flare and inadequate directional control during landing.NTSB WPR12CA077Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · San Diego, CAThe pilot's inadequate directional control during the landing roll.NTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.NTSB WPR12LA074Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic WT9 · Glendale, AZThe pilot did not shut down the engine upon recognizing a brake malfunction. Contributing to the accident was the airplane's brake malfunction for undetermined reasons.NTSB CEN12LA129Accident · Minor injuriesLimited investigationFinal reportAviat A-1C-180 · Chetek, WIThe passenger’s interference with the flight controls, which resulted in the airplane’s failure to climb after an aborted landing. Contributing was the pilot's failure to maintain directional control during landing roll, which resulted in the need to abort…NTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.NTSB WPR12LA075Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ERA12CA134Accident · No injuriesData collectionFinal reportMaule M-5-180C · River Ranch, FLThe pilot’s failure to maintain directional control after encountering a wind gust during landing.