NTSB investigations, 2019, 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\") = 2019
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") = 2019 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 GAA20CA064Accident · Minor injuriesData collectionFinal reportNew Glasair Sportsman GS-2 · Huntsville, ARThe pilot's failure to maintain proper pitch control during takeoff from a muddy, turf runway and his exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.NTSB CEN19FA332Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Prairie Grove, ARThe noninstrument-rated pilot's loss of control due to spatial disorientation after encountering instrument meteorological conditions at night.NTSB CEN19FA248Accident · 1 fatalClass 3 · FieldFinal reportCessna 310 · De Queen, ARA loss of control for reasons that could not be determined based on the available information.NTSB CEN19LA222Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Clinton, ARA partial loss of engine power for undetermined reasons.NTSB CEN19LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Fort Smith, ARA total loss of engine power due to fuel starvation as a result of the flight instructor's fuel mismanagement.NTSB GAA19CA319Accident · No injuriesData collectionFinal reportPiper PA24 · Weiner, ARThe pilot's failure to maintain directional control during the landing roll on a wet runway, which resulted in a runway overrun and collision with a pole.NTSB CEN19FA160Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Cass, ARA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA304Accident · No injuriesData collectionFinal reportPiper PA32R · Flippin, ARThe airplane’s collision with deer during the landing and the airport’s failure to provide an adequate barrier to prevent wildlife from entering the runway environment despite previous deer strikes.NTSB GAA19CA289Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Fisher, ARThe pilot's failure to maintain directional control during takeoff in gusting wind conditions, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA271Accident · No injuriesData collectionFinal reportAyres S 2R · Stuttgart, ARThe pilot's exceedance of the airplane's critical angle of attack while maneuvering during an agricultural application flight, which resulted in an aerodynamic stall.NTSB CEN19LA146Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S76 · Morrilton, ARThe improper securing of the exhaust duct bolts, which resulted in the duct becoming unseated and substantial heat damage to the tail rotor drive shaft.NTSB GAA19CA259Accident · No injuriesData collectionFinal reportCessna 182 · Crossett, ARThe pilot's failure to maintain the runway centerline and his subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose-over.NTSB CEN19LA116Accident · No injuriesClass 3 · LimitedFinal reportBerkey S-6ES · Lafe, ARThe non-certificated pilot's failure to maintain an appropriate glidepath while landing toward the sun, which resulted in impact with vegetation and a subsequent loss of control.NTSB GAA19CA177Accident · Minor injuriesData collectionFinal reportChampion 7EC · Fayetteville, ARThe pilot's exceedance of the airplane's critical angle of attack during takeoff as he attempted to avoid power lines, which resulted in an aerodynamic stall.