NTSB investigations, AR
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\" = '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 FTW96LA330Accident · No injuriesLimited investigationFinal reportSchleicher KA6-CR · Forrest City, ARthe pilot's failure to abort the takeoff. Factors were the dust restricting his visibility and the uneven terrain.NTSB FTW96LA325Accident · Minor injuriesLimited investigationFinal reportPezetel M-18A · Mcgehee, ARfailure of the brake system for undetermined reason(s), which resulted in a loss of directional control and a subsequent encounter with a ditch.NTSB FTW96LA315Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Mount Holly, ARFuel exhaustion due to the pilot's failure to refuel the helicopter. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA309Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mountain Home, ARfailure of the pilot to compensate for the tailwind and attain the proper touch down point. The tailwind was a related factor.NTSB FTW96LA308Accident · No injuriesLimited investigationFinal reportDearinger Duce · Corning, ARThe pilot's failure to arrest his rate of descent and his improper recovery from a bounced landing.NTSB FTW96LA307Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Beedeville, ARThe pilot's failure to maintain terrain clearance.NTSB FTW96LA306Accident · No injuriesLimited investigationFinal reportSmith RV4 · Mandeville, ARa loss of engine power for undetermined reasons.NTSB FTW96LA302Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Rogers, ARfuel exhaustion due to the pilot's failure to refuel. Factors were the below landing minimums weather conditions and the lack of suitable terrain for the forced landing.NTSB FTW96LA297Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Mcgehee, ARa loss of engine power and subsequent engine fire for undetermined reasons.NTSB FTW96LA296Accident · No injuriesLimited investigationFinal reportCessna 180J · Mountain Home, ARThe pilot's failure to maintain directional control during landing. A factor was the cross wind.NTSB FTW96LA301Accident · No injuriesLimited investigationFinal reportMyers Smythe Sidewinder · El Dorado, ARthe pilot's failure to attain the correct touchdown point. Factors were: hydroplaning due to the wet runway, and the berm in the overrun area.NTSB FTW96LA286Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Almyra, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's excessive use of flaps during the maneuver.NTSB FTW96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301A · Hunter, ARThe loss of engine power for undetermined reasons.NTSB FTW96LA260Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Prescott, ARThe loss of engine power due to improper fuel. Factors were the pilot's inadequate preflight and lack of suitable terrain for the forced landing.NTSB FTW96LA251Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Cash, ARThe partial loss of engine power due to fuel contamination. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW96LA245Accident · No injuriesLimited investigationFinal reportBeech 23 · Weiner, ARan improper flare by the pilot, which resulted in a hard landing.NTSB FTW96FA243Accident · 1 fatalField investigationFinal reportAeronca 65-CA · Lonoke, ARThe pilot's failure to maintain aircraft control.NTSB FTW96LA236Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Dumas, ARFailure of all personnel concerned to identify the unsafe/hazardous condition, which resulted from a visual restriction, due to trees near the intersection of the road and runway.NTSB FTW96LA232Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARfailure of the pilot to maintain clearance from the power line.NTSB FTW96FA230Accident · 5 fatalField investigationFinal reportPiper PA-31T · Malvern, ARThe pilot's failure to maintain control of the airplane after takeoff.NTSB FTW96LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Griffithville, ARloss of engine oil (leak) for an undetermined reason, which resulted in oil starvation and a loss of engine power; and failure of the pilot to maintain airspeed during the emergency descent/landing phase, which resulted in an inadvertent stall and subsequent…NTSB FTW96LA209Accident · No injuriesLimited investigationFinal reportCessna 150M · Springdale, ARthe flight instructor's improper (unapproved) procedure of using the mixture control to simulate an engine failure. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Mountain Home, ARthe pilot's failure to visually check the fuel quantity during the preflight inspection. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA194Accident · No injuriesLimited investigationFinal reportChampion 7AC · Pine Bluff, ARthe pilot's failure to follow proper starting procedures, and an inadequate tie-down.NTSB FTW96LA196Accident · No injuriesLimited investigationFinal reportBeech A35 · Siloam Springs, ARthe pilot's inadequate compensation for the crosswind. The crosswind was a factor.NTSB FTW96LA189Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Malvern, ARfailure of the pilot to apply carburetor heat during the approach to land, which resulted in a loss of engine power due to carburetor ice. A factor relating to the accident was: the carburetor icing (weather) condition.NTSB FTW96LA188Accident · No injuriesLimited investigationFinal reportCessna 182P · Fordyce, ARthe pilot's failure to initiate a timely go-around. A factor was the pilot's misjudgment of distance and speed during the approach.NTSB FTW96LA160Accident · No injuriesLimited investigationFinal reportCessna 172K · Danville, ARthe student pilot's inadequate compensation for the crosswind. Factors were the crosswind and the soft terrain.NTSB FTW96LA148Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Texarkana, ARa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA135Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARFailure of the engine master rod. A factor relating to the accident was: the lack of suitable terrain for a forced landing, due to the proximity of a power line and trees.NTSB FTW96LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dewitt, ARa loss of engine power due to the malfunction of the carburetor as a result of an improper overhaul. A factor was the unsuitable terrain for the forced landing.NTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).NTSB FTW96LA139Accident · No injuriesLimited investigationFinal reportRockwell 500U · Hampton, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96FA108Accident · Serious injuriesField investigationFinal reportCessna 152 · Conway, ARloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall at low altitude. The gusty wind condition was a related factor.NTSB FTW96FA100Accident · 4 fatalField investigationFinal reportBeech 58 · Atkins, ARContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above mountainous/hilly terrain. Factors relating to the accident were: low ceiling, fog, and high terrain in the area of the…NTSB FTW96LA069Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · West Helena, ARBinding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.NTSB FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.NTSB FTW96LA043Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Berryville, ARThe pilot's failure to conduct an adequate preflight and remove the control locks.NTSB FTW96LA032Accident · No injuriesLimited investigationFinal reportCessna 175 · Deer, ARThe pilot's selection of a downwind runway for landing. Factors were the tailwind and the pilot's misinterpretation of the wind conditions.NTSB FTW96LA018Accident · No injuriesLimited investigationFinal reportCessna 175 · Batesville, ARthe pilot's failure to maintain control of the airplane during landing.NTSB FTW96LA007Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamburg, ARLoss of engine power due to a cylinder failure. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW95LA396Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Searcy, ARThe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB FTW95FA393Accident · 3 fatalField investigationFinal reportCessna 172M · Witter, ARfailure of the pilot to maintain sufficient altitude/clearance from high/wooded terrain. Factors relating to the accident were: darkness, high terrain, and foggy weather conditions. Also, the pilot's use of Methamphetamine (not approved by the FAA) was a…NTSB FTW95LA391Accident · No injuriesLimited investigationFinal reportCessna 172D · Prim, ARThe loss of engine power for undetermined reasons. Factors were the pilot's inability to initiate a flare due to the fracture of the yoke assembly, and the lack of suitable terrain for the forced landing.NTSB FTW95LA371Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Trumann, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain available to the pilot to execute the forced landing.NTSB FTW95LA355Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fayetteville, ARThe pilot's inability to extend the landing gear due to the failure of an emergency gear extension valve.NTSB FTW95LA350Accident · No injuriesLimited investigationFinal reportCessna A150L · Paragould, ARLoss of engine power due to an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW95LA346Accident · No injuriesLimited investigationFinal reportCessna 150F · Manila, ARA blown (tripped) fuse, which rendered flap retraction inoperative. Factors relating to the accident were: the hot weather condition, the aircraft's lack of climb performance with the flaps extended, and the lack of suitable terrain in the forced landing area.NTSB FTW95LA345Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Wilmot, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA339Accident · No injuriesLimited investigationFinal reportReims Cessna FR182 · Lakeview, ARThe pilot's improper recovery from a bounced landing, and failure to maintain directional control. Factors related to the accident were: the pilot's failure to attain the proper touchdown point or abort the landing.