Skip to content

NTSB investigations, 1981, GA

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1981, GA per year, 1962–2026: 4,090 cases
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	26

Where

Latest cases

Query with SQL

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") = 1981 AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1981
    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") = 1981
  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 ATL82FKG08Accident · Minor injuriesClosedPiper PA-32 · Jefferson, GADec 10, 1981 · N4066W · Substantial damage NTSB ATL82FA023Accident · 2 fatalClosedCessna 310K · Gainsville, GADec 1, 1981 · N6943L · Destroyed NTSB ATL82FA022Accident · 1 fatalClosedCessna 206 · Pine Mountain, GANov 27, 1981 · N4617F · Destroyed NTSB ATL82FA017Accident · 1 fatalClosedPiper PA-28 · Savannah, GANov 14, 1981 · N8569E · Substantial damage NTSB ATL82FKG07Accident · No injuriesClosedGrumm Amer AA-5B · Blue Ridge, GANov 8, 1981 · N1508R · Substantial damage NTSB ATL82FKG06Accident · Minor injuriesClosedEnstrom 280C · Savannah, GANov 7, 1981 · N5700L · Substantial damage NTSB ATL81FKG05Accident · No injuriesClosedHughes 269C · Atlanta, GAOct 31, 1981 · N8659F · Substantial damage NTSB ATL82FKG04Accident · No injuriesClosedPiper PA-28 · Swainsboro, GAOct 29, 1981 · N702FL · Destroyed NTSB ATL82FKG03Accident · Minor injuriesClosedCessna 150F · Columbus, GAOct 28, 1981 · N8808G · Destroyed NTSB ATL82FLA02Accident · No injuriesClosedMooney M20C · Folkston, GAOct 16, 1981 · N9244V · Substantial damage NTSB ATL82FKG02Accident · No injuriesClosedPiper PA-28 · Stone Mountain, GAOct 16, 1981 · N15101 · Substantial damage NTSB ATL82DA007Accident · No injuriesClosedCessna 340 · Waycross, GAOct 14, 1981 · N2701A · 2 aircraft · Minor damage NTSB ATL82FKG01Accident · Serious injuriesClosedHughes 369D · Savannah, GAOct 7, 1981 · N444HM · Substantial damage NTSB ATL81FA118Accident · Serious injuriesClosedHughes 369A · Atlanta, GASep 30, 1981 · N3766Z · Substantial damage NTSB ATL81DLA15Accident · No injuriesClosedGrumman G-164B · Pelham, GASep 26, 1981 · N6670K · Substantial damage NTSB ATL81DLA14Accident · No injuriesClosedRockwell S-2R · Pelham, GASep 19, 1981 · N8469V · Substantial damage NTSB ATL81FKG47Accident · No injuriesClosedChampion 7AC · Stone Mountain, GASep 13, 1981 · N3118E · Substantial damage NTSB ATL81DKG48Accident · No injuriesClosedPiper PA-18 · Williamson, GASep 12, 1981 · N4083Z · Substantial damage NTSB ATL81FA112Accident · 3 fatalClosedCessna 172K · Philomath, GASep 4, 1981 · N758EQ · Destroyed NTSB ATL81FKG46Accident · Minor injuriesClosedCessna 310 · Abbeville, GASep 1, 1981 · N3093D · Substantial damage NTSB ATL81DLA11Accident · Minor injuriesClosedBell 47G-2 · Quitman, GAAug 31, 1981 · N2508 · Substantial damage NTSB ATL81DKG45Accident · No injuriesClosedBeech 58 · Savannah, GAAug 31, 1981 · N124P · Substantial damage NTSB ATL81DKG44Accident · Serious injuriesClosedPiper PA-25 · Fort Valley, GAAug 25, 1981 · N8689L · Destroyed NTSB ATL81DLA13Accident · No injuriesClosedHughes 269A-1 · Sale City, GAAug 15, 1981 · N8935F · Substantial damage NTSB ATL81FA108Accident · 5 fatalClosedAero Comdr 685 · Wrens, GAAug 14, 1981 · N8007H · Destroyed NTSB ATL81FKG43Accident · Minor injuriesClosedGulf Amer AA-5A · Savannah, GAAug 12, 1981 · N26748 · Substantial damage NTSB ATL81FLA12Accident · No injuriesClosedCessna 404 · St Simons Is, GAAug 11, 1981 · N2684L · Destroyed NTSB ATL81FKG42Accident · No injuriesClosedPiper PA-25 · Cochran, GAAug 11, 1981 · N9646P · Substantial damage NTSB ATL81FKG40Accident · Minor injuriesClosedGrumman G-164 · Hazlehurst, GAAug 10, 1981 · N6737Q · Destroyed NTSB ATL81FA106Accident · 4 fatalClosedPiper PA-28 · Camilla, GAAug 9, 1981 · N8470F · Destroyed NTSB ATL81FKG41Accident · Minor injuriesClosedCessna A188B · Sylvania, GAAug 7, 1981 · N731WY · Destroyed NTSB ATL81DKG38Accident · No injuriesClosedCessna A188B · Pitts, GAAug 4, 1981 · N8900G · Substantial damage NTSB ATL81DKG37Accident · No injuriesClosedGrumman G-164B · Preston, GAAug 3, 1981 · N48501 · Destroyed NTSB ATL81FKG36Accident · No injuriesClosedPiper J-3 · Jonesboro, GAAug 2, 1981 · N3559N · Destroyed NTSB ATL81FA105Accident · 1 fatalClosedGrum Amer AA-5B · Baxley, GAAug 1, 1981 · N28401 · Destroyed NTSB ATL81FKG39Accident · No injuriesClosedPiper PA-36 · Kildare, GAJul 29, 1981 · N57865 · Substantial damage NTSB ATL81FKG35Accident · No injuriesClosedCessna 172G · Louisville, GAJul 26, 1981 · N65WB · Substantial damage NTSB ATL81FKG33Accident · No injuriesClosedCessna 182 · Abbeville, GAJul 18, 1981 · N7379Q · Substantial damage NTSB ATL81FLA09Accident · No injuriesClosedMooney M20C · Thomasville, GAJul 17, 1981 · N5832Q · Substantial damage NTSB ATL81DLA10Accident · No injuriesClosedCessna 188B · Coolidge, GAJul 17, 1981 · N6298G · Substantial damage NTSB ATL81DKG34Accident · Minor injuriesClosedCessna 140 · Dahlonega, GAJul 17, 1981 · N72966 · Destroyed NTSB ATL81DKG32Accident · Serious injuriesClosedPiper PA-22 · Griffin, GAJul 14, 1981 · N3919P · Substantial damage NTSB ATL81FKG31Accident · Serious injuriesClosedCessna 177 · Cummings, GAJul 10, 1981 · N3421T · Destroyed NTSB ATL81FA093Accident · 1 fatalClosedCessna 411 · Columbus, GAJul 9, 1981 · N7007R · Destroyed NTSB ATL81FA092Accident · 3 fatalClosedPiper PA-28 · Eatonton, GAJul 8, 1981 · N6452J · 2 aircraft · Destroyed NTSB ATL81FA091Accident · Minor injuriesClosedCessna 150H · Toccoa, GAJul 7, 1981 · N22353 · Destroyed NTSB ATL81FKG30Accident · No injuriesClosedCessna 172N · Lexington, GAJul 6, 1981 · N2776E · Substantial damage NTSB ATL81FA089Accident · Minor injuriesClosedCessna 152 · Decatur, GAJul 6, 1981 · N67312 · Destroyed NTSB ATL81FA088Accident · 1 fatalClosedPiper PA-28R · Beach, GAJul 4, 1981 · N4512J · Destroyed NTSB ATL81FLA08Accident · 1 fatalClosedCallair A-9A · Blakely, GAJun 27, 1981 · N8247H · Destroyed