NTSB investigations, OK
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.NTSB CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN13FA121Accident · Serious injuriesField investigationFinal reportEurocopter EC130 B4 · Seminole, OKThe loss of engine power due to ice ingestion. Contributing to the accident was maintenance personnel’s delayed decision to install the helicopter's engine inlet cover until after the engine had been exposed to moisture and freezing temperatures and their…NTSB CEN13TA113Accident · Minor injuriesFinal reportCessna 550 · Oklahoma City, OKThe flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane…NTSB CEN13FA080Accident · Minor injuriesField investigationFinal reportCessna 208B · Bryans Corner, OKThe total loss of engine power as a result of a fractured compressor turbine blade due to fatigue cracking.NTSB CEN13FA051Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Anadarko, OKThe pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.NTSB CEN13CA027Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Helena, OKThe pilot's failure to properly secure the cyclic and to stop the main rotor system before exiting the helicopter, which resulted in the main rotor blades striking the tail rotor driveshaft.NTSB CEN12CA625Accident · No injuriesData collectionFinal reportBeech 35 · Geary, OKThe student pilot failed to maintain control of the airplane during a forced landing attempt which resulted in an aerodynamic stall. Contributing to the accident was the instructor pilot's delay in taking control of the airplane and the loss of engine power…NTSB CEN12CA671Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Goldsby, OKThe commercial pilot did not attain the proper touchdown point during the landing, which resulted in a premature touchdown and an impact with the edge of the runway surface.NTSB CEN12CA533Accident · No injuriesData collectionFinal reportThrush S-2R · Newkirk, OKThe pilot’s failure to maintain clearance from power lines.NTSB CEN12CA454Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jenks, OKThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway overrun and impact with obstructions.NTSB CEN12LA368Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Hooker, OKThe pilot’s loss of airplane control after a partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures, which resulted in an…NTSB CEN12CA329Accident · No injuriesData collectionFinal reportBrumbaugh B/Kasowski L Avid Flyer IV · Pryor, OKThe pilot's failure to maintain directional control during a high speed taxi.NTSB CEN12LA314Accident · No injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKThe student pilot's improper configuration of the airplane flaps during an aborted landing, which resulted in an inadequate climb rate and subsequent collision with trees.NTSB CEN12LA307Accident · 1 fatalLimited investigationFinal reportDial David L Titan Tornado II · Checotah, OKThe noncertificated pilot's loss of airplane control while maneuvering during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s ostentatious display.NTSB CEN12LA299Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Shawnee, OKThe improper installation of the mixture cable by maintenance personnel, which allowed the mixture cable to entangle with the landing gear during gear extension and led to the subsequent loss of engine power.NTSB CEN12CA269Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Hugo, OKThe pilot’s inadequate collective control inputs while performing a hovering autorotation, which resulted in a hard landing. Contributing to the accident was the check airman's delayed remedial action.NTSB CEN12LA235Accident · No injuriesLimited investigationFinal reportEurocopter SA315B · Alva, OKFailure of the current and previous operators to comply with the manufacturer's maintenance procedures for operation in sandy environments, which resulted in turbine case erosion and the subsequent uncontained engine failure.NTSB WPR12LA144Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Laverne, OKThe airplane’s encounter with severe turbulence during cruise flight, which resulted in a serious injury to a flight attendant.NTSB CEN12LA179Accident · 1 fatalLimited investigationFinal reportSkeeter 1M · Oklahoma City, OKThe pilot's failure to maintain airplane control while on final approach as he was executing a turn to provide spacing between his airplane and an airplane on the runway.NTSB CEN12LA134Accident · Minor injuriesLimited investigationFinal reportAero Commander 500-B · Bartlesville, OKThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection, which did not correctly identify the airplane’s fuel quantity before departure.NTSB CEN12FA101Accident · 2 fatalField investigationFinal reportPiper PA-28-235D · Chickasha, OKThe non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane. Contributing to the accident was the pilot’s lack of instrument…NTSB CEN12CA054Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Woodward, OKThe student pilot’s hard landing and subsequent loss of directional control.NTSB CEN12FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Guthrie, OKThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.NTSB CEN12CA016Accident · No injuriesData collectionFinal reportCessna 182A · Skiatook, OKA total loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel management.NTSB CEN11CA609Accident · Minor injuriesData collectionFinal reportMooney M20C · Allen, OKA total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.NTSB CEN11LA579Accident · No injuriesLimited investigationFinal reportCessna 180 · Stillwater, OKThe pilot's on-ground loss of control during the landing roll upon encountering a sudden wind shift and gust.NTSB CEN11CA509Accident · No injuriesData collectionFinal reportBell 206B · Temple, OKThe pilot’s failure to maintain clearance from static power lines.NTSB CEN11FA434Accident · 1 fatalField investigationFinal reportSchaffer Gary W Lancair · Yukon, OKThe pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…NTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.NTSB CEN11CA389Accident · No injuriesData collectionFinal reportConner Leroy RV6A · Oakwood, OKThe pilot's improper decision to land on a road with obstacles.NTSB CEN11CA378Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Wagoner, OKThe airplane's collision with a deer during the landing flare and touchdown.NTSB CEN11LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Frederick, OKAn in-flight fire for undetermined reasons.NTSB CEN11CA353Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Guymon, OKThe pilot's loss of directional control while landing in gusty, crosswind conditions.NTSB CEN11FA300Accident · 1 fatalField investigationFinal reportDahlman-Dower Tailwind W-8 · Elk City, OKThe pilot's decision to attempt flight into instrument meteorological conditions in an airplane that was equipped for flight in visual meteorological conditions only, which resulted in the pilot’s spatial disoriented and loss of control of the airplane.NTSB CEN11IA280Incident · No injuriesIncident investigationFinal reportBeech 90B · Chickasha, OKThe mechanic's improper installation of the aileron.NTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.NTSB CEN11LA200Accident · No injuriesLimited investigationFinal reportHughes 369D · Henryetta, OKFailure of the cyclic control system for reasons undetermined.NTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB CEN11LA101Accident · Serious injuriesLimited investigationFinal reportBeech 95-C55 · Claremore, OKA loss of engine power on both engines for undetermined reasons.NTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB CEN10LA572Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Tulsa, OKA shorted terminal lug on the landing gear hydraulic pump which resulted in a cabin fire. Contributing to the accident was the lack of clear installation procedures for the hydraulic pump.NTSB CEN10CA517Accident · Minor injuriesData collectionFinal reportBeech D35 · Guymon, OKThe loss of engine power for undetermined reasons.NTSB CEN10CA513Accident · No injuriesData collectionFinal reportCessna 172P · Bartlesville, OKThe student pilot's loss of directional control during takeoff due to an improper flap setting.NTSB CEN10LA483Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Idabel, OKA loss of engine power for undetermined reasons.NTSB CEN10CA464Accident · No injuriesData collectionFinal reportCessna 414 · Vici, OKThe pilot's failure to ensure adequate runway remaining during landing.NTSB CEN10LA440Accident · No injuriesLimited investigationFinal reportBeech F35 · Enid, OKA loss of engine power for undetermined reasons.