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 DEN89LA215Accident · No injuriesLimited investigationFinal reportCessna 180K · Englewood, COFailure of the pilot to maintain directional control, which resulted in a ground swerve. The crosswind was a related factor.NTSB DEN89LA204Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTFailure of the pilot to maintain directional control which resulted in a ground swerve. Soft terrain beside the runway was a related factor.NTSB BFO89LA078Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Parkersburg, WVThe pilot's inadvertent use (movement) of the collective control during engine operation before shutdown, and a subsequent lift-off, loss of control, roll over, and collision with the ground.NTSB DEN89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dutch John, UTInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during the takeoff ground run. Factors related to the accident were: the unfavorable (variable/gusty) wind condition, and the high vegetation and tree beside the…NTSB SEA89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Independence, ORFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop and subsequent overload failure of the left main gear. A factor related to the accident was: improper flare by the pilot.NTSB DEN89LA201Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Watkins, COFailure of the left brake assembly, and subsequent loss of directional control by the pilot.NTSB CHI89DEM07Accident · Minor injuriesFinal reportBradley S-1D · Mt Pleasant, MIThe tail wheel spring becoming disconnected resulting in the pilot's inability to maintain directional control of the airplane.NTSB LAX89LA285Accident · No injuriesLimited investigationFinal reportCessna 185F · Fresno, CAFailure of the pilot to maintain directional control of the aircraft.NTSB ANC89LA145Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Galbraith Lake, AKThe pilots failure to maintain direction control after aborting takeoff following failure of the tail landing gear tire.NTSB ANC89LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Copper Center, AKThe selection of unsuitable terrain for landing by the pilot. He subsequently lost control of the airplane when he improperly applied hard braking during a wheel landing.NTSB CHI89FA174Accident · Serious injuriesField investigationFinal reportCessna 172P · Superior, WIThe failure of the pilot to maintain directional control.NTSB DEN89LA195Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bountiful, UTInadequate compensation for wind conditions by the pilot and his failure to maintain directional control during the landing. The pilot's inadequate preflight preparation (lack of a weather briefing) and the weather conditions were contributing factors.NTSB CHI89LA169Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Wadsworth, OHInadequate supervision of the flight by the pilot-in-command (CFI) which resulted in loss of directional control of the aircraft. Contributing factors were: lack of recent experience in the type of operation by the CFI, lack of total experience by the student…NTSB CHI89LA166Accident · No injuriesLimited investigationFinal reportCessna 172P · Ravenna, OHFailure of pilot in command to maintain directional control of the airplane while executing a touch-and-go.NTSB FTW89LA146Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125-3A · Houston, TXFailure of the nose wheel steering system for undetermined reasons, and the pilot-in-command's hesitation reaching for the nose wheel steering tiller. A contributing factor was his lack of experience in a DH-125.NTSB LAX89DVA09Accident · No injuriesFinal reportAero Commander S2R · Tranquillity, CAThe pilot's visual look-out was inadequate and that he failed to see the high vegetation upon landing. Factors relating to this accident are dark night and high vegetation.NTSB ANC89LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Sparrevohn, AKPilot-in-command's failure to maintained directional control of the airplane during takeoff. The misjudged terrain was a contributing factor in the eventual outcome.NTSB MKC89LA174Accident · No injuriesLimited investigationFinal reportStinson L-5 · Minneapolis, MNThe pilot selected the wrong runway and failed to maintain directional control. The crosswind was a contributing factor.NTSB DEN89LA188Accident · No injuriesLimited investigationFinal reportCessna 185 · Durango, COImproper planning/decision by the pilot. The wind condition was considered to be a contributing factor.NTSB MIA89LA243Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Hollywood, FLThe severe fuselage vibration (ground resonance) and the pilot's improper planning/decision to avoid or compensate for the occurrence. A factor related to the accident was the low shock strut.NTSB DEN89LA191Accident · No injuriesLimited investigationFinal reportCessna 170B · Boulder, COThe student pilot failed to maintain directional control during landing roll due to improper use of the flight controls.NTSB ANC89LA135Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kodiak, AKThe pilot failed to maintain directional control and inadvertently allowed the aircraft to ground loop.NTSB LAX89LA261Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Rio Linda, CAFailure of the pilot to maintain proper runway alignment during an aborted landing. Related factors were: a false airspeed indication, the pilot's lack of familiarity with the aircraft, his improper use of carburetor heat, his diverted attention, and the…NTSB NYC89LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Mattituck, NYFailure of right braking action due to a hydraulic leak.NTSB NYC89LA180Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Plymouth, NHLoss of directional control during an aborted takeoff. The ditch was a related factor.NTSB BFO89DIG03Incident · No injuriesFinal reportSmith Miniplane · Cumberland, MDFailure of the pilot to maintain directional control of the airplane during high speed taxi tests.NTSB DEN89LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent damage to the wing.NTSB MKC89LA164Accident · No injuriesLimited investigationFinal reportCessna 172 · Duluth, MNAircraft control was not maintained by the pilot in command due to improper use of the aircraft flight controls.NTSB MIA89LA205Accident · No injuriesLimited investigationFinal reportMooney M22 · Vero Beach, FLFailure of an old weld repair on the nose gear strut housing. A contributing factor was improper maintenance by other (unknown) maintenance personnel.NTSB DEN89LA176Accident · No injuriesLimited investigationFinal reportCessna 170B · Kyle, SDThe pilot used poor preflight planning & decision-making in selecting a road on which to land during gusty wind conditions which resulted in the failure to maintain direction control.NTSB ANC89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chitina, AKThe pilot's selection of an unsuitable landing area and delay in slowing the airplane after landing. A factor in the accident was the rough/uneven terrain.NTSB NYC89LA170Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ithaca, NYA loss of control on takeoff due to improper takeoff techniques.NTSB MKC89LA161Accident · Minor injuriesLimited investigationFinal reportGates Learjet Learjet 35 · Des Moines, IAFailure of the pilot to maintain directional control and runway alignment during the landing. Factors related to the accident were: adverse weather/runway/terrain conditions, failure of the local controller to warn the pilot of possible hydroplaning…NTSB CHI89LA138Accident · No injuriesLimited investigationFinal reportCessna 182 · New Castle, INFailure of the pilot to maintian directional during the aborted takeoff, which resulted in an inadvertent ground swerve. The ditch was a contributing factor.NTSB FTW89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Granite, OKThe pilot did not maintain directional control.NTSB MIA89LA191Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Pahokee, FLThe pilot's inadvertent loss of airplane control, while on the water, which resulted in a swerve and subsequent accident.NTSB CHI89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INImproper recovery from a bounced landing and failure to maintain directional control by the pilot. The student pilot's lack of flight experience contributed to the accident.NTSB FTW89LA130Accident · No injuriesLimited investigationFinal reportStinson V77 · El Paso, TXPilot's failure to maintain directional control during landing roll in a high crosswind environment.NTSB FTW89LA126Accident · No injuriesLimited investigationFinal reportBeech 35 · Terrell, TXThe pilot's failure to maintain directional control. A factor related to the accident was: the pile of dirt (dirt bank) beside the runway.NTSB FTW89LA121Accident · No injuriesLimited investigationFinal reportBeech G35 · Roby, TXThe pilot's improper compensation for wind conditions & his failure to maintain directional control. Factors related to the accident were: the pilot's operation of the aircraft with a known deficiency (worn tire), the adverse wind conditions, and barrels…NTSB DEN89LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Red Lodge, MTInadequate compensation for the wind conditions during landing roll, resulting in a loss of control. Contributing to the accident was the gusty wind condition.NTSB CHI89LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Gladwin, MIFailure of the pilot seated in the left seat of the airplane to use brakes to correct for a left turn caused by a bent tail wheel.NTSB CHI89LA125Accident · No injuriesLimited investigationFinal reportAerofab Lake LA 4-200 · Oshkosh, WIThe pilot's encounter with unsuitable terrain (rough water) and his inability to maintain directional control.NTSB SEA89LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Orchards, WAThe failure of the pilot to align the aircraft with the landing runway on touchdown and his failure to maintain directional control during landing ground roll, resulting in a ground loop.NTSB LAX89LA227Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Julian, CAThe failure of the pilot to select the proper runway for existing wind conditions and to execute a go-around when touchdown at the proper point was not accomplished.NTSB SEA89LA125Accident · No injuriesLimited investigationFinal reportMaule M4-210 · Lopez, WAThe pilot did not maintain directional control of the airplane during the landing roll.NTSB DEN89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Durango, COThe pilot failed to maintain directional control, which resulted in an inadvertent groundloop/swerve. A factor related to the accident was: the adverse wind condition.NTSB ANC89LA107Accident · No injuriesLimited investigationFinal reportCessna 180H · Naknek, AKThe pilot's selection of an unsuitable landing area.NTSB FTW89LA119Accident · No injuriesLimited investigationFinal reportCessna A185F · Marksville, LAFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and a subsequent nose over.NTSB SEA89LA124Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kassan, AKThe excessive taxi speed used by the pilot in the existing weather conditions. Contributing to the accident was the gusty tailwind.