NTSB investigations, 1967, NE
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
| 1962 | 1 |
|---|---|
| 1964 | 58 |
| 1965 | 67 |
| 1966 | 72 |
| 1967 | 89 |
| 1968 | 80 |
| 1969 | 88 |
| 1970 | 74 |
| 1971 | 93 |
| 1972 | 64 |
| 1973 | 52 |
| 1974 | 71 |
| 1975 | 47 |
| 1976 | 64 |
| 1977 | 52 |
| 1978 | 49 |
| 1979 | 41 |
| 1980 | 36 |
| 1981 | 34 |
| 1982 | 42 |
| 1983 | 39 |
| 1984 | 40 |
| 1985 | 31 |
| 1986 | 27 |
| 1987 | 21 |
| 1988 | 16 |
| 1989 | 22 |
| 1990 | 13 |
| 1991 | 24 |
| 1992 | 20 |
| 1993 | 21 |
| 1994 | 20 |
| 1995 | 16 |
| 1996 | 14 |
| 1997 | 14 |
| 1998 | 28 |
| 1999 | 23 |
| 2000 | 13 |
| 2001 | 19 |
| 2002 | 14 |
| 2003 | 12 |
| 2004 | 11 |
| 2005 | 15 |
| 2006 | 17 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 15 |
| 2010 | 13 |
| 2011 | 7 |
| 2012 | 21 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 10 |
| 2017 | 9 |
| 2018 | 12 |
| 2019 | 13 |
| 2020 | 9 |
| 2021 | 9 |
| 2022 | 14 |
| 2023 | 10 |
| 2024 | 17 |
| 2025 | 11 |
| 2026 | 4 |
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\") = 1967
AND c.\"eventStateOrRegion\" = 'NE' 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") = 1967 AND c."eventStateOrRegion" = 'NE' 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 MKC68F0430Accident · Minor injuriesClosedAeronca 11AC · Rockville, NENTSB MKC68D0398Accident · No injuriesClosedCessna 180 · Millard, NENTSB MKC68A0041Accident · No injuriesClosedBrantly B-2A · Gordon, NENTSB MKC68F0412Accident · No injuriesClosedCessna 182 · Omaha, NENTSB MKC68D0384Accident · No injuriesClosedAero Comdr 100 · Broken Bow, NENTSB MKC68D0379Accident · No injuriesClosedPiper PA-22 · Chadron, NENTSB MKC68F0385Accident · Serious injuriesClosedAero Comdr 680-FL · North Platte, NENTSB MKC68D0351Accident · No injuriesClosedPiper PA-32 · Beaver City, NENTSB MKC68F0366Accident · No injuriesClosedPiper PA-24 · Sutherland, NENTSB MKC68D0364Accident · No injuriesClosedPiper J3C-65 · Curtis, NENTSB NYC68F0350Accident · No injuriesClosedPiper PA-24A · Omaha, NENTSB MKC68F0347Accident · Serious injuriesClosedPiper PA-32 · Hemingford, NENTSB MKC68D0338Accident · No injuriesClosedPiper PA-18 · Whitman, NENTSB MKC68D0346Accident · No injuriesClosedCessna 172 · Blair, NENTSB MKC68D0345Accident · No injuriesClosedCessna 172 · Newport, NENTSB MKC68D0339Accident · No injuriesClosedPiper PA-22 · Lexington, NENTSB MKC68F0332Accident · No injuriesClosedCessna 310 · Alliance, NENTSB MKC68D0315Accident · Minor injuriesClosedPiper J-3 · Gothenburg, NENTSB MKC68D0309Accident · No injuriesClosedCessna 210 · North Platte, NENTSB MKC68F0325Accident · 1 fatalClosedCessna 172 · Lexington, NENTSB MKC68F0299Accident · Minor injuriesClosedCessna 150H · Millard, NENTSB MKC68D0326Accident · No injuriesClosedLuscombe 8A · Craig, NENTSB MKC68D0275Accident · No injuriesClosedPiper PA-28 · Lewellen, NENTSB MKC68F0308Accident · No injuriesClosedPiper PA-24 · Gordon, NENTSB MKC68F0263Accident · Minor injuriesClosedCessna 150 · Omaha, NENTSB MKC68A0026Accident · No injuriesClosedBrantly B-2 · Merriman, NENTSB MKC68F0298Accident · No injuriesClosedPiper PA-28 · Pender, NENTSB MKC68D0270Accident · Minor injuriesClosedCessna 150 · Lodgepole, NENTSB MKC68F0217Accident · No injuriesClosedPiper PA-25 · Mccool Junct, NENTSB DEN68A0016Accident · 1 fatalClosedN.American P-51D · Minden, NENTSB MKC68F0209Accident · Minor injuriesClosedChampion 7GCB · Haigler, NENTSB MKC68D0184Accident · No injuriesClosedCallair A-9 · Henderson, NENTSB MKC68F0211Accident · No injuriesClosedPiper PA-25 · Cozad, NENTSB MKC68F0170Accident · No injuriesClosedPiper J-3 · Lincoln, NENTSB MKC68D0171Accident · No injuriesClosedPiper PA-22 · Wahoo, NENTSB MKC68D0087Accident · No injuriesClosedPiper PA-28 · Hemingford, NENTSB MKC68F0128Accident · Minor injuriesClosedCessna T-210G · Grand Island, NENTSB MKC68F0099Accident · No injuriesClosedCessna 180H · Oneill, NENTSB MKC68D0147Accident · Minor injuriesClosedPiper PA-25 · Kearney, NENTSB MKC68D0161Accident · No injuriesClosedPiper PA-22 · Bridgeport, NENTSB MKC68F0092Accident · No injuriesClosedBeech A35 · So.Sioux City, NENTSB MKC68D0086Accident · No injuriesClosedPiper PA-28 · Chadron, NENTSB MKC68F0102Accident · No injuriesClosedPiper PA-22 · Newman Grove, NENTSB MKC68D0038Accident · No injuriesClosedCessna 182C · Valentine, NENTSB MKC68F0140Accident · No injuriesClosedPiper PA-18 · Alliance, NENTSB MKC67A0091Accident · Serious injuriesClosedHughes 269B · Papillion, NENTSB MKC68F0054Accident · No injuriesClosedBeech 35 · Sidney, NENTSB MKC68F0024Accident · Serious injuriesClosedFunk F23-A · Alliance, NENTSB MKC68A0084Accident · Serious injuriesClosedDouglas DC-6B · 70e Hayes Cr., NENTSB MKC68F0051Accident · No injuriesClosedPiper PA-18 · Chester, NE