NTSB investigations, 1981, AL
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 1981
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") = 1981 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 ATL82FKJ08Accident · No injuriesClosedCessna 152 · Phenix City, ALNTSB ATL82FKJ07Accident · No injuriesClosedCessna 150 · Birmingham, ALNTSB ATL82FKJ06Accident · Serious injuriesClosedCessna 150 · Russellville, ALNTSB ATL82FKJ04Accident · No injuriesClosedCessna 172M · Selma, ALNTSB ATL82DKJ03Accident · No injuriesClosedCessna T210N · Bayou La Batre, ALNTSB ATL82FKJ05Accident · No injuriesClosedBeech 3NM · Ohatchee, ALNTSB ATL82FA011Accident · No injuriesClosedBeech 58 · Selma, ALNTSB ATL82DKJ01Accident · No injuriesClosedPiper PA-28 · Dothan, ALNTSB ATL82DKJ02Accident · No injuriesClosedPiper PA-28 · Hurtsboro, ALNTSB ATL82FA001Accident · 2 fatalClosedPiper PA-38 · Gadsden, ALNTSB ATL81DKJ37Accident · No injuriesClosedCessna 182 · Elberta, ALNTSB ATL81FKJ36Accident · Minor injuriesClosedAir & Space 18A · Huntsville, ALNTSB ATL81FA116Accident · 2 fatalClosedPiper PA-38 · Cullman, ALNTSB ATL81FKJ35Accident · No injuriesClosedBellanca 14-19 · Weaver, ALNTSB ATL81DA113Incident · No injuriesClosedBoeing 727 · Birmingham, ALNTSB ATL81FKJ34Accident · No injuriesClosedCessna 172 · Bay Minette, ALNTSB ATL81DKJ33Accident · Minor injuriesClosedPiper PA-28 · Brundidge, ALNTSB ATL81DKJ32Accident · Serious injuriesClosedPiper PA-32 · Tuscaloosa, ALNTSB ATL81DKJ31Accident · Minor injuriesClosedCessna 150 · Huntsville, ALNTSB ATL81DKJ30Accident · No injuriesClosedCessna 150M · Hamilton, ALNTSB ATL81DKJ29Accident · No injuriesClosedCessna 172N · Daviston, ALNTSB ATL81DKJ28Accident · No injuriesClosedPiper PA-32 · Butler, ALNTSB ATL81FKJ27Accident · No injuriesClosedAyres S2R · Ft Mitchel, ALNTSB ATL81DKJ26Accident · No injuriesClosedPiper PA-28 · Bessemer, ALNTSB ATL81FA101Accident · 4 fatalClosedCessna 210B · Plantersville, ALNTSB ATL81FKJ25Accident · Serious injuriesClosedCessna 177B · Wetumpka, ALNTSB ATL81FKJ23Accident · No injuriesClosedStinson 108-2 · Huntsville, ALNTSB ATL81FKJ24Accident · 1 fatalClosedPiper J3C-65 · Fadette, ALNTSB ATL81DKJ22Accident · No injuriesClosedHiller Acft UH-12E · Centreville, ALNTSB ATL81FA090Accident · 2 fatalClosedCessna 182M · Haleyville, ALNTSB ATL81FKJ38Accident · Serious injuriesClosedCessna U206 · Elberta, ALNTSB ATL81FA083Accident · 2 fatalClosedPiper PA-38 · Smiths Station, ALNTSB ATL81FKJ21Accident · No injuriesClosedCessna 182RG · Gadsden, ALNTSB ATL81DKJ20Accident · No injuriesClosedCessna 152 · Huntsville, ALNTSB ATL81FA067Accident · No injuriesClosedAdams A50S · Montevallo, ALNTSB ATL81IA065Incident · No injuriesClosedCessna 414 · Montgomery, ALNTSB ATL81DKJ17Accident · Minor injuriesClosedCessna 172 · Maysville, ALNTSB ATL81FKJ16Accident · No injuriesClosedCessna 150 · Ozark, ALNTSB ATL81DKJ14Accident · No injuriesClosedPiper PA-38 · Auburn, ALNTSB ATL81DKJ13Accident · No injuriesClosedPiper PA-38 · Bessemer, ALNTSB ATL81FA052Accident · 4 fatalClosedBeech B23 · Mobile, ALNTSB ATL81FA051Accident · 1 fatalClosedPiper PA-30 · Autaugaville, ALNTSB ATL81FKJ12Accident · No injuriesClosedBeech K35 · Wetumpka, ALNTSB ATL81DKJ11Accident · No injuriesClosedPiper PA-18 · Alabaster, ALNTSB ATL81FKJ10Accident · No injuriesClosedBeech V35TC · Eufaula, ALNTSB ATL81FKJ09Accident · No injuriesClosedPiper PA-32R · Birmingham, ALNTSB ATL81DKJ06Accident · No injuriesClosedCessna 172 · Dothan, ALNTSB ATL81FKJ05Accident · Minor injuriesClosedCessna 185 · Evergreen, AL