NTSB investigations, AR
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\" = 'AR' 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" = 'AR' 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 MKC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Little Rock, ARThe failure of the powerplant due to a sheared timing gear. Contributing factors were unsuitable terrain and restricted vision due to fog.NTSB MKC90LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Bald Knob, ARThe powerplant failure for undetermined causes. Contributing factor was unsuitable terrain.NTSB MKC90LA109Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Searcy, ARPilot impairment from consumption of alcohol, inadequate preflight by the pilot, and fuel contamination with water and dirt (mud) in the system.NTSB MKC90LA117Accident · Serious injuriesLimited investigationFinal reportBell 47G · Wynne, ARLanding gear skid entangled with a fuel hose. A factor was the pilot's inadequate preflight inspection.NTSB MKC90LA104Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Scott, ARPilot in command's failure to maintain directional control during the landing roll. Related to the accident was tall grass and soft terrain.NTSB MKC90FA101Accident · 1 fatalField investigationFinal reportBeech J-35 · Pine Bluff, ARAircraft stall, from which recovery was not achieved.NTSB MKC90LA097Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Little Rock, ARPilot in command's failure to refuel the airplane, which resulted in fuel exhaustion. Related to the accident was: unsuitable terrain in the emergency landing area.NTSB MKC90LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Allport, ARImproper use of carburetor heat by the pilot. Contributing factors were carburetor icing conditions, power lines and visual outlook inadequate by the pilot.NTSB MKC90LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Des Arc, ARWater contamination of the fuel, due to improper ground servicing of the aircraft, and an improper preflight by the pilot.NTSB MKC90LA094Accident · No injuriesLimited investigationFinal reportBennett KR-1 · Blytheville, ARImproper handling of the aircraft during a high speed taxi.NTSB MKC90FA091Accident · 2 fatalField investigationFinal reportPiper PA32RT-300 · Mansfield, ARThe non-instrument rated pilot's decision to continue VFR flight into IMC. Contributing to the accident were the low ceilings, rain, and turbulence encountered at low altitude, and the pilot's lack of instrument training/experience.NTSB MKC90LA085Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Pleasant Grove, ARImproper use of carburetor heat by the pilot, which resulted in carburetor icing. The weather (carburetor icing condition) was a related factor.NTSB MKC90LA083Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Harrisburg, ARFailure of the generator, and failure of the pilot to maintain rotor RPM.NTSB MKC90LA080Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mounds, ARThe pilot's improper compensation for wind conditions. Factors related to the accident were: the pilot's selection of the wrong runway and the resultant tailwind condition.NTSB MKC90LA079Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Des Arc, ARFailure of the engine fuel pump.NTSB MKC90LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARFailure of the pilot to maintain proper runway alignment, which resulted in an encounter with soft/wet (muddy) terrain and a subsequent nose over of the aircraft.NTSB MKC90DPG01Accident · Serious injuriesFinal reportVolksplane WE-1 · Wooster, ARThe power loss for undetermined reasons and the inadvertent stall. A factor was the pilot's maximum performance takeoff.NTSB MKC90LA067Accident · No injuriesLimited investigationFinal reportGrumman AG-CAT G-164A · Parkin, ARTotal failure of the engine's master connecting rod.NTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.NTSB MKC90LA064Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Elaine, ARImproper planning/decision by the pilot and his failure to maintain directional control. Factors related to the accident were: the unfavorable weather conditions, runway condition, and the pilot's overconfidence in himself and the aircraft.NTSB MKC90LA061Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARFailure of the engine exhaust valve.NTSB MKC90LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Lonoke, ARFailure of the pilot to maintain directional control of the aircraft. His lack of experience in the type of aircraft was a related factor.NTSB MKC90LA060Accident · No injuriesLimited investigationFinal reportCessna 140 · Brinkley, ARRecovery from bounced landing not performed and porpoise encountered by the pilot in command.NTSB MKC90LA059Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · El Dorado, ARFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind.NTSB MKC90LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palestine, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB MKC90LA051Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Conway, ARThe pilot failed to attain the proper touchdown point and the delayed initiation of the go-around. Contributing to the accident was the fence struck during the aborted landing.NTSB MKC90MA049Accident · 7 fatalMajor investigationFinal reportGrumman G1159 · Little Rock, ARFailure of the pilot-in-command to follow IFR procedures (maintain an ILS glide path or initiate a missed approach) during an IFR arrival to the airport. Factors related to the accident were: unfavorable weather conditions, an erroneous wind indication from…NTSB MKC90LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pine Bluff, ARAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of power.NTSB MKC90LA027Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Springdale, ARThe banner tow pick up equipment became entangled resulting in a jammed rudder and restricted aircraft control.NTSB MKC90FA020Accident · 1 fatalField investigationFinal reportCessna 402B · Little Rock, ARA leak in the aircraft's fuel system which resulted in an in-flight fire. The origin of the fuel leak was not determined.NTSB MKC90LA015Accident · No injuriesLimited investigationFinal reportCessna 150 · Cherokee Vill, ARThe pilots failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.NTSB MKC90LA011Accident · No injuriesLimited investigationFinal reportCessna 172Q · Hiwasse, ARThe pilot's failure to properly plan the flight and insure that there was sufficient fuel to complete the flight. The pilot also failed to monitor the fuel level during the flight.NTSB MKC90LA023Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Heafer, ARThe intentional swerve by the pilot during the takeoff roll. Contributing to the accident was the rough and soft terrain conditions.NTSB MKC90LA007Accident · No injuriesLimited investigationFinal reportCessna 182 · Hasty, ARThe engine failure due to fuel starvation resulting from the collapse at the fuel cell. The fact that the forced landing was made in dark night conditions was a factor.NTSB MKC90LA001Accident · No injuriesLimited investigationFinal reportAlon Aircoupe · Greers Ferry, ARThe pilot's misjudgement of performance data which resulted in the inability to gain sufficient airspeed for takeoff.NTSB MKC89FA196Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bentonville, ARA loose oil line that became disconnected, when maintenance/inspection of the aircraft had not been completed, which resulted in loss of engine oil and subsequent failure of the connecting rod from lack of lubrication. A factor related to the accident was:…NTSB MKC89LA192Accident · Minor injuriesLimited investigationFinal reportPietenpol AIR Camper B4A · Horatio, ARImproper use of carburetor heat by the pilot, which resulted in carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB MKC89LA190Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Wabbaseka, ARImproper planning/decision by the pilot which resulted in his failure to maintain clearance from the tall vegetation (grass). The tall vegetation & high density altitude were considered to be contributing factors.NTSB MKC89LA187Accident · No injuriesLimited investigationFinal reportBeech V35B · Concord, ARImproper installation of the alternator wiring harness by the pilot/owner which resulted in chafed wiring and a subsequent electrical fire. The uneven terrain was a contributing factor.NTSB MKC89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Russell, ARAn engine failure, because of a valve which stuck in the open position, over terrain that was unsuitable for a forced landing.NTSB MKC89DPG04Accident · Serious injuriesFinal reportRockwell S-2R · Moscow, ARInadequate visual lookout by the pilot. The guy wire was a contributing factor.NTSB MKC89LA173Accident · No injuriesLimited investigationFinal reportMooney M20C · Fouke, ARThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion, at night. The ensuing forced landing resulted in a collision with a fencepost, ground swerve, and collapse of the right main landing gear.NTSB MKC89LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft Smith, ARInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A contributing factor was the road sign.NTSB MKC89LA170Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Portland, AREngine failure due to failure of an engine cylinder.NTSB MKC89DPG03Accident · 1 fatalFinal reportPZL-Mielec M-18 · Parkin, ARThe failure of the pilot to maintain a visual lookout adequate to have avoided the powerlines.NTSB MKC89IA168Incident · No injuriesIncident investigationFinal reportBeech 65-90 · Springdale, ARThe pilot's failure to extend the landing gear.NTSB MKC89LA162Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bono, ARThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling/mushing and descending out of control until collision with trees.NTSB MKC89DPG02Accident · 1 fatalFinal reportRockwell S-2R · Reyno, ARImproper in-flight planning/decision by the pilot which resulted in a tight maneuver at inadequate airspeed and a subsequent stall. A contributing factor was the presence of high obstructions (trees).NTSB MKC89LA151Accident · Minor injuriesLimited investigationFinal reportPiper J3 "CUB" · Morrilton, ARThe abrupt handling of the airplane by the pilot. He failed to maintain airspeed and inadvertantly stalled and spun the airplane at an altitude insufficient for recovery.NTSB MKC89LA150Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Jonesboro, ARThe pilot's encounter with unsuitable terrain during a forced landing made necessary by the separation of three feet of one of the propeller blades.