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 CHI96LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Letcher, SDthe pilot's inadequate evaluation of the severe weather condition. A factor was the weather conditions.NTSB ANC96TA075Accident · No injuriesFinal reportCessna A-185-F · Juneau, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was the crosswind.NTSB SEA96LA095Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cut Bank, MTthe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. Factors relating to the accident were: the unfavorable wind conditions (crosswind and…NTSB LAX96LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAthe student pilot's failure to maintain directional control of the aircraft during an aborted takeoff.NTSB LAX96LA201Accident · No injuriesLimited investigationFinal reportBoeing-Brown E75NL · Columbia, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB IAD96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Westminster, MDThe pilot-in-command's failure to maintain control of the airplane during landing. A factor in this accident was the CFI-rated pilot/passenger's inattention.NTSB FTW96LA223Accident · No injuriesLimited investigationFinal reportCessna 170A · Wharton, TXfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.NTSB CHI96TA160Accident · No injuriesFinal reportCessna 182 · Jacksonville, ILthe pilot's improper compensation for the crosswind condition. A factor in the accident was the crosswind conditions which existed.NTSB ANC96LA073Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cold Bay, AKthe pilot's excessive taxi speed. Factors associated with the accident were: the pilot's improper preflight inspection of the airplane, and the entanglement of the left main landing gear brake and axle with wire.NTSB FTW96LA214Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Akron, COthe pilot's failure to maintain directional control.NTSB IAD96LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Roanoke, VAthe student pilot's failure to maintain adequate control of the aircraft during the touch and go landing. Related factors were the crosswind condition and the student pilot's lack of experience.NTSB FTW96LA213Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Calhan, COthe pilot's failure to maintain directional control during landing. A factor was a gusting cross-wind.NTSB IAD96LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Providence, KYthe pilot's failure to maintain directional control of the airplane during the landing roll. Related factors are the crosswind weather condition, the pilot's inadequate compensation for wind conditions, and the intermittent binding of the left brake.NTSB NYC96LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshfield, MAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control, on-ground collision with terrain, and the aircraft nosing over. The sudden windshift was a related factor.NTSB FTW96LA211Accident · No injuriesLimited investigationFinal reportBoeing E75 · Taos, NMthe pilot's failure to maintain directional control. A factor was the dust devil.NTSB IAD96FA074Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Sunapee, NHthe pilot's failure to maintain control of the airplane. Factors in this accident were: the pilot's lack of currency in type and model airplane, and not following the requirement for the pilot to have a flight instructor onboard during water landings.NTSB FTW96LA203Accident · No injuriesLimited investigationFinal reportCessna 172K · Leadville, COthe pilot's failure to adequately compensate for the wind conditions and to maintain directional control. Factors were: the gusting cross wind and the pilot's lack of total experience in make and model of aircraft.NTSB LAX96LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · Lake Havasu Cty, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control. The wind was a factor.NTSB ANC96LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKthe pilot's inadequate compensation for the crosswind conditions. Factors associated with the accident were the soft terrain at the landing site, and a crosswind.NTSB ANC96LA063Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Dillingham, AKfailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop/swerve.NTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…NTSB LAX96LA181Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Riverside, CAthe loss of directional control by the pilot's inadequate compensation for the wind gusts, and improper use of the engine and flight controls. The wind was a factor.NTSB LAX96LA178Accident · No injuriesLimited investigationFinal reportCessna TR182 · San Diego, CAthe pilot's failure to maintain directional control during landing rollout as a result of his excessive application of brakes and improper use of the elevator (yoke) control.NTSB IAD96LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culpeper, VAThe pilot's improper compensation for the crosswind.NTSB IAD96LA068Accident · No injuriesLimited investigationFinal reportBeech B55 · Lynchburg, VAThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve and landing gear collapse. A related factor was the strong crosswind.NTSB FTW96LA196Accident · No injuriesLimited investigationFinal reportBeech A35 · Siloam Springs, ARthe pilot's inadequate compensation for the crosswind. The crosswind was a factor.NTSB LAX96LA183Accident · No injuriesLimited investigationFinal reportCessna R182 · Las Vegas, NVthe pilot's misjudged landing flare and improper bounced landing recovery. Contributing factors were the overload failure of a main landing gear tire which resulted in the pilot's loss of directional control.NTSB FTW96LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COthe student pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. A factor was the cross wind.NTSB ATL96LA082Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Mckenzie, TNThe pilot's improper use of the flight control during a crosswind landing that resulted in a loss of control of the airplane.NTSB LAX96LA176Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZfailure of the pilot to adequately compensate for gusting crosswind conditions and to maintain directional control. A factor in the accident was unattended construction equipment parked in close proximity to the runway edge.NTSB FTW96LA180Accident · Minor injuriesLimited investigationFinal reportWhistle Questair Venture M20 · Watkins, COthe pilot's failure to compensate for prevailing wind conditions and to maintain directional control. Factors were the gusting and quartering tailwind conditions.NTSB CHI96LA137Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Aitkin, MNthe pilot's improper planning/decision, which resulted in his failure (or inability) to adequately compensation for wind conditions. Factors relating to the accident were: the gusty crosswind condition and the snowbank.NTSB CHI96LA140Accident · No injuriesLimited investigationFinal reportCessna 172 · Dekalb, ILThe flight instructor's inadequate supervision, and his delay in taking remedial action to regain directional control of the airplane. Factors relating to the accident were: the student's improper flare for landing, improper recovery from a bounced landing,…NTSB CHI96LA136Accident · No injuriesLimited investigationFinal reportCessna 172N · Middleton, WIfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty crosswind condition, the pilot's excessive lowering of flaps, and the…NTSB NYC96LA092Accident · No injuriesLimited investigationFinal reportCessna 175 · Pittsfield, MAthe pilot's inadequate crosswind compensations during the landing roll.NTSB LAX96LA174Accident · No injuriesLimited investigationFinal reportHelio H-295 · Grand Canyon, AZthe partial failure of the landing gear brake system resulting from loss of the clips retaining the right-hand brake disk. The resulting loss of braking authority impaired the pilot's ability to maintain directional control in a left quartering tailwind and…NTSB MIA96FA118Accident · 1 fatalField investigationFinal reportHawker Siddeley FB-60 · Lakeland, FLThe pilot's improper use of brakes and ailerons, during the landing rollout with a right crosswind, which resulted in a loss of directional control and subsequent nose over. Factors relating to the accident were: the crosswind and the pilot's lack of…NTSB LAX96LA171Accident · Minor injuriesLimited investigationFinal reportBryan Glasair 3SH-3R · Sedona, AZthe pilot's misjudged landing flare which resulted in a hard, bounced landing, and his improper recovery technique. A contributing factor was the pilot's failure to attain a proper initial touchdown point on the runway surface during dusk light conditions.NTSB FTW96LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Silver City, NMthe student pilot's failure to maintain directional control. A Factor was the crosswind.NTSB ATL96LA079Accident · No injuriesLimited investigationFinal reportCessna 172K · Lebanon, TNthe student pilot's failure to maintain directional control during landing.NTSB FTW96LA173Accident · No injuriesLimited investigationFinal reportAeronca 65-TAF · Roanoke, TXthe pilot's failure to maintain directional control during landing.NTSB LAX96LA163Accident · No injuriesLimited investigationFinal reportCessna 185F · Placerville, CAthe CFI's failure to take adequate remedial action to preclude the loss of direction control during landing rollout.NTSB ANC96LA044Accident · No injuriesLimited investigationFinal reportCessna 185 · Fairbanks, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.NTSB CHI96LA138Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Pontiac, MIfailure of the pilot to maintain control of the airplane during the landing roll. A factor relating to the accident was: the crosswind condition.NTSB LAX96LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Palm Springs, CAthe pilot's inadequate compensation for the crosswind condition and subsequent failure to maintain directional control. The crosswind was a factor.NTSB FTW96LA160Accident · No injuriesLimited investigationFinal reportCessna 172K · Danville, ARthe student pilot's inadequate compensation for the crosswind. Factors were the crosswind and the soft terrain.NTSB FTW96LA159Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A · Hughes, LAthe pilot exceeding the maximum authorized crosswind component of the airplane. Factors were the crosswind and the side sloping runway.NTSB CHI96LA123Accident · No injuriesLimited investigationFinal reportCessna 206 · Ulysses, KSFailure of the pilot to maintain control of the airplane, while taxiing. Factors relating to the accident were: the high, gusty, crosswind condition; and loose gravel on the roadway.NTSB ATL96LA071Accident · No injuriesLimited investigationFinal reportMeeker JUNGSTER-1 · Ormond Beach, FLthe pilot's failure to maintain directional control during a landing, which resulted in a ground loop. A factor relating to the accident was: the pilot's lack of total experience in type of aircraft.NTSB ANC96LA040Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's inadequate compensation for gusty crosswind conditions. The strong, gusty crosswind was a factor.