NTSB investigations, OK
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 FTW91LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Wilburton, OKThe pilot's decision to abort the take off with insufficient distance remaining. Factors were the fluctuating engine and the trees in his path.NTSB FTW91FA085Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Claremore, OKThe instructor pilot (PIC) did not maintain clearance from obstacles during the maneuver.NTSB FTW91FA081Accident · 2 fatalField investigationFinal reportCessna 150J · Caney, OKBinding of the #2 exhaust valve (stuck valve), and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. A factor related to the accident was: the failed exhaust manifold gasket.NTSB FTW91FA074Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-20 · Kenefic, OKImproper planning/decision by the pilots of both aircraft, and the Mitsubishi pilot's misjudgment of his position, while attempting to fly formation at night with an aircraft that did not have all navigation lights operative. Factors related to the accident…NTSB FTW91LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Weatherford, OKThe inadvertent stalling of the airplane. A factor was the gusty wind.NTSB FTW91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain proper alignment during the flare.NTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.NTSB FTW91LA058Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hobart, OKThe pilot's failure to maintain clearance with known objects.NTSB FTW91DPJ01Accident · Serious injuriesFinal reportPiper PA-25 · Spiro, OKA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe pilot's failure to maintain airspeed and altitude on final approach.NTSB FTW91FA043Accident · 3 fatalField investigationFinal reportMitsubishi MU-2B-60 · Tulsa, OKThe shutdown of one engine for undetermined reasons, and the pilot's failure to maintain vmca during a critical phase of flight. A factor in the accident was the pilot's improper emergency procedure.NTSB FTW91LA041Accident · No injuriesLimited investigationFinal reportHughes 269C · Knowles, OKThe pilot's failure to maintain a proper descent rate during the maneuver and his delay in initiating the go-around.NTSB DEN91LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Guymon, OKFuel starvation for undetermined reasons, and the pilot's delay in flaring the airplane. A factor was: the pilot's total lack of experience.NTSB FTW91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Enid, OKThe mechanical failure of the ignition switch. A factor was the pilot's failure to apply the parking brake or use airplane wheel chocks.NTSB DEN91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe inadequate supervision of the student by the flight instructor. A factor was: the student's failure to flare the aircraft.NTSB FTW91FA030Accident · 4 fatalField investigationFinal reportMooney 20J · Newcastle, OKThe pilot's failure to maintain aircraft control. Factors were spatial disorientation, improper IFR procedures, and the dark night with low ceilings and rain.NTSB FTW91FA027Accident · 6 fatalField investigationFinal reportCessna 421B · Muskogee, OKThe pilot's failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: darkness, adverse weather conditions, and the pilot's physical impairment from the chronic sinus infection.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 FTW91LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Claremore, OKFailure of pilot in command to insure the aircraft contained enough fuel for the flight resulting in engine failure due to fuel exhaustion.NTSB FTW91GA001Accident · No injuriesFinal reportMcdonnell Douglas 369E · Anadarko, OKFailure of the pilot to maintain proper visual lookout prior to and during departure.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 FTW90DPJ12Accident · No injuriesFinal reportMassegee Rebel 300 · El Reno, OKFailure of the elevator control rod at the bell crank.NTSB FTW90DPJ11Accident · No injuriesFinal reportDooley Mustang MII · Cashion, OKThe separation of a 14 inch section of one propeller blade due to previous damage.NTSB DEN90LA183Accident · 1 fatalLimited investigationFinal reportBeech E 33 · Tulsa, OKThe pilot's failure to select the right tank prior to the approach resulting in fuel starvation.NTSB FTW90LA174Accident · Minor injuriesLimited investigationFinal reportCessna C172N · Marietta, OKFailure of the pilot to attain the proper climb rate after takeoff resulting in the aircraft colliding with trees at the departure end of the runway. Contribuing to the accident was the pilot in commands failure to account for high density altitude.NTSB FTW90FA160Accident · 4 fatalField investigationFinal reportAerospatiale/Socata TB-10 · Ada, OKImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed for a climb profile. Factors related to the accident were: the pilot allowed the weight and balance of the aircraft to exceed the certified limits, his use of…NTSB FTW90LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Broken Arrow, OKThe pilot in command's failure to maintain directional control during the takeoff.NTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.NTSB FTW90DPJ10Accident · No injuriesFinal reportHomebuilt Midget Mustang M1 · Bristow, OKFuel starvation induced power loss, a compromised fuel vent system, and improper installation of the plumbing in the fuel vent system.NTSB FTW90GA146Accident · 1 fatalFinal reportRobinson R22B · Tahlequah, OKThe pilot's failure to maintain adequate altitude.NTSB FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.NTSB FTW90FA120Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Oklahoma City, OKFailure of the pilot to recover from the aerobatic maneuver and subsequent stall/spin, due to inadequate altitude. Fatigue may have been a related factor.NTSB FTW90LA117Accident · No injuriesLimited investigationFinal reportBoeing E75 · Watonga, OKPic's failure to use all of the available runway. A factor was the high density altitude.NTSB FTW90DPJ08Accident · 1 fatalFinal reportDe Havilland Venom 112 MK4 · Muskogee, OKThe pilot's premature rotation and the subsequent stall. A factor was the pilot's lack of experience in the airplane.NTSB FTW90DPJ07Accident · Minor injuriesFinal reportCessna T188C · Altus, OKThe PIC did not maintain the proper clearance from the powerline.NTSB FTW90DPJ06Accident · 1 fatalFinal reportStits SA-3A Playboy · Bartlesville, OKAn inadvertent stall.NTSB FTW90LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Tulsa, OKAn engine failure due to a disconnect in the magneto drive train caused by the crankshaft gear not being properly installed and secured during a recent engine overhaul.NTSB FTW90DPJ05Accident · Minor injuriesFinal reportBell 47G-4A · Bixby, OKLoss of control due to undetermined mechanical failure.NTSB FTW90FA093Accident · 1 fatalField investigationFinal reportMooney M-20J · Inola, OKThe pilot's decision to conduct the flight into known adverse weather and his inability to maintain control of the airplane due to spatial disorientation. Factors were the dark night conditions and thunderstorms.NTSB FTW90DPJ04Accident · 1 fatalFinal reportMooney M20F · Bethany, OKLoss of control in flight when the pilot stalled and spun the airplane inadvertently while turning to the base leg. A factor was lack of night flying time.NTSB FTW90LA089Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Durant, OKPilot's failure to maintain adequate airspeed (vso) and subsequent stall of the aircraft at an altitude from which recovery was not possible. A factor in the accident was the pilot's improper procedures for the landing approach.NTSB FTW90DPJ03Accident · Minor injuriesFinal reportPiper PA36-400 · Temple, OKFailure of an aileron attachment (bolt) due to fatigue.NTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.NTSB FTW90FA062Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Coalgate, OKFlight into known adverse weather conditions by the non-instrument rated pilot, and his subsequent spatial disorientation, which resulted in a loss of aircraft control. Factors related to the accident were: inoperative instrument panel lights, dark night,…NTSB FTW90LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Glencoe, OKThe power loss due to carburetor ice, which resulted from the pilot's failure to engage carburetor heat in a timely manner. A factor in this accident was the pilot's lack of total experience.NTSB FTW90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Clinton, OKPilots failure to correctly maintain the proper glidepath, which caused him to impact short of the runway.NTSB FTW90TL#01Accident · No injuriesClass 3Final reportHughes 369E · Stroud, OKNTSB 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 FTW90LA034Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Shawnee, OKFailure of the pilot to maintain adequate airspeed during the turn after takeoff, which resulted in a stall. The obstructions (trees) were a factor.