NTSB investigations
4,590 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 WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.NTSB ERA22LA063Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Denver, NCThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB ERA22LA057Accident · No injuriesClass 4 · LimitedFinal reportCessna/Air Repair 305F · Anne Arundel, MDThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and substantial damage.NTSB ERA22LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Newport Richie, FLA loss of directional control on landing for undetermined reasons.NTSB CEN22LA030Accident · No injuriesClass 4 · LimitedFinal reportRaytheon G36 · Frankenmuth, MIThe pilot’s failure to maintain directional control while landing on a wet grass strip.NTSB WPR22LA029Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Challis, IDThe pilot’s loss of directional control after the airplane encountered a gust of wind during the landing roll.NTSB WPR22LA027Accident · No injuriesClass 4 · LimitedFinal reportSanta Fe CCX-2300 · Taos, NMThe pilot’s failure to maintain directional control during a landing roll, which resulted in a ground loop and impact with the ground.NTSB CEN22LA025Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Cresson, TXThe student pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with trees.NTSB CEN22LA028Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Greeley, COThe pilot’s loss of directional control during the landing roll.NTSB ERA22LA032Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6D · Pickens, SCThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and collision with rocky terrain.NTSB CEN22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe student pilot’s failure to maintain aircraft control during the final approach resulting in a bounced landing.NTSB ERA22LA027Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB500 · Orlando, FLThe pilot's inadvertent application of the right brake during the landing roll, which resulted in a loss of directional control and a subsequent runway excursion.NTSB ANC22LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208B · Juneau, AKThe pilot’s loss of directional control for reasons that could not be determined.NTSB ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.NTSB WPR22LA009Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Albany, ORThe pilot's failure to maintain directional control during takeoff.NTSB WPR22LA008Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Garberville, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with an unoccupied parked airplane.NTSB CEN22LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Watkins, COThe separation of the left main landing gear spring during landing roll due to a preexisting fatigue crack.NTSB WPR22LA003Accident · No injuriesClass 4 · LimitedFinal reportInterstate S-1A · Independence, ORThe separation of the left rudder pedal interconnect cable during takeoff, which resulted in the student pilot’s inability to maintain directional control.NTSB ERA22LA003Accident · No injuriesClass 4 · LimitedFinal reportCulp John S Culps Specl Sopwith · Pottstown, PAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA21LA394Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Apopka, FLA loss of directional control during landing for reasons that could not be determined based upon the disposition of the wreckage following a late accident report.NTSB ERA21LA387Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLThe pilot’s loss of helicopter control after landing. Also causal was the pilot’s intentional operation of the helicopter without the required training, experience, and endorsements.NTSB ERA22LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Indian Trail, NCThe pilot’s failure to maintain airplane control during takeoff and initial climb. Contributing was the pilot’s physical limitation which caused an inadvertent application of left rudder.NTSB CEN21LA458Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182E · Troup, TXThe pilot’s failure to maintain directional control during landing with a variable gusting wind and his decision not to perform a go-around that resulted an overrun and impact with a fence and trees.NTSB WPR21LA361Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Elk River, IDThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a fence.NTSB WPR21LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Tucumcari, NMThe pilot’s improper landing flare which resulted in a hard and bounced landing.NTSB CEN21LA451Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Eden Prairie, MNThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.NTSB ANC21LA099Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cordova, AKThe pilot’s failure to maintain control of the airplane after landing in gusty wind conditions.NTSB WPR21LA349Accident · No injuriesClass 4 · LimitedFinal reportBeech D17S · San Diego / El Cajon, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a crosswind, which resulted in a runway excursion and subsequent collision with runway signage.NTSB ERA21LA370Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Walnut Cove, NCThe pilot’s failure to attain the proper touchdown point which resulted in a runway overrun, collision with an airport boundary fence, and a nose over event.NTSB CEN21LA448Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Topeka, KSThe loss of control and ground loop due to the mechanical malfunction of the tailwheel lock.NTSB ANC21LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Homer, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB ANC21LA091Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Nenana, AKThe pilots over application of the brakes during landing, which resulted in a nose-over.NTSB CEN21LA430Accident · No injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Battle Creek, MIThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing and the flight instructor’s inadequate remedial action.NTSB CEN21LA422Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Ypsilanti, MIThe pilot’s failure to maintain directional control during taxi, which resulted in a ground loop.NTSB WPR21LA347Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Stanley, IDThe pilot’s failure to maintain airplane control during landing with a gusting crosswind which, resulted in a hard landing and collision with terrain.NTSB WPR21LA346Accident · Serious injuriesClass 4 · LimitedFinal reportGordon Scot A RV-6A · Palouse, WAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB CEN21LA433Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Council Bluffs, IAThe student pilot’s failure to maintain directional control during a touch and go landing.NTSB GAA21WA230Accident · 1 fatalClass 5 · ForeignBell 206 · Hope Bay, Canada, CanadaNTSB ERA21LA375Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Andover Township, NJThe student pilot's excessive asymmetrical application of the brakes, which resulted in a nose over.NTSB ERA21LA358Accident · Minor injuriesClass 4 · LimitedFinal reportAlon A2 · Abingdon, VAThe failure of a nosewheel steering actuator arm, which resulted in a loss of control during the landing rollout.NTSB ANC21LA086Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Port Alsworth, AKA loss of directional control for reasons that could not be determined based on the available information.NTSB CEN21LA420Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Ultralight Challenger II · Rogers City, MIThe separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…NTSB ANC21LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and nose over.NTSB WPR21LA339Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Arlington, WAThe fatigue fracture of the tailwheel fitting spring, which resulted in the loss of directional control during the landing roll.NTSB CEN21LA403Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Gunnison, COThe pilot’s failure to maintain directional control of the airplane after landing with a quartering tailwind.NTSB ANC21LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tyonek, AKThe pilot’s selection of inappropriate terrain and decision to land with a tailwind, which resulted in a loss of directional control, an attempted go-around, and subsequent impact with terrain.NTSB WPR21LA336Accident · Serious injuriesClass 4 · LimitedFinal reportRagwing S1 · Arlington, WAThe pilot’s loss of directional control during landing.NTSB ANC21LA084Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Gustavus, AKThe pilot’s failure to maintain directional control during an off-airport beach landing.NTSB CEN21LA394Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Dunseith, NDThe pilot’s failure to maintain directional control during an attempted go-around with a strong gusting crosswind.NTSB CEN21LA393Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Storm Lake, IAThe pilot’s failure to maintain adequate airspeed during a landing approach with a tailwind that resulted in a landing overrun and impact with terrain.