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 CHI89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILInadequate compensation for wind conditions by the student pilot and his failure to maintain directional control. The crosswind and the student's lack of total experience were contributing factors.NTSB BFO89LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing factors were the slight crosswind and the pilot's lack of experience.NTSB ATL89LA134Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Millersburg, OHThe pilots failure to compensate for the gusty wind conditions during landing.NTSB ANC89LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI89LA076Accident · No injuriesLimited investigationFinal reportWaco YMF · Lansing, MIPilot's failure to maintain directional control during the landing roll, and his excessive brake application as the aircraft departed the runway, which resulted in the aircraft nosing over. The pilot's inexperience in taildragger aircraft, and the inadequate…NTSB ATL89LA132Accident · No injuriesLimited investigationFinal reportCessna 172F · Elkin Arpt., NCThe failure of the pilot to properly compensate for the gusty wind conditions during takeoff and the delay in his decision to abort the takeoff before colliding with trees. Contributing to the accident were the gusty wind conditions and the pilot's lack of…NTSB ANC89LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB FTW89DRA04Accident · No injuriesFinal reportAir Tractor AT-502 · Ganado, TXLoss of directional control for an unknown reason.NTSB DEN89LA111Accident · No injuriesLimited investigationFinal reportCessna 170A · Kalispell, MTThe pilot's failure to maintain control of the airplane during the landing flare and rollout. Contributing to the accident was the pilot's lack of proficiency with only 4 hours of flight time in the preceding 90 day period.NTSB DEN89LA110Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Kindred, NDThe pilot's failure to compensate for the wind conditions during the takeoff. Contributing to the accident were the crosswind conditions.NTSB CHI89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INThe student pilot's failure to compensate for the crosswind condition and maintain directional control during the landing. The airplane departed the runway and nosed over in soft terrain. Contributing to the accident was the student's lack of recent…NTSB MIA89LA130Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Lakeland, FLThe pilot's failure to maintain directional control, which resulted in an inadvertent ground loop.NTSB DEN89LA107Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Aurora, COThe inadequate compensation for wind conditions by the pilot. Lack of recent experience in the type of aircraft is considered a contributing factor.NTSB LAX89LA156Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Scottsdale, AZThe pilot's loss of directional control of the airplane during the ground run and abrupt rotation to get airborne.NTSB DEN89LA106Accident · No injuriesLimited investigationFinal reportCessna A188B · Rapelje, MTThe inadequate compensation for the wind conditions by the pilot which resulted in a loss of directional control on landing and subsequent collision with a ditch.NTSB LAX89LA153Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Livermore, CADirectional control not maintained by the pilot. Unfavorable wind, high wind, and gusts were contributing factors.NTSB DEN89LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Devils Lake, NDInadequate compensation for wind conditions by the pilot, which resulted in loss of directional control and an inadvertent ground loop/swerve. Contributing factors were: the crosswind and the pilot's lack of familiarity with the aircraft.NTSB NYC89LA112Accident · No injuriesLimited investigationFinal reportChampion 8KCAB · Manchester, NHThe loss of control and collision with a parked aircraft due to the inadvertent application of the throttle that took place as the pilot was fastening the over the shoulder safety harness while warming the engine in preparation for departure.NTSB MIA89LA120Accident · No injuriesLimited investigationFinal reportCessna 172M · Columbia, MSThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. A factor related to the accident was: the gusty/crosswind condition.NTSB CHI89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Allegan, MIImproper use of flight controls by the student pilot, which resulted in his loss of directional control and an inadvertent ground swerve; and the instructor pilot's (cfi's) inadequate supervision. Factors related to the accident were: the crosswind condition,…NTSB CHI89LA066Accident · No injuriesLimited investigationFinal reportCessna 170B · Freedom, WIThe pilot's failure to maintain directional control during the attempted takeoff on unsuitable terrain. The pilot's lack of recent flight experience was a contributing factor.NTSB DEN89LA096Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, COThe pilot's inadequate compensation for wind conditions, failing to maintain directional control, and inadvertent ground swerve. Gusty crosswinds contributed to the accident.NTSB FTW89LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Contributing factors were: inadequate supervision by the CFI, who authorized the 2nd solo flight in unfavorable wind conditions, the…NTSB SEA89LA062Accident · No injuriesLimited investigationFinal reportCessna 185 · Everett, WAThe failure of the pilot to maintain directional control of the tailwheel aircraft during landing roll.NTSB DEN89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Great Falls, MTThe failure of the pilot in compensate adequately for wind conditions, and landing despite having been alerted to wind conditions.NTSB ATL89DLG01Accident · No injuriesFinal reportUpchurch Rotorway Executive · Lugoff, SCImproper evaluation of existing conditions during preflight inspection resulting in a dynamic rollover due to drag from an imbedded left skid.NTSB ANC89LA054Accident · No injuriesLimited investigationFinal reportCessna 180-A · Skwentna, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run. A contributing factor to the accident is the pilot's selection of an unsuitable landing/takeoff site.NTSB BFO89LA025Accident · No injuriesLimited investigationFinal reportCessna 170A · Ravenswood, WVThe pilots decision to land with a tailwind and inadequately compensating for the wind conditions.NTSB MIA89LA112Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Marathon, FLThe pilot failed to maintain directional control of the aircraft and inadvertently allowed it to ground loop. Crosswind was a contributing factor.NTSB NYC89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honesdale, PAThe loss of directional control by the pilot during landing.NTSB NYC89LA100Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Lakewood, NJThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the crosswind conditions.NTSB LAX89LA125Accident · No injuriesLimited investigationFinal reportBell 206B · Corona, CAImproper operation of the cyclic by the student pilot, failure of the student to relinquish control and inadequate supervision by the flight instructor.NTSB DEN89LA087Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Broomfield, COPilot's failure to properly control the aircraft while conducting a crosswind takeoff.NTSB ATL89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tiffin, OHThe pilots improper recovery from a bounced landing which led to inadvertent porpoising and loss of directional control.NTSB MIA89LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and ditch were contributing factors.NTSB SEA89LA055Accident · Minor injuriesLimited investigationFinal reportCessna TU206-G · Reno, NVThe pilot's failure to adequately compensate for crosswinds. Contributing to the accident was the pilot's decision to land the amphibious aircraft in strong crosswind conditions.NTSB MKC89LA077Accident · No injuriesLimited investigationFinal reportJennings Pietenpol Aircamper · Lincoln, NEFailure of the pilot in command to adequately preflight the aircraft resulting in a front cockpit seat cushion interfering with the rudder pedals and brakes.NTSB DEN89LA086Accident · No injuriesLimited investigationFinal reportCessna 182 · Tooele, UTInadequate compensation for wind conditions by the pilot which resulted in loss of directional control and inadvertent ground swerve. The quartering crosswind, gusts, and lack of pilot experience were contributing factors.NTSB LAX89LA122Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Fullerton, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB MKC89LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Cresco, IAFailure of the pilot to maintain control of the airplane during the landing on a closed runway.NTSB CHI89LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Superior, WIFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were the icy and snow covered runway conditions and the snowbank.NTSB LAX89LA124Accident · No injuriesLimited investigationFinal reportCessna 182L · Upland, CAThe pilot failed to correct the attitude of the aircraft and achieve proper alignment with the runway prior to landing touchdown.NTSB ANC89FA048Accident · No injuriesField investigationFinal reportCessna U-206G · Anchorage, AKThe pilot's and company's disregard of hazardous weather conditions and the pilot's failure to maintain control of the airplane. Contributing to the accident were the gusty crosswind conditions.NTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.NTSB SEA89LA051Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Albany, ORThe failure of the student pilot to maintain directional control of the airplane during landing and the improper use of flight controls. Contributing to the accident were the crosswind and the pilot's lack of total experience.NTSB LAX89DUJ05Accident · Serious injuriesFinal reportWarwick Thorp T-18 · Aguila, AZFailure of the pilot to maintain directional control, which resulted in the aircraft veering off the runway. Factors related to the accident were: uneven runway & the ditch.NTSB ANC89LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe pilot's failure to maintain directional control during a touch and go landing. A contributing factor is the pilot's lack of total flight experience.NTSB CHI89LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Stevens Point, WIFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.NTSB DEN89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COFailure of the dual student to maintain directional control and the failure of the pilot in command (CFI), to provide adequate remedial action in a timely manner, to correct the swerve. A second probable cause was the cfi's failure to provide adequate…NTSB DEN89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe failure of the pilot to correct a ground loop swerve. A lack of total flight experience is considered to be a contributing factor.