NTSB investigations, OK
20 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 1 |
| 2019 | 2 |
| 2021 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '090' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '090' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 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 CEN26LA021Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Tulsa, OKThe pilot’s improper landing flare which resulted in a hard bounced landing.NTSB CEN25LA350Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Ardmore, OKThe pilot’s improper landing flare, which resulted in a hard, bounced 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 CEN24LA063Accident · No injuriesClass 3 · LimitedFinal reportCessna T210 · Sapulpa, OKThe total loss of engine power due to the failure of the left magneto and subsequent damage to a lead for the right magneto.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 CEN21LA311Accident · Minor injuriesClass 4 · LimitedFinal reportEslinger C W/Eslinger S M Cassutt · Pryor, OKThe pilot’s high flare and failure to execute a go-around which resulted in a hard landing and runway excursion.NTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB CEN19LA264Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Cordell, OKThe pilot's improper landing flare, which resulted in a hard bounced landing.NTSB GAA17CA173Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe student pilot’s loss of directional control.NTSB GAA16CA208Accident · No injuriesData collectionFinal reportCessna 172 · Durant, OKThe pilot candidate's incorrect action performance by pulling the throttle off early and the subsequent failure to maintain the descent rate, resulting in a hard landing.NTSB GAA16CA194Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and collision with a runway distance remaining sign.NTSB GAA16CA116Accident · No injuriesData collectionFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain pitch control during the landing, resulting in a porpoise.NTSB GAA15CA165Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Comanche, OKThe pilot's failure to maintain proper pitch control during touchdown, which resulted in a nose over and impact with terrain.NTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.NTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.NTSB CEN10CA350Accident · No injuriesData collectionFinal reportAviat A-1B · Idabell, OKThe pilot's failure to maintain directional control during a go-around.NTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.