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 DFW06CA166Accident · No injuriesData collectionFinal reportCessna 172A · Durant, OKThe pilot's failure to maintain airspeed resulting in an inadvertent stall/spin.NTSB DFW06CA150Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Alex, OKThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.NTSB DFW06CA132Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the dark night conditions and the pilot's inadequate preflight planning and preparation.NTSB DFW06CA131Accident · No injuriesData collectionFinal reportCessna 150M · Ardmore, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning.NTSB DFW06CA112Accident · No injuriesData collectionFinal reportBell 206B · Vinita, OKThe pilot's improper pre-flight planning, which resulted in a total loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA107Accident · No injuriesData collectionFinal reportPiper PA-22 · Tecumseh, OKThe pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB DFW06LA078Accident · 1 fatalLimited investigationFinal reportCessna C-37 · Fittstown, OKThe loss of engine power due to a cracked cylinder head. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.NTSB DFW06LA060Accident · No injuriesLimited investigationFinal reportCessna 175 · Lindsay, OKThe hard landing was the result of the pilot's failure to maintain adequate airspeed while misjudging the altitude above the runway. Contributing factors were the inadequate quality of the manufacturer's engine-support bracket and the prevailing night…NTSB DFW06CA051Accident · Minor injuriesData collectionFinal reportCessna 177 · Antlers, OKThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight planning. A contributing factor was the encounter with windshear during the forced landing.NTSB DFW06CA045Accident · Minor injuriesData collectionFinal reportCessna 150L · Tulsa, OKThe pilot's improper preflight planning and preparation, which resulted in a loss of engine power due to fuel exhaustion.NTSB DFW06CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Bixby, OKThe loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA248Accident · No injuriesData collectionFinal reportPiper PA-46T · El Reno, OKThe improper flare which resulted in a hard landing. A related factor was the instructor's delayed remedial action.NTSB DFW05FA242Accident · 1 fatalField investigationFinal reportAkro Tech Aviation Inc. Giles G-300 · Yukon, OKThe catastrophic separation of the canopy as result of the failure of the forward canopy hinge while performing aerobatics and the subsequent incapacitation of the pilot.NTSB DFW05CA224Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing. A contributing factor was the dark night conditions.NTSB DFW05CA194Accident · No injuriesData collectionFinal reportCessna 175A · Graham, OKThe impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB DFW05FA188Accident · 3 fatalField investigationFinal reportCessna 310Q · Ada, OKThe loss of engine power as a result of a fatigue fracture in one of the crankshaft gear teeth for undetermined reasons. Also causal was the pilot's failure to maintain control of the twin-engine airplane after the power loss, which resulted in an inadvertent…NTSB DFW05LA187Accident · 1 fatalLimited investigationFinal reportYakovlev Yak 52 · Claremore, OKThe pilot's failure to obtain adequate airspeed while executing a low altitude aerobatic maneuver, which resulted in an aerodynamic stall while inverted. A factor was the low altitude.NTSB DFW05FA178Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Norman, OKThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the pilot's attempted aborted landing following a hard landing and propeller strike.NTSB DFW05CA164Accident · No injuriesData collectionFinal reportCessna 152 · Burneyville, OKThe students pilot's improper flare and his failure to maintain directional control of the airplane. A contributing factor was the bounced landing.NTSB DFW05CA154Accident · No injuriesData collectionFinal reportCessna 152 · Marietta, OKThe pilot's failure to maintain directional control while executing a soft field take off. A factor was the prevailing dark night conditions.NTSB DFW05IA156Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace Avro 146-RJ85A · Oklahoma City, OKFailure of a high pressure hydraulic line from fatigue as a result of a manufacturing defect.NTSB DFW05CA143Accident · No injuriesData collectionFinal reportLuscombe 8A · Wagoner, OKThe pilots failure to maintain directional control during landing and attempted go-around.NTSB DFW05LA140Accident · Serious injuriesLimited investigationFinal reportDebus/Mountain/Bowes Debus-Casst-Snoshoo · Oklahoma City, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the loss of engine power as result of the fracture of the number two piston to crankshaft connecting rod.NTSB DFW05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Perry, OKA loss of engine power for undetermined reasons. A contributing factor was collision with a piece of farm equipment.NTSB DFW05CA104Accident · Minor injuriesData collectionFinal reportBeech J35 · Bartlesville, OKA loss of engine power due to the pilot's inadvertent and improper positioning of the fuel tank selector, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA072Accident · No injuriesData collectionFinal reportRobinson R44 II · Woodward, OKthe pilot's encounter with adverse weather conditions.NTSB DFW05CA101Accident · No injuriesData collectionFinal reportCessna 152 · Stillwater, OKThe student pilot's failure to maintain directional control during landing.NTSB DFW05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Shawnee, OKThe pilot's improper landing flare and his inadequate recovery from a bounced landing. A factor was the prevailing crosswind.NTSB DFW05LA081Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Westport, OKThe collapsing of the right main landing gear as a result of the failure of the scissors assembly.NTSB DFW05CA070Accident · Minor injuriesData collectionFinal reportRobinson R22 · Owasso, OKThe flight instructor's failure to verify that the student had the flight controls and his delayed remedial action.NTSB DFW05CA061Accident · Minor injuriesData collectionFinal reportMaule M-4-210C · McAlister, OKThe loss of engine power due to fuel exhaustion as result of the pilot's improper fuel calculations, and his inadequate in-flight planning decision. A contributing factor was the pilot's failure to complete an emergency pre-landing checklist, which resulted…NTSB DFW05LA067Accident · No injuriesLimited investigationFinal reportCessna 172F · Sallisaw, OKA loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05FA055Accident · 1 fatalField investigationFinal reportCessna T-37B · Hollister, OKThe pilots of the AT-502B and the T-37B failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft. Contributing factors included the lack of a transponder and radios on the AT-502B, and the reduced visibility due to…NTSB DFW05LA069Accident · 1 fatalLimited investigationFinal reportNolen Lite Squared · Holdenville, OKUndeterminedNTSB DFW05LA053Accident · Serious injuriesLimited investigationFinal reportMyers Kit Fox Series VI · Cleveland, OKThe pilot's failure to maintain control and sufficient airspeed while performing an abrupt pull-up manuever after takeoff, which resulted in an inadvertent stall/spin.NTSB DFW05LA037Accident · 2 fatalLimited investigationFinal reportCrosley Christen Eagle II · Morris, OKThe pilot's intentional spin, which was unrecoverable due to exceeded aircraft weight and balance limitations as a result of improper preflight planning/preparation.NTSB DFW05LA031Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Tulsa, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.NTSB DFW05LA027Accident · No injuriesLimited investigationFinal reportCessna P210N · Pawhuska, OKThe pilot's mismanagement of the fuel by his failure to adequately set the fuel selector position which resulted in fuel exhaustion and the loss of engine power.NTSB DFW05LA019Accident · Minor injuriesLimited investigationFinal reportBell 206L1 · Sapulpa, OKThe loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.NTSB DFW05FA015Accident · 1 fatalField investigationFinal reportPiper PA-30 · Boise City, OKThe pilot's incapacitation (cardiovascular) resulting in a loss of aircraft control.NTSB DFW05LA012Accident · 1 fatalLimited investigationFinal reportHuber DR 107 · Fletcher, OKThe pilot's inadequate planning/decision to conduct an aerobatic maneuver without sufficient altitude to recover.NTSB DFW05CA006Accident · No injuriesData collectionFinal reportGunnoe Velocity · Myrick, OKThe pilot's improper wind evaluation. Contributing factors were the tailwind and the short runway.NTSB DFW05CA002Accident · No injuriesData collectionFinal reportBalloon Works Firefly 8B-15 · Piedmont, OKThe pilot's failure to maintain clearance with power lines while landing. Contributing factors were the reduced visibility, fog, and low cloud ceiling.NTSB FTW05CA002Accident · No injuriesData collectionFinal reportThunder and Colt AA-1050 · Crescent, OKThe pilot's failure to maintain clearance from the high power transmission lines. Contributing factor was the dark night and high wind conditions.NTSB FTW04TA219Accident · Serious injuriesFinal reportCessna 182Q · Lamar, OKThe pilot's failure to maintain airspeed which resulted in a inadvertent stall. Contributing factors were the low altitude and high wind.NTSB SEA04FA165Accident · 3 fatalField investigationFinal reportCessna T210L · Tulsa, OKThe pilot's inadequate preflight inspection by his failure to secure the oil cap, which resulted in oil leakage on the windscreen, obstructing his vision, and his failure to maintain adequate airspeed.NTSB FTW04LA202Accident · No injuriesLimited investigationFinal reportCessna 140 · Kingston, OKThe failure by the other pilot to maintain visual lookout for other aircraft during landing.NTSB FTW04LA188Accident · No injuriesLimited investigationFinal reportMattie RV-4 · El Reno, OKThe pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane during landing.NTSB FTW04LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Blackwell, OKThe pilot's failure to maintain directional control and the instructor's inadequate supervision by his delay in taking corrective action during the landing roll.NTSB FTW04LA171Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Tulsa, OKThe loss of engine power for undetermined reasons.