NTSB investigations, 1981, NC
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 | 3 |
|---|---|
| 1963 | 2 |
| 1964 | 102 |
| 1965 | 83 |
| 1966 | 81 |
| 1967 | 101 |
| 1968 | 85 |
| 1969 | 77 |
| 1970 | 67 |
| 1971 | 86 |
| 1972 | 89 |
| 1973 | 118 |
| 1974 | 100 |
| 1975 | 90 |
| 1976 | 76 |
| 1977 | 77 |
| 1978 | 77 |
| 1979 | 52 |
| 1980 | 59 |
| 1981 | 47 |
| 1982 | 59 |
| 1983 | 56 |
| 1984 | 53 |
| 1985 | 51 |
| 1986 | 60 |
| 1987 | 47 |
| 1988 | 52 |
| 1989 | 52 |
| 1990 | 48 |
| 1991 | 52 |
| 1992 | 50 |
| 1993 | 37 |
| 1994 | 52 |
| 1995 | 39 |
| 1996 | 32 |
| 1997 | 49 |
| 1998 | 35 |
| 1999 | 38 |
| 2000 | 42 |
| 2001 | 40 |
| 2002 | 37 |
| 2003 | 38 |
| 2004 | 27 |
| 2005 | 42 |
| 2006 | 39 |
| 2007 | 37 |
| 2008 | 33 |
| 2009 | 37 |
| 2010 | 31 |
| 2011 | 37 |
| 2012 | 28 |
| 2013 | 30 |
| 2014 | 29 |
| 2015 | 44 |
| 2016 | 25 |
| 2017 | 34 |
| 2018 | 24 |
| 2019 | 29 |
| 2020 | 30 |
| 2021 | 41 |
| 2022 | 30 |
| 2023 | 34 |
| 2024 | 33 |
| 2025 | 22 |
| 2026 | 27 |
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\" = 'NC' 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" = 'NC' 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 ATL82FA030Accident · 2 fatalClosedPiper PA-32R · Wallace, NCNTSB ATL82FLJ03Accident · 1 fatalClosedDabbs B8M · Garland, NCNTSB ATL82FA014Accident · 1 fatalClosedBalzer DSK-1 · Washington, NCNTSB ATL82FLJ02Accident · Serious injuriesClosedPiper PA-24 · Chapel Hill, NCNTSB ATL82FLJ01Accident · Minor injuriesClosedCessna 150J · Knightdale, NCNTSB ATL82FKM01Accident · Minor injuriesClosedCessna R182 · West Jefferson, NCNTSB ATL82FKM02Accident · No injuriesClosedGR Lakes 2T-1A2 · Pinnacle, NCNTSB ATL82IA003Incident · No injuriesClosedBoeing 737 · Greensboro, NCNTSB ATL81FLJ18Accident · Serious injuriesClosedCessna P206E · Wilmar, NCNTSB ATL81FLJ17Accident · 1 fatalClosedCessna 188B · Edenton, NCNTSB ATL81FLJ16Accident · Serious injuriesClosedScorpion 145 · Garner, NCNTSB ATL81FA111Accident · 2 fatalClosedMooney M20C · Thomasville, NCNTSB ATL81DLJ15Accident · No injuriesClosedCessna 188 · Newton Grove, NCNTSB ATL81FLJ14Accident · Minor injuriesClosedCessna 172N · Roxboro, NCNTSB ATL81DLJ13Accident · No injuriesClosedPiper PA-28 · Salvo, NCNTSB ATL81FA098Accident · 1 fatalClosedPiper PA-28 · Buckland, NCNTSB ATL81FA095Accident · Serious injuriesClosedCessna 172L · Banner Elk, NCNTSB ATL81FKM14Accident · Serious injuriesClosedPiper PA-32R · Asheville, NCNTSB ATL81FA094Accident · 1 fatalClosedPiper PA-31P · Wilmington, NCNTSB ATL81DLJ12Accident · No injuriesClosedCessna 188A · Bayboro, NCNTSB ATL81FLJ11Accident · Minor injuriesClosedErco 415-E · Southport, NCNTSB ATL81DLJ10Accident · No injuriesClosedCessna 150M · Farmville, NCNTSB ATL81FLJ09Accident · Serious injuriesClosedCessna 172K · Conetoe, NCNTSB ATL81DLJ08Accident · No injuriesClosedCessna 150 · Knightdale, NCNTSB ATL81DKM13Accident · No injuriesClosedPiper PA-28 · Charlotte, NCNTSB ATL81FA080Accident · 1 fatalClosedPiper PA-22 · Chapel Hill, NCNTSB ATL81DLJ07Accident · Minor injuriesClosedPiper PA-28 · Windsor, NCNTSB ATL81DKM12Accident · No injuriesClosedCessna 172M · Concord, NCNTSB ATL81FKM11Accident · Serious injuriesClosedTaylorcraft BC-12D · Indian Trail, NCNTSB ATL81DKM10Accident · No injuriesClosedCessna 170 · Mocksville, NCNTSB ATL81FLJ06Accident · No injuriesClosedPiper PA-34 · Raleigh, NCNTSB ATL81FA069Accident · 1 fatalClosedCessna 337G · Greensboro, NCNTSB ATL81DKM09Accident · No injuriesClosedMooney M20C · Asheboro, NCNTSB ATL81DKM08Accident · Minor injuriesClosedCessna 172A · Maiden, NCNTSB ATL81IA064Incident · No injuriesClosedNamc YS-11 · Charlotte, NCNTSB ATL81DKM07Accident · Minor injuriesClosedBeech C23 · Greensboro, NCNTSB ATL81DKM06Accident · No injuriesClosedPiper PA-28 · Shiloh, NCNTSB ATL81FLJ05Accident · Minor injuriesClosedCessna 172M · Belhaven, NCNTSB ATL81FKM05Accident · No injuriesClosedPiper PA-28 · Long Island, NCNTSB ATL81FA056Accident · 1 fatalClosedCessna 182 · Raeford, NCNTSB ATL81FA054Accident · 2 fatalClosedCessna 182P · Jefferson, NCNTSB ATL81DKM04Accident · No injuriesClosedPiper PA-22 · Morganton, NCNTSB ATL81FA050Accident · 1 fatalClosedPiper PA-28 · Statesville, NCNTSB ATL81FKM03Accident · No injuriesClosedCessna 152 · Bear Creek, NCNTSB ATL81FA043Accident · 7 fatalClosedCessna 340A · Chapel Hill, NCNTSB ATL81FLJ04Accident · Minor injuriesClosedStinson 108 · Havelock, NCNTSB ATL81DKM02Accident · No injuriesClosedCessna 210 · Marion, NC