NTSB investigations, OK
68 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 5 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 2 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 6 |
| 2000 | 3 |
| 2001 | 2 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 3 |
| 2007 | 5 |
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 c.\"eventStateOrRegion\" = 'OK' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'OK' AND c."eventCountry" = 'USA' 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 DFW08CA044Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot failed to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB DFW08CA032Accident · No injuriesData collectionFinal reportCessna 150 · Muskogee, OKThe pilot's failure to maintain directional control while landing.NTSB DFW07CA192Accident · No injuriesData collectionFinal reportBoeing 1942 · Edmond, OKThe pilot's failure to maintain directional control during takeoff resuting in a nose over. A contributing factor was the soft terrain.NTSB DFW07CA115Accident · No injuriesData collectionFinal reportCessna 172P · Harrah, OKThe pilot's failure to compensate for the existing wind conditons while landing. A factor was the crosswind.NTSB DFW07LA052Accident · No injuriesLimited investigationFinal reportFairchild Merlin SA-226-T · Tulsa, OKThe loss of control as result of the malfunction of the nose wheel steering mechanism during landing for undetermined reasons.NTSB DFW05CA154Accident · No injuriesData collectionFinal reportCessna 152 · Marietta, OKThe pilot's failure to maintain directional control while executing a soft field take off. A factor was the prevailing dark night conditions.NTSB DFW05CA143Accident · No injuriesData collectionFinal reportLuscombe 8A · Wagoner, OKThe pilots failure to maintain directional control during landing and attempted go-around.NTSB DFW05CA101Accident · No injuriesData collectionFinal reportCessna 152 · Stillwater, OKThe student pilot's failure to maintain directional control during landing.NTSB FTW04LA188Accident · No injuriesLimited investigationFinal reportMattie RV-4 · El Reno, OKThe pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane during landing.NTSB FTW04LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Blackwell, OKThe pilot's failure to maintain directional control and the instructor's inadequate supervision by his delay in taking corrective action during the landing roll.NTSB FTW03CA205Accident · No injuriesData collectionFinal reportCessna 195 · Sand Springs, OKThe pilot's failure to maintain directional control during the landing roll.NTSB FTW03LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Guymon, OKThe pilot's inadequate compensation for the crosswind, and his failure to maintain directional control. A factor was the crosswind.NTSB FTW01LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ardmore, OKthe student pilot's failure to maintain directional control during takeoff roll.NTSB FTW01LA161Accident · No injuriesLimited investigationFinal reportCessna 172 · Kingston, OKthe pilot's failure to maintain directional control during the takeoff roll, which required his evasive maneuver and resulted in a stall.NTSB FTW00LA134Accident · No injuriesLimited investigationFinal reportCessna 140 · Tulsa, OKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the runway sign struck by the aircraft.NTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.NTSB FTW00LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Sand Springs, OKThe pilot's failure to maintain aircraft control during landing roll.NTSB FTW99LA248Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Ada, OKThe pilot's failure to maintain directional control of the airplane during the landing flare/touchdown. Factors were the pilot's excessive approach speed and the partial failure of the seat guides for the pilot's seat.NTSB FTW99LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKThe pilot's loss of control due to his improper recovery from a bounced landing.NTSB FTW99LA106Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Kingston, OKThe failure of the pilot-in-command to maintain control of the airplane during the landing roll. A factor was the gusty wind conditions.NTSB FTW99LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ada, OKThe pilot's excessive application of the wheel brakes.NTSB FTW99LA071Accident · No injuriesLimited investigationFinal reportCessna 172E · Guymon, OKThe pilot's failure to maintain aircraft control. A factor was the gusty crosswind.NTSB FTW99LA068Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Edmond, OKThe pilot's failure to attain the proper touchdown point due to excessive airspeed and his failure to abort the landing. Factors were the pilot's excessive braking and the short, grass runway.NTSB FTW98LA271Accident · No injuriesLimited investigationFinal reportCessna 150C · Collinsville, OKThe pilot's failure to maintain directional control during landing roll. A factor was the pilot's diverted attention.NTSB FTW98LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain directional control during landing. A factor was the pilot's lack of total experience in the make and model of aircraft.NTSB FTW97LA372Accident · No injuriesLimited investigationFinal reportCessna 170A · Oklahoma City, OKThe pilot's inadequate compensation for the crosswind conditions resulting in an inadvertent groundloop. Factors were the crosswind, the pilot's lack of total experience in make and model, the separation of the left main wheel due to corroded bolts, and the…NTSB FTW97LA282Accident · Minor injuriesLimited investigationFinal reportShapley Quickie Q-200 · Tahlequah, OKthe pilot's failure to maintain directional control of the aircraft during the landing. A factor relating to the accident was: low pressure in the right main tire.NTSB FTW97LA152Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Stillwater, OKthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control, which resulted in a ground swerve and collapse of the nose gear. The crosswind was a related factor.NTSB FTW97LA008Accident · No injuriesLimited investigationFinal reportCessna 172M · Tuttle, OKfailure of the pilot to maintain directional control during takeoff roll, which resulted in a ground swerve. Factors relating to the accident were: tall grass along the edges of the runway, and the proximity of the fence, fence posts, and trees.NTSB FTW96LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKthe pilot's failure to maintain directional control. A factor was the wet grass runway.NTSB FTW96LA034Accident · No injuriesLimited investigationFinal reportCessna T210F · Tulsa, OKthe pilot's failure to secure a cellular telephone which jammed the rudder pedals.NTSB FTW95LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKThe pilot's improper recovery from a bounced landing. Factors were the improper flare and the resultant loss of directional control.NTSB FTW94LA129Accident · No injuriesLimited investigationFinal reportCessna 172P · Tulsa, OKThe pilot's failure to compensate for wind conditions. A factor was the gusting cross wind.NTSB FTW94LA072Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student pilot's improper braking technique and the resultant failure to maintain directional control. A factor was the pilot not obtaining an ATC clearance prior to takeoff.NTSB FTW92LA034Accident · No injuriesLimited investigationFinal reportCessna 172P · Okmulgee, OKThe pilot's failure to compensate for a crosswind condition. Factors were the pilot's lack of total experience and the prevailing crosswind.NTSB FTW91LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · Marietta, OKThe pilot's failure to maintain directional control. A factor was his attempt to takeoff without using all available runway.NTSB FTW91LA026Accident · No injuriesLimited investigationFinal reportCessna 205 · Medford, OKThe pilot's use of improper starting procedures which resulted in the loss of control of the airplane. A factor in the accident was the airplane's encounter with rough terrain during the unmanned taxi.NTSB FTW91LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Eufaula, OKA restriction in the movement of the right rudder pedal. The restriction resulted from a passenger's inadvertent placement of an object on the cockpit's floor.NTSB DEN90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Marietta, OKThe loss of directional control by the pilot. The selection of unsuitable terrain is a factor.NTSB FTW90LA041Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKPilot's inadequate compensation for existing wind conditions. Contributing to the accident were the gusty tail winds.NTSB FTW89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Granite, OKThe pilot did not maintain directional control.NTSB FTW89LA094Accident · No injuriesLimited investigationFinal reportCessna 177B · Harrah, OKFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve; and his improper planning/decision (indecision) concerning an attempted go-around. The pilot's lack of experience in the type of aircraft…NTSB FTW88LA154Accident · No injuriesLimited investigationFinal reportAlon A2 · Guthrie, OKThe private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a…NTSB FTW88LA099Accident · No injuriesLimited investigationFinal reportBeech B55 · Ada, OKThe plt said all pre-flt prep were normal including an eng run-up. The takeoff was being made with light winds. After rolling about 300 ft the acft began a swerve to the rt which the plt perceived was associated with a loss of pwr on the rt eng. The plt…NTSB FTW88LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Lamont, OKThe pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…NTSB FTW88LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Washington, OKThe student pilot received dual instruction in crosswind takeoffs and landings after which the instructor pilot deplaned to observe the student. The student lost directional control on the first takeoff attempt and the aircraft collided with a ditch after…NTSB FTW87LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Yukon, OKOn touchdown the aircraft started to drift to the left. The pilot applied right rudder and lost directional control of the aircraft. The aircraft's right wing contacted the runway and the aircraft nosed over.NTSB FTW87LA092Accident · No injuriesLimited investigationFinal reportCessna 402B · Altus, OKA 17 year old non rated pilot and 3 of his friends attempted to steal the arcft. After the engines were started power was applied and control of the aircraft was lost immediately. The aircraft struck a hangar and continued across the taxiway where the…NTSB FTW86LA055Accident · No injuriesLimited investigationFinal reportCessna 172H · Bristow, OKThe pilot reported encountering strong gusty winds while taxiing for departure at jones memorial airport, Bristow, OK. As a result his aircraft was flipped upside down and substantially damaged. The pilot was not injured.NTSB FTW85LA292Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Chattanooga, OKThe plt lost directional control while landing in a crosswind and the acft ground looped after the left main landing gear contacted soft terrain alongside of the runway. The nearest official aviation weather reporting station was at lawton, OK, located 16…