NTSB investigations, 1974, 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\") = 1974
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") = 1974 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 IAD75FLJ16Accident · Minor injuriesClosedCessna 150L · Burlington, NCNTSB IAD75DLJ15Accident · No injuriesClosedBeech 95-B55 · Cape Hatteras, NCNTSB IAD75FLJ14Accident · Minor injuriesClosedCessna 150 · Wilmington, NCNTSB IAD75AI032Accident · 2 fatalClosedCessna 150J · Morganton, NCNTSB IAD75A1031|IAD75AI031Accident · 1 fatalClosedLuscombe 8A · Polkton, NCNTSB IAD75FLJ13Accident · No injuriesClosedCessna 150L · New River, NCNTSB IAD75DKM14Accident · 1 fatalClosedBaby Ace E · Asheville, NCNTSB IAD75DLJ12Accident · No injuriesClosedCessna 177RG · Chapel Hill, NCNTSB IAD75AI028Accident · 1 fatalClosedCessna 172K · Charlotte, NCNTSB IAD75FKM13Accident · Serious injuriesClosedCessna 172M · Statesville, NCNTSB IAD75FLJ11Accident · Minor injuriesClosedCessna 150J · Kenly, NCNTSB IAD75AI026Accident · 2 fatalClosedLuscombe 8E · Stedman, NCNTSB IAD75AI023Accident · 3 fatalClosedPiper PA-23 · Bryson City, NCNTSB IAD75II020Incident · No injuriesClosedDassault Falcon · Southern Pines, NCNTSB IAD75DKM11Accident · No injuriesClosedCessna 177 · Waynesville, NCNTSB IAD75AI017Accident · 1 fatalClosedCessna 140 · Greensboro, NCNTSB IAD75AI015Accident · 2 fatalClosedPiper PA-23 · Pinnacle, NCNTSB IAD75DKM10Accident · No injuriesClosedCessna 172K · Indian Trail, NCNTSB IAD75AI013Accident · 2 fatalClosedPiper PA-28 · Raleigh, NCNTSB IAD75FLJ08Accident · No injuriesClosedCessna A188 · Pollocksville, NCNTSB DCA75AZ009Accident · 71 fatalClosedDouglas DC9-31 · Charlotte, NCNTSB IAD75DLJ02Accident · No injuriesClosedCallair A-9 · Beaulahville, NCNTSB IAD75FLJ10Accident · No injuriesClosedBoeing A75-N1 · Grantham, NCNTSB IAD75AI009Accident · 2 fatalClosedBoeing A75L3 · Waynesville, NCNTSB IAD75DKM09Accident · No injuriesClosedPiper PA-22 · Salisbury, NCNTSB IAD75FLJ09Accident · Minor injuriesClosedCessna 140 · Angier, NCNTSB IAD75AI007Accident · 2 fatalClosedCessna 210 · Duck, NCNTSB IAD75FKM08Accident · Minor injuriesClosedPiper PA-28 · Winston Salem, NCNTSB IAD75DLJ06Accident · Serious injuriesClosedBellanca 14-13 · Fayetteville, NCNTSB IAD75FLJ07Accident · Minor injuriesClosedPiper 28-140 · Raleigh, NCNTSB IAD74DLJ05Accident · No injuriesClosedCessna 150 · Chocowinity, NCNTSB IAD75DLJ04Accident · No injuriesClosedPiper PA-25 · Lagrange, NCNTSB IAD75FIJ03Accident · Serious injuriesClosedCallair A-9 · Rowland, NCNTSB IAD75DKM07Accident · No injuriesClosedPiper PA-30 · Asheville, NCNTSB IAD75AI004Accident · 2 fatalClosedBellanca 7GCBC · Archdale, NCNTSB IAD75DKM06Accident · No injuriesClosedPiper PA-30 · Charlotte, NCNTSB IAD75AI002Accident · 1 fatalClosedCessna 182H · Burnsville, NCNTSB IAD75DKM04Accident · Minor injuriesClosedPiper PA-22 · Monroe, NCNTSB IAD75DKM05Accident · Minor injuriesClosedPiper PA-28 · Lake Lure, NCNTSB IAD75DKM03Accident · No injuriesClosedBell 47G-5 · Charlotte, NCNTSB IAD75DKM02Accident · No injuriesClosedCessna 172 · Advance, NCNTSB IAD75DKM01Accident · Minor injuriesClosedHughes 269A · Shelby, NCNTSB IAD75DLJ01Accident · No injuriesClosedCurtis-Wrt 16 · Gibsonville, NCNTSB IAD74DKM58Accident · Serious injuriesClosedChampion 7KCAB · Laurel Springs, NCNTSB IAD74AI071Accident · 2 fatalClosedCessna 150L · Fayetteville, NCNTSB IAD74DLJ48Accident · No injuriesClosedCessna 150 · Ft Bragg, NCNTSB IAD74DKM57Accident · No injuriesClosedAeronca 11AC · Taylorsville, NCNTSB IAD74DKM59Accident · No injuriesClosedCessna 182 · Statesville, NCNTSB IAD74FKM60Accident · No injuriesClosedBellanca 14-192 · Wallberg, NCNTSB IAD74AI069Accident · 2 fatalClosedHughes 269B · Reidsville, NC