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 LAX05CA145Accident · No injuriesData collectionFinal reportCessna 180 · Corona, CAthe pilot's inadequate compensation for a crosswind/wind gust condition and his failure to maintain directional control during landing rollout.NTSB LAX05CA142Accident · No injuriesData collectionFinal reportRankin Quickie Q2 · Chino, CAthe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during landing rollout.NTSB CHI05CA101Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Gordon, NEThe student pilot's failure to maintain direction control during landing. The pilot lack of familiarity with the airplane was a factor.NTSB CHI05LA099Accident · No injuriesLimited investigationFinal reportCessna 195A · Jackson, MIThe fracture of the left brake master cylinder piston rod, which resulted in the total failure of the left-side brake system and the subsequent loss of directional control during landing roll. An additional cause was the encountered ground-loop.NTSB ANC05CA060Accident · No injuriesData collectionFinal reportCessna A185E · Wasilla, AKThe flight instructor's failure to provide adequate supervision of the second pilot during the landing roll, which resulted in a loss of control and an intentional ground-loop by the instructor. A factor in the accident was the dual student's ( a certificated…NTSB DEN05LA069Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Englewood, COThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control during landing. Contributing factors were crosswind weather conditions and a lack of familiarity with the aircraft.NTSB CHI05CA098Accident · No injuriesData collectionFinal reportCurl Avid Air Magnum · Cando, NDThe pilot's failure to compensate for the crosswind condition and maintain directional control during landing rollout. Factors to the accident were the crosswind and the muddy drainage ditch.NTSB LAX05LA138Accident · No injuriesLimited investigationFinal reportCessna 150F · Prescott, AZthe pilot's failure to maintain directional control on landing.NTSB MIA05CA090Accident · No injuriesData collectionFinal reportNorth American AT-6C · Lakeland, FLThe pilot's attempted turn off the runway at excessive speed, resulting in the right wing raising, the left wing touching the runway, and the left landing gear collapsing.NTSB NYC05LA070Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Warren, PAThe pilot's failure to follow the balked landing checklist while attempting to abort a landing. Factors in the accident were his failure to maintain directional control during the landing, and a gust of wind.NTSB SEA05LA073Accident · No injuriesLimited investigationFinal reportShorethose Kitfox Series 5 · Cresent City, FLAircraft handling not maintained during the landing rollout. Factors include soft terrain.NTSB LAX05CA147Accident · No injuriesData collectionFinal reportMaule MA-7-235C · Borrego Springs, CAthe pilot's failure to maintain directional control.NTSB ANC05CA057Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop. A factor contributing to the accident was a tailwind.NTSB MIA05CA089Accident · Minor injuriesData collectionFinal reportAerostar Yak-52TW · Daytona Beach, FLPilot's failure to maintain directional control in a variable wind condition during landing resulting in the airplane departing the runway subsequent landing gear separation and impact with trees.NTSB SEA05LA081Accident · No injuriesLimited investigationFinal reportCessna 185F · Medford, ORThe pilot's failure to maintain directional control during the landing roll. Factors include variable winds that at times were crosswinds.NTSB DFW05CA101Accident · No injuriesData collectionFinal reportCessna 152 · Stillwater, OKThe student pilot's failure to maintain directional control during landing.NTSB CHI05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Kalamazoo, MIThe pilot's failure to maintain directional control and the excessive taxispeed.NTSB NYC05LA067Accident · No injuriesLimited investigationFinal reportCessna 182S · West Mifflin, PAThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the gusty wind conditions.NTSB CHI05CA089Accident · Serious injuriesData collectionFinal reportFranz RV-6 · Howell, MIThe pilot's failure to maintain directional control during the landing rollout which resulted in the aircraft departing the runway pavement and nosing over. An additional cause was the pilot's inadequate compensation for the crosswind condition. Contributing…NTSB ATL05CA069Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Griffin, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with a ditch.NTSB ANC05CA054Accident · No injuriesData collectionFinal reportPiper PA-18 · Bethel, AKThe pilot's failure to compensate for a crosswind during an aborted landing, which resulted in a loss of directional control. A factor associated with the accident was a crosswind.NTSB LAX05CA127Accident · No injuriesData collectionFinal reportCessna 172L · Chino, CAthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB ATL05CA070Accident · No injuriesData collectionFinal reportCessna 152 · Goose Creek, NCThe student pilot's failure to maintain direction control, which resulted in a loss of control and collision with a berm.NTSB LAX05LA126Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Long Beach, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB CHI05FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · West Union, IAThe pilot's failure to abort the takeoff, his failure to maintain adequate airspeed during the takeoff, and the pull-up to avoid obstacles which resulted in an inadvertent stall. Factors associated with the accident were the pilot's failure to maintain…NTSB ANC05LA052Accident · No injuriesLimited investigationFinal reportCub Crafters PA-18 · Fairbanks, AKThe flight instructor's inadequate supervision of the flight, and the dual student's failure to maintain directional control.NTSB NYC05LA063Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hamburg, NYThe pilot's failure to maintain directional control while landing.NTSB LAX05CA123Accident · No injuriesData collectionFinal reportPeter A. Geiser Lee/Geiser Nieuprt17 · Chandler, AZThe pilot's inadequate compensation for the gusting crosswind condition and failure to maintain directional control during landing rollout.NTSB CHI05CA084Accident · No injuriesData collectionFinal reportCessna 172 · Baudette, MNThe pilot's inadequate compensation for the crosswind which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the snow covered surface on which the landing was being made, and the…NTSB LAX05LA118Accident · No injuriesLimited investigationFinal reportCessna 172S · Thermal, CAthe student pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.NTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…NTSB DFW05CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Crosbyton, TXThe pilot's failure to mantain directional control during take-off. A contributing factor was the dust devil.NTSB LAX05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Flagstaff, AZthe loss of directional control during landing for undetermined reasons.NTSB SEA05CA062Accident · No injuriesData collectionFinal reportCessna 172 · Gooding, IDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of control during taxi. A contributing factor was the wind gusts.NTSB DFW05CA095Accident · No injuriesData collectionFinal reportAyres S-2R · Marvell, ARThe pilot's failure to maintain directional control while landing. A contributing factor was gusty winds.NTSB DFW05CA084Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe pilot's failure to maintain control of the airplane during landing. A contributing factor was a deflated right main tire.NTSB LAX05LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Tucson, AZa loss of directional control due to the failure of unknown maintenance personnel to install the tailwheel-locking collar, and the inadequate maintenance inspection of the worn tailwheel steering arm.NTSB SEA05LA054Accident · 1 fatalLimited investigationFinal reportSimpkins RV-6A · Yamhill, ORThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in a nose over. Factors contributing to the accident included the wet runway and the embankment.NTSB MIA05LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Destin, FLThe pilot's inadequate compensation for wind during a crosswind takeoff resulting in a loss of directional control and subsequent collision with terrain.NTSB IAD05LA042Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Andover, NJThe pilot receiving instruction's failure to maintain directional control during the landing roll. Factors in the accident were the flight instructors delayed remedial action, and crosswind.NTSB MIA05CA068Accident · No injuriesData collectionFinal reportCessna 305A · Bartow, FLThe pilots failure to maintain directional control resulting in the airplane ground-looping. A factor in the accident was the pilots lack of total experience in the airplane make and model.NTSB ANC05LA044Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's excessive taxi speed during a turn while taxiing from landing, which resulted in the collapse of the left main landing gear, and structural damage to the fuselage.NTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…NTSB LAX05LA103Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Kapolei, HIthe pilot's inadequate compensation for the quartering tailwind conditions, and his failure to maintain directional control of the airplane during landing. Related factors were the tailwind and crosswind.NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.NTSB MIA05LA059Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Brookhaven, MSThe pilot's inadequate compensation for wind and his failure to maintain control of the airplane during landing, which resulted in the airplane ground looping.NTSB ANC05LA041Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a departure from the runway and collision with a snow bank. A factor contributing to the accident was snow-covered terrain.NTSB LAX05CA096Accident · No injuriesData collectionFinal reportAeronca 7EC · Grass Valley, CAthe pilot's failure to maintain directional control.NTSB LAX05CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Roosevelt, AZthe pilot's failure to maintain directional control.