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 MIA74DKG88Accident · No injuriesClosedCessna 150 · Toccoa, GAJun 2, 1973 · N8283S · Substantial damage NTSB MIA73DKG80Accident · No injuriesClosedCessna 140 · Marietta, GAMay 23, 1973 · N89180 · Substantial damage NTSB MIA73FKG77Accident · 1 fatalClosedPitts S1C · Athens, GAMay 17, 1973 · N3192 · Destroyed NTSB MIA73DKG78Accident · No injuriesClosedCessna 182 · Dalton, GAMay 13, 1973 · N7308Q · Substantial damage NTSB MIA73AM102Accident · 2 fatalClosedCessna 150G · Hiram, GAMay 13, 1973 · N2457J · Destroyed NTSB MIA73FKG75Accident · Serious injuriesClosedCessna 150 · Chamblee, GAMay 6, 1973 · N5834G · Substantial damage NTSB MIA73DKG73Accident · No injuriesClosedCessna 150L · Stockbridge, GAApr 30, 1973 · N18209 · Substantial damage NTSB MIA73DKG74Accident · No injuriesClosedMooney M20C · Villa Rica, GAApr 29, 1973 · N9256M · Substantial damage NTSB MIA73FKG72Accident · Serious injuriesClosedMooney M20A · Mcrae, GAApr 28, 1973 · N6592B · Destroyed NTSB MIA73FKG71Accident · Minor injuriesClosedPiper PA-28 · Gray, GAApr 20, 1973 · N2304T · Destroyed NTSB MIA73FKG70Accident · No injuriesClosedCessna 172 · Fitzgerald, GAApr 16, 1973 · N4249Q · Substantial damage NTSB MIA73DKG69Accident · Minor injuriesClosedPiper PA-22 · Blythe, GAApr 14, 1973 · N3627P · Substantial damage NTSB MIA73FKG68Accident · 2 fatalClosedN.American P-51D · Atlanta, GAApr 8, 1973 · N469P · Destroyed NTSB MIA73DKG67Accident · No injuriesClosedMooney M21 · Quitman, GAApr 3, 1973 · N5548Q · Substantial damage NTSB MIA73DKG66Accident · No injuriesClosedPiper PA-28 · Cornelia, GAApr 3, 1973 · N7989W · Substantial damage NTSB MIA73FKG64Accident · No injuriesClosedNavion A · Brooks, GAMar 24, 1973 · N8754H · Substantial damage NTSB MIA73DKG59Accident · No injuriesClosedPiper PA-28 · Pelham, GAMar 15, 1973 · N5545F · Substantial damage NTSB IAD73AI002Accident · 2 fatalClosedCessna 177RG · Woodstock, GAMar 15, 1973 · N1881Q · Destroyed NTSB MIA73DKG63Accident · No injuriesClosedPiper PA-25 · Bairdstown, GAMar 8, 1973 · N8644L · Substantial damage NTSB MIA73AM089Accident · 1 fatalClosedCessna 310G · College Park, GAMar 7, 1973 · N891DP · Destroyed NTSB MIA73AM087Accident · 7 fatalClosedGates Lear 24 · Atlanta, GAFeb 26, 1973 · N454RN · Destroyed NTSB MIA73FKG65Accident · No injuriesClosedChampion 7KCAB · Albany, GAFeb 24, 1973 · N6345N · Substantial damage NTSB MIA73FKG62Accident · No injuriesClosedCessna 150J · Hampton, GAFeb 20, 1973 · N60728 · Destroyed NTSB MIA73AM085Accident · 4 fatalClosedCessna 210H · Rome, GAFeb 15, 1973 · N5970F · Destroyed NTSB MIA73FKG61Accident · No injuriesClosedBeech 100 · Athens, GAFeb 14, 1973 · N570DU · Substantial damage NTSB MIA73DKG60Accident · No injuriesClosedMcculloch J-2 · Statesboro, GAFeb 12, 1973 · N4345G · Substantial damage NTSB MIA73AM080Accident · 1 fatalClosedAmer Avco AA1 · Attapulgus, GAFeb 6, 1973 · N6408L · Destroyed NTSB MIA73FKG58Accident · No injuriesClosedCessna 150F · Alma, GAFeb 4, 1973 · N7017F · Substantial damage NTSB MIA73FKG54Accident · 2 fatalClosedN. American F-51D · Flowery Branch, GADec 30, 1972 · N9149R · Destroyed NTSB MIA73FKG56Accident · Serious injuriesClosedPiper PA-22 · Peachtree City, GADec 29, 1972 · N3649A · Substantial damage NTSB MIA73DKG55Accident · Minor injuriesClosedSidewinder Smith · Milledgeville, GADec 28, 1972 · N2285 · Substantial damage NTSB MIA73AMO64Accident · 2 fatalClosedCessna 310 · Shellman, GADec 20, 1972 · N2691C · Destroyed NTSB MIA73FKG53Accident · No injuriesClosedCessna 150G · Chamblee, GADec 19, 1972 · N8392J · Substantial damage NTSB MIA73FKG52Accident · Minor injuriesClosedBeech A23 · Jefferson, GADec 17, 1972 · N3559R · Destroyed NTSB MIA73AM059Accident · 1 fatalClosedAero Comdr 680V · Augusta, GADec 9, 1972 · N1195Z · Destroyed NTSB MIA73FKG51Accident · No injuriesClosedPiper J3C-65 · Cordele, GADec 3, 1972 · N3545N · Substantial damage NTSB MIA73FKG50Accident · Minor injuriesClosedCessna 150H · Reidsville, GADec 2, 1972 · N6982S · Substantial damage NTSB MIA73FKG49Accident · Minor injuriesClosedCessna 150J · Hartwell, GANov 27, 1972 · N50572 · Destroyed NTSB MIA73DKG57Accident · No injuriesClosedEaa Biplane P · Macon, GANov 23, 1972 · N1419 · Destroyed NTSB MIA73FKG48Accident · Minor injuriesClosedCessna 310N · Macon, GANov 19, 1972 · N4116Q · Substantial damage NTSB MIA73AMO52Accident · 2 fatalClosedCessna 182P · Porterdale, GANov 19, 1972 · N9397G · Destroyed NTSB MIA73DKGH7Accident · Minor injuriesClosedChampion 7BCM · Richmond Hill, GANov 12, 1972 · N2552B · Substantial damage NTSB MIA73AM048Accident · No injuriesClosedBoeing 727 · Atlanta, GANov 8, 1972 · N8156G · Substantial damage NTSB MIA73AM047Accident · 1 fatalClosedNavion A · Brunswick, GANov 5, 1972 · N4340K · Destroyed NTSB MIA73IM046Incident · No injuriesClosedDouglas DC-8 · Atlanta, GANov 1, 1972 · N801E · Minor damage NTSB MIA73AMO43Accident · No injuriesClosedBeech D18S · Oglethorpe, GAOct 22, 1972 · N270QS · Substantial damage NTSB MIA73FKG45Accident · Minor injuriesClosedHughes 269C · Chamblee, GAOct 19, 1972 · N9670F · Substantial damage NTSB MIA73FKG44Accident · No injuriesClosedCessna 150 · Atlanta, GAOct 16, 1972 · N7075F · Substantial damage NTSB MIA73DLG27Accident · No injuriesClosedPiper PA-23 · No.Myrtle Bch, GAOct 14, 1972 · N6281Y · Substantial damage NTSB MIA73DKG46Accident · No injuriesClosedGrumman G-164A · Quitman, GAOct 14, 1972 · N7833 · Substantial damage