NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 CHI03LA195Accident · No injuriesLimited investigationFinal reportRuminski Ultra Pup · Richmond, INThe pilot failed to maintain directional control and the airplane ground looped.NTSB CHI03LA196Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lansing, ILThe dynamic rollover encountered by the pilot. Factors were the inadequate remedial action by the pilot due to his failure to prevent the rollover, and the inadequate facility with regard to the design of the landing platform.NTSB DEN03LA117Accident · No injuriesLimited investigationFinal reportMooney M20C · Englewood, COthe pilot's failure to maintain aircraft control during landing. Factors contributing to the accident were the gusting crosswinds and the high density altitude.NTSB LAX03CA219Accident · No injuriesData collectionFinal reportStinson 108-3 · St. Johns, AZthe pilot's inadequate compensation for the gusting and shifting wind conditions, which resulted in a failure to maintain directional control and a ground loop. The gusting and shifting wind conditions were factors in the accident.NTSB ANC03LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Pilot Point, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain control of the airplane that resulted in the left wing striking the ground during the landing roll. A factor contributing to the accident was the presence of wind gusts.NTSB SEA03LA120Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moses Lake, WAAn improper flare which resulted in a bounced landing during landing. The pilot's failure to maintain aircraft control and soft terrain were factors which eventually led to the aircraft nosing over.NTSB NYC03LA159Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Taunton, MAThe pilot's failure to maintain directional control while landing and the CFI's delayed remedial action.NTSB NYC03LA140Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Point Pleasant, WVThe CFI's failure to maintain directional control, which resulted in a collision with trees.NTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.NTSB SEA03LA122Accident · No injuriesLimited investigationFinal reportCessna 185F · Lexington, ORThe pilot's failure to maintain aircraft control during the landing roll. A partially deflated tire and soft terrain were factors.NTSB IAD03CA059Accident · No injuriesData collectionFinal reportPiper Saratoga II TC PA32- · Mansfield, OHThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing. A factor was the gusty wind conditions.NTSB ATL03LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Hatteras, NCThe pilot's failure to maintain directional control during the landing roll. A factor was a go-around not performed.NTSB CHI03LA168Accident · No injuriesLimited investigationFinal reportCessna A188B · Hornersville, MOThe pilot's failure to maintain directional control of the airplane during takeoff. A contributing factor was the crosswind.NTSB DEN03LA106Accident · No injuriesLimited investigationFinal reportCessna 180 · Ogden, UTthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control.NTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.NTSB CHI03LA163Accident · No injuriesLimited investigationFinal reportCessna 172N · Anoka, MNThe pilot's failure to attain the proper touchdown point, and his failure to maintain directional control. Contributing factors were the pilot's lack of experience, and the runway sign.NTSB SEA03LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Laurel, MTAircraft control was not maintained during the landing roll. The aircraft subsequently nosed over.NTSB LAX03LA195Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Casa Grande, AZThe pilot's inadequate compensation for the wind conditions, and his failure to maintain aircraft control resulting in an inadvertent ground loop.NTSB ATL03CA105Accident · Minor injuriesData collectionFinal reportAyers RV-6A · St. Simons Isld, GAThe pilot's inadequate preflight inspection that resulted in his failure to remove the seatbelt (flight control gust lock) from the right side flight control stick.NTSB NYC03LA126Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Louisville, KYThe pilots inadequate compensation for the crosswind conditions, and his failure to maintain directional control. A factor related to the accident was the crosswind.NTSB ANC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Teller, AKThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during the landing roll, resulting in a loss of control and nose down of the airplane. A factor in the accident was a crosswind.NTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.NTSB LAX03LA186Accident · No injuriesLimited investigationFinal reportCessna 172S · Prescott, AZThe student pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight in allowing the student to perform a solo flight with a strong,…NTSB NYC03LA125Accident · No injuriesLimited investigationFinal reportCessna 172L · Newburyport, MAThe pilot's failure to attain the proper touchdown point.NTSB NYC03LA123Accident · No injuriesLimited investigationFinal reportCessna R172K · Warrenton, VAThe pilot's inadequate compensation the shifting wind conditions, and his failure to maintain directional control. A factor related to the accident was the shifting wind conditions.NTSB CHI03LA157Accident · No injuriesLimited investigationFinal reportCessna 140A · Grinnell, IAThe pilot's inadvertent ground loop. Factors contributing to the accident were the wind gusts and crosswind conditions.NTSB CHI03LA145Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Jenison, MIThe pilot not maintaining directional control of the airplane during landing. A factor to the accident was the overload of the right main landing gear.NTSB SEA03LA091Accident · No injuriesLimited investigationFinal reportCessna 150 · Dillon, MTThe pilot's failure to maintain directional control during the takeoff roll, and his inadequate remedial actions during his attempt to realign the aircraft with the runway. Factors include a crosswind, and the pilot's lack of experience in tailwheel-equipped…NTSB DEN03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Price, UTthe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A related factor was the crosswind.NTSB DEN03LA091Accident · No injuriesLimited investigationFinal reportChampion 7GC · Casper, WYthe pilot's failure to maintain directional control of the aircraft during the landing. Contributing factors include the inadequate remedial action by the pilot and the pilot's lack of experience in the aircraft.NTSB CHI03LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Seneca, KSThe pilot's failure to maintain directional control while landing. Factors contributing to the accident were the collapse of the left main landing gear strut and the ditch.NTSB ATL03LA099Accident · No injuriesLimited investigationFinal reportCessna 177RG · Wilmington, NCThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the ditch.NTSB ANC03LA052Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for a crosswing during the landing roll. A factor contribuiting to the accident was the presence of a crosswind.NTSB FTW03LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Guymon, OKThe pilot's inadequate compensation for the crosswind, and his failure to maintain directional control. A factor was the crosswind.NTSB SEA03LA088Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Oregon City, ORThe student pilot's failure to maintain aircraft control during the landing roll. A tailwind and gusting conditions were factors.NTSB DEN03LA084Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Albuquerque, NMthe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors include, the pressures induced on the pilot by the landing conditions and the asphalt walkway on the side of the runway.NTSB CHI03LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · North Platte, NEThe pilot's failure to maintain directional control and the collapse of the main landing gear. A factor to the accident was the quartering tailwind.NTSB LAX03LA155Accident · No injuriesLimited investigationFinal reportMonaghan Glasair · Hayward, CAthe pilot's inadequate recovery from a bounced landing and his failure to maintain directional control, resulting in a ground loop.NTSB LAX03LA153Accident · No injuriesLimited investigationFinal reportBeech B19 · Chandler, AZthe pilot's failure to maintain directional control on the landing roll due to his inadvertent use of brakes.NTSB SEA03LA083Accident · No injuriesLimited investigationFinal reportCessna 182J · Payette, IDThe pilot-in-command's failure to maintain directional control during the landing roll resulting in the aircraft departing the runway environment, collapsing the nose gear and nosing over. Contributing factors were the pilot-in-command's failure to execute a…NTSB CHI03LA128Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Lake Ozark, MOAn inability to maintain control of the helicopter during the wind gust and brief tail wind. The ravine, wind gust and tailwind were contributing factors to the accident.NTSB SEA03LA081Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colville, WAThe pilot's inadequate compensation for wind conditions on landing. A contributing factor was a crosswind.NTSB LAX03LA151Accident · No injuriesLimited investigationFinal reportCessna 172S · Camarillo, CAthe student pilot's failure to maintain directional control, resulting in a collision with terrain. The flight instructor's inadequate supervision of the flight and delayed remedial action were also causal.NTSB ATL03LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bristol, TNThe pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.NTSB NYC03LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Roanoke, VAThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the gusty wind conditions.NTSB ATL03LA087Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Beaufort, NCThe pilot's failure to follow the checklist and set the parking brake which resulted in the airplane colliding with a parked airplane.NTSB SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.NTSB MIA03CA103Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Madison, MSThe pilot's failure to maintain control during the landing rollout/which resulted in the airplane veering off the runway and incurring damage.NTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…NTSB NYC03LA092Accident · No injuriesLimited investigationFinal reportStinson 108 · Brookville, OHThe pilot's failure to maintain directional control while landing.