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 DFW06CA144Accident · No injuriesData collectionFinal reportMooney M20J · Wichita Falls, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the gusty crosswind.NTSB NYC06CA158Accident · No injuriesData collectionFinal reportBoeing A75N1 · South Hill, VAThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop and a subsequent nose over.NTSB NYC06CA141Accident · No injuriesData collectionFinal reportMaule M-5-180C · Mount Pocono, PAThe disconnected tailwheel compression spring, which resulted in a loss of directional control.NTSB NYC06CA123Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Linden, NJThe pilot's failure to maintain aircraft control during the engine run-up. Factor's in the accident were the pilot's diverted attention, and his failure to secure the airplane's left tire.NTSB DFW06CA143Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Justin, TXThe pilot's improper compensation for the prevailing high wind conditions.NTSB ANC06CA062Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate recovery from a bounced landing during the landing flare/touchdown, which resulted in a loss of control, the right wing striking the runway, and subsequent nose down when the airplane departed the runway.NTSB NYC06CA120Accident · No injuriesData collectionFinal reportPiper PA-28-280 · Tangier Island, VAThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch. A factor was the rough runway condition.NTSB LAX06CA181Accident · No injuriesData collectionFinal reportCessna 152 · Buckeye, AZthe pilot's failure to maintain directional control during landing.NTSB ANC06CA060Accident · No injuriesData collectionFinal reportCessna 180 · Sterling, AKThe pilot's inadequate compensation for a crosswind during the landing roll, which resulted in an on-ground encounter with the runway surface. Factors contributing to the accident were a crosswind, and an inadvertent ground loop.NTSB NYC06CA105Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Laconia, NHThe pilot's failure to maintain directional control during the landing.NTSB DFW06CA138Accident · No injuriesData collectionFinal reportMaule MX-7-180B · Melbourne, ARThe pilot's failure to maintain directional control while landing resulting in a ground loop. A contributing factor was the prevailing crosswind.NTSB ANC06CA061Accident · No injuriesData collectionFinal reportPiper J-3 · Hollywood, FLThe flight instructor's inadequate supervision of the instructional flight during the landing roll in crosswind conditions, which resulted in a collision with a runway sign. Factors contributing to the accident were a crosswind, and the student pilot's…NTSB ANC06LA058Accident · No injuriesLimited investigationFinal reportBoeing A75-L3 · Lake Wales, FLThe pilot's failure to maintain proper runway alignment during the takeoff roll, which resulted in a collision with trees during a precautionary landing when the airplane touched down to the right of the runway edge. A factor contributing to the accident was…NTSB SEA06CA103Accident · No injuriesData collectionFinal reportCessna 172M · Hamilton, MTThe pilot's inadequate compensation for the wind conditions during the landing roll which resulted in his failure to maintain directional control. Factors included variable winds and gusty crosswinds.NTSB LAX06CA179Accident · No injuriesData collectionFinal reportCessna A185F · Columbia, CAthe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the landing rollout.NTSB CHI06CA133Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Verdigre, NEThe pilot's decision to land on a wet grass runway that had insufficient length available for landing roll. An additional cause was the pilot's failure to properly retract the flaps during the aborted landing, resulting in diminished climb performance and the…NTSB LAX06CA177Accident · No injuriesData collectionFinal reportCessna 150M · Tucson, AZthe failure of the student pilot to maintain directional control and the certified flight instructor's delayed remedial actions and inadequate supervision of the flight.NTSB LAX06CA174Accident · No injuriesData collectionFinal reportCessna 172S · Madera, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB DFW06CA128Accident · No injuriesData collectionFinal reportBeech BE33 · Greenville, MSThe pilot's failure to maintain directional control while landing. Contributing factors were the crosswind and the gusty winds.NTSB ATL06CA081Accident · No injuriesData collectionFinal reportPiper PA28-140 · Murfreesboro, TNThe student pilot's failure to maintain directional control during landing roll.NTSB ATL06CA080Accident · No injuriesData collectionFinal reportCessna 525 · Murfreesboro, TNThe pilot's failure to maintain directional control while landing on a wet runway.NTSB NYC06CA116Accident · No injuriesData collectionFinal reportCessna 172S · Louisville, KYThe student pilot's failure to maintain directional control during the takeoff roll.NTSB DFW06CA124Accident · No injuriesData collectionFinal reportRobinson R-44 · West Monroe, LAThe pilot's loss of control while taxiing.NTSB CHI06CA126Accident · No injuriesData collectionFinal reportHelmetag Glassair III · Aurora, ILThe pilot's failure to maintain directional control during the takeoff roll. A contributing factor was the airport sign impacted during the runway excursion.NTSB ATL06CA075Accident · No injuriesData collectionFinal reportCessna C172S · Muscle Shoals, ALThe student pilot's failure to maintain directional control of the airplane during takeoff roll.NTSB LAX06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Columbia, CAthe pilot's failure to maintain directional control during the landing roll.NTSB DEN06CA071Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Rangely, COthe pilot's inadvertent application of the brake during the landing roll. A contributing factor was the pilot's failure to maintain directional control and the flight instructor's inadequate supervision during the landing.NTSB NYC06CA107Accident · No injuriesData collectionFinal reportCessna 172D · Lumberton, NJThe student pilot's failure to maintain aircraft control while landing, which resulted in an runway overrun and subsequent impact with terrain.NTSB MIA06CA100Accident · No injuriesData collectionFinal reportCessna 170B · Fort Pierce, FLThe failure of the pilot-in-command to maintain directional control during the landing roll.NTSB MIA06CA099Accident · No injuriesData collectionFinal reportHoward DGA-15P · Merritt Island, FLThe failure of the pilot to comply with the before landing checklist for his failure to lock the tailwheel.NTSB LAX06CA149Accident · Minor injuriesData collectionFinal reportM.C. Thomas Thorpe T-18 · Reno, NVthe pilot's failure to maintain directional control. A contributing factor was the certified flight instructor's inadequate supervision of the flight.NTSB CHI06CA122Accident · No injuriesData collectionFinal reportCessna 182T · Madison, WIThe student pilot's failure to maintain directional control during landing which resulted in a runway excursion and collapse of the nose landing gear. A contributing factor was the pilot's inadequate compensation for the crosswind condition. Additional…NTSB SEA06CA089Accident · No injuriesData collectionFinal reportEly Kitfox III · Lewiston, IDFailure to maintain aircraft control during the landing roll from an aborted takeoff. Excessive use of the rudder to control the airplane, the subsequent inadvertent ground loop, and the inadequate supervision by the flight instructor were factors.NTSB LAX06CA145Accident · No injuriesData collectionFinal reportCessna 170B · Redlands, CAthe student's inadequate compensation for the crosswind gust and failure to maintain directional control. Also causal was the flight instructor's inadequate supervision of the flight, and his failure to maintain directional control. A factor was control…NTSB LAX06CA144Accident · No injuriesData collectionFinal reportAviat A-1B · Chandler, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout. A contributing factor was the pilot's excessive use of the flight controls.NTSB CHI06CA123Accident · No injuriesData collectionFinal reportCessna 172E · Richmond, INThe pilot's inadequate compensation for wind conditions during the landing. Factors were the crosswind and gusts.NTSB SEA06CA083Accident · No injuriesData collectionFinal reportCubCrafters CC-18-180 · Logan, UTThe pilot receiving instruction failed to maintain airplane directional control during the landing roll, and the flight instructor's inadequate supervision. An inadvertent ground loop was a factor.NTSB CHI06CA120Accident · No injuriesData collectionFinal reportCessna 172E · Wadena, MNThe pilot's inadequate compensation for the wind conditions during the landing. Factors were the crosswinds, the gusts, and the ditch.NTSB DFW06CA105Accident · No injuriesData collectionFinal reportParks RV-7 · Fort Worth, TXThe pilot's failure to maintain directional control during the takeoff roll. A contributing factor was the prevailing crosswind.NTSB ANC06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Birchwood, AKThe flight instructor's delayed remedial action during the landing roll, which resulted in the loss of directional control by the student, a ground-loop, and collapse of the main landing gear. A factor associated with the accident was the student's failure to…NTSB MIA06LA089Accident · No injuriesLimited investigationFinal reportBeech C24R · Panama City, FLA flat tire which occurred for undetermined reasons that resulted an inadvertent loss of control during the landing roll.NTSB MIA06LA086Accident · No injuriesLimited investigationFinal reportCessna 310K · Brooksville, FLThe mechanic's improper maintenance that resulted in the right main landing gear's separation from the airplane and an inadvertent loss of control during landing.NTSB LAX06CA142Accident · No injuriesData collectionFinal reportAir Tractor 502A · Stanfield, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.NTSB DEN06CA066Incident · No injuriesData collectionFinal reportCessna 170A · Buena Vista, COThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the crosswinds and the wind gusts.NTSB CHI06CA114Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Drayton, NDThe pilot's failure to maintain directional control during takeoff. A related factor was the high wind condition.NTSB ATL06CA064Accident · Minor injuriesData collectionFinal reportCessna L-19 · Kenly, NCThe pilot's continued operation of the airplane with known deficiencies (tail wheel steering) which resulted in loss of directional control during the takeoff roll, and a ground loop.NTSB ATL06CA063Accident · No injuriesData collectionFinal reportCessna 0-1A · Kenansville, NCThe pilot's failure to maintain directional control which resulted in an ground loop, and subsequent collision with ground.NTSB DFW06CA098Accident · No injuriesData collectionFinal reportCessna 172S · Denton, TXThe student pilot's failure to maintain directional control during the takeoff roll.NTSB MIA06CA085Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Tallahassee, FLThe pilot's failure to maintain directional control during the landing rollout while making a crosswind landing in gusting conditions which resulted in an advertent ground loop and damage to the airplane.NTSB MIA06CA083Accident · No injuriesData collectionFinal reportCessna 172M · Vero Beach, FLThe pilot's failure to maintain directional control while executing a go-around in gusty conditions which resulted in the airplane veering off the runway, colliding with a ditch and nosing over.