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 NYC03LA091Accident · No injuriesLimited investigationFinal reportCessna 172K · Burnham, PAThe pilot's failure to maintain directional control during the takeoff roll.NTSB CHI03LA115Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Romeoville, ILThe pilot not maintaining directional control during the landing rollout. A factor to the accident was the gusting crosswind.NTSB FTW03LA144Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Houston, TXThe pilot's failure to maintain directional control while landing.NTSB LAX03LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182P · North Las Vegas, NVThe pilot's inadequate compensation for the gusty cross wind conditions and failure to maintain directional control.NTSB SEA03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Marion, MTThe pilot-in-command's failure to maintain directional control during the takeoff roll resulting in the aircraft leaving the runway, crossing a ditch and collapsing the landing gear. A contributing factor was the ditch.NTSB CHI03LA111Accident · No injuriesLimited investigationFinal reportCessna 150F · Three Rivers, MIThe directional control not maintained by the student pilot. The student pilot's lack of experience was a contributing factor.NTSB CHI03LA110Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Ironwood, MIThe pilot's inadvertent ground loop on landing. A contributing factor was the ditch.NTSB ANC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Palmer, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in an inadvertent ground loop and collapse of the left main landing gear.NTSB LAX03LA140Accident · No injuriesLimited investigationFinal reportCessna 180J · Angwin, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control of the airplane during the landing roll.NTSB FTW03LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Pecos, TXThe failure of the pilot to maintain aircraft control while landing. A contributing factor was the gusty wind condition.NTSB DEN03FA070Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe flight crew's failure to maintain aircraft control, which resulted in engine start with the throttles advanced and the subsequent impact with the tug. Contributing factors include, the flight crew's improper procedures/directives and failure to…NTSB DEN03LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kemmerer, WYthe pilot's failure to maintain directional control and his inadequate compensation for wind during the landing roll which resulted in a ground loop/swerve and impact with terrain. Contributing factors include the wind gust and the ditch.NTSB ANC03LA045Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dillingham, AKThe pilot's inadequate compensation for wind conditions while taxiing for takeoff, which resulted in a loss of control and an on ground encounter with ocean water. A factor associated with the accident was a gusty wind condition.NTSB FTW03LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Batchelor, LAThe pilot's failure to abort the takeoff with adequate runway available. A contributing factor was the high density altitude.NTSB DEN03LA080Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Watkins, COthe pilot's failure to maintain directional control of the aircraft during the landing roll out. Contributing factors were the unlocked tailwheel.NTSB ATL03LA079Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75L3 · Gainesville, GAThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.NTSB SEA03LA062Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Florence, ORPilot's failure to maintain directional control during the landing roll. Factors include rough terrain.NTSB NYC03LA084Accident · No injuriesLimited investigationFinal reportMaule M4 · Danielson, CTThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB NYC03LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control. Factors in the accident were the crosswind and landing at night.NTSB LAX03LA136Accident · No injuriesLimited investigationFinal reportCessna 177RG · Redding, CAThe pilot's improper engine starting procedures, and his failure to maintain clearance with a parked airplane, resulting in a collision with the parked and unoccupied airplane.NTSB CHI03LA102Accident · No injuriesLimited investigationFinal reportCessna 172S · Grayslake, ILThe flight instuctor's improper in-flight decision to land with a tailwind and failure to maintain directional control of the airplane during landing. Factors contributing to the accident were the tailwind, the student pilot's inadequate flare, and the muddy…NTSB ATL03LA076Accident · No injuriesLimited investigationFinal reportLarry Woods Venture · Fort Payne, ALThe pilot's failure to maintain directional control during the landing roll.NTSB SEA03LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lexington, ORThe pilot's inadequate compensation for the cosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.NTSB DEN03LA064Accident · No injuriesLimited investigationFinal reportCessna 182G · Truth or Conseq, NMthe pilot's failure to maintain directional control during landing roll which resulted in impact with terrain. Contributing factors include, the pilot's improper in-flight planning/decision making, the crosswind and gusty wind conditions, the ditch, and the…NTSB NYC03LA077Accident · No injuriesLimited investigationFinal reportWaco YOC · Allentown, PAThe pilot's failure to maintain directional control while landing which resulted in a ground loop. A factor in the accident was the crosswind.NTSB MIA03CA093Accident · No injuriesData collectionFinal reportBoeing A75N1 · Lakeland, FLThe pilot's failure to maintain control during the landing rollout which resulted in the airplane exiting the runway, impacting a runway light, and nosing over.NTSB NYC03LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Taunton, MAThe pilot's inadequate compensation for the winds, and his failure to maintain airspeed which resulted in the inadvertent stall. A factor in the accident was the tailwind.NTSB MIA03CA086Accident · Minor injuriesData collectionFinal reportMathews Pegazai · Lakeland, FLThe failure of the pilot to maintain directional control and his inadequate compensation for wind.NTSB MIA03CA083Accident · No injuriesData collectionFinal reportCessna 190 · Lakeland, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control. A related factor was the crosswind.NTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.NTSB MIA03LA082Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tavernier, FLThe control interference by the pilot-rated passenger in an attempt to avoid an obstacle, which resulted in a loss of control.NTSB DEN03LA060Accident · No injuriesLimited investigationFinal reportCessna 170A · Hobbs, NMthe pilot's failure to maintain aircraft directional control during takeoff roll. A factor was the runway light's cement foundation.NTSB MIA03CA091Accident · No injuriesData collectionFinal reportMaule M-5-235C · Jay, FLThe failure of the pilot to perform a go-around after bouncing following touchdown, resulting in the airplane nosing over during the landing roll.NTSB ATL03LA069Accident · No injuriesLimited investigationFinal reportCessna 310 · Dyersburg, TNThe pilot's failure to maintain directional control during landing roll. A factor was muddy terrain conditions.NTSB NYC03LA073Accident · No injuriesLimited investigationFinal reportCessna 150G · Medina, OHThe pilot's failure to follow published procedures while starting the engine, and his failure to maintain control of the airplane.NTSB NYC03LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot under instruction's failure to maintain directional control, and the flight instructor's delayed remedial action.NTSB NYC03LA069Accident · Minor injuriesLimited investigationFinal reportBell 47D · Princetown, NYThe student's failure to maintain control while executing a takeoff to a hover, and the flight instructor's delayed remedial action. A factor in the accident was the muddy ground.NTSB LAX03LA118Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Mammoth Lakes, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll. A factor was the gusty crosswind.NTSB LAX03LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAthe pilot's failure to maintain directional control during an aborted landing. A contributing factor is the pilot's improper recovery from a bounced landing.NTSB DEN03LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control during aborted landing. Contributing factors include the crosswind component, and the snow covered muddy terrain.NTSB CHI03LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Owatonna, MNThe pilots loss of directional control on landing and subsequent collision with terrain. Contributing factors were the crosswind, the airport lights, and the ditch.NTSB IAD03LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Honesdale, PAThe pilot's failure to maintain directional control while landing. A factor was the crosswind.NTSB DEN03LA058Accident · No injuriesLimited investigationFinal reportAviat A-1B · Englewood, COthe pilot's failure to maintain directional control of the airplane, resulting in an inadvertent ground loop. A contributing factor was the gusty winds.NTSB LAX03LA112Accident · No injuriesLimited investigationFinal reportCessna 172R · Thermal, CAthe student pilot's failure to use aileron controls to compensate for the known crosswind and failure to maintain directional control during the landing rollout.NTSB NYC03LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Linden, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Factors in the accident were the crosswind and the snowbank.NTSB FTW03LA108Accident · No injuriesLimited investigationFinal reportWaco UKS-7 · El Paso, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the crosswind.NTSB ATL03LA058Accident · No injuriesLimited investigationFinal reportCessna 172 M · Collegedale, TNThe student pilot's failure to maintain directional control, which resulted in a loss of control, impact with terrain and subsequent nose over.NTSB NYC03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · South Woodstock, CTThe pilot's failure to maintain directional controlNTSB CHI03LA091Accident · No injuriesLimited investigationFinal reportAviat A-1 · Cahokia, ILThe pilot’s inadequate compensation for wind and his failure to maintain directional control of the airplane which resulted in a ground loop. A factor associated with the accident was the gusty crosswind condition.NTSB CHI03LA081Accident · No injuriesLimited investigationFinal reportCessna 180K · St Charles, MOThe pilot's inadequate compensation for wind and his failure to maintain directional control resulting in a ground loop. A factor was the crosswind.