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 MIA66F0138Accident · Serious injuriesClosedGrumman G-164 · Shellman, GAJul 10, 1965 · N597Y · Substantial damage NTSB MIA66F0083Accident · Serious injuriesClosedCallair A5 · Harrison, GAJul 8, 1965 · N9976C · Substantial damage NTSB MIA66F0098Accident · No injuriesClosedCessna 182 · Ringgold, GAJul 6, 1965 · N1840X · Substantial damage NTSB MIA66F0061Accident · No injuriesClosedCessna 150 · Atlanta, GAJul 3, 1965 · N6137T · 2 aircraft · Minor damage NTSB MIA66F0029Accident · Minor injuriesClosedPiper J3C · Jesup, GAJul 3, 1965 · N7217H · Destroyed NTSB MIA66D0064Accident · No injuriesClosedPiper PA-25 · Sylvester, GAJul 3, 1965 · N6776Z · Substantial damage NTSB MIA66D0060Accident · No injuriesClosedChampion 7FC · Athens, GAJul 3, 1965 · N8508E · Substantial damage NTSB MIA66F0147Accident · No injuriesClosedGreat Lakes 2T1A · Jonesboro, GAJun 26, 1965 · N828K · Substantial damage NTSB MIA66D0178Accident · No injuriesClosedPiper PA-24 · Cannon, GAJun 25, 1965 · N7211P · Substantial damage NTSB MIA66F0046Accident · No injuriesClosedCessna 170B · Atlanta, GAJun 22, 1965 · N4542C · Substantial damage NTSB MIA66F0123Accident · Serious injuriesClosedPiper J3 · Baxley, GAJun 20, 1965 · N6970H · Destroyed NTSB MIA66F0145Accident · Serious injuriesClosedRyan ST3KR · Atlanta, GAJun 19, 1965 · N48238 · Destroyed NTSB MIA65A0124Accident · 3 fatalClosedCessna 172 · Toccoa, GAJun 19, 1965 · N4253F · Destroyed NTSB MIA66D0006Accident · No injuriesClosedAeronca 7AC · Marietta, GAJun 13, 1965 · N2610E · Substantial damage NTSB MIA66D0023Accident · No injuriesClosedCessna 182 · Dahlonega, GAJun 12, 1965 · N6322A · Substantial damage NTSB MIA66F0020Accident · Serious injuriesClosedCessna 172D · Cumming, GAJun 10, 1965 · N2696U · Destroyed NTSB MIA66F0075Accident · Minor injuriesClosedCessna 182 · Stockbridge, GAJun 6, 1965 · N4913D · Substantial damage NTSB MIA66F0105Accident · Minor injuriesClosedMooney M20A · Augusta, GAJun 4, 1965 · N8366E · Substantial damage NTSB MIA65F0131Accident · No injuriesClosedPiper PA-25 · Shellman, GAMay 31, 1965 · N7407Z · Substantial damage NTSB MIAL6F0034Accident · No injuriesClosedBellanca 14-19 · Fairburn, GAMay 23, 1965 · N131H · Substantial damage NTSB MIA66F0015Accident · Minor injuriesClosedBeechcraft 35 · Hiawassee, GAMay 21, 1965 · N2829W · Destroyed NTSB MIA66F0014Accident · No injuriesClosedCessna 310 · Carollton, GAMay 21, 1965 · N3699D · Substantial damage NTSB MIA65F0111Accident · No injuriesClosedMorrisey 2150A · Gainesville, GAMay 19, 1965 · N5132V · Substantial damage NTSB MIA66F0033Accident · Serious injuriesClosedPiper PA-22 · Suwanee, GAMay 1, 1965 · N6906B · Destroyed NTSB MIA65F0064Accident · Minor injuriesClosedPiper PA-12 · Chamblee, GAMay 1, 1965 · N98955 · Destroyed NTSB MIA65F0092Accident · No injuriesClosedBeechcraft 95-55 · Atlanta, GAApr 29, 1965 · N5694H · Substantial damage NTSB MIA65A0108Accident · No injuriesClosedCessna 310G · Atlanta, GAApr 28, 1965 · N2915R · Substantial damage NTSB MIA65A0106Accident · No injuriesClosedBell 47G4 · Doraville, GAApr 26, 1965 · N3081G · Substantial damage NTSB MIA66F0132Accident · Serious injuriesClosedGlobe 6C-1A · Augusta, GAApr 24, 1965 · N80559 · Destroyed NTSB MIA66D0074Accident · No injuriesClosedBeechcraft P-35 · Gainesville, GAApr 24, 1965 · N8620M · Substantial damage NTSB MIA65D0088Accident · No injuriesClosedBeechcraft 35-33 · Dublin, GAApr 19, 1965 · N981T · Substantial damage NTSB MIA66F0131Accident · Minor injuriesClosedPiper PA-24 · Rochelle, GAApr 18, 1965 · N7035P · Substantial damage NTSB MIA65A0102Accident · No injuriesClosedLockheed PV-2 · Bainbridge, GAApr 17, 1965 · N7260C · Substantial damage NTSB MIA65A0101Accident · 1 fatalClosedPiper PA18A · Lagrange, GAApr 14, 1965 · N9392D · Destroyed NTSB MIA65D0028Accident · No injuriesClosedAeronca 7AC · Stone Mountain, GAApr 11, 1965 · N3064E · Substantial damage NTSB MIA65F0052Accident · Serious injuriesClosedAeronca 65TC · Hazlehurst, GAApr 10, 1965 · N31345 · Destroyed NTSB MIA65D0085Accident · No injuriesClosedAeronca 7CCM · Jonesboro, GAApr 10, 1965 · N2559B · Substantial damage NTSB MIA65F0099Accident · No injuriesClosedPiper PA-23 · Augusta, GAApr 9, 1965 · N1030P · Substantial damage NTSB MIA65F0012Accident · No injuriesClosedCessna 150E · Griffin, GAApr 4, 1965 · N3080J · Substantial damage NTSB MIA65D0065Accident · No injuriesClosedPiper PA-28 · Savannah, GAApr 4, 1965 · N6326W · Substantial damage NTSB MIA65D0081Accident · No injuriesClosedMooney M21 · Chamblee, GAApr 3, 1965 · N74510 · Substantial damage NTSB MIA65A0098Accident · Minor injuriesClosedBrantly B2A · Atlanta, GAApr 1, 1965 · N5977X · Substantial damage NTSB MIA65F0080Accident · No injuriesClosedMooney M20D · Toccoa, GAMar 30, 1965 · N1975Y · Substantial damage NTSB MIA65F0038Accident · No injuriesClosedPiper PA-24 · Marietta, GAMar 30, 1965 · N6145P · Substantial damage NTSB MIA65F0016Accident · No injuriesClosedErcoupe 415C · Roscoe, GAMar 26, 1965 · N99692 · Substantial damage NTSB MIA66F0073Accident · Minor injuriesClosedCessna 182A · St Simons Is, GAMar 19, 1965 · N2202G · Substantial damage NTSB MIA65D0018Accident · Minor injuriesClosedCessna 172 · Elberton, GAMar 19, 1965 · N8212U · Substantial damage NTSB MIA66F0001Accident · No injuriesClosedCessna 182A · Brunswick, GAMar 14, 1965 · N5866B · Substantial damage NTSB MIA65F0034Accident · No injuriesClosedPiper PA-24 · Chamblee, GAMar 14, 1965 · N6579P · Substantial damage NTSB MIA65F0005Accident · No injuriesClosedCessna 206 · Dudley, GAMar 8, 1965 · N5119U · Substantial damage