NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1077Accident · No injuriesClosedHughes 269A · Columbus, NENTSB UNK65X0986Accident · No injuriesClosedPiper PA22 · Wayne, NENTSB UNK65X0921Accident · No injuriesClosedBellanca 14-19 · Kearney, NENTSB UNK65X0823Accident · No injuriesClosedPiper PA18 · Valentine, NENTSB UNK65X0773Accident · No injuriesClosedBeechcraft 35 · Lincoln, NENTSB UNK65X0625Accident · 2 fatalClosedAeronca 7AC · Merriman, NENTSB UNK65X0608Accident · No injuriesClosedCessna 182 · Grand Is, NENTSB UNK65X0601Accident · No injuriesClosedPiper PA22 · Hastings, NENTSB UNK65X0590Accident · No injuriesClosedCessna 320 · Norfolk, NENTSB UNK65X0436Accident · No injuriesClosedCessna 170 · Marshland, NENTSB UNK65X0432Accident · No injuriesClosedCessna 180 · Gretna, NENTSB UNK65X0399Accident · No injuriesClosedMooney 20P · Kearney, NENTSB UNK65X0381Accident · No injuriesClosedBell 47J2 · Kimball, NENTSB UNK65X0345Accident · 1 fatalClosedBrantly B2 · Broadwater, NENTSB UNK65X0323Accident · No injuriesClosedBeechcraft 23 · Kearney, NENTSB UNK65X0149Accident · 2 fatalClosedAeronca L-16 · Bee, NENTSB UNK64X4132Accident · No injuriesClosedCessna 172D · Valentine, NENTSB UNK64X4100Accident · No injuriesClosedBeech D17S · Burwell, NENTSB UNK64X3988Accident · No injuriesClosedBeechcraft 23 · Ogallala, NENTSB UNK64X3930Accident · No injuriesClosedHughes 269A · North Platte, NENTSB UNK64X3898Accident · No injuriesClosedBeechcraft 33 · Hastings, NENTSB UNK64X3870Accident · No injuriesClosedBeechcraft K35 · Omaha, NENTSB UNK64X3831Accident · 2 fatalClosedBellanca 14-193 · Atkinson, NENTSB UNK64X3759Accident · Minor injuriesClosedHughes 269A · Lexington, NENTSB UNK64X3587Accident · No injuriesClosedPiper PA18 · Lincoln, NENTSB UNK64X3487Accident · No injuriesClosedBeechcraft B95A · Gozad, NENTSB UNK64X3323Accident · Serious injuriesClosedPiper PA-18A · Loomis, NENTSB UNK64X3295Accident · No injuriesClosedCessna 170B · Grand Island, NENTSB UNK64X3068Accident · No injuriesClosedPiper PA25 · Mclean, NENTSB UNK64X2795Accident · No injuriesClosedPiper PA12 · Gordon, NENTSB UNK64X2720Accident · No injuriesClosedSlingsby Lark 4 · Max, NENTSB UNK64X2691Accident · 1 fatalClosedPiper J3 · Tekamah, NENTSB UNK64X2589Accident · No injuriesClosedPiper DA25 · Neligh, NENTSB UNK64X2568Accident · No injuriesClosedPiper PA22 · Sidney, NENTSB UNK64X2484Accident · Minor injuriesClosedBell 47G · Ord, NENTSB UNK64X2308Accident · 1 fatalClosedPiper PA22 · Grant, NENTSB UNK64X2304Accident · No injuriesClosedCessna 120 · Lexington, NENTSB UNK64X2287Accident · No injuriesClosedPiper PA28 · Burwell, NENTSB UNK64X2248Accident · No injuriesClosedCessna 170A · Omaha, NENTSB UNK64X2156Accident · Minor injuriesClosedPiper PA-18 · North Platte, NENTSB UNK64X1813Accident · 1 fatalClosedFunk B85C · Fort Calhoun, NENTSB UNK64X1744Accident · 2 fatalClosedBeech B95 · Columbus, NENTSB UNK64X1631Accident · No injuriesClosedCessna 175 · North Platte, NENTSB UNK64X1630Accident · No injuriesClosedCessna 172C · Niobrara, NENTSB UNK64X1454Accident · No injuriesClosedBeechcraft 35 · Omaha, NENTSB UNK64X1343Accident · Minor injuriesClosedCessna 180 · Dix, NENTSB UNK64X1296Accident · No injuriesClosedPiper PA16 · Lincoln, NENTSB UNK64X1224Accident · Minor injuriesClosedTaylorcraft BL65 · Mullen, NENTSB UNK64X1184Accident · Minor injuriesClosedCessna 182A · Lincoln, NENTSB UNK64X1139Accident · No injuriesClosedCessna 140 · Ord, NE