NTSB investigations, 1966, NC
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1966
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") = 1966 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 MIA67F0335Accident · No injuriesClosedPiper PA-28 · Pikeville, NCNTSB DIA67D0004Accident · No injuriesClosedCessna 172 · Long Beach, NCNTSB MIA67D0328Accident · No injuriesClosedMooney M20E · Chapel Hill, NCNTSB MIA67D0280Accident · No injuriesClosedMooney M20E · Ramseur, NCNTSB MIA67A0058Accident · 3 fatalClosedMartin M-404 · New Bern, NCNTSB MIA67F0266Accident · Minor injuriesClosedPiper PA-12 · Whitsett, NCNTSB MIA67A0284Accident · No injuriesClosedBeech P35 · Eagle Springs, NCNTSB MIA67F0233Accident · Minor injuriesClosedBeech F35 · Rutherfordton, NCNTSB MIA67A0051Accident · 1 fatalClosedBensen B8M · Morrisville, NCNTSB MIA67F0218Accident · No injuriesClosedBoeing IB75A · Palmyra, NCNTSB MIA67F0229Accident · No injuriesClosedDehaviland DH104 · Charlotte, NCNTSB MIA67F0199Accident · No injuriesClosedCessna 120 · Morganton, NCNTSB MIA67D0206Accident · No injuriesClosedMooney M20C · Wilkesbord, NCNTSB MIA67F0183Accident · No injuriesClosedMooney M20E · Buies Creek, NCNTSB MIA67D0238Accident · No injuriesClosedCessna 182J · Wallace, NCNTSB MIA67A0037Accident · 4 fatalClosedCessna 170A · N.Wilkesboro, NCNTSB MIA67F0198Accident · No injuriesClosedPiper PA-24 · Charlotte, NCNTSB MIA67F0230Accident · 1 fatalClosedPiper PA-18 · Aurora, NCNTSB MIA67F0156Accident · No injuriesClosedTaylorcraft BL-55 · Rutherfordton, NCNTSB MIA67D0243Accident · No injuriesClosedCessna 182E · Manteo, NCNTSB MIA67F0157Accident · No injuriesClosedPiper J3C-65 · Sanford, NCNTSB MIA67D0137Accident · Minor injuriesClosedCessna 150E · Cherokee, NCNTSB MIA67F0147Accident · No injuriesClosedAlon A-2 · Jacksonville, NCNTSB MIA67A0033Accident · 4 fatalClosedMooney M20E · Andrews, NCNTSB MIA67D0174Accident · No injuriesClosedPiper PA-24 · Bryson City, NCNTSB MIA67F0102Accident · No injuriesClosedBeech D50 · Charlotte, NCNTSB MIA67F0071Accident · No injuriesClosedCessna 182 · Charlotte, NCNTSB MIA67D0099Accident · No injuriesClosedLear Jet 23 · Manteo, NCNTSB MIA67F0084Accident · No injuriesClosedErcoupe 415-C · Greensboro, NCNTSB MIA67D0087Accident · No injuriesClosedPiper PA-24 · Beaufort, NCNTSB MIA67A0015Accident · 2 fatalClosedMooney M20C · Jacksonville, NCNTSB MIA67A0014Accident · 1 fatalClosedAir Space 18A · Arden, NCNTSB MIA67D0088Accident · Minor injuriesClosedAlon A-2 · Washington, NCNTSB MIA67A0008Accident · 1 fatalClosedPiper J3C-65 · Burlington, NCNTSB MIA67F0058Accident · No injuriesClosedBeech D18S · Winston Salem, NCNTSB MIA67F0010Accident · Minor injuriesClosedCessna 210D · Selma, NCNTSB MIA67F0011Accident · No injuriesClosedCessna 150 · Clinton, NCNTSB MIA67A0002Accident · 4 fatalClosedFairchild 24W · Banner Elk, NCNTSB MIA67F0005Accident · No injuriesClosedPiper J3 · Erwin, NCNTSB MIA67D0063Accident · No injuriesClosedPiper PA-22 · Lewisburg, NCNTSB MIA67F0003Accident · No injuriesClosedAeronca 7FC · Greensboro, NCNTSB MIA67D0001Accident · No injuriesClosedCessna 182A · Lake Lure, NCNTSB MIA66D0628Accident · No injuriesClosedCessna 172 · Bakersville, NCNTSB MIA67F0005Accident · No injuriesClosedTaylorcraft BC12D · Mooresville, NCNTSB MIA67A0152Accident · 2 fatalClosedCessna 172 · Hatteras, NCNTSB MIA66F0615Accident · Minor injuriesClosedWaco UPF7 · Mooresville, NCNTSB MIA66D0616Accident · No injuriesClosedPiper PA28 · Statesville, NCNTSB MIA66D0612Accident · No injuriesClosedCessna 172 · High Point, NCNTSB MIA67F0006Accident · Minor injuriesClosedPiper PA12 · China Grove, NCNTSB MIA66D0619Accident · No injuriesClosedBeech E18S · Hatteras, NC