Skip to content

NTSB investigations, 1973, GA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1973, GA per year, 1962–2026: 4,091 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	27

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") = 1973 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\") = 1973
    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") = 1973
  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 MIA74FKG48Accident · Minor injuriesClosedCessna 150L · Tifton, GADec 31, 1973 · N5389Q · Destroyed NTSB MIA74FKG47Accident · Serious injuriesClosedAeronca 7AC · Dalton, GADec 14, 1973 · N83556 · Substantial damage NTSB MIA74FKG46Accident · Minor injuriesClosedCessna 140 · Savannah, GADec 3, 1973 · N2220N · Substantial damage NTSB MIA74FKG45Accident · No injuriesClosedAeronca L-16 · Brunswick, GANov 30, 1973 · N2554B · Substantial damage NTSB MIA74DKG44Accident · No injuriesClosedCessna 172 · Covington, GANov 24, 1973 · N6910X · Substantial damage NTSB MIA74AM043Accident · 2 fatalClosedBeech E55 · Decatur, GANov 16, 1973 · N3917A · Destroyed NTSB MIA74FLG15Accident · No injuriesClosedMeyers 200B · Savannah, GANov 14, 1973 · N357CE · Substantial damage NTSB MIA74FKG43Accident · No injuriesClosedN.American 600S2R · Albany, GANov 14, 1973 · N5645X · Substantial damage NTSB MIA74FKG42Accident · No injuriesClosedCessna 150 · Atlanta, GANov 12, 1973 · N6662F · Substantial damage NTSB MIA74FKG38Accident · No injuriesClosedRoberts Bandit · Rocky Face, GAOct 25, 1973 · N71DR · Substantial damage NTSB MIA74DKG40Accident · No injuriesClosedCessna 172L · Thomson, GAOct 23, 1973 · N4277Q · Substantial damage NTSB MIA74FKG39Accident · No injuriesClosedAero Comdr 680-FL · Kennesaw, GAOct 20, 1973 · N347R · Substantial damage NTSB MIA74FKG41Accident · No injuriesClosedHughes 269A · Hartwell, GAOct 15, 1973 · N8917F · Substantial damage NTSB MIA74DKG36Accident · No injuriesClosedPiper PA-24 · Gainesville, GAOct 7, 1973 · N7329F · Substantial damage NTSB MIA74FKG44Accident · No injuriesClosedEnstrom F-28A · Atlanta, GAOct 3, 1973 · N4870 · Substantial damage NTSB MIA74FKG33Accident · No injuriesClosedGrumman G-164A · Quitman, GASep 27, 1973 · N7833 · Substantial damage NTSB MIA74FKG32Accident · Minor injuriesClosedCessna 414 · Perry, GASep 26, 1973 · N816TP · Destroyed NTSB MIA74FKG31Accident · No injuriesClosedCessna 182 · Waresboro, GASep 26, 1973 · N2912Y · Substantial damage NTSB MIA74FKG30Accident · 1 fatalClosedAero Comdr A-9B · Jordan, GASep 22, 1973 · N7664V · Destroyed NTSB MIA74DKG37Accident · No injuriesClosedBellanca 7ECA · Statesboro, GASep 20, 1973 · N5195T · Substantial damage NTSB MIA74DKG35Accident · No injuriesClosedBeech H35 · Albany, GASep 18, 1973 · N8317D · Substantial damage NTSB MIA74FKG29Accident · Serious injuriesClosedCessna 150G · Jonesboro, GASep 17, 1973 · N2218J · Substantial damage NTSB MIA74DKG28Accident · No injuriesClosedPiper PA-25 · Cochran, GASep 17, 1973 · N4682Y · Substantial damage NTSB MIA74FKG27Accident · No injuriesClosedAero Comdr S-2R · Smithville, GASep 11, 1973 · N8902Q · Substantial damage NTSB MIA74FKG25Accident · No injuriesClosedCessna 172G · Prattsburg, GASep 9, 1973 · N5863R · Substantial damage NTSB MIA74FKG24Accident · Minor injuriesClosedBeech B35 · Bainbridge, GASep 9, 1973 · N5555K · Substantial damage NTSB MIA74FKG26Accident · Minor injuriesClosedCessna 140 · Stockbridge, GASep 8, 1973 · N76217 · Destroyed NTSB MIA74FKG23Accident · No injuriesClosedPiper PA-30 · Sylvania, GASep 2, 1973 · N7902Y · Substantial damage NTSB MIA74FKG22Accident · No injuriesClosedRyan ST3KR · Villa Rica, GASep 2, 1973 · N46751 · Substantial damage NTSB MIA74FKG21Accident · No injuriesClosedCessna 172F · Jasper, GASep 1, 1973 · N7870U · Substantial damage NTSB MIA74FKG19Accident · 1 fatalClosedBoeing A75 · Cordele, GAAug 25, 1973 · N1515M · Destroyed NTSB MIA74FKG18Accident · Serious injuriesClosedAero Comdr S2R · Pineview, GAAug 24, 1973 · N8920Q · Destroyed NTSB MIA74FKG15Accident · Minor injuriesClosedPiper PA-22 · Atlanta, GAAug 22, 1973 · N5617Z · Substantial damage NTSB MIA74FKG16Accident · No injuriesClosedAero Comdr A-9B · Statesboro, GAAug 20, 1973 · N7661V · Destroyed NTSB MIA74FKG14Accident · No injuriesClosedGlobe GC-1B · Cordele, GAAug 20, 1973 · N7CE · Substantial damage NTSB MIA74DKG13Accident · No injuriesClosedGrumman G-164A · Perry, GAAug 16, 1973 · N7996 · Substantial damage NTSB MIA74FKG20Accident · No injuriesClosedPiper PA-30 · Jesup, GAAug 12, 1973 · N7695Y · Substantial damage NTSB MIA74DKG11Accident · No injuriesClosedCessna 140 · Thomaston, GAAug 12, 1973 · N77166 · Substantial damage NTSB MIA74DKG17Accident · No injuriesClosedCessna 188 · Cochran, GAAug 11, 1973 · N5657J · Substantial damage NTSB MIA74FKG10Accident · No injuriesClosedAero Comdr A-9B · Pitts, GAAug 10, 1973 · N7746V · Substantial damage NTSB MIA74AM016Accident · 1 fatalClosedBeech 23 · Fitzgerald, GAAug 4, 1973 · N2386L · Destroyed NTSB MIA74AM011Accident · 2 fatalClosedPiper PA-28R · Nahunta, GAAug 1, 1973 · N10JJ · Destroyed NTSB MIA74AM009Accident · 4 fatalClosedBeech V35A · Georgetown, GAJul 27, 1973 · N7623N · Destroyed NTSB MIA74DKG07Accident · No injuriesClosedCessna 172 · St.Simons Isle, GAJul 22, 1973 · N20181 · Substantial damage NTSB MIA74FKG06Accident · No injuriesClosedBeech G18S · Augusta, GAJul 21, 1973 · N1500Z · Substantial damage NTSB MIA74FKG05Accident · No injuriesClosedGrumman G-164 · Fitzgerald, GAJul 18, 1973 · N643U · Substantial damage NTSB MIA74DKG12Accident · No injuriesClosedFairchild 24K · Jekyll Island, GAJul 18, 1973 · N20629 · Substantial damage NTSB MIA74DKG09Accident · No injuriesClosedAero Comdr A-9B · Bainbridge, GAJul 16, 1973 · N8025V · Substantial damage NTSB MIA74AM004Accident · 1 fatalClosedBeech 60 · Valdosta, GAJul 13, 1973 · N7282D · Destroyed NTSB MIA74FKG04Accident · No injuriesClosedCessna 150 · Dalton, GAJul 12, 1973 · N3796J · Substantial damage