NTSB investigations, 1980, AL
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 |
|---|---|
| 1963 | 1 |
| 1964 | 61 |
| 1965 | 92 |
| 1966 | 70 |
| 1967 | 85 |
| 1968 | 68 |
| 1969 | 75 |
| 1970 | 89 |
| 1971 | 73 |
| 1972 | 76 |
| 1973 | 82 |
| 1974 | 67 |
| 1975 | 71 |
| 1976 | 77 |
| 1977 | 82 |
| 1978 | 72 |
| 1979 | 50 |
| 1980 | 50 |
| 1981 | 48 |
| 1982 | 61 |
| 1983 | 60 |
| 1984 | 41 |
| 1985 | 45 |
| 1986 | 48 |
| 1987 | 45 |
| 1988 | 36 |
| 1989 | 33 |
| 1990 | 32 |
| 1991 | 30 |
| 1992 | 40 |
| 1993 | 33 |
| 1994 | 27 |
| 1995 | 42 |
| 1996 | 32 |
| 1997 | 17 |
| 1998 | 27 |
| 1999 | 29 |
| 2000 | 17 |
| 2001 | 25 |
| 2002 | 27 |
| 2003 | 30 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 24 |
| 2007 | 29 |
| 2008 | 28 |
| 2009 | 13 |
| 2010 | 8 |
| 2011 | 17 |
| 2012 | 25 |
| 2013 | 10 |
| 2014 | 24 |
| 2015 | 23 |
| 2016 | 12 |
| 2017 | 19 |
| 2018 | 20 |
| 2019 | 15 |
| 2020 | 17 |
| 2021 | 15 |
| 2022 | 21 |
| 2023 | 19 |
| 2024 | 11 |
| 2025 | 18 |
| 2026 | 17 |
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\" = 'AL' 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" = 'AL' 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 ATL81DKJ03Accident · No injuriesClosedCessna 402B · Fairhope, ALNTSB ATL81FA007Accident · 4 fatalClosedCessna T188C · Theodore, ALNTSB ATL81DKJ01Accident · No injuriesClosedBeech C18S · Theodore, ALNTSB ATL80DKJ32Accident · No injuriesClosedBeech C24R · Decatur, ALNTSB ATL88DKJ34Accident · No injuriesClosedPiper PA-25 · Bay Minette, ALNTSB ATL81FA099Accident · No injuriesClosedSnow AT302A · Selma, ALNTSB ATL80DKJ29Accident · No injuriesClosedCessna 182M · Iron City, ALNTSB ATL81FKJ28Accident · Minor injuriesClosedGrumman G-164 · Bay Minette, ALNTSB ATL80DKJ31Accident · No injuriesClosedPiper PA-28R · Redstone Arsnl, ALNTSB ATL80DKJ27Accident · Minor injuriesClosedPiper PA-28 · Ashville, ALNTSB ATL80FKJ26Accident · Serious injuriesClosedGrumman G-164B · Autaugaville, ALNTSB ATL80DKJ24Accident · No injuriesClosedCessna 150 · Hartselle, ALNTSB ATL80DKJ25Accident · Minor injuriesClosedGrumman G-164 · Cherokee, ALNTSB ATL80FKJ22Accident · No injuriesClosedCessna R182 · Anniston, ALNTSB ATL80FA080Accident · No injuriesClosedGrumman G-164A · Samson, ALNTSB ATL80DKJ20Accident · No injuriesClosedHughes 269B · Decatur, ALNTSB ATL80FKJ19Accident · No injuriesClosedBeech S35 · Selma, ALNTSB ATL80DKJ17Accident · No injuriesClosedBeech 58 · Jackson, ALNTSB ATL80DKJ18Accident · No injuriesClosedPiper PA-28R · Dothan, ALNTSB ATL80DKJ16Accident · No injuriesClosedCessna 172 · Butler, ALNTSB ATL80FKJ15Accident · No injuriesClosedErco 415-C · Cullman, ALNTSB ATL80FA059Accident · 2 fatalClosedCessna 182 · Omaha, ALNTSB ATL80FKJ13Accident · Minor injuriesClosedPitts S-2S · Alabaster, ALNTSB ATL80FA054Accident · No injuriesClosedSwearingen SA226A · Birmingham, ALNTSB ATL80FKJ12Accident · Minor injuriesClosedPiper J5A · Cullman, ALNTSB ATL80FKJ11Accident · Minor injuriesClosedCessna 150 · Decatur, ALNTSB ATL80FKJ09Accident · No injuriesClosedCessna T188 · St Elmo, ALNTSB ATL80DKJ08Accident · No injuriesClosedPiper PA-28 · Ashland, ALNTSB ATL80DKJ07Accident · No injuriesClosedCessna 150 · Florence, ALNTSB ATL80FA049Accident · 6 fatalClosedPiper PA-31 · Mobile, ALNTSB ATL80DKJ06Accident · No injuriesClosedBeech B19 · Oneonta, ALNTSB ATL80DKJ05Incident · No injuriesClosedGlobe GC-1B · Spring Hill, ALNTSB ATL80DKJ02Accident · No injuriesClosedCessna 150 · Camden, ALNTSB ATL80DKJ14Accident · No injuriesClosedCessna 172R · Huntsville, ALNTSB ATL80DKJ04Accident · No injuriesClosedCessna 182 · Mobile, ALNTSB ATL80FKJ03Accident · Minor injuriesClosedCessna 182 · Heflin, ALNTSB MIA80DKJ31Accident · No injuriesClosedPiper PA-31 · Eufaula, ALNTSB MIA80DKJ30Accident · No injuriesClosedCessna 172 · Clayton, ALNTSB MIA80FKJ29Accident · Minor injuriesClosedPiper PA-28R · Foley, ALNTSB MIA80FKJ34Accident · No injuriesClosedBeech 95-B55 · Montgomery, ALNTSB MIA80FKJ28Accident · No injuriesClosedPiper PA-30 · Birmingham, ALNTSB MIA80FKJ27Accident · 1 fatalClosedBensen BTS8-M · Selma, ALNTSB MIA80FA049Accident · 2 fatalClosedCessna U206 · York, ALNTSB MIA80DKJ23Accident · No injuriesClosedPiper PA-32 · Hokes Bluff, ALNTSB MIA80FKJ22Accident · Serious injuriesClosedErco 415-C · Laceys Spring, ALNTSB MIA80FKJ21Accident · No injuriesClosedCessna 152 · Montgomery, ALNTSB MIA80FKJ20Accident · No injuriesClosedCessna 150 · North Johns, ALNTSB MIA80DKJ18Accident · No injuriesClosedMaule M5 · Foley, ALNTSB MIA80FKJ17Accident · Serious injuriesClosedStinson 108-1 · Irvington, ALNTSB MIA80FA028Accident · No injuriesClosedPiper PA-23 · Mobile, AL