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 ANC15CA053Accident · No injuriesData collectionFinal reportCessna U206F · Kasilof, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a jammed elevator and subsequent loss of control and collision with terrain.NTSB GAA15CA193Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Oxford, IAThe pilot's selection of unsuitable terrain for takeoff based on the runway and density altitude conditions, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA192Accident · No injuriesData collectionFinal reportCessna R172K · Fairfield, NCThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with terrain.NTSB GAA15CA189Accident · No injuriesData collectionFinal reportCessna 182Q · Hanksville, UTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with terrain.NTSB GAA15CA207Accident · No injuriesData collectionFinal reportCessna 170B · Rosamond, CAThe pilot's failure to maintain directional control during the takeoff roll, resulting in a collision with terrain.NTSB WPR15LA218Accident · No injuriesLimited investigationFinal reportDafoe Gerald W Tcow Smith CUB · Cascade, IDA gouge in the right brake master cylinder piston O-ring, which resulted in a loss of brake pressure and reduced effectiveness after landing. Contributing to the accident was the pilot’s decision to operate the airplane with an ongoing brake issue.NTSB GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.NTSB GAA15CA185Accident · No injuriesData collectionFinal reportBarron Starduster SA 300 · Whiteville, NCThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.NTSB CEN15CA304Accident · No injuriesData collectionFinal reportCessna 340 · South St. Paul, MNThe airplane's inability to takeoff for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies. The aborted takeoff resulted in a runway overrun and impact with a fence.NTSB GAA15CA213Accident · No injuriesData collectionFinal reportCessna A185F · Dauphin Island, ALThe pilot's loss of directional control during the landing roll in gusty wind conditions which resulted in a ground loop and impact with terrain.NTSB ERA15LA268Accident · No injuriesLimited investigationFinal reportCessna 170 · Buffalo, NYThe pilot’s failure to maintain directional control of the airplane during the landing with a light quartering tailwind, which resulted in the failure of the landing gear and a subsequent ground loop.NTSB WPR15WA225Incident · No injuriesForeign investigationBoeing 737-800 · TamuningOn July 5, 2015, about 0210 local time, a Boeing 737-800, HL8224, Korean Airlines Flight 2115, had a runway excursion at A. B. Won Pat Guam International Airport. Tamuning, Guam. Korean Airlines was operating the airplane under the provisions of the Korean…NTSB GAA15CA182Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Llano, TXThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.NTSB GAA15CA168Accident · No injuriesData collectionFinal reportCessna A188B · Saratoga, WYThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion, and a ground loop.NTSB GAA15CA183Accident · No injuriesData collectionFinal reportCessna 180 · Cahokia, ILThe pilot's failure to maintain directional control during the landing roll which resulted in a ground loop.NTSB GAA15CA150Accident · Minor injuriesData collectionFinal reportCessna TR182 · Rio Vista, CAThe pilot's use of improper procedures during an aborted landing, resulting in a runway excursion and a collision with a canal.NTSB GAA15CA158Accident · No injuriesData collectionFinal reportCessna 337 · Blanding, UTThe pilot's selection of a departure runway of inadequate length for the density altitude, resulting in the airplane not gaining sufficient lift, departing the runway, and impacting terrain.NTSB GAA15CA144Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Williston, NDThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with runway marking signs.NTSB ANC15CA042Accident · No injuriesData collectionFinal reportCessna U206G · Anchorage, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control.NTSB GAA15CA166Accident · No injuriesData collectionFinal reportBryan Jerry R CH750 · Gainesville, MOThe pilot's perception that the airplane was not climbing normally, which precipitated an aborted landing with insufficient runway remaining to stop the airplane safely.NTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.NTSB GAA15CA155Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Salisbury, MDThe student pilot's loss of directional control during the landing roll, resulting in a runway excursion and collision with terrain.NTSB GAA15CA152Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Edna, TXThe pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and collision with a fence.NTSB WPR15LA198Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Schafers Meadows, MTThe pilot's failure to maintain directional control of the airplane during the landing roll in variable and gusting wind conditions.NTSB GAA15CA134Accident · No injuriesData collectionFinal reportQuicksilver MX · Nampa, IDThe student pilot's failure to maintain directional control during the takeoff roll, resulting in a runway excursion, and a collision with terrain.NTSB GAA15CA169Accident · No injuriesData collectionFinal reportWeatherly 201B · Pemberton, NJThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane's left main landing gear impacting an unknown object, and subsequent collapse during landing.NTSB GAA15CA132Accident · Minor injuriesData collectionFinal reportErvin Rex H Bear Hawk · Merrill, ORThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA15CA302Accident · No injuriesData collectionFinal reportAviat A · Grants Pass, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA15CA127Accident · No injuriesData collectionFinal reportPaquin Michael A A · Concord, NHThe pilot's inability to maintain directional control during takeoff, which resulted in a roll over. Contributing to the loss of control was the pilot's failure to disengage the main rotor brake prior to takeoff.NTSB WPR15LA186Accident · Serious injuriesLimited investigationFinal reportRockwell International S 2R · Washtucna, WAThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB GAA15CA120Accident · No injuriesData collectionFinal reportBeech RC 45J · Everett, WAThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with a sign.NTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.NTSB GAA15CA113Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Bakersfield, CAThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with terrain.NTSB GAA15CA112Accident · No injuriesData collectionFinal reportCessna 180 · Vichey, MOThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB ANC15CA038Accident · No injuriesData collectionFinal reportMaule M 7-235B · Talkeetna, AKThe pilot's loss of directional control during landing, resulting in a collision with terrain.NTSB GAA15CA118Accident · No injuriesData collectionFinal reportCessna 195 · Lancaster, NYA loss of directional control and subsequent ground loop due to an underinflated right tire, which was a result of foreign object debris puncturing the tire.NTSB WPR15CA173Accident · No injuriesData collectionFinal reportCessna T188C · Ismay, MTThe pilot's incorrect action to continue the takeoff when he failed to maintain directional control during the takeoff roll.NTSB GAA15CA115Accident · Minor injuriesData collectionFinal reportSmiley James E RAG Wing RW-6 · Mocksville, NCThe pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with a building.NTSB GAA15CA104Accident · No injuriesData collectionFinal reportCessna 150F · Harlingen, TXThe student pilot's failure to maintain directional control while landing with a crosswind.NTSB ERA15LA224Accident · No injuriesLimited investigationFinal reportCessna 337 · Melbourne, FLThe pilot’s failure to maintain directional control while taxiing as a result of his impairment due to alcohol ingestion.NTSB CEN15LA250Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe pilot's loss of directional control to the right for reasons that could not be determined during examination of the right main landing gear wheel and brake drum.NTSB GAA15CA095Accident · No injuriesData collectionFinal reportCessna 182Q · Honesdale, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane.NTSB GAA15CA084Accident · No injuriesData collectionFinal reportFaunce PA-11 · Morrisville, VTThe pilot's failure to maintain directional control during the landing roll and his deliberate application of excessive braking pressure.NTSB GAA15CA082Accident · Minor injuriesData collectionFinal reportBoeing PT 17 · Williamson, GAThe pilot landed off the right side of the runway resulting in a collision with terrain.NTSB ANC15CA028Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Seward, AKThe pilot's excessive braking during landing, which resulted in a nose over.NTSB GAA15CA079Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Princeton, NJThe pilot's failure to maintain directional control during the landing, resulting in a runway excursion.NTSB GAA15CA078Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA4-200 · Mineral, VAThe pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.NTSB GAA15CA074Accident · No injuriesData collectionFinal reportMaule MX 7-180C · Sharps Chapel, TNCollision with an obstacle during the landing roll, which resulted in a loss of control and subsequent runway excursion and tree strike.NTSB ANC15CA025Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Anchorage, AKThe pilot's excessive use of brakes to maintain directional control, which resulted in a nose over.NTSB GAA15CA076Accident · No injuriesData collectionFinal reportCessna 170B · Bentonville, ARThe flight instructor's failure to maintain directional control, which resulted in a ground loop on takeoff.