NTSB investigations, 1978, OK
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 | 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
Open the mapLatest 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\") = 1978
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") = 1978 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 FTW79FA034Accident · 1 fatalClosedAero Comdr 680 · Oklahoma City, OKNTSB FTW79FA029Accident · 4 fatalClosedCessna 172N · Ada, OKNTSB FTW79DPJ03Accident · No injuriesClosedPiper PA-28R · Chattanooga, OKNTSB FTW79DPM04Accident · No injuriesClosedPiper PA-22 · Durant, OKNTSB FTW79FPM03Accident · Serious injuriesClosedCessna 185A · Tulsa, OKNTSB FTW79FPM01Accident · Serious injuriesClosedCessna 172 · Jenks, OKNTSB FTW79DPJ02Accident · No injuriesClosedCessna 152 · Tonkawa, OKNTSB FTW79FPJ01Accident · 1 fatalClosedPiper PA-25 · Hydro, OKNTSB FTW79FPM02Accident · No injuriesClosedCessna 152T · Dewey, OKNTSB FTW78DA003Accident · Minor injuriesClosedWaco VKS-7 · Tahlequah, OKNTSB FTW79DPJ39Accident · No injuriesClosedCessna 172 · Enid, OKNTSB FTW78DPJ38Accident · No injuriesClosedCessna 150 · Tuttle, OKNTSB FTW78IA074Incident · No injuriesClosedPiper PA-32 · Enid, OKNTSB FTW78DPJ37Accident · No injuriesClosedCessna 172XP · Elk City, OKNTSB FTW78FPJ36Accident · No injuriesClosedCessna 310C · Oklahoma City, OKNTSB FTW78FPM23Accident · No injuriesClosedCessna 150L · Pawhuska, OKNTSB FTW78FPJ35Accident · Serious injuriesClosedCessna 150 · Lawton, OKNTSB FTW78DPJ33Accident · No injuriesClosedCessna 172 · Beaver, OKNTSB FTW78FPM22Accident · Minor injuriesClosedAero-Comdr 100 · Tahlequah, OKNTSB FTW78FPJ31Accident · No injuriesClosedCessna 182 · Cushing, OKNTSB FTW78FPJ30Accident · No injuriesClosedBeech 35 · Tecumseh, OKNTSB FTW78FA056Accident · 3 fatalClosedCessna 182P · Hollis, OKNTSB FTW79DPM24Accident · No injuriesClosedAir Tractor 301 · Bartlesville, OKNTSB FTW78FPM20Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW78FPM19Accident · Minor injuriesClosedCessna 152 · Tulsa, OKNTSB FTW78FPJ29Accident · 1 fatalClosedBellanca 8GCBC · Hinton, OKNTSB FTW78FPM21Accident · Serious injuriesClosedSemco Chlngr · Tulsa, OKNTSB FTW78FPJ28Accident · No injuriesClosedLuscombe 8A · Norge, OKNTSB FTW78FPM18Accident · No injuriesClosedCessna 150 · Tulsa, OKNTSB FTW78FPM17Accident · Serious injuriesClosedRearwin 8135 · Owasso, OKNTSB FTW78FPM16Accident · Serious injuriesClosedCessna 177 · Pawhuska, OKNTSB FTW78FPJ27Accident · No injuriesClosedPiper PA-25 · Gould, OKNTSB FTW78FPJ26Accident · Serious injuriesClosedPiper PA-25 · Enid, OKNTSB FTW78FPM15Accident · No injuriesClosedSchleicher K7 · Haskell, OKNTSB FTW78FA049Accident · 2 fatalClosedPiper PA-18 · Greenfield, OKNTSB FTW78FPJ24Accident · No injuriesClosedLuscombe 8A · Oklahoma City, OKNTSB FTW78FA048Accident · 1 fatalClosedPiper PA-23 · Longdale, OKNTSB FTW78FPM12Accident · No injuriesClosedCessna 150 · Owasso, OKNTSB FTW78FPM13Accident · No injuriesClosedPiper PA-22 · Tulsa, OKNTSB FTW78FPM11Accident · Serious injuriesClosedLockheed TV-2 · Muskogee, OKNTSB FTW78FA047Accident · 2 fatalClosedAero Comdr 690A · Calumet, OKNTSB FTW78DPJ25Accident · No injuriesClosedCessna 182 · Lawton, OKNTSB FTW78FPM10Accident · Serious injuriesClosedGlobe Swift GC-1B · Tulsa, OKNTSB FTW78DPJ23Accident · No injuriesClosedGreat Lakes 2T-1A · Enid, OKNTSB FTW78FPJ22Accident · Minor injuriesClosedErco 415-C · El Reno, OKNTSB FTW78FPJ20Accident · No injuriesClosedCessna 414A · Oklahoma City, OKNTSB FTW78FPM09Accident · No injuriesClosedPiper PA-28 · Tulsa, OKNTSB FTW78FPJ19Accident · No injuriesClosedCessna A188B · Kingfisher, OKNTSB FTW78FPJ18Accident · Serious injuriesClosedPiper PA-25 · Comanche, OKNTSB FTW78FPJ21Accident · No injuriesClosedBeech 58P · Prague, OK