NTSB investigations, 2002
204 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\") = 2002
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") = 2002 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 NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.NTSB FTW03LA074Accident · No injuriesLimited investigationFinal reportCessna 170A · West Helena, ARThe pilot's failure to maintain directional control during landing. A contributing factor was the deflated tire.NTSB FTW03LA065Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Denver City, TXThe pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.NTSB ANC03LA019Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Soldotna, AKThe flightcrew's selection of an unsuitable landing area, which resulted in a loss of directional control and an on ground encounter with terrain. A factor associated with the accident was a snow-covered, unplowed runway.NTSB MIA03CA030Accident · No injuriesData collectionFinal reportCessna A150M · Crystal River, FLThe student pilot's improper application of brakes during the landing rollout, which resulted in a loss of directional control and the airplane running off of the runway, impacting a runway light structure, and nosing over.NTSB NYC03IA030Incident · No injuriesIncident investigationFinal reportPiper PA-601P · Manassas, VAThe pilot' failure to maintain directional control during an aborted takeoff.NTSB CHI03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Greensburg, INFailure of the pilot to maintain directional control during the takeoff roll. Contributing factors included inadequate planning/decision by the pilot for attempting to depart from the slush covered runway, the slush covered runway itself, and the falling snow.NTSB MIA03CA026Accident · No injuriesData collectionFinal reportPiper PA38 · Pensacola, FLThe student pilot's attempt to turn off the runway at an excessive taxi speed resulting in a loss of directional control and collision with a taxiway sign.NTSB ATL03LA024Accident · No injuriesLimited investigationFinal reportCessna 172N · Cartersville, GAThe student pilot's failure to maintain directional control, during the landing roll resulted in the on ground collision with a ravine.NTSB LAX03LA042Accident · No injuriesLimited investigationFinal reportCessna 170B · Mobile, AZthe pilot's improper compensation for the crosswind conditions at touchdown and failure to maintain proper alignment of the tail wheel equipped airplane during landing, which resulted in a ground loop. The crosswind was a contributory factor.NTSB LAX03LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Hollister, CAthe pilot's failure to maintain directional control of the airplane.NTSB ATL03LA018Accident · No injuriesLimited investigationFinal reportHickman Murphy Rebel · Hilton Head, SCThe pilot's failure to maintain directional control during an aborted landing that resulted in the in-flight collision with a ditch.NTSB FTW03LA039Accident · Serious injuriesLimited investigationFinal reportLarson Kitfox III · Little Rock, ARThe pilot's failure to maintain aircraft control during an intentional taxi resulting in the inadvertent lift-off of the airplane and subsequent inadvertent stall. Contributing factors were the pilot's lack of total experience in the make and model of…NTSB LAX03LA030Accident · No injuriesLimited investigationFinal reportCessna 182T · Scottsdale, AZThe pilot's failure to apply adequate crosswind compensation, which resulted in a loss of directional control. Factors were the crosswind and the pilot's lack of experience in the make and model of airplane.NTSB LAX03LA028Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Bermuda Dunes, CAthe pilot's inadequate compensation for gusty crosswind conditions and his failure to maintain directional control.NTSB CHI03LA042Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Faulkton, SDThe directional control not maintained during an after landing taxi on the runway by the student pilot. The student pilot's lack of experience and downhill terrain off the runway were contributing factors.NTSB LAX03LA035Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Livermore, CAThe pilot's failure to maintain directional control during landing. A factor in the accident was the crosswind.NTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.NTSB LAX03LA023Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, NVThe pilot's failure to maintain directional control during takeoff. A contributing factor was the ditch.NTSB DEN03LA013Accident · No injuriesLimited investigationFinal reportMooney M20E · Broomfield, COthe pilot's failure to maintain directional control after landing due to a sheared steering horn attach bolt that should have been replaced by maintenance personnel in compliance with an outstanding service bulletin. Contributing factors included the pilot's…NTSB LAX03LA021Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chandler, AZThe pilot's failure to maintain directional control.NTSB MIA03LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Pell City, ALThe pilot's failure to maintain directional control following landing touchdown, resulting in a runway excursion and collision with a ditch off the left side of the runway.NTSB LAX03LA020Accident · No injuriesLimited investigationFinal reportCessna T182T · Long Beach, CAThe student's failure to maintain directional control and the instructor's inadequate supervision of the flight by his delayed remedial action.NTSB ATL03LA013Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Warner Robins, GAThe pilot's failure to follow engine start procedures for a overprimed engine, and his improper use of the throttle control during an attempted start.NTSB NYC03LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Morristown, NJThe student pilot's failure to maintain directional control during takeoff.NTSB ATL03IA006Incident · No injuriesIncident investigationFinal reportAmerican Blimp A-60 · Valdosta, GALoss of airship control during tie down, due to gusty wind conditions.NTSB ANC03CA004Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in the left wing striking the runway.NTSB CHI03LA011Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, MIThe pilot not maintaining directional control during landing and the inoperative right main landing gear brake. Contributing factors were the failed brake master cylinder seal, resulting in a hydraulic leak, the inadequate preflight by the pilot, the fuel…NTSB ATL03LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Opa Locka, FLThe pilot' inadequate evaluation of weather information, and the selection of the wrong runway that resulted in an attempted takeoff with a tailwind and the subsequent loss of control during takeoff.NTSB FTW03LA017Accident · No injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot's inadequate compensation for wind resulting in a loss of directional control. A contributing factor was the prevailing crosswind.NTSB DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.NTSB LAX03LA002Accident · No injuriesLimited investigationFinal reportKline KSE5A · Sedona, AZthe pilot's failure to compensate for the wind conditions resulting in a loss of directional control during the takeoff roll. A contributing factor was the pilot's incorrect installation of the left wheel, which resulted in a locked left wheel when the brakes…NTSB FTW03LA007Accident · No injuriesLimited investigationFinal reportMooney M20K · Port Sulphur, LAthe pilot's failure to maintain directional control while landing, which resulted in an in-flight collision with trees during an attempted go-around. A factor was the wet runway condition.NTSB FTW03LA001Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235C · San Antonio, TXThe pilot's failure to compensate for the existing winds conditions. A contributing factor was the prevailing tailwind.NTSB CHI03LA034Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Owatonna, MNThe remedial action not performed by the certified flight instructor (CFI) during the bounced landing and directional control not maintained during the go-around by CFI. Contributing factors were the CFIs preflight planning/preparation in placing the dual…NTSB MIA02LA172Accident · No injuriesLimited investigationFinal reportRonald Levee Kitfox IV · De Land, FLThe failure of the pilot to maintain directional control of the airplane during the flare/touchdown resulting in substantial damage. A factor in the accident was the poor in-flight planning decision by the pilot for his continuing the approach in close…NTSB LAX02FA300Accident · Serious injuriesField investigationFinal reportFairchild SA227-AC · Hawthorne, CAThe pilot-in-command's failure to maintain directional control during the rejected takeoff. The loss of directional control was caused by the crew's failure to follow prescribed pretakeoff and takeoff checklist procedures to ensure the both propellers were…NTSB IAD02LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bumpass, VAThe pilot's failure to maintain directional control during the landing. A factor was the narrow runway width.NTSB NYC02LA190Accident · No injuriesLimited investigationFinal reportCessna 421 · Ithaca, NYThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the wet runway.NTSB NYC02LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Titusville, PAThe student pilot's failure to maintain directional control during the landing roll.NTSB ATL02LA167Accident · No injuriesLimited investigationFinal reportPiper PA-30-30 · Winder, GAThe pilot's failure to maintain directional control during landing roll which resulted in the subsequent collision with an airport sign and the collapse of the main landing gear. the pilot's improper recovery from a bounced landing was a contributing factor.NTSB NYC02LA183Accident · 1 fatalLimited investigationFinal reportRoyse Glasair · Flemingsburg, KYThe pilot's improper recovery from a bounced landing, which resulted in a loss of control on the ground. A factor was the pilot's lack of experience in the type of aircraft.NTSB IAD02LA092Accident · No injuriesLimited investigationFinal reportGoff Glassair · Stow, MAThe pilot's improper positioning of the throttle during engine start, which resulted in his inability to maintain control of the airplane.NTSB ANC02LA126Accident · No injuriesLimited investigationFinal reportCessna 185 · Seward, AKA loss of directional control of the airplane due to the failure of the pilot to correct for torque/P Factor during the takeoff roll. A factor in the accident was a wet grass surface.NTSB ANC02LA113Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's failure to maintain control of the airplane during the landing roll, which precipitated a nose over.NTSB LAX02LA271Accident · No injuriesLimited investigationFinal reportMooney M20 · Sierraville, CAthe pilot's decision to attempt takeoff in crosswind conditions that likely exceeded the capability of the airplane, and, his subsequent failure to maintain the airplane's proper alignment over the runway. Also causal was the pilot's premature liftoff and…NTSB NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.NTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.NTSB SEA02LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · W. Yellowstone, MTThe pilot's compensation for the wind conditions was inadequate during the landing roll. A quartering tailwind was a factor.NTSB CHI02LA273Accident · No injuriesLimited investigationFinal reportCessna 195 · Shenandoah, IAThe pilot's inadequate compensation for wind, and the locked brake. A factor associated with the accident was the crosswind.