NTSB investigations, OK
142 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 9 |
| 1984 | 12 |
| 1985 | 6 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 9 |
| 1990 | 4 |
| 1991 | 6 |
| 1992 | 3 |
| 1993 | 6 |
| 1994 | 4 |
| 1995 | 8 |
| 1996 | 3 |
| 1997 | 6 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 3 |
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\" = 250)
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" = 250) 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 DFW08FA040Accident · 2 fatalField investigationFinal reportCessna 172N · Marlow, OKThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall/spin and impact with terrain. Contributing to the accident were the low altitude for recovery and the gusty tailwind.NTSB DFW08FA015Accident · 5 fatalField investigationFinal reportBeech A36 · Glenpool, OKThe pilot's failure to maintain control of the airplane after departure, which resulted in a collision with power lines. A factor was the high winds.NTSB DFW07FA071Accident · 1 fatalField investigationFinal reportStevens KB-2 · Oklahoma City, OKThe pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.NTSB DFW07LA032Accident · 2 fatalLimited investigationFinal reportNoble Vans RV-7A · Norman, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.NTSB DFW06CA213Accident · No injuriesData collectionFinal reportRobinson R22 · Skiatook, OKThe pilot's failure to maintain control of the helicopter following an encounter with dynamic rollover.NTSB DFW06CA166Accident · No injuriesData collectionFinal reportCessna 172A · Durant, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB DFW06CA132Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the dark night conditions and the pilot's inadequate preflight planning and preparation.NTSB DFW05LA187Accident · 1 fatalLimited investigationFinal reportYakovlev Yak 52 · Claremore, OKThe pilot's failure to obtain adequate airspeed while executing a low altitude aerobatic maneuver, which resulted in an aerodynamic stall while inverted. A factor was the low altitude.NTSB DFW05CA070Accident · Minor injuriesData collectionFinal reportRobinson R22 · Owasso, OKThe flight instructor's failure to verify that the student had the flight controls and his delayed remedial action.NTSB DFW05LA053Accident · Serious injuriesLimited investigationFinal reportMyers Kit Fox Series VI · Cleveland, OKThe pilot's failure to maintain control and sufficient airspeed while performing an abrupt pull-up manuever after takeoff, which resulted in an inadvertent stall/spin.NTSB DFW05LA037Accident · 2 fatalLimited investigationFinal reportCrosley Christen Eagle II · Morris, OKThe pilot's intentional spin, which was unrecoverable due to exceeded aircraft weight and balance limitations as a result of improper preflight planning/preparation.NTSB DFW05FA015Accident · 1 fatalField investigationFinal reportPiper PA-30 · Boise City, OKThe pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.NTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.NTSB FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.NTSB SEA04FA165Accident · 3 fatalField investigationFinal reportCessna T210L · Tulsa, OKThe pilot's inadequate preflight inspection by his failure to secure the oil cap, which resulted in oil leakage on the windscreen, obstructing his vision, and his failure to maintain adequate airspeed.NTSB FTW04LA019Accident · Serious injuriesLimited investigationFinal reportRichard Riley Velocity · Fargo, OKThe pilot's failure to maintain control of the aircraft while practicing slow flight. A contributing factor was the low altitude selected by the pilot.NTSB FTW03LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ardmore, OKThe failure of the pilot to adequately compensate for existing wind conditions. A contributing factor was the gusty crosswind conditions from the east.NTSB FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB FTW03LA141Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's failure to attain adequate airspeed during liftoff resulting in a stall.NTSB FTW03LA116Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB FTW03FA086Accident · 1 fatalField investigationFinal reportCessna 152 · Norman, OKThe pilot's failure to maintain airspeed while maneuvering, resulting in an inadvertent stall . Factors contributing to the accident were the low altitude and the prevailing high winds.NTSB FTW02LA224Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Marietta, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW02LA134Accident · 1 fatalLimited investigationFinal reportRobinson Tierra II · Hooker, OKthe loss of control for an undetermined reason, which resulted in an in-flight collision with terrain.NTSB FTW01LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Miami, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB FTW01FA151Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · McAlester, OKthe inadvertent stall by the pilot-in-command.NTSB FTW01FA129Accident · 1 fatalField investigationFinal reportCessna 150 · Pryor, OKthe failure of the glider pilot to maintain aircraft control and his delay in releasing the towrope. A contributing factor was the glider's worn elevator trim friction, which resulted in its disengagement.NTSB FTW01LA080Accident · No injuriesLimited investigationFinal reportCessna 210D · Lawton, OKthe pilot's failure to maintain aircraft control during the landing flare/touchdown. A contributing factor was the crosswind.NTSB FTW01LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe certified flight instructor's (CFI) failure to maintain directional control of the airplane during landing. A contributing factor was the gusty wind condition.NTSB FTW01FA013Accident · 1 fatalField investigationFinal reportCessna 210 · Oklahoma City, OKthe pilot's loss of control of the aircraft during initial/takeoff climb. Contributing factors were the night conditions, low ceilings, and the pilot's lack of flight experience in actual instrument meteorological conditions at night.NTSB FTW00FA236Accident · 1 fatalField investigationFinal reportCessna 150 · Collinsville, OKthe pilot's failure to maintain control of the aircraft while maneuvering after takeoff, which resulted in an inadvertent stall/spin and impact with terrain.NTSB FTW00LA226Accident · No injuriesLimited investigationFinal reportCessna 182M · Shawnee, OKThe pilot's failure to maintain control of the airplane during the landing flare/touchdown. A factor was the gusty wind condition.NTSB FTW00LA222Accident · Serious injuriesLimited investigationFinal reportRomero SEA REY · Tulsa, OKThe loss of control by the pilot due to incapacitation for unknown reasons.NTSB FTW00FA053Accident · 1 fatalField investigationFinal reportMooney M20K · Mcalester, OKThe pilot's failure to maintain aircraft control. Factors were the pilot's impairment (drugs), the deployed right speed brake, and the night conditions.NTSB FTW99LA224Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKThe pilot's failure to maintain rotor rpm which resulted in a hard landing. A factor was the high density altitude.NTSB FTW99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Washington, OKThe flight instructor's inadequate supervision resulting in an inadvertent stall/spin by the student pilot.NTSB FTW99LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Claremore, OKThe pilot's failure to maintain minimum airspeed for flight while maneuvering, which resulted in an inadvertent stall.NTSB FTW99FA067Accident · 4 fatalField investigationFinal reportCessna 182B · Honobia, OKThe pilot's failure to maintain aircraft control for an undetermined reason.NTSB FTW98LA409Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Catoosa, OKThe pilot's failure to maintain control of the airplane resulting in an inadvertent stall.NTSB FTW98LA397Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tahlequah, OKThe pilot's failure to maintain directional control of the aircraft during takeoff. A factor was the gusty wind conditions at the time of the accident.NTSB FTW98FA189Accident · 2 fatalField investigationFinal reportCessna 150F · Muskogee, OKThe inadvertent stall as result of the pilot's failure to retract the flaps from the fully extended position prior to takeoff. Factors were the gusting winds and the pilot's failure to follow the before takeoff checklist.NTSB FTW98TA174Accident · No injuriesFinal reportBellanca 7GCBC · Mcalester, OKthe pilot's inadequate compensation for the gusty crosswinds, during recovery from a bounced landing; and his failure to maintain directional control during a go-around. Related factors were: the wind conditions, and a subsequent encounter with of a fence and…NTSB FTW98LA159Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Norman, OKThe pilot's improper compensation for wind conditions, which resulted in a loss of directional control and collision with a ditch. A contributing factor was the high crosswind.NTSB FTW98LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Marietta, OKThe pilot's improper compensation for the wind conditions. A factor was the crosswind.NTSB FTW98LA103Accident · No injuriesLimited investigationFinal reportCessna 340A · Bethany, OKThe pilot's flight into known adverse weather conditions which resulted in an inadvertent stall due to airframe ice. A factor was the icing conditions.NTSB FTW98LA085Accident · No injuriesLimited investigationFinal reportMooney M20J · Westport, OKThe pilot's inadequate compensation for the existing wind conditions. A factor was gusty winds.NTSB FTW97LA346Accident · 1 fatalLimited investigationFinal reportReilly Thorp T-18 · Wagoner, OKthe pilot's failure to maintain airspeed.NTSB FTW97LA339Accident · 1 fatalLimited investigationFinal reportRoddie MINI-500 · Idabel, OKThe loss of control in flight for undetermined reasons. A factor was the pilot's lack of total experience in helicopters.NTSB FTW97LA325Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Marietta, OKThe pilot's failure to follow procedures/directives for takeoff. Factors were the runway's rough/uneven condition and the hilly terrain on the departure end of the runway.NTSB FTW97FA199Accident · 3 fatalField investigationFinal reportBeech V35 · Shawnee, OKThe pilot's inadvertent entry into a spin. A factor was the pilot's initiated flight into adverse weather.NTSB FTW97LA178Accident · Serious injuriesLimited investigationFinal reportRans S-12 · Goldsby, OKthe pilot-in-command's improper judgment in allowing the passenger to control the airplane, and the pilot-in-command's inadequate supervision. Factors relating to the accident were: the passenger's failure to maintain minimum required airspeed, which resulted…