NTSB investigations, 1966, NE
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
| 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\") = 1966
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") = 1966 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 MKC67D0350Accident · No injuriesClosedCessna 210B · Lincoln, NENTSB MKC67F0402Accident · No injuriesClosedCessna 140 · Palmer, NENTSB MKC67D0386Accident · No injuriesClosedPiper J3C-65 · Silver Creek, NENTSB MKC67F0374Accident · No injuriesClosedBeech A23 · Lincoln, NENTSB MKC67F0338Accident · No injuriesClosedPiper PA-24 · Omaha, NENTSB MKC67F0339Accident · No injuriesClosedCessna 195A · Hastings, NENTSB MKC67A0037Accident · 2 fatalClosedChampion 7DC · Anselmo, NENTSB MKC67F0325Accident · No injuriesClosedCessna 195 · Humboldt, NENTSB MKC67A0033Accident · 1 fatalClosedCessna 172G · Venango, NENTSB MKC67F0298Accident · No injuriesClosedPiper PA-28 · Lincoln, NENTSB MKC67F0270Accident · Minor injuriesClosedPiper PA-18 · Eli, NENTSB MKC67A0031Accident · Minor injuriesClosedBensen B-8M · Lincoln, NENTSB MKC67F0290Accident · Minor injuriesClosedBoeing A75N1 · North Platte, NENTSB MKC67D0273Accident · No injuriesClosedCessna 182 · Omaha, NENTSB MKC67D0279Accident · No injuriesClosedCessna 170 · Thedford, NENTSB MKC67D0262Accident · No injuriesClosedPiper PA-22 · Chadron, NENTSB MKC67F0198Accident · No injuriesClosedBeech K35 · Lincoln, NENTSB MKC67F0213Accident · No injuriesClosedPiper PA-22 · Scottsbluff, NENTSB MKC67F0157Accident · Minor injuriesClosedCessna 120 · Tekamah, NENTSB MKC67A0015Accident · 2 fatalClosedPiper PA-11 · Mullen, NENTSB MKC67D0177Accident · No injuriesClosedCessna 182J · Minden, NENTSB MKC67F0176Accident · No injuriesClosedPiper PA-23 · Broken Bow, NENTSB MKC67F0172Accident · No injuriesClosedNavion A · Grand Island, NENTSB UNK66X0163CaseClosedBritish AC 1-11 · Falls City, NENTSB DCA67A0001Accident · 42 fatalClosedBritish AC · Falls City, NENTSB MKC67F0141Accident · No injuriesClosedCessna 150F · Columbus, NENTSB MKC67A0008Accident · No injuriesClosedMooney M20E · Columbus, NENTSB MKC67F0140Accident · No injuriesClosedPiper PA-25 · Lexington, NENTSB MKC67F0170Accident · 1 fatalClosedBoeing A75 · Lexington, NENTSB MKC67F0097Accident · No injuriesClosedChampion 7GC · Axtell, NENTSB MKC67F0095Accident · Serious injuriesClosedPiper PA-18 · Shelton Webr, NENTSB MKC67F0082Accident · No injuriesClosedPiper PA-18A · Naponee, NENTSB MKC67F0110Accident · No injuriesClosedSnow S2A · Elwood, NENTSB MKC67D0094Accident · No injuriesClosedCessna 210 · Columbus, NENTSB MKC67D0093Accident · No injuriesClosedCessna 170A · O@Neil, NENTSB MKC67D0053Accident · No injuriesClosedPrue 215A · Wilbur, NENTSB MKC67D0054Accident · No injuriesClosedPiper PA-18A · Bartley, NENTSB MKC67A0002Accident · 2 fatalClosedAeronca 7ACM · Gordon, NENTSB MKC67A0001Accident · Serious injuriesClosedHiller UH12E · North Platte, NENTSB MKC67F0076Accident · No injuriesClosedMooney M20 · Omaha, NENTSB MKC67F0037Accident · Minor injuriesClosedPiper PA-12 · Madison, NENTSB MKC66A0069Accident · No injuriesClosedDouglas DC-3 · Hastings, NENTSB MKC66F0584Accident · Minor injuriesClosedPiper PA-25 · Wisner, NENTSB MKC67D0044Accident · No injuriesClosedPiper PA-28 · Loup City, NENTSB MKC66A0066Accident · No injuriesClosedBrantly B-2 · N.Platte, NENTSB MKC67F0006Accident · No injuriesClosedPiper PA-25 · Holdredge, NENTSB MKC66F0581Accident · No injuriesClosedPiper PA-24 · Lincoln, NENTSB MKC66A0062Accident · 1 fatalClosedCessna 182 · Hyannis, NENTSB MKC67F0003Accident · No injuriesClosedPiper PA-11 · Whitman, NENTSB MKC66D0577Accident · No injuriesClosedPiper PA-22 · Sidney, NE