NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 MKC81FCJ04Accident · No injuriesClosedCessna 182 · Albion, NENTSB MKC81DCJ03Accident · No injuriesClosedPiper PA-15 · Cambridge, NENTSB MKC81DCJ02Accident · No injuriesClosedCessna 120 · Aurora, NENTSB MKC81DCJ01Accident · No injuriesClosedCessna 175A · Broken Bow, NENTSB MKC80DCJ34Accident · Serious injuriesClosedPiper PA-28 · Burwell, NENTSB MKC80DCJ33Accident · Minor injuriesClosedUniv Acft 108-2 · Omaha, NENTSB MKC80DCJ31Accident · No injuriesClosedPiper PA-28 · Ogallala, NENTSB MKC80DCJ32Accident · No injuriesClosedPiper PA-28R · Nebraska City, NENTSB MKC80DCJ39Accident · No injuriesClosedPiper PA-25 · Weeping Water, NENTSB MKC80DCJ29Accident · No injuriesClosedCessna 152 · Columbus, NENTSB MKC80FA049Accident · Serious injuriesClosedPiper PA-28R · Omaha, NENTSB MKC80DCJ28Accident · No injuriesClosedGrumman G-164B · Cambridge, NENTSB MKC80DCJ27Accident · No injuriesClosedCessna A188B · Axtell, NENTSB MKC80FCJ26Accident · Minor injuriesClosedMaule M4-210 · O'Neill, NENTSB MKC80DCJ24Accident · No injuriesClosedPiper PA-25 · Overton, NENTSB MKC80DCJ23Accident · No injuriesClosedCessna 188 · Blue Hill, NENTSB MKC80DCJ20Accident · No injuriesClosedCessna A188B · Holdrege, NENTSB MKC80FCJ25Accident · No injuriesClosedCessna 150L · Sutton, NENTSB MKC80DCJ21Accident · No injuriesClosedPiper PA-25 · Minden, NENTSB MKC80DCJ19Accident · Minor injuriesClosedStinson 108-3 · Minden, NENTSB MKC80DCJ18Accident · No injuriesClosedMooney M20F · Gordon, NENTSB MKC80FCJ16Accident · No injuriesClosedAero Comndr 500B · Omaha, NENTSB MKC80DCJ15Accident · Serious injuriesClosedKen Kanta KR-2 · Omaha, NENTSB DCA80AA019Accident · 13 fatalClosedSwearingen 226TC · Valley, NENTSB MKC80FCJ13Accident · No injuriesClosedGreat Lakes 01 · Omaha, NENTSB MKC80DCJ12Accident · No injuriesClosedCessna 188 · Clay Center, NENTSB MKC80FA036Accident · 1 fatalClosedCherokee II · So Sioux City, NENTSB MKC80DCJ11Accident · No injuriesClosedCessna 152 · Omaha, NENTSB MKC80FCJ10Accident · No injuriesClosedPiper PA-22 · Lincoln, NENTSB MKC80FA029Accident · 1 fatalClosedCessna 210L · Sidney, NENTSB MKC80FCJ08Accident · No injuriesClosedCessna 152 · Imperial, NENTSB MKC80FCJ09Accident · No injuriesClosedCessna 310 · Thedford, NENTSB MKC80DA027Accident · No injuriesClosedPiper PA-31 · Utica, NENTSB MKC80DCJ07Accident · No injuriesClosedBeech 200 · Hastings, NENTSB MKC80FCJ06Accident · Serious injuriesClosedPiper J3C · Milburn, NENTSB MKC80DCJ05Accident · No injuriesClosedCessna 172M · Sidney, NE