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 FTW95LA268Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmington, NMThe student pilot's inadequate compensation for wind conditions during the landing, which resulted in her failure to maintain proper runway alignment. The gusty crosswind was a related factor.NTSB SEA95LA144Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Moses Lake, WAThe pilot's failure to maintain directional control during the landing and go around. The crosswind and gusty wind conditions were factors in the accident.NTSB MIA95LA173Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Belzoni, MSInadequate compensation for wind conditions by the pilot. The gusty crosswind was a factor.NTSB LAX95LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · New Cuyama, CAthe pilot's failure to attain and maintain an adequate airspeed, his premature rotation, and his failure to maintain directional control when the aircraft settled back onto the runway. The pilot's selection of a closed airport for the takeoff attempt was a…NTSB SEA95LA141Accident · No injuriesLimited investigationFinal reportMooney M20E · Ronan, MTDirectional control was not maintained. Factors to the accident were a rough/uneven airstrip and tall vegetation.NTSB LAX95LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Thermal, CAthe student pilot's failure to maintain directional control while executing a touch-and-go.NTSB FTW95LA265Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Denton, TXInadequate supervision by the flight instructor (CFI), and the resultant loss of directional control. A factor relating to the accident was: the lack of brake controls for the right seat occupant.NTSB MIA95LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · New Port Richey, FLThe pilot landed on the wrong runway. The tailwind contributed to the loss of directional control.NTSB LAX95LA223Accident · No injuriesLimited investigationFinal reportCessna 182P · Susanville, CAthe pilot's failure to maintain directional control of the aircraft during the landing roll.NTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.NTSB BFO95LA068Accident · No injuriesLimited investigationFinal reportCessna 180H · Chatsworth, NJthe pilot's failure to maintain directional control during the takeoff roll. Related factors were the gusty crosswind conditions.NTSB SEA95LA121Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Helena, MTThe pilots failure to maintain directional control. Contributing to the accident was the crosswind.NTSB CHI95LA192Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Peru, ILthe pilot's failure to maintain directional control of the airplane while landing. A factor in the accident was the runway light.NTSB LAX95LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · Big Bear, CAthe pilot's failure to maintain directional control during an aborted takeoff attempt, which was necessitated by his failure to properly lean the fuel mixture. The pilot's limited experience in small piston engine airplanes was a factor in the accident.NTSB ANC95LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Skwentna, AKThe pilot's failure to maintain directional control. Factors associated with the accident are the wet and uneven airstrip surface.NTSB FTW95LA236Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Farmington, NMFailure by the pilot to maintain directional control.NTSB MIA95LA147Accident · Minor injuriesLimited investigationFinal reportCessna 172P · St. Petersbug, FLThe pilot-in-command's/CFI improper supervision of the dual student on landing rollout. This resulted in an on ground loss of control (directional control not maintained), and subsequent nose over.NTSB ATL95LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Bessemer, ALThe pilot's failure to maintain directional control during a touch and go landing.NTSB CHI95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Plymouth, MIthe failure of the nose wheel collar assembly as a result of the loss of a bolt.NTSB CHI95LA169Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Clear Lake, MNfailure of the pilot to maintain directional control of the airplane during the takeoff roll. The proximity of trees to the runway was a related factor.NTSB ANC95TA068Accident · No injuriesFinal reportPiper PA-18-160 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing/takeoff. Factors associated with the accident are the long and wet grass covering the unimproved takeoff area.NTSB CHI95LA172Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Dawson, MNthe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control of the airplane on takeoff. A factor in the accident was the tall grass.NTSB ANC95TA067Accident · No injuriesFinal reportPiper PA-18-150 · Sand Point, AKThe premature castoring of the tailwheel steering mechanism. A factor associated the accident is the added degree of difficulty in handling airplanes equipped with oversize 'tundra' tires.NTSB FTW95TA228Accident · No injuriesFinal reportBell 206B-III · Meeker, COFailure by the pilot to maintain control of the aircraft during landing. A factor was soft terrain.NTSB FTW95LA229Accident · No injuriesLimited investigationFinal reportCessna 182K · Alamosa, COFailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve and collision with a taxiway sign. Factors relating to the accident were: the unfavorable (gusty/quartering) wind condition, and the taxiway sign's…NTSB ATL95LA104Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Rock Hill, SCAn inoperative left main wheel brake that resulted in a loss of directional control. A factor was the wet, grass runway.NTSB NYC95LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bluffton, OHan improperly planned approach and touchdown, which resulted in an loss of directional control at touchdown, with the airplane departing the runway, and striking a ravine.NTSB ANC95LA060Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Koliganek, AKThe pilot's failure to attain the proper approach and landing speed, not maintaining directional control, and his inadequate remedial action(s). A factor in the accident was the loose objects in the landing area.NTSB SEA95LA113Accident · No injuriesLimited investigationFinal reportCessna 180 · Phillipsburg, MTThe failure of the dual student to maintain directional control during the bounced landing, and the failure of the certified flight instructor to take adequate remedial action and recover from the loss of directional control. A factor contributing to the…NTSB NYC95LA126Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Fairfield, NJThe student pilot's failure to maintain control of the helicopter. The student's lack of experience in the type of operation (solo flight) was a related factor.NTSB CHI95LA164Accident · No injuriesLimited investigationFinal reportCessna 337B · Lemmon, SDthe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB MIA95LA136Accident · No injuriesLimited investigationFinal reportCessna A150L · Miami, FLThe dual student's improper use of the rudder following a left swerve during landing rollout which prevented the flight instructor from regaining directional control.NTSB FTW95LA210Accident · No injuriesLimited investigationFinal reportCessna 175 · Malvern, ARThe pilot's failure to maintain directional control. A factor was the pilot's lack of recent experience.NTSB FTW95LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Corpus Christi, TXThe pilot's inadequate compensation for crosswind conditions.NTSB CHI95LA156Accident · No injuriesLimited investigationFinal reportCessna 150G · Stockton, MOthe pilot's inadequate compensation for the crosswind weather condition and subsequent failure to maintain directional control. Factors were the crosswind and the ditch.NTSB CHI95LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Hutchinson, MNthe pilot's not maintaining aircraft control. A factor was the crosswind condition.NTSB CHI95LA152Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Hatton, NDthe pilot's failure to maintain control of the airplane, and the excessive airspeed. Factors associated with the accident were the pilot's selection of unsuitable terrain for landing, and the soft, wet condition of the sod runway.NTSB NYC95LA111Accident · No injuriesLimited investigationFinal reportRockwell 112B · Edgewater, MDThe pilot's improper decision to continue his flight into the adverse weather conditions that existed at the destination airport. The weather contributed to the accident.NTSB CHI95TA174Accident · No injuriesFinal reportCessna 180 · Orr, MNthe pilot's inadequate compensation for the crosswind weather condition. A factor was the crosswind.NTSB FTW95LA191Accident · No injuriesLimited investigationFinal reportCessna 190 · Longmont, COFailure by the pilot-in command-to compensate for crosswind conditions.NTSB FTW95LA189Accident · No injuriesLimited investigationFinal reportCessna 180 · Little Rock, ARThe pilot's failure to maintain directional control due to the excessive taxi speed.NTSB CHI95LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe pilot's failure to maintain directional control. A factor was the crosswind.NTSB CHI95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Boyceville, WIThe pilot's inadequate compensation for the wind conditions and subsequent failure to maintain runway alignment. The crosswind was a factor.NTSB CHI95TA151Accident · No injuriesFinal reportCessna 172 · Hutchinson, MNThe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the crosswind and soft terrain.NTSB NYC95LA096Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Clarion, PAA partial failure of the brake system.NTSB CHI95LA132Accident · No injuriesLimited investigationFinal reportCessna 172N · Detroit, MIthe student pilot's failure to maintain directional control during the takeoff ground run. A factor associated with the accident was the soft terrain.NTSB NYC95LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering off the left side of the runway. A factor was the pilot's failure to abort the takeoff.NTSB LAX95LA167Accident · No injuriesLimited investigationFinal reportCessna 182Q · Palo Alto, CAinadequate compensation for wind conditions by the private pilot, and failure of the flight instructor (CFI) to ensure that directional control of the aircraft was maintained. The gusty/crosswind (weather) condition was a related factor.NTSB FTW95LA171Accident · No injuriesLimited investigationFinal reportChampion 7GC · Paragould, ARThe student pilot's failure to maintain directional control, resulting in an inadvertent groundloop. A factor was the instructor's inadequate supervision.NTSB CHI95LA127Accident · No injuriesLimited investigationFinal reportPiper J3C · Poplar Grove, ILThe student pilot's excessive throttle control and the certified flight instructor's inadequate supervision of the student. A factor in the accident was the gusty wind conditions.