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 MIA72AM029Accident · 1 fatalClosedPiper PA-28 · Augusta, GASep 22, 1971 · N8439R · Destroyed NTSB MIA72DKG43Accident · No injuriesClosedPiper PA-18 · Valdosta, GASep 16, 1971 · N1891A · Substantial damage NTSB MIA72FKG42Accident · No injuriesClosedCessna 172G · Dahlonega, GASep 15, 1971 · N3714L · Substantial damage NTSB MIA72FKG41Accident · Serious injuriesClosedErco 415-C · Allenhurst, GASep 14, 1971 · N94889 · Destroyed NTSB MIA72DKG39Accident · No injuriesClosedPiper PA-22 · Loganville, GASep 13, 1971 · N4352A · Substantial damage NTSB MIA72FKG40Accident · Serious injuriesClosedBeech A35 · St.Marys, GASep 12, 1971 · N8499A · Substantial damage NTSB MIA72FKG38Accident · No injuriesClosedPiper J-3 · Hiram, GASep 8, 1971 · N6454H · Destroyed NTSB MIA72FKG36Accident · Minor injuriesClosedCessna 170B · Palmetto, GASep 6, 1971 · N8323A · Substantial damage NTSB MIA72DKG37Accident · Minor injuriesClosedCessna 150 · Thomaston, GASep 3, 1971 · N8800G · Substantial damage NTSB MIA72FKG33Accident · No injuriesClosedPiper PA-25 · Thomasville, GAAug 27, 1971 · N8615L · Destroyed NTSB MIA72FKG35Accident · No injuriesClosedPiper PA-28 · Newnan, GAAug 25, 1971 · N3929K · Substantial damage NTSB MIA72FKG31Accident · 1 fatalClosedCallair A-9 · Buena Vista, GAAug 23, 1971 · N3562G · Destroyed NTSB MIA72FKG30Accident · No injuriesClosedCessna 190 · Brunswick, GAAug 23, 1971 · N4310V · Destroyed NTSB MIA72FKG27Accident · Serious injuriesClosedCessna 172I · Marietta, GAAug 22, 1971 · N35683 · Substantial damage NTSB MIA72DKG32Accident · No injuriesClosedSchemp Cirrus · Unadilla, GAAug 22, 1971 · N26TE · Substantial damage NTSB MIA72DKG28Accident · No injuriesClosedCessna 172 · Lafayette, GAAug 22, 1971 · N5188A · Substantial damage NTSB MIA72IM020Incident · No injuriesClosedCessna 310 · Peachtree City, GAAug 21, 1971 · N3606D · Minor damage NTSB MIA72FKG26Accident · Serious injuriesClosedPiper PA-28 · Lithonia, GAAug 21, 1971 · N1715T · Destroyed NTSB MIA72FKG24Accident · Minor injuriesClosedCessna 210E · Clayton, GAAug 20, 1971 · N731JH · Destroyed NTSB MIA72DKG25Accident · No injuriesClosedCallair A9 · Waynesboro, GAAug 20, 1971 · N3579G · Substantial damage NTSB MIA72DKG29Accident · No injuriesClosedAero Comdr A9B · Nevils, GAAug 18, 1971 · N7752V · Substantial damage NTSB MIA72AM014Accident · No injuriesClosedDouglas DC-9 · Savannah, GAAug 18, 1971 · N3316L · Substantial damage NTSB MIA72DKG34Accident · No injuriesClosedAero Comdr A-9B · Iron City, GAAug 16, 1971 · N7919V · Substantial damage NTSB MIA72DKG23Accident · No injuriesClosedCessna 150G · Gray, GAAug 16, 1971 · N3301J · Substantial damage NTSB MIA72FKG22Accident · No injuriesClosedPiper PA-30 · Chamblee, GAAug 15, 1971 · N8428Y · Substantial damage NTSB MIA72DKG21Accident · No injuriesClosedAero Comdr A-9B · Aragon, GAAug 13, 1971 · N7781V · Substantial damage NTSB MIA72AM011Accident · 1 fatalClosedCessna 172K · Atlanta, GAAug 13, 1971 · N79407 · Destroyed NTSB MIA72DKG20Accident · No injuriesClosedGrumman G-164A · Vada, GAAug 11, 1971 · N905X · Destroyed NTSB MIA72AM010Accident · 2 fatalClosedStinson 108-2 · Cartersville, GAAug 10, 1971 · N236C · Destroyed NTSB MIA72FKG19Accident · Serious injuriesClosedGlobe GC-1B · Fairburn, GAAug 7, 1971 · N90338 · Substantial damage NTSB MIA72DKG18Accident · No injuriesClosedBeech 95 · St Simons Isl, GAAug 2, 1971 · N2710Y · Substantial damage NTSB MIA72DKG17Accident · No injuriesClosedAero Comdr A-9B · Vienna, GAAug 2, 1971 · N7728V · Substantial damage NTSB MIA72FKG15Accident · Minor injuriesClosedCessna 172B · Conyers, GAJul 31, 1971 · N7567X · Substantial damage NTSB MIA72DKG16Accident · No injuriesClosedCessna 188 · Shellman, GAJul 30, 1971 · N9896V · Substantial damage NTSB MIA72FKG14Accident · No injuriesClosedPiper PA-28 · Greensboro, GAJul 29, 1971 · N6336W · Destroyed NTSB MIA72FKG13Accident · No injuriesClosedPitts Spcl S-1C · Williamson, GAJul 29, 1971 · N101M · Substantial damage NTSB MIA72FKG12Accident · No injuriesClosedCessna 150K · Talbotton, GAJul 24, 1971 · N5959G · Destroyed NTSB MIA72DKG09Accident · No injuriesClosedGrumman G-164 · Carnegie, GAJul 21, 1971 · N590Y · Substantial damage NTSB MIA72DKG11Accident · No injuriesClosedPiper PA-28 · Marietta, GAJul 18, 1971 · N6911W · Substantial damage NTSB MIA72DKG10Accident · No injuriesClosedAmer Avco A-1 · Stone Mountain, GAJul 17, 1971 · N5921L · Substantial damage NTSB MIA72FKG06Accident · No injuriesClosedAero Comdr 100 · Albany, GAJul 13, 1971 · N3625X · Substantial damage NTSB MIA72DKG05Accident · No injuriesClosedCassutt II · Milledgeville, GAJul 13, 1971 · N1419R · Substantial damage NTSB MIA72FKG07Accident · No injuriesClosedCessna 210 · Jonesboro, GAJul 10, 1971 · N9552T · Substantial damage NTSB MIA72FKG04Accident · No injuriesClosedPiper PA-28 · Valdosta, GAJul 8, 1971 · N4361J · Substantial damage NTSB MIA72DKG03Accident · No injuriesClosedCessna 170B · Lithonia, GAJul 5, 1971 · N2342D · Substantial damage NTSB MIA72AM002Accident · No injuriesClosedBoeing E75N1 · Cumming, GAJul 5, 1971 · N1935M · Destroyed NTSB MIA72DKG02Accident · No injuriesClosedCessna 150F · Fort Benning, GAJul 3, 1971 · N6996F · Substantial damage NTSB MIA71DKH01Accident · No injuriesClosedCessna 182 · Stone Mtn, GAJun 29, 1971 · N91912 · Substantial damage NTSB MIA71IM116Incident · No injuriesClosedPiper PA-31 · Atlanta, GAJun 27, 1971 · N721ZC · No damage NTSB MIA71FKG98Accident · No injuriesClosedCessna 150 · Stone Mtn, GAJun 26, 1971 · N60729 · Substantial damage