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 DEN89LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Boulder, COInadequate compensation for wind conditions by the (private rated) dual student and his failure to maintain directional control, which resulted in an inadvertent ground swerve, and inadequate supervision by the instructor pilot (CFI). A factor related to the…NTSB ANC89LA098Accident · No injuriesLimited investigationFinal reportCessna 182A · Tyonek, AKSelection of unsuitable terrain by the pilot. Probable contributing factors were the soft sand and the pilot's delay in aborting the takeoff.NTSB ANC89LA095Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKLoss of directional control by the pilot & inadvertent ground loop/swerve of the aircraft during the landing.NTSB MKC89LA139Accident · No injuriesLimited investigationFinal reportCessna A185F · Int'L Falls, MNThe pilot's inability to maintain aircraft control after encountering a strong gust of wind during the landing flare/touchdown.NTSB ANC89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Alder Creek, AKSelection of unsuitable terrain (unimproved strip) by the pilot. Soft/uneven terrain & low bushes on the strip, as well as alders beside the strip, were contributing factors.NTSB DEN89LA139Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Bullfrog, UTThe pilot failed to compensate for wind conditions during the landing roll. The crosswind was considered as a contributing factor. An underlying factor to the accident was the pilot's lack of experience in performing crosswind landings in the Cessna 180.NTSB SEA89LA112Accident · No injuriesLimited investigationFinal reportCessna TU206G · Las Vegas, NVThe loss of directional control as a result of gusting wind conditions.NTSB NYC89LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Pittsburgh, PALoss of control during landing rollout due to excessive application of brakes by the pilot.NTSB MKC89LA133Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Ceour, MOThe failure of the pilot to plan the approach and maintain alignment with the sod landing strip. The pilot's innattention to the grass strip resulted in a landing in a soft wheat field.NTSB SEA89LA107Accident · No injuriesLimited investigationFinal reportCessna 180F · Reno, NVThe pilot's failure to maintain directional control during landing.NTSB ANC89FA091Accident · No injuriesField investigationFinal reportde Havilland DHC-2 · Anchorage, AKFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.NTSB SEA89LA106Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Longbranch, WAThe poor in-flight decision by the pilot to land on water, downwind. His failure to compensate for the wind conditions resulted in a loss of control and nose over of the airplane.NTSB ANC89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-100 · Knik River, AKThe failure of the pilot-in-command to maintain control of the airplane on the ground by proper use of the flight controls during gusting winds.NTSB MKC89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Ft Leavenworth, KSThe student pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing to the accident was the student's lack of total experience.NTSB SEA89LA101Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Vancouver, WAThe pilot's failure to maintain directional control during landing ground roll, resulting in a ground loop and nose over. The crosswind is considered to be a contributing factor to the accident.NTSB MKC89LA126Accident · Serious injuriesLimited investigationFinal reportOlson BD-4 · Cedar Rapids, IAPremature lift-off and inadvertent stall by the pilot. A loss of directional control and an inadvertent ground swerve by the pilot were contributing factors.NTSB MIA89LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's failure to maintain directional control during landing.NTSB NYC89LA145Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Erwinna, PALoss control and collision with trees due to failure of the student pilot to compensate for the wind and lack of supervision by the CFI.NTSB ATL89LA156Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Myrtle Beach, SCThe improper installation/modification of the banner tow system, which jammed the rudder during a landing. The wind and terrain conditions were related factors.NTSB CHI89LA102Accident · No injuriesLimited investigationFinal reportCessna 206 · Flushing, MIPilot's inadequate aircraft control during the aborted takeoff attempt, and the aircraft's resultant collision with trees. The wet runway was a factor in the lack of normal braking action.NTSB MKC89LA121Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Snow Lake, ARThe selection of unsuitable terrain to takeoff from by the pilot and the inadequate runway maintenance by airport personnel. Contributing to the accident was the hidden hole which the airplane contacted resulting in the pilot's inability to control the…NTSB MIA89LA163Accident · No injuriesLimited investigationFinal reportCessna 150L · Jacksonville, FLThe pilot's failure to have someone operate the airplane's brakes and engine controls during hand propping the engine.NTSB ANC89LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilots failure to maintain directional control of the aircraft during a touch and go landing which resulted in a ground loop.NTSB DEN89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rangely, COImproper planning/decision by the pilot. The high wind, gusts, the pilot's lack of recent experience, and his lack of familiarity with the aircraft's new handling characteristics were considered to be contributing factors.NTSB NYC89LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oneonta, NYThe pilot lost control of the aircraft while landing in gusty wind conditions.NTSB MIA89LA160Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Fort Lauderdale, FLFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and the pilot's improper use of brakes were contributing factors.NTSB LAX89LA205Accident · No injuriesLimited investigationFinal reportCessna 190 · Livermore, CAThe failure of the flight instructor to maintain directional control. Contributing to the accident was the flight instructors lack of experience in this type aircraft.NTSB MKC89LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Duluth, MNThe failure of the pilot to maintain control of the aircraft while attempting to land in turbulent gusty wind conditions.NTSB MIA89IA156Incident · No injuriesIncident investigationFinal reportTemco GC-1B · Crestview, FLFailure of the pilots to maintain directional control of the aircraft. Contributing to the incident was the crosswind and lack of brakes avialable to the pilot-in-command (PIC).NTSB FTW89DRD04Accident · No injuriesFinal reportSchweizer G-164A · Oak Grove, LAThe pilot failed to perform adequate prelight planning/preparation before attempting a takeoff by failing to assure the runway condition.NTSB SEA89LA090Accident · No injuriesLimited investigationFinal reportStits SA-3A · Jackpot, NVInadequate wind compensation by the pilot. Contributing to the accident were gusty grosswinds.NTSB FTW89LA094Accident · No injuriesLimited investigationFinal reportCessna 177B · Harrah, OKFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve; and his improper planning/decision (indecision) concerning an attempted go-around. The pilot's lack of experience in the type of aircraft…NTSB ANC89LA074Accident · No injuriesLimited investigationFinal reportGrumman G21 · Togiak, AKInadequate compensation for wind conditions by the pilot, which resulted in a loss of directional control. A factor related to the accident was: the gusty crosswind condition.NTSB DEN89LA125Accident · No injuriesLimited investigationFinal reportChampion 7EC · St George, UTInadequate compensation for the wind conditions by the pilot. The gusty crosswind, soft terrain, and ditch were contributing factors.NTSB LAX89LA195Accident · No injuriesLimited investigationFinal reportBeech 23 · Glendale, AZThe pilot's failure to execute a go around in a timely manner. The delay in aborting the landing precluded the airplane from accelerating to a climb airspeed before colliding with a fence.NTSB CHI89LA088Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 · Big Rapids, MIInadequate compensation for wind conditions by the pilot and his failure to maintain directional control. The the variable/gusty/crosswind condition was considered to be a contributing factor.NTSB MKC89FA109Accident · Serious injuriesField investigationFinal reportBensen B-8KSB · Eldon, MOPilot's failure to maintain aircraft control which resulted in collision with the terrain during take off.NTSB CHI89LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Terre Haute, INPilot's inability to maintain directional control during the takeoff roll. A factor in the accident was the crosswind.NTSB MKC89LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Moberly, MOThe failure of the pilot in command to maintain control of the aircraft while on takeoff ground run. Contributing to this lack of control were wind gusts from dust devils in the area, thermal activity, and the pilot's lack of experience.NTSB LAX89LA196Accident · No injuriesLimited investigationFinal reportCessna 175A · Mojave, CAInadequate preflight planning/preparation, and the pilot's disregard of the wind information.NTSB ANC89FA070Accident · No injuriesField investigationFinal reportCessna C-402 · Tatitlek, AKInstallation of the improper washer on the scissors assembly of the left main landing gear. The extra forces encounteredon a gravel runway were sufficient to pull the bushing, washer, and bolt through the scissors assembly and allowing the lower half to pivot…NTSB MKC89LA105Accident · No injuriesLimited investigationFinal reportWeatherly 620TP · Montrose, ARFailure of the pilot in command to maintain control of the aircraft during landing adversely affected by the existance of a tailwind of average proportions.NTSB DEN89LA116Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Deming, NMThe pilot's failure to maintain directional control during the takeoff ground run, resulting in a loss of control and collision with the terrain. The lack of experience in this type of aircraft is considered to be a factor.NTSB LAX89LA179Accident · No injuriesLimited investigationFinal reportCessna 180 · Cottonwood, AZImproper flight planning/decision by the PIC when he decided to land with such a crosswind, and not maintaining compensation for the crosswind after he decided to attempt the landing.NTSB ATL89LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHPilot in command failed to maintain directional control of the aircraft while landing in a gusty crosswind. The crosswind component exceeded the published demonstrated crosswind capability of the airplane.NTSB DEN89LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Bozeman, MTImproper in-flight planning/decision by the pilot which led to his failure to maintain directional control during the landing. Contributing factors were: use of an unfavorable runway, crosswind, and gusts.NTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.NTSB DEN89LA113Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Albuquerque, NMInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during landing roll. Variable and gusting winds are considered a contributing factor.NTSB NYC89LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, VTThe student pilot's failure to maintain directional control of the aircraft.NTSB MIA89LA141Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Smyrna Bch., FLThe failure of the pilot to adequately preflight the airplane. Contributing to the accident was the pilot's failure to use the brakes to maintain directional control and poor inspection of the airplane by company maintenance personnel.