NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NENTSB MKC66A0034Accident · 1 fatalClosedPiper PA-22 · Burr, NENTSB MKC66F0312Accident · Serious injuriesClosedCessna 172 · Sutherland, NENTSB MKC66F0317Accident · No injuriesClosedPiper PA-28 · Lincoln, NENTSB MKC66F0356Accident · No injuriesClosedPiper PA-24 · Omaha, NENTSB MKC66F0303Accident · Minor injuriesClosedCessna 175 · Mullen, NENTSB MKC66F0292Accident · No injuriesClosedAeronca 7AC · Valley, NENTSB MKC66F0296Accident · No injuriesClosedBeechcraft B95 · Columbus, NENTSB MKC66F0286Accident · Serious injuriesClosedPiper PA-24 · Lincoln, NENTSB MKC66F0284Accident · No injuriesClosedPiper PA-12 · Paxton, NENTSB MKC66F0390Accident · No injuriesClosedPiper PA-28 · Grand Island, NENTSB MKC66F0259Accident · No injuriesClosedCessna 210 · Omaha, NENTSB MKC66F0250Accident · No injuriesClosedTaylorcraft BL-65 · Spencer, NENTSB MKC66F0227Accident · No injuriesClosedPiper PA-24 · Ogallala, NENTSB MKC66A0019Accident · 3 fatalClosedDouglas A-26 · Scottsbluff, NENTSB MKC66F0222Accident · No injuriesClosedBeechcraft 35-33 · Omaha, NENTSB MKC66F0195Accident · No injuriesClosedPiper PA-23 · Wallace, NENTSB MKC66F0192Accident · No injuriesClosedCessna 185 · Fairbury, NENTSB MKC66F0191Accident · No injuriesClosedPiper PA-18A · Hershey, NENTSB MKC66F0137Accident · No injuriesClosedPiper PA-18A · Elm Creek, NENTSB MKC66F0163Accident · No injuriesClosedCessna 180 · Scottsbluff, NENTSB MKC66F0136Accident · No injuriesClosedBeechcraft A-23 · Crofton, NENTSB MKC66F0117Accident · No injuriesClosedCessna 140 · Omaha, NENTSB UNK65X1519Accident · No injuriesClosedPiper PA-18A · Kimball, NENTSB MKC66F0107Accident · No injuriesClosedPiper J-3 · Giltner, NENTSB MKC66F0108Accident · No injuriesClosedPiper PA-25 · Hayes Center, NENTSB MKC66F0094Accident · Minor injuriesClosedPiper PA-18 · Fremont, NENTSB MKC66F0084Accident · No injuriesClosedMooney M20 · Omaha, NENTSB MKC66A0002Accident · Serious injuriesClosedBoeing 707 131B · Omaha, NENTSB MKC66F0074Accident · Serious injuriesClosedCessna 182C · Culbertson, NENTSB MKC66F0070Accident · Minor injuriesClosedChampion 7GCB · Imperial, NENTSB MKC66F0092Accident · Serious injuriesClosedPiper PA-18 · Minden, NENTSB MKC66D0054Accident · No injuriesClosedPiper PA-18A · Sutherland, NENTSB MKC66F0057Accident · No injuriesClosedBeech A35 · Hoskins, NENTSB MKC65A0077Accident · 1 fatalClosedPiper J3C · Nebraska City, NENTSB MKC66D0046Accident · No injuriesClosedPiper PA-22 · Gibbon, NENTSB MKC66F0064Accident · No injuriesClosedPiper PA-25 · Scottsbluff, NENTSB MKC66F0060Accident · Serious injuriesClosedAeronca 7AC · Springview, NENTSB MKC66F0053Accident · No injuriesClosedCallair A-6 · Humbolt, NENTSB MKC66F0045Accident · No injuriesClosedBeechcraft F-17D · Papillion, NENTSB MKC66F0032Accident · No injuriesClosedPiper PA-25 · Gilead, NENTSB MKC66F0031Accident · No injuriesClosedCessna 182H · Grand Island, NENTSB MKC65A0071Accident · 4 fatalClosedBeechcraft 35 · Bee, NENTSB MKC66D0037Accident · No injuriesClosedPiper PA-18A · Decatur, NENTSB MKC66F0004Accident · Serious injuriesClosedPiper PA-22 · Imperial, NENTSB MKC65F0154Accident · 1 fatalClosedSchweizer SGS126 · Papillion, NENTSB MKC66D0001Accident · Minor injuriesClosedPiper J3-C · Nebraska City, NENTSB MKC65F0131Accident · No injuriesClosedPiper PA-22 · Sutherland, NENTSB MKC65D0114Accident · No injuriesClosedCessna 182 · Ord, NENTSB MKC65F0134Accident · No injuriesClosedBeechcraft 23 · Lincoln, NE