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 LAX97LA099Accident · No injuriesLimited investigationFinal reportAyres S2R-T65 · Firebaugh, CAfailure of the pilot to compensate for crosswind conditions and to maintain proper runway alignment. Factors relating to the accident were: the crosswind, narrow runway condition, and the soft terrain and ditch beside the runway.NTSB NYC97LA052Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cincinnati, OHThe flight instructor's inadequate supervision and delayed remedial reaction which resulted in the loss of directional control by the student pilot during the landing roll out.NTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.NTSB CHI97LA061Accident · No injuriesLimited investigationFinal reportCessna 182K · El Dorado, KSthe pilot's failure to maintain directional control of the airplane. A factor relating to the accident was: the ditch, which the airplane contacted.NTSB CHI97LA066Accident · No injuriesLimited investigationFinal reportCessna 414 · Springfield, MOthe pilot's continued flight into known icing conditions with an inadequate windscreen deicing system and the diminished visual lookout. Factors were the icing weather conditions and the windscreen ice.NTSB MIA97LA071Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Daytona Beach, FLthe student pilot's failure to maintain direction control of the airplane during takeoff. The crosswind was a factor.NTSB FTW97LA093Accident · No injuriesLimited investigationFinal reportCessna 180K · Valentine, TXThe pilot's failure to attain the proper touchdown point, and the excessive airspeed during the approach and landing. A factor was the dirt bank paralleling the airstrip.NTSB CHI97LA065Accident · No injuriesLimited investigationFinal reportCessna 182J · Gaylord, MIthe student pilot's inadequate compensation for the wind conditions which resulted in a failure to maintain proper runway alignment. Factors associated with the accident were: the gusty, crosswind condition, the pilot's failure to perform a go-around, and the…NTSB IAD97LA042Accident · No injuriesLimited investigationFinal reportCessna 310F · Bridgeport, CTthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane during the landing roll. Related factors were: the pilot's misunderstanding of the wind conditions, and the resultant quartering tail wind.NTSB CHI97LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Bloomington, INthe pilot failed to maintain control of the aircraft. Factors included the icy runway and the crosswind.NTSB CHI97LA053Accident · No injuriesLimited investigationFinal reportLearjet 24 · Muscatine, IAthe pilot's failure to maintain directional control. A factor was the snow covered runway edge.NTSB LAX97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZfailure of the student pilot to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight. The student's diverted attention was a related factor.NTSB FTW97LA082Accident · Minor injuriesLimited investigationFinal reportJohn T. Garrett Baby Great Lakes · El Paso, TXThe pilot's failure to maintain control during takeoff.NTSB LAX97LA085Accident · No injuriesLimited investigationFinal reportMooney M20K · Van Nuys, CAthe pilot's failure to maintain directional control of the aircraft during landing rollout.NTSB FTW97LA078Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Channelview, TXLoss of aircraft control due to the pilot's inadequate compensation for the crosswind. Factors were the crosswind, and the muddy terrain.NTSB SEA97LA042Accident · No injuriesLimited investigationFinal reportCessna 150K · Helena, MTThe pilot's failure to maintain directional control.NTSB FTW97TA075Accident · No injuriesFinal reportCessna 182Q · Cleburne, TXthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane. Factors relating to the accident were: the crosswind, and the dirt bank which was parallel to the runway.NTSB MIA97LA058Accident · No injuriesLimited investigationFinal reportWaco WMF-5 · Kissimmee, FLthe pilot's failure to maintain direction control of the airplane after applying the brakes. A factor was the pilot's lack of familiarity with this make and model airplane.NTSB MIA97IA050Incident · No injuriesIncident investigationFinal reportDouglas DC8-62 · Orlando, FLThe failure of the captain to center the rudder and close all engine throttles during an aborted takeoff resulting in an uncontrolled turn to the right due to nose wheel steering through the rudder pedals and asymmetric engine thrust. A factor in the incident…NTSB LAX97LA081Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Jean, NVThe failure of both pilots to maintain directional control of the aircraft, and the instructor's inadequate supervision of the flight. A factor in the accident was the limited conventional gear experience of both pilots.NTSB CHI97LA048Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Menominee, MIice restricting normal brake system, normal braking not possible for the pilot and the pilot's poor in-flight planning. A factor was the pilot not performing a flight to an alternate destination airport.NTSB CHI97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Savoy, ILthe student pilot's failure to maintain directional control. Factors relating to this accident were the student pilot's failure to request another runway and the crosswind.NTSB NYC97LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering into a snowbank. The proximity of the snowbank was a related factor.NTSB MIA97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pensacola, FLfailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve and subsequent collapse of the nose gear. The crosswind was a related factor.NTSB FTW97LA053Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ruidoso, NMfailure of the pilot to maintain directional control during landing roll, and his delayed aborted landing. The gusty crosswind and blown left main tire were considered to be related factors.NTSB FTW97LA052Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Floydada, TXThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the locked left main wheel brake.NTSB LAX97LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · El Cajon, CAfailure of the pilot to maintain directional control, which resulted in a ground swerve. The pilot's low total time in conventional gear aircraft was a related factor.NTSB LAX97LA054Accident · No injuriesLimited investigationFinal reportCessna 172G · Chino, CAthe pilot's attempt to taxi with a crosswind component well in excess of the aircraft's maximum factory demonstrated capability. The wind conditions were factors.NTSB MIA97LA029Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Charlotte, NCfailure of the pilot maintain directional control of the aircraft, while landing. The proximity of trees was a related factor.NTSB CHI97LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hart, MIthe pilot's failure to maintain directional control on rollout.NTSB LAX97LA043Accident · No injuriesLimited investigationFinal reportCessna T210L · Mesa, AZthe pilot's failure to maintain directional control of the aircraft during the landing roll, which resulted in an inadvertent ground swerve.NTSB ATL97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Cartersville, GAthe flight instructor's (CFI's) inadequate supervision by failing to ensure that directional control of the aircraft was maintained, during a simulated engine failure. The student pilot's delay in performing the appropriate single-engine emergency procedure…NTSB FTW97LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Westcliffe, COfailure of the pilot to maintain directional control during the landing.NTSB SEA97LA024Accident · No injuriesLimited investigationFinal reportCessna A185E · Price, UTThe pilot's failure to maintain directional control during the landing roll.NTSB FTW97LA031Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mckinney, TXthe pilot's inadequate preflight planning/preparation, by selecting a seat/cushion that would not allow adequate knee clearance and ankle movement in the cockpit, which was subsequently attributed to the pilot's failure to maintain directional control during…NTSB CHI97MA017Accident · 4 fatalMajor investigationFinal reportGulfstream G-IV · Wheeling, ILfailure of the pilot-in-command (PIC) to maintain directional control of the airplane during the takeoff roll in a gusty crosswind, his failure to abort the takeoff, and failure of the copilot to adequately monitor and/or take sufficient remedial action to…NTSB FTW97LA027Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Lubbock, TXthe pilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB CHI97LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Alliance, NEthe instructor-pilot's inadequate supervision by not taking timely action after the student started losing directional control. A factor was the loss of directional control by the student pilot.NTSB SEA97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ogden, UTthe pilot's inadequate compensation for wind conditions, while landing, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.NTSB LAX97LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during landing rollout, which resulted in a ground swerve. Soft terrain on the shoulder of the runway was a related factor.NTSB CHI97LA015Accident · No injuriesLimited investigationFinal reportCessna 180 · New Richmond, WIthe dual student's failure to recover from the bounced landing and the instructor pilot's failure to correct the situation in time.NTSB FTW97LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COthe pilot's failure to maintain directional control and his improper use of rudder. A factor was the pilot's lack of total experience in the make and model of airplane.NTSB FTW97LA008Accident · No injuriesLimited investigationFinal reportCessna 172M · Tuttle, OKfailure of the pilot to maintain directional control during takeoff roll, which resulted in a ground swerve. Factors relating to the accident were: tall grass along the edges of the runway, and the proximity of the fence, fence posts, and trees.NTSB CHI97LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Allegan, MIthe pilot's failure to maintain directional control during landing.NTSB FTW96LA405Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Aspen, COfailure of the right brake antiskid, due to corrosion of a canon plug; and failure of the flight crew to revert to the normal brake system.NTSB MIA96LA235Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Borinquen, PRthe pilot failed to maintain control of the aircraft while hover taxing. Factors in this accident were wind gusts and a tailwind.NTSB NYC96LA190Accident · No injuriesLimited investigationFinal reportBins Kitfox IV · Pittsfield, MAthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control, the airplane veering off the runway, and a subsequent nose over. The adverse wind condition and uneven terrain were related factors.NTSB ANC96LA165Accident · No injuriesLimited investigationFinal reportCessna 185 · Nome, AKfailure of the pilot to maintain proper alignment of the selected landing area. Subsequent encounter with rocks was a related factor.NTSB CHI96LA347Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fargo, NDthe pilot's failure to maintain directional control of the airplane during the landing. A factor was the crosswind.NTSB SEA96LA217Accident · No injuriesLimited investigationFinal reportCessna 182P · Driggs, IDthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. Factors relating to the accident were: the gusty wind and soft terrain beside the runway.