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 CHI05LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Grafton, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control during the landing. Factors associated with the accident were the crosswind condition and the snow bank.NTSB CHI05CA072Accident · No injuriesData collectionFinal reportGulfstream American 690C · Indianapolis, INThe pilot's failure to maintain directional control during landing touchdown and rollout. Contributing factors were the pilot's inadequate compensation for the crosswind condition, the runway light which the aircraft struck and the muddy grass area…NTSB CHI05CA068Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Larimore, NDThe CFI's delay in applying remedial action which resulted in a loss of directional control of the airplane. Factors associated with the accident were the student's excessive application of rudder and the snow bank which the airplane contacted.NTSB IAD05CA037Accident · No injuriesData collectionFinal reportCessna 172P · Cross Keys, NJThe pilots failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the snow bank.NTSB NYC05LA049Accident · Minor injuriesLimited investigationFinal reportAeronca 65CA · Ravenswood, WVThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB LAX05LA085Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAa loss of directional control due to a jammed rudder pedal, which prevented the pilot from exercising full rudder control authority.NTSB SEA05CA043Accident · No injuriesData collectionFinal reportCessna 172N · Idaho Falls, IDThe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. A contributing factor was the deep snow beside the runway.NTSB NYC05CA047Accident · No injuriesData collectionFinal reportBell 206B · Lancaster, PAThe pilot's loss of lateral control while attempting to transition to a hover from the ground. A factor was the bright sunlight conditions.NTSB MIA05CA064Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ocala, FLThe pilot-rated passengers improper use of the rudder control and his failure to maintain directional control resulting in a loss of control on the ground.NTSB ANC05LA025Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Toksook Bay, AKThe pilot's inadequate compensation for the gusty crosswind wind condition, which resulted in a loss of control during the landing roll, and the collapse of the nose landing gear. Factors associated with the accident were the crosswind and wind gusts.NTSB CHI05CA058Accident · No injuriesData collectionFinal reportCessna 172F · Willmar, MNThe student pilot's failure to properly compensate for the crosswind conditions and his failure to maintain directional control during the landing rollout. Contributing factors were the crosswind and the snow bank.NTSB SEA05LA039Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lewiston, IDThe pilot's failure to maintain directional control during the landing roll. Wind gusts and the pilot's inadequate compensation for wind conditions were factors.NTSB MIA05CA053Accident · No injuriesData collectionFinal reportLee Harold Swarthout Velocity Xlrg · Daytona Beach, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with a fence and a ditch.NTSB DFW05CA060Accident · No injuriesData collectionFinal reportSabreliner 40 · San Antonio, TXThe failure of the aircraft hydraulic system as result of improper maintenance by company maintenance personnel.NTSB DFW05CA057Accident · No injuriesData collectionFinal reportCessna 182J · Malvern, ARThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the sun glare.NTSB ANC05TA022Accident · No injuriesFinal reportCessna 185 · Eek, AKThe pilot's inadequate evaluation of weather conditions, which resulted in an on ground encounter with terrain during the landing roll. Factors associated with the accident were a tailwind, and snow-covered, icy terrain conditions.NTSB DFW05CA050Accident · No injuriesData collectionFinal reportReinhart GP-4 · Fort Worth, TXThe pilot's failure to compensate for the prevailing crosswind. A contributing factor was the crosswind.NTSB LAX05CA067Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB LAX05CA066Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB ATL05CA040Accident · No injuriesData collectionFinal reportChampion 7FC · Soperton, GAThe pilot's failure to maintain directional control of the airplane during takeoff roll, which resulted in an on-ground collision with trees. A factor was the pilot's lack of experience in a tailwheel airplane.NTSB NYC05LA044Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Cleveland, OHThe pilot's failure to maintain directional control during landing, which resulted in an impact with a sign.NTSB MIA05CA048Accident · No injuriesData collectionFinal reportCessna 172SP · Clewiston, FLThe pilot's failure to maintain directional control during landing rollout which resulted in the airplane veering off the runway and colliding into an airport sign.NTSB IAD05LA030Accident · No injuriesLimited investigationFinal reportBeech G35 · Falmouth, MAThe pilot's failure to maintain control of the airplane during taxi. A factor was the snow-covered taxiway.NTSB NYC05LA034Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Smoketown, PAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a parked airplane.NTSB DFW05CA046Accident · No injuriesData collectionFinal reportCessna 172P · Houston, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the muddy condition of the terrain.NTSB ATL05CA036Accident · No injuriesData collectionFinal reportChampion 7-GCAA · Talladega, ALThe binding right wheel brake that resulted in a loss of control during landing roll. A factor was the drainage ditch.NTSB SEA05CA030Accident · No injuriesData collectionFinal reportFairchild 24W-41A · Wenatchee, WAThe pilot's failure to maintain directional control during the landing roll. A frozen brake was a factor.NTSB ANC05CA019Accident · No injuriesData collectionFinal reportCessna U206G · Illiamna, AKThe pilot's inadequate compensation for the gusty wind conditions, which resulted in a loss of control, and the airplane nosing over. A factor contributing to the accident was the gusty wind condition.NTSB LAX05LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Phoenix, AZthe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control during landing.NTSB SEA05CA029Accident · No injuriesData collectionFinal reportBeech 58TC · Everett, WAThe pilot's misjudgment of distance/speed on landing touchdown and rollout, and his subsequent excessive braking. A factor was the fence.NTSB NYC05CA031Accident · No injuriesData collectionFinal reportFlight Design CT-2K · Waynesboro, VAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.NTSB DFW05LA045Accident · No injuriesLimited investigationFinal reportCessna 421C · Henderson, TXThe failure of the nose landing gear trunnion lug. A contributing factor was the non-compliance of the service bulletin by maintenance personnel.NTSB DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB MIA05LA043Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakeland, FLThe faulure of the pilot to maintain directional control of the aircraft during the landing roll resulting in the on-ground collision with a taxiway sign and subsequent collapse of the nose landing gear.NTSB ANC05CA017Accident · No injuriesData collectionFinal reportCessna U206G · Nunapitchuk, AKThe pilot's inadequate compensation for gusty wind conditions, which resulted in a loss of directional control, and collision with a ditch. Factors contributing to the accident were an icy taxiway and wind gusts.NTSB LAX05CA052Accident · No injuriesData collectionFinal reportClassic Waco YMF · Santa Barbara, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during landing rollout, which resulted in a ground loop.NTSB CHI05CA043Accident · No injuriesData collectionFinal reportBellanca 14-19 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A contributing factorwas the approach light.NTSB LAX05CA047Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kapolei, HIthe pilot's failure to maintain directional control, which resulted in a collision with an obstacle.NTSB MIA05CA041Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Holly Springs, MSThe failure of the pilot to maintain directional control of the airplane while performing a go-around after a bounced landing, resulting in the on ground collision with trees.NTSB DFW05LA029Accident · No injuriesLimited investigationFinal reportConvair 580 · McAllen, TXThe failure to activate the hydraulic pump which resulted in the pilot's inability to maintain directional control.NTSB DEN05LA031Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe student pilot's failure to maintain directional control during landing.NTSB CHI05CA040Accident · Minor injuriesData collectionFinal reportCessna 182P · Belle Fourche, SDThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Contributing factors were the gusting crosswind, the pilot's lack of night flying of experience, the inoperative instrument lights, and the night…NTSB LAX05LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Prescott, AZthe pilot's failure to maintain directional control during landing rollout. A contributing factor in the accident was the pilot's unfamiliarity with the airplane.NTSB NYC05CA019Accident · No injuriesData collectionFinal reportVigneau RAF 2000 GTX · Chatham, MAThe pilot's failure to maintain aircraft control during a takeoff. A factor related to the accident was the pilot's lack of experience in gyroplanes.NTSB DEN05LA028Accident · No injuriesLimited investigationFinal reportFarrell Lancair LC3 · Las Cruces, NMthe pilot's failure to maintain directional control during takeoff.NTSB ANC05LA015Accident · No injuriesLimited investigationFinal reportCessna U206F · Bethel, AKThe pilot's inadequate evaluation of the weather conditions, and his inadequate compensation for the wind conditions, which resulted in a loss of control and subsequent nose over during taxi from landing. A factor contributing to the accident was a tailwind.NTSB DEN05LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Loveland, COthe student pilot's failure to maintain directional control during landing and the student pilot's inadequate in-flight planning and decision making. Contributing factors include the quartering tail wind, the high airspeed, and the airport sign.NTSB SEA05LA015Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Redmond, ORThe student pilot's failure to maintain directional control during the landing roll. Also causal were the instructor's inadequate supervision and remedial action. Factors include soft terrain just off the side of the runway.NTSB LAX05LA037Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · San Diego, CAthe flight instructor's failure to maintain directional control during the landing rollout.NTSB IAD05LA011Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Clarksburg, WVThe pilot's inability to operate the airplane's brake pedals which resulted in the loss of aircraft control.