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 BFO93LA104Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Culpeper, VAThe pilot's failure to maintain directional control during landing rollout. A factor related to the accident include a ditch.NTSB CHI93LA241Accident · No injuriesLimited investigationFinal reportCessna U206A · Kimberling City, MOA rock lodged in the left brake assembly.NTSB ANC93LA109Accident · No injuriesLimited investigationFinal reportMaule M4 · Iliamna, AKThe pilot in command's improper taxi speed. A factor in the accident was the rough water.NTSB ANC93LA104Accident · No injuriesLimited investigationFinal reportCessna 140 · Juneau, AKThe pilot's failure to maintain directional control. A factor to the accident was the pilot's lack of total experience.NTSB CHI93LA227Accident · No injuriesLimited investigationFinal reportCessna 182L · Aurora, ILThe disconnected nose gear upper torque link (landing gear steering). Directional control not possible was a factor.NTSB CHI93LA223Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Osceola, WIThe pilot in command's failure to maintain directional control.NTSB SEA93LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Bozeman, MTDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB CHI93LA231Accident · No injuriesLimited investigationFinal reportMooney M20C · Eveleth, MNThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA222Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Cloud, MNthe pilot's improper starting procedures.NTSB CHI93LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rapid City, SDThe pilot in command's inadequate compensation for wind conditions.NTSB LAX93LA265Accident · No injuriesLimited investigationFinal reportCulver LCA · San Luis Obispo, CAThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the pilot's lack of recent flight experience in tail wheel aircraft.NTSB ANC93LA106Accident · No injuriesLimited investigationFinal reportCessna 185 · Victory, AKThe pilot selected unsuitable terrain for landing.NTSB ANC93LA091Accident · No injuriesLimited investigationFinal reportAeronca AR11 · Anchorage, AKFailure of the student pilot to maintain directional control, which resulted in a ground swerve, and inadequate supervision by the flight instructor. A factor related to the accident was: the soft/wet (muddy) terrain at the edge of the runway.NTSB SEA93LA131Accident · No injuriesLimited investigationFinal reportChampion 7GC · Gillette, WYThe pilot in command's not maintaining directional control and the overload of the left main landing gear. A factor contributing to the accident was the pilot's lack of experience in conventionally geared aircraft.NTSB LAX93LA257Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Oakdale, CAthe failure of the flying pilot to maintain directional control of the aircraft during the takeoff ground roll. A factor in the accident was the flying pilot's lack of recent total flight time and recent experience in conventional landing gear equipped…NTSB ANC93LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-3 · Knik, AKThe improper use of the flight controls by the student pilot and inadequate supervision by the CFI pilot-in-command.NTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.NTSB CHI93LA198Accident · Serious injuriesLimited investigationFinal reportBeech 200 · Wonder Lake, ILThe failure of the pilot of the Beech 200, N210PH, to maintain sufficient runway alignment to prevent the airplane from departing the runway.NTSB NYC93LA101Accident · No injuriesLimited investigationFinal reportCessna 172P · Lincoln Park, NJThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and a collision with trees.NTSB CHI93LA211Accident · No injuriesLimited investigationFinal reportMonnett Sonerai IIL · De Kalb, ILThe pilot in command's inability to maintain directional control due to inadequate compensation for wind conditions.NTSB ANC93LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe pilot's failure to maintain direction control of the airplane during landing. The tailwind was a factor.NTSB NYC93LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAImproper recovery from a bounced landing which resulted in the airplane departing the side of the runway and striking trees.NTSB FTW93LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARThe pilot's selection of the downwind runway for landing. Factors were the wind conditions and the left brake malfunction for undetermined reasonsNTSB LAX93LA238Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Pacoima, CAA failure of the pilot to adequately compensate for cross wind conditions and a failure to maintain directional control of the airplane.NTSB ANC93LA073Accident · No injuriesLimited investigationFinal reportCessna 140 · Dillingham, AKThe pilot in command's failure to maintain proper runway alignment.NTSB MIA93LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pensacola, FLThe pilot-in-command's inadequate compensation for wind conditions and delayed remedical action.NTSB LAX93LA236Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Sedona, AZA failure of the pilot to adequately compensate for the wind conditions and subsequent loss of directional control during the landing roll. A factor in the accident was a lack of total experience in the aircraft type.NTSB LAX93LA232Accident · No injuriesLimited investigationFinal reportCessna 170B · Escondido, CAThe pilot-in-command's improper use of the brakes. The high vegetation was a factor in the accident.NTSB ANC93LA072Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's failure to maintain control of the airplane during landing.NTSB SEA93LA126Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Vancouver, WAThe pilot's inadequate remedial action. Factors include crosswinds, gusts, and the pilot's lack of total experience in tailwheel type aircraft.NTSB ANC93LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot in command's inadvertent ground loop.NTSB LAX93LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Madera, CAThe pilot's failure to maintain directional control. A factor related to this accident was the left quartering tailwind.NTSB BFO93LA097Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Reedsville, PATailwheel landing gear system components failing due to their worn condition resulting in the loss of ground steering capability. A factor in this accident was a gusting crosswind encountered during landing roll.NTSB FTW93LA166Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Mount Vernon, TXThe pilot's inadequate compensation for the crosswind.NTSB MIA93LA126Accident · No injuriesLimited investigationFinal reportCessna 170B · Titusville, FLThe pilot-in-command's failure to compensate for wind conditions, resulting in loss of directional control during landing roll.NTSB LAX93LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Vacaville, CAthe pilot's failure to maintain directional control after encountering strong and gusty cross winds during the landing flare.NTSB FTW93LA161Accident · No injuriesLimited investigationFinal reportLewis RV4 · Tyler, TXPilot's loss of directional control.NTSB SEA93LA115Accident · No injuriesLimited investigationFinal reportLarkin Pitts Special · Nampa, IDThe pilot failed to maintain directional control during landing ground roll.NTSB SEA93LA112Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hardin, MTThe pilot in command's failure to maintain directional control.NTSB MIA93LA122Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Destin, FLThe pilot-in-command's failure to abort the takeoff roll, resulting in an on-ground loss of control, and on-ground collision with terrain. Contributing to the accident was the failure of the nose wheel steering cable.NTSB SEA93LA110Accident · No injuriesLimited investigationFinal reportCessna 210 · Palouse, WAThe pilot in command not maintaining directional control. A factor contributing to the accident was the control interference by the passenger.NTSB CHI93LA176Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Plainwell, MIThe pilot-in-command's initiating hand starting of the airplane unattended by a qualified person.NTSB BFO93LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Shirley, NYFailure of the pilot to maintain directional control during the landing, which resulted in a ground swerve, and his failure to maintain sufficient clearance and or altitude from the trees. The proximity of trees was a related factor.NTSB LAX93LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Elko, NVThe pilot's failure in not determining the surface winds prior to landing which resulted in a landing in conditions beyond the demonstrated capability of the airplane.NTSB DEN93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe student's failure to maintain proper touchdown alignment, and the instructor pilot's inadequate supervision.NTSB ANC93LA062Accident · No injuriesLimited investigationFinal reportCessna 182 · Blair Lakes, AKThe pilots selection of unsuitable terrain on which to land. A factor was the soft, wet, rough area on the strip.NTSB BFO93LA079Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittstown, NJThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve. The gusty wind and proximity of the parked airplane were related factors.NTSB LAX93LA205Accident · No injuriesLimited investigationFinal reportCessna 195B · Placerville, CAThe unreliability of the normal brake system and the leaking master cylinderNTSB BFO93LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Marlboro, MAThe pilot failed to maintain control of the airplane during landing. Related to the accident was the excessive airspeed.NTSB LAX93LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Reedley, CAA failure of the pilot to maintain proper runway alignment and improper remedial action during the balked landing. A factor in the accident was a lack of total aeronautical experience.