NTSB investigations, 1967, AR
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1967
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") = 1967 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 FTW68A0067Accident · Minor injuriesClosedAero Cmdr 500-B · Mena, ARNTSB FTW68D0403Accident · No injuriesClosedPiper PA-28 · Jonesboro, ARNTSB FTW68F0404Accident · No injuriesClosedCessna 210E · Searcy, ARNTSB FTW68F0386Accident · No injuriesClosedPiper PA-23 · Little Rock, ARNTSB FTW68D0406Accident · No injuriesClosedCessna 172 · Springdale, ARNTSB FTW68D0398Accident · No injuriesClosedBeech A23 · Conway, ARNTSB FTW68A0060Accident · Serious injuriesClosedHughes 300 · Fayetteville, ARNTSB FTW68A0059Accident · 1 fatalClosedPiper PA-24 · Black Oak, ARNTSB FTW68F0432Accident · No injuriesClosedPiper PA-24 · Hindsville, ARNTSB FTW68D0390Accident · No injuriesClosedNavion A · Little Rock, ARNTSB FTW68F0371Accident · No injuriesClosedMooney M20D · Fayetteville, ARNTSB FTW68D0365Accident · No injuriesClosedBeech 35 · Booneville, ARNTSB FTW68D0335Accident · No injuriesClosedCessna 180 · Pine Bluff, ARNTSB FTW69A0004Accident · 1 fatalClosedBeech 35-B33 · Mount Ida, ARNTSB FTW68A0043Accident · 4 fatalClosedBeech N35 · Camden, ARNTSB FTW68F0293Accident · No injuriesClosedBeech 35-C33 · Fayetteville, ARNTSB FTW68D0267Accident · No injuriesClosedPiper PA-22 · Manila, ARNTSB FTW68D0266Accident · No injuriesClosedBeech A23 · Pine Bluff, ARNTSB FTW68F0264Accident · Minor injuriesClosedAeronca 11AC · Benton, ARNTSB FTW68F0262Accident · Minor injuriesClosedBeech E18S · Walnut Ridge, ARNTSB FTW68F0226Accident · Serious injuriesClosedSnow S2C · Harrisburg, ARNTSB FTW68A0032Accident · No injuriesClosedBell 47D1 · Russellville, ARNTSB FTW68F0260Accident · No injuriesClosedCallair A9 · Howell, ARNTSB FTW68F0290Accident · Serious injuriesClosedPietenpol Scout · Van Buren, ARNTSB FTW68F0235Accident · Minor injuriesClosedBoeing E75N1 · Marvell, ARNTSB FTW68F0231Accident · No injuriesClosedCessna 150F · Tinsman, ARNTSB FTW68F0214Accident · Minor injuriesClosedBeech 35-B33 · West Memphis, ARNTSB FTW68F0256Accident · No injuriesClosedCallair A-9 · Mcgehee, ARNTSB FTW68D0210Accident · No injuriesClosedBeech 23 · West Memphis, ARNTSB FTW68D0175Accident · No injuriesClosedPiper PA-23 · Gurdon, ARNTSB FTW68F0174Accident · No injuriesClosedCessna 175 · Little Rock, ARNTSB FTW68D0155Accident · No injuriesClosedBoeing A75N1 · Dumas, ARNTSB FTW68D0207Accident · No injuriesClosedBeech H35 · West Memphis, ARNTSB FTW68D0170Accident · No injuriesClosedBeech V35 · Clarksville, ARNTSB FTW68F0205Accident · No injuriesClosedCessna 180A · Almyra, ARNTSB FTW68A0020Accident · 1 fatalClosedCallair A-9 · Knobel, ARNTSB FTW68D0167Accident · No injuriesClosedBeech B35 · Malvern, ARNTSB FTW68F0255Accident · No injuriesClosedGrumman G-164 · Eudora, ARNTSB FTW68F0164Accident · Minor injuriesClosedPiper PA-25 · Etowah, ARNTSB FTW68F0227Accident · No injuriesClosedGrumman G-164 · Cotton Plant, ARNTSB FTW68D0148Accident · No injuriesClosedBoeing E75 · Osceola, ARNTSB FTW68F0142Accident · No injuriesClosedCessna 150 · Walnut Ridge, ARNTSB FTW68D0099Accident · No injuriesClosedBeech 23 · Weiner, ARNTSB FTW68D0141Accident · No injuriesClosedPiper PA-18A · Lewisville, ARNTSB FTW68D0121Accident · No injuriesClosedGrumman G-164 · Hickory Ridge, ARNTSB FTW68F0097Accident · No injuriesClosedCessna 150 · Dumas, ARNTSB FTW68D0140Accident · Minor injuriesClosedCessna 170 · Waldron, ARNTSB FTW68A0007Accident · 1 fatalClosedPiper J-3C · Parkin, ARNTSB FTW68D0139Accident · Minor injuriesClosedBoeing A75 · Reydel, ARNTSB FTW68D0113Accident · No injuriesClosedBeech M35 · Blytheville, AR