NTSB investigations, 2012, 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\") = 2012
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") = 2012 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 CEN13LA095Accident · No injuriesLimited investigationFinal reportMooney M20E · Gurdon, ARThe total loss of engine power for reasons that could not be determined because no mechanical engine malfunctions were identified and because the actual fuel load and distribution at the time of the accident could not be determined.NTSB CEN13CA084Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Melbourne, ARThe pilot's failure to maintain directional control of the airplane during the landing.NTSB CEN13LA054Accident · 1 fatalLimited investigationFinal reportCessna P210N · Conway, ARThe pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…NTSB CEN13CA021Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 Special · Lonoke, ARThe pilot's failure to maintain directional control during the landing.NTSB CEN12LA495Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lakeview, ARThe pilot’s loss of control during the takeoff roll for reasons that could not be determined because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA476Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Conway, ARThe pilot's improper landing flare, which resulted in a hard landing and overstress failure of the right main landing gear.NTSB CEN12CA486Accident · No injuriesData collectionFinal reportMooney M20M · Heber Springs, ARThe pilot's improper flare, which led to a bounced landing and a subsequent loss of control.NTSB CEN12FA463Accident · Minor injuriesField investigationFinal reportMooney M20E · Marked Tree, ARThe loss of engine power during cruise flight due to a malfunction of the fuel injection servo due to a damaged O-ring.NTSB CEN12CA447Accident · No injuriesData collectionFinal reportCessna 177B · Lakeview, ARThe pilot's delay in aborting the takeoff, which resulted in a runway excursion.NTSB CEN12CA422Accident · No injuriesData collectionFinal reportCessna 172K · Greers Ferry, ARThe pilot’s failure to maintain a positive rate of climb while taking off with a high density altitude.NTSB CEN12LA386Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Walnut Ridge, ARThe pilot's failure to maintain aircraft control after encountering a whirlwind or dust-devil during the landing flare.NTSB CEN12LA379Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeview, ARThe pilot's improper flare and recovery from a bounced landing.NTSB CEN12LA352Accident · No injuriesLimited investigationFinal reportGrumman G164 · Higginson, ARThe partial loss of engine power for reasons that could not be determined due to impact and fire damage.NTSB CEN12LA331Accident · Minor injuriesLimited investigationFinal reportBaldwin Skybolt · Stuttgart, ARThe pilot's inadequate preflight planning, which resulted in the airplane’s overweight takeoff from an airstrip with a high density altitude and subsequent collision with terrain.NTSB CEN12LA326Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Ozark, ARThe failure of a connecting rod due to oil starvation.NTSB CEN12LA323Accident · No injuriesLimited investigationFinal reportThrush S2RHG-T65 · Alicia, ARThe pilot of the Thrush did not execute a go-around prior to landing, which resulted in excessive ground speed after touchdown, and his subsequent loss of directional control, which resulted in a collision with the Air Tractor.NTSB CEN12FA312Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Sedgwick, ARThe inability of both pilots to see and avoid the other airplane, which resulted in a midair collision. Contributing to the accident was the distraction of the Air Tractor pilot by a cellular telephone conversation during the flight.NTSB CEN12LA310Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Humnoke, ARThe pilot’s failure to attain the proper touchdown point, which resulted in a landing undershoot.NTSB CEN12LA306Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Marion, ARThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA259Accident · No injuriesLimited investigationFinal reportMoody-Siple A · Stuttgart, ARThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12CA205Accident · Minor injuriesData collectionFinal reportFurru Donald Jeffrey Skyranger V MAX · Viola, ARThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB CEN12CA225Accident · No injuriesData collectionFinal reportBeech V35B · Malvern, ARThe pilot did not fly a stabilized approach and elected not to perform a go-around, which resulted in a runway excursion.NTSB CEN12LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Sheridan, ARThe passenger’s interference with the flight controls during the initial climb, which resulted in a loss of control and impact with terrain.