NTSB investigations, 2001
215 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 372 |
|---|---|
| 1983 | 374 |
| 1984 | 329 |
| 1985 | 295 |
| 1986 | 315 |
| 1987 | 331 |
| 1988 | 295 |
| 1989 | 235 |
| 1990 | 278 |
| 1991 | 244 |
| 1992 | 217 |
| 1993 | 232 |
| 1994 | 213 |
| 1995 | 210 |
| 1996 | 221 |
| 1997 | 219 |
| 1998 | 224 |
| 1999 | 247 |
| 2000 | 229 |
| 2001 | 215 |
| 2002 | 204 |
| 2003 | 240 |
| 2004 | 217 |
| 2005 | 228 |
| 2006 | 213 |
| 2007 | 232 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2001
AND 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 year(c."eventDate") = 2001 AND 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 IAD02LA023Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Martinsville, VAThe pilot's premature rotation and his failure to maintain directional control during the takeoff roll.NTSB SEA02LA029Accident · No injuriesLimited investigationFinal reportPilatus PC-12 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll. An icy runway and a snow bank were factors.NTSB LAX02LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Long Beach, CAThe student pilot's inadequate compensation for wind, and his failure to maintain directional control of the aircraft during the landing roll.NTSB CHI02LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Olathe, KSThe pilot's failure to maintain directional control during landing resulting in the overload of the nose gear fork. The overload failure of the nose landing gear fork, the embankment, and the remedial action not possible were contributing factors.NTSB LAX02LA052Accident · No injuriesLimited investigationFinal reportCessna 185F · Reno, NVWear on the tail wheel thrust plate spacers resulted in the compression springs binding on the thrust plates and the tail wheel sticking, so that the pilot could not maintain directional control.NTSB DEN02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Crested Butte, COa wet brake that later froze resulting in a loss of directional control on landing. A contributing factor was the snow bank.NTSB LAX02LA051Accident · No injuriesLimited investigationFinal reportVernon Sonerai IIL · Camarillo, CAFailure of the pilot to maintain directional control on the landing rollout. Factors were the owner/pilot's inadequate remedial design changes and the freshly plowed field.NTSB FTW02LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · New Braunfels, TXThe student pilot's failure to maintain directional control of the airplane during the landing roll. A contributing factor was the soft terrain.NTSB DEN02LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COthe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the crosswind.NTSB SEA02LA020Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Halfway, ORA loss of aircraft control for undetermined reasons. A factor was a snow-covered landing surface.NTSB NYC02LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHThe student pilot's failure to maintain directional control.NTSB MIA02LA042Accident · 1 fatalLimited investigationFinal reportFerguson A 26 Vulcan SS · Newnan, GAThe pilot's failure to maintain directional control during landing and go-around, resulting in a collision with a runway perimeter fence pole and trees.NTSB CHI02LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devils Lake, NDThe student pilot's failure to maintain directional control of the airplane during the takeoff phase of a touch and go landing. Factors associated with the accident were the student's lack of total experience and the runway light which the airplane contacted.NTSB CHI02LA039Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Harrisonville, MOdirectional control not maintained be the pilot during landing rollout. The ditch was a contributing factor.NTSB IAD02LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe pilot's failure to maintain directional control of the airplane during landing. A factor was the crosswind.NTSB LAX02LA029Accident · No injuriesLimited investigationFinal reportAviat S-2C · Chandler, AZFailure of the flight instructor to maintain directional control resulted in a departure from the runway surface and collision with a runway sign.NTSB LAX02LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Chandler, AZFailure of the student pilot to maintain directional control during landing.NTSB IAD02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, NYThe CFI's delayed remedial action, which resulted in a loss of control during landing rollout and impact with a parked airplane.NTSB LAX02LA021Accident · No injuriesLimited investigationFinal reportCessna 182S · Palm Springs, CAThe failure of the pilot-in-command to maintain directional control of the airplane after encountering a dust devil during landing roll.NTSB CHI02LA038Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Hawley, MNthe failure of the pilot to maintain directional control. A factor was the trees.NTSB CHI02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Decatur, ILThe excessive braking performed by the flight instructor.NTSB LAX02LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Prescott, AZThe CFI's improper remedial action and failure to maintain directional control during landing in a strong crosswind condition.NTSB ATL02LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Wales, FLThe pilot's improper decision to land on a wet sod runway which resulted in a loss of directional control during landing. Factors were the wet grass strip which allowed the airplane to hydroplane.NTSB NYC02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Buckhannon, WVThe student pilot's failure to maintain directional control while landing. A factor related to the accident were the gusting wind conditions.NTSB NYC02LA015Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-105 · Morgantown, WVThe passengers failure to remain in the balloon basket after landing which resulted in the inadvertent lift-off of the balloon and subsequent injury to the pilot. A factor related to the accident was the pilot's failure to perform a passenger briefing prior…NTSB LAX02LA011Accident · No injuriesLimited investigationFinal reportCessna A185E · Winnemucca, NVThe pilot's inadequate compensation for the wind conditions, failure to maintain directional control and use of excessive braking, which resulted in the airplane nosing over.NTSB NYC02LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Farmville, VAThe CFI's failure to maintain directional control during the takeoff. A factor in the accident was the CFI's decision to conduct the flight from the airplane's right seat, which was not equipped with brakes.NTSB ATL02LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Goldsboro, NCThe student pilot's failure to maintain directional control during a touch-and-go landing.NTSB CHI02LA011Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ann Arbor, MIThe pilots failure to maintain directional control during the landing. Factors were the gusty crosswind and the terrain drop-off.NTSB FTW02LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Midlothian, TXthe pilot's failure to maintain control of the aircraft while taxiing from a landing. A contributing factor was the gusty wind conditions.NTSB LAX02LA005Accident · Minor injuriesLimited investigationFinal reportAero Commander 690 · Temecula, CAa misrigging of the engine controls that resulted in an asymmetric reverse thrust condition.NTSB SEA02LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Boardman, ORThe pilot-in-command's inability to maintain control of the aircraft while taxiing from landing resulting in a nose over. Contributing factors were high winds, crosswind conditions during taxi, and gusty wind conditions.NTSB CHI02LA004Accident · No injuriesLimited investigationFinal reportCessna 172N · Beaver Island, MIThe pilot not maintaining directional control of the airplane during landing. The gusty crosswind and the berm were factors.NTSB ANC02TA001Accident · No injuriesFinal reportCessna 185F · Bethel, AKThe pilot's inadequate compensation for wind conditions. Factors associated in the accident were a crosswind, and a worn tailwheel steering horn.NTSB MIA02LA002Accident · No injuriesLimited investigationFinal reportCessna 172R · Wauchula, FLthe pilot's failure to maintain directional control of the aircraft while attempting to take off after executing a touch-and-go landing, in gusty wind conditions, which resulted in a ground swerve, and the aircraft exiting the runway, and incurring…NTSB SEA01LA176Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Estacada, ORThe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. A tailwind, fence and the pilot's lack of total experience in the type of aircraft were factors.NTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…NTSB DEN01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Deming, NMthe pilot's failure to maintain aircraft control during takeoff roll. A contributing factor was the gusting crosswind weather condition.NTSB CHI01LA333Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Duluth, MNThe pilots failure to maintain directional control during the landing. Factors were the crosswind and the soft terrain.NTSB ANC01LA150Accident · No injuriesLimited investigationFinal reportSlepcev Storch SS-MK4 · Anchorage, AKThe pilot's failure to maintain directional control and an inadvertent ground loop/swerve during the landing roll.NTSB SEA01LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDThe pilot's inadequate compensation for wind conditions. A factor was variable winds.NTSB CHI01LA323Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Clear Lake, MNThe pilot not maintaining directional control of the airplane during the takeoff. A factor was the soybean crop.NTSB NYC01LA230Accident · No injuriesLimited investigationFinal reportCarver RAF 2000 GTX SE · Barre, VTThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident were wind gusts.NTSB DEN01LA160Accident · No injuriesLimited investigationFinal reportCessna 177RG · St. George, UTbrake system failure for reasons undetermined, which resulted in a loss of control on landing.NTSB CHI01LA304Accident · No injuriesLimited investigationFinal reportBeech C23 · St. Helen, MIThe pilot's failure to attain the proper airspeed which resulted in a premature lift-off and subsequent stall/mush. A factor to the accident was the fence.NTSB LAX01LA301Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Bridgeport, CAThe failure of the pilot to maintain directional control of the tail wheel equipped aircraft during landing roll which resulted in a ground loop.NTSB CHI01LA306Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Pierre, SDThe pilot not maintaining directional control of the airplane during landing.NTSB DEN01LA155Accident · No injuriesLimited investigationFinal reportVans RV-6A · Pagosa Springs, COThe pilot's inadequate airplane preflight inspection which led to the subsequent lateral control of the airplane on the ground not being possible. A contributing factor was the unavailability of rudder control due to a headset blocking the rudder control…NTSB ANC01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKA failure of the pilot to maintain directional control of the airplane during the takeoff run.NTSB IAD01LA088Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's operation of the airplane with known deficiencies. Also causal was the loss of brake pressure, which resulted in the failure of the right brake, and subsequent loss of control of the airplane.