NTSB investigations, OK
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW88LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Ada, OKAfter a loss of engine power, the airplane landed in a soft, plowed field, 50 feet short of a runway at the destination airport. After touchdown, it nosed over to the inverted position. According to the operator, the pilot said he might have run out of fuel.…NTSB FTW88IA147Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Oklahoma City, OKThe flight was an instructional flight with three pilots onboard. The airplane departed on runway 17R and was 300 to 400 feet AGL when one blade of the right propeller separated from the hub, followed by the remainder of the propeller. The PIC made an…NTSB FTW88DPJ09Accident · No injuriesFinal reportCessna 152 · Skiatook, OKThe student pilot landed her aircraft on the last half of the runway. She added power and retracted the flaps when she decided to abort the landing and go around. She subsequently decided to abort the go around and pulled off the power. There was insufficient…NTSB FTW88LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Westville, OKThe pilot descended the airplane from 5000 feet using reduced power but without using carburetor heat. At 3500 feet the pilot advanced the throttle but the engine did not accelerate and then stopped producing power completely. Despite corrective measures by…NTSB FTW88LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Oklahoma City, OKThe air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was…NTSB FTW88LA138Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Sayre, OKThe pilot said that shortly after takeoff, at 200 feet AGL, the engine quit. He tried to land on the remaining runway but the airplane went off left side, then through a ditch. No problems could be found to cause the loss of engine power. The engine was later…NTSB FTW88DPJ08Accident · Minor injuriesFinal reportCessna 152 · Heavener, OKDuring a cross country training flight, the non-instrument rated pilot flew into IMC conditions while descending. The pilot attempted to climb into VFR conditions but when that was not successful a descent was begun in an effort to breakout into VFR…NTSB FTW88DPJ07Accident · Minor injuriesFinal reportNorthrop C-125A · Tulsa, OKThe pilot did not hold a type rating or written authorization to act as pilot in command. The co-pilot did not hold a type rating or written authorization to act as second in command and his medical had expired. The aircraft did not have an airworthiness…NTSB FTW88LA123Accident · No injuriesLimited investigationFinal reportBeech B-24R · Blanchard, OKAccording to the private pilot in the left front seat, this was a training flight set up by the commercial pilot flight instructor in one of the rear seats. The private pilot in the left front seat was to practice for his commercial flight test and the…NTSB FTW88LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mounds, OKThe instructor was demonstrating an engine out emergency to the student. The engine balked on the attempted go-around and he completed the landing. Thereafter, his first two takeoff attempts were aborted because of insufficient distance to complete the…NTSB FTW88DPJ06Accident · Serious injuriesFinal reportCessna 172G · Frederick, OKDuring slow taxi to takeoff, a gust of wind or a dust devil lifted aircraft off taxiway and flipped it inverted. Numerous small whirlwinds were observed in the vicinity of the airport at the time.NTSB FTW88DPJ05Accident · 1 fatalFinal reportStinson 108-3 · Collinsville, OKThe pilot experienced a loss of engine power during the takeoff leg. Post accident investigation revealed that the fuel selector was in the near closed position. This position only allowed a small percentage of the fuel to flow but would allow operation in…NTSB FTW88LA113Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Hinton, OKThe pilot departed bethany, Oklahoma on a local pleasure flight with the fuel tanks slightly less than 1/2 full. After about a 1.5 hour flight, he landed at the red rock airport in Hinton, Oklahoma. No service was performed on the aircraft while in Hinton and…NTSB DCA88MA059Accident · Serious injuriesMajor investigationFinal reportEmbraer EMB-110P · Lawton, OKNone submittedNTSB FTW88FA104Accident · 2 fatalField investigationFinal reportCessna 172P · Le Flore, OKThe acft was being used to fly over a wooded area & spot cattle for psnl on the ground. After spotting cattle for about 2 hrs, the plt was flying at low alt when the acft suddenly rolled into a steep bank, then the nose dropped & the acft crashed in a steep…NTSB FTW88LA099Accident · No injuriesLimited investigationFinal reportBeech B55 · Ada, OKThe plt said all pre-flt prep were normal including an eng run-up. The takeoff was being made with light winds. After rolling about 300 ft the acft began a swerve to the rt which the plt perceived was associated with a loss of pwr on the rt eng. The plt…NTSB FTW88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Pawnee, OKAircraft's flight envelope was exceeded.NTSB FTW88LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Lamont, OKThe pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…NTSB FTW88DPJ04Accident · 1 fatalFinal reportAerotek Pitts S-2A · Elk City, OKThe aircraft was observed doing aerobatics. A stall/spin was initiated from a climbing vertical attitude. Corrective action was not accomplished by the pilot and the aircraft was observed to spin to ground impact. No aircraft malfunctions were found.NTSB FTW88DPJ03Accident · Serious injuriesFinal reportCessna 172M · Norman, OKPilot retracted flaps during go around and aircraft settled into trees and was destroyed. Front seat occupants were not wearing the available shoulder harnesses. The acft was landing with a quartering tailwind. Due to serious head injuries the plt never…NTSB FTW88LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Washington, OKThe student pilot received dual instruction in crosswind takeoffs and landings after which the instructor pilot deplaned to observe the student. The student lost directional control on the first takeoff attempt and the aircraft collided with a ditch after…NTSB FTW88LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilots experienced a sudden total and complete loss of engine power during climbout after takeoff. Suitable terrain for a safe landing was not available and the aircraft was damaged during landing on a golf course. Examinations of the aircraft and engine…NTSB FTW88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Oklahoma City, OKThe airplane was equipped for IFR but not equipped to fly into icing cond. At 4000 feet MSL, the OAT was above freezing. At 3000 feet MSL the airplane was in clouds with OAT of 32 degrees f. the plt elected to attempt downwind ILS approach and landing. Plt…NTSB FTW88FA057Accident · Serious injuriesField investigationFinal reportCessna 120 · Ada, OKThe pilot was flying low up the river and hit the upper strand of a two strand high voltage power line. Both the pilot and passenger received serious injuries when the airplane crashed on a sand-bar in the river.NTSB FTW88FA046Accident · Serious injuriesField investigationFinal reportBeech B36TC · Woodward, OKBefore tkof, the plt was briefed on flt precautions for IFR & snow; however, he was not adzd of icing conds in clouds & precip above the freezing lvl to 18,000' as cautioned in the current area forecast. While climbing after tkof, he enctrd clouds & 'some…NTSB FTW88LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Fargo, OKDuring takeoff roll, the engine RPM dropped to 2600 and started running rough. Shortly after takeoff, the pilot elected to make a precautionary landing. During landing roll the aircraft's left wing hit a tree causing substantial damage to the aircraft. Prior…NTSB FTW88LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Mangum, OKAccording to the pilot, the engine started running rough during cruise flight. He elected to make a forced landing and intentionally stalled the aircraft into some trees to cushion the impact, substantially damaging the aircraft. The pilot further stated that…NTSB FTW88LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawton, OKThe student pilot stated that during flare/touchdown the aircraft bounced and came down hard on the nose gear collapsing it and damaging the prop and firewall. The majority of the student pilots flt time was obtained while in the military.NTSB FTW88MA021Accident · Minor injuriesMajor investigationFinal reportConvair 640 (340D) · Bartlesville, OKThe capt was cross-feeding both engines from the right tank while the first officer (f/o) was flying, without informing the f/o. the capt then left the cockpit while cross-feeding. Both tank valves and the right boost pump were on. The right tank ran dry, the…NTSB FTW88LA019Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Fort Supply, OKThe acft was forced to land due to loss of eng power. The plt attempted to land on a roadway. During the landing the acft rt wing struck a fence post. The landing gear collapsed during a groundloop after lndg. Post acc investigation revealed that the eng was…NTSB FTW88LA018Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Ardmore, OKDuring landing, the aircraft touched down about 15 feet short of the runway causing the rt main gear to collapse. The acft slid approx 800 ft BEF0RE coming to rest on the rwy. Both gear penetrated the upper skin on the wings.NTSB FTW88DPJ02Accident · Serious injuriesFinal reportPiper PA-25 · Catoosa, OKThe pilot stalled the aircraft while turning downwind during a practice agricultural operation. The aircraft impacted the ground out of control. The pilot stated that he could not recall anything about the flight.NTSB FTW88DPJ01Accident · Serious injuriesFinal reportWard Cassutt 3M · Yukon, OKDuring initial climb the engine failed and the pilot was unable to get a restart. The pilot, who was also the builder of the aircraft, was aware that in certain attitudes the engine would fail due to fuel starvation and that by changing the aircraft attitude…NTSB FTW87DPJ09Accident · Serious injuriesFinal reportG&C Helicopters EL Tomcat MK5A · Marlow, OKPilot failed to see and avoid tree at end of swath run during a spraying operation. After contacting the tree, the helicopter started to spin and struck the ground in an approximate 90 degree right bank and started to burn.NTSB FTW87DPJ07Accident · No injuriesFinal reportMooney M20F · Jenks, OKEngine failed during initial climb. Aircraft collided with airport perimeter fence and slid across road during landing attempt. Water was found in the fuel distributor system following the accident.NTSB MIA87FA248Accident · No injuriesField investigationFinal reportBoeing 727 · Tulsa, OKThe crew of the Boeing 727 aircraft on a domestic passenger flight initiated an approach to a runway with a known crosswind and tailwind component. On final approach the tower controllers re-stated the wind and issued a windshear warning. On short final at…NTSB FTW87LA218Accident · No injuriesLimited investigationFinal reportBeech 58 · Guthrie, OKThe pilot failed to ensure that the landing gear was down and locked. The aircraft landed gear up and received substantial damage. The gear was lowered normally after the aircraft was lifted from the runway.NTSB FTW87LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Edmond, OKThe pilot executed a short field approach to a private airstrip. During the landing roll the nose gear collapsed resulting in the aircraft's nose contacting the terrain. No reason for the nose gear collapse could be determined.NTSB FTW87DPJ08Accident · 1 fatalFinal reportAir Tractor 301A · Hollis, OKDuring an aerial application cleanup run, the aircraft's wing collided with a pole and sheared off the outboard five feet. The aircraft then collided with the ground out of control. Exam of the engine and airframe did not disclose any pre-existing failures or…NTSB FTW87LA189Accident · Minor injuriesLimited investigationFinal reportBeech V35B · El Reno, OKAcft bounced on touchdown and began porpoising down the runway. According to the plt, following the second bounce, the rt front seat passenger applied full throttle and the acft veered left into a fence. After striking the fence the nose gear collapsed when…NTSB FTW87LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Sallisaw, OKThe acft impacted the terrain near the Sallisaw, Oklahoma airport. Visual meteorological conditions prevailed at the time of the accident. The pilot stated that the engine quit and he attempted a forced landing to a field. However, the pilot stated that the…NTSB FTW87FA168Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Jenks, OKAlthough it was determined that the engine failed due to fuel exhaustion, the exact sequence of events that led to this event was not determined. The pilot reported that the aircraft was out of fuel over the radio and no fuel was found in the aircraft. There…NTSB FTW87LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Tulsa, OKDrg the initial climb after takeoff, the acft's eng lost pwr. The plt landed the acft on a median in a residential & shopping area, where it nosed over. An exam & an opnl check of the eng revealed no reason for the loss of pwr.NTSB FTW87LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Farris, OKThe plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged.NTSB FTW87LA153Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Marietta, OKThe plt rprtd that drg takeoff fm a grass rwy, the acft stalled after climbing about 10 ft AGL. He said that torque pulled the nose of the acft to the left & he tried to recover. However, there was insufficient alt & the acft hit the tops of trees, then fell…NTSB FTW87LA150Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Chelsea, OKThe non-rated plt attempted a downwind takeoff from a 1450' pvt grass strip. The strip was soft from recent rain & contained grass & weeds which were 6 to 7 inches hi. After taking off, the acft would not climb fast enough to clear obstacles. Subsequently, it…NTSB FTW87LA145Accident · No injuriesLimited investigationFinal reportCessna 172 · Yukon, OKOn touchdown the aircraft started to drift to the left. The pilot applied right rudder and lost directional control of the aircraft. The aircraft's right wing contacted the runway and the aircraft nosed over.NTSB FTW87FA142Accident · Serious injuriesField investigationFinal reportBeech 35 · Cookson, OKJust after takeoff smoke was smelled and then observed in the cockpit. The pilot beleived that the smoke source was electrical and turned off the master switch. Just before touchdown flames began burning the pilots left leg. The aircraft was stopped on the…NTSB FTW87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Norman, OKWhile performing a touch and go landing, the aircraft landed hard causing a vibration in the engine area, and some loss of rudder control. The pilot flew by the tower and the tower indicated everything looked ok. On landing roll the nose gear failed causing…NTSB FTW87MA133Accident · 1 fatalMajor investigationFinal reportCessna P210R · Arnett, OKThe flt departed baton rouge (btr) for the plts stated dest of alexandria, which was 78 miles on a bearing of 301 deg, at 0836 CDT. After dep the btr local area there was no radio contact with any ATC facility. The transponder continued to transmit a code…