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 DEN99LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Heber City, UTThe stripped threads and subsequent separation of the left hydraulic brake line leading to fluid loss and the pilot's inability to maintain directional control.NTSB SEA99LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Kennewick, WAThe student pilot's inadequate compensation for gusty wind conditions. A contributing factor was gusty winds.NTSB MIA99FA226Accident · No injuriesField investigationFinal reportCanadair CL-600 · Fort Lauderdale, FLThe failure of the flight crew to main directional control of the airplane after landing, resulting in the airplane going off the side of the runway and colliding with a taxiway sign, collapsing the nose landing gear, and causing substantial damage to the…NTSB NYC99LA204Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Mansfield, MAWas the student pilot's failure to maintain lateral control of the helicopter while bringing it to a hover. A factor in the accident was the student pilot's lack of total experience in helicopters.NTSB NYC99LA201Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Zanesville, OHThe pilot's failure to maintain directional control.NTSB LAX99LA324Accident · No injuriesLimited investigationFinal reportKilpatrick IV-1200 · Springerville, AZFailure of the pilot to maintain directional control resulting in an inadvertent groundloop. A factor was muddy terrain by the runway.NTSB DEN99LA147Accident · No injuriesLimited investigationFinal reportCessna 180H · Gillette, WYThe pilot's inadvertent ground loop during landing roll.NTSB CHI99LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Red Wing, MNDirectional control not being maintained by the pilot. A factor to the accident was the ditch.NTSB ANC99LA129Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Anchorage, AKThe pilot's inadequate preflight planning/preparation, and improper starting procedure.NTSB NYC99LA196Accident · No injuriesLimited investigationFinal reportCessna 172P · Montgomery, NYthe failure of the student pilot to maintain directional control during the touchdown and landing roll.NTSB MIA99LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAThe failure of the pilot to maintain directional control during takeoff from a touch and go landing resulting in the aircraft traveling off the runway, colliding with taxiway lights and a taxiway sign, collapsing the nose landing gear, and nosing down.NTSB FTW99LA215Accident · No injuriesLimited investigationFinal reportMbb BO-105S · Vermilion 250The failure of the pilot to maintain directional control of the helicopter while attempting to takeoff. A factor was the high wind condition.NTSB SEA99LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Sidney, MTThe pilot's failure to adequately compensate for wind conditions.NTSB MIA99LA216Accident · No injuriesLimited investigationFinal reportCessna 172R · Savannah, GAThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, resulting in the airplane running off the runway and colliding with a runway sign.NTSB DEN99LA138Accident · No injuriesLimited investigationFinal reportCessna TU206A · Durango, COA worn landing nose gear steering system that diminished the ability to steer the airplane. Factors were improper maintenance by unknown persons, and loose gravel.NTSB CHI99LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILthe CFI's delay in taking remedial action to maintain directional control of the airplane. A factor associated with the accident was the student's improper use of the brakes.NTSB FTW99LA210Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Whitewright, TXThe pilot's failure to maintain directional control of the airplane.NTSB CHI99FA276Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Lake Geneva, WIthe aborted takeoff not performed by the safety-pilot and airspeed not obtained/maintained by the safety-pilot. Factors to the accident were directional control and runway alignment not maintained by the pilot-in-command, the inadequate supervision of the…NTSB DEN99LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Casper, WYThe pilot's selection of a wrong runway for landing and his failure to maintain directional control.NTSB ANC99LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKThe loss of control due to wake turbulence, and the issuance of an improper takeoff clearance by air traffic control personnel. A factor associated with the accident was air traffic control personnel's failure to issue a safety advisory.NTSB NYC99LA192Accident · No injuriesLimited investigationFinal reportBeech A36 · Westminster, MDThe pilot-in-command's failure to maintain aircraft control while landing.NTSB NYC99LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Frederick, MDThe pilot's failure to maintain directional control. Contributing factors were gusty wind conditions and the sign.NTSB CHI99LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Harlan, IAthe failure of the pilot to maintain directional control of the aircraft during landing. Factors to the accident were the crosswind, the failure of the pilot to maintain compensation for the crosswind condition on approach, and the inadvertent ground loop…NTSB ANC99LA102Accident · No injuriesLimited investigationFinal reportCessna 180A · Gustavus, AKThe pilot's inadvertent ground loop/swerve.NTSB SEA99LA132Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Creek, IDThe pilot-in-command's improper remedial action (continued takeoff). Contributing factors were the tree and control interference (inadvertent brake activation) by the passenger..NTSB CHI99LA271Accident · No injuriesLimited investigationFinal reportCessna 180K · Shawano, WIthe failure of the pilot to maintain directional control. Factors were the misjudged flare and improper recovery from the bounced landing by the pilot, and the ditch.NTSB CHI99LA262Accident · No injuriesLimited investigationFinal reportBeech C-45H · Grain Valley, MOthe failure of the pilot to use the tailwheel lock on takeoff, creating a condition where it was not possible for the pilot to maintain directional control. Factors were the unlocked tailwheel and the ditch.NTSB CHI99FA260Accident · No injuriesField investigationFinal reportBurns Pietenpol AIR Camper · Oshkosh, WIthe pilot failed to maintain directional control and ground looped the airplane. Factors included the crosswind and the turbulence from the DC-3.NTSB CHI99LA282Accident · No injuriesLimited investigationFinal reportCessna 152 · Superior, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the gusty wind condition, the student's lack of experience, and the soft terrain encountered.NTSB SEA99LA128Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Spokane, WAThe pilot's failure to maintain directional control. A related factor was the pilot's lack of experience in tailwheel aircraft.NTSB DEN99LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Peyton, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. Factors were the crosswind and the ditch.NTSB FTW99LA195Accident · No injuriesLimited investigationFinal reportCessna 152 · Frisco, TXThe pilot's failure to maintain directional control of the airplane during the simulated soft field takeoff.NTSB CHI99LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, MIthe student pilot's inadequate use of the rudder which resulted in a loss of directional control during an aborted landing. A factor associated with the accident was the student's lack of total experience and the segmented circle which the airplane contacted.NTSB SEA99LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Oakridge, ORThe pilot's failure to maintain aircraft control during a go-around. A downdraft during the approach is a factor.NTSB ANC99LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Teller, AKThe pilot's improper starting procedure.NTSB IAD99LA055Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Millbrook, NYwas the pilot's inadequate compensation for winds and his failure to maintain directional control.NTSB LAX99LA252Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Taft, CAThe pilot's selection of the wrong runway in consideration of the wind conditions and his subsequent failure to maintain directional control. The pilot's decision to abort the landing attempt with inadequate runway remaining for the takeoff phase was also…NTSB NYC99LA176Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Sanford, METhe pilot's failure to maintain control of the airplaneNTSB SEA99LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Renton, WAFailure of the pilot-in-command to maintain directional control after landing, resulting in a ground loop.NTSB LAX99LA247Accident · Minor injuriesLimited investigationFinal reportRose Velocity 173/FG-E · Santa Monica, CAThe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain runway alignment.NTSB CHI99LA224Accident · No injuriesLimited investigationFinal reportCessna 172N · Faribault, MNthe pilot's failure to maintain directional control of the airplane during the takeoff ground run.NTSB LAX99LA249Accident · No injuriesLimited investigationFinal reportCessna 185 · Beckwourth, CAThe pilot's inadequate compensation for the wind conditions and subsequent failure to maintain directional control.NTSB DEN99LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Watkins, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A related factor was the gusty quartering tailwind.NTSB CHI99LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Rogers City, MIThe pilot's inadequate compensation for the crosswind.NTSB SEA99LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Conner, MTThe pilot's attempt to take off on an unsuitable runway surface due to standing water on the runway. Factors include standing water on the airstrip.NTSB NYC99LA166Accident · No injuriesLimited investigationFinal reportCessna 140 · Beckley, WVThe pilot's loss of aircraft control during the landing roll, which resulted in an inadvertent ground loop.NTSB ANC99LA089Accident · No injuriesLimited investigationFinal reportCessna 140 · Sitka, AKThe pilot's inadequate compensation for crosswind conditions. Factors in the accident were a crosswind, and the pilot's lack of total experience in the type of airplane.NTSB ANC99LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Fairbanks, AKThe pilot's inadequate compensation for a crosswind. Factors in the accident were a crosswind, and an inadvertent ground loop.NTSB LAX99LA244Accident · No injuriesLimited investigationFinal reportCessna 180 · North Las Vegas, NVThe pilot's failure to adequately compensate for the existing crosswind condition and maintain directional control of the aircraft.NTSB ANC99LA112Accident · No injuriesLimited investigationFinal reportCessna 170B · Wasilla, AKThe student pilot's inadvertent ground loop during the takeoff roll. A factor in this accident was the a left crosswind.