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 FTW94LA072Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student pilot's improper braking technique and the resultant failure to maintain directional control. A factor was the pilot not obtaining an ATC clearance prior to takeoff.NTSB LAX94LA097Accident · No injuriesLimited investigationFinal reportClunis Long EZ · Camarillo, CAthe pilot's improper use of the brake system which resulted in a failure of the right brake due to excessive heat glazing.NTSB ATL94LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Pelion, SCInadequate supervision by the instructor and inadequate compensation for wind conditions by the student pilot. The unfavorable wind condition for supervised solo landing training was a factor.NTSB MIA94FA053Accident · 1 fatalField investigationFinal reportBell 206L3 · Arcadia, FLThe pilot-in-command's improper supervision of an unqualified pilot while attempting a takeoff to a hover. This resulted in an on ground loss of control (dynamic roll over). The improper flight control input (cyclic and collective) by the unqualified pilot…NTSB LAX94LA095Accident · No injuriesLimited investigationFinal reportCessna T210L · California Valy, CAThe pilot's failure to maintain directional control of the aircraft and the instructor's inadequate supervision of the flight.NTSB CHI94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Dowagiac, MIwas the pilot not maintaining directional control during the takeoff ground roll. Factors related to the accident were the icy, snow covered runway and poor preflight planning/preparation.NTSB FTW94LA064Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB-180 · Colo. Springs, COAn inadvertent stall during initial climb following takeoff. A factor was failure by the pilot to maintain directional control.NTSB CHI94LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Casselton, NDthe student's failure to attain proper runway alignment and to maintain directional control. A factor related to the accident was the snow covered runway.NTSB SEA94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Missoula, MTThe pilot/passenger's failure to maintain directional control and the pilot in command's failure to properly supervise the landing.NTSB FTW94LA066Accident · No injuriesLimited investigationFinal reportCessna 195 · Watkins, COThe loss of directional control by the pilot rated passenger. A factor was inadequate supervision by the pilot in command.NTSB NYC94LA046Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Richmond Height, OHThe pilot's loss of directional control during landing, resulting in a departure from the runway and the subsequent encounter with soft terrain and collapse of the nose gear. A factor related to the accident was the icy runway conditions.NTSB FTW94LA062Accident · No injuriesLimited investigationFinal reportCessna 140 · Espanola, NMWas the dual student pilot's failure to maintain directional control. A factor was the certificated flight instructor's inadequate supervision.NTSB CHI94LA055Accident · No injuriesLimited investigationFinal reportCessna 185 · Grand Island, NEthe pilot's failure to maintain directional control of the airplane. A factor related to the accident was the gusty quartering tailwind condition.NTSB CHI94LA065Accident · No injuriesLimited investigationFinal reportCessna 210M · Festus, MOImproper planning/decision by the pilot. Factors related to the accident were: the icy runway, crosswind and snowbank.NTSB CHI94LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Kimball, NEthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the pilot's lack of total flight experience.NTSB ANC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Lions, AKImproper inflight planning and decision-making by the pilot in command. Factors contributing to the accident were the icy runway condition and the tailwind.NTSB LAX94LA070Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Santa Paula, CAA failure of the pilot to maintain directional control of the tailwheel airplane following touchdown. The pilot's lack of total experience in the type of airplane was a factor in the accident.NTSB MIA94LA038Accident · No injuriesLimited investigationFinal reportCessna 650 · Tampa, FLThe pic's improper decision to taxi the airplane off the taxiway. Contributing to the accident was the improper wiring of the anti-skid system.NTSB FTW94LA040Accident · No injuriesLimited investigationFinal reportCessna A185F · Maybell, COThe pilot's failure to ascertain the condition of the landing area. The snow covered condition of the runway was a factor.NTSB ATL94FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mount Airy, NCThe pilot's improper decision to land downwind, failure to control the aircraft on the ground, and his decision to abort the landing after loss of control and damage to the aircraft on the ground. A factor in the accident was the gusty tail wind at the time…NTSB LAX94LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAwas the student pilot's improper use of the rudder. The student pilot's lack of total experience was a factor in this accident.NTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.NTSB FTW94LA024Accident · No injuriesLimited investigationFinal reportBellanca BL17-31ATC · Pagosa Springs, COFailure by the pilot in command to maintain control of the aircraft during landing roll.NTSB CHI94LA030Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Valparaiso, INThe pilot's inadequate compensation for wind conditions while landing in a gusty crosswind. Factors associated with the accident are the gusty crosswind and the pilot's lack of experience in this type airplane.NTSB ANC94LA015Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Goose Bay, AKThe pilot-in-command did not maintain directional control of the airplane. A factor in the accident were the trees adjacent to the side of the runway.NTSB LAX94LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZThe pilot's loss of directional control due to his improper bounced landing recovery technique and the improper use of the rudder controls. A factor in the accident was the pilot's lack of total experience in conventional landing gear aircraft.NTSB NYC94LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Somerset, PAwas the failure of the pilot to adequately compensate for wind conditions, and maintain directional control. A factor related to the accident were the gusting crosswinds.NTSB ATL94LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lexington, NCThe pilot's failure to maintain directional control during a crosswind landing. A factor was the crosswind condition.NTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.NTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.NTSB CHI94LA012Accident · No injuriesLimited investigationFinal reportCessna A188B · Wall, SDFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the type (make and model) of airplane.NTSB LAX94LA008Accident · No injuriesLimited investigationFinal reportStinson 108 · Mesa, AZa loose wheel half bolt, due to the inadequate maintenance inspection of the aircraft.NTSB SEA94LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Renton, WAThe student pilot's failure to maintain directional control during landing. The crosswind was a factor.NTSB ANC94LA009Accident · No injuriesLimited investigationFinal reportDouglas C-54GDC · Point Lay, AKThe pilot-in-command's failure to perform proper preflight planning by not computing the required landing runway length.NTSB MIA94LA002Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Opa-Locka, FLImproper servicing of three of the four main landing gear dampers by company maintenance personnel, and innadequate remedial action by the pilot as ground resonance began.NTSB FTW94LA006Accident · No injuriesLimited investigationFinal reportCessna 310I · Southlake, TXAircraft control not maintained by the private pilot receiving instruction. Factors were rough runway, runway edge lights inoperative, dark night conditions, brakes restricted due to an out of rig rudder system, and inadequate CFI supervision.NTSB CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.NTSB FTW94LA002Accident · No injuriesLimited investigationFinal reportMaule M-5-200C · Watkins, COThe pilot's loss of directional control resulting in the inadvertent ground loop. A factor was the instructor's failure to take remedial action on a timely manner.NTSB ANC94LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pilot Point, AKThe Pilot-in-command's failure to compensate for the crosswind during taxi. The crosswind was a factor.NTSB SEA93LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tooele, UTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the fence.NTSB LAX93LA372Accident · No injuriesLimited investigationFinal reportCryder RV-6 · Ely, NVthe pilot's failure to maintain directional control of his conventional gear airplane after the failure of a main landing gear tire.NTSB BFO93LA183Accident · No injuriesLimited investigationFinal reportCessna 170B · Martinsburg, WVThe pilot's failure to maintain directional control.NTSB ANC93LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Pumice Creek, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors were the pilot misjudged the wind information, and the unfavorable wind.NTSB LAX93LA359Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Hawthorne, CAdual student's failure to maintain directional control and improper use of the rudder and the CFI's inadequate supervision of the flight.NTSB BFO93LA181Accident · No injuriesLimited investigationFinal reportCessna 180H · New Philadelphi, OHThe pilot's failure to maintain directional control of the airplane during landing rollout, subsequently causing the airplane to veer off the runway and groundloop.NTSB ANC93LA180Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Yantarni Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. A factor was the crosswind.NTSB BFO93LA168Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Gilbertsville, KYThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. The crosswind was a related factor.NTSB FTW93LA258Accident · No injuriesLimited investigationFinal reportCessna 180 · Watkins, COThe pilot's improper compensation for shifting winds.NTSB FTW93LA254Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Oak Grove, LADirectional control not maintained by the pilot for undetermined reasons. Factors were a fence and trees.NTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.