NTSB investigations, 1997, AR
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 per year
| 1964 | 85 |
|---|---|
| 1965 | 80 |
| 1966 | 87 |
| 1967 | 109 |
| 1968 | 81 |
| 1969 | 89 |
| 1970 | 76 |
| 1971 | 92 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 81 |
| 1975 | 107 |
| 1976 | 101 |
| 1977 | 91 |
| 1978 | 96 |
| 1979 | 90 |
| 1980 | 76 |
| 1981 | 72 |
| 1982 | 68 |
| 1983 | 46 |
| 1984 | 89 |
| 1985 | 49 |
| 1986 | 48 |
| 1987 | 46 |
| 1988 | 61 |
| 1989 | 48 |
| 1990 | 65 |
| 1991 | 53 |
| 1992 | 57 |
| 1993 | 55 |
| 1994 | 54 |
| 1995 | 58 |
| 1996 | 44 |
| 1997 | 40 |
| 1998 | 44 |
| 1999 | 49 |
| 2000 | 23 |
| 2001 | 21 |
| 2002 | 37 |
| 2003 | 37 |
| 2004 | 31 |
| 2005 | 37 |
| 2006 | 28 |
| 2007 | 17 |
| 2008 | 22 |
| 2009 | 21 |
| 2010 | 32 |
| 2011 | 22 |
| 2012 | 23 |
| 2013 | 21 |
| 2014 | 17 |
| 2015 | 21 |
| 2016 | 22 |
| 2017 | 16 |
| 2018 | 20 |
| 2019 | 14 |
| 2020 | 16 |
| 2021 | 19 |
| 2022 | 21 |
| 2023 | 23 |
| 2024 | 14 |
| 2025 | 20 |
| 2026 | 13 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1997
AND 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 year(c."eventDate") = 1997 AND 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 FTW98LA083Accident · Serious injuriesLimited investigationFinal reportCessna R172K · Lakeview, ARthe pilot's failure to maintain runway alignment during the approach, and his delayed decision to execute a go-around. A related factor was the sunglare interfering with the pilot's view.NTSB FTW98LA078Accident · No injuriesLimited investigationFinal reportBeech 35 · Springdale, ARThe fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…NTSB FTW98LA082Accident · No injuriesLimited investigationFinal reportMooney M20 · Pocahontas, ARfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in an inadvertent ground swerve. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB FTW98LA059Accident · No injuriesLimited investigationFinal reportMooney M20F · Stuttgart, ARthe pilot's failure to activate the runway lights, which led to his selection of a closed/abandoned runway for the landing. Factors relating to the accident were: the unlatched cabin door, and the lack of lighting conditions at dusk.NTSB FTW98FA031Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Hazen, ARThe pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the make and model of aircraft, the pilot's lack of total night flight experience, and the dark night conditions,NTSB FTW98LA005Accident · No injuriesLimited investigationFinal reportCessna 175A · Bentonville, ARThe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA355Accident · Serious injuriesLimited investigationFinal reportAmerican General AG5B · Texarkana, ARthe pilot's improper planning/decision, by failing to ensure timely refueling of the airplane, which resulted in fuel exhaustion, loss of engine power, and a forced landing.NTSB FTW97LA358Accident · No injuriesLimited investigationFinal reportMooney M20C · Pettigrew, ARThe pilot's improper in-flight decision. Factors were the prevailing low ceilings, the inaccurate flight and navigation instruments as result of the failure of the engine accessories vacuum pump and the lack of suitable terrain for the pilot to execute the…NTSB FTW97LA347Accident · No injuriesLimited investigationFinal reportHughes MDL-369HS · Brinkley, ARThe in flight collision of the tail rotor blade with an object that had a brass zipper on it, and the subsequent overload and failure of the tail rotor drive shaft. Factors were the object with the brass zipper on it and the unsuitable terrain for the forced…NTSB FTW97LA344Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Horseshoe Bend, ARFuel starvation due to partially blocked fuel vents. Factors were: the pilot's inadequate preflight inspection of the airplane; the pilot's improper decision to continue operation of the airplane with known deficiencies; and the lack of suitable terrain for…NTSB FTW97LA341Accident · Serious injuriesLimited investigationFinal reportBurgess Skyhopper · Jonesboro, ARThe pilot's failure to obtain/maintain the aircraft's airspeed. Factors were the high density altitude and the lack of suitable terrain for the forced landing.NTSB FTW97LA332Accident · No injuriesLimited investigationFinal reportPitts S-2B · Mountain View, ARFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97FA330Accident · 1 fatalField investigationFinal reportSouthwest Florida SW204 · Manila, ARFatigue failure of the main rotor blade resulting in the in-flight separation of the main rotor system due to the use of an unairworthy blade, and failure of the maintenance personnel who modified the rotor blade and the mechanic who complied with the…NTSB FTW97FA304Accident · 1 fatalField investigationFinal reportGrumman G-164 · Wilmot, ARThe loss of engine power due to a fractured throttle cable because the cable housing prevents an inspection of the cable by maintenance personnel. Factors were the pilot's impairment due to a heart attack, the lack of suitable terrain for the forced landing,…NTSB FTW97LA296Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Harrison, ARThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA284Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pine Bluff, ARloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.NTSB FTW97LA279Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlisle, ARthe pilot's failure to maintain directional control of the airplane during the takeoff roll (at night).NTSB FTW97LA276Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Palestine, ARThe pilot's failure to maintain clearance with the wire transmission line due to his diverted attention.NTSB FTW97LA264Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Crossett, ARfailure of maintenance personnel to perform an adequate inspection of the fuselage center frame and detect a fatigue fracture of a longeron tube on the upper left side of the center frame, which resulted in a disconnect of the tail rotor drive shaft from the…NTSB FTW97LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ashdown, ARThe inadvertent stall/mush. A factor was the high density altitude.NTSB FTW97LA257Accident · Serious injuriesLimited investigationFinal reportReiffer RS-15 · Ward, ARThe pilot's inadvertent stall. Factors were the pilot's failure to attain the proper touchdown point, his failure to use the flaps to obtain the proper touchdown point, and the pilot's lack of recent experience in the type of aircraft.NTSB FTW97LA233Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Swifton, ARthe pilot's improper planning/decision. Factors relating to the accident were: the pilot's lack of recent experience in type of airplane, the weather condition (high temperature and tailwind), and the proximity of the fence and trees to the runway.NTSB FTW97LA231Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Waldenburg, ARthe pilot's improper planning/decision. The short runway and failure to use up to 10 degrees of flaps were related factors.NTSB FTW97FA221Accident · 2 fatalField investigationFinal reportCessna 172N · Greenbrier, ARThe pilot's failure to maintain aircraft control during a low altitude maneuver. Factors were the pilot's lack of total experience in the type of operation and inadequate training by the company management.NTSB FTW97FA220Accident · 1 fatalField investigationFinal reportAyres S2R-T34 · Corning, ARThe in-flight separation of the left wing as result of fatigue crack of the lower spar cap due to inadequate materials by the manufacturer. A factor was the operator's failure to comply with a published service bulletin on the airframe.NTSB FTW97LA224Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Little Rock, ARa loss of engine power due to fuel starvation from a partially blocked fuel line which was the result of improper maintenance by unknown person(s). A factor was the lack of suitable terrain for landing.NTSB FTW97LA223Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Black Oak, ARThe loss of engine power due to compressor turbine blade failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA219Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Biggers, ARThe total blockage of a fuel line by a silicone rubber contaminant which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA216Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Swifton, ARMain landing gear collapse resulting from a failure of the torque link assembly attaching bolt. A factor was the lack of required maintenance (lubrication of the bolt) which resulted in the bolt becoming dry and corroded.NTSB FTW97LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ward, ARThe loss of engine power resulting from fuel starvation due to the pilot's mismanagement of available fuel. A factor was the lack of suitable terrain for a forced landing.NTSB FTW97FA193Accident · 1 fatalField investigationFinal reportPezetel M-18A · Wilmot, ARfailure of the pilot to remove the elevator control lock before the first flight of the day, which resulted in his inability to control the airplane, due to the locked elevator control. Related factors were: the prevailing high winds and the lack of a visible…NTSB FTW97LA182Accident · Minor injuriesLimited investigationFinal reportMooney M20K · N Little Rock, ARThe pilot's failure to maintain aircraft control. A factor was the pilot's failure to use the proper aborted landing procedures.NTSB FTW97LA195Accident · No injuriesLimited investigationFinal reportCessna 182K · Little Rock, ARthe pilot's improper flare and improper recovery from a bounced landing.NTSB FTW97LA170Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · El Dorado, ARThe pilot misjudging his altitude above the airport, resulting in not attaining the proper touchdown point. A factor was the separation of teeth from the aft gear of the spur gear assembly, which resulted in the interruption of fuel.NTSB FTW97LA141Accident · No injuriesLimited investigationFinal reportPiper PA-17 · N Little Rock, ARloss of engine power due to failure of the crankshaft. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB FTW97LA140Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Watson, ARThe pilot's failure to attain lift off speed and the ground loop/swerve encountered. Factors were the gravel and soft terrain at the end of the runway.NTSB FTW97LA136Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Swifton, ARthe pilot's improper in-flight planning/decision and failure to maintain positive control of the airplane, while performing an aerobatic maneuver.NTSB FTW97LA134Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Paragould, ARThe pilot's failure to maintain clearance from trees resulting in jammed control surfaces. A factor was that aircraft control was not possible by the pilot.NTSB FTW97LA127Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402 · Pine Bluff, ARfailure of the pilot to see-and-avoid the tower. The proximity of the tower was a related factor.NTSB FTW97LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Rogers, ARthe pilot's improper fuel consumption calculations, which resulted in the loss of engine power, due to fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for a forced landing.