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 CEN14CA156Accident · No injuriesData collectionFinal reportOlson Kenneth H T Zodiac 601 HDS · Garrison, MNThe pilot's failure to maintain directional control during takeoff which resulted in the airplane striking a snow bank.NTSB ANC14CA018Accident · No injuriesData collectionFinal reportPiper PA 18 · Tanana, AKThe passenger inadvertently interfered with the rudder control pedal, which resulted in a loss of directional control during takeoff.NTSB ERA14CA140Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Mayaguez, PRThe pilot's loss of directional control of the airplane during landing, which resulted in a runway excursion.NTSB ERA14CA139Accident · No injuriesData collectionFinal reportPiper PA 11S · Marlboro, MAThe pilot's loss of directional control during the landing rollout in crosswinds, resulting in a runway excursion and subsequent impact with a snow bank.NTSB CEN14CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Adrian, TXThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the airplane ground looping.NTSB CEN14CA177Accident · No injuriesData collectionFinal reportCessna A185F · Fredericksburg, TXThe pilot did not maintain directional control of the airplane during the takeoff with a gusting crosswind.NTSB ERA14CA134Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Gulf Shores, ALThe student pilot's incorrect rudder input, which resulted in a ground loop and collision with a runway sign.NTSB ERA14LA149Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Alabaster, ALThe pilot’s delay in aborting the takeoff following the loss of directional control early in the takeoff roll due to a deflated left main landing gear tire.NTSB WPR14CA120Accident · No injuriesData collectionFinal reportPiper PA 16 · Scappoose, ORThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot's diverted attention and inadequate preflight inspection.NTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.NTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.NTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.NTSB CEN14CA152Accident · No injuriesData collectionFinal reportCessna 172R · Ellsworth, KSthe student pilot's failure to maintain directional control during landing.NTSB ERA14CA119Accident · No injuriesData collectionFinal reportPiper PA 38-112 · West Milford, NJThe failure of the pilot-in-command to maintain directional control during landing.NTSB CEN14LA138Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Marion, IAThe pilot’s failure to attain a touchdown on the runway’s hard surface, which resulted in a loss of directional control.NTSB ANC14CA015Accident · Minor injuriesData collectionFinal reportCraig C Walls Snowyriver Special · Wasilla, AKThe pilot's failure to maintain directional control after landing, resulting in a nose over.NTSB CEN14CA130Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 D · Worthington, MNThe pilot's loss of control during a crosswind landing.NTSB WPR14CA103Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · Renton, WAThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN14CA119Accident · No injuriesData collectionFinal reportPiper PA46 500TP · Tulsa, OKThe loss of directional control while landing due to the failure of the inner tube in the left tire.NTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.NTSB CEN14TA116Accident · Minor injuriesFinal reportAutogyro Mtosport · Spring, TXThe pilot’s failure to maintain the gyroplane’s rotor control during the landing roll in gusting crosswind conditions.NTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.NTSB WPR14CA090Accident · No injuriesData collectionFinal reportCessna 140 · Marana, AZThe pilot did not maintain directional control during the landing roll out when the right brake did not release completely after he applied, then released brake pressure, which resulted in a ground loop. Contributing to the accident was the taxi speed.NTSB CEN14CA098Accident · No injuriesData collectionFinal reportBell 206B · Temple, TXThe pilot's loss of control while landing on a mobile helipad.NTSB WPR14CA083Accident · No injuriesData collectionFinal reportCessna 195A · Salinas, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB CEN14CA096Accident · Minor injuriesData collectionFinal reportCessna 172K · Concordia, KSThe pilot's failure to maintain a proper glidepath during approach which resulted in the airplane landing long, and his decision to turn off of the runway during the landing roll which resulted in a collision with an earth berm.NTSB ERA14CA082Accident · No injuriesData collectionFinal reportCessna 182H · Littleton, NCThe pilot's failure to maintain directional control during takeoff.NTSB WPR14CA076Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Laural, MTThe pilot's failure to maintain directional control during takeoff with a gusting crosswind, which resulted in the collision with terrain. Contributing to the accident was the pilot's distraction when the door popped open.NTSB WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.NTSB WPR14CA073Accident · No injuriesData collectionFinal reportCessna A185F · Carson City, NVThe pilot's failure to maintain directional control during landing which resulted in the airplane veering off the runway and nosing over.NTSB CEN14LA089Accident · Minor injuriesLimited investigationFinal reportCessna 305C (0 1E) · Hondo, TXThe pilot's loss of directional control during an attempted go-around for reasons that could not be determined based on the available evidence. Contributing to the accident was the flight instructor’s and pilot’s decision to continue flight after experiencing…NTSB CEN14LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Oscoda, MIThe student pilot’s loss of control during landing in gusting wind conditions. Contributing to the accident was the pilot’s decision to land with gusting wind.NTSB WPR14CA064Accident · No injuriesData collectionFinal reportPiper PA 16 · San Carlos, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN14LA080Accident · No injuriesLimited investigationFinal reportPiper PA46 500TP · Albuquerque, NMThe pilot’s loss of directional control during landing due to his inadequate compensation for the tailwind.NTSB ERA14CA061Accident · Minor injuriesData collectionFinal reportAero Commander 680E · Crescent City, FLThe pilot's failure to maintain directional control during takeoff.NTSB ERA14CA055Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Tunica, MSThe student pilot's failure to maintain control of the helicopter during the attempted takeoff, and the flight instructor's inadequate supervision of the student pilot.NTSB ERA14LA071Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Monroe, NCThe pilot’s operation of the airplane with underinflated tires, which resulted in the right tire’s failure during takeoff and a subsequent runway excursion.NTSB CEN14CA070Accident · No injuriesData collectionFinal reportCessna 172 · New Orleans, LAThe pilot's failure to maintain aircraft control after starting the engine, which resulted in a collision with a building.NTSB ANC14CA009Accident · No injuriesData collectionFinal reportCessna A185F · Nenana, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrain.NTSB ERA14CA106Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB WPR14CA053Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe student pilot's failure to maintain directional control during the landing roll.NTSB ERA15WA034Accident · No injuriesForeign investigationBombardier CL 600 2B16 · Charallave, VenezuelaNTSB ERA14CA046Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Clewiston, FLThe student pilot's failure to maintain directional control during takeoff.NTSB WPR14LA050Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Carefree, AZThe failure of the left brake master cylinder seal, which rendered the left brake inoperative during landing.NTSB ERA14CA040Accident · No injuriesData collectionFinal reportBeech E 55 · Blountville, TNThe pilot's delayed reaction and loss of directional control while performing a simulated engine failure during the takeoff roll. A factor in the accident was the CFI's delayed reaction to the loss of directional control.NTSB ERA14CA039Accident · No injuriesData collectionFinal reportTaylorcraft BC 65 · Fallston, MDThe pilot's failure to maintain directional control during landing resulting in collision with equipment off the side of the runway. Contributing to the accident was the pilot's intentional landing on a closed runway with a tailwind.NTSB CEN14CA037Accident · No injuriesData collectionFinal reportRaytheon A36 · Hayden, COThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control and runway excursion.NTSB CEN14CA040Accident · No injuriesData collectionFinal reportCessna 182Q · Braggadocio, MOThe pilot's failure to maintain directional control during landing rollout, which resulted in a runway excursion and the airplane nosing over.NTSB ERA14CA033Accident · No injuriesData collectionFinal reportStinson SR 5A · Manassas, VAThe pilot's inadvertent application of only one brake during landing roll, resulting in a ground loop and runway excursion.NTSB WPR14CA035Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Twin Falls, IDThe pilot's loss of aircraft control during the rejected takeoff.