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 MKC90LA035Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Louis, MOThe pilot's failure to adequately compensate for the wind. The gusty, crosswind condition is considered a contributing factor to the accident.NTSB BFO90LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchellville, MDThe pilot allowed the aircraft to enter an inadvertent porpoise during an aborted takeoff.NTSB LAX90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rancho Calif, CAThe pilot's loss of directional control during a crosswind landing.NTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.NTSB LAX90LA032Accident · No injuriesLimited investigationFinal reportMooney 201 · Concord, CAThe pilot's loss of directional control and subsequent collision with an object during a touch and go landing in visual meteorological conditions.NTSB DEN90LA019Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Fort Collins, COInadequate compensation for wind conditons by the pilot which resulted in his failure to maintain directional control. Factors related to the accident were: the unfavorable wind condition and soft terrain.NTSB NYC90FA024Accident · Serious injuriesField investigationFinal reportCessna 145 · Bayport, NYThe pilot failed to maintain adequate airspeed during a go-around while recovering from a bounced landing. Contributing factor(s) was: an improper level-off and recovery from a bounced landing.NTSB MIA90IA020Incident · No injuriesIncident investigationFinal reportClassic YMF-5 · Marathon, FLThe pilot's incorrect elevator control while taxiing with a quartering tailwind. Contributing to the incident was the tailwind condition.NTSB LAX90LA018Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB NYC90LA022Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Pittstown, NJThe pilot's failure to maintain directional control during landing.NTSB MIA90LA019Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Zellwood, FLImproper planning/decision by the pilot. The crosswind and ditch were related factors.NTSB ATL90LA015Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Florence, SCThe worn steering system.NTSB MKC90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · St Louis, MODirectional control not maintained by the pilot in command. A contributing factor was the gusty crosswind.NTSB DEN90LA011Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Sterling, COThe pilot failed to correct a ground loop/swerve during landing roll. A strong crosswind was a contributing factor.NTSB SEA90LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · White City, ORThe pilot did not maintain direction control of the airplane during the landing roll and took inadequate remedial action. Factors contributing to the accident include terrain and the pilot's lack of total expereince.NTSB MKC90LA023Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Heafer, ARThe intentional swerve by the pilot during the takeoff roll. Contributing to the accident was the rough and soft terrain conditions.NTSB BFO90LA006Accident · No injuriesLimited investigationFinal reportCessna T310Q · Stevensville, MDThe pilot failed to maintain directional control of the aircraft during the landing roll.NTSB LAX90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Paso Robles, CAThe student pilot's failure to adequately compensate for the cross wind condition.NTSB CHI90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Toledo, OHFailure of the pilot to maintain directional control, which resulted in a ground swerve. Factors related to the accident were: the crosswind and the pilot's improper compensation for wind condition.NTSB SEA90LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Hoonah, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Factors related to the accident were: unfavorable/gusty wind conditions and the berm.NTSB LAX90DJA01Accident · Minor injuriesFinal reportEmair MA1-B · Hilo, HIThe failure of a main landing gear tire which caused the pilot to apply excessive brake pressure to avoid departing a narrow landing strip. Contributing to the accident was the pilot accepting an aircraft that had a tire worn beyond safe limits and…NTSB LAX90LA003Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Penn Valley, CAFailure of the pilot to maintain directional control during the landing roll-out, which resulted in an inadvertent ground swerve. Uneven terrain beside the runway was a factor.NTSB ATL90LA003Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Albemarle, NCThe pilot's failure to maintain directional control of the airplane.NTSB NYC90LA003Accident · No injuriesLimited investigationFinal reportCessna 172M · Bennington, VTFailure of the student pilot to maintain directional control during landing. Contributing factor(s) was: the crosswind.NTSB MKC90LA003Accident · No injuriesLimited investigationFinal reportStits-Itrich SA6B · Swan, IAThe pilot's failure to adequately compensate for the gusty crosswind conditions which contributed to the accident.NTSB MIA89LA257Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockledge, FLFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. The gusty crosswind and proximity of the parked aircraft were related factors.NTSB LAX89LA330Accident · No injuriesLimited investigationFinal reportCessna 180 · Flagstaff, AZFailure of the left brake. The pilot's failure to maintain directional control with rudder and tailwheel steering was considered to be a related factor.NTSB LAX89DVA11Accident · 1 fatalFinal reportSkilling VARI-EZE · Oakdale, CAThe pilot's failure to maintain directional control and the delayed initiation of the aborted landing. A factor was lack of aircraft familiarity.NTSB CHI89DEE06Accident · Minor injuriesFinal reportHowe Quickie Q2 · Lakeinthehills, ILThe pilot failed to maintain directional control of the airplane during a bounced landing. A factor related to the accident was the pilot's evasive maneuver to avoid rolling into a stone quarry.NTSB SEA89LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · East Sound, WAThe student pilot's failure to maintain directional control.NTSB LAX89LA320Accident · Minor injuriesLimited investigationFinal reportAir & Space 18A · Palo Alto, CAImproper planning/decision by the instructor pilot (CFI), which resulted in a loss of control as the gyroplane went into ground resonance.NTSB DCA89MA074Accident · 2 fatalClass 1 · MajorFinal reportBoeing 737-400 · Flushing, NYThe captain's failure to exercise his command authority in a timely manner to reject the takeoff or take sufficient control to continue the takeoff, which was initiated with a mistrimmed rudder. Also causal was the captain's failure to detect the mistrimmed…NTSB CHI89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Ypsilanti, MIThe failure of the plt to maintain directional control during the takeoff ground roll. Rain softened terrain adjacent to the runway surface is a contributing factor to the accident.NTSB CHI89LA184Accident · No injuriesLimited investigationFinal reportDouglas DC-3A · Columbus, INThe co-pilot's failure to relinquish control of the aircraft to the pilot-in-command after encountering directional control difficulties during roll-out, and excessive braking by the co-pilot.NTSB LAX89DUJ10Accident · Serious injuriesFinal reportAyres S-2R · Yuma, AZThe failure of the pilot to maintain directional control after landing on a dry gravel runway.NTSB MIA89IA249Incident · No injuriesIncident investigationFinal reportPiper PA-28-161 · Fort Pierce, FLThe student's failure to maintain directional control of the airplane. Contributing to the accident was the student's lack of experience.NTSB LAX89LA308Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAThe pilot's failure to maintain directional control during landing roll-out, which resulted a ground swerve. The pilot's relatively low level of flying experience and the berm beside the runway were related factors.NTSB FTW89LA164Accident · No injuriesLimited investigationFinal reportCessna 140A · Austin, TXThe pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.NTSB ANC89LA166Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle City, AKPilot failed to maintain directional during the landing roll.NTSB SEA89LA168Accident · No injuriesLimited investigationFinal reportCessna R182 · Jordan Valley, ORFailure of the pilot to maintain directional control. Factors related to the accident were: the pilot's selection of unsuitable terrain (closed/rough runway), and the crosswind.NTSB DEN89LA225Accident · No injuriesLimited investigationFinal reportCessna 170 · Cortez, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop.NTSB ATL89LA211Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Screven, GAFailure of maintenance personnel to correct right brake adjustment problems during brake repairs which led to a failure of the right brake, and the pilot's delay in taking remedial action to correct the veering initiated by the brake failure.NTSB LAX89DVG10Accident · No injuriesFinal reportMinicab Hawk · Montaque, CAThe failure of the pilot to maintain directional control after landing.NTSB ANC89LA161Accident · No injuriesLimited investigationFinal reportCessna 180 · Yakataga, AKThe pilot failed to maintain directional control and inadvertently allowed the aircraft to ground loop. The tailwind was a contributing factor.NTSB DEN89LA212Accident · No injuriesLimited investigationFinal reportCessna 172N · Burlington, COImproper use of the rudder by the pilot, which resulted in a loss of directional control. The soft terrain was a related factor.NTSB FTW89LA162Accident · No injuriesLimited investigationFinal reportCessna 172K · Midlothian, TXThe failure of the pilot to compensate for the crosswind condition, which resulted in a loss of directional control and collision with a tree.NTSB FTW89DQG06Accident · Minor injuriesFinal reportCessna T188C · Levelland, TXA partial brake system failure due to a leak in the left brake master cylinder.NTSB DEN89LA207Accident · No injuriesLimited investigationFinal reportCessna C-150 · Platteville, COPilot's failure to compensate for the wind conditions and his failure to maintain directional control during the landing roll. Contributing to the accident was the gusting crosswind.NTSB NYC89LA211Accident · No injuriesLimited investigationFinal reportCessna 150M · Colts Neck, NJFailure of the pilot to maintain directional control during a rough field takeoff. Contributing factor(s) was: the crosswind and he sunglare in the pilot's eyes.NTSB LAX89LA299Accident · No injuriesLimited investigationFinal reportCessna 150M · Riverside, CAThe student pilot's failure to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's lack of recent experience and improper training by her flight instructor.