NTSB investigations, 1973, NE
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1973
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") = 1973 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 MKC74DCJ22Accident · No injuriesClosedCessna 120 · Wilber, NENTSB MKC74DCJ21Accident · No injuriesClosedCessna 172 · Omaha, NENTSB MKC74DCJ23Accident · No injuriesClosedCessna 170A · Merriman, NENTSB MKC74DCJ20Accident · No injuriesClosedCessna 150 · Angora, NENTSB MKC74FCJ17Accident · No injuriesClosedCessna 172 · Beatrice, NENTSB MKC74DCJ19Accident · No injuriesClosedBell 206A · North Platte, NENTSB MKC74FCJ18Accident · No injuriesClosedPiper PA-22 · Valparaiso, NENTSB MKC74AK023Accident · 1 fatalClosedTaylorcraft BC12-D · Fairbury, NENTSB MKC74DGJ15Accident · No injuriesClosedPiper PA-28 · Gordon, NENTSB MKC74DCJ16Accident · No injuriesClosedErco 415C · Trenton, NENTSB MKC74FCJ14Accident · No injuriesClosedAero Comdr 200D · Emerald, NENTSB MKC74FCJ13Accident · Minor injuriesClosedCessna 182M · Seward, NENTSB MKC74DCJ11Accident · No injuriesClosedPiper PA-18 · Ainsworth, NENTSB MKC74AK012Accident · 3 fatalClosedGates Lear 25 · Lincoln, NENTSB MKC74DCJ10Accident · No injuriesClosedPiper PA-25 · Gresham, NENTSB MKC74FCJ09Accident · Minor injuriesClosedBeech 58 · Omaha, NENTSB MKC74FCJ08Accident · No injuriesClosedBeech C35 · Papillion, NENTSB MKC74FCJ07Accident · Serious injuriesClosedCessna 177A · Omaha, NENTSB MKC74FCJ06Accident · No injuriesClosedPiper PA-25 · Thurston, NENTSB MKC74FCJ04Accident · No injuriesClosedPiper PA-28 · Lincoln, NENTSB MKC74DCJ12Accident · No injuriesClosedPiper PA-25 · Bertrand, NENTSB MKC74DCJ05Accident · No injuriesClosedCessna 150J · North Platte, NENTSB MKC74DCJ03Accident · No injuriesClosedPiper PA-28 · Ogallala, NENTSB MKC74DCJ02Accident · No injuriesClosedBeech P35 · Scottsbluff, NENTSB MKC74DCJ01Accident · No injuriesClosedPiper PA-25 · Lynch, NENTSB MKC73DCJ50Accident · No injuriesClosedPiper PA-28 · Hay Springs, NENTSB MKC73AK076Accident · 2 fatalClosedBeech D17S · Kimball, NENTSB MKC73AK075Accident · 1 fatalClosedPiper PA-18 · Grant, NENTSB MKC73FCJ49Accident · Minor injuriesClosedMooney M20A · Bassett, NENTSB MKC73FCJ48Accident · Minor injuriesClosedPiper PA-15 · Schwyler, NENTSB MKC73DCJ45Accident · No injuriesClosedPiper PA-25 · North Loup, NENTSB MKC73DCJ47Accident · Minor injuriesClosedPiper PA-25 · Stamford, NENTSB MKC73DCJ46Accident · No injuriesClosedPiper PA-22 · Nebraska Cty, NENTSB MKC73DCJ44Accident · No injuriesClosedPiper J3C-65 · Lodgepole, NENTSB MKC73DCJ39Accident · Minor injuriesClosedGernr Evans WE-1 · Kimball, NENTSB MKC73DCJ43Accident · No injuriesClosedCessna 150 · Plattsmouth, NENTSB MKC73FCJ41Accident · 1 fatalClosedChampion 7GCBC · Lexington, NENTSB MKC73DCJ42Accident · No injuriesClosedLuscombe 8A · Sidney, NENTSB MKC73FCJ40Accident · 1 fatalClosedScorpion Single · Grand Island, NENTSB MKC73DCJ38Accident · No injuriesClosedCessna 180H · Ponca, NENTSB MKC73DCJ37Accident · No injuriesClosedPiper PA-16 · Atkinson, NENTSB MKC73DCJ36Accident · No injuriesClosedPiper PA-18 · Ogallala, NENTSB MKC73FCJ35Accident · Serious injuriesClosedPiper PA-18 · Maywood, NENTSB MKC73DCJ34Accident · No injuriesClosedCessna 188B · Sutton, NENTSB MKC73FCJ33Accident · No injuriesClosedCessna 150L · Fort Calhoun, NENTSB MKC73DCJ32Accident · No injuriesClosedCessna T-50 · Omaha, NENTSB MKC73FCJ31Accident · No injuriesClosedCessna 310G · Omaha, NENTSB MKC73FCJ30Accident · No injuriesClosedCessna 140A · Mc Cook, NENTSB MKC73FCJ29Accident · 1 fatalClosedCessna A188B · Hebron, NENTSB MKC73DCJ28Accident · No injuriesClosedChampion 7GCAA · No.Platte, NE