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 MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.NTSB CHI93LA349Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Delevan, WIthe excessive use of brakes and rudder by the pilot-in-command. A factor related to the accident was the pilot-in-command's lack of total experience in this type of aircraft.NTSB LAX93LA341Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Willows, CAthe pilot's failure to maintain directional control of the aircraft.NTSB ANC93LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Happy Valley, AKThe pilot's improper preflight planning/decision, and his failure to maintain directional control of the airplane. A factor was the rough/uneven terrain.NTSB LAX93LA334Accident · No injuriesLimited investigationFinal reportCessna A150M · Sacramento, CAThe dual student pilot's failure to maintain directional control, improper use of the flight controls, and failure to relinquish the flight controls to the CFI. The soft dirt was a factor in this accident.NTSB CHI93LA336Accident · No injuriesLimited investigationFinal reportCessna 172M · Adrian, MIan excessive taxi speed used by the pilot-in-command. A factor related to the accident was loose gravel on the ramp and inadequate airport maintenance by the airport personnel.NTSB NYC93LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · London, OHThe student pilot's failure to maintain directional control of the airplane after landing, and subsequent departure from the runway and collision with terrain.NTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB DEN93LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Carr, COFailure of the pilot in command to maintain directional control of the aircraft during landing roll. Factors were the pilot disregarding the tailwind, and rough and uneven terrain off the side of the runway.NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.NTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.NTSB DEN93LA102Accident · No injuriesLimited investigationFinal reportCessna 140A · Lake Arthur, NMThe pilot's failure to maintain directional control of the aircraft during landing roll.NTSB SEA93LA176Accident · No injuriesLimited investigationFinal reportCessna 185C · Stibnite, IDLeakage of hydraulic brake fluid and improper maintenance by the pilot in command. A factor contributing to the accident was inadequate inspection by the mechanic.NTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.NTSB MIA93LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLFailure of the pilot-in-command to apply right rudder while applying power during the touch-and-go landing. Contributing to the accident was the pilot-in-command's lack of total experience.NTSB LAX93LA321Accident · No injuriesLimited investigationFinal reportCessna 170B · Lakeport, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB ANC93LA139Accident · No injuriesLimited investigationFinal reportCessna 170 · Northway, AKThe pilot-in-command's inadequate compensating for the variable wind conditions.NTSB CHI93LA314Accident · No injuriesLimited investigationFinal reportCessna 188 · Martin, SDthe pilot's failure to maintain control of the airplane during the takeoff roll.NTSB ANC93LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe failure of the pilot to maintain directional control on touchdown. A factor in the accident was the gusty crosswind conditions.NTSB ANC93LA136Accident · No injuriesLimited investigationFinal reportLake LA04 · Blair Lake, AKThe pilot's inadvertant entry into a porpoise and subsequent loss of control while step-taxiing prior to takeoff. A factor in the accident was the rough water conditions.NTSB LAX93LA314Accident · No injuriesLimited investigationFinal reportMooney M20J · King City, CAthe pilot's loss of directional control during the takeoff ground roll due to the inadvertent interference with the controls by a passenger.NTSB MIA93LA169Accident · No injuriesLimited investigationFinal reportAyres S2R-T15 · Louise, MSThe pilot in commands decision to takeoff from a road with a left quartering tailwind which resulted in his loosing directional control and the aircraft colliding with a utility pole.NTSB NYC93LA144Accident · No injuriesLimited investigationFinal reportBeech A55 · Norfolk, VAThe pilot's improper compesnation for wind conditions and failure to maintain firectional control. A factor was adverse wind conditions.NTSB ANC93LA132Accident · No injuriesLimited investigationFinal reportCessna 180 · Sparrevohn, AKThe pilot's failure to maintain directional control of the airplane. A factor was the animal on the runway.NTSB FTW93LA221Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Burnet, TXInadvertent groundloop by the pilot.NTSB FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.NTSB CHI93LA293Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Oshkosh, WIThe pilot-in-command's not maintaining directional control. Factors include a crosswind, the pilot-in-command's not attaining compensation for wind conditions, and his lack of experience in this type of airplane.NTSB SEA93LA165Accident · No injuriesLimited investigationFinal reportRiches Avid Flyer · Tooele, UTThe failure of the PIC to maintain directional control and to correct a ground loop/swerve.NTSB SEA93LA164Accident · No injuriesLimited investigationFinal reportChampion 7EC · Chewelah, WAThe failure of the PIC to maintain directional control and correct for ground loop/swerve.NTSB SEA93LA163Accident · No injuriesLimited investigationFinal reportCessna 195 · Pray, MTThe PIC failed to maintain directional control. A factor relating to the accident was the tailwind weather condition.NTSB LAX93LA301Accident · Minor injuriesLimited investigationFinal reportFerdon Thorp S-18 · Ash Fork, AZThe pilots inadequate compensation for wind conditions and failure to maintain directional control of the airplane during a precautionary landing, that resulted in collision with a fence and nose over of the airplane. A cross wind condition was a factor in…NTSB CHI93LA273Accident · No injuriesLimited investigationFinal reportCessna 305B · Fulton, MOfailure to maintain directional control. A factor related to the accident was the pilot's fatigue.NTSB BFO93LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belmar, NJThe pilot's inadequate compensation for wind and failure to maintain directional control during landing. Other related factors were the crosswind and the ravine.NTSB CHI93LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe student pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.NTSB LAX93LA293Accident · No injuriesLimited investigationFinal reportAviat A-1 · Selma, CAthe pilot-in-command's failure to maintain direction control, inadequate compensation for the existing wind conditions, and improper use of the rudder. The pilot's lack of total experience in the accident airplane make and model is a factor in this accident.NTSB DEN93LA083Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, COThe pilot's failure to maintain directional control.NTSB ATL93LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Poplar Branch, NCThe pilot's failure to maintain directional control during landing.NTSB BFO93LA127Accident · No injuriesLimited investigationFinal reportCessna 172P · Edgartown, MAThe pilot failed to maintain directional control during takeoff. Other related factors were: the tailwind, and the gross weight of the airplane being exceeded.NTSB DEN93LA082Accident · No injuriesLimited investigationFinal reportCessna 305A · Belen, NMFailure of the pilot in command to maintain directional control. A factor was: a quartering tailwind.NTSB ANC93LA117Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Circle Hot Spri, AKThe pilot-in-command's failure to maintain directional control during taxi. Factor is the rough/rutted condition of the airstrip.NTSB CHI93LA254Accident · No injuriesLimited investigationFinal reportGrumman G164B · Eldred, MNthe pilot's failure to maintain directional control during the takeoff roll.NTSB CHI93LA257Accident · No injuriesLimited investigationFinal reportCessna T188C · Wheaton, MNThe pilot's failure to maintain alignment during takeoff roll.NTSB ATL93LA125Accident · No injuriesLimited investigationFinal reportPiper J3 · Athens, GAThe dual student's improper application of wheel brakes prior to lowering the tail wheel and inadequate supervision by the CFI.NTSB CHI93LA246Accident · No injuriesLimited investigationFinal reportCessna R172K · Middleton, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB BFO93LA110Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lincoln Park, NJThe pilot's failure to maintain directional control of the airplane during landing rollout, and his delay is performing the proper remedial action of bringing back the left throttle to idle during landing rollout.NTSB LAX93LA305Accident · No injuriesLimited investigationFinal reportAyres Pitts MA-1 · Greenfield, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll and subsequent application of excessive braking that resulted in the airplane nosing over.NTSB BFO93LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsfield, MELoss of the tail wheel steering due to undetermined reason(s).NTSB CHI93LA242Accident · No injuriesLimited investigationFinal reportStinson V77 · St. Charles, MOThe pilot's failure to maintain directional control of the aircraft. A factor in the accident was the wind gusts present at the time of the accident.NTSB FTW93LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rogers, ARThe pilot's failure to maintain control of the airplane. A factor was the tailwind.NTSB DEN93LA073Accident · No injuriesLimited investigationFinal reportCessna 177 · Akron, COThe pilot's inadequate compensation for wind conditions. Factors were: the pilot's failure to initiate a go around in a more timely manner, and gusty crosswinds.