NTSB investigations, OK
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 FTW97LA240Accident · Serious injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Ardmore, OKThe pilot's failure to maintain clearance from the power line. Factors were his improper decision to continue the flight after he noted a loss of engine power during initial takeoff climb and the loss of engine power for an undetermined reason.NTSB FTW97LA228Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pond Creek, OKloss of engine power for undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW97LA211Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Oklahoma City, OKThe pilot's impairment of judgment and performance due to alcohol which led to an attempted takeoff in an airplane without an elevator installed.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…NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.NTSB FTW97LA156Accident · No injuriesLimited investigationFinal reportRockwell 114 · Oklahoma City, OKThe exhaust manifold cracking due to the pilot's inadequate maintenance modification of the exhaust system which resulted in a fire. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA153Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marietta, OKThe pilot's inadequate short field takeoff. A factor was the pilot's lack of recent experience in short field takeoffs from a grass/turf runway.NTSB FTW97LA149Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Bartlesville, OKthe pilot's selection of an empty fuel tank, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's lack of familiarity with the aircraft.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 FTW97LA146Accident · No injuriesLimited investigationFinal reportBeech G33 · Bixby, OKfailure of a number two connecting rod bolt, possibly from being either over-torqued or under-torqued during installation, and failure of the pilot to see-and-avoid the transmission line, while performing a forced landing.NTSB FTW97FA135Accident · 1 fatalField investigationFinal reportTeschendorf Cassutt Sport · Stilwell, OKfailure of the right wing spar and/or debonding of the right wing skin, which resulted in separation of the wing skin and a portion of the right wing, during high speed flight. Factors related to the accident were: previous wing damage and inadequate…NTSB FTW97LA116Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, OKThe pilot/mechanic's improper installation of the spark plug, resulting in its separation from the engine. A factor was the unsuitable terrain available in the runway's overrun area.NTSB FTW97LA117Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Newkirk, OKThe partial loss of engine power due to failure of the blower (integral supercharger). A factor was the power line over which the pilot had to maneuver during the forced landing which resulted in insufficient airspeed to flare the airplane.NTSB FTW97FA100Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Lone Wolf, OKthe pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, and his failure to maintain sufficient altitude (clearance above a lake), while performing aerobatic flight. Factors relating to the accident were: the…NTSB FTW97FA097Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKThe flight instructor's failure to obtain/maintain clearance with the power line. A factor was the sunglare from the setting sun, which could have impaired the flight instructor's ability to see the power line.NTSB FTW97LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Boswell, OKThe student pilot's improper inflight planning and decision, after becoming lost/disoriented, which resulted in fuel exhaustion, before landing in a suitable landing area. Factors relating to the accident were: the pilot of another aircraft did not accurately…NTSB FTW97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sulphur, OKThe loss of engine power due to fuel starvation and the pilot's improper use of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.NTSB FTW97IA084Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Oklahoma City, OKexistence of fumes from the cargo compartment and activation of the cargo smoke detector for undetermined reasons.NTSB FTW97LA064Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Muskogee, OKthe pilot's improper planning/decision and inaccurate fuel consumption calculations, which resulted in an inadequate supply of fuel, fuel exhaustion, and a subsequent forced landing at night. Darkness was a related factor.NTSB FTW97LA062Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Ardmore, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB FTW97LA057Accident · No injuriesLimited investigationFinal reportGilbert Rutan Vari EZE · Oklahoma City, OKThe pilot's failure to follow proper starting procedures and set the throttle to idle before hand propping.NTSB FTW97LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tulsa, OKFuel exhaustion due the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA041Accident · No injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKThe failure of the main landing gear pivot gear assembly.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 FTW97LA007Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Elk City, OKThe loss of aircraft control due to a fuel imbalance as a result of a partial failure of the fuel jettison system. A factor was that fuel could not be transferred from the left wing tip fuel tank to the rear fuselage fuel tank.NTSB FTW96LA363Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKthe student pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the student's lack of experience in this make and model of aircraft, darkness, and lack…NTSB FTW96LA358Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Tulsa, OKlow fluid level in the hydraulic reservoir, due to inadequate maintenance/inspection, which resulted in an inoperative brake system. Factors relating to the accident were: the down sloping runway, and trees at the departure end of the runway.NTSB FTW96LA345Accident · No injuriesLimited investigationFinal reportCessna 210-5 · Muskogee, OKloss of engine power due to fuel contamination. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA327Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Kingfisher, OKthe pilot's misjudgment of distance and speed, and his failure to attain a proper touchdown point, while landing. Related factors were: the short/wet runway, and uneven terrain and ditch beyond the end of the runway.NTSB FTW96LA326Accident · No injuriesLimited investigationFinal reportRockwell International S2R · Tahlequah, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA318Accident · Minor injuriesLimited investigationFinal reportSteward Breezy · Owasso, OKthe pilot's failure to secure his cargo prior to departure. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW96LA312Accident · No injuriesLimited investigationFinal reportCessna 182A · Skiatook, OKa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW96LA300Accident · No injuriesLimited investigationFinal reportCessna 172P · Owasso, OKInadequate maintenance by maintenance personnel resulting in inoperative brake system during an aborted takeoff. A factor was the downhill runway condition.NTSB FTW96LA298Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Ardmore, OKThe pilot's inadvertent premature retraction of the landing gear during takeoff roll. A factor was inadequate supervision by the safety pilot/flight instructor.NTSB FTW96LA287Accident · No injuriesLimited investigationFinal reportCessna 421B · Stillwater, OKthe failure of the pilots of the Cessna 421B, N450SU, and the Cessna 152, N94532, to maintain visual lookout. Factors were: the inadequate radio communications maintained by both pilots, and the failure of the student pilot of the Cessna 152 to take evasive…NTSB FTW96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKThe student pilot's improper flare during the landing, which resulted in a collapsed nose gear, ground swerve, and collision with an object.NTSB FTW96LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Hobart, OKthe pilot became lost/disoriented, and failed to properly use information that was provided by ATC, which resulted in fuel exhaustion and an encounter with soft terrain during an emergency landing. A factor relating to the accident was: the lack of suitable…NTSB FTW96LA249Accident · No injuriesLimited investigationFinal reportAmerican General AG-5B · Tulsa, OKthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Darkness was a related factor.NTSB FTW96IA248Incident · No injuriesIncident investigationFinal reportFairchild SA227-DC · Enid, OKfailure of the accessory drive bearing, causing the accessory drive gear teeth to shear and disengage the fuel pump accessory drive shaft, resulting in a disabled fuel pump and subsequent fuel starvation.NTSB FTW96FA234Accident · 4 fatalField investigationFinal reportFairchild KR-31 · Bartlesville, OKThe failure of each pilot-in-command to maintain visual lookout. Factors were: the lack of each pilot-in-command obtaining/maintaining communication with the control tower, and inadequate lookout by each pilot-rated passenger, the inadequate…NTSB FTW96TA222Accident · No injuriesFinal reportMcDonnell Douglas MD-520N · Bethany, OKThe main rotor blades' contact with the tail boom due to gusting winds during rotor deceleration.NTSB FTW96LA204Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Okmulgee, OKThe pilot's continued operation with known deficiencies in the airplane and the pilot's and maintenance personnel's failure to comply with an airworthiness directive resulting in the malfunctioning of a worn ignition switch. A factor was trees.NTSB FTW96LA190Accident · Serious injuriesLimited investigationFinal reportDeaton JUNGSTER-1 · Mcalester, OKthe pilot's failure to maintain obstacle clearance.NTSB FTW96FA183Accident · 4 fatalField investigationFinal reportPiper PA-28-151 · Vera, OKimproper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.NTSB FTW96LA192Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKthe student's inadvertent dynamic rollover, and inadequate supervision by the flight instructor.NTSB FTW96FA181Accident · 1 fatalField investigationFinal reportBeech A36 · Oklahoma City, OKthe pilot's delay in aborting the landing and his failure to obtain/maintain sufficient airspeed during the aborted landing, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's improper…NTSB FTW96LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's improper planning/decision and failure to obtain/maintain sufficient airspeed to climb after takeoff, which resulted in a stall/mush and subsequent collision with terrain. Factors relating to the accident were: failure of the pilot to follow short…NTSB FTW96LA137Accident · Minor injuriesLimited investigationFinal reportBell B206-BIII · Chandler, OKthe reported loss of engine power during a go-around for undetermined reason(s).NTSB FTW96LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cushing, OKThe inadvertent deployment of the passenger's parachute as a result of his failure to follow proper procedures and deactivate the automatic opening device on the parachute.