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 MIA06CA082Accident · No injuriesData collectionFinal reportCessna C170A · Lakeland, FLThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB NYC06CA088Accident · No injuriesData collectionFinal reportCessna 172-P · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB LAX06CA137Accident · No injuriesData collectionFinal reportCessna 170A · Hanford, CAthe pilot's failure to maintain directional control.NTSB LAX06CA136Accident · No injuriesData collectionFinal reportCessna 172 · Wickenburg, AZthe pilot's failure to maintain directional control.NTSB CHI06CA103Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Grayslake, ILThe pilot failed to compensate adequately for the crosswind condition and failed to maintain directional control during the landing roll. Contributing factors included the crosswind, the narrow runway, soft ground, and the ditch.NTSB SEA06CA070Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and subsequent nose over. Contributing factors were the tailwind and the soft snow-covered terrain.NTSB ATL06CA057Accident · No injuriesData collectionFinal reportCessna 172M · Newnan, GAThe student pilot's failure to maintain directional control on the landing roll out, resulting in the airplane veering off the right side of the runway and colliding with an airport runway sign.NTSB ATL06CA056Accident · No injuriesData collectionFinal reportCessna 140 · Pageland, SCThe pilot's failure to maintain directional control during a crosswind landing resulting in the airplane veering to the right, colliding with a runway light, and subsequent nose over.NTSB MIA06CA072Accident · No injuriesData collectionFinal reportPiper PA32-301 · Key West, FLThe failure of the pilot to maintain directional control during the landing roll with a crosswind, resulting in collapse of the nose landing gear.NTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB CHI06LA101Accident · No injuriesLimited investigationFinal reportCessna 180G · Eveleth, MNThe pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane departing the left side of the runway. Contributing to the accident was the airport fence and the drainage ditch.NTSB CHI06LA100Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South St. Paul, MNThe pilot's failure to maintain directional control during landing roll, which resulted in the collapse of the right main landing gear. A factor associated with the accident was a tailwind.NTSB NYC06LA081Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Philadelphia, PAThe operator's inadequate maintenance of the fuel computer harness which resulted in engine surging and a subsequent loss of control by the flight crew during the takeoff roll.NTSB MIA06LA068Accident · No injuriesLimited investigationFinal reportChampion 7EC · Zellwood, FLA loss of directional control due to the spring connecting the rudder to the tailwheel horn being detached.NTSB MIA06CA065Accident · No injuriesData collectionFinal reportCessna 172 · Leesburg, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with a taxiway sign.NTSB LAX06CA128Accident · No injuriesData collectionFinal reportCirrus SR22 · Scottsdale, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB DEN06CA047Accident · Minor injuriesData collectionFinal reportBoeing D75N1 · Santa Teresa, NMthe pilot's failure to maintain directional control during the landing. Contributing factors include the high airspeed, the improper recovery from a bounced landing, the crosswind, and the soft dirt.NTSB ANC06LA024Accident · No injuriesLimited investigationFinal reportCessna 185 · Ely, NVThe pilot's inadequate compensation for a quartering tailwind while taxiing, which resulted in a loss of control and an on ground encounter with terrain. A factor in the accident was the quartering crosswind.NTSB ANC06LA022Accident · No injuriesLimited investigationFinal reportPiper PA-24 · El Cajon, CAThe student pilot's failure to maintain directional control during takeoff, which resulted in an on ground collision with a sign, and the collapse of the main landing gear.NTSB ANC06CA033Accident · No injuriesData collectionFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane colliding with a snowbank and nosing over.NTSB MIA06CA059Accident · No injuriesData collectionFinal reportPiper PA-18 · SanJuan, PRThe pilot's failure to maintain directional control during landing.NTSB ANC06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24 · La Vern, CAThe pilot's excessive taxi speed while turning, which resulted in an on ground collision with a taxiway light and the ground.NTSB DFW06LA074Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Forrest City, ARThe pilot's failure to follow proper procedures while attempting to start the engine by hand-proping the engine.NTSB ANC06CA031Accident · No injuriesData collectionFinal reportRobinson R22 · Anchorage, AKThe pilot's decision to land the helicopter on an icy airport parking ramp, which resulted in a loss of control on touchdown, and subsequent collision with another parked and unoccupied helicopter.NTSB LAX06CA117Accident · No injuriesData collectionFinal reportCessna 172M · Prescott, AZthe pilot's inadequate compensation for the crosswind conditions and his failure to maintain directional control.NTSB MIA06LA052Accident · No injuriesLimited investigationFinal reportCessna 501 · Fort Pierce, FLmechanical binding of the normal brake system, rendering directional control impossible. Contributing factors were the improper overhaul, inadequate quality control procedures by the overhaul facility, and the rough terrain.NTSB LAX06LA112Accident · Minor injuriesLimited investigationFinal reportGlobe Swift GC-1A · Rancho Murieta, CAthe pilot's failure to maintain directional control of the airplane on the landing roll.NTSB CHI06CA083Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe solo student pilot's failure to properly compensate for the crosswind, resulting in his failure to maintain directional control during landing. Factors were the crosswind and the snow bank.NTSB DFW06CA065Accident · No injuriesData collectionFinal reportRalph Sanders Murphy Acft Elite · Presidio, TXThe pilot's failure to maintain directional control during the takeoff roll.NTSB NYC06CA067Accident · No injuriesData collectionFinal reportPergerson Highlander · Appomattox, VAThe pilot's failure to maintain directional control during landing. A factor in the accident was the pilot's improper use of flaps.NTSB NYC06CA065Accident · No injuriesData collectionFinal reportCessna A185F · Pembroke, MAThe pilot's failure to maintain control during the takeoff roll, which resulted in a ground loop and subsequent impact with trees. A factor was the soft runway as reported by the pilot.NTSB LAX06CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Maricopa, AZThe pilot's failure to maintain directional control during landing rollout. A factor was the soft dirt adjacent to the runway.NTSB DFW06CA061Accident · No injuriesData collectionFinal reportMaule M-7-260C · Lakeview, ARThe pilot's failure to compensate for existing wind conditions during the landing roll. Contributing factors were the prevailing crosswind, and wet terrain.NTSB MIA06CA047Accident · No injuriesData collectionFinal reportCessna 152 · Lantana, FLThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in the nosegear collapsing, the airplane veering off the runway, and nosing over.NTSB NYC06CA057Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Haven, CTThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of aircraft control during landing and subsequent impact with a ditch.NTSB DFW06CA059Accident · No injuriesData collectionFinal reportPietenpol Aircamper · Lometa, TXThe pilot's failure to maintain directional control while landing. Contributing factors were the sun glare and the rough and uneven landing area.NTSB DFW06LA057Accident · No injuriesLimited investigationFinal reportAgusta A109E · Fort Worth, TXThe pilot's inadvertent encounter with ground resonance which resulted in the destruction of the helicopter.NTSB DEN06CA033Accident · No injuriesData collectionFinal reportCessna 172M · Denver, COthe pilot's failure to align the airplane's nose into the direction of the wind while performing the pre-takeoff checklist. A contributing factor was the gusty wind conditions.NTSB CHI06LA281Accident · No injuriesLimited investigationFinal reportUnivar Ercoupe · Howell, MIThe student pilot's improper landing flare and lack of total experience.NTSB LAX06CA086Accident · Minor injuriesData collectionFinal reportBellanca 7KCAB · Fallbrook, CAthe student pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control.NTSB LAX06CA085Accident · Minor injuriesData collectionFinal reportPiper Seneca · Van Nuys, CAThe pilot's failure to maintain directional control during landing. Also causal was the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB SEA06CA041Accident · No injuriesData collectionFinal reportCessna 172A · Othello, WAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the berm.NTSB DEN06CA032Accident · Minor injuriesData collectionFinal reportCessna 170B · Ulysses, KSthe pilot's failure to maintain directional control during the landing, resulting in a ground loop.NTSB DEN06CA030Accident · No injuriesData collectionFinal reportAppel Mustang II · Erie, COthe pilot's inadequate preflight decision to depart in gusty winds, and the pilot's failure to maintain direction control during the departure roll. The high gusty crosswind contributed to the accident.NTSB CHI06LA062Accident · No injuriesLimited investigationFinal reportBeech A100 · Sault Ste Marie, MIThe inadequate in-flight decision to continue the approach to land, directional control not maintained, and the contaminated runway. Contributing factors were flight to destination alternate not performed, a notice to airman not issued by airport personnel…NTSB LAX06LA073Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Boulder City, NVThe pilot's inadequate preflight inspection and failure to follow the airplane's checklist, which resulted in his failure to remove the gust lock prior to flight.NTSB LAX06CA074Accident · No injuriesData collectionFinal reportAvid Mark IV · California City, CAthe pilot's inadequate compensation for the crosswind and failure to maintain directional control of the airplane on takeoff.NTSB DFW06CA070Accident · No injuriesData collectionFinal reportBeech C23 · Eureka Springs, ARThe pilot's failure to maintain directional control while landing and his delay in aborting the landing.NTSB DFW06CA044Accident · No injuriesData collectionFinal reportChampion 7ECA · Fredericksburg, TXThe pilot's failure to maintain directional control on the landing roll-out. A factor was the crosswind.NTSB NYC06CA051Accident · No injuriesData collectionFinal reportPiper PA-22 · Jamestown, NYThe pilot's failure to maintain directional control during the landing rollout. Factors included the ice on the runway and the soft terrain.