NTSB investigations, 1980, NC
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1980
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") = 1980 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 ATL81DLJ03Accident · Serious injuriesClosedCessna 182G · Apex, NCNTSB ATL81DKM01Accident · No injuriesClosedBaby GR LKS 1 · Greensboro, NCNTSB ATL81FLJ01Accident · No injuriesClosedCessna 152 · Fort Bragg, NCNTSB ATL81DLJ02Accident · No injuriesClosedBensen B8M · Spring Lake, NCNTSB ATL80DKM28Accident · Minor injuriesClosedPiper PA-28 · East Bend, NCNTSB ATL81IA004Incident · No injuriesClosedFairchild F-27 · Raliegh, NCNTSB ATL80DLJ25Accident · Minor injuriesClosedCessna 172 · Zebulon, NCNTSB ATL80DLJ24Accident · No injuriesClosedBeech 23 · Chapel Hill, NCNTSB ATL80FA097Accident · 1 fatalClosedPiper PA-28R · Troy, NCNTSB ATL80DKM27Accident · No injuriesClosedPiper PA-28 · Charlotte, NCNTSB ATL80IA089Incident · No injuriesClosedPiper PA-32 · Raeford, NCNTSB ATL80DKM26Accident · No injuriesClosedDehavilland DHC-1B · Huntersville, NCNTSB ATL80DLJ18Accident · No injuriesClosedCessna 188B · Elizabeth City, NCNTSB ATL80DLJ21Accident · No injuriesClosedPiper PA-25 · Kenly, NCNTSB ATL80FLJ23Accident · No injuriesClosedPiper PA-25 · Hope Mills, NCNTSB ATL80FLJ22Accident · No injuriesClosedGrumman G-164C · Grantham, NCNTSB ATL80FLG18Accident · 1 fatalClosedHughes 269B · Whiteville, NCNTSB ATL80FLJ20Accident · No injuriesClosedCessna 150 · Mebane, NCNTSB ATL80DKM23Accident · Serious injuriesClosedStarduster SA-300 · Horse Shoe, NCNTSB ATL80FA084Accident · 2 fatalClosedBellanca 7KCAB · Lake Norman, NCNTSB ATL80FKM24Accident · Minor injuriesClosedCessna 150 · Bryson City, NCNTSB ATL80DKM22Accident · No injuriesClosedPiper PA-28 · Liberty, NCNTSB ATL80DKM25Accident · Minor injuriesClosedPiper PA-38 · Morganton, NCNTSB ATL80FLJ19Accident · No injuriesClosedCessna 188B · Rowland, NCNTSB ATL80FLJ15Accident · No injuriesClosedPiper PA-38 · Pinehurst, NCNTSB ATL80DA075Accident · No injuriesClosedPiper PA-23 · Banner Elk, NCNTSB ATL80IA062Incident · Minor injuriesClosedDouglas DC-8 · Greensboro, NCNTSB ATL80FLJ17Accident · Minor injuriesClosedBeech B19 · Kinston, NCNTSB ATL80FA051Accident · 2 fatalClosedCessna 172 · Salisbury, NCNTSB ATL80FLJ16Accident · No injuriesClosedCessna A188B · Harlowe, NCNTSB ATL80FLJ14Accident · Minor injuriesClosedQuickie KN05 · Manteo, NCNTSB ATL80FKM20Accident · Minor injuriesClosedBeech TC-45J · Maiden, NCNTSB ATL80DKM19Accident · No injuriesClosedPiper PA-28 · Gastonia, NCNTSB ATL80FLJ13Accident · No injuriesClosedBoeing A75N1 · Wenoma, NCNTSB ATL80DKM18Accident · No injuriesClosedNavion A · Mooresville, NCNTSB ATL80DKM17Accident · No injuriesClosedAeronca 7BCM · Greensboro, NCNTSB IAD80FLJ12Accident · Minor injuriesClosedCessna 182 · Henderson, NCNTSB IAD80FLJ09Accident · Minor injuriesClosedCessna 150 · Richlands, NCNTSB IAD80DKM16Accident · No injuriesClosedCurtis-Wrt D4D · Candor, NCNTSB IAD80FA037Accident · 1 fatalClosedCessna 401 · Linville, NCNTSB IAD80DKM15Accident · Minor injuriesClosedCessna 175 · Morgantown, NCNTSB IAD80DKM14Accident · No injuriesClosedBeech A36 · Albemarle, NCNTSB IAD80DKM13Accident · No injuriesClosedPiper PA-28 · Mayodan, NCNTSB IAD80FA031Accident · 1 fatalClosedPiper PA-30 · Charlotte, NCNTSB IAD80FKM12Accident · Minor injuriesClosedCessna 152 · Mayodan, NCNTSB IAD80DKM11Accident · No injuriesClosedBalloon WKS AX-7 · East Bend, NCNTSB IAD80FLJ11Accident · No injuriesClosedPiper PA-28R · Raleigh Durham, NCNTSB IAD80FLJ10Accident · No injuriesClosedPiper PA-32R · Redford, NCNTSB IAD80FKM10Accident · 1 fatalClosedStits Playby · China Grove, NCNTSB IAD80FA025Accident · 2 fatalClosedCessna 152 · Vale, NC