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 FTW99LA010Accident · No injuriesLimited investigationFinal reportMooney M20A · Oklahoma City, OKThe loss of engine power due to fuel starvation as result of the pilot's improper placement of the fuel tank selector switch. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB FTW99FA006Accident · 1 fatalField investigationFinal reportCessna 172M · Oklahoma City, OKSuicide.NTSB FTW99LA005Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Ringling, OKThe pilot's failure to maintain obstacle clearance. A factor was the sun glare which impaired the pilot's vision.NTSB FTW99LA003Accident · No injuriesLimited investigationFinal reportBeech M35 · Carter, OKFuel starvation. Factors were; the pilot's self induced pressure to fly the aircraft when maintenance had not been completed, poor judgement by the pilot to commence and continue flight with known deficiencies in the aircraft, and the lack of suitable terrain…NTSB FTW98LA409Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Catoosa, OKThe pilot's failure to maintain control of the airplane resulting in an inadvertent stall.NTSB FTW98LA403Accident · No injuriesLimited investigationFinal reportCessna 150M · Yukon, OKThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB FTW98LA400Accident · No injuriesLimited investigationFinal reportBell 47-G-2 · Ardmore, OKThe pilots failure to maintain clearance with terrain and the ensuing loss of control.NTSB FTW98LA397Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tahlequah, OKThe pilot's failure to maintain directional control of the aircraft during takeoff. A factor was the gusty wind conditions at the time of the accident.NTSB FTW98LA345Accident · Minor injuriesLimited investigationFinal reportFennell VP2 · Collinsville, OKThe loose throttle control cable resulting in the loss of engine power. A factor was the pilot's decision to intentionally stall the airplane close to the ground during the forced landing to an open field.NTSB FTW98LA346Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe student pilot's delayed landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB FTW98LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fairview, OKLoss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98FA306Accident · 2 fatalField investigationFinal reportBell 47G · Jones, OKThe pilot's failure to maintain adequate clearance from the trees during a low altitude flight/maneuver.NTSB FTW98LA294Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe airplane's impeded climb performance for undetermined reasons. A factor was the rising terrain.NTSB FTW98LA271Accident · No injuriesLimited investigationFinal reportCessna 150C · Collinsville, OKThe pilot's failure to maintain directional control during landing roll. A factor was the pilot's diverted attention.NTSB FTW98LA263Accident · 1 fatalLimited investigationFinal reportMoore B-8MJ · Pauls Valley, OKThe non-certificated pilot's failure to maintain clearance from the hangar. A factor was the pilot's maneuvering at a low altitude.NTSB FTW98LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Balko, OKThe pilot's inadequate preflight planning which failed to assure adequate climb performance to clear an obstacle (fence) during takeoff climb.NTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB FTW98FA238Accident · 1 fatalField investigationFinal reportBell 47G · Bixby, OKThe pilot's failure to maintain clearance from the power lines.NTSB FTW98LA234Accident · Minor injuriesLimited investigationFinal reportHarding Revolution MINI-500B · Grove, OKThe improper alignment of the main drive belt by the owner/pilot/mechanic, which resulted in the failure of the main drive belt. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98FA229Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Guthrie, OKThe designated pilot examiner's decision to execute a single engine go-around which exceeded the airplane's engine out climb capability in the gear down configuration. Factors were the arcing of an electrical wire that grounded the engine starter and the high…NTSB FTW98LA210Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKThe loss of engine power due to water contamination of the fuel. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW98FA203Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Olustee, OKThe student pilot's improper decision to attempt an 180 degree turn to return to the takeoff runway.NTSB FTW98FA189Accident · 2 fatalField investigationFinal reportCessna 150F · Muskogee, OKThe inadvertent stall as result of the pilot's failure to retract the flaps from the fully extended position prior to takeoff. Factors were the gusting winds and the pilot's failure to follow the before takeoff checklist.NTSB FTW98LA182Accident · No injuriesLimited investigationFinal reportFroberg Rotorway Executive · Sand Springs, OKThe failure of the owner/pilot to complete maintenance on the helicopter.NTSB FTW98TA174Accident · No injuriesFinal reportBellanca 7GCBC · Mcalester, OKthe pilot's inadequate compensation for the gusty crosswinds, during recovery from a bounced landing; and his failure to maintain directional control during a go-around. Related factors were: the wind conditions, and a subsequent encounter with of a fence and…NTSB FTW98LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain directional control during landing. A factor was the pilot's lack of total experience in the make and model of aircraft.NTSB FTW98LA171Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cushing, OKThe total loss of engine power resulting from a sheared accessory drive due to an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA162Accident · Minor injuriesLimited investigationFinal reportCarter LONG-EZ · Lebanon, OKThe pilot's inadequate compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the tailwind and the pilot's failure to adequately preflight the airplane which resulted in a partial loss of engine power due to…NTSB FTW98LA159Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Norman, OKThe pilot's improper compensation for wind conditions, which resulted in a loss of directional control and collision with a ditch. A contributing factor was the high crosswind.NTSB FTW98LA154Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tulsa, OKThe complete loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Marietta, OKThe pilot's improper compensation for the wind conditions. A factor was the crosswind.NTSB FTW98IA130Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lawton, OKthe collapse of the left main landing gear during landing roll as result of a shorted weight-on-wheels relay. Contributing factors were the insufficient information available to the flight crew in the company's quick reference handbook (QRH), and the…NTSB FTW98LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKFuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frederick, OKThe loss of wheel brakes due to the failure of the brake actuating cable. A factor was the tailwind.NTSB FTW98LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lone Grove, OKThe total loss of engine power for an undetermined reason. Factors were the total loss of electrical power resulting from a separated alternator cable due to improper maintenance by unknown maintenance personnel, the lack of suitable terrain for the forced…NTSB FTW98LA108Accident · No injuriesLimited investigationFinal reportCessna 340 · Wagoner, OKthe entrance of deer onto the runway, which resulted in an unavoidable impact. Darkness was a related factor.NTSB FTW98LA103Accident · No injuriesLimited investigationFinal reportCessna 340A · Bethany, OKThe pilot's flight into known adverse weather conditions which resulted in an inadvertent stall due to airframe ice. A factor was the icing conditions.NTSB FTW98LA085Accident · No injuriesLimited investigationFinal reportMooney M20J · Westport, OKThe pilot's inadequate compensation for the existing wind conditions. A factor was gusty winds.NTSB FTW98LA040Accident · No injuriesLimited investigationFinal reportCessna 172G · Elk City, OKThe high winds and the pilot's poor judgment in attempting to taxi in the existing wind conditions.NTSB FTW98LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent collapse of the nose gear.NTSB FTW98LA016Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Altus, OKThe loss of engine power due to the cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA372Accident · No injuriesLimited investigationFinal reportCessna 170A · Oklahoma City, OKThe pilot's inadequate compensation for the crosswind conditions resulting in an inadvertent groundloop. Factors were the crosswind, the pilot's lack of total experience in make and model, the separation of the left main wheel due to corroded bolts, and the…NTSB FTW97LA346Accident · 1 fatalLimited investigationFinal reportReilly Thorp T-18 · Wagoner, OKthe pilot's failure to maintain airspeed.NTSB FTW97LA339Accident · 1 fatalLimited investigationFinal reportRoddie MINI-500 · Idabel, OKThe loss of control in flight for undetermined reasons. A factor was the pilot's lack of total experience in helicopters.NTSB FTW97LA325Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Marietta, OKThe pilot's failure to follow procedures/directives for takeoff. Factors were the runway's rough/uneven condition and the hilly terrain on the departure end of the runway.NTSB FTW97LA290Accident · No injuriesLimited investigationFinal reportCessna A150K · Elgin, OKfuel contamination, and the pilot's inadequate preflight of the airplane. Trees in the emergency landing area were considered a related factor.NTSB FTW97LA282Accident · Minor injuriesLimited investigationFinal reportShapley Quickie Q-200 · Tahlequah, OKthe pilot's failure to maintain directional control of the aircraft during the landing. A factor relating to the accident was: low pressure in the right main tire.NTSB FTW97LA277Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Blackwell, OKpartial loss of engine power for undetermined reasons. Factors relating to the accident were: the high vegetation and ditch in the emergency landing area.NTSB FTW97LA272Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Chickasha, OKthe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.NTSB FTW97LA254Accident · No injuriesLimited investigationFinal reportNorth American NA-265-80 · Ardmore, OKThe failure of maintenance personnel to mask the gear locking pins prior to painting the airplane which resulted in the right main gear locking pin jamming in the unlocked position due to contamination with paint. A factor was the failure of maintenance…