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 CEN09CA072Accident · No injuriesData collectionFinal reportCessna 172I · Osh Kosh, NEThe pilot's failure to maintain control of the airplane while taxing in strong winds.NTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.NTSB ERA09CA048Accident · No injuriesData collectionFinal reportCessna 172 · Groton, CTThe student pilot's failure to maintain directional control during landing.NTSB WPR09CA035Accident · No injuriesData collectionFinal reportCessna 305A · El Cajon, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.NTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.NTSB CEN09CA042Accident · No injuriesData collectionFinal reportCessna 172H · Ingleside, TXThe pilot's decision to land in crosswind conditions, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.NTSB CEN09LA036Accident · No injuriesLimited investigationFinal reportCessna 180 · Justin, TXThe pilot's failure to maintain control of the airplane during landing.NTSB CEN09CA044Accident · No injuriesData collectionFinal reportCessna 172M · Carroll, IAThe improper preflight planning/decision made by the pilot in attempting a taxi in high wind conditions. Contributing to the accident was the winds.NTSB ERA09CA104Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Tallahasee, FLThe pilot's failure to maintain aircraft control after touchdown. Contributing to the accident were the gusting winds.NTSB CEN09CA076Accident · No injuriesData collectionFinal reportCessna 170A · Butler, MOThe pilot's failure to maintain directional control and his failure to compensate for wind conditions which resulted in a ground loop.NTSB WPR09FA019Accident · 3 fatalField investigationFinal reportMooney M20J · Avalon, CAThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons. Contributing to the accident was the pilot's failure to abort the takeoff while sufficient runway remained to stop.NTSB CEN09CA028Accident · No injuriesData collectionFinal reportHoward Super Sky Raider · Tuscola, ILThe pilot failed to maintain directional control during takeoff roll. A contributing factor was the cornfield and the pilot's lack of recent experience.NTSB WPR09CA018Accident · Minor injuriesData collectionFinal reportBeech F33A · Big Bear, CAThe pilot's failure to maintain directional control of the airplane during landing.NTSB ERA09CA023Accident · No injuriesData collectionFinal reportPiper PA-20 · Albertville, ALThe pilot’s failure to maintain control of the airplane during the landing roll.NTSB CEN09CA027Accident · Minor injuriesData collectionFinal reportCessna 180 · Denton, TXThe pilot's loss of directional control and subsequent "ground-loop."NTSB CEN09CA029Accident · No injuriesData collectionFinal reportCessna 172 · Van Wert, OHThe pilot's failure to maintain directional control of the airplane while taxiing on the wet grass.NTSB WPR09CA007Accident · No injuriesData collectionFinal reportCessna T206H · Henderson, NVThe pilot's inadequate compensation for the crosswind conditions.NTSB CEN09CA018Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-105 · Albuquerque, NMThe pilot's failure to maintain control of the balloon during landing. Contributing to the accident were the wind gusts.NTSB CEN09CA005Accident · No injuriesData collectionFinal reportCessna 180A · St. Louis, MOThe flight instructor's failure to maintain directional control during the landing.NTSB ERA09CA008Accident · No injuriesData collectionFinal reportAviat A-1B · Mooresville, NCThe pilot's improper flare while landing. Contributing to the accident was the pilot's lack of recent experience.NTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.NTSB ERA09CA010Accident · No injuriesData collectionFinal reportCessna 172 · Naples, METhe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB CEN09CA002Accident · No injuriesData collectionFinal reportCessna 172 · Alton, ILThe student pilot's failure to maintain directional control during landing. A contributing factor was the presence of the sign struck during the runway excursion.NTSB CEN09CA001Accident · No injuriesData collectionFinal reportLuscombe 8A · Greeley, COThe pilot's failure to maintain directional control during the landing roll resulting in a ground loop. Contributing to the accident was the lack of remedial action from the flight instructor.NTSB SEA08CA215Accident · No injuriesData collectionFinal reportNorth American AT-6 · Arlington, WAThe front seated pilot's inadequate compensation for the right quartering tailwind and failure to maintain directional control. Also causal was the rear seated pilot's inadequate remedial action and failure to regain directional control.NTSB LAX08FA301Accident · Serious injuriesField investigationFinal reportCessna 172S · Fullerton, CAThe pilot's failure to follow the takeoff checklist and verify the proper flap setting before takeoff.NTSB CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…NTSB SEA08CA214Accident · No injuriesData collectionFinal reportLaird LC-1B-300 · Spokane, WAThe pilot’s misjudged landing flare that resulted in a hard landing. A contributing factor was the impact related failure of the tail wheel spring attachment bolts due to overload, which resulted in a ground loop.NTSB CHI08CA295Accident · Minor injuriesData collectionFinal reportNorth American Harvard MK · Dayton, OHImproper maintenance on the tail wheel anti-shimmy mechanism and the pilot's decision to continue operating the airplane with a known shimmy in the tail wheel.NTSB SEA08CA212Accident · No injuriesData collectionFinal reportSport Flight International Astra · Spokane, WAThe pilot's excessive use of brakes and failure to maintain directional control during the landing roll.NTSB CHI08LA286Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Delaware, OHThe student pilot's failure to maintain directional control during landing.NTSB CHI08LA297Accident · Serious injuriesLimited investigationFinal reportPowrachute Pegasus · New London, WIThe pilot's loss of directional control during landing due to failure of the nose wheel support as a result of an inadequate weld.NTSB CHI08CA289Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Crookston, MNThe pilot's failure to maintain directional control during landing and the flight instructor's delayed remedial action.NTSB SEA08CA204Accident · No injuriesData collectionFinal reportGoetz RAF 2000 · Mulino, ORThe pilot's failure to maintain directional control during landing.NTSB DEN08CA156Accident · No injuriesData collectionFinal reportCessna 177RG · Ellsworth, KSThe student pilot's failure to maintain directional control during the landing roll.NTSB SEA08CA201Accident · No injuriesData collectionFinal reportStinson 108-1 · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC08CA124Accident · No injuriesData collectionFinal reportPiper PA-12 · Slana, AKThe pilot's excessive application of the brakes during the landing roll, resulting in a nose over and substantial damage.NTSB SEA08CA198Accident · No injuriesData collectionFinal reportCessna 152 · Columbia, CAThe student pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot's improper use of the throttle control.NTSB MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.NTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.NTSB NYC08CA313Accident · No injuriesData collectionFinal reportDiamond Aircraft Industry DA 20-C1 · Stevensville, MDThe student pilot's failure to maintain directional control during takeoff.NTSB LAX08CA293Accident · No injuriesData collectionFinal reportBrubaker F1 · Truckee, CAThe failure of the bolts securing the tail wheel to its attach point that resulted in a loss of directional control.NTSB DEN08CA154Accident · No injuriesData collectionFinal reportNorth American SNJ-5 · Leadville, COThe pilot's failure to maintain aircraft control during takeoff.NTSB ANC08CA118Accident · No injuriesData collectionFinal reportDiehl William A S-4 · Galena, AKThe pilot's failure to maintain pitch control of the airplane during takeoff, and the pilot's inadequate preflight inspection of the airplane.NTSB SEA08CA197Accident · No injuriesData collectionFinal reportCessna A185F · Lakeview, ORThe pilot's failure to maintain directional control. A contributing factor was the rough terrain.NTSB DFW08CA221Accident · No injuriesData collectionFinal reportCessna 560 · Telluride, COThe pilot's failure to maintain control during landing. A factor was the reported wind shear.NTSB DEN08CA147Accident · No injuriesData collectionFinal reportPiper PA-22 · Star City, ARThe pilot failed to maintain directional control during landing. Contributing to the accident were the crosswinds and the rough terrain near the runway.NTSB LAX08CA287Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Dillon, MTThe pilot-certificated passenger's failure to maintain directional control during landing and the pilot's delayed remedial action and inadequate supervision.NTSB CHI08LA288Accident · No injuriesLimited investigationFinal reportFantasy Air Sro Allegro 20 · Walworth, WIThe pilot's failure to maintain directional control during landing.