NTSB investigations, 1976, NE
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1976
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") = 1976 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 MKC77FCJ08Accident · Minor injuriesClosedBellanca 7ECA · Tecumseh, NENTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NENTSB MKC77FA007Accident · 3 fatalClosedPiper PA-24 · Kimball, NENTSB MKC77FCJ05Accident · No injuriesClosedPiper PA-28 · Hastings, NENTSB MKC77FCJ04Accident · No injuriesClosedPiper PA-34 · Nebraska City, NENTSB MKC77FCJ03Accident · No injuriesClosedCessna 210J · Columbus, NENTSB MKC77DCJ02Accident · Minor injuriesClosedPiper PA-28R · Wayne, NENTSB MKC77DCJ01Accident · No injuriesClosedErco 415-C · Omaha, NENTSB MKC77IA001Incident · No injuriesClosedN. American NA-265 · Scottsbluff, NENTSB MKC76AK083Accident · 2 fatalClosedN. American AT-6G · Beatrice, NENTSB MKC76FCJ71Accident · No injuriesClosedCessna 180 · Gordon, NENTSB MKC76FCJ69Accident · 1 fatalClosedPiper PA-18A · North Platte, NENTSB MKC76DCJ67Accident · No injuriesClosedArrow A&M 2-110 · Burwell, NENTSB MKC76DCJ68Accident · No injuriesClosedPiper PA-28 · Omaha, NENTSB MKC76FCJ66Accident · No injuriesClosedCessna 195B · Lincoln, NENTSB MKC76DCJ65Accident · No injuriesClosedCessna 182A · Bingham, NENTSB MKC76DCJ64Accident · No injuriesClosedCessna 188 · Bridgeport, NENTSB MKC76AK076Accident · 2 fatalClosedPiper PA-32R · Overton, NENTSB MKC76AK075Accident · 3 fatalClosedBeech B35 · Columbus, NENTSB MKC76FCJ63Accident · No injuriesClosedPiper PA-36 · North Platte, NENTSB MKC76FCJ62Accident · No injuriesClosedStinson 108-2 · Mccook, NENTSB MKC76FCJ60Accident · Minor injuriesClosedPiper PA-28 · Broken Bow, NENTSB MKC76DCJ58Accident · 1 fatalClosedPiper PA-18 · Abie, NENTSB MKC76FCJ61Accident · No injuriesClosedPiper PA-25 · Holdrege, NENTSB MKC76DCJ59Accident · No injuriesClosedCessna 188B · Campbell, NENTSB MKC76FCJ57Accident · No injuriesClosedPiper PA-36 · Bertrand, NENTSB MKC76FCJ56Accident · No injuriesClosedPiper PA-36 · Imperial, NENTSB MKC76DCJ53Accident · Minor injuriesClosedGrumman G-164A · Farnam, NENTSB MKC76FCJ55Accident · No injuriesClosedSchleicher K-7 · Lincoln, NENTSB MKC76FCJ45Accident · Serious injuriesClosedCessna 140 · Elgin, NENTSB MKC76FCJ52Accident · Serious injuriesClosedCessna A188B · Harvard, NENTSB MKC76DCJ51Accident · Minor injuriesClosedMaule M5210C · Gothenburg, NENTSB MKC76DCJ50Accident · No injuriesClosedCessna A188B · York, NENTSB MKC76DCJ49Accident · No injuriesClosedCessna 172 · Mccook, NENTSB MKC76FCJ48Accident · No injuriesClosedCallair A-9 · Stromsburg, NENTSB MKC76DCJ47Accident · No injuriesClosedPiper PA-24 · Chadron, NENTSB MKC76DCJ46Accident · No injuriesClosedBellanca 7GCBC · Cedar Rapids, NENTSB MKC76FCJ45Accident · No injuriesClosedGrumman G-164A · Minden, NENTSB MKC76DCJ44Accident · No injuriesClosedCessna 140 · York, NENTSB MKC76DCJ42Accident · No injuriesClosedCessna 210 · Omaha, NENTSB MKC76FCJ43Accident · No injuriesClosedPiper PA-28 · Kennard, NENTSB MKC76FCJ41Accident · Minor injuriesClosedHiller Acft UH-12D · North Platte, NENTSB MKC76FCJ40Accident · No injuriesClosedCallair A-9 · Central City, NENTSB MKC76DCJ39Accident · Serious injuriesClosedAero-Comdr A-9B · Bridgeport, NENTSB MKC76DCJ37Accident · No injuriesClosedPiper J3C-65 · Ashland, NENTSB MKC76DCJ38Accident · No injuriesClosedPiper PA-28 · Hallam, NENTSB MKC76DCJ35Accident · No injuriesClosedCessna 172 · Mccook, NENTSB MKC76DCJ36Accident · No injuriesClosedCessna 185D · Ashby, NENTSB MKC76DCJ34Accident · No injuriesClosedAero Comdr 600S2R · Norfolk, NENTSB MKC76DCJ33Accident · No injuriesClosedCessna 150 · Omaha, NE