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 FTW87LA128Accident · No injuriesLimited investigationFinal reportMooney M20J · Marietta, OKThe plt attempted takeoff from the 2450 ft rwy at the mcgeehe catfish airport near Marietta, OK. The rwy was soft with a sharp rise in the direction of takeoff. The plt failed to maintain airspeed after liftoff and directional control was lost resulting in…NTSB FTW87FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Porter, OKAcft was observed in a rt bank when it experienced an inflt breakup. Both wings, vert stab and rudder, and the horz stab and trim tab separated prior to impact. Wx was dark night with scattered to broken cloud cover, but VFR. Although a wx rpt 33 NM northwest…NTSB FTW87LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nowatta, OKDuring takeoff, the pilot reduced power and attempted to climb. When the aircraft would not respond, the pilot applied full power and raised the flaps. The aircraft settled back down nose high, contacting a fence and subsequently the ground, substantially…NTSB FTW87LA124Accident · No injuriesLimited investigationFinal reportCessna T210N · Tahlequah, OKThe right brake disk separated from the hub when brakes were applied during landing rollout. The aircraft veered left off the runway and into a drainage ditch where the horizontal stabilizer contacted the ground, damaging both of its spars.NTSB FTW87LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKDuring a normal uneventful approach, and upon touchdown, the aircraft's nose gear collapsed for undetermined reasons. The aircraft slid to a stop causing substantial damage.NTSB FTW87LA113Accident · Minor injuriesLimited investigationFinal reportBoeing 707-323C · Oklahoma City, OKAfter engine start ground personnel experienced difficulty disconnecting the airstart unit hose. The ground signalman left the view of the crew to assist the other men in an effort to disconnect the unit from the aircraft. The pilot assuming that all was…NTSB FTW87LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Pond Creek, OKPilot failed to lower flaps for a short field takeoff. After rotation the pilot realized that the aircraft would not clear a power line off the end of the runway and aborted the takeoff. The aircraft ran off the end of the runway and contacted a fence and…NTSB FTW87LA107Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKThe pilot reportedly heard an unusual noise in the engine and made a precautionary autorotation to landing. Touchdown was on uneven terrain and in a nose low attitude. This resulted in the tail rotor assembly being chopped off the tail boom by the main rotor…NTSB FTW87LA092Accident · No injuriesLimited investigationFinal reportCessna 402B · Altus, OKA 17 year old non rated pilot and 3 of his friends attempted to steal the arcft. After the engines were started power was applied and control of the aircraft was lost immediately. The aircraft struck a hangar and continued across the taxiway where the…NTSB FTW87LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Laverne, OKDuring a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces.NTSB FTW87DPJ05Accident · Serious injuriesFinal reportde Havilland DHC-1B-2S5 · Claremore, OKMud daubers plugged the fuel tank vents resulting in fuel starvation and engine failure. The acft received substantial damage during the forced lndg and the plt was seriously injured.NTSB FTW87DPJ06Accident · No injuriesFinal reportAir Tractor AT301 · El Dorado, OKThe pilot stated that during takeoff from a county road, black smoke started coming out of the engine exhaust. The aircraft then collided with a tree and a post causing substantial damage. It was found that the carburetor heat system had been modified and the…NTSB FTW87DPJ04Accident · No injuriesFinal reportAir Tractor 301 · Oluskee, OKDuring aerial application the engine sustained a power loss due to separation of the number 9 cylinder head. During the forced landing in rough terrain the aircraft was substantially damaged.NTSB FTW87DPJ03Accident · Minor injuriesFinal reportBoeing B75N1 · Fairmont, OKDuring the pull up at end of swath run pilot misjudged power line clearance. Top line caught on aircraft and caused uncontrolled descent to ground.NTSB FTW87LA073Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Broken Arrow, OKThe Balloon drifted into power lines just after liftoff. The pilot stated he was hooking up a new temperature gauge and did not notice that the Balloon was descending.NTSB FTW87LA072Accident · No injuriesLimited investigationFinal reportCessna P206B · Hooker, OKThe pilot closed the throttle after crossing the approach end of the runway and while at 10 feet or less above ground level. He bled off airspeed to the point that the aircraft stalled and dropped to the surface, resulting in a hard landing with substantial…NTSB FTW87LA069Accident · No injuriesLimited investigationFinal reportBell 47G · Sand Springs, OKInstructor plt was demonstrating a confined area takeoff to the pvt plt taking advance instruction. As the acft cleared the barriers, the quartering head wind shifted to a tail wind and the acft lost translational lift. Application of full power did not…NTSB FTW87DPJ02Accident · Serious injuriesFinal reportAir Tractor AT-302 · Colony, OKDuring a downwind swath run the number one compressor bearing failed in the ltp 101-600-1A engine which resulted in the engine failing completely. During an attempt to turn into the wind for an emergency landing the left wing tip struck the ground and the…NTSB FTW87LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Kingfisher, OKThe pilot stated that he was demonstrating emergency landing procedures to the student pilot. At about 1000 AGL he instructed the student to apply full power for a go around. According to the pilot, the engine developed full power for about 30 sec. And…NTSB FTW87LA049Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Medford, OKThe acft experienced a double eng failure as a result of fuel exhaustion during descent to the destination aprt. The plt attempted to divert to a nearby arpt during the descent, but both engs quit before he had the rwy assured. The subsequent attempted forced…NTSB FTW87FA037Accident · 1 fatalField investigationFinal reportCessna 150L · Altus, OKThe pilot was circling about 40-50 feet above the ground at a slow rate of airspeed while searching for a lost dog. He was using 10 degrees of flaps and most probably operating at a reduced power setting. Carburetor icing conditions were present and…NTSB FTW87FA031Accident · 2 fatalField investigationFinal reportCessna 172K · El Reno, OKPrivate pilot of Cessna 172K attempted VFR flight in IFR flight conditions. Contacted okc approach control and requested special VFR approach during hours of darkness. Approach denied special VFR due to lack of instrument qualification of pilot. Pilot was…NTSB FTW87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student plt noted a partial power loss while practicing multiple touch-and-go landings. She stated that after she had turned on a downwind, she heard 'a different sound' from the eng and it appeared to lose power. During an apch for an off arpt landing,…NTSB FTW87DPJ01Accident · No injuriesFinal reportSnow AT-301 · Hennessey, OKThe acft collided with a street sign during takeoff. Unablt to maintain flight, the plt landed the acft in a field collapsing the right landing gear.NTSB FTW86LA172Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Sulphur, OKThe acft struck a large bird at 2,500 ft MSL in cruise flt, which took out the windshield. The plt determined that he could not sustain level flt due to the increased drag and loss of lift and elected to execute an emergency landing in a pasture. During the…NTSB FTW86LA168Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Mc Alester, OKSixty-six year old commercial pilot taking off from Mc Alester, OK airport. Pilot stated fuel pressure fluctuated followed by loss of power during initial climb. Pilot activated auxiliary fuel pumps and switched fuel tanks. Could not restore fuel pressure.…NTSB FTW86LA166Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Oklahoma City, OKThe pilot apparently had neglected to check his engine oil supply before takeoff since there was no oil in the crankcase at the time of the accident. If five quarts of oil (the amount the pilot reportedly stated was in the engine at takeoff) had leaked out…NTSB FTW86LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Afton, OKThe pilot stated he was making a precautionary landing at night due to engine roughness and impacted electrical transmission wires. Investigation failed to disclose any reason for the reported engine roughness.NTSB FTW86LPJ11Accident · Minor injuriesFinal reportHomebuilt SA-100 · Oklahoma City, OKThe acft nosed over during a forced landing after a power loss. The plt stated after the accident that the engine lost power during a roll maneuver. The engine ran for a short time at aprx 1800 RPM and then stopped completely. The plt landed in a cultivated…NTSB FTW86LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Murray, OKThe pilot lost control of the aircraft prior to touchdown after the left wing dipped approximately four feet. The left gear touched down alongside the runway and the pilot made an attempt to go around but changed his mind when he saw a group of trees at the…NTSB FTW86LA153Accident · No injuriesLimited investigationFinal reportCessna 206 · Ardmore, OKThe pre-solo student pilot had taken the aircraft without the owner's permission. He flew around the area for approximately 30 minutes before returning to the airport. After a hard landing, the nose wheel tire blew causing the nose wheel to collapse. The…NTSB FTW86LA149Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Tulsa, OKThe pilot was on an approach into Tulsa international airport when the engine began to surge after the landing gear had been lowered. The pilot informed the tower he thought he was experiencing fuel exhaustion. The aircraft landed 2,000 feet short of runway…NTSB FTW86LA148Accident · Serious injuriesLimited investigationFinal reportCessna P210N · Altus, OKThe engine failed at 10,500 feet MSL and the pilot was vectored to a small private sod strip. However, this strip had been closed and plowed up for about a year and was not listed on the current aeronautical charts. The pilot was then revectored to another…NTSB FTW86LA145Accident · No injuriesLimited investigationFinal reportCessna 172D · Cordell, OKThe pilot was practicing maneuvers at 1200 feet AGL, when the engine began to run rough. He applied the carburetor heat and had a large power reduction. He then turned off the carburetor heat and had a total loss of power at approximately 800 feet AGL. The…NTSB FTW86LA143Accident · No injuriesLimited investigationFinal reportForney F-1A · Wagoner, OKAn 80 yr old stu plt with an expired medical certificate was using auto fuel in the acft without an STC. FAA records forthe acft showed a sale was pending for svrl yrs. During flt, the plt decided to make a precautionary landing when the engine began 'running…NTSB FTW86FA142Accident · Serious injuriesField investigationFinal reportBell 206B · Watson, OKPilot of Bell 206B conducting forestry operations experienced problem with fire dispensing apparatus being slung beneath aircraft while returning to helipad for fuel. Pilot landed, released external load, and got out of aircraft to release electrical…NTSB FTW86LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Bartlesville, OKThe plt took off on a test flt after an annual inspn of the acft & a top overhaul of the eng had been completed. While climbing thru about 1200 to 1300 ft AGL, the eng started running rough, then quit. The plt attempted to return to the arpt, but was unable.…NTSB FTW86LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Sand Springs, OKThe student pilot was hovering aircraft at 3 feet and allowed the aircraft to drift to the right. High skid gear was installed on the a/c. the right skid made contact with the ground causing dynamic rollover. The student pilot had a total of 44.2 hours flight…NTSB FTW86LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Broken Arrow, OKThe pilot made his takeoff from the intersection of a cinder packed runway, allowing only 900 feet before the end of the runway. Gross weight of the aircraft at the time of the accident was 1,700 lbs.; maximum gross weight of the aircraft is 1,670. The…NTSB FTW86LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Porum, OKThe student pilot became disoriented during a cross-country flight. He was unable to find an airport and had to land in a field due to fuel exhaustion. During the attempted landing he had to maneuver to avoid a herd of cows and collided with a concrete fence…NTSB FTW86LPJ10Accident · No injuriesFinal reportGrumman G-164 · Hooker, OKThe pilot stated that the aircraft flipped over when he landed in soft dirt on his recently extended private landing strip.NTSB FTW86LA120Accident · No injuriesLimited investigationFinal reportBeech E18S · Oklahoma City, OKA swearingen SA-226TC, N516SS, was lndd at ngt on rwy 17L. After lndg, the flt crew exited onto taxiway-E3 (TWY-E3), where they were instructed by tower to hold. A Beech E18S, N2001C, was then lndd on the same rwy (rwy 17L) & its plt also exited onto TWY-E3.…NTSB FTW86FPJ09Accident · Serious injuriesFinal reportQuick Silver Mxii · Ardmore, OKThe acft landed short of the rwy after losing eng pwr during the apch. Post acc inspection showed that the bearing on the pwr shaft failed. This allowed the belt tension to become slack which reduced the prop RPM. No other discrepancies were noted.NTSB FTW86IA103Incident · No injuriesIncident investigationFinal reportPiper PA-31 · Kingston, OKAcft received minor damage as a result of an electrical fire in-flight while in cruise at 9,000' MSL. The plt stated that he observed smoke emanating from the c.b. panel mounted on the left side wall of the cockpit and that several c.b.'s popped and he lost…NTSB FTW86FPJ08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Blackwell, OKThe acft crashed after a turn while spraying a field. The acft caught fire after the impact but the plt escaped.NTSB FTW86LA100Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Thomas, OKShortly after takeoff at an alt of aprx 200 ft AGL, the plt attempted a snap-roll. The plt was unable to recover after the intended 1 roll and the maneuver continued for 1 1/2 rolls. The plt was able to level the wings but the acft contacted the terrain in a…NTSB DEN86FA150Accident · 2 fatalField investigationFinal reportBeech A36TC · Marietta, OKThe plt obtained a wx briefing and was advised of scattered thunderstorm activity along his route of flt. The plt then filed an IFR flt plan from wiley post airport, Oklahoma city, OK, to houston intercontinental airport, TX. The plt and his wife took off at…NTSB FTW86FA098Accident · 3 fatalField investigationFinal reportCessna T210N · Sperry, OKThe airplane departed jones (riverside) airport and climbed, on course, to its assigned altitude. It was in IMC conditions and a IFR flight plan had been filed. The pilot told ATC (after being asked) that his ride was 'smooth so far'. Shortly thereafter the…NTSB FTW86FA092Accident · 2 fatalField investigationFinal reportCessna 210M · Calumet, OKAcft on a night xc flt in marginal VFR to IMC conditions impacted in an 80 deg nose down attitude in a left spiral. Immediately prior to the accident the non-instrument rated pvt plt had indicated that he was IMC and was going to attempt to climb out of it.…NTSB FTW86FA086Accident · 1 fatalField investigationFinal reportCessna 172G · Blackwell, OKThe pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that…