NTSB investigations, OK
182 cases where NTSB found Task performance.
Cases per year
| 2008 | 11 |
|---|---|
| 2009 | 6 |
| 2010 | 8 |
| 2011 | 6 |
| 2012 | 9 |
| 2013 | 14 |
| 2014 | 4 |
| 2015 | 7 |
| 2016 | 18 |
| 2017 | 13 |
| 2018 | 10 |
| 2019 | 9 |
| 2020 | 10 |
| 2021 | 8 |
| 2022 | 14 |
| 2023 | 11 |
| 2024 | 9 |
| 2025 | 11 |
| 2026 | 4 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0206'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0206')) 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 CEN26LA246Accident · Minor injuriesClass 4 · LimitedFinal reportRotec Engineering Rally 3 · Hooker, OKThe total loss of engine power due to an engine seizure for undetermined reasons because the wreckage was disposed of before it could be examined.NTSB CEN26LA206Accident · No injuriesClass 4 · LimitedFinal reportPitts Special S-1S · Bartlesville, OKThe pilot’s failure to maintain control during the landing rollout and subsequent aborted landing.NTSB CEN26LA170Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA 31P 350 · Ardmore, OKThe pilot’s failure to maintain control of the airplane while landing on a wet runway with a tailwind.NTSB CEN26LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Tahlequah, OKThe student pilot’s failure to maintain directional control while landing, which resulted in a runway excursion and nose over.NTSB CEN26LA075Accident · No injuriesClass 4 · LimitedFinal reportSteen Skybolt · Guthrie, OKThe pilot's failure to maintain directional control during landing with a quartering left crosswind.NTSB CEN26LA073Accident · Minor injuriesClass 4 · LimitedFinal reportRockwell International 114 · Stroud, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of power due to fuel exhaustion.NTSB CEN26LA057Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Weatherford, OKThe pilot’s improper landing flare which resulted in a hard landing. Contributing to the accident was the pilot being in a rush and failing to note the wind direction and speed.NTSB CEN26LA041Accident · No injuriesClass 4 · LimitedFinal reportDouglas B-26B · Ponca City, OKFailure of the nose landing gear link which resulted in a loss of directional.NTSB CEN26LA021Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Tulsa, OKThe pilot’s improper landing flare which resulted in a hard bounced landing.NTSB CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB CEN25LA350Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Ardmore, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN25LA330Accident · Minor injuriesClass 4 · LimitedFinal reportEXP Supercub · Grove, OKThe pilot’s failure to maintain elevator control during the landing, which resulted in a nose over.NTSB CEN25LA201Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Pawhuska, OKThe pilot’s failure to properly configure the airplane for landing.NTSB CEN25LA167Accident · Minor injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 505 · Bethany, OKThe pilot’s improper landing technique that allowed the helicopter’s right skid to get caught on the landing platform, which resulted in a dynamic rollover.NTSB CEN25LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCaldwell C W 162F · Mounds, OKThe student pilot’s failure to maintain control of the helicopter during a precautionary landing, which resulted in a dynamic roll over and postimpact fire.NTSB CEN25LA051Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 340 · Muskogee, OKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB CEN25LA002Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Moffett, OKThe tail wheel assembly’s fractured bolt which resulted in the pilot’s loss of directional control during landing.NTSB CEN24LA317Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Guthrie, OKA loss of engine power due to the separation and ingestion of an air filter retaining bracket into the engine cylinder.NTSB CEN24LA308Incident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Tulsa, OKThe mechanic’s improper installation of the alternator wiring connections, which resulted in electrical arcing and thermal damage to the airplane.NTSB CEN24LA258Accident · Minor injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · Stillwater, OKThe pilot’s failure to properly configure the landing gear before performing a water landing.NTSB CEN24LA219Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-23H-15 · Chouteau, OKThe student pilot’s failure to maintain control of the glider while landing. Contributing to the accident was the unclear communications between the student pilot and instructor.NTSB CEN24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Davis, OKThe pilot’s failure to maintain proper airspeed on approach which resulted in an extended touchdown, bounced landing, and runway overrun.NTSB CEN24LA130Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Oklahoma City, OKThe student pilot’s improper landing flare, which resulted in a bounced landing, aerodynamic stall, and impact with the runway.NTSB CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.NTSB CEN24LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Ponca City, OKThe pilot’s loss of directional control during landing in gusty crosswind conditions.NTSB CEN24LA070Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Claremore, OKThe flight instructor’s failure to maintain sufficient rotor speed during a practice autorotation which resulted in a hard landing.NTSB CEN24LA004Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Hochatown, OKA total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.NTSB CEN23LA423Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Broken Bow, OKThe pilot’s failure to maintain the runway centerline during landing and subsequent failure to maintain clearance from the airport grounds worker during the landing roll. Contributing to the accident was the absence of a NOTAM for mowing operations at the…NTSB CEN23FA360Accident · Serious injuriesClass 3 · FieldFinal reportPiper PA-24-250 · Oklahoma City, OKThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN23LA157Accident · Minor injuriesClass 4 · LimitedFinal reportAcro Sport II · Skiatook, OKThe pilot's failure to maintain directional control during landing in a gusting crosswind.NTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…NTSB CEN23LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oklahoma City, OKThe pilot’s loss of directional control during landing with wind gusts, which resulted in a runway excursion and nose over.NTSB CEN23LA121Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Oklahoma City, OKThe pilot’s failure to maintain directional control during the landing, that resulted in a runway excursion, and an impact with an obstacle.NTSB CEN23LA117Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Guthrie, OKThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN23FA050Accident · 2 fatalClass 3 · FieldFinal reportCessna 170 · Gage, OKThe non-certificated pilots’ loss of airplane control, resulting in an impact with terrain during final approach. Contributing to the accident was the airplane owner’s impairment due to his use of ethanol and depressant medications, in combination with his…NTSB CEN22LA443Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Owasso, OKThe student pilot’s failure to maintain a proper descent rate during the short field landing.NTSB CEN22LA343Accident · No injuriesClass 3 · LimitedFinal reportBeech E33A · Zena, OKThe pilot’s inadequate preflight inspection and fuel planning, and improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA321Accident · 2 fatalClass 3 · LimitedFinal reportJust Highlander · Bennington, OKThe pilot’s exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall and loss of control.NTSB CEN22LA315Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 650B · Eufaula, OKThe loss of engine power due to a push rod that was incorrectly installed by the airplane owner.NTSB CEN22LA303Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-140 · Oklahoma City, OKThe pilot’s failure to maintain adequate airspeed for unknown reasons during the initial climb, which resulted in an inadvertent aerodynamic stall and impact with terrain.NTSB CEN22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150E · Harrah, OKThe flight instructor’s inadequate inflight fuel planning that resulted in fuel exhaustion and a forced landing.NTSB CEN22LA294Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Idabel, OKThe pilot’s failure to apply full power during the practice autorotation recovery, which resulted in a hard landing.NTSB CEN22LA296Accident · No injuriesClass 4 · LimitedFinal reportBaker Eugene L RV6-A · Goldsby, OKThe pilot’s failure to maintain directional control during landing resulting in a runway excursion.NTSB CEN22LA255Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Stillwater, OKThe inadequate maintenance and inspection of the engine induction air coupling, which impeded airflow to the engine and resulted in the subsequent partial loss of engine power.NTSB DCA22LA126Incident · No injuriesClass 3 · LimitedFinal reportBoeing 757-236 · Tulsa, OKThe flight crew’s misidentification of the intended landing runway. Contributing to the incident were (1) the flight crew’s failure to perceive and correctly interpret visual and auditory indicators – including electronic guidance – that they were approaching…NTSB CEN22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Marshall, OKThe pilot’s failure to manage fuel, which resulted in a loss of engine power to both engines due to fuel starvation.NTSB CEN22FA145Accident · 3 fatalClass 3 · FieldFinal reportPiper PA-30 · Pond Creek, OKThe pilot’s loss of control of the airplane, resulting in an in-flight breakup.NTSB CEN22LA140Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Heavner, OKA total loss of engine power due to oil exhaustion which resulted from improper engine maintenance.NTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.