NTSB investigations, 1964, OK
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 | 108 |
|---|---|
| 1965 | 105 |
| 1966 | 100 |
| 1967 | 134 |
| 1968 | 100 |
| 1969 | 99 |
| 1970 | 81 |
| 1971 | 102 |
| 1972 | 56 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 60 |
| 1976 | 66 |
| 1977 | 72 |
| 1978 | 63 |
| 1979 | 66 |
| 1980 | 64 |
| 1981 | 79 |
| 1982 | 63 |
| 1983 | 64 |
| 1984 | 65 |
| 1985 | 47 |
| 1986 | 42 |
| 1987 | 45 |
| 1988 | 38 |
| 1989 | 40 |
| 1990 | 29 |
| 1991 | 30 |
| 1992 | 36 |
| 1993 | 23 |
| 1994 | 32 |
| 1995 | 42 |
| 1996 | 35 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 36 |
| 2000 | 31 |
| 2001 | 24 |
| 2002 | 26 |
| 2003 | 22 |
| 2004 | 23 |
| 2005 | 25 |
| 2006 | 21 |
| 2007 | 28 |
| 2008 | 25 |
| 2009 | 23 |
| 2010 | 23 |
| 2011 | 19 |
| 2012 | 18 |
| 2013 | 23 |
| 2014 | 11 |
| 2015 | 17 |
| 2016 | 21 |
| 2017 | 20 |
| 2018 | 15 |
| 2019 | 15 |
| 2020 | 18 |
| 2021 | 17 |
| 2022 | 22 |
| 2023 | 23 |
| 2024 | 19 |
| 2025 | 19 |
| 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\") = 1964
AND c.\"eventStateOrRegion\" = 'OK' 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") = 1964 AND c."eventStateOrRegion" = 'OK' 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 UNK65X1203Accident · 2 fatalClosedPiper PA24 · Cushing, OKNTSB UNK65X1195Accident · No injuriesClosedPiper PA24 · El Reno, OKNTSB UNK65X1184Accident · No injuriesClosedTaylorcraft DCO · Vinita, OKNTSB UNK65X1159Accident · No injuriesClosedCessna 150 · Cushing, OKNTSB UNK65X1101Accident · No injuriesClosedBeech 35 · Broken Arrow, OKNTSB UNK65X1073Accident · No injuriesClosedPiper PA28 · Elmore City, OKNTSB UNK65X1039Accident · No injuriesClosedGlobe GC1B · Purcell, OKNTSB UNK65X0992Accident · 2 fatalClosedRyan ST3KR · Altus, OKNTSB UNK65X0962Accident · Serious injuriesClosedCessna 210 · Sayre, OKNTSB UNK65X0954Accident · No injuriesClosedErcoupe 415C · El Reno, OKNTSB UNK65X0917Accident · Minor injuriesClosedCessna 140A · Ardmore, OKNTSB UNK65X0885Accident · No injuriesClosedLuscombe 8A · Colony, OKNTSB UNK65X0880Accident · No injuriesClosedBoeing B-720 · Okla City, OKNTSB UNK65X0875Accident · No injuriesClosedCessna 182 · Broken Arrow, OKNTSB UNK65X0767Accident · No injuriesClosedBrantly B2 · Muskogee, OKNTSB UNK65X0744Accident · 1 fatalClosedCessna 140A · Tulsa, OKNTSB UNK65X0693Accident · No injuriesClosedBell 47G2A · Yukon, OKNTSB UNK65X0662Accident · 1 fatalClosedMooney M18C · Perry, OKNTSB UNK65X0661Accident · Serious injuriesClosedDean Case Specl · Fairview, OKNTSB UNK65X0635Accident · 2 fatalClosedCessna 206 · Ponca City, OKNTSB UNK65X0597Accident · No injuriesClosedCessna 172 · Lawton, OKNTSB UNK65X0388Accident · No injuriesClosedAero Comm 520 · El Reno, OKNTSB UNK65X0238Accident · No injuriesClosedCessna 182 · Cache, OKNTSB UNK65X0190Accident · Minor injuriesClosedCessna C37 · Shawnee, OKNTSB UNK64X4088Accident · Serious injuriesClosedLuscombe 8E · Sapulpa, OKNTSB UNK64X4041Accident · Serious injuriesClosedPiper PA15 · Wetumka, OKNTSB UNK64X3978Accident · No injuriesClosedPiper J3 · Guthrie, OKNTSB UNK64X3976Accident · No injuriesClosedPiper PA24 · Okla City, OKNTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OKNTSB UNK64X3822Accident · No injuriesClosedStinson 108-1 · Ardmore, OKNTSB UNK64X3812Accident · No injuriesClosedPiper PA24 · Perry, OKNTSB UNK64X3804Accident · 2 fatalClosedTaylorcraft BC-12D · Douglas, OKNTSB UNK64X3773Accident · No injuriesClosedPiper PA28 · Kingston, OKNTSB UNK64X3750Accident · Minor injuriesClosedErcoupe 415C · Eufaula, OKNTSB UNK64X3479Accident · No injuriesClosedCessna 182 · Mcalester, OKNTSB UNK64X3252Accident · No injuriesClosedPiper PA24 · Prague, OKNTSB UNK64X3189Incident · No injuriesClosedLockheed L-188A · Tulsa, OKNTSB UNK64X3151Accident · No injuriesClosedMooney MK20C · Okla City, OKNTSB UNK64X3049Accident · No injuriesClosedCessna 310F · Durant, OKNTSB UNK64X3048Accident · No injuriesClosedErcoupe 415C · Bartlesville, OKNTSB UNK64X3019Accident · No injuriesClosedChampion 7EC · Guymon, OKNTSB UNK64X2998Accident · No injuriesClosedBeech F35 · Okla City, OKNTSB UNK64X2853Accident · No injuriesClosedCessna 182 · Weatherford, OKNTSB UNK64X2782Accident · Serious injuriesClosedForney 415C · Purcell, OKNTSB UNK64X2756Accident · 1 fatalClosedBeechcraft A45 · Anadarko, OKNTSB UNK64X2712Accident · No injuriesClosedCessna 310G · Stillwater, OKNTSB UNK64X2648Accident · 2 fatalClosedCessna 172 · Tulsa, OKNTSB UNK64X2646Accident · No injuriesClosedMooney MK20D · Gage, OKNTSB UNK64X2583Accident · 4 fatalClosedCessna 170B · Muskogee, OKNTSB UNK64X2514Accident · No injuriesClosedBeechcraft 23 · Yukon, OK