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 NYC90LA221Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions AX-7 · Binghamton, NYThe pilot's failure to maintain control of the balloon during touchdown resulting in the basket of the balloon tipping. Factors to the accident were the slope of the terrain and the wind.NTSB FTW90LA148Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARPilot's initiation of the abort with excess airspeed. A contributing factor was the engine tachometer overspeed.NTSB LAX90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZThe failure of the pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's improper use of the airplane brakes.NTSB CHI90LA206Accident · No injuriesLimited investigationFinal reportBeech D17S · Oelwein, IAInadequate visual outlook by the pilot in command.NTSB ANC90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big River, AKThe improper use of brakes by the pilot during the landing roll.NTSB CHI90LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · East Tawas, MIThe private pilot's failure to maintain adequate control of the aircraft after touchdown.NTSB SEA90LA145Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Missoula, MTPilot's failure to maintain directional control during the landing roll.NTSB ANC90LA122Accident · No injuriesLimited investigationFinal reportCessna 172F · Lake Louise, AKThe pilot's failure to maintain directional control during landing. A contributing factor was a crosswind.NTSB NYC90LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hudson, NYThe failure of the pilot to maintain directional control during a rejected landing. Factors related to the accident were: improper use of the flight controls by the pilot, a variable wind, and lack of expereince in type of airplane.NTSB FTW90LA142Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Worth, TXPilot's failure to maintain directional control. Contributing to the accident was the pilot's diverted attention.NTSB NYC90LA166Accident · No injuriesLimited investigationFinal reportCessna 150M · New Knoxville, OHThe pilot's improper use of flight controls which resulted in loss of directional control during the takeoff ground run.NTSB SEA90LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Klamath Falls, ORPilot's failure to maintain directional control during the landing roll, resulting in a ground loop. The pilot's lack of experience in this make/model was a related factor.NTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.NTSB ANC90LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Moller, AKThe pilot failed to maintain directional control during landing. Contributing to the accident were the unfavorable winds, the soft runway surface, and the pilot's lack of training and total experience.NTSB NYC90LA160Accident · 1 fatalLimited investigationFinal reportCessna U206F · Augusta, MEImproper planning/decision by the pilot, and his failure to compensate for wind conditions. The unfavorable wind conditions and rough water were related factors.NTSB FTW90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Houston, TXStudent pilot's failure to maintain directional control during landing.NTSB MKC90LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egypt, ARThe pilot's failure to maintain directional control. A factor related to the accident was the soft/muddy area on the runway.NTSB DEN90LA162Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Logan, UTThe pilot's failure to maintain directional control and his improper use of the wheel brakes. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB DEN90LA160Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Akron, COThe pilot's failure to correct a swerve during landing roll. A factor was wind gusts.NTSB CHI90LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pulaski, WIThe pilot's failure to maintain positive control of the airplane while landing. Factors related to the accident were the pilot's lack of total flight experience, and inadequate compensation for crosswind conditions.NTSB SEA90LA126Accident · Minor injuriesLimited investigationFinal reportHardesty/Hays Quickie Q2 · Twisp, WAThe pilot's failure to maintain directional control during the landing roll. Factors related to the accident were: the high weeds on the sides of the grass/dirt strip and the dirt berm.NTSB NYC90LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · High Point Lake, PAA loss of control upon touchdown and during the go around, which resulted in uncontrolled contact with the windsock and a rock quarry. Contributing was the excessive speed of the aircraft (reported 80 knots) upon initial touchdown.NTSB LAX90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Davis, CAThe pilot failed to maintin directional control by improperly using the brakes.NTSB ANC90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe pilot's failure to maintain directional control during the landing roll.NTSB CHI90LA168Accident · No injuriesLimited investigationFinal reportBeech V35B · Lockport, ILThe pilot's failure to maintain aircraft directional control and keep the aircraft on the runway during the landing roll.NTSB SEA90LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Island Park, IDPilot's failure to maintain directional control, while attempting a soft-field takeoff. The crosswind was a related factor.NTSB CHI90DEC03Accident · Serious injuriesFinal reportMaxair MU532 · Troy, MIThe pilot's improper remedial action to regain directional control during the landing.NTSB ANC90LA106Accident · No injuriesLimited investigationFinal reportCessna 180K · Homer, AKThe pilot loss of directional control.NTSB BFO90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · S. Charleston, WVPilot's failure to maintain directional control of the airplane. A related factor crosswind conditions.NTSB ANC90LA102Accident · Minor injuriesLimited investigationFinal reportGrumman G21 · King Salmon, AKThe pilot failed to adequately compensate for the prevailing wind conditions and his failure to maintain directional control. A contributing factor was the strong crosswind component.NTSB FTW90LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Houston, TXFailure to maintain directional control.NTSB ANC90LA099Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control on landing. The pilot's lack of familiarity with this type airplane (large tires/tail wheel combination), and his lack of total experience were contributing factors.NTSB SEA90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Sitka, AKFailure of the pilot to maintain directional control of the airplane during the landing roll. The crosswind condition was a factor related to the accident.NTSB ANC90LA100Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olson Creek, AKThe pilot's selection of unsuitable terrain.NTSB MKC90LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Tecumseh, NEExcessive taxi speed and directional control not maintained by the pilot in command.NTSB BFO90LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Clinton, MDThe student pilot's failure to maintain directional control of the aircraft and his improper use of the throttle control. Contributing to the accident was the student's lack of total experience.NTSB ANC90LA096Accident · No injuriesLimited investigationFinal reportShort Brothers SH-7 · Kako Mine Strip, AKThe pilot-in-command's failure to maintain control of the airplane through the touchdown and landing phase.NTSB SEA90LA107Accident · No injuriesLimited investigationFinal reportRobert C. Campbell Quickie · Arlington, WAThe pilot did not maintain directional control of the airplane.NTSB SEA90LA104Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Spokane, WAThe pilot was taxiing the airplane at an excessive speed which resulted in a loss of directional control.NTSB ATL90LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNPilot's failure to maintain directional control upon landing and subsequent premature rotation of the airplane during the go-around attempt. Contributing to the accident was the pilot's lack of total experience.NTSB DEN90LA138Accident · No injuriesLimited investigationFinal reportBuchanan S1-S · Albuquerque, NMThe failure of the pilot in command to adequately compensate for the wind conditions and to maintain directional control during landing roll. A contributing factor was the failure of the tailwheel locking assembly.NTSB CHI90LA156Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Aurora, ILThe pilot's inadequate compensation for wind conditions, and his not maintaining proper directional control on landing.NTSB MKC90LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Altheimer, ARDirectional control was not maintained by the pilot in command. Contributing factors were landing with a tailwind. Compensation for wind conditions not considered and selection of the wrong runway.NTSB LAX90LA226Accident · No injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the pilot's improper compensation for the gusty wind conditions, and her improper bounced landing recovery.NTSB LAX90LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Show Low, AZThe pilot improperly used the flight controls and failed to maintain directional control.NTSB LAX90DVA05Accident · No injuriesFinal reportVans RV-3 · Bakersfield, CAThe pilots loss of directional control after a touch and go landing in a newly acquired homebuilt aircraft. Contributing to the accident was the pilots lack of experience in this aircraft.NTSB NYC90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Middleton, RILoss of direction control by the pilot when he came in high and fast and touched down at improper touchdown point.NTSB NYC90LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Tarentum, PAAirplane nosed over during landing rollout after the pilot failed to maintain directional control on the runway and improperly used the brakes.NTSB ANC90LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Deshka River, AKThe pilot-in-command's failure to maintain directional control.NTSB LAX90LA217Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot failed maintain directional control by his failure to compensate for the existing wind conditions.