NTSB investigations, 2001, AR
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 2001
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") = 2001 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 FTW02FA054Accident · 2 fatalField investigationFinal reportCessna T210-M · Monticello, ARThe separation of the #2 connecting rod and subsequent catastrophic failure of the engine. A factor was the in-flight collision with a vehicle while maneuvering to a emergency landing area.NTSB FTW02LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Wilton, ARthe pilot's failure to obtain a proper touchdown point and his excessive approach speed during a forced landing. A contributing factor was the total loss of engine power for undetermined reasons.NTSB FTW01LA190Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Odom, ARthe pilot's failure to follow the proper procedures for hand-propping an airplane.NTSB FTW01LA192Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Dover, ARthe pilot's delay in aborting the landing.NTSB FTW01LA180Accident · No injuriesLimited investigationFinal reportCessna 210 · Fort Smith, ARthe overload fracture of the left main landing gear actuator which resulted in the loss of all hydraulic fluid and led to a wheels up landing.NTSB FTW01LA196Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Dumas, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW01LA173Accident · No injuriesLimited investigationFinal reportCurtis-Travel Air 4000 · Morrilton, ARthe pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's lack of experience in the accident airplane, and the rough/uneven runway.NTSB FTW01FA171Accident · 4 fatalField investigationFinal reportCessna 205 · De Queen, ARthe pilot's VFR flight into IMC, which resulted in spatial disorientation and a loss of aircraft control. A contributing factor to the accident was the pilot's lack of total instrument flight time.NTSB FTW01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Springdale, ARthe instructor's failure to refuel the airplane, which resulted in fuel exhaustion.NTSB FTW01LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newport, ARthe loss of control during takeoff initial climb as a result of encountering wake turbulence due to the pilot's failure to recognize the hazard and delay the takeoff.NTSB FTW01LA141Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvell, ARthe improper decision of the driver of the vehicle(ATV) to enter an active airstrip.NTSB FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.NTSB FTW01LA138Accident · No injuriesLimited investigationFinal reportCessna 172M · Hot Springs, ARthe student pilot's delayed go-around, which resulted in the airplane impacting trees during the aborted landing.NTSB FTW01LA137Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Oil Trough, ARthe pilot's failure to refuel the airplane which resulted in the loss of engine power due to fuel exhaustion. A contributory factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA136Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Powhatan, ARthe pilot's failure to maintain obstacle clearance while maneuvering after takeoff.NTSB FTW01LA114Accident · Serious injuriesLimited investigationFinal reportBoykin B J B8M · Clarksville, ARthe pilot's inadequate preflight inspection, which resulted in a loose control stick on takeoff, rendering the aircraft uncontrollable.NTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB FTW01LA097Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Roe, ARthe inadvertent stall by the pilot while maneuvering at low altitude. A contributory factor was the tailwind.NTSB FTW01FA095Accident · 2 fatalField investigationFinal reportCessna 190 · Lurton, ARthe pilot's continued VFR flight into IMC, which resulted in spatial disorientation and the ensuing loss of aircraft control while in cruise flight. Contributory factors were the haze and fog weather conditions.NTSB FTW01LA057Accident · Minor injuriesLimited investigationFinal reportBeech BE-58 · Brinkley, ARthe pilot's poor inflight planning and decision making which resulted in his executing a precautionary landing in a soft field. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB FTW01LA064Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARthe pilot's failure to maintain directional control during the forced landing on a gravel road. Contributing factors were the pilot's delay in using carburetor heat and the loose gravel.