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 GAA16CA303Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Nicolaus, CAThe pilot's insufficient clearance from a power line during aerial application operations, which resulted in a power line strike, a forced landing on unsuitable terrain, loss of directional control, and collision with terrain.NTSB GAA16CA274Accident · Minor injuriesData collectionFinal reportKoons Donald H Cygnet · Zanesville, OHThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, and a nose over.NTSB GAA16CA270Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Mack, COThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, impact with a ditch, and nose over.NTSB CEN16LA202Accident · No injuriesLimited investigationFinal reportHarry Oas Pitts S1C · Carlsbad, NMThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB GAA16CA269Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Midland, TXThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a ground-loop, main landing gear collapse and collision with terrain.NTSB GAA16CA528Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Jacksonville, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA16CA311Accident · Minor injuriesData collectionFinal reportChampion Aeronca 7AC · Groveland, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and a collision with a concrete barrier wall.NTSB GAA16CA287Accident · No injuriesData collectionFinal reportPiper PA 18 · Palmer, AKThe pilot's incorrect brake application during the landing roll, which resulted in a nose over.NTSB WPR16CA121Accident · Serious injuriesData collectionFinal reportChampion 7ECA · Brookings, ORThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA16CA260Accident · No injuriesData collectionFinal reportCessna A185 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA16CA262Accident · No injuriesData collectionFinal reportPiper PA 18A · Westminster, MDThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with terrain.NTSB GAA16CA249Accident · No injuriesData collectionFinal reportBoeing B75 · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and nose over.NTSB GAA16CA257Accident · No injuriesData collectionFinal reportAeronca 11AC · Vinton, IAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and ground loop.NTSB GAA16CA248Accident · No injuriesData collectionFinal reportLuscombe 8 · Blue Bell, PAThe pilot's failure to maintain directional control during the takeoff roll and the flight instructor's delayed remedial action, which resulted in runway excursion, and collision with a ditch.NTSB GAA16CA247Accident · No injuriesData collectionFinal reportCessna 182 · Redding, CAThe student pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and nose over.NTSB ERA16LA192Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Batavia, NYThe student pilot's failure to maintain directional control during takeoff, which resulted in a collision with runway signs.NTSB GAA16CA245Accident · No injuriesData collectionFinal reportCessna 172 · Carbondale, ILThe student pilot's inadequate flare which resulted in a hard landing, loss of directional control, and a runway excursion.NTSB CEN16TA194Accident · No injuriesFinal reportNorth American AT6 · Mason, MIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and impact with a ditch.NTSB GAA16CA242Accident · Minor injuriesData collectionFinal reportVan B Anthony Zodiac · Grass Valley, CAThe pilot's failure to maintain a stabilized approach and landing, which resulted in a hard landing, loss of directional control, runway excursion, and collision with a parked airplane.NTSB CEN16LA192Accident · No injuriesLimited investigationFinal reportCessna T206H · New Roads, LAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA16CA233Accident · No injuriesData collectionFinal reportCessna 180 · St. George, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, ground loop, right main landing gear collapse, and substantial damage to the right wing.NTSB GAA16CA240Accident · No injuriesData collectionFinal reportMills Gregory T AIR Commander LRT · Tybee Island, GAThe pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.NTSB ANC16CA027Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during landing, which resulted in a collision with terrain. Contributing to the accident was the loose dirt and gravel deposited in the center of the runway.NTSB WPR16LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NVThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion.NTSB WPR16LA108Accident · Minor injuriesLimited investigationFinal reportCessna 180 · California City, CAA directional upset on landing due to a thermally induced atmospheric disturbance, which the pilot was unable to successfully counter due to improperly set rudder travel limits.NTSB GAA16CA243Accident · No injuriesData collectionFinal reportPiper PA-28 · Crystal River, FLThe student pilot's failure to maintain directional control during the takeoff, which resulted in runway excursion and collision with a ditch. Contributing to the accident was the improper flap retraction procedure employed by the pilot during takeoff.NTSB GAA16CA238Accident · No injuriesData collectionFinal reportWaco YKS 7 · Millersburg, OHThe pilot's loss of directional control during landing in gusting wind conditions resulting in excessive brake application, and airplane nose over.NTSB ERA16LA183Accident · No injuriesLimited investigationFinal reportPiper PA 22 · Gallatin, TNThe pilot's inadequate preflight inspection, which resulted in an inflight fire due to the presence of a bird nest in the engine compartment.NTSB GAA16CA236Accident · No injuriesData collectionFinal reportPiper PA 28R · Lee's Summit, MOThe pilot's improper pitch control after the landing flare, resulting in an aerodynamic stall, hard landing, and consequent substantial left wing damage.NTSB CEN16LA178Accident · No injuriesLimited investigationFinal reportMooney M20K · Akron, OHA missing bolt in the nose landing gear assembly, which resulted in the airplane suddenly turning left and the pilot's inability to maintain directional control during a crosswind takeoff.NTSB GAA16CA224Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Oberlin, KSThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and a ground loop.NTSB GAA16CA220Accident · No injuriesData collectionFinal reportCessna 172 · Richmond, KYThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with tree(s).NTSB GAA16CA216Accident · No injuriesData collectionFinal reportAirborne Redback · Arlington, WAThe pilot's failure to adequately secure the aircraft while manually starting the engine from outside the cockpit, which resulted in the unmanned aircraft becoming airborne and colliding with a hangar roof.NTSB GAA16CA214Accident · No injuriesData collectionFinal reportRockwell International 112TC · Durango, COThe instructed pilot's interference with the flight controls during landing, which resulted in the flight instructor's inability to maintain directional control, resulting in a runway excursion and substantial damage to the firewall and left wing spar.NTSB CEN16LA173Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Iowa, LAThe pilot's failure to maintain directional control while landing with an inoperative right brake.NTSB GAA16CA225Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Harlingen, TXThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop and substantial damage to the right wing.NTSB GAA16CA215Accident · No injuriesData collectionFinal reportCessna 172 · Boise, IDThe pilot's decision to land with a quartering tailwind and failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground loop.NTSB ERA16LA174Accident · No injuriesLimited investigationFinal reportAmerican Champion 7AC · Keene, NHThe disengagement of the tailwheel locking mechanism during the landing roll due to wear, and a subsequent loss of directional control. Contributing was the pilot's inadequate remedial action, which resulted in a runway excursion.NTSB ERA16LA173Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108 · Calverton, NYThe pilot's failure to maintain directional control during the landing roll.NTSB GAA16CA203Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Maryville, MOThe pilot's unintentional brake application during the landing roll, which resulted in a nose over.NTSB GAA16CA200Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Madison, KSThe pilot's incorrect brake application during the landing roll, which resulted in a nose over.NTSB GAA16CA210Accident · Minor injuriesData collectionFinal reportPiper PA18S · Talkeetna, AKThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose over.NTSB ERA16LA181Accident · No injuriesLimited investigationFinal reportMaule M 7-235B · Littleton, NCThe pilot's improper landing flare, which resulted in a hard landing and subsequent damage to the left float.NTSB GAA16CA239Accident · No injuriesData collectionFinal reportLogan Jerry L GN 1 Aircamper · Defuniak Springs, FLThe pilot's loss of directional control during the landing in gusting crosswind conditions resulting in a runway excursion, and the pilot's failure to attain a positive climb rate during the aborted landing and subsequent ground collision.NTSB GAA16CA197Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Ramona, CAThe pilot's failure to maintain directional control during takeoff in variable wind conditions.NTSB ERA16CA178Accident · No injuriesData collectionFinal reportChampion 7AC · Jasper, ALThe pilot's inadequate compensation for the wind which resulted in a loss of directional control at touchdown and collapse of the landing gear.NTSB GAA16CA251Accident · No injuriesData collectionFinal reportCirrus SR22 · Church Hill, MDThe pilot's decision to land on an unlighted grass airstrip at night, resulting in landing long, a loss of directional control, and collapsed landing gear producing substantial damage to the landing gear attachment point and left wing.NTSB GAA16CA193Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Burlington, WAThe pilot's excessive application of the brakes during the landing roll, resulting in a loss of directional control, runway excursion, and ground loop.NTSB GAA16CA195Accident · Minor injuriesData collectionFinal reportGary A Jamieson JA30 Superstol · Palmer, AKThe pilot's failure to maintain pitch control of the airplane during the landing touchdown, which resulted in a nose over.NTSB GAA16CA194Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and collision with a runway distance remaining sign.