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 WPR20CA214Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18A-135 · Marion, MTThe pilot's failure to maintain directional control of the airplane while landing in gusting wind conditions, which resulted in a runway excursion and collision with a fence.NTSB WPR20LA226Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75 · Chino, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC20LA065Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Anchorage, AKThe failure of the left float bottom due to corrosion, which resulted in a loss of control during the water landing.NTSB ERA20CA254Accident · No injuriesClass 4 · Data collectionFinal reportLockwood Aircam · Ooltewah, TNThe pilot's failure to maintain directional control during landing.NTSB WPR20CA204Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · San Diego, CAThe pilot's failure to maintain airplane control during landing with a crosswind and excessive braking action, which resulted in the airplane nosing over.NTSB ERA20CA239Accident · No injuriesClass 4 · Data collectionFinal reportBeech 76 · Crystal River, FLThe flight instructor's delayed remedial action during a simulated engine failure on takeoff, which resulted in a loss of directional control.NTSB ERA20CA236Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Meadville, PAThe pilot's distraction while taxiing, which resulted in a taxiway excursion.NTSB CEN20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA18A-150 · Brainerd, MNThe pilot's decision to land on a shortened field and his incorrect brake application. Contributing was the flight instructor's lack of oversight.NTSB WPR20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV-8 · McMinnville, ORThe pilot's failure to maintain directional control during takeoff which resulted in a collision with a runway marker.NTSB ERA20CA233Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 8 · Perkasie, PAThe pilot’s loss of directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and collision with a ditch.NTSB ANC20CA062Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCK-1865 · Juneau, AKThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB CEN20CA247Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CC19-180 · Fredericksburg, TXThe pilot's failure to maintain directional control during the landing roll. The pilot being fatigued likely contributed to his failure to maintain directional control during the landing roll.NTSB WPR20CA231Accident · No injuriesClass 4 · Data collectionFinal reportChad Lewis Kitfox Super Sport · St Anthony, IDThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion, contact with the airport perimeter fence, and subsequent nose over.NTSB ERA20CA224Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Burlington, VTThe pilot’s failure to maintain directional control during landing roll in crosswind conditions.NTSB CEN20CA238Accident · No injuriesClass 4 · Data collectionFinal reportGreat Lakes 2T 1A · Cambridge, OHThe pilot’s failure to maintain directional control during landing, which resulted in the airplane exiting the runway and striking a ditch.NTSB CEN20CA235Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCX-2000-0086 · Gypsom, COThe pilot's failure to maintain airplane control during landing in gusting wind conditions.NTSB CEN20CA233Accident · No injuriesClass 4 · Data collectionFinal reportPiper J3C-65 · Mount Victory, OHThe pilot's inadequate planning, and his failure to secure the airplane prior to hand-starting the engine.NTSB ERA20LA230Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Williston, FLThe pilot’s failure to maintain directional control while landing with a crosswind, which resulted in a runway excursion and nose landing gear collapse.NTSB ERA20CA214Accident · No injuriesClass 4 · Data collectionFinal reportWaco YMF F5C · Ghent, NYA loss of directional control on takeoff, which resulted in a runway excursion and collision with trees.NTSB WPR20WA264Accident · No injuriesForeign investigationAir Tractor AT802A · Karubaga, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a AIR TRACTOR AT802A airplane that occurred on June 09, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB WPR20CA178Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Santa Barbara, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a fence.NTSB CEN20CA222Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 15 · Lancaster, TXThe pilot's failure to maintain directional control during landing.NTSB WPR20CA181Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20J · Healdsburg, CAThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a landing gear collapse.NTSB WPR20LA175Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman G164 · Lincoln, CAThe pilot’s loss of directional control on takeoff for undetermined reasons.NTSB WPR20CA168Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Yakima, WAThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in a ground loop, runway excursion, and subsequent nose over.NTSB CEN20CA242Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Castroville, TXThe pilot's failure to maintain directional control during landing.NTSB CEN20CA218Accident · No injuriesClass 4 · Data collectionFinal reportGlasflugel Mosquito · Alvarado, TXThe pilot's decision to divert to the private airport and his subsequent failure to maintain directional control while landing on a turf runway that contained tall grass.NTSB WPR20CA164Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Sandia, TXThe pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.NTSB CEN20WA398Accident · No injuriesForeign investigationCessna U206 · Tallard, FranceThe government of France has notified the NTSB of an accident involving a Cessna U206 airplane that occurred on June 2, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB CEN20CA204Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Denver, COThe pilot’s failure to maintain directional control while landing during variable wind conditions.NTSB CEN20CA206Accident · No injuriesClass 4 · Data collectionFinal reportZenair CH601 · Worthington, MNThe pilot's excessive brake application during the landing roll to avoid an animal on the runway, which resulted in a ground loop.NTSB CEN20CA205Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Lakeview, ARThe pilot’s failure to maintain control of the airplane during the takeoff.NTSB CEN20CA202Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Arlington, TXThe pilot's failure to maintain airplane directional control during a gusty crosswind landing.NTSB ERA20CA228Accident · Minor injuriesClass 4 · Data collectionFinal reportThorp Thorp T 18 · Madisonville, TNThe pilot's failure to maintain directional control during the landing roll on a soft turf runway, which resulted in a nose-over.NTSB ANC20CA057Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Palmer, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB CEN20CA196Accident · No injuriesClass 4 · Data collectionFinal reportDenney Kitfox Speedster · Georgetown, TXThe pilot's failure to maintain directional control during landing.NTSB CEN20CA191Accident · No injuriesClass 4 · Data collectionFinal reportPietenpol Aircamper · Midland, MIThe pilot's loss of control during an aborted landing.NTSB CEN20CA190Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Bunkie, LAThe pilot's failure to maintain directional control during takeoff.NTSB CEN20CA193Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Ionia, MIThe pilot's failure to maintain directional control during landing. Contributing was the pilot getting his shoe caught in the rudder pedal.NTSB CEN20CA192Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Carbondale, ILThe pilot's excessive brake input while he attempted to maintain directional control during landing roll.NTSB CEN20CA184Accident · No injuriesClass 4 · Data collectionFinal reportRhoads, Larry E Sopwith Baby · Lee's Summit, MOThe airplane builder's improper installation of the lower right wing which resulted in an uncommanded left roll and the subsequent loss of control.NTSB ERA20CA190Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Oxford, CTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB ANC20CA048Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Skwentna, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ANC20CA047Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18 · McGrath, AKThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a collision with trees and impacted with the ground.NTSB CEN20CA182Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Chatham, ILThe pilot's decision to continue flight in instrument meteorological conditions in an airplane not equipped for instrument flight, which forced her to perform a precautionary landing to a muddy field resulting in the airplane nosing over.NTSB ERA20CA185Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Fayetteville, TNThe pilot's failure to maintain directional control during landing in gusting crosswind conditions.NTSB WPR20LA172Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Imperial, CAThe pilot's loss of control during a landing roll due to a failure of the main O-ring in the right brake assembly, which resulted in a loss of brake pressure and subsequent brake failure.NTSB WPR20CA142Accident · No injuriesClass 4 · Data collectionFinal reportN126c CCX-2000 · Heber City, UTThe front seat pilot's failure to maintain directional control during the landing roll, and the rear seat pilot's delayed remedial control inputs that subsequently resulted in a ground loop. Contributing to the accident was a lack of communication by both…NTSB CEN20CA176Accident · No injuriesClass 4 · Data collectionFinal reportNorth American SNJ · San Antonio, TXThe pilot's loss of directional control while landing a tailwheel airplane in gusty wind conditions.NTSB WPR20CA139Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Hanksville, UTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop.