NTSB investigations, 1976, GA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 | 1 |
|---|---|
| 1963 | 2 |
| 1964 | 77 |
| 1965 | 114 |
| 1966 | 113 |
| 1967 | 140 |
| 1968 | 101 |
| 1969 | 126 |
| 1970 | 117 |
| 1971 | 131 |
| 1972 | 142 |
| 1973 | 89 |
| 1974 | 117 |
| 1975 | 77 |
| 1976 | 103 |
| 1977 | 113 |
| 1978 | 120 |
| 1979 | 95 |
| 1980 | 92 |
| 1981 | 83 |
| 1982 | 82 |
| 1983 | 84 |
| 1984 | 79 |
| 1985 | 75 |
| 1986 | 56 |
| 1987 | 63 |
| 1988 | 61 |
| 1989 | 51 |
| 1990 | 60 |
| 1991 | 61 |
| 1992 | 54 |
| 1993 | 38 |
| 1994 | 49 |
| 1995 | 47 |
| 1996 | 48 |
| 1997 | 49 |
| 1998 | 54 |
| 1999 | 38 |
| 2000 | 42 |
| 2001 | 49 |
| 2002 | 49 |
| 2003 | 51 |
| 2004 | 46 |
| 2005 | 32 |
| 2006 | 44 |
| 2007 | 54 |
| 2008 | 49 |
| 2009 | 47 |
| 2010 | 48 |
| 2011 | 44 |
| 2012 | 39 |
| 2013 | 30 |
| 2014 | 34 |
| 2015 | 33 |
| 2016 | 42 |
| 2017 | 35 |
| 2018 | 35 |
| 2019 | 39 |
| 2020 | 36 |
| 2021 | 37 |
| 2022 | 42 |
| 2023 | 37 |
| 2024 | 44 |
| 2025 | 24 |
| 2026 | 28 |
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\" = 'GA' 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" = 'GA' 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 MIA77FKG14Accident · Serious injuriesClosedPiper PA-28 · Cleveland, GANTSB MIA77DKG10Accident · No injuriesClosedCessna 150F · Elberton, GANTSB MIA77FKG12Accident · Serious injuriesClosedPiper J3 · Greensboro, GANTSB MIA77FKG09Accident · No injuriesClosedPiper PA-30 · Macon, GANTSB MIA77DKG13Accident · No injuriesClosedGrum Amer AA-5 · Fairmont, GANTSB MIA77FKG11Accident · No injuriesClosedCessna U206A · Palmetto, GANTSB MIA77FKG01Accident · No injuriesClosedCessna 210L · Marietta, GANTSB MIA77DKG08Accident · No injuriesClosedBell 47D1 · Vanceville, GANTSB MIA77FA012Accident · 2 fatalClosedCessna 182P · Savannah, GANTSB MIA77FKG07Accident · No injuriesClosedAero Comdr 500B · Savannah, GANTSB MIA77DKG06Accident · No injuriesClosedErco 415-D · St.Mary'S, GANTSB MIA77FA005Accident · 1 fatalClosedCessna R172E · Jonesboro, GANTSB MIA77DKG05Accident · No injuriesClosedGrumman G-164 · Midville, GANTSB MIA77FKG04Accident · No injuriesClosedGlobe GC-1B · Zebulon, GANTSB MIA77FA001Accident · 2 fatalClosedCessna 210L · Villanow, GANTSB MIA77FKG03Accident · No injuriesClosedBeech B55 · Atlanta, GANTSB MIA77DKG02Accident · No injuriesClosedPiper PA-32 · Valdosta, GANTSB MIA76FKH11Accident · No injuriesClosedCessna 180 · Fort Valley, GANTSB MIA76DKH10Accident · No injuriesClosedStearman A75N1 · Albany, GANTSB MIA76FKH09Accident · No injuriesClosedGrum Amer AA-1B · Brooks, GANTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GANTSB MIA76FKH07Accident · No injuriesClosedCessna 150 · Stone Mountain, GANTSB MIA76FKH05Accident · Minor injuriesClosedPiper J3C-65 · Atlanta, GANTSB MIA76FKH06Accident · Minor injuriesClosedCessna 177RG · Dahonega, GANTSB MIA76DKH04Accident · Minor injuriesClosedCessna 188B · Quitman, GANTSB MIA76DKH03Accident · Minor injuriesClosedNavion L17B · Kennesaw, GANTSB MIA76DKH02Accident · Minor injuriesClosedWeatherly 201B · Shellman, GANTSB MIA76FKH01Accident · No injuriesClosedBell 47 · Augusta, GANTSB MIA76FKG99Accident · Minor injuriesClosedPiper PA-25 · Albany, GANTSB MIA76FKG98Accident · Serious injuriesClosedCessna 172 · Shannon, GANTSB MIA76FKG96Accident · No injuriesClosedBoeing B-17G · Cordele, GANTSB MIA76FKG97Accident · Minor injuriesClosedCessna 310F · Columbus, GANTSB MIA76DKG95Accident · No injuriesClosedCessna 188 · Albany, GANTSB MIA76AM102Accident · 1 fatalClosedAero Comdr 680T · Alapaha, GANTSB MIA76FKG93Accident · 1 fatalClosedCessna A188B · Waynesboro, GANTSB MIA76FKG94Accident · Minor injuriesClosedBoeing B-17G · Rochelle, GANTSB MIA76AM100Accident · Serious injuriesClosedBoeing 727 · Atlanta, GANTSB MIA76AM099Accident · 1 fatalClosedAero Comdr 100 · Donaldsonville, GANTSB MIA76FKG91Accident · 1 fatalClosedPiper PA-36 · Blakely, GANTSB MIA76FKG90Accident · Minor injuriesClosedCessna 188 · Butler, GANTSB MIA76FKG91Accident · No injuriesClosedCessna 182M · Hampton, GANTSB MIA76DKG89Accident · No injuriesClosedCessna 150 · Gainesville, GANTSB MIA76FKG88Accident · No injuriesClosedGrumman G-164A · Hatley, GANTSB MIA76DKG87Accident · No injuriesClosedCessna 188B · Hawkinsville, GANTSB MIA76DKG86Accident · No injuriesClosedPiper PA-25 · Americus, GANTSB MIA76FKG85Accident · No injuriesClosedPiper PA-36 · Blakely, GANTSB MIA76DKG84Accident · No injuriesClosedAero-Comdr 600S2R · Albany, GANTSB MIA76AM076Accident · 1 fatalClosedPiper J3C-65 · Cartersville, GANTSB MIA76AM095Accident · 1 fatalClosedCessna 337B · Augusta, GANTSB MIA76FKG83Accident · No injuriesClosedPiper PA-28 · Ochlocknee, GA