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 FTW94LA135Accident · No injuriesLimited investigationFinal reportSavage Kitfox · Longmont, COThe pilot's failure to maintain directional control.NTSB CHI94LA141Accident · No injuriesLimited investigationFinal reportCessna 182P · Kahoka, MOThe pilot's failure to determine the wind conditions before attempting to land in conditions which exceeded the performance capability of the airplane.NTSB BFO94LA072Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Clarion, PAThe pilot's failure to maintain directional control which resulted in an overrun of the runway and collision with a berm.NTSB CHI94LA135Accident · No injuriesLimited investigationFinal reportCessna 150J · Fredricktown, MOthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB ANC94LA050Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Fairbanks, AKThe failure of the pilot to abort the takeoff when her foot interfered and restricted the movement of the rudder control system.NTSB FTW94LA129Accident · No injuriesLimited investigationFinal reportCessna 172P · Tulsa, OKThe pilot's failure to compensate for wind conditions. A factor was the gusting cross wind.NTSB FTW94LA122Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Mount Bellvue, TXThe pilot's failure to maintain directional control. Factors were the soft runway and gusty winds.NTSB ATL94LA078Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Collegedale, TNThe pilot's failure to compensate for wind conditions during a crosswind landing. The crosswind was a factor.NTSB MIA94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Boca Raton, FLThe failure of the dual student to maintain directional control during landing and the failure of the flight instructor to properly supervise the dual student and take corrective action in a timely manner.NTSB CHI94LA127Accident · No injuriesLimited investigationFinal reportBeech 35 · Anderson, INthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the rough terrain encountered following the loss of control.NTSB BFO94LA059Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Oneonta, NYThe pilot's failure to maintain directional control during takeoff. A related factor was the crosswind component.NTSB ATL94LA072Accident · Serious injuriesLimited investigationFinal reportFoote M1 Mustang · Marietta, GAThe failure of the pilot to maintain control of the aircraft. Factors in the accident were the lack of familiarization with the aircraft by the pilot, and throttle cable rigging in the experimental aircraft.NTSB FTW94LA113Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Houston, TXThe pilot's failure to maintain directional control.NTSB SEA94LA090Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Driggs, IDDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB CHI94LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB CHI94LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Richmond, WIthe failure of the pilot to maintain directional control.NTSB SEA94LA087Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Dutch John, UTThe pilot's inadequate compensations for wind conditions. The gusty crosswind was a factor.NTSB FTW94LA106Accident · No injuriesLimited investigationFinal reportCessna 172L · Buena Vista, COThe improper supervision of the instructor pilot. A factor was the loss of directional control by the student pilot.NTSB LAX94LA161Accident · No injuriesLimited investigationFinal reportLuscombe 8EZ · Prescott, AZthe flying pilot's inadequate compensation for the existing crosswind condition, his failure to maintain directional control, and the inadvertent entry into a ground loop. A factor in the accident was the flying pilot's lack of experience in conventional…NTSB ANC94LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Soldotna, AKThe failure of the pilot-in-command/flight instructor to maintain directional control of the airplane.NTSB CHI94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ottumwa, SDinadequate compensation for wind conditions and the pilot's failure to maintain directional control. Factors related to the accident were the crosswind and the fence posts.NTSB LAX94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Angwin, CAthe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilots lack of total experience.NTSB FTW94LA093Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Lake Charles, LAThe failure of the pilot to adequately perform a preflight. A factor was the soft terrain.NTSB CHI94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hutchinson, MNthe pilot's failure to maintain directional control. Factors associated with the accident were the crosswind, the pilot's lack of total experience, the concrete block and the dirt back.NTSB SEA94LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Evanston, WYThe pilot's inadequate compensation for wind conditions. Factors include gusty crosswind, and the pilot's lack of total experience.NTSB MIA94LA082Accident · No injuriesLimited investigationFinal reportCessna 190 · Fort Lauderdale, FLLocking of the right main landing gear brake for undetermined reasons.NTSB LAX94LA151Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Concord, CAThe pilot's failure to maintain directional control during a touch-and-go landing. A factor in the accident was the pilot's limited expereince in tailwheel aircraft.NTSB NYC94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Falls Of Rough, KYThe pilot's inadequate tiedown and starting procedure which resulted in a runaway aircraft, which subsequently collided with a building.NTSB CHI94LA099Accident · No injuriesLimited investigationFinal reportCessna 172RG · Frankfort, MIThe failure of the pilot-in-command to maintain directional control. The snow covered runway was a factor.NTSB ANC94LA035Accident · No injuriesLimited investigationFinal reportCessna 402 · Kivalina, AKThe pilot's inadequate compensation for the wind conditions by landing on the left side of the runway. Factors were: inadequate snow removal and the snow covered runway.NTSB LAX94LA142Accident · No injuriesLimited investigationFinal reportWeber Q200 · Las Vegas, NVThe total failure of the tailwheel assembly. The rough/uneven terrain was a factor in this accident.NTSB LAX94LA144Accident · No injuriesLimited investigationFinal reportCessna 421C · Tulare, CAthe pilot's use of an excessive taxi speed, and his misjudgment of the distance to the approaching intersection. A factor in the accident was the dark night lighting conditions which effected the pilot's perception of the taxiway layout.NTSB FTW94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eagle Lake, TXThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB LAX94LA131Accident · No injuriesLimited investigationFinal reportPiper J5A-L4F · Kernville, CAthe pilot's improper use of the flight controls resulting in his failure to maintain directional control. The existing crosswind is a factor in this accident.NTSB CHI94LA092Accident · No injuriesLimited investigationFinal reportCessna 170B · Waupaca, WIThe failure of the pilot to maintain directional control. A factor related to the accident was the gusty crosswind.NTSB SEA94LA063Accident · No injuriesLimited investigationFinal reportCessna TU206 · Salt Lake City, UTThe pilot's improper aircraft handling during the aborted takeoff.NTSB CHI94LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sandwich, ILthe private pilot's failure to maintain directional control of the airplane while landing on a snow and ice covered runway. Factors are the snow on the runway and the snowbank.NTSB CHI94LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Dowagiac, MIFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's lack of experience in this make and model of aircraft, the crosswind, and snow beside the runway.NTSB LAX94LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172K · New Cuyama, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control of the aircraft.NTSB ANC94LA034Accident · No injuriesLimited investigationFinal reportCessna 206 · New Koliganek, AKThe pilot's failure to maintain control of the airplane. Factors in the accident were the strong crosswinds and the icy/snow covered taxi surface.NTSB ANC94LA033Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe failure of the pilot-in-command to maintain directional control of the airplane during the landing rollout. Contributing to the accident was the pilot's lack of recent experience in the airplane.NTSB CHI94LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Sebewaing, MIwas the pilot-in-command's failure to maintain directional control. Factors were the icy runway and a snowbank.NTSB CHI94LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Delavan, WIthe pilot-in-command's not maintaining directional control and his inadequate compensation for wind conditions. Factors were icy runway and crosswind.NTSB FTW94LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Meeker, COFailure by the pilot to maintain directional control of the aircraft during landing roll.NTSB CHI94LA074Accident · No injuriesLimited investigationFinal reportDouglas DC3C · Anderson, INthe pilot in command's inadequate remedial action after a loss of directional control during the takeoff ground roll. Related factors are the copilot's failure to maintain directional control, and the snow covered, icy runway.NTSB LAX94LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Truckee, CAThe pilot's failure to maintain directional control, delay in his remedial action, and failure to raise the flaps. The snow covered runway was a factor in this accident.NTSB LAX94LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Livermore, CAThe student pilot's failure to maintain directional and his improper use of the rudder. The student pilot's failure to raise the flaps, the prevailing 90-degree crosswind, and his lack of total experience are factors in this accident.NTSB BFO94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bennington, VTThe pilot's selection of unsuitable terrain for landing.NTSB SEA94LA056Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sidney, MTThe pilot's inadequate compensation for the crosswind resulting in loss of directional control.NTSB BFO94LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAthe pilot's failure to maintain directional control during the flare/touchdown.