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 ATL07CA020Accident · No injuriesData collectionFinal reportCessna 190 · Chattanooga, TNThe pilot's failure to maintain directional control on takeoff resulting in a collapse of the left main landing gear when the airplane swerved. A factor in the accident was wake turbulence from a landing airplane.NTSB LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.NTSB SEA07LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Billings, MTThe flight instructor's inadequate remedial action to maintain directional control, which resulted in a ground loop/swerve during takeoff roll. A factor was the failure of the pilot who was receiving instruction to maintain directional control.NTSB MIA07TA017Accident · Minor injuriesFinal reportEurocopter AS 350 BA · Ft. Myers, FLThe pilot's failure to maintain aircraft control during engine start. Contributing to the accident was the pilot's improper advancement of the fuel control lever.NTSB CHI07LA024Accident · 1 fatalLimited investigationFinal reportMaule MX-7-180B · Edenville, MIThe pilot's loss of control during landing on a lake resulting in the amphibian aircraft flipping over inverted.NTSB DEN07CA023Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Fe, NMthe pilot's failure to maintain directional control during the landing roll, and his failure to maintain airspeed which resulted in a stall and hard landing.NTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.NTSB LAX07CA030Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Glendale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB SEA07LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Richfield, UTThe student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…NTSB CHI07CA014Accident · No injuriesData collectionFinal reportBellanca 7ECA · Eden Prairie, MNThe pilot not maintaining directional control of the tailwheel airplane during the landing roll. A factor was the runway sign that was impacted.NTSB DFW07CA015Accident · No injuriesData collectionFinal reportMaule M5 · New Braunfels, TXThe failure of the right main landing gear attachment during the landing roll, which resulted in a ground loop. A contributing factor was a crosswind.NTSB DEN07CA014Accident · No injuriesData collectionFinal reportChampion 7GCB · Farmington, NMthe pilot's failure to maintain directional control during the landing.NTSB ANC07CA004Accident · No injuriesData collectionFinal reportPiper PA-20-135 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and encounter with terrain. Factors associated with the accident were the ground loop and inadequate main wheel brakes.NTSB LAX07CA009Accident · No injuriesData collectionFinal reportFinney Thorp T-18 · San Diego, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB DFW07CA013Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Fredricksburg, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB ATL07CA008Accident · No injuriesData collectionFinal reportCessna CE-180-A · Statesville, NCThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with the runway.NTSB SEA07LA011Accident · No injuriesLimited investigationFinal reportSorensen Searey · Marysville, WAThe pilot's failure to identify an unsafe condition (strong tidal currents) prior to a water landing, which resulted in the airplane nosing over when the pilot was unable to maintain aircraft control.NTSB LAX07CA006Accident · No injuriesData collectionFinal reportHarry D. Miller Midget Mustang 1 · Reno, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB SEA07LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lebanon, ORThe pilot's failure to maintain directional control during the landing roll, resulting in the aircraft departing the runway and impacting a Visual Approach Slope Indicator (VASI) standard. The VASI standard near the side of the runway was a factor.NTSB ATL07CA003Accident · No injuriesData collectionFinal reportHadwise Varieze · Enterprise, ALThe pilot's improper starting procedure, which resulted in an uncommanded aircraft movement and collision with a hanger.NTSB SEA07CA003Accident · No injuriesData collectionFinal reportCessna T182T · Spokane, WAThe pilot's excessive braking which resulted in a loss of aircraft control during the landing roll. A taxiway sign was a factor.NTSB DFW07CA003Accident · No injuriesData collectionFinal reportBoeing 75 · Sweetwater, TXThe pilot's failure to maintain directional control while landing.NTSB NYC06CA232Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe pilot's failure to maintain directional control while landing.NTSB SEA06CA191Accident · No injuriesData collectionFinal reportMaule M-6-235 · Ronan, MTThe pilot's failure to maintain directional control during the landing roll in the tailwheel-equipped aircraft. A swale (sunken area) between the runway and the taxiway was a factor.NTSB DFW06LA216Accident · 1 fatalLimited investigationFinal reportWeber Venture · El Paso, TXThe aircraft's inadequate landing gear design, which resulted in a loss of directional control and subsequent nose-over. A factor was the owner/builder's failure to incorporate modifications to the landing gear.NTSB ATL06CA132Accident · No injuriesData collectionFinal reportCessna 180K · Mooresville, NCThe pilot's failure to maintain directional control during the takeoff roll which resulted in a ground loop.NTSB CHI06CA272Accident · No injuriesData collectionFinal reportBoeing A75N1 · Garrettsville, OHThe pilot's failure to maintain directional control during the takeoff roll. The bush and tree were factors to the accident.NTSB LAX06CA303Accident · No injuriesData collectionFinal reportCleberg Sportsman 2+2 GS-2 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB CHI06FA269Accident · 1 fatalField investigationFinal reportCessna 182Q · Cumberland, WIThe pilot's inadvertent attempt to land on water with the wheels down and his failure to verify the gear position prior to landing. Contributing factors were the inoperative gear system due to the open gear selector circuit breaker, which tripped for…NTSB SEA06CA186Accident · No injuriesData collectionFinal reportCessna 152 · Pembroke Pine, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the runway sign.NTSB SEA06CA187Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's failure to adequately compensate for wind conditions during the landing roll. A drainage ditch and wind were contributing factors.NTSB SEA06LA184Accident · 1 fatalLimited investigationFinal reportShimer One Design · Lake Wales, FLThe loss of control for an undetermined reason during the landing roll.NTSB LAX06CA295Accident · No injuriesData collectionFinal reportBeech A36 · Chandler, AZthe student's failure to establish a stabilized approach, which resulted in a bounced landing and a loss of directional control. Also causal was the flight instructor's inadequate supervision of the flight, delayed remedial action, and failure to verbally…NTSB SEA06CA192Accident · No injuriesData collectionFinal reportAmorde Glasair II-S RG · Rockford, IDThe pilot's failure to maintain aircraft control during landing. A contributing factor was gusty winds.NTSB SEA06CA183Accident · No injuriesData collectionFinal reportCessna 305A · Lewistown, MTThe pilot's failure to maintain aircraft control during landing, which resulted in an inadvertent swerve and nose down. A contributing factor was the gusty wind condition.NTSB SEA06CA179Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kanab, UTThe pilot's failure to maintain aircraft control during the takeoff roll. Contributing factors were the rough/uneven conditions of the dirt runway, the wind gusts, and the berms and ditches on both sides of the runway.NTSB ANC06CA126Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's excessive braking during the landing roll, which resulted in a loss of control and a nose over.NTSB NYC06LA216Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hampton, NHThe pilot's failure to maintain directional control during takeoff.NTSB DEN07CA032Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Riverton, WYthe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop.NTSB ANC06LA134Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Wainwright, AKThe pilot's failure to adequately compensate for wind conditions during the landing roll, which resulted in a loss of control, and subsequent collision with a ditch when the airplane departed the runway. A factor contributing to the accident was a crosswind.NTSB NYC06CA217Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · White Lake, NYThe flight instructor's failure to ensure the landing gear was retracted prior to attempting a water landing.NTSB CHI06LA255Accident · No injuriesLimited investigationFinal reportCessna A185E · Valentine, NEThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in an inadvertent ground loop by the pilot. A factor contributing to the accident was the gusting crosswind condition.NTSB DFW06CA202Accident · No injuriesData collectionFinal reportCessna 152 · Gainesville, TXThe pilot's improper recovery from a bounced landing resulting in a porpoise.NTSB SEA06CA170Accident · No injuriesData collectionFinal reportPiper PA-22-20-150 · Auburn, WAThe flight instructor's delayed remedial action during the landing roll in response to the student's loss of directional control, which resulted in a ground loop. A factor associated with the accident was the student's failure to maintain directional control.NTSB DFW06CA200Accident · No injuriesData collectionFinal reportAeronca 11AC · Searcy, ARThe student pilot's inadequate compensation for the existing wind conditions and the flight instructor's delayed remedial action to maintain directional control. A contributing factor was the crosswind.NTSB LAX06LA269Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Carlos, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll.NTSB SEA06LA163Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103A · North Plains, ORThe glider pilot's misjudgment of distance/speed during approach, which resulted in excessive speed at touchdown, and his failure to maintain directional control during the landing roll. A contributing factor was the glider pilot's lack of experience in the…NTSB LAX06LA266Accident · 1 fatalLimited investigationFinal reportSaloff Sonerai Iilt · Williams, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB MIA06CA131Accident · No injuriesData collectionFinal reportCessna 182S · Fort Myers, FLThe pilot's failure to maintain control during the landing rollout during gusting wind conditions, which resulted in the airplane veering off the runway.NTSB LAX06CA263Accident · No injuriesData collectionFinal reportStinson 108-2 · Grass Valley, CAfailure of the pilot to maintain directional control on the landing rollout due to inadequate compensation for a gusty crosswind condition and an attempt to turn at an excessive taxi speed.