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 ERA12CA558Accident · No injuriesData collectionFinal reportBeech 35-C33 · Burlington, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN12CA574Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Centralia, ILThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB WPR12CA368Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McMinnville, ORThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.NTSB CEN12LA642Accident · No injuriesLimited investigationFinal reportAeropro CZ A240 · Greenfield, MOThe pilot's failure to attain a proper takeoff speed or pitch attitude during takeoff, which resulted in the airplane settling on the runway and impacting trees.NTSB WPR12CA372Accident · No injuriesData collectionFinal reportBoeing B75N1 · Mesa, AZThe pilot's failure to maintain directional control while landing in a crosswind.NTSB ERA12CA517Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Gum Neck, NCThe pilot's failure to maintain airplane control during the takeoff roll. Contributing to the accident was the rough condition of the runway.NTSB CEN12CA567Accident · No injuriesData collectionFinal reportFantasy Air Allegro 2000 · Bear Creek, WIA malfunction of the right brake for reasons that could not be determined because of the perishable evidence, which resulted in the pilot’s inability to maintain directional control of the airplane during landing.NTSB ANC12CA090Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during landing, which resulted in a ground loop and runway excursion.NTSB ANC12CA088Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's loss of control during the landing roll in gusting wind conditions, which resulted in the airplane nosing over.NTSB WPR12CA357Accident · No injuriesData collectionFinal reportCessna 172R · Everett, WAThe pilot’s failure to maintain directional control during takeoff.NTSB CEN12LA557Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Flandreau, SDA malfunction of the helicopter’s throttle system, which resulted in a loss of engine power during cruise flight.NTSB CEN12CA590Accident · No injuriesData collectionFinal reportCessna 180J · Wausau, WIThe pilot's loss of control during landing roll out, resulting in a runway excursion. Contributing to the accident was an unexpected crosswind wind gust.NTSB ERA12LA505Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Bay Minette, ALThe separation of the tailwheel linkage for reasons that could not be determined because the linkage was not located, which resulted in a loss of directional control during landing.NTSB WPR12CA354Accident · No injuriesData collectionFinal reportPiper PA-22 · Napa, CAThe pilot's inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control during the landing roll.NTSB WPR12CA352Accident · No injuriesData collectionFinal reportCessna 180 · Upland, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB ERA12CA506Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Myerstown, PAThe student pilot's decision to continue the takeoff roll while trying to secure an open canopy and his subsequent failure to maintain directional control. Contributing to the accident was the student pilot's failure to complete the pretakeoff checklist.NTSB CEN12LA541Accident · No injuriesLimited investigationFinal reportCessna 177RG · Litchfield, ILThe pilot's failure to maintain airplane control during the landing and the subsequent aborted landing.NTSB CEN12CA537Accident · No injuriesData collectionFinal reportGage Midget Mustang MM-1 · Erie, COThe pilot's inadequate compensation for the crosswind conditions during takeoff, which resulted in a loss of directional control.NTSB ERA12CA502Accident · No injuriesData collectionFinal reportMaule M-4C · Lincoln, METhe pilot's failure to maintain directional control during the landing roll.NTSB CEN12LA531Accident · No injuriesLimited investigationFinal reportRistine Avid Mark IV · Poplar Grove, ILThe failure of the lower right side longeron tail-spring support area during landing due to excessive corrosion.NTSB WPR12LA348Accident · No injuriesLimited investigationFinal reportSantana PA-18 Replica · Ronan, MTA jammed tailwheel assembly, which resulted in the pilot’s inability to maintain directional control upon landing.NTSB ERA12CA499Accident · No injuriesData collectionFinal reportAeronca 7CCM · Norridgewock, METhe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN12LA538Accident · No injuriesLimited investigationFinal reportCantlon Starduster Too SA300 · Galion, OHThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing an aborted landing.NTSB ERA12CA496Accident · Minor injuriesData collectionFinal reportCessna 172S · Culpeper, VAThe pilot’s failure to maintain directional control during an attempted takeoff.NTSB ERA12CA490Accident · No injuriesData collectionFinal reportAeronca 7AC · Winter Haven, FLThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.NTSB CEN12CA510Accident · No injuriesData collectionFinal reportCessna 172S · Oshkosh, WIThe flight instructor’s loss of directional control during landing, which resulted in a collision with a runway light.NTSB CEN12LA507Accident · No injuriesLimited investigationFinal reportCessna 150M · Cottage Grove, WIThe pilot's decision to land on a runway with significant overgrown vegetation along the edges and his landing, which was left of the centerline.NTSB WPR12CA336Accident · No injuriesData collectionFinal reportPiper PA28-150 · Yellow Pine, IDThe pilot's failure to attain and maintain an appropriate glide path, failure to perform a go-around, and failure to maintain directional control during the landing roll.NTSB CEN12CA499Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Hutchinson, KSThe pilot’s loss of directional control during the landing roll.NTSB WPR12CA333Accident · No injuriesData collectionFinal reportCessna 170A · Ellensburg, WAThe pilot’s loss of directional control during the landing roll.NTSB CEN12LA495Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lakeview, ARThe pilot’s loss of control during the takeoff roll for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA503Accident · No injuriesData collectionFinal reportPiper PA-16 · Keokuk, IAThe pilot’s loss of directional control during the landing roll in a variable crosswind, which resulted in a runway excursion.NTSB WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.NTSB CEN12LA494Accident · No injuriesLimited investigationFinal reportLee Oscar D III RV7 · Columbus, INThe failure of the right main landing gear attach bolt for undetermined reasons because the bolt was not received for examination.NTSB ERA12CA492Accident · No injuriesData collectionFinal reportFairchild M-62A · Albion, NYThe pilot’s failure to maintain directional control while taking off in gusting wind conditions.NTSB ERA12CA476Accident · No injuriesData collectionFinal reportMooney M20TN · Hilton Head, SCThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB WPR12CA322Accident · No injuriesData collectionFinal reportCubCrafters CC 11-160 · Stanley, IDThe pilot’s excessive use of the brakes during the landing roll.NTSB WPR12CA338Accident · No injuriesData collectionFinal reportAerotrek A220 · Bremerton, WAThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions.NTSB ERA12CA481Accident · No injuriesData collectionFinal reportCessna 172M · Hammond, NYThe pilot’s failure to maintain directional control of the airplane while landing in gusting wind conditions.NTSB CEN12LA471Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Augusta, KSThe loss of brake effectiveness on landing roll for reasons that could not be determined because a postaccident brake system examination did not reveal any anomalies, which resulted in a runway excursion.NTSB CEN12CA465Accident · Serious injuriesData collectionFinal reportMooney M20J · Oshkosh, WIThe pilot’s excessive airspeed at touchdown and his loss of control of the airplane during the landing roll.NTSB WPR12LA324Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G58 · Medford, ORA loss of directional control on landing for reasons that could not be determined based on the available evidence.NTSB WPR12LA315Accident · No injuriesLimited investigationFinal reportPiper PA-32S-300 · Adelanto, CAThe pilot’s failure to maintain directional control during the aborted takeoff, which was aborted due to fuel starvation as a result of an inadvertent in-flight activation of the fuel drain activation lever by the passenger. Contributing to the accident was…NTSB CEN12CA468Accident · No injuriesData collectionFinal reportPiper PA-11 · Neilsville, WIThe pilot did not maintain control of the airplane during an attempted aborted landing, which resulted in an inadvertent stall.NTSB CEN12CA461Accident · No injuriesData collectionFinal reportMooney M20K · Hutchinson, MNThe student pilot’s inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with obstructions.NTSB ANC12CA077Accident · No injuriesData collectionFinal reportBell 206L-3 · Circle, AKThe pilot's selection of unsuitable terrain for landing.NTSB CEN12LA485Accident · No injuriesLimited investigationFinal reportMooney M20E · Englewood, COThe pilot's loss of directional control during landing.NTSB ANC12CA076Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Whittier, AKThe pilot's failure to maintain clearance from brush during landing, which resulted in a loss of control.NTSB ERA12LA456Accident · Serious injuriesLimited investigationFinal reportSeibert Robert M Seibert RV-6 · Ridgeland, SCThe pilot's inadvertent use of the wheel brakes during touchdown and his failure to maintain directional control. Contributing to the accident was the flight instructor's delayed remedial action.