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 CHI96LA355Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Jordan, MNthe pilot's failure to maintain directional control during the landing roll.NTSB LAX96LA333Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot's failure to maintain directional control. The 40-degree crosswind component was a factor in this accident.NTSB ATL96LA126Accident · No injuriesLimited investigationFinal reportCessna 177 · Lyon, MSthe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, which resulted in a ground swerve. The gusty crosswind condition was a related factor.NTSB IAD96LA145Accident · Serious injuriesLimited investigationFinal reportDickmann Pitts S-1 · Meriden, CTfailure of the pilot to maintain control of the airplane during take off.NTSB LAX96LA332Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, CAfailure of the student pilot to maintain direction control of the airplane, which resulted in an inadvertent ground swerve and subsequent collapse of the nose gear, during an encountered with soft terrain.NTSB ANC96LA147Accident · No injuriesLimited investigationFinal reportRans 7 · Anchorage, AKthe pilot's improper recovery from a bounced landing and failure to maintain control of the aircraft. A factor relatated to the accident was: the pilot's improper decision to continue the flight after he identified he was having difficulty landing the…NTSB CHI96LA329Accident · No injuriesLimited investigationFinal reportCessna 172 · Wellston, MIThe pilot failed to maintain control of the aircraft. Factors were the rough road, the tree, and the tire.NTSB ANC96LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKthe pilot's improper braking action, which resulted in an inadvertent ground swerve and subsequent damage to the airplane. His excessive airspeed during landing was a related factor.NTSB LAX96LA328Accident · No injuriesLimited investigationFinal reportCessna 425 · Auburn, CAfailure of the right brake system (master cylinder O-ring seal). Factors relating to the accident were: the narrow runway, and the presence of a ditch adjacent to the runway.NTSB SEA96LA210Accident · No injuriesLimited investigationFinal reportCessna 120 · Nampa, IDthe solo student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a ground loop/swerve.NTSB ANC96LA143Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKthe pilot's inadequate compensation for gusty crosswind conditions, which resulted in a loss of directional control and subsequent collision with trees/brush. Factors relating to the accident were: the crosswind and wind gusts.NTSB FTW96LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Brownfield, TXThe pilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB MIA96LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Williamson, GAThe failure of the pilot to maintain directional control during takeoff.NTSB LAX96LA314Accident · No injuriesLimited investigationFinal reportCessna 172M · Truckee, CAthe student pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control. The encounter with a ditch was a related factor.NTSB ANC96LA130Accident · No injuriesLimited investigationFinal reportMaule M-7 · Palmer, AKThe pilot's selection of an unsuitable landing area.NTSB SEA96LA200Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Waitsburg, WAthe pilot's inadequate compensation for wind conditions and failure to maintain control of the airplane after encountering a whirlwind during the landing.NTSB SEA96LA191Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lander, WYthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors relating to the accident were: the variable and gusty wind conditions.NTSB LAX96LA312Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Vacaville, CAThe pilot's failure to maintain directional control of the aircraft during the landing rollout.NTSB LAX96LA309Accident · No injuriesLimited investigationFinal reportCessna 195A · San Luis Obispo, CAthe pilot's failure to maintain directional control, which resulted in a ground loop/swerve.NTSB FTW96LA354Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Victoria, TXthe pilot's failure to maintain directional control of the airplane during the landing roll. A related factor was the rough/uneven terrain (gopher mound) on the grass runway.NTSB FTW96LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring, TXfailure of the pilot to maintain directional control of the airplane during a touch-and-go, which resulted in an inadvertent ground swerve, an encounter with soft terrain, and a nose over of the airplane.NTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.NTSB SEA96LA208Accident · No injuriesLimited investigationFinal reportCessna 150M · Paterson, WAfailure of the student pilot to maintain directional control of the airplane during a landing, which resulted in an uncontrolled ground loop/swerve. Factors relating to the accident were: the gusty crosswind condition, and soft terrain beside the runway.NTSB SEA96LA193Accident · No injuriesLimited investigationFinal reportCessna A185E · Cody, WYfailure of the pilot to maintain directional control of the airplane and runway alignment during the takeoff roll. Factors relating to the accident were: the crosswind, and possible dragging of the right brake.NTSB IAD96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pottstown, PAThe pilot's failure to maintain directional control during takeoff/ground run resulting in in-flight collision with a fence. Related factors were the pilot's poor planning/decision making, and the fog.NTSB IAD96LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Ashland, VAan undetermined braking anomaly and/or failure of the pilot to maintain directional control of the airplane during the landing.NTSB NYC96LA166Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Bedford, MAThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a ground loop/swerve. The variable wind condition was a related factor.NTSB SEA96FA182Accident · 1 fatalField investigationFinal reportCessna 182P · St. Anthony, IDThe pilot's failure to maintain directional control during a landing attempt. Factors included: probable dusk lighting conditions and no lights on the airstrip. Conributing to the pilot's injury severity was his failure to fasten his seat belt and shoulder…NTSB CHI96LA291Accident · No injuriesLimited investigationFinal reportCessna 150 · Plattsmouth, NEfailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.NTSB SEA96LA179Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Culbertson, MTthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control; and her inadequate remedial action for gusty winds after the aircraft departed the runway. Factors relating to the accident were: the strong and gusty…NTSB CHI96LA280Accident · No injuriesLimited investigationFinal reportCessna 177B · Drummond Island, MIthe pilot's failure to attain a proper landing attitude, and his failure to recover from the porpoise.NTSB LAX96LA307Accident · No injuriesLimited investigationFinal reportCessna A185F · Casa Grande, AZthe student pilot's failure to maintain directional control of the airplane, which resulted in an inadvertent ground loop. Factors relating to the accident were: the student pilot's inadequate training and lack of certification (endorsement).NTSB FTW96LA333Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Clayton, LAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the wet grass runway.NTSB LAX96LA295Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Douglas, AZThe pilot's failure to maintain directional control of the aircraft during the landing roll. A contributing factor was the pilot's inexperience in the type aircraft.NTSB FTW96LA330Accident · No injuriesLimited investigationFinal reportSchleicher KA6-CR · Forrest City, ARthe pilot's failure to abort the takeoff. Factors were the dust restricting his visibility and the uneven terrain.NTSB CHI96LA268Accident · No injuriesLimited investigationFinal reportUltravia Aero Int'l Pelican · Winneconne, WIfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in a ground swerve. The location of the tree was a related factor.NTSB CHI96LA263Accident · Minor injuriesLimited investigationFinal reportRockwell S-2D · Bancroft, WIthe pilot's inadequate compensation for wind conditions and failure to maintain directional control, which resulted in a ground swerve, encounter with soft/sandy terrain, and a subsequent noseover. Factors relating to the accident were: the pilot's selection…NTSB LAX96LA292Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Payson, AZthe failure of the pilot to maintain directional control on touchdown and the landing ground roll.NTSB ANC96LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Northway, AKThe pilot's failure to maintain directional control of the airplane during landing.NTSB CHI96LA257Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Napoleon, NDthe pilot's improper use of the rudder to correct the airplane's drift to the right. A factor was the pilot's inadequate compensation for the crosswind.NTSB FTW96LA321Accident · No injuriesLimited investigationFinal reportCessna 188A · Decatur, TXthe pilot's failure to maintain directional control. A factor was the prevailing crosswind.NTSB CHI96LA265Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Macksville, KSfailure of the pilot to allow the airplane to achieve sufficient airspeed for takeoff, and the resultant loss of aircraft control. Factors relating to the accident were: the rough runway, and the mound of dirt at the end of the runway.NTSB NYC96LA159Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Alexandria, NJfailure of the commercial pilot to ensure that directional control was maintained during takeoff, which led to a ground swerve and collision with a fence.NTSB ATL96LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bessemer, ALThe dual student's failure to maintain control of the aircraft during landing, and the flight instructor's failure to properly supervise the flight.NTSB CHI96LA246Accident · Minor injuriesLimited investigationFinal reportElliot Steen Skybolt · Belleville, ILthe inadequate weld on the landing gear by the builder/pilot.NTSB ANC96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nikiski, AKThe pilot's failure to maintain directional control during takeoff.NTSB LAX96LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Boulder City, NVa loss of directional control due to the student pilot's inadequate compensation for wind conditions and improper remedial action. Factors in the accident were crosswinds, inadvertent brake application, and failure to use the ailerons.NTSB CHI96LA251Accident · No injuriesLimited investigationFinal reportMaule M5-210TC · Olathe, KSthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the uncontrolled porpoise encountered and the pilot's lack of recent experience in tailwheel airplanes.NTSB MIA96LA192Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Okeechobee, FLfailure of the pilot to maintain control of the airplane during a high speed taxi check, which resulted in a lift-off and subsequent collision with the terrain.NTSB FTW96LA311Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Los Lunas, NMthe pilot's improper weather evaluation. Factors were the dust devil and the turbulence.