NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 MIA66F0355Accident · Minor injuriesClosedCessna 172 · Pine Hall, NCNTSB MIA66F0394Accident · Serious injuriesClosedPiper PA-22 · Wilmington, NCNTSB MIA66A0070Accident · 2 fatalClosedCessna 172C · Castle Hayne, NCNTSB MIA66F0353Accident · No injuriesClosedPiper PA-22 · Greensboro, NCNTSB MIA66F0402Accident · 1 fatalClosedBeechcraft A-23 · Southern Pines, NCNTSB MIA66F0409Accident · No injuriesClosedPiper PA-24 · New Bern, NCNTSB MIA66A0067Accident · No injuriesClosedJodel D1190S · Wilmington, NCNTSB MIA66F0342Accident · No injuriesClosedPiper PA-22 · Wendell, NCNTSB MIA66D0332Accident · No injuriesClosedCessna 210 · Lumberton, NCNTSB MIA66F0324Accident · No injuriesClosedPiper PA-24 · Statesville, NCNTSB MIA66A0061Accident · 1 fatalClosedPiper PA-28 · New Topsail Bc, NCNTSB MIA66F0305Accident · No injuriesClosedPiper PA-18A · Fontana Villge, NCNTSB MIA66F0328Accident · No injuriesClosedCessna 180 · Charlotte, NCNTSB MIA66F0315Accident · Serious injuriesClosedPiper PA-18 · Moriah, NCNTSB MIA66A0056Accident · 3 fatalClosedStinson 108-3 · Lawndale, NCNTSB MIA66D0313Accident · Minor injuriesClosedCessna 182 · Scotland Neck, NCNTSB MIA66F0304Accident · No injuriesClosedBeechcraft D35 · Greensboro, NCNTSB MIA66F0308Accident · No injuriesClosedErcoupe 415C · Spruce Pine, NCNTSB MIA66F0295Accident · No injuriesClosedCessna 205 · Hendersonville, NCNTSB MIA66F0280Accident · Minor injuriesClosedCessna 140 · Shelby, NCNTSB MIA66F0286Accident · No injuriesClosedPiper PA-20 · Charlotte, NCNTSB MIA66F0261Accident · No injuriesClosedBeechcraft D35 · Gastonia, NCNTSB MIA66A0042Accident · Minor injuriesClosedDouglas DC-7 · Charlotte, NCNTSB MIA66D0282Accident · No injuriesClosedPiper PA-20 · No Wilkesboro, NCNTSB MIA66F0253Accident · No injuriesClosedPiper PA-23 · Albemarle, NCNTSB MIA66A0027Accident · No injuriesClosedBell 47D1 · Sligo, NCNTSB MIA66F0211Accident · No injuriesClosedCessna 182 · Shelby, NCNTSB IAD75AI030Accident · 1 fatalClosedCessna 120 · Black Mountain, NCNTSB MIA66F0187Accident · Serious injuriesClosedCessna 170B · Grimesland, NCNTSB MIA66D0189Accident · No injuriesClosedPiper PA-22 · Buies Creek, NCNTSB MIA66F0186Accident · No injuriesClosedPiper PA-22 · High Point, NCNTSB MIA66F0166Accident · No injuriesClosedPiper PA-24 · Jacksonville, NCNTSB MIA66F0165Accident · No injuriesClosedPiper PA-28 · Cove City, NCNTSB MIA66F0162Accident · No injuriesClosedConvair L-13A · Ayden, NCNTSB MIA66A0019Accident · 1 fatalClosedBeechcraft A-35 · Statesville, NCNTSB MIA66F0121Accident · No injuriesClosedBeechcraft 95-55 · Astonia, NCNTSB MIA66F0095Accident · Minor injuriesClosedBeechcraft 23 · Igh P0int, NCNTSB MIA66F0119Accident · No injuriesClosedBeechcraft 23 · Asheville, NCNTSB MIA66F0094Accident · No injuriesClosedMooney M20A · Charlotte, NCNTSB UNK65X1523Accident · Minor injuriesClosedPiper PA-18A · Gumberry, NCNTSB MIA66F0127Accident · No injuriesClosedPiper J3C · Indian Trail, NCNTSB MIA66F0071Accident · Minor injuriesClosedPiper J-3C · Stokesdale, NCNTSB MIA66F0070Accident · No injuriesClosedChampion 7FC · Greensboro, NCNTSB MIA66F0163Accident · Serious injuriesClosedFairchild M62A · Bragtown, NCNTSB MIA66F0052Accident · No injuriesClosedPiper PA-28 · Winston Salem, NCNTSB MIA66F0049Accident · No injuriesClosedPiper PA-18A · Laurinburg, NCNTSB MIA66F0063Accident · Minor injuriesClosedTaylorcraft BC12D · Mineral Sps, NCNTSB MIA66I0005Incident · No injuriesClosedMartin M-404 · Winston Salem, NCNTSB MIA66F0144Accident · Serious injuriesClosedStinson 108 · Booneville, NCNTSB MIA66D0057Accident · No injuriesClosedCessna 210 · Faison, NC