NTSB investigations, 1972, 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\") = 1972
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") = 1972 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 FTW73IF028Incident · Minor injuriesClosedBoeing 707 · Little Rock, ARNTSB FTW73DPG33Accident · No injuriesClosedCessna 120 · Beebe, ARNTSB FTW73FPG32Accident · Serious injuriesClosedAero Comdr A-9B · Gould, ARNTSB FTW73FPG30Accident · Serious injuriesClosedBantam Burton · El Dorado, ARNTSB FTW73FPG31Accident · Serious injuriesClosedBoeing A75 · Moro, ARNTSB FTW73DPG29Accident · No injuriesClosedCessna 120 · Corning, ARNTSB FTW73DPG27Accident · No injuriesClosedPiper PA-28 · Judsonia, ARNTSB FTW73FRJ19Accident · No injuriesClosedPiper J4A · Texarkana, ARNTSB FTW73FPG28Accident · 1 fatalClosedSnow S2A · Chatfield, ARNTSB FTW73FPG26Accident · Minor injuriesClosedCessna 172 · N.Little Rock, ARNTSB FTW73DPG25Accident · No injuriesClosedCessna 337B · Lonoke, ARNTSB FTW74DPG24Accident · No injuriesClosedCallair A-9 · Rudy, ARNTSB FTW73AF010Accident · 1 fatalClosedMooney M20A · Peach Orchard, ARNTSB FTW73DPG34Accident · No injuriesClosedBell 47D · Plumerville, ARNTSB FTW73FPG23Accident · No injuriesClosedCessna 188 · Scott, ARNTSB FTW73DPG21Accident · Minor injuriesClosedCessna 172 · Ashdown, ARNTSB FTW73DPG20Accident · No injuriesClosedCessna 120 · Lakeview, ARNTSB FTW73FRJ17Accident · 1 fatalClosedAero Comdr A-9 · Garland City, ARNTSB FTW73FPG22Accident · No injuriesClosedCessna 188B · Marvell, ARNTSB FTW73FPG19Accident · Minor injuriesClosedBoeing E75 · Elaine, ARNTSB FTW73FRJ18Accident · No injuriesClosedCessna 182E · Texarkana, ARNTSB FTW73FPG18Accident · No injuriesClosedCessna 182E · Pocahontas, ARNTSB FTW73DRJ12Accident · No injuriesClosedCessna 150F · Texarkana, ARNTSB FTW73DPG17Accident · No injuriesClosedAmer Avco AA1-A · Caraway, ARNTSB FTW73FPG15Accident · No injuriesClosedCessna 188 · Elaine, ARNTSB FTW73DPG16Accident · No injuriesClosedBoeing 75 · St Charles, ARNTSB FTW73FPG14Accident · Minor injuriesClosedCessna 182F · Scranton, ARNTSB FTW73FPG13Accident · No injuriesClosedPiper PA-20 · Booneville, ARNTSB FTW73FPG12Accident · No injuriesClosedGrumman G-164 · Wynne, ARNTSB FTW73FPG11Accident · No injuriesClosedAero Comdr A-9A · Boydell, ARNTSB FTW73FPG10Accident · No injuriesClosedPiper J-5 · Van, ARNTSB FTW73DPG06Accident · No injuriesClosedGrumman G-164 · Weiner, ARNTSB FTW73FPG08Accident · Serious injuriesClosedStearman E75N1 · Pollard, ARNTSB FTW73FPG07Accident · No injuriesClosedGrumman G-164A · Coy, ARNTSB FTW73DPG05Accident · No injuriesClosedPiper PA-25 · Eudora, ARNTSB FTW73FPG09Accident · Minor injuriesClosedPiper PA-22 · Arkansas City, ARNTSB FTW73DPG03Accident · No injuriesClosedGrumman G-164A · Hazen, ARNTSB FTW73DPG04Accident · No injuriesClosedSnow S2A · Almyra, ARNTSB FTW73DPG02Accident · No injuriesClosedLuscombe 8E · Monticello, ARNTSB FTW73DPG01Accident · No injuriesClosedGrumman G-164 · Mayflower, ARNTSB FTW72FPG87Accident · No injuriesClosedSnow S2A · Almyra, ARNTSB FTW72FPG88Accident · No injuriesClosedBoeing A75 · De Witt, ARNTSB FTW72FPG86Accident · 1 fatalClosedCessna A188 · Jerome, ARNTSB FTW72FPG84Accident · 2 fatalClosedGrumman G-164A · Crawfordsvlle, ARNTSB FTW72FPG85Accident · No injuriesClosedGrumman G-164A · Jerome, ARNTSB FTW72FPG83Accident · Minor injuriesClosedCessna A188A · Hickory Ridge, ARNTSB FTW72AF082Accident · 2 fatalClosedCessna 210E · Monticello, ARNTSB FTW72FPG82Accident · Minor injuriesClosedCessna 182 · Guion, ARNTSB FTW72FPG81Accident · Serious injuriesClosedCessna 150 · Guion, ARNTSB FTW72FPG79Accident · 1 fatalClosedBoeing A75N1 · Hazen, AR