NTSB investigations, 2004, 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\") = 2004
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") = 2004 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 DFW05LA030Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 20 · Pine Bluff, ARThe pilot's misjudgment of speed/distance which resulted in a runway overrun. Contributing factors were the moderate rain and the reported encounter with hydroplaning conditions.NTSB DFW05CA024Accident · No injuriesData collectionFinal reportMcCulloch J2 · Camden, ARThe separation of the engine exhaust stack for undetermined reasons.NTSB DEN05FA012Accident · 2 fatalField investigationFinal reportBeech F35 · Chester, ARthe pilot's inadequate planning/decision which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were the pilot's failure to follow the briefing recommendation, fog, mist, and observation.NTSB FTW04LA220Accident · Minor injuriesLimited investigationFinal reportBell 212 · Umpire, ARThe pilot's encounter with settling with power resulting in a loss of control. A contributing factor was the high density altitude.NTSB FTW04LA214Accident · No injuriesLimited investigationFinal reportCessna T188C · Heth, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04CA185Accident · Serious injuriesData collectionFinal reportGrumman G-164 · Havana, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight.NTSB FTW04CA184Accident · No injuriesData collectionFinal reportGrumman G-164C · Tiller, ARThe pilot's inability to maintain control of the airplane while landing due to a brake system failure.NTSB FTW04LA183Accident · 1 fatalLimited investigationFinal reportBeech C23 · Morrilton, ARThe pilot's inadequate preflight planning/preparation to assure adequate takeoff performance to clear obstacles.NTSB DEN04FA104Accident · 2 fatalField investigationFinal reportCessna 172I · Paris, ARthe pilot's inadequate preflight preparation, his attempted flight into adverse weather conditions, and his failure to maintain clearance from the trees resulting in the airplane's collision with the trees and subsequent impact with the ground. Factors…NTSB FTW04LA180Accident · No injuriesLimited investigationFinal reportCessna 150M · Sherrill, ARthe pilot's inadequate in-flight planning/decision which resulted in the loss of engine power due to fuel exhaustion.NTSB FTW04CA181Accident · No injuriesData collectionFinal reportCessna 180E · Weiner, ARThe pilot's poor preflight preparation/planning which resulted in the pilot landing at a wrong airport. A contributing factor was the lack of suitable terrain for the off airport landing.NTSB FTW04FA172Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hot Springs, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with mountainous terrain. Factors were the clouds and the air traffic controllers' failure to provide known information that may have assisted the…NTSB FTW04LA156Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Joiner, ARThe pilot's failure to maintain clearance and altitude from terrain while maneuvering during an aerial application.NTSB FTW04LA153Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402 · Tucker, ARThe pilot's failure to maintain control while manuevering during aerial application which resulted in impact with terrain.NTSB FTW04LA152Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Dumas, ARThe loss of engine power for undetermined reasons.NTSB FTW04LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Benton, ARThe student pilot's failure to maintain airspeed resulting in an inadvertent stall during a go-around.NTSB FTW04LA150Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA151Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Weldon, ARThe other pilot's failure to maintain an adequate visual lookout during approach to landing, which resulted in a midair collision between the two airplanes.NTSB FTW04LA155Accident · No injuriesLimited investigationFinal reportSchreder HP-11A · Cherry Valley, ARThe pilot's improper flare which resulted in a stall and hard landing.NTSB FTW04CA139Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Beedeville, ARThe pilot's failure to maintain directional control of the airplane during landing roll-out. Contributing factors were the crosswind and condition of the the runway.NTSB FTW04LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Brookland, ARThe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB FTW04LA127Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Brinkley, ARThe pilots failure to attain flying airspeed after takeoff. A factor was the overloading of agricultural chemicals that exceeded the airplane's maximum takeoff weight.NTSB FTW04LA116Accident · No injuriesLimited investigationFinal reportCessna 150 · Magnolia, ARThe pilot's improper pre-flight planning, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA103Accident · Serious injuriesLimited investigationFinal reportPdps PZL-Bielsko SZD-50-3 · Cherry Valley, ARThe pilot's failure to maintain airspeed during the landing which resulted in an inadvertent stall.NTSB FTW04LA090Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Springdale, ARThe failure of the right main landing gear actuator clevis bolt for undetermined reasons.NTSB FTW04FA083Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Wrightsville, ARThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin on the downwind leg of the traffic pattern.NTSB FTW04LA080Accident · 1 fatalLimited investigationFinal reportGrumman G-164C · Hazen, ARThe pilot's loss of control while maneuvering during an aerial application flight for undetermined reasons.NTSB FTW04LA071Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Mena, ARThe loss of engine power for undetermined reasons and the pilot's misjudgment of altitude and distance during the forced landing which resulted in a collision with trees and transmission wires.NTSB FTW04LA065Accident · No injuriesLimited investigationFinal reportCessna 120 · Lonoke, ARThe loss of engine power for undetermined reasons. A contributing factor was the dusk lighting conditions and unlit airfield.NTSB FTW04FA057Accident · 1 fatalField investigationFinal reportCessna 182RG · El Dorado, ARThe loss of engine power as a result of loss of engine oil due to the failure of the oil filter converter plate gasket and the noncompliance to an airworthiness directive. Contributing factors were the lack of suitable terrain for the forced landing and the…NTSB FTW04LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20R · Sheridan, ARThe loss of engine power due to fuel starvation as a result of the pilot's improper positioning of the fuel tank selector. A factor was the lack of suitable terrain for the forced landing.