NTSB investigations, 1971, 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
Latest 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\") = 1971
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") = 1971 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 FTW72DPG58Accident · No injuriesClosedCessna 150 · Heth, ARNTSB FTW72FPG57Accident · Serious injuriesClosedChampion 7GCBC · Parkin, ARNTSB FTW72FPG56Accident · Serious injuriesClosedCessna 150E · Hot Springs, ARNTSB FTW72DPG55Accident · No injuriesClosedCessna 177 · Carlisle, ARNTSB FTW72FPG54Accident · No injuriesClosedCessna 150 · Jacksonville, ARNTSB FTW72FPG53Accident · No injuriesClosedBeech 95-B55 · De Queen, ARNTSB FTW72FPG52Accident · No injuriesClosedLuscombe 8F · Marion, ARNTSB FTW72FPG48Accident · No injuriesClosedTaylorcraft BC1265 · Benton, ARNTSB FTW72FPG49Accident · No injuriesClosedMitsubishi MU-2B · Van Buren, ARNTSB FTW72DPG47Accident · No injuriesClosedPiper PA-25 · Joiner, ARNTSB FTW72DPG46Accident · No injuriesClosedCessna 172B · Banks, ARNTSB FTW72FPG50Accident · No injuriesClosedHarvard MK IV · West Memphis, ARNTSB FTW72DPG45Accident · Minor injuriesClosedGrumman G-164 · Trumann, ARNTSB FTW72FPG44Accident · No injuriesClosedCessna 172 · El Dorado, ARNTSB FTW72DPG43Accident · No injuriesClosedPiper PA-25 · Osceola, ARNTSB FTW72AF016Accident · 2 fatalClosedPiper J3C-65 · Springdale, ARNTSB FTW72FPG42Accident · 1 fatalClosedPiper PA-25 · Mccrory, ARNTSB FTW72DPG39Accident · No injuriesClosedPiper PA-16 · De Queen, ARNTSB FTW72DPG36Accident · No injuriesClosedCessna 188 · Van Buren, ARNTSB FTW72DPG38Accident · No injuriesClosedSchweizer SGS233 · Abbott, ARNTSB FTW72DPG37Accident · Minor injuriesClosedCessna 150G · Abbott, ARNTSB FTW72FPG41Accident · No injuriesClosedBoeing E75N1 · Aubrey, ARNTSB FTW72FPG40Accident · No injuriesClosedBoeing E75N1 · Aubrey, ARNTSB FTW72FPG51Accident · Minor injuriesClosedPiper PA-25 · Stephens, ARNTSB FTW72DPG34Accident · No injuriesClosedPiper PA-25 · Tyronza, ARNTSB FTW72FRJ06Accident · No injuriesClosedLake LA-4 · Texarkana, ARNTSB FTW72DPG31Accident · No injuriesClosedLuscombe 8A · Humnoke, ARNTSB FTW72FPG32Accident · Serious injuriesClosedPiper PA-18A · W.Helena, ARNTSB FTW72DPG33Accident · No injuriesClosedCessna 188 · Marvell, ARNTSB FTW72DPG30Accident · No injuriesClosedGrumman G-164 · Moro, ARNTSB FTW72DPG28Accident · Minor injuriesClosedBoeing D75N1 · Joiner, ARNTSB FTW72FPG27Accident · 1 fatalClosedAero Comdr A-9B · Mccrory, ARNTSB FTW72DPG23Accident · No injuriesClosedSnow 600S2D · Parkin, ARNTSB FTW72DPG26Accident · No injuriesClosedGrumman G-164 · Truman, ARNTSB FTW72DPG25Accident · No injuriesClosedPiper PA-18 · West Memphis, ARNTSB FTW72DPG22Accident · No injuriesClosedPiper PA-25 · Holly Grove, ARNTSB FTW72FPG21Accident · No injuriesClosedPiper PA-18 · West Helena, ARNTSB FTW72FPG18Accident · No injuriesClosedCessna 195 · Jonesboro, ARNTSB FTW72DPG24Accident · No injuriesClosedGrumman G-164A · Tubbell, ARNTSB FTW72FPG19Accident · No injuriesClosedCessna 140 · N Little Rock, ARNTSB FTW72DPG17Accident · No injuriesClosedBoeing E75 · Dumas, ARNTSB FTW72FPG15Accident · 1 fatalClosedBoeing E75 · Dumas, ARNTSB FTW72FPG16Accident · No injuriesClosedGrumman G-164 · Keo, ARNTSB FTW72DPG14Accident · No injuriesClosedPiper PA-25 · Heth, ARNTSB FTW72FPG12Accident · 1 fatalClosedPiper PA-25 · Star City, ARNTSB FTW72FPG11Accident · Minor injuriesClosedCessna 150F · Nashville, ARNTSB FTW72FPG10Accident · No injuriesClosedCessna 182N · Mt Ida, ARNTSB FTW72FPG05Accident · No injuriesClosedPiper PA-25 · Beech Grove, ARNTSB FTW72DPG03Accident · Serious injuriesClosedPiper PA-25 · Lake Village, ARNTSB FTW72DPG04Accident · Minor injuriesClosedPitts Spcl S1C · West Helena, AR