NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 FTW66D0437Accident · No injuriesClosedCessna 150 · Fayetteville, ARNTSB FTW66F0484Accident · No injuriesClosedBeechcraft 65 · Tuckerman, ARNTSB FTW66D0462Accident · No injuriesClosedCessna 170B · Magnolia, ARNTSB FTW66F0431Accident · Minor injuriesClosedTaylorcraft DCO-65 · Gurdon, ARNTSB FTW66F0480Accident · No injuriesClosedCessna 182 · Hot Springs, ARNTSB UNK66X0110Accident · 2 fatalClosedPiper PA-22 · Ogeman, ARNTSB FTW66A0049Accident · 2 fatalClosedPiper PA-28 · West Fork, ARNTSB FTW66D0424Accident · No injuriesClosedPiper PA-22 · Waldo, ARNTSB FTW66A0047Accident · 1 fatalClosedCessna 150F · Holly Grove, ARNTSB FTW66F0470Accident · No injuriesClosedBeechcraft K35 · Camden, ARNTSB FTW66D0375Accident · No injuriesClosedPiper PA-23 · Siloam Sps, ARNTSB FTW66F0372Accident · No injuriesClosedMooney M20E · Newport, ARNTSB FTW66D0371Accident · No injuriesClosedPiper PA-28 · Cotton Plant, ARNTSB FTW66F0415Accident · No injuriesClosedCessna 195 · Hot Springs, ARNTSB FTW66F0469Accident · No injuriesClosedPiper PA-30 · Nashville, ARNTSB FTW66D0364Accident · No injuriesClosedBoeing PT-13 · Tucker, ARNTSB FTW66F0321Accident · No injuriesClosedPiper PA-25 · Walnut Ridge, ARNTSB FTW66D0281Accident · No injuriesClosedPiper PA-18A · England, ARNTSB FTW66F0279Accident · Minor injuriesClosedBoeing IB75A · Dumas, ARNTSB FTW66F0478Accident · No injuriesClosedGrumman G-164 · Portland, ARNTSB FTW66D0319Accident · No injuriesClosedBriegleb BG8-K2 · Manila, ARNTSB FTW66F0303Accident · No injuriesClosedCessna 150 · Mena, ARNTSB FTW66D0305Accident · No injuriesClosedPiper PA-28 · Swan Lake, ARNTSB FTW66F0273Accident · No injuriesClosedBoeing A75N1 · Dumas, ARNTSB FTW66F0250Accident · No injuriesClosedPiper PA-25 · Bradford, ARNTSB FTW66F0248Accident · No injuriesClosedPiper PA-22 · Spring Hill, ARNTSB FTW66F0468Accident · No injuriesClosedGrumman G-164 · Gould, ARNTSB FTW66F0477Accident · No injuriesClosedGrumman G-164 · Helena, ARNTSB FTW66I0019Incident · No injuriesClosedBoeing B-727 · Little Rock, ARNTSB FTW66F0199Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARNTSB FTW66D0223Accident · No injuriesClosedPiper PA-25 · Parkin, ARNTSB FTW66A0017Accident · No injuriesClosedHughes 300AG · Briscoe, ARNTSB FTW66F0222Accident · Serious injuriesClosedPiper PA-25 · Jerome, ARNTSB FTW66F0197Accident · Serious injuriesClosedPiper PA-18 · Keo, ARNTSB FTW66A0014Accident · 1 fatalClosedPiper PA-24 · Mcalmont, ARNTSB FTW66F0191Accident · No injuriesClosedCessna 150 · West Helena, ARNTSB FTW66F0262Accident · Minor injuriesClosedCessna 140 · Texarkana, ARNTSB FTW66F0218Accident · Minor injuriesClosedPiper PA-25 · Boydell, ARNTSB FTW66F0169Accident · Minor injuriesClosedPiper PA-22 · Springdale, ARNTSB FTW66A0009Accident · 3 fatalClosedBeechcraft G35 · Morrow, ARNTSB FTW66F0212Accident · No injuriesClosedPiper PA-23 · Mena, ARNTSB FTW66D0177Accident · No injuriesClosedGruman G-164 · Hunter, ARNTSB FTW66A0002Accident · 1 fatalClosedPiper J-3 · No.Little Rck, ARNTSB FTW66A0001Accident · No injuriesClosedBoeing 707 123B · Texarkana, ARNTSB FTW66D0123Accident · No injuriesClosedMooney M21 · Gould, ARNTSB FTW66D0104Accident · No injuriesClosedPiper PA-23 · Herber Springs, ARNTSB FTW66F0476Accident · No injuriesClosedCessna TL-19D · Almyra, ARNTSB FTW66F0098Accident · No injuriesClosedMooney M20C · Hope, ARNTSB FTW66F0096Accident · No injuriesClosedMooney M20D · West Fordyce, ARNTSB FTW65A0122Accident · 1 fatalClosedPiper PA-18A · Gillett, AR