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 LAX02LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Denio, NVThe pilot's failure to maintain directional control and his inadequate compensation for wind condition. Wind gust is a contributing factor.NTSB SEA02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Deer Park, WALoss of directional control while landing. A drainage ditch was a factor.NTSB LAX02LA112Accident · No injuriesLimited investigationFinal reportMaule M-7-260 · Montague, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.NTSB NYC02LA069Accident · No injuriesLimited investigationFinal reportPiper P46T · Philadelphia, PAThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to flare during initial touchdown.NTSB LAX02LA125Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Dixon, CAThe pilot lost directional control due to the unsuitable landing area. A contributing factor was the muddy runway condition.NTSB LAX02LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Coalinga, CAthe pilot's failure to maintain directional control and his inadequate compensation for the wind conditions. The crosswind was a contributing factor.NTSB SEA02LA047Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COThe student pilot's failure to maintain directional control during landing. Factors included the student pilot's lack of experience, an icy runway, and a mound of snow adjacent to the runway.NTSB ATL02FA058Accident · 1 fatalField investigationFinal reportBeech BE-60 · Mexia, TXThe pilot's failure to remove the control lock before the flight and his failure to follow the checklist.NTSB NYC02LA066Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Atlantic City, NJThe pilot's failure to obtain a proper touchdown point.NTSB CHI02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · New Holstein, WIThe pilot's inadequate compensation for the wind conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind condition and the runway marker sign which the airplane…NTSB LAX02LA089Accident · No injuriesLimited investigationFinal reportBeech 77 · Long Beach, CAA loss of directional control due to the pilot's inadequate compensation for the existing crosswind condition.NTSB CHI02LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dowagiac, MIThe pilot's inadequate compensation for the wind conditions that resulted in directional control not being maintained during the landing roll. Factors to the accident were the pilot's inadequate in-flight decision to attempt the landing with a gusting 20 knot…NTSB DEN02LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the crosswind and the pilot's fatigue from lack of sleep.NTSB LAX02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot of the landing airplane failed to maintain directional control resulting in the on-ground collission.NTSB SEA02LA038Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Creswell, ORThe pilot's failure to maintain directional control on landing resulting in the aircraft leaving the runway environment, crossing a ditch and nosing over. Contributing factors were variable winds reported by the pilot and the ditch.NTSB LAX02LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Jean, NVThe pilot's failure to maintain directional control.NTSB NYC02LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fremont, OHDamage to the right tire, which resulted in a sudden loss of tire pressure and a loss of directional control.NTSB LAX02LA080Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-1 · San Diego, CAThe pilot failed to maintain directional control after encountering a gust of wind during the landing roll. Factors were the unexpected wind gusts and the soft terrain adjacent to the runway.NTSB CHI02LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Ottumwa, IAthe student pilot failed to maintain directional control during takeoff. A contributing factor was the snowbank.NTSB LAX02LA074Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hawthorne, CAFailure of the student to maintain directional control of the airplane on the landing rollout and failure of the CFI to adequately supervise the flight. A contributing factor was the decreased tension of the right main landing gear shock cord/bungee.NTSB NYC02LA054Accident · No injuriesLimited investigationFinal reportBeech F33A · Lynchburg, VAThe pilot's failure to maintain directional control and delay in aborting the takeoff.NTSB LAX02LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Payson, AZFailure of the pilot to maintain directional control of the airplane. A contributing factor was the premature raising of the flaps.NTSB IAD02LA027Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Waterville, METhe pilot's improper decision to attempt a takeoff from a snow-covered runway with a quartering tailwind.NTSB MIA02LA055Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Milton, FLThe inability of the pilot to maintain directional control of the airplane resulting in a ground loop. A finding in the investigation was a loose left rudder flight control cable.NTSB LAX02LA068Accident · No injuriesLimited investigationFinal reportCessna 206H · Mammoth Lakes, CAthe pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a loss of aircraft control and nose over during landing roll.NTSB CHI02LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Iowa Falls, IAThe pilot's inadequate compensation for the crosswind condition and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind and the rough terrain encountered.NTSB MIA02LA056Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Sarasota, FLThe poor in-flight planning decision by the pilot-in-command for his failure to request the runway most aligned with the wind and his failure to maintain directional control during the landing roll.NTSB DEN02LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · St. George, UTThe student pilot's failure to maintain aircraft directional control during take off roll.NTSB DEN02LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Logan, UTthe pilot's failure to maintain aircraft control during landing roll. Contributing factors were the runway's patchy snow and ice conditions and a snow bank along the side of the runway.NTSB FTW02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Iraan, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were the pilot's selection of a downwind runway for landing, the tail wind condition, and his lack of total experience in the type of aircraft.NTSB ATL02LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe pilots failure to maintain directional control during landing roll that resulted in a collision with an airport sign. Factors were wet runway surface and wind gust.NTSB ANC02LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight. Factors in the accident were the student's failure to maintain directional control of the airplane during the landing roll, icy runway conditions, and snow-covered terrain along the runway edges.NTSB LAX02LA067Accident · No injuriesLimited investigationFinal reportFarrand Vans RV6 · San Jose, CAFailure of the pilot to sufficiently slow the airplane prior to exiting the runway, which lead to the left main landing gear collapsing and a subsequent ground loop.NTSB LAX02LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Reno, NVThe pilot failed to maintain directional control resulting in an inadvertent ground loop. A contributing factor was the tailwind.NTSB IAD02LA023Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Martinsville, VAThe pilot's premature rotation and his failure to maintain directional control during the takeoff roll.NTSB SEA02LA029Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll. An icy runway and a snow bank were factors.NTSB LAX02LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Long Beach, CAThe student pilot's inadequate compensation for wind, and his failure to maintain directional control of the aircraft during the landing roll.NTSB CHI02LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Olathe, KSThe pilot's failure to maintain directional control during landing resulting in the overload of the nose gear fork. The overload failure of the nose landing gear fork, the embankment, and the remedial action not possible were contributing factors.NTSB LAX02LA052Accident · No injuriesLimited investigationFinal reportCessna 185F · Reno, NVWear on the tail wheel thrust plate spacers resulted in the compression springs binding on the thrust plates and the tail wheel sticking, so that the pilot could not maintain directional control.NTSB DEN02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Crested Butte, COa wet brake that later froze resulting in a loss of directional control on landing. A contributing factor was the snow bank.NTSB LAX02LA051Accident · No injuriesLimited investigationFinal reportVernon Sonerai IIL · Camarillo, CAFailure of the pilot to maintain directional control on the landing rollout. Factors were the owner/pilot's inadequate remedial design changes and the freshly plowed field.NTSB FTW02LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · New Braunfels, TXThe student pilot's failure to maintain directional control of the airplane during the landing roll. A contributing factor was the soft terrain.NTSB DEN02LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COthe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the crosswind.NTSB SEA02LA020Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Halfway, ORA loss of aircraft control for undetermined reasons. A factor was a snow-covered landing surface.NTSB NYC02LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHThe student pilot's failure to maintain directional control.NTSB MIA02LA042Accident · 1 fatalLimited investigationFinal reportFerguson A 26 Vulcan SS · Newnan, GAThe pilot's failure to maintain directional control during landing and go-around, resulting in a collision with a runway perimeter fence pole and trees.NTSB CHI02LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devils Lake, NDThe student pilot's failure to maintain directional control of the airplane during the takeoff phase of a touch and go landing. Factors associated with the accident were the student's lack of total experience and the runway light which the airplane contacted.NTSB CHI02LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Harrisonville, MOdirectional control not maintained be the pilot during landing rollout. The ditch was a contributing factor.NTSB IAD02LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe pilot's failure to maintain directional control of the airplane during landing. A factor was the crosswind.NTSB LAX02LA029Accident · No injuriesLimited investigationFinal reportAviat S-2C · Chandler, AZFailure of the flight instructor to maintain directional control resulted in a departure from the runway surface and collision with a runway sign.