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 NYC95LA085Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Tangier Island, VAThe pilot's failure to maintain obstacle clearance which resulted in an inflight collision with a tree. Contributing factors are a crosswind and the pilot's failure to maintain directional control and his inadequate compensation for wind conditionsNTSB LAX95LA160Accident · No injuriesLimited investigationFinal reportCessna 170A · Woodland, CAthe pilot's improper recovery from a bounced landing. The mechanic's inadequate annual inspection by failing to determine the worn condition of the crosswind landing gear detent stop groove and snubber pin and the soft terrain were factors in this accident.NTSB ATL95LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe pilot's failure to adequately compensate for wind conditions during landing, which resulted in a loss of directional control.NTSB LAX95LA156Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZthe pilot's inadequate compensation for the prevailing wind conditions which resulted in an inadvertent ground loop. The crosswind and the pilot's lack of familiarity with the aircraft are factors in this accident.NTSB ANC95LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe flight instructor's inadequate remedial action. Factors include the dual student's failure to maintain directional control, and the rear pilot's station not having brakes installed.NTSB FTW95LA157Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Midland, TXThe pilot's failure to maintain directional control.NTSB ATL95LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Canton, GAThe student pilot's failure to maintain directional control during a crosswind landing.NTSB SEA95LA091Accident · No injuriesLimited investigationFinal reportNorth American SNJ-4 · Prospect, ORThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was wet grass.NTSB SEA95LA075Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Klamath Falls, ORThe pilot-in-command's failure to maintain directional control during takeoff, resulting in a ground loop.NTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.NTSB CHI95LA113Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Higginsville, MOthe pilot's inadequate compensation for wind conditions during the attempted takeoff. The gusty crosswind was a factor.NTSB FTW95LA152Accident · No injuriesLimited investigationFinal reportCessna 195A · Albuquerque, NMA partial failure of the airplane brake system (left brake). A factor was the right quartering tailwind.NTSB MIA95LA095Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Kissimmee, FLThe inadequate annual inspection by a mechanic that failed to detect corrosion that eventually failed the engine mounts and allowed the engine and nosegear to deflect to the side during landing roll.NTSB BFO95LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean City, NJthe private pilot's inadequate compensation for the wind conditions during the landing/aborted landing sequence. Related factors are the unfavorable wind conditions and high obstructions.NTSB BFO95LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Zanesville, OHthe pilot's failure to maintain control of the airplane while taxiing after landing. Related factors were the unfavorable (gusty) wind condition, and the pilot's improper compensation for wind conditions.NTSB NYC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchellville, MDThe pilot's failure to maintain directional control and the instructor's inadequate supervision. Related factors: high winds, and a crosswind.NTSB CHI95LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Table Rock, NEthe pilot's failure to maintain directional control during an aborted takeoff. Factors related to the accident were the crosswind conditions and the berm which the airplane contacted.NTSB ANC95LA042Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe pilot's failure to correct for torque/p factor. The presence of snowberms that narrowed the width of the runway and the pilot's lack of total experience were factors in the accident.NTSB CHI95LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Alma, MIthe flight instructor's inadequate remedial action during the approach to landing/landing roll. Related factors are the flight instructor's inadequate supervision, the dual student's wrong runway selection, the tailwind, and the dual student's failure to…NTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.NTSB CHI95LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · West Fargo, NDthe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor associated with the accident was the soft terrain that the airplane encountered.NTSB NYC95LA072Accident · No injuriesLimited investigationFinal reportCessna 120 · Skaneateles, NYThe student pilot's failure to maintain directional control and his improper use of the brakes.NTSB CHI95LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIthe student pilot's failure to maintain directional control during an aborted takeoff. A factor was the snow covered ground which contributed to the airplane nosing over as it departed the runway.NTSB ANC95LA032Accident · No injuriesLimited investigationFinal reportCessna 185F · Port Alsworth, AKThe pilot's inadvertent activation of the right brake pedal during the landing roll.NTSB LAX95LA122Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · San Jose, CAthe student pilot's failure to maintain directional control of the conventional gear aircraft during an aborted landing attempt. Factors in the accident were the student's high and fast approach and his failure to achieve the proper touchdown point.NTSB SEA95LA057Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Salem, ORThe pilot-in-command's failure to maintain directional control during the landing rollout.NTSB FTW95LA123Accident · No injuriesLimited investigationFinal reportCessna 180J · El Paso, TXThe pilot's failure to maintain directional control during the landing roll.NTSB NYC95LA061Accident · No injuriesLimited investigationFinal reportCessna 172M · West Seneca, NYThe pilot's improper planning/decision to attempt a takeoff on a narrow icy runway with crosswind conditions, which resulted in the loss of control of the airplane, impact with a snow bank, and a nose over.NTSB CHI95LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Owosso, MIthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the snow bank.NTSB CHI95LA092Accident · No injuriesLimited investigationFinal reportCessna 150A · Grant, MIThe student pilot's decision to intentionally land downwind and his failure to maintain directional control of the aircraft during landing roll. The pilot's lack of experience and the tailwind were contributing factors.NTSB FTW95LA118Accident · No injuriesLimited investigationFinal reportCessna 177B · Terlingua, TXThe pilot's failure to maintain directional control. Factors were his decision to land on the unlit runway and the dusk light conditions.NTSB LAX95LA117Accident · No injuriesLimited investigationFinal reportCessna T210F · Phalen, CAthe pilot's decision to continue the flight with a known mechanical discrepancy in the brake system.NTSB DCA95MA020Accident · 3 fatalClass 1 · MajorFinal reportDouglas DC-8-63 · Kansas City, MO(1) The loss of directional control by the pilot in command during the takeoff roll, and his decision to continue the takeoff and initiate a rotation below the computed rotation airspeed, resulting in a premature liftoff, further loss of control and collision…NTSB LAX95LA115Accident · No injuriesLimited investigationFinal reportSkov-Papworth Q2 · Hollister, CAthe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. The pilot's lack of recent experience is a factor in the accident.NTSB LAX95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Corona, CAthe pilot's failure to maintain runway alignment after aborting a takeoff and improper use of the brakes during the abort.NTSB NYC95LA052Accident · No injuriesLimited investigationFinal reportCessna 210L · Dayton, OHThe pilot's inadequate compensation for wind and not attaining directional control which resulted in the airplane impacting a snow bank and nosing over.NTSB SEA95LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Camas, WAInadequate remedial action by the flight instructor after the student lost directional control.NTSB CHI95LA084Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Kenosha, WIthe student's failure to maintain directional control during the landing roll.NTSB LAX95LA134Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Long Beach, CAFailure of the right main tire, and subsequent failure of the pilot to maintain directional control of the airplane. A factor related to the accident was: the pilot's lack of recent flight experience.NTSB LAX95LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Rosamond, CAFailure of the pilot to maintain directional control. Soft terrain beside the runway was a related factor.NTSB LAX95LA095Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Carson City, NVthe pilot's improper use of the brakes.NTSB ANC95LA030Accident · No injuriesLimited investigationFinal reportCessna 185F · W.Point Village, AKA failure of the pilot to maintain directional control of the airplane. The pilot's excessive remedial reaction and lack of total experience in the accident aircraft make and model were factors in the accident.NTSB FTW95LA099Accident · No injuriesLimited investigationFinal reportMBB BO-105S · Cameron 278bThe pilot's failure to remove the tiedoown during the preflight and an inadequate preflight.NTSB LAX95LA085Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesa, AZStudent pilot's failure to maintain proper alignment, his delayed remedial action, and improper use of the flight controls. The student pilot's lack of experience was a factor in this accident.NTSB LAX95LA084Accident · No injuriesLimited investigationFinal reportCessna 195 · Phoenix, AZthe failure of the left main strut due to a pre-existing crack.NTSB LAX95LA083Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Lodi, CAthe pilot's inadequate compensation for the existing crosswind wind condition and his failure to maintain proper alignment with the runway.NTSB ATL95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Meridianville, ALThe failure of the student pilot to maintain directional control of the aircraft.NTSB LAX95LA102Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Wickenburg, AZThe pilot-rated passenger's failure to maintain directional control of the airplane during the takeoff ground roll, and the pilot-in-command's inadequate supervision of the pilot-rated passenger, who had sole access to the airplane's brakes.NTSB ANC95LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiak, AKA failure of the pilot to maintain directional control of the airplane. Icy runway conditions and a lack of a local NOTAM to report the runway condition by local maintenance personnel were factors in the accident.NTSB FTW95LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during a touch-and-go landing.