NTSB investigations
4,592 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 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 GAA15CA180Accident · No injuriesData collectionFinal reportPietenpol AIR Camper · Burlington, WIThe student pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.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 GAA15CA146Accident · No injuriesData collectionFinal reportCessna 150L · Huntsville, ALThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a porpoise, and firewall damage.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 GAA15CA139Accident · Minor injuriesData collectionFinal reportRandall W Grandpre CH-701 Zenith · Quincy, WAThe pilot's inadequate selection of a take-off area, resulting in a collision with obstacles and a loss of directional control.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 WPR15LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA 20 · Yellow Pine, IDThe pilot's delayed decision to go around after realizing that the airplane’s airspeed and altitude were too high, which resulted in an inadequate flare and bounced landing and a subsequent go-around in high-density altitude conditions.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 CEN15CA274Accident · No injuriesData collectionFinal reportEnstrom F 28C · Romeoville, ILThe certified flight instructor (CFI) did not maintain directional control during a downwind emergency running landing to soft muddy terrain, which resulted in a dynamic rollover. Contributing to the accident was the CFI's delayed or insufficient remedial…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 GAA15CA125Accident · No injuriesData collectionFinal reportCessna 180B · Waterloo, IAThe incorrect installation of the secondary seat stop reel which resulted in the pilot's loss of control when the seat moved full aft during takeoff.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 GAA15CA100Accident · No injuriesData collectionFinal reportCessna 305 · Richfield, UTThe pilot's loss of directional control during landing, which resulted in a ground loop.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 GAA15CA093Accident · No injuriesData collectionFinal reportRogers Homer/Rogers Sheila RV 6A · Lorain/Elyria, OHThe pilot's failure to maintain airplane attitude control during the landing flare, which resulted in an aerodynamic stall, hard landing, and runway excursion.NTSB GAA15CA086Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 200 · Glenwood, MNThe pilot's improper lateral/ bank level off during the landing flare, which resulted in the right wing impacting the water and a subsequent loss of control.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.