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 LAX90LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · Redding, CAThe failure of the pilot in command to maintain direction control. Factors in the accident were the pilot in command's premature rotation during the takeoff and the failure to take the necessary remedial action.NTSB SEA90LA093Accident · No injuriesLimited investigationFinal reportCessna TU206G · Elk City, IDThe pilot did not maintain directional control of the airplane during the landing roll. The landing was made on a wet runway with excessive airspeed.NTSB DEN90LA128Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wahpeton, NDInadequate compensation for the wind conditions by the pilot. A factor was a strong cross wind, with gusts.NTSB ANC90LA084Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot failed to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB DEN90LA125Accident · No injuriesLimited investigationFinal reportCessna 188A · Martin, SDThe on-ground loss of control during the takeoff ground run. Contributing to this accident was the pilot's failure to use optimum takeoff flaps for the runway conditions that existed, and the soft wet runway surface.NTSB MIA90LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe improper landing flare by the pilot in command.NTSB FTW90LA113Accident · No injuriesLimited investigationFinal reportLuscombe 11 · Fort Worth, TXLoss of control on the ground, due to a locked left brake, undetermined reasons.NTSB CHI90LA149Accident · No injuriesLimited investigationFinal reportBeech F33A · Port Clinton, OHThe pilot failed to maintain aircraft control after encountering gusty wind conditions during the takeoff roll.NTSB CHI90LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIStudent pilot's failure to maintain directional control while landing in a crosswind. The student's lack of flight experience and the crosswind were factors.NTSB CHI90DEX01Accident · Minor injuriesFinal reportSattler Aeroduster SA750 · Columbus, INFailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The pilot's lack of experience in the airplane was a related factor.NTSB CHI90LA144Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Carbondale, ILThe pilot's inability to maintain directional control during the touchdown and landing roll.NTSB CHI90LA142Accident · No injuriesLimited investigationFinal reportCessna 150F · Holland, MIThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a related factor.NTSB CHI90LA137Accident · No injuriesLimited investigationFinal reportBeech A-23-19 · Stow, OHFailure of the pilot to attain runway alignment and maintain directional control after touchdown. Contributing to the accident was his landing at the wrong airport.NTSB CHI90LA135Accident · No injuriesLimited investigationFinal reportCessna 150F · White Cloud, MIFailure of the pilot to maintain control of the airplane during a landing flare and touchdown. The pilot's lack of total aviation experience is a factor in the accident.NTSB ANC90LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Northway, AKThe pilot lost control of the airplane during the post-landing taxi.NTSB MKC90LA118Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morton, ARThe pilot's failure to maintain directional control due to inadequate compensation for wind conditions.NTSB CHI90LA140Accident · No injuriesLimited investigationFinal reportLet L-13 · Oxford, MIThe glider pilot's failure to maintain adequate aircraft control during the touchdown and landing roll. The poorly executed approach to landing, and rough/uneven terrain were contributing factors in this accident.NTSB LAX90LA188Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeport, CAThe pilot's inadequate compensation for crosswind conditions. The crosswind was a factor in the accident.NTSB MIA90LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Opa-Locka, FLLoss of control during the landing roll due to the instructor pilot's lack of experience in tailwheel equipped aircraft.NTSB DEN90LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sioux Falls, SDThe pilot's loss of directional control during landing roll.NTSB ANC90LA072Accident · No injuriesLimited investigationFinal reportCessna C-140 · Minto, AKUncertificated pilot's failure to become qualified to operate an aircraft and gain the ability to recognize and respond to crosswind situations.NTSB NYC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, NYThe pilot's poor judgement in attempting to land the airplane under the existing wind conditions.NTSB FTW90DQG02Accident · No injuriesFinal reportBellanca BL-DW-1 · Petersberg, TXLoss of directional control as the result of an encounter with a dust devil.NTSB DEN90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Delta, UTThe pilot's loss of directional control during landing. Factors were gusting tailwinds and the pilot selected the wrong runway.NTSB CHI90LA132Accident · Minor injuriesLimited investigationFinal reportCessna 205A · Piqua, OHThe pilot-in-command's inadequate compensation for wind conditions, and his failure to maintain directional control.NTSB ANC90LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Mountain, AKPilot-in-command failed to compensate for gusty wind conditions and control of the aircraft during the take off roll.NTSB SEA90LA078Accident · No injuriesLimited investigationFinal reportCessna 170B · Haines, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the gusty crosswind condition, and pilot fatigue.NTSB LAX90LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe failure of the student pilot to maintain an appropriate airspeed during the attempted go-around.NTSB NYC90LA109Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warehouse Point, CTThe pilot failed to maintain directional control during a landing with a gusty crosswind.NTSB SEA90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Wenatchee, WAThe pilot's failure to maintain directional control during landing.NTSB LAX90LA173Accident · No injuriesLimited investigationFinal reportBeech N35 · Los Banos, CAThe pilot's failure to maintain directional control of the aircraft during the takeoff roll.NTSB CHI90LA133Accident · No injuriesLimited investigationFinal reportChampion 7EC · Hamilton, OHFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve.NTSB MIA90FA117Accident · Minor injuriesField investigationFinal reportHughes 269C · Fort Pierce, FLImproper touchdown during the autorotation by the dual student (ATP), his failure to maintain runway alignment, inadequate supervision by the CFI, and inadequate crew coordination. A factor related to the accident was the obstruction (taxiway light).NTSB SEA90LA073Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Newberg, ORThe pilot did not maintain directional control duing the landing.NTSB MKC90LA104Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Scott, ARPilot in command's failure to maintain directional control during the landing roll. Related to the accident was tall grass and soft terrain.NTSB DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.NTSB ANC90LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot failed to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve.NTSB ATL90LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Hahira, GAThe failure of the right main landing gear tire on landing the failure of the pilot to detect an existing cut on the right main landing gear tire during preflight.NTSB ANC90LA064Accident · No injuriesLimited investigationFinal reportCessna 180C · Anchorage, AKThe pilot failed to maintain directional control of the airplane.NTSB LAX90LA163Accident · No injuriesLimited investigationFinal reportCessna 140 · Paso Robles, CAThe pilot failed to maintain directional control.NTSB MKC90LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ames, IAThe wrong runway was selected and directional control was not maintained by the pilot in command.NTSB NYC90LA101Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Meadville, PALoss of directional control by the pilot during landing. Contributing factor was gusty wind conditions.NTSB CHI90LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Angola, INFailure of the pilot to maintain directional control of the aircraft, while landing in gusty/crosswind conditions. The adverse wind was a related factor.NTSB DEN90LA101Accident · No injuriesLimited investigationFinal reportCessna 172 · Englewood, COThe pilot landed with a tailwind, and cost control of the airplane during rollout.NTSB LAX90LA154Accident · No injuriesLimited investigationFinal reportCessna 120 · Phoenix, AZThe pilot failed to maintain directional control by improperly using the rudders/tall wheel steering.NTSB MKC90LA096Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Thedford, NEThe pilot in command's failure to compensate for wind while landing resulting in loss of directional control and collision with terrain.NTSB MIA90IA109Incident · No injuriesIncident investigationFinal reportBoeing 707-321B · Miami, FLThe airplane's aft CG limit had been exceded due to improper weighing procedures.NTSB LAX90LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Stockton, CAThe failure of the pilot to maintain control of the aircraft.NTSB DEN90LA096Accident · No injuriesLimited investigationFinal reportCessna 170B · Englewood, COThe pilot's failure to maintain directional control of the airplane during the landing. The crosswind condition was a factor related to the accident.NTSB BFO90LA037Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Prnc Frederick, MDThe pilot's improper planning/decision by not shutting down the engine or assuring the helicopter was properly attended,when he deplaned.