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 ATL81FKG20Accident · No injuriesClosedCessna 421 · Statesboro, GAMay 29, 1981 · N76ES · Substantial damage NTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GAMay 21, 1981 · N5714E · Destroyed NTSB ATL81FA075Accident · 1 fatalClosedCessna 172 · Rocky Face, GAMay 21, 1981 · N5414R · Destroyed NTSB ATL81FKG18Accident · No injuriesClosedVarize 01 · Winder, GAMay 5, 1981 · N1RL · Destroyed NTSB ATL81DLA06Accident · No injuriesClosedCessna 150G · Waycross, GAMay 1, 1981 · N2994J · Substantial damage NTSB ATL81FKG17Accident · No injuriesClosedPiper PA-39 · Macon, GAApr 28, 1981 · N8959Y · Substantial damage NTSB ATL81FKG15Accident · No injuriesClosedBeech A23 · Cornelia, GAApr 24, 1981 · N3572R · Substantial damage NTSB ATL81FKG16Accident · No injuriesClosedCessna 172P · Carnesville, GAApr 23, 1981 · N53045 · Substantial damage NTSB ATL81DLA05Accident · No injuriesClosedPiper PA-28 · Brunswick, GAApr 20, 1981 · N7993W · Substantial damage NTSB ATL81DKG14Accident · No injuriesClosedCessna 150 · Oglethorpe, GAApr 18, 1981 · N6441T · Destroyed NTSB ATL81FKG13Accident · No injuriesClosedBeech H18 · Atlanta, GAApr 17, 1981 · N7998K · Substantial damage NTSB ATL81DLA04Accident · No injuriesClosedCessna 177 · Homerville, GAApr 17, 1981 · N2247Y · Substantial damage NTSB ATL81FKG12Accident · Minor injuriesClosedPiper PA-28 · Dalton, GAApr 10, 1981 · N9431J · Substantial damage NTSB ATL81FKG11Accident · No injuriesClosedBeech E55 · Atlanta, GAMar 18, 1981 · N7237R · Substantial damage NTSB ATL81FLA03Accident · No injuriesClosedCessna 177A · St Simons, GAMar 14, 1981 · N30415 · Substantial damage NTSB ATL81FKG10Accident · Serious injuriesClosedBeech D18 · Claxton, GAMar 2, 1981 · N80162 · Substantial damage NTSB ATL81FLA02Accident · Minor injuriesClosedHughes 269B · Valdosta, GAMar 1, 1981 · N9557F · Substantial damage NTSB ATL81DKG08Accident · No injuriesClosedBeech 58P · Jenkinsburg, GAFeb 23, 1981 · N15X · Substantial damage NTSB ATL81FKJ15Accident · 1 fatalClosedPiper PA-32 · Mobile, GAFeb 19, 1981 · N3898W · Destroyed NTSB ATL81FKG09Accident · No injuriesClosedCessna 182L · Statesboro, GAFeb 19, 1981 · N3149R · Substantial damage NTSB ATL81FKG07Accident · Serious injuriesClosedCessna 195B · Columbus, GAFeb 15, 1981 · N3018B · Substantial damage NTSB ATL81FA040Accident · 1 fatalClosedCessna 180K · Statesboro, GAFeb 1, 1981 · N2954K · Destroyed NTSB ATL81FKG06Accident · No injuriesClosedCessna 152 · Americus, GADec 30, 1980 · N4737B · Substantial damage NTSB ATL81FKG05Accident · No injuriesClosedBeech 200 · Alma, GADec 16, 1980 · N300CP · Substantial damage NTSB ATL81FA027Accident · Serious injuriesClosedBeech G-185 · Atlanta, GADec 13, 1980 · N9684R · Destroyed NTSB ATL81FA028Accident · 1 fatalClosedPiper PA-28 · Valdosta, GADec 12, 1980 · N9115J · Destroyed NTSB ATL81FKG04Accident · Minor injuriesClosedAeronca 7CCM · Douglasville, GADec 4, 1980 · N2558B · Substantial damage NTSB ATL81IA023Incident · No injuriesClosedDouglas DC-8 · Atlanta, GADec 3, 1980 · N864FT · Minor damage NTSB ATL81IA017Incident · No injuriesClosedCessna 340A · Rome, GANov 20, 1980 · N44RK · Minor damage NTSB ATL81FKG03Accident · No injuriesClosedChampion 7ECA · Madison, GANov 19, 1980 · N5114X · Substantial damage NTSB NYC81FKG02Accident · Minor injuriesClosedCessna 140 · Stockbridge, GANov 15, 1980 · N76151 · Substantial damage NTSB ATL81FA013Accident · 2 fatalClosedCessna T210N · Baxley, GANov 7, 1980 · N5392A · Destroyed NTSB ATL81FA011Accident · 1 fatalClosedCessna T210M · Pearson, GAOct 31, 1980 · N761HK · Destroyed NTSB ATL81FA010Accident · 1 fatalClosedBellanca 8KCAB · Woodland, GAOct 30, 1980 · N4108Y · Destroyed NTSB ATL81FA008Accident · 4 fatalClosedCessna 310 · Milledgeville, GAOct 23, 1980 · N5882M · Destroyed NTSB ATL81DLA01Accident · No injuriesClosedMustang II · Nashville, GAOct 13, 1980 · N363RD · Substantial damage NTSB ATL81FKG01Accident · No injuriesClosedCessna A188B · Buena Vista, GAOct 7, 1980 · N6369G · Substantial damage NTSB ATL81FA001Accident · 1 fatalClosedCessna 210 · Cartersville, GAOct 1, 1980 · N6956N · Destroyed NTSB ATL80FKG29Accident · No injuriesClosedBellanca 17-31 · Hampton, GASep 21, 1980 · N7374V · Substantial damage NTSB ATL80FKG30Accident · Minor injuriesClosedPiper PA-25 · Claxton, GASep 20, 1980 · N6571Z · Destroyed NTSB ATL80FKG28Accident · Minor injuriesClosedPiper PA-23 · Cartersville, GASep 19, 1980 · N1482P · Substantial damage NTSB ATL80IA098Incident · No injuriesClosedConvair 440 · Brunswick, GASep 18, 1980 · N477KW · Minor damage NTSB ATL80FKG27Accident · Minor injuriesClosedAerostar 601P · Peachtree City, GASep 15, 1980 · N333BM · Substantial damage NTSB ATL80FKG26Accident · Minor injuriesClosedCessna 150 · Covington, GASep 15, 1980 · N2934V · Destroyed NTSB ATL80DKG25Accident · No injuriesClosedCessna 172A · Athens, GASep 14, 1980 · N7584T · Substantial damage NTSB ATL80FA094Accident · Minor injuriesClosedLear Jet 24 · Chamblee, GASep 10, 1980 · N127DM · Substantial damage NTSB ATL80DLA15Accident · Serious injuriesClosedCessna T188C · Moultrie, GASep 8, 1980 · N2288J · Destroyed NTSB ATL80FKG24Accident · Serious injuriesClosedCessna 172N · Atlanta, GASep 6, 1980 · N738FE · Destroyed NTSB ATL80FA090Accident · 1 fatalClosedCessna 172 · Milledgeville, GASep 6, 1980 · N13268 · Substantial damage NTSB ATL80DLA14Accident · No injuriesClosedGrumman G-164A · Berlin, GASep 5, 1980 · N8939H · Substantial damage