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 FTW84LA233Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Colcord, OKThe flight departed downwind from an unimproved field to avoid power lines at the upwind end of the field. During the takeoff roll sufficient speed could not be attained to lift off and clear a fence at the departure end of the runway. The pilot attempted to…NTSB FTW84LA223Accident · No injuriesLimited investigationFinal reportCessna 172 · Allen, OKThe pilot stated that he could not climb enough to clear the trees at the end of the airport. The left wing hit a tree then the right wing hit a pwr line and utility pole. The acft then crashed into the ground. The plt had about 400 hours in this make and…NTSB FTW84LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Putnam, OKThe acft bounced during landing and the plt attempted to abort the landing. A truck was parked near the end of the field. The acft collided with the truck which it failed to clear in an attempt to fly over it. There were no reported malfunctions of equipment.NTSB FTW84FPJ01Accident · 2 fatalFinal reportPiper PA-22 · Byron, OKThe acft had impacted the ground at a 60 deg angle. The 1153 wx at ponca city, OK (60 mi east of the crash site) was ceilings obscured to vision & indefinite, with thunderstorms, rain & fog. The ceiling was estimated to be 200 ft obscured.NTSB FTW84LA213Accident · No injuriesLimited investigationFinal reportAerospatiale AS 315B · Hartshorn, OKThe helicopter sustained substantial damage during an autorotative landing following an explosion in the engine compartment. While in level flight at 1000 ft AGL, the plt heard a loud screech from the engine area followed by a loud bang. A wingman observed 10…NTSB FTW84FA209Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Pryor, OKThe student plt taxied upwind & took off downwind. Witnesses reported that the acft lifted off at the departure end & never left ground effect. After about 1/2 mi, the acft stalled as the plt attempted to clear electric lines. The acft then crashed, hitting a…NTSB FTW84LA204Accident · Serious injuriesLimited investigationFinal reportBeasley, Gerald L. Varieze · Purcell, OKThe plt reported that he started the eng by using fuel from the 2.5 gal aux tank, then he moved the fuel selector to the 'both' position. He took off at about 0600 CST & climbed to cruise at 5500 ft MSL. While en route, a short time later, the eng 'sputtered…NTSB FTW84LA202Accident · No injuriesLimited investigationFinal reportCessna 500 · Oklahoma City, OKDuring a proficiency flt check, the aircrew was making a N0-flap landing. After completing the landing checklist down to the landing gear, power was reduced causing the landing gear audible warning to sound. The horn silence switch was depressed & the apch…NTSB FTW84LA196Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Guthrie, OKWhile on final approach the acft descended below the desired glidepath. When the plt added pwr, the engine did not respond. The acft touched down hard and short of the rwy after which the left wing contacted a tree. The plt stated he did not use carb heat…NTSB FTW84LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student was on his 3rd solo flt, practicing touch-&-go landings. According to witnesses, the acft initially touched down short of the rwy, then bounced onto the prepared surface. The acft porpoised several times. The plt made no attempt to go around.NTSB FTW84LA192Accident · No injuriesLimited investigationFinal reportRockwell A-9B · Lamont, OKThe plt reported that between swath runs, his attention was directed to swath marks on the ground, then he tried to determine how much chemical was remaining in the hopper. At about 100 ft AGL, while in a 50 deg left bank, he heard 'the eng slow down' & felt…NTSB FTW84FA171Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Kiefer, OKThe acft was destroyed as it spun into the ground after having been observed doing aerobatics between 800 and 1500 AGL. The maneuvers included barrel rolls and hammerhead stalls. The last maneuver ended in a spin that was said to last ABOUT5 turns before…NTSB FTW84FA170Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Bristow, OKJust prior to the accident, the acft was observed to make a low pass down rwy 35 in slow flt. The acft then entered a steep climb at the end of the rwy to an alt of 200 to 300 ft AGL. It then turned left onto a crosswind leg of the pattern, the left wing…NTSB FTW84LA186Accident · No injuriesLimited investigationFinal reportLockheed VEGA-1 · Yukon, OKThe plt was practicing touch-&-go landings & lost control of the acft. It swerved to the left onto soft terrain & went over on its nose. At 1st, the plt made comments about improper strut inflation. However, later, he reported that wx was not a problem & that…NTSB FTW84LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKBefore takeoff, a student & a commercial plt agreed to rendezvous & fly formation while the student took pictures of the commercial plt's acft. The student was to fly a Cessna 152, N4861B, while the commercial plt flew a Cessna 150, N704V6. They planned for…NTSB FTW84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrah, OKThe plt landed at higher than normal speed, with initial contact about 400 ft down the runway. He stated that the acft was 'sailing' and attempts to decelerate were 'ineffective'. The nose gear collapsed when the acft hit in the middle road on the north end…NTSB FTW84LA140Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ada, OKThe acft collided with powerlines during a low level flt along the canadian river and fell into the shallow water. The plt who is a fireman said he had descended to observe a grass fire burning along side the river.NTSB FTW84LA137Accident · 1 fatalLimited investigationFinal reportPiper PA-25-150 · Altus, OKThe acft crashed in a wheat field that was being spray, then was destoyed by a post crash fire. According to the operator, the plt was at the end of a swath run when he glanced into the cockpit to visually check how much chemical was remaining in the hopper.…NTSB FTW84LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKDuring landing the nose gear of the acft collapsed. The plt reported that the nose gear started to shimmy after landing and he pulled the stick back to raise the nose gear. When the gear contacted the rwy again it collapsed. Examination of the wreckage showed…NTSB FTW84IA135Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Tulsa, OKThe acft experienced a nose wheel steering malfunction & ran off the rwy during landing. The nose wheel system was removed from the acft & submitted for inspection & overhaul. Examination revealed that the lever shaft 'ears' had separated from fatigue.NTSB FTW84FA126Accident · 1 fatalField investigationFinal reportPiper PA-30B · Hugo, OKAccording to witnesses, the acft was having some kind of problem after takeoff. It entered a nose high attitude, went to the right & crashed. An exam revealed that it had impacted in a nose down attitude. The landing gear was found in a down & locked…NTSB FTW84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe acft landed hard and bounced. The plt reacted by pushing the nose over and when the acft contacted the rwy the nose gear collapsed.NTSB FTW84FA115Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Davidson, OKThe acft struck high voltage powerlines while conducting aerobatic maneuvers. A witness stated that the acft pulled-up into a nose high maneuver, climbed to about 3000 ft AGL, appeared to slide backwards and enter a nose-down turning maneuver. Full power was…NTSB FTW84LA112Accident · No injuriesLimited investigationFinal reportBeech 65-90 · Okemah, OKThe plt landed long on a turf rwy with standing water on the approach end. The plt was unable to stop on the rwy and was also unsuccessful in groundlooping to avoid hitting trees off the end of the rwy.NTSB FTW84FA100Accident · 2 fatalField investigationFinal reportMooney M20F · Ada, OKThe eng lost power shortly after takeoff & the acft stalled while in a slight left turn. Examination revealed that the left wing fuel sump drain contained frozen water in the drain ports. The fuel injector screen, after thawing out, contained frozen water…NTSB FTW84LA092Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Washington, OKAbout 15 min after tkof the plt became aware that the ground below was covered with fog. The plt found a hold in the obscured ceiling, descended and established visual contact with a field. After circling the plt landed in the field. About halfway down the…NTSB FTW84LA089Accident · 1 fatalLimited investigationFinal reportCessna 150G · Clinton, OKThree witnesses observed the acft flying low before it went out of sight behind trees. Two of them reported that the plt made 3 low fly-bys with the eng sounding normal, then they heard the acft impact in a field on the 3rd pass. An exam of the crash site…NTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…NTSB FTW84FA082Accident · 1 fatalField investigationFinal reportCessna 310K · Hodgen, OKThe plt had purchased the acft at rexburg, id on the day of the accident. Reportedly, the previous owner had flown with the plt, before the plt departed rexburg, and said he had flown the acft very well. The previous owner stated that the DME was not…NTSB FTW84LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ardmore, OKThe plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…NTSB FTW84FA075Accident · Serious injuriesField investigationFinal reportGulfstream Peregrine · El Reno, OKAt about 215 KTS the plt rolled the acft in order to evaluate newly installed ailerons. It had been noted earlier that a dead-band existed in the aileron neutral range that increased with airspeed. The plt stated that upon rollout the dead-band was stronger &…NTSB FTW84LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Okmulgee, OKAccording to the plt, the eng was not producing sufficient power to maintain alt in normal cruise. Also, he reported that 'extra power' was required on final apch for landing at the destination arpt. He further stated that he was unable 'to cut power to idle'…NTSB FTW84LA073Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Walters, OKThe plt & safety plt had made two simulated instrument approaches at duncan,OK &a low VFR pass at Walters which was to terminate with a circling approach & landing. The acft stalled during the pull-up from the low pass.NTSB FTW84LA051Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Moore, OKThe acft crashed during a forced landing after the engine quit. The acft had a prior forced landing and the fuel pump was suspect. Post accident investigation showed that only one safety pin was installed in the fuel selector shaft allowing excessive free…NTSB FTW84FA045Accident · 2 fatalField investigationFinal reportCessna 310L · Bartlesville, OKThe acft was observed at 300-500 ft on a downwind leg over the brightly lighted city. After passing the city the acft entered a very dark & hilly area immediately north of the city. He then made a left turn onto base leg & remained over unlighted & hilly…NTSB FTW84LA044Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Tulsa, OKDuring a missed approach from a practice ILS apch, a loud noise was heard during gear retraction. Subsequent attempts toextend the gear, both normally & manually, resulted in the right gear remaining up & locked with the inboard gear door slightly open. The…NTSB FTW84LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · Oklahoma City, OKThe plt reported that he intended to practice hovering within the arpt boundries. According to him, as the RPM was increased to 100% for lift-off, the right skid came off the ground, but the left skid was 'evidently stuck in the soft ground.' Right cyclic was…NTSB FTW84FA035Accident · 2 fatalField investigationFinal reportCessna 310 · Fairview, OKThe acft was observed to take off at about 1830. Witnesses near the crash site reported seeing & hearing a low flying acft at about 2000 & stated the engs were running smoothly. There was fog in the low areas with visibility of less than 1/4 mi in those…NTSB FTW84LA030Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33 · Norman, OKThe acft made a hard landing & cartwheeled.NTSB FTW84LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKThe student plt reported that shortly after takeoff, the eng lost power. He made an emergency landing in a field, but before he could stop the acft, it collided with a fence. Later, the acft eng was examined, but no reason for the power loss was found.NTSB FTW84LA018Accident · No injuriesLimited investigationFinal reportCessna 182M · Aline, OKBefore departing norman, OK, the plt obtained a wx briefing from the Oklahoma city fss. During that briefing, he was advised that VFR flt was not recommended. He then took off for dodge city, KS without filling a flt plan. However, en route, he encountered wx…NTSB FTW83LA435Accident · Minor injuriesLimited investigationFinal reportPitts S-1T · Haskell, OKWhile performing a snaproll at an airshow, the crankshaft failed & the prop separated from the acft. The plt landed on the arpt, but the acft went thru an open hanger before the plt could stop. The wings struck supporting poles under the roof of the hanger.…NTSB FTW83LA436Accident · No injuriesLimited investigationFinal reportCessna 180K · El Reno, OKThe acft nosed over while landing. The 2nd plt was transitioning into tailwheel acft. The PIC demonstrated one landing and the 2nd plt attempted the next. The acft bounced and the PIC took over the controls too late to prevent the nose over.NTSB FTW83FA416Accident · 8 fatalField investigationFinal reportCessna 421C · Altus, OKThe plt initiated a takeoff on a hot afternoon with 7 passengers on board. Shortly after left-off, 2 witnesses observed what they described as a puff of black smoke from the right eng. According to witnesses, the acft rurned to the left before crossing the…NTSB FTW83FA406Accident · 1 fatalField investigationFinal reportPiper PA 28R-200 · Copan, OKThe acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…NTSB FTW83LA390Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Buffalo, OKThe acft hit the ground while trying to stay VFR under low ceilings at night. The student plt was returning from a x-country, for which he had no briefing on the weather, when the weather became worse. The student plt circumnavigated some of the thunderstorms…NTSB FTW83FU004Accident · 1 fatalFinal reportPterodactyl Ascender II+ · Haskell, OKThe plt & his instructor were departing the airport in separate ultralight vehicles to proceed on a x-country flt for a fly-in. The instructor saw the plt takeoff, but lost sight of him moments later & did not see the accident. However, an eye witness stated…NTSB FTW83LA383Accident · No injuriesLimited investigationFinal reportPierce GS-1 · Sand Springs, OKThe acft collided with the lake after maneuvering around at low alt for some time. A lake patrolman reported the acft alt before the crash at about 20 ft AGL. According to the plts statement he was about 50 ft high when he initiated a 30 to 40 degree angle of…NTSB FTW83LA378Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Grove, OKThe acft was high & fast on final apch & touched down about 1/3 of the way down the rwy. The nosewheel touched down 1st & the acft began to porpoise. The plt applied power to stop the porpoise, then elected to go around. In order to avoid trees near the end…NTSB FTW83LA368Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe acft collided with a fence and a powerline during takeoff climb. The student pilot was visiting a small field with A1300 ft rwy of sod for practice. The C-152 uses 1340 ft to clear a 50 ft obstabcle for a standard day on a surfaced rwy this day was above…