NTSB investigations, 1981, 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
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\") = 1981
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") = 1981 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 FTW82FPG07Accident · No injuriesClosedCessna 177RG · Little Rock, ARNTSB FTW82FPG06Accident · 1 fatalClosedPiper J3C-65 · Star City, ARNTSB FTW81IA027Incident · No injuriesClosedBeech A36 · Fayetteville, ARNTSB FTW82FPG05Accident · No injuriesClosedPiper PA-60 · El Dorado, ARNTSB FTW82DPG04Accident · No injuriesClosedCessna 182G · Hughes, ARNTSB FTW82DPG02Accident · Serious injuriesClosedCessna 177B · Crossett, ARNTSB FTW82KPG01Accident · 1 fatalClosedPitts S-1 · Jonesboro, ARNTSB FTW81DPG70Accident · No injuriesClosedAir Tractor AT-301 · Lonoke, ARNTSB FTW82FPG69Accident · Minor injuriesClosedCessna 150F · England, ARNTSB FTW81FPG65Accident · Serious injuriesClosedVans RV3 · Little Rock, ARNTSB FTW81DPG66Accident · No injuriesClosedPiper PA-23 · Jonesboro, ARNTSB FTW81DPG67Accident · No injuriesClosedAyres S2-R · Harrisburg, ARNTSB FTW81DPG64Accident · No injuriesClosedCessna A188B · Gin City, ARNTSB FTW81FPG63Accident · No injuriesClosedBeech C24R · Searcy, ARNTSB FTW81DPG62Accident · No injuriesClosedPiper PA-38 · Grubbs, ARNTSB FTW81FPG60Accident · 1 fatalClosedPiper J3C-65 · Almyra, ARNTSB FTW81FPG61Accident · No injuriesClosedPiper PA-23 · Malvern, ARNTSB FTW81DPG59Accident · No injuriesClosedAero Comdr S2R · Swifton, ARNTSB FTW81DPG58Accident · No injuriesClosedGrumman G-164A · Piggott, ARNTSB FTW81FPG56Accident · No injuriesClosedCessna 421C · Little Rock, ARNTSB FTW81DPG57Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARNTSB FTW81FA127Accident · 2 fatalClosedBellanca 8KCAB · Alma, ARNTSB FTW81FA123Accident · 2 fatalClosedLuscombe 8A · N Little Rock, ARNTSB FTW81DPG55Accident · Minor injuriesClosedGrumman G-164B · Bono, ARNTSB FTW81DPG52Accident · No injuriesClosedCessna 188 · Gould, ARNTSB FTW81DPG53Accident · No injuriesClosedCessna 188B · Beech Grove, ARNTSB FTW81FPG54Accident · No injuriesClosedPiper PA-32 · Little Rock, ARNTSB FTW81DPG51Accident · No injuriesClosedGrumman G-164 · Cash, ARNTSB FTW81DPG49Accident · No injuriesClosedRockwell S2R · Bono, ARNTSB FTW81FPG50Accident · No injuriesClosedHiller Acft UH-12E · Warren, ARNTSB FTW81FA110Accident · 4 fatalClosedPiper PA-22 · Busch, ARNTSB FTW81DPG48Accident · No injuriesClosedCessna 188 · Lake Village, ARNTSB FTW81DPG47Accident · No injuriesClosedRockwell S2R · Dumas, ARNTSB FTW81FPG45Accident · 1 fatalClosedGrumman G-164A · Lonoke, ARNTSB FTW81DPG46Accident · No injuriesClosedGrumman G-164 · Holly Grove, ARNTSB FTW81DPG44Accident · No injuriesClosedCessna 182RG · Springdale, ARNTSB FTW81DPG43Accident · Serious injuriesClosedJunior Ace 6E · Salem, ARNTSB FTW81DPG42Accident · No injuriesClosedGrumman G-164A · Wilson, ARNTSB FTW81FPG40Accident · No injuriesClosedGrumman G-164B · Wynne, ARNTSB FTW81DPG41Accident · No injuriesClosedCessna 172RG · Grady, ARNTSB FTW81DPG38Accident · No injuriesClosedGrumman G-164 · Manila, ARNTSB FTW81FPG39Accident · No injuriesClosedPiper PA-24 · Stuttgart, ARNTSB FTW81DPG36Accident · No injuriesClosedGrumman G-164 · Hughes, ARNTSB FTW81DPG30Accident · No injuriesClosedGrumman G-164A · Hughes, ARNTSB FTW81FPG35Accident · 1 fatalClosedAyers S2R · West Bay, ARNTSB FTW81DPG34Accident · No injuriesClosedGrumman G-164B · Griffithville, ARNTSB FTW81DPG29Accident · No injuriesClosedAyers S2R · Stuttgart, ARNTSB FTW81DPG33Accident · Serious injuriesClosedAir Tractor AT-300 · Foreman, ARNTSB FTW81DPG37Accident · No injuriesClosedGrumman G-164B · Corning, ARNTSB FTW81DPG28Accident · No injuriesClosedGrumman G-164B · Lexa, AR