NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 FTW67D0378Accident · No injuriesClosedCessna 170B · Texarkana, ARNTSB FTW67A0062Accident · 2 fatalClosedCessna 172 · Franklin, ARNTSB FTW67A0061Accident · 1 fatalClosedBeech K35 · Dover, ARNTSB FTW67F0339Accident · Minor injuriesClosedPiper J3C-65 · Stuttgart, ARNTSB FTW67F0316Accident · No injuriesClosedCessna 210 · Little Rock, ARNTSB FTW67F0313Accident · Serious injuriesClosedBeech 95 · Little Rock, ARNTSB FTW67D0308Accident · No injuriesClosedBeech S35 · Little Rock, ARNTSB FTW67D0279Accident · No injuriesClosedAlon A-2 · Corning, ARNTSB FTW67D0262Accident · No injuriesClosedCessna 150 · Rogers, ARNTSB FTW67F0245Accident · Serious injuriesClosedPiper PA-25 · Eudora, ARNTSB FTW67D0244Accident · No injuriesClosedGrumman G-164 · Leavchville, ARNTSB FTW67D0238Accident · No injuriesClosedCessna 140A · Mc Gehee, ARNTSB FTW67D0237Accident · No injuriesClosedCessna 172 · Berryville, ARNTSB FTW67D0220Accident · No injuriesClosedBeech 23 · Augusta, ARNTSB FTW67D0202Accident · No injuriesClosedChampion 7GCB · Black Oak, ARNTSB FTW67F0214Accident · Minor injuriesClosedGrumman G-164 · Tupelo, ARNTSB FTW67F0213Accident · No injuriesClosedAeronca 7AC · Gurdon, ARNTSB FTW67F0197Accident · No injuriesClosedPiper PA-28 · Hot Springs, ARNTSB FTW67F0191Accident · No injuriesClosedCessna 140 · Brinkley, ARNTSB FTW67D0207Accident · No injuriesClosedBeech G35 · El Dorado, ARNTSB FTW67F0233Accident · No injuriesClosedSnow 600S2C · Bay, ARNTSB FTW67F0189Accident · No injuriesClosedRepublic RC-3 · Benton, ARNTSB FTW67F0133Accident · No injuriesClosedPiper PA-28 · Pine Bluff, ARNTSB FTW67F0231Accident · Serious injuriesClosedPiper PA-25 · Parkin, ARNTSB FTW67D0141Accident · No injuriesClosedBeech J35 · Willisville, ARNTSB FTW67F0170Accident · Serious injuriesClosedCessna T50 · Pocahontas, ARNTSB FTW67F0152Accident · No injuriesClosedPiper PA-25 · Success, ARNTSB FTW67D0130Accident · No injuriesClosedCessna 172 · Bull Shoals, ARNTSB FTW6MD0120Accident · No injuriesClosedMooney M20C · Midway, ARNTSB FTW67F0121Accident · No injuriesClosedBoeing A75 · Brinkley, ARNTSB FTW67A0019Accident · Serious injuriesClosedHughes 269A · Brookland, ARNTSB FTW67A0017Accident · Serious injuriesClosedBell 47D1 · Stuttgart, ARNTSB FTW67F0167Accident · Serious injuriesClosedCessna 140 · Jonesboro, ARNTSB FTW67F0128Accident · Minor injuriesClosedPiper PA-28 · Berryville, ARNTSB FTW67F0112Accident · No injuriesClosedBeech A23 · Lead Hill, ARNTSB FTW67A0016Accident · 1 fatalClosedBoeing A75N1 · Hazen, ARNTSB FTW67D0105Accident · No injuriesClosedPiper PA-24 · Keo, ARNTSB FTW67F0077Accident · No injuriesClosedPiper PA-23 · Stuttgart, ARNTSB FTW67D0073Accident · No injuriesClosedCessna 182 · Flippin, ARNTSB FTW67D0071Accident · No injuriesClosedBeech 65 · Hope, ARNTSB FTW67A0010Accident · No injuriesClosedHughes 269A · Little Rock, ARNTSB FTW67F0092Accident · No injuriesClosedBoeing A75 · Swan Lake, ARNTSB FTW67D0065Accident · No injuriesClosedPiper PA18 · Stuttgart, ARNTSB FTW67A0004Accident · 1 fatalClosedPiper J-3 · Stuttgart, ARNTSB FTW67D0051Accident · No injuriesClosedPiper PA30 · Springdale, ARNTSB FTW67A0001Accident · No injuriesClosedHughes 269B · Little Rock, ARNTSB FTW66A0121Accident · No injuriesClosedPiper PA-25 · Garland, ARNTSB FTW66A0120Accident · Serious injuriesClosedConvair 600 · Hot Spring, ARNTSB FTW66I0118Incident · No injuriesClosedDouglas DC-3 · El Dorado, ARNTSB FTW67D0015Accident · No injuriesClosedCessna 172 · Colt, AR