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 DEN93LA028Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Englewood, COFailure by the pilot to maintain control of the aircraft. A factor was: lack of experience in type of aircraft.NTSB CHI93LA100Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Mason City, IAExcessive braking by the dual student.NTSB BFO93LA043Accident · No injuriesLimited investigationFinal reportCessna 150 · Knoxville, PAThe pilot's failure to maintain directional control. Contributing to the accident was the pilot's failure to plow the runway adequately.NTSB CHI93LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, WIThe student pilot's failure to maintain aircraft directional control during the takeoff ground run.NTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.NTSB CHI93LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Canton, MIThe student pilot's failure to maintain directional control.NTSB LAX93LA136Accident · No injuriesLimited investigationFinal reportCessna T188C · Delhi, CAThe pilot selected unsuitable terrain for takeoff and failed to maintain directional control of the aircraft. A factor in the accident was the standing water on the runway.NTSB LAX93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAThe pilots inadequate compensation for the existing crosswind condition and his resultant loss of directional control.NTSB BFO93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Hudson, NYFailure of the pilot to maintain directional control, which resulted in an advertent ground swerve. The snowbank was a related factor.NTSB LAX93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Galt, CAThe pilot's inadequate compensation for the existing crosswind conditions and his failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited total flight experience.NTSB LAX93LA122Accident · No injuriesLimited investigationFinal reportCessna 182E · Corning, CAThe pilot's poor preflight inspection. Factors relating to this accident were the not properly secured oil cap and the oil covered windshield.NTSB BFO93LA027Accident · No injuriesLimited investigationFinal reportCessna 210K · Sunbury, OHThe pilot's failure to maintain directional control during the takeoff roll. The soft terrain was a related factor.NTSB LAX93LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Chowchilla, CAThat the pilot failed to maintain directional control. The pilot's failure to use the tailwheel lock and the soft and wet terrain were factors relating to this accident.NTSB MIA93LA066Accident · No injuriesLimited investigationFinal reportCessna 172K · Plymouth, FLUndetected damage to the right main gear brake line which developed a leak and resulted in failure of the brake. The pilot was unable to maintain directional control, or stop the aircraft, prior to colliding with aircraft parked to the side of the runway.NTSB ANC93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run.NTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.NTSB ANC93LA030Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot's failure to maintain control of the airplane during the takeoff run. Factors were the unfavorable winds and rough water.NTSB ATL93MA055Accident · 7 fatalMajor investigationFinal reportLockheed L382E-44K-20 · Marietta, GADisengagement of the rudder fly-by-wire flight control system resulting in a total loss of rudder control capability while conducting ground minimum control speed tests. The disengagement was a result of the inadequate design of the rudder's integrated…NTSB SEA93LA061Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Medford, ORMovement of the tailwheel assembly was restricted. Improper maintenance was a factor.NTSB CHI93LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIFailure of the student pilot to maintain directional control.NTSB CHI93LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Omaha, NEThe pilot's failure to maintain directional control.NTSB CHI93LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Warren, MNThe pilot's inadequate compensation for variable wind conditions during landing. The crosswind was a factor.NTSB SEA93LA058Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bend, ORDirectional control not maintained and ground loop/swerve not corrected by the pilot in command.NTSB LAX93LA108Accident · No injuriesLimited investigationFinal reportCessna 210D · Douglas, AZThe pilot's selection of the wrong runway based on inaccurate wind information.NTSB NYC93LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Hagerstown, MDThe failure of the flight instructor to adequately supervise the student pilot, and take control of the airplane in a timely manner which resulted in the airplane departing the runway and striking a tower. Factors related to the accident were the improper use…NTSB CHI93LA080Accident · No injuriesLimited investigationFinal reportCessna 172D · Slayton, MNThe pilot's inadequate compensation for the crosswind condition. The crosswind was a factor.NTSB NYC93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Dover, VTThe pilot's failure to maintain directional control during takeoff, and his inadequate remedial actions, resulting in a collision with a snowbank. Factors related to the accident were the ice covered runway and the snowbank along the runway edges.NTSB CHI93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · South St. Paul, MNThe pilot's inadequate compensation for the existing crosswind condition. The crosswind was a factor.NTSB FTW93LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Fort Worth, TXThe pilot's failure to maintain directional control. A factor was the crosswindNTSB NYC93LA055Accident · No injuriesLimited investigationFinal reportCessna 172P · Teterboro, NJThe failure of the pilot to maintain directional control during landing which resulted in the airplane departing the runway and nosing over. Factors related to the accident were the crosswind and the soft terrain encountered by the airplane.NTSB FTW93LA075Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Fort Worth, TXThe pilot's failure to compensate for the crosswind. A factor was the crosswind.NTSB LAX93LA105Accident · No injuriesLimited investigationFinal reportBeech 58P · Pacoima, CAThe pilot's poorly planned approach, his use of an excessive airspeed on final approach and his improper use of the brakes. A factor in the accident was his limited experience in both multi engine and in the accident aircraft.NTSB LAX93LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lost Hills, CAThe pilot's inability to maintain directional control during the landing roll out due to a binding left brake master cylinder.NTSB NYC93LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAThe pilot failed to maintain control of the airplane resulting in the airplane departing the runway and impacting with a snow bank.NTSB CHI93LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, MNFailure of the pilot to maintain directional control during a takeoff ground run.NTSB BFO93LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Scotia, NYThe student pilot's failure to maintain directional control during landing. The snow covered runway was a related factor.NTSB SEA93LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T(B) · John Day, ORThe pilot's failure to maintain directional control. Factors include a snow covered runway.NTSB FTW93LA070Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · San Antonio, TXThe failure of the pilot to maintain directional control during the landing rollNTSB CHI93LA071Accident · No injuriesLimited investigationFinal reportDon Showalter Lancair 320 · Madison, WIA jammed main landing gear brake.NTSB FTW93LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's failure to maintain directional control. A factor was the snow conditionsNTSB ANC93IA026Incident · No injuriesIncident investigationFinal reportGrumman G-21A · Akutan, AKThe incident was caused by the pilots improper compensation for the winds. Factors were the microburst, the rough water, and the pilot's inadequate evaluation of the weather conditions.NTSB CHI93LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, MNThe student pilot's failure to maintain directional control.NTSB FTW93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe pilot's failure to maintain directional control.NTSB ATL93LA048Accident · No injuriesLimited investigationFinal reportCessna 120 · Bessemer, ALThe failure of the pilot to maintain directional control during take off.NTSB LAX93LA085Accident · No injuriesLimited investigationFinal reportMooney M20F · So. Lake Tahoe, CAThe pilot's failure to maintain directional control of the aircraft due to gusting cross winds and ice on the runway.NTSB LAX93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Big Bear, CAThe pilot's failure to maintain directional control of the aircraft after touchdown.NTSB LAX93LA082Accident · No injuriesLimited investigationFinal reportMaule MX-7-180 · Oceano, CAThe pilot's operation of the aircraft with known deficiencies in the brake system.NTSB LAX93LA081Accident · No injuriesLimited investigationFinal reportVarga 2150A · Salome, AZThe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the failure of the left brake.NTSB CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.NTSB ATL93LA042Accident · No injuriesLimited investigationFinal reportPitts S2B · Tuscaloosa, ALThe failure of the pilot to maintain directional control of the aircraft, during the take off roll. A factor was the wind gust.