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 CHI92LA080Accident · No injuriesLimited investigationFinal reportCessna 182 · Omaha, NEThe pilot's inadequate compensation for the wind conditions. Associated factors are the high and gusty winds.NTSB CHI92LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · New Haven, MIDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. A factor related to the accident was the icy runway conditions.NTSB LAX92LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Boulder, NVThe student pilot's failure to maintain directional control of the airplane during the takeoff portion of a touch an go landing. A factor which contributed to the accident was the student's lack of experience in the type of operation.NTSB CHI92LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Zenda, WIDirectional control was not maintained by the pilot. Factors related to the accident were: a gusty surface wind condition and lack of total experience by the pilot.NTSB BFO92LA023Accident · No injuriesLimited investigationFinal reportCessna 182-D · Put In Bay, OHThe pilot's failure to maintian directional control during landing. Contributing to the accident were the snow on the runway and the gusty winds.NTSB DEN92LA026Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COLoss of directional control when the student pilot inadvertently activated the brakes during takeoff roll. Inadequate supervision by the certified flight instructor was a factor.NTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.NTSB ANC92LA027Accident · No injuriesLimited investigationFinal reportCessna 206 · English Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the ice and slush on the runway, the snowbank, and the crosswind.NTSB ANC92LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Atmautluak, AKThe pilot selected unsuitable terrain. Factors contributing to the accident were the dawn light condition and the snow on the runway.NTSB LAX92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Young, AZThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the soft muddy runway conditions at the dirt airstrip.NTSB SEA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTDirectional control was not maintained. A factor to the accident was: the pilot's lack of total flight experience.NTSB LAX92LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT-300 · Big Bear City, CAThe failure of the pilot to maintain directional control and improper use of the rudder. Contributing to the accident was the improper installation by the company of a hand control mechanism that required the pilot to operate the airplane controls with one…NTSB FTW92LA052Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cottonport, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB ANC92LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Tatitlek, AKThe pilot's failure to perform a go around. Contributing to the accident was the icy runway condition and the failure of the fss personnel to properly issue and disseminate a NOTAM concerning the icy runway condition.NTSB DEN92LA019Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Aurora, COThe pilot failed to maintain control of the aircraft. A factor was: improper supervision by the flight instructor.NTSB LAX92LA066Accident · No injuriesLimited investigationFinal reportCessna 150G · Point Mugu, CAThe pilot's disregard of the available wind information. Contributing to this accident was a high tail wind.NTSB CHI92LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Point Lookout, MOFailure of the pilot to attain the proper touchdown Point and maintain directional control of the aircraft. A factor related to the accident was: a go-around was not performed by the pilot.NTSB CHI92LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Minneapolis, MNRemedial action was not performed by the CFI. A factor related to the accident was directional control was not maintained by the student pilot.NTSB MIA92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the pilot to maintain directional control during the landing roll. This resulted in the collision with a sign. Contributing to the accident was his lack of total experience.NTSB CHI92LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbury, NEThe pilot's improper use of the brakes. An associated factor is the pilot's lack of total experience in the type airplane.NTSB CHI92FA044Accident · 1 fatalField investigationFinal reportPiper PA-32RT/300T · Camdenton, MOThe pilot's disregard for wind conditions, not aborting the takeoff, and inadequate remedial action by the pilot after the airplane became airborne. Factors associated with the accident are an inadequate weather evaluation by the pilot, not maintaining…NTSB LAX92LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Bakersfield, CAThe pilot's failure to maintain directional control of the aircraft during the landing roll due to inadequate compensation for the existing wind conditions. A factor in the accident was the pilot's lack of total experience.NTSB FTW92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Roads, LAThe student pilot's loss of directional control and the resultant ground loop. Factors were the cfi's lack of supervision and the ditch adjacent to the runway.NTSB CHI92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Indianapolis, INRemedial action was not performed by the cfi/pic. A factor related to the accident was directional control was not maintained by the student pilot.NTSB CHI92LA046Accident · No injuriesLimited investigationFinal reportCessna 421 · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing. A factor contributing to the accident was the icy runway.NTSB CHI92LA041Accident · No injuriesLimited investigationFinal reportCessna 210N · Frankfort, ILThe failure of the fss to notify ATC that the ariport was closed, atc's subsequent approach clearance to the closed airport, and the pilot's inability to maintain directional control on the icy runway. A factor in the accident was the icy runway conditions.NTSB SEA92LA025Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AC · Missoula, MTThe pilot's inability to maintain directional control during takeoff. Factors include a dragging brake.NTSB LAX92LA056Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Palo Alto, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB FTW92LA028Accident · No injuriesLimited investigationFinal reportCessna 120 · Las Cruces, NMThe pilot's failure to maintain directional control. A factor was the tailwind.NTSB LAX92LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · Long Beach, CAThe failure of the pilot to maintain directional control during the landing touchdown.NTSB CHI92LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Decorah, IAInadequate compensation for wind conditions, which resulted in a loss of directional control. Factors related to the accident were: the unfavorable wind conditions, snow covered runway, and snowbanks adjacent to the runway.NTSB MIA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe pilot-in-command's improper use of the rudder controls and brakes. A contributing factor was his lack of total experience.NTSB FTW92LA034Accident · No injuriesLimited investigationFinal reportCessna 172P · Okmulgee, OKThe pilot's failure to compensate for a crosswind condition. Factors were the pilot's lack of total experience and the prevailing crosswind.NTSB CHI92LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Shenandoah, IAThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. An associated factor is the pilot's lack of experience in this type operation (crosswind takeoffs).NTSB ATL92LA023Accident · No injuriesLimited investigationFinal reportGeorga L. Atwood Kitfox III · Trezevant, TNThe pilot's improper handling of the airplane which resulted in a noseover.NTSB LAX92LA040Accident · No injuriesLimited investigationFinal reportMaule M4-220C · Coolidge, AZThe pilot's failure to maintain directional control of the aircraft during the takeoff ground run due to inadequate compensation for the existing wind conditions. A factor in this accident was the unfavorable wind reported by the pilot.NTSB ANC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Stebbins, AKThe pilot's failure to adequately compensate for the wind during landing. Factors were the crosswind and the attempted go aroundNTSB FTW92LA021Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Teresa, NMThe pilot's failure to initiate corrective action in a timely fashion.NTSB LAX92LA052Accident · No injuriesLimited investigationFinal reportCessna 195A · Camarillo, CAThe failure of the pilot to maintain directional control during the landing ground roll.NTSB LAX92LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Reedley, CAThe student pilot's improper use of the flight controls and his failure to maintain directional control of the aircraft. A contributing factor in the accident was the students lack of total experience.NTSB DEN92IA007Incident · No injuriesIncident investigationFinal reportDouglas DC-10-10 · Colorado Spring, COThe captain's inadequate supervision and the copilot's failure to maintain directional control. Factors were: the crosswind and snow/ice on the runway.NTSB FTW92LA018Accident · Minor injuriesLimited investigationFinal reportMahan Hardaway Quickie Q2 · Arcola, TXThe pilot's improper flare and improper recovery from the resultant bounced landing. A factor was the pilot's lack of familiarity with the airplane.NTSB ATL92LA011Accident · No injuriesLimited investigationFinal reportWinchester Thorp T-18 · Walterboro, SCThe student pilot's improper use of the wheel brakes, and the subsequent loss of directional control. Factors in this accident were the student pilot's lack of total flying experience and the pilot-in-command's inadequate supervision of the flight.NTSB LAX92LA018Accident · No injuriesLimited investigationFinal reportSnow S2C · Bowie, AZThe failure of the pilot to maintain directional control after landing. The unfavorable wind condition was a related factor.NTSB FTW92GA011Accident · No injuriesFinal reportCessna T21OR · Lordsburg, NMThe pilot's improper recovery from a bounced landing. Factors were the pilot's excessive airspeed and improper flare technique.NTSB CHI92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 II · Lee'S Summit, MOThe student pilot's failure to maintain directional control. Related factors are the student's lack of total experience, improper touch and go procedures, and diverted attention.NTSB CHI92LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Sioux Center, IAThe pilot in command's not maintaining directional control and not performing an aborted takeoff. Windshear was a factor relating to the accident.NTSB ANC92LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Berners Bay, AKThe pilot's loss of control during the pre takeoff taxi, due to his improper handling of the airplane. Contributing to the accident was the soft takeoff area.NTSB MIA92LA013Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Sebring, FLFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and collision with tall grass beside the runway. The tall grass was a related factor.