NTSB investigations, 1976, NC
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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\") = 1976
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") = 1976 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 IAD77DLJ03Accident · No injuriesClosedCessna 180 · Rougemont, NCNTSB IAD77FLJ06Accident · Serious injuriesClosedTaylorcraft BC12-D · Durants Neck, NCNTSB IAD77FLJ01Accident · Minor injuriesClosedPiper PA-23 · Angier, NCNTSB IAD77DKM09Accident · No injuriesClosedPiper PA-28R · Bryson City, NCNTSB IAD77DKM08Accident · Minor injuriesClosedStarduster T00 · Gastonia, NCNTSB IAD77DKM07Accident · No injuriesClosedCessna 182 · Hickory, NCNTSB IAD77FA015Accident · 4 fatalClosedCessna 210 · Oxford, NCNTSB IAD77FA013Accident · 3 fatalClosedCessna 310 · Black Mountain, NCNTSB IAD77FA012Accident · 4 fatalClosedPiper PA-28 · Wise, NCNTSB IAD77FLJ05Accident · Minor injuriesClosedCessna 150 · Woodland, NCNTSB IAD77DKM06Accident · No injuriesClosedCessna 150 · Banner Elk, NCNTSB IAD77DKM04Accident · No injuriesClosedCessna 182 · Gastonia, NCNTSB IAD77FA009Accident · 2 fatalClosedBellanca 17-30A · Nakina, NCNTSB IAD77DKM05Accident · No injuriesClosedCessna 172 · Wadesboro, NCNTSB IAD77FKM03Accident · 3 fatalClosedBalloon 1 · Charlotte, NCNTSB IAD77IA006Incident · No injuriesClosedMitsubishi MU-2K · Charlotte, NCNTSB IAD77FLJ02Accident · No injuriesClosedHiller UH-12D · Morrisville, NCNTSB IAD77DKM02Accident · No injuriesClosedCessna 172 · Bryson City, NCNTSB IAD77FA004Accident · No injuriesClosedPiper PA-32R · Wilmington, NCNTSB IAD77FA005Accident · 4 fatalClosedPiper PA-34 · Busick, NCNTSB IAD76FKM01Accident · No injuriesClosedPiper PA-25 · Charlotte, NCNTSB IAD76FKM47Accident · No injuriesClosedPiper PA-30 · Charlotte, NCNTSB IAD76II100Incident · No injuriesClosedDouglas DC-3C · Gastonia, NCNTSB IAD76FLJ38Accident · Serious injuriesClosedErcoupe 415C · Magnolia, NCNTSB IAD76FLJ28Accident · No injuriesClosedCessna A188B · Battleboro, NCNTSB IAD76FLJ37Accident · No injuriesClosedBeech A23 · Beaufort, NCNTSB IAD76DKM46Accident · No injuriesClosedCessna 150 · Ashville, NCNTSB IAD76DKM45Accident · Minor injuriesClosedCessna 170A · Concord, NCNTSB IAD76FLJ35Accident · No injuriesClosedCessna 188B · Dunn, NCNTSB IAD76FLJ34Accident · No injuriesClosedPiper PA-18A · Lagrange, NCNTSB IAD76AI095Accident · 1 fatalClosedPiper PA-22 · Mooresville, NCNTSB IAD76DKM44Accident · No injuriesClosedPiper PA-24 · Waynesville, NCNTSB IAD76FLJ33Accident · No injuriesClosedCessna 172 · Apex, NCNTSB IAD76AI092Accident · 5 fatalClosedCessna 172K · Bryson City, NCNTSB IAD76AI088Accident · 1 fatalClosedPiper J3C · Troy, NCNTSB IAD76II087Incident · No injuriesClosedCessna 402A · Charlotte, NCNTSB IAD76FLJ32Accident · No injuriesClosedStinson 108 · Durham, NCNTSB IAD76DKM42Accident · Minor injuriesClosedCessna 150 · Bessemer City, NCNTSB IAD76DKM40Accident · No injuriesClosedPiper PA-30 · Boone, NCNTSB IAD76FLJ31Accident · No injuriesClosedCessna 177 · Wilson, NCNTSB IAD76FKM41Accident · Serious injuriesClosedPiper PA-28 · Asheboro, NCNTSB IAD76FKM43Accident · No injuriesClosedM-Saulnier MS894A · Cliffside, NCNTSB IAD76AI082Accident · 3 fatalClosedBellanca 17-31A · Jacksonville, NCNTSB IAD76AI080Accident · 1 fatalClosedCessna 182M · Beaufort, NCNTSB IAD76AI078Accident · 1 fatalClosedCessna 172 · St Pauls, NCNTSB IAD76FLJ26Accident · Serious injuriesClosedScamp WT16 · Holly Springs, NCNTSB IAD76FKM39Accident · Minor injuriesClosedPiper PA-23 · Huntersville, NCNTSB IAD76DKM38Accident · No injuriesClosedCessna 310 · Greensboro, NCNTSB IAD76FLJ25Accident · No injuriesClosedCessna 402B · Wilmington, NCNTSB IAD76DKM37Accident · No injuriesClosedGrum Amer AA-5 · Rutherfordton, NC