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 FTW00LA158Accident · No injuriesLimited investigationFinal reportCessna 182RG · Sand Springs, OKThe pilot's failure to maintain directional control during the takeoff. A factor was the fence struck by the aircraft.NTSB FTW00FA154Accident · 2 fatalField investigationFinal reportCessna 152 · Noble, OKthe failure of both pilots to maintain visual lookout.NTSB FTW00LA134Accident · No injuriesLimited investigationFinal reportCessna 140 · Tulsa, OKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the runway sign struck by the aircraft.NTSB FTW00LA133Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Claremore, OKThe pilot's premature raising of the flaps.NTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.NTSB FTW00LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Maud, OKthe loss of engine power while maneuvering as a result of the separation of the exhaust rocker arm retaining stud due to fatigue, which resulted in a precautionary landing.NTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rush Springs, OKThe pilot's failure to maintain control of the aircraft during landing roll. Factors were the pilot's diverted attention to raising the flaps and the high wind conditions.NTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.NTSB FTW00LA075Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Oklahoma City, OKThe failure of the pilot to deice the airplane prior to departure.NTSB FTW00LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Sand Springs, OKThe pilot's failure to maintain aircraft control during landing roll.NTSB FTW00FA053Accident · 1 fatalField investigationFinal reportMooney M20K · Mcalester, OKThe pilot's failure to maintain aircraft control. Factors were the pilot's impairment (drugs), the deployed right speed brake, and the night conditions.NTSB FTW00LA044Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Elk City, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA038Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Stillwater, OKThe total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.NTSB FTW00LA028Accident · No injuriesLimited investigationFinal reportCessna 210K · Ponca City, OKInadequate quality control by the manufacturer of the throttle control cable, which resulted in failure of the cable due to fatigue. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oklahoma City, OKThe failure of the pilot to follow the landing checklist and verify that the landing gear was down and locked, which resulted in a wheels up landing. A factor was the failure of the landing gear locking mechanism for an undetermined reason.NTSB FTW00LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Granite, OKCorrosion failure of the fuselage support tubing below the right wing forward attach fitting due to inadequate maintenance.NTSB FTW00LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150G · El Reno, OKThe total loss of engine power resulting from a fatigue failure of the intake rocker arm for the #4 cylinder. A factor was the soft terrain encountered during the forced landing.NTSB FTW00LA004Accident · Serious injuriesLimited investigationFinal reportLindstrand LBL-105G · Mcalester, OKThe pilot's continued flight into known adverse weather, which resulted in a hard landing. Factors were the thunderstorms, dark night light conditions, and the high winds.NTSB FTW99LA272Accident · 1 fatalLimited investigationFinal reportCessna 150F · Poteau, OKThe instructor pilot's inadequate in-flight decision making, which resulted in the continued flight with a disabled generator and subsequent total failure of the electrical system. Factors were the installation of the inadequate generator fuse by unknown…NTSB FTW99LA271Accident · No injuriesLimited investigationFinal reportStinson L-5 · Woodward, OKThe in-flight separation of the tip of a wood propeller blade. Contributing factors were the soft terrain and ditch encountered during the precautionary landing.NTSB FTW99LA266Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Lone Grove, OKThe pilot's selection of an unsuitable takeoff area. Factors were the fences struck during the takeoff, the tall grass, rising terrain, and a tailwind.NTSB FTW99LA248Accident · Serious injuriesLimited investigationFinal reportBeech 95-A55 · Ada, OKThe pilot's failure to maintain directional control of the airplane during the landing flare/touchdown. Factors were the pilot's excessive approach speed and the partial failure of the seat guides for the pilot's seat.NTSB FTW99LA247Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lookeba, OKThe loss of engine power resulting from a cylinder that failed for an undetermined reason.NTSB FTW99LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Randalette, OKThe failure of the pilot to maintain clearance with the telephone pole. A factor was the sunglare.NTSB FTW99FA235Accident · 1 fatalField investigationFinal reportBeech D-35 · Seminole, OKThe loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.NTSB FTW99LA224Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKThe pilot's failure to maintain rotor rpm which resulted in a hard landing. A factor was the high density altitude.NTSB FTW99FA222Accident · 1 fatalField investigationFinal reportPiper PA30 · Holdenville, OKthe pilot's failure to maintain aircraft control during takeoff initial climb. Factors were the loss of right engine power for undetermined reasons, and the pilot's lack of total experience in the make and model of aircraft.NTSB FTW99FA211Accident · 2 fatalField investigationFinal reportCessna 177 · Wagoner, OKThe pilot's inadvertent stall while performing an abrupt maneuver at low altitude.NTSB FTW99LA203Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe pilot's failure to maintain the proper descent rate, which resulted in a hard landing.NTSB FTW99FA199Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Bethany, OKThe pilot's failure to maintain the minimum controllable airspeed. A factor was the disconnected rubber interconnect boot, which resulted in the partial loss of left engine power.NTSB FTW99TA183Accident · Minor injuriesFinal reportMcDonnell Douglas 500-E · Oklahoma City, OKDuring a practice autorotation, the pilot flared the helicopter too low, which resulted in the tailboom contacting the ground. A factor was the dark night light conditions.NTSB FTW99LA154Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Mcalester, OKThe pilot inadvertently stalling the airplane while attempting to avoid power lines. Factors were the loss of power on both the left and right engines as a result of water contamination in the fuel system, the pilot's inadequate preflight procedures, and the…NTSB FTW99LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKThe pilot's loss of control due to his improper recovery from a bounced landing.NTSB DEN99FA086Accident · 1 fatalField investigationFinal reportPZL-Mielec M-18B · Altus, OKThe pilot's disregard of takeoff performance data and his failure to jettison the load. Contributing factors were high density altitude, exceeding the aircraft's maximum allowable gross weight, and the berm.NTSB FTW99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Washington, OKThe flight instructor's inadequate supervision resulting in an inadvertent stall/spin by the student pilot.NTSB FTW99FA132Accident · No injuriesField investigationFinal reportGrumman American AA-5B · Claremore, OKThe fatigue fracture of the propeller bolts resulting from the improper installation of the propeller assembly.NTSB FTW99LA129Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Claremore, OKThe pilot's failure to maintain minimum airspeed for flight while maneuvering, which resulted in an inadvertent stall.NTSB FTW99FA123Accident · 1 fatalField investigationFinal reportCessna 402C · Goldsby, OKThe fatigue failure of the right wing spar as a result of inadequate quality control during manufacture of the spar. A factor was the inadequate inspection of the right wing by maintenance personnel, which failed to detect the crack.NTSB FTW99LA106Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Kingston, OKThe failure of the pilot-in-command to maintain control of the airplane during the landing roll. A factor was the gusty wind conditions.NTSB FTW99LA105Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shawnee, OKThe improper flare during an autorotation by the pilot-in-command. A factor was the loss of engine power for an undetermined reason.NTSB FTW99LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ada, OKThe pilot's excessive application of the wheel brakes.NTSB FTW99LA097Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Hobart, OKThe loss of engine power due to an undetermined reason. A factor was the ditch.NTSB FTW99LA071Accident · No injuriesLimited investigationFinal reportCessna 172E · Guymon, OKThe pilot's failure to maintain aircraft control. A factor was the gusty crosswind.NTSB FTW99LA068Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Edmond, OKThe pilot's failure to attain the proper touchdown point due to excessive airspeed and his failure to abort the landing. Factors were the pilot's excessive braking and the short, grass runway.NTSB FTW99FA067Accident · 4 fatalField investigationFinal reportCessna 182B · Honobia, OKThe pilot's failure to maintain aircraft control for an undetermined reason.NTSB FTW99LA057Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Marietta, OKThe failure of the pilot-in-command to maintain clearance with terrain. Factors were the short runway and the dark night light condition.NTSB FTW99FA044Accident · 1 fatalField investigationFinal reportBeech 58 · Newcastle, OKthe pilot's loss of control due to his inadvertent encounter with severe turbulence and wind shear during an instrument approach. Factors contributing to the accident were the severe turbulence and the wind shear.NTSB FTW99LA023Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Tulsa, OKThe loss of engine power due to detonation for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99FA020Accident · 2 fatalField investigationFinal reportBeech B19 · Hobart, OKThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain terrain clearance. Factors were the low ceiling, fog, dark night conditions, and the pilot's failure to obtain a weather briefing prior to the flight.