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 LAX98LA150Accident · No injuriesLimited investigationFinal reportPitts S-2B · Greenfield, CAThe pilot's failure to maintain directional control. A related factor was the proximity of high brush located on both sides of the runway.NTSB MIA98LA139Accident · No injuriesLimited investigationFinal reportBeech 58 · Tampa, FLThe pilot's failure to maintain runway alignment during touchdown.NTSB CHI98LA132Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tecumseh, MIThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control. A contributing factors were wind gusts and crosswind.NTSB FTW98LA181Accident · No injuriesLimited investigationFinal reportWaxenfelter Thorp T-18 · Morrilton, ARThe pilot's failure to maintain directional control during landing roll.NTSB FTW98LA180Accident · No injuriesLimited investigationFinal reportCessna A152 · Brigham City, UTfailure of the pilot to maintain directional control of the airplane during a touch and go landing. Related factors were: the pilot allowed his attention to be diverted into the cockpit for an excessive amount of time, and the encounter with a ditch.NTSB FTW98LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain directional control during landing. A factor was the pilot's lack of total experience in the make and model of aircraft.NTSB SEA98LA057Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Glendive, MTThe pilot's delayed remedial action and his inadvertent entry into a ground loop.NTSB CHI98LA112Accident · No injuriesLimited investigationFinal reportCessna 310J · Hutchinson, KSthe flight instructor's inadequate supervision by failing to ensure that the right throttle had been retarded before re-advancing the right mixture control, which resulted in a loss of directional control, an encounter with soft terrain, and damage to the…NTSB MIA98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCthe pilot-in-command's failure to maintain directional control after landing.NTSB NYC98LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTThe pilot's inadequate crosswind compensation.NTSB ATL98LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hampton, GAThe pilot's failure to maintain directional control during a full stop landing roll.NTSB NYC98LA084Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, NJThe pilot in commands improper recovery from a bounced landing.NTSB IAD98LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Red Hook, NYinadequate compensation for the crosswind by the pilot, and his failure to maintain directional control during the landing. Related factors were: the gusty crosswind condition, and high vegetation that was encountered after departing the runway.NTSB SEA98LA053Accident · No injuriesLimited investigationFinal reportCessna 150G · Hailey, IDA fractured nosewheel steering linkage bolt, which permitted the nosewheel steering linkage to become disconnected, and the student pilot's subsequent failure to restore directional control by use of differential wheel braking.NTSB ANC98LA030Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions during landing. A factor was the crosswind.NTSB NYC98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Weyers Cave, VAthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing roll, which resulted in an encounter with a fence on uneven terrain and a nose over.NTSB CHI98LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Jeffersonville, INthe pilot's failure to maintain directional control. The crosswind was a factor.NTSB ANC98LA028Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot-in-command's decision to relinquish controls to the student pilot in the left seat during practice landings, and the pilot-in-command's failure to maintain directional control. A factor contributing to this accident was the pilot-in-command's lack…NTSB ANC98LA027Accident · No injuriesLimited investigationFinal reportCessna A185F · Homer, AKThe pilot's failure to maintain directional control. Factors in the accident are the sheared valve stem/deflation of the tire, and subsequent fracturing of the associated wheel.NTSB ATL98LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The gusty crosswind condition was a related factor.NTSB ATL98LA057Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAthe pilot's inadequate compensation for wind conditions and excessive application of braking action, which resulted in an on-ground loss-of-control and a nose over. Related factors were: the pilot's selection of the wrong runway, and the crosswind condition.NTSB ANC98LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Mcgrath, AKThe pilot's failure to maintain directional control after landing. Factors associated with the accident are the presence of snow covered terrain, a tree, and the pilot's selection of an unsuitable landing area.NTSB MIA98LA099Accident · Minor injuriesLimited investigationFinal reportPitts S1-S · Zephyrhills, FLthe pilot's improper use of flight controls (ailerons) during a touch-and-go landing with a crosswind, resulting in a loss of directional control and subsequent nose over of the airplane. A factor relating to the accident was: the pilot's lack of total…NTSB ANC98LA024Accident · No injuriesLimited investigationFinal reportCessna 180H · Tatitna, AKThe pilot's selection of unsuitable terrain for landing. A factor was the snow machine ruts creating a rough landing surface.NTSB LAX98LA100Accident · No injuriesLimited investigationFinal reportRyan PT22-ST3KR · Davis, CAThe failure of the pilot to maintain directional control of the aircraft on the landing roll.NTSB FTW98LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Rayville, LAThe pilot's inadequate compensation for the gusting crosswinds. Factors were the gusting crosswinds and the pilot's lack of experience in gusting crosswinds.NTSB MIA98LA090Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Raymond, MSthe pilot passenger's impairment of judgment and performance due to alcohol, and control interference by the pilot passenger, which resulted in a loss of aircraft control and subsequent in-flight collision with the runway and trees.NTSB LAX98LA094Accident · No injuriesLimited investigationFinal reportPiper J3 · Chandler, AZThe pilot's failure to maintain directional control of the airplane.NTSB SEA98LA036Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Bozeman, MTThe pilot's failure to maintain directional control during takeoff.NTSB LAX98LA087Accident · No injuriesLimited investigationFinal reportCessna 195 · Carefree, AZThe pilot's misjudging the wind direction and his selection of the wrong runway for the landing attempt.NTSB FTW98LA128Accident · No injuriesLimited investigationFinal reportBeech 23 · Colorado Sprngs, COThe pilot's inadvertent porpoise during landing roll. A factor was the ditch.NTSB CHI98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Point Lookout, MOthe pilot's failure to maintain directional control on landing rollout.NTSB MIA98LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Daytona Beach, FLThe pilot's improper use of ailerons and brakes on landing rollout.NTSB FTW98LA120Accident · No injuriesLimited investigationFinal reportCessna 210A · Morgan, UTfailure of the pilot to maintain control of the aircraft, which resulted in an inadvertent ground swerve. A related factor was the lack of experience in the make and model of aircraft.NTSB MIA98LA070Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLThe pilot's improper use of flight controls (cyclic) while attempting a takeoff to a hover, which led to an on-ground loss of control (dynamic rollover).NTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.NTSB CHI98LA090Accident · No injuriesLimited investigationFinal reportCessna 150M · Troy, MIthe student pilot's failure to maintain direction control of the airplane. Factors relating to this accident were: the crosswind, and wet/soft terrain (mud) beside the runway.NTSB MIA98LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · New Smyrna Bch, FLfailure of the pilot to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.NTSB LAX98LA078Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Van Nuys, CAThe student pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control. A related factor was the crosswind.NTSB LAX98LA084Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Prescott Valley, AZThe failure of the ground crew to correctly attach the tow bridle, which resulted in the pilot's loss of directional control.NTSB LAX98LA077Accident · No injuriesLimited investigationFinal reportPitts S1 · Prescott, AZThe pilot's failure to maintain directional control of the aircraft.NTSB LAX98LA081Accident · No injuriesLimited investigationFinal reportCessna 340A · Groveland, CAFailure of the brake line as a result of inadequate maintenance.NTSB FTW98LA113Accident · No injuriesLimited investigationFinal reportCessna 182Q · Keeline, WYfailure of the pilot to maintain directional control of the airplane during the landing roll. Factors relating to the accident included: a snow covered/icy/muddy area on the runway, and the proximity of a snowbank to the runway.NTSB ATL98LA038Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Selmer, TNThe loss of control on the ground, due to hydroplaning, and a collision with trees. A factor was the rain.NTSB ANC98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Pt. Baker, AKThe pilot's failure to maintain directional control.NTSB LAX98LA074Accident · No injuriesLimited investigationFinal reportCessna 195 · Long Beach, CAThe pilot's failure to maintain directional control during the landing, which led to a ground loop and a resultant overload failure of the right main landing gear attach points.NTSB LAX98LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Goodyear, AZThe inadvertent brake activation by the student pilot while practicing touch-and-go landings.NTSB LAX98LA069Accident · No injuriesLimited investigationFinal reportCessna 195A · Tucson, AZThe student's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors in this accident were the inadequate supervision of the flight by the flight instructor, and the student's failure to relinquish the…NTSB MIA98LA057Accident · No injuriesLimited investigationFinal reportCessna 170 · Orlando, FLfailure of the the left brake to operate, due to a bad o-ring; and subsequent failure of the pilot to maintain directional control of the airplane during landing rollout, resulting in a ground loop and subsequent on-ground encounter with terrain.NTSB FTW98LA077Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Worth, TXthe pilot's improper planning/decision, by allowing the airplane to get in a situation, where he could not compensate for wind conditions. A related factor was the gusty crosswind.