Skip to content

NTSB investigations, GA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, newest first

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 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 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 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 MIA71AM056Accident · 1 fatalClosedPiper PA-24 · Barney, GAJan 5, 1971 · N5122P · Destroyed NTSB MIA71FKG55Accident · No injuriesClosedPiper PA-24 · Atlanta, GADec 19, 1970 · N8846P · Substantial damage NTSB MIA71FKG54Accident · Serious injuriesClosedGlobe GC-1B · Stone Mountain, GADec 19, 1970 · N78146 · Substantial damage NTSB MIA71AM052Accident · 2 fatalClosedPiper PA-28 · Savannah, GADec 14, 1970 · N4115J · Destroyed NTSB MIA71AM049Accident · 2 fatalClosedAeronca 11AC · Butler, GADec 12, 1970 · N3247E · Destroyed NTSB MIA71AM046Accident · 2 fatalClosedPiper PA-28 · Blakely, GADec 10, 1970 · N9827W · Destroyed NTSB MIA71AM045Accident · No injuriesClosedMartin 404 · Atlanta, GADec 10, 1970 · N143S · Minor damage NTSB MIA71FKG53Accident · No injuriesClosedHiller Acft FH1100 · Columbus, GADec 8, 1970 · N245CP · Substantial damage NTSB MIA71FKG52Accident · Serious injuriesClosedCessna 310C · St Simons Isle, GADec 4, 1970 · N1821H · Destroyed NTSB MIA71DKG51Accident · No injuriesClosedBriegleb BG12BD · Williamson, GANov 28, 1970 · N9009 · Substantial damage NTSB MIA71DKG50Accident · No injuriesClosedCessna 150J · Suwanee, GANov 26, 1970 · N60228 · Substantial damage NTSB MIA71AM040Accident · No injuriesClosedBoeing 727-35 · Savannah, GANov 4, 1970 · N4611 · Substantial damage NTSB MIA71FKG49Accident · No injuriesClosedBeech 65 · Chamblee, GANov 2, 1970 · N350GK · Substantial damage NTSB MIA71AM039Accident · 1 fatalClosedNavion A · Suwanee, GANov 1, 1970 · N1261 · Destroyed NTSB MIA71FKG48Accident · No injuriesClosedCessna 182 · Pavo, GAOct 31, 1970 · N3091Y · Substantial damage NTSB MIA71AM035Accident · 2 fatalClosedCessna 120 · Marietta, GAOct 23, 1970 · N89865 · Destroyed NTSB MIA71AM033Accident · No injuriesClosedBeech 99 · Atlanta, GAOct 22, 1970 · N845NS · Substantial damage NTSB MIA71FKG47Accident · No injuriesClosedBeech 95-C55 · Waycross, GAOct 21, 1970 · N9591Q · Substantial damage NTSB MIA71AM032Accident · 2 fatalClosedBeech J35 · Mussella, GAOct 19, 1970 · N749B · Destroyed NTSB MIA71FKG45Accident · No injuriesClosedChampion 7GCAA · Chamblee, GAOct 16, 1970 · N9026L · Substantial damage NTSB MIA71FKC46Accident · No injuriesClosedBeech 56TC · Atlanta, GAOct 13, 1970 · N680PC · Substantial damage NTSB MIA71DKG44Accident · No injuriesClosedPiper PA-28 · St Simons Isle, GAOct 9, 1970 · N5861U · Substantial damage NTSB MIA71DKG42Accident · No injuriesClosedCessna 172 · Twin City, GAOct 8, 1970 · N35368 · Substantial damage NTSB MIA71FKC43Accident · No injuriesClosedBeech 95 · Lithonia, GAOct 6, 1970 · N2052C · Substantial damage NTSB MIA71DKG40Accident · No injuriesClosedCessna 150 · Dahlonega, GASep 18, 1970 · N60344 · Substantial damage NTSB MIA71DKG39Accident · No injuriesClosedCessna 150F · Warner Robins, GASep 18, 1970 · N6809F · Substantial damage NTSB MIA71DKG37Accident · Serious injuriesClosedCessna 188 · Vidalia, GASep 7, 1970 · N8016V · Destroyed NTSB MIA71FKG38Accident · 1 fatalClosedWolf-Hirth LO-150 · Sylvania, GASep 6, 1970 · N1110V · Destroyed NTSB MIA71FKG36Accident · Minor injuriesClosedPhares Breezy · Savannah, GASep 6, 1970 · N1276 · Substantial damage NTSB MIA71FKG35Accident · No injuriesClosedCessna 150 · Dahlonega, GASep 5, 1970 · N8057S · Substantial damage NTSB MIA71DKG34Accident · No injuriesClosedPiper PA-25 · Moultrie, GASep 1, 1970 · N8581L · Substantial damage NTSB MIA71FKG32Accident · Serious injuriesClosedPiper PA-18 · Girard, GAAug 31, 1970 · N4896A · Destroyed NTSB MIA71FKG30Accident · No injuriesClosedCessna 172 · Claxton, GAAug 30, 1970 · N7267T · Substantial damage NTSB MIA71FKG31Accident · No injuriesClosedPiper PA-30 · Statesboro, GAAug 28, 1970 · N7881Y · Substantial damage NTSB MIA71FKG33Accident · No injuriesClosedChampion 7KCAB · Savannah, GAAug 27, 1970 · N6300N · Substantial damage NTSB MIA71AM019Accident · 1 fatalClosedPiper PA-18 · Macon, GAAug 27, 1970 · N3449P · Destroyed NTSB MIA71DKG28Accident · No injuriesClosedPiper PA-25 · Pinehurst, GAAug 25, 1970 · N7360Z · Destroyed NTSB MIA71FKG27Accident · Minor injuriesClosedNavion H · Blackshear, GAAug 24, 1970 · N2533T · Substantial damage NTSB MIA71DKG26Accident · No injuriesClosedMidget Must MM-1 · Warner Robins, GAAug 23, 1970 · N131D · Substantial damage NTSB MIA71FKG25Accident · Minor injuriesClosedCessna 150G · Atlanta, GAAug 22, 1970 · N4064J · Substantial damage NTSB MIA71FKG24Accident · No injuriesClosedLuscombe 8A · Perry, GAAug 21, 1970 · N45452 · Substantial damage NTSB MIA71FKG22Accident · Minor injuriesClosedPiper PA-28R · East Point, GAAug 20, 1970 · N3207R · Substantial damage NTSB MIA71FKG21Accident · Serious injuriesClosedPiper PA-25 · Unadilla, GAAug 19, 1970 · N4738Y · Destroyed NTSB MIA71FKG20Accident · Serious injuriesClosedWittman W-8 · La Grange, GAAug 10, 1970 · N1010B · Destroyed NTSB MIA71FKG18Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 8, 1970 · N8326Y · Substantial damage NTSB MIA71FKG19Accident · No injuriesClosedCessna 188A · Leesburg, GAAug 6, 1970 · N5632J · Substantial damage NTSB MIA71FKG17Accident · No injuriesClosedCessna 182H · Dalton, GAAug 3, 1970 · N2015X · Substantial damage NTSB MIA71DKG16Accident · No injuriesClosedPiper PA-25 · Henderson, GAAug 1, 1970 · N6976Z · Substantial damage NTSB MIA71AM010Accident · 4 fatalClosedPiper PA-28 · Brunswick, GAAug 1, 1970 · N98271 · Destroyed NTSB MIA71DKG14Accident · No injuriesClosedPiper PA-25 · Ty Ty, GAJul 28, 1970 · N8596L · Substantial damage