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 MIA71FKG97Accident · Minor injuriesClosedCessna 172D · Folkston, GAJun 21, 1971 · N2704U · Destroyed NTSB MIA71FKG96Accident · No injuriesClosedHughes 269B · Savannah, GAJun 14, 1971 · N9444F · Substantial damage NTSB MIA71DKG94Accident · No injuriesClosedPiper PA-28 · Ft.Valley, GAJun 14, 1971 · N5937U · Substantial damage NTSB MIA71FKG93Accident · Minor injuriesClosedPiper PA-22 · Soperton, GAJun 13, 1971 · N8101D · Substantial damage NTSB MIA71DKG95Accident · No injuriesClosedCessna 172 · Dublin, GAJun 13, 1971 · N2814U · Substantial damage NTSB MIA71IM112Incident · No injuriesClosedBeech 99 · Brunswick, GAJun 11, 1971 · N848NS · No damage NTSB MIA71DKG92Accident · No injuriesClosedAero-Comdr A-9B · Resaca, GAJun 8, 1971 · N7781V · Substantial damage NTSB MIA71DKG99Accident · No injuriesClosedBeech B35 · Jekyll Island, GAJun 7, 1971 · N4444D · Substantial damage NTSB MIA71FKG89Accident · No injuriesClosedCessna 150J · Lithonia, GAJun 5, 1971 · N61254 · Substantial damage NTSB MIA71FKG91Accident · No injuriesClosedBellanca 14-13 · Palmetto, GAJun 4, 1971 · N86723 · Substantial damage NTSB MIA71FKH02Accident · No injuriesClosedCessna 182B · Warm Springs, GAJun 1, 1971 · N2282G · Substantial damage NTSB MIA71FKG88Accident · Minor injuriesClosedPiper PA-28 · College Park, GAMay 28, 1971 · N520FL · Substantial damage NTSB MIA71FKG87Accident · No injuriesClosedN.American P-51 · Atlanta, GAMay 28, 1971 · N469P · Substantial damage NTSB MIA71FKG86Accident · No injuriesClosedAeronca 7ACM · Moultrie, GAMay 26, 1971 · N2552B · Substantial damage NTSB MIA71AM103Accident · 1 fatalClosedAeronca 11AC · Sandersville, GAMay 25, 1971 · N86338 · Destroyed NTSB MIA71DKG85Accident · No injuriesClosedCessna 150 · Covington, GAMay 22, 1971 · N61134 · Substantial damage NTSB MIA71FKG84Accident · Minor injuriesClosedPiper PA-22 · Hephzibah, GAMay 18, 1971 · N3345Z · Substantial damage NTSB MIA71AM096Accident · 3 fatalClosedBeech 95-B55 · Ellabelle, GAMay 15, 1971 · N100DC · Destroyed NTSB MIA71DKG79Accident · Minor injuriesClosedPiper PA-23 · Augusta, GAMay 6, 1971 · N6019Y · Substantial damage NTSB MIA71FKG82Accident · No injuriesClosedCessna 150G · Quitman, GAMay 5, 1971 · N2726S · Substantial damage NTSB MIA71DKG80Accident · No injuriesClosedAeronca 7CCM · Jefferson, GAMay 4, 1971 · N2558B · Substantial damage NTSB MIA71FKG83Accident · No injuriesClosedChampion 7AC · Thomasville, GAMay 2, 1971 · N82628 · Substantial damage NTSB MIA71DKG81Accident · No injuriesClosedPiper PA-28 · Ashburn, GAMay 2, 1971 · N5006W · Substantial damage NTSB MIA71FKG78Accident · No injuriesClosedCessna 170B · Moultrie, GAMay 1, 1971 · N2242D · Substantial damage NTSB MIA71FKG77Accident · No injuriesClosedPiper PA-28 · Marietta, GAApr 27, 1971 · N5000W · Substantial damage NTSB MIA71DKG76Accident · No injuriesClosedPitts SC-1 · Douglasville, GAApr 25, 1971 · N6119 · Substantial damage NTSB MIA71FKG75Accident · No injuriesClosedChampion 7ECA · Sylvania, GAApr 21, 1971 · N1658G · Substantial damage NTSB MIA71AM088Accident · 4 fatalClosedMooney M20C · Athens, GAApr 17, 1971 · N6752V · Destroyed NTSB MIA71DKG73Accident · No injuriesClosedCessna 182 · Fort Valley, GAApr 11, 1971 · N71716 · Destroyed NTSB MIA71DKG72Accident · No injuriesClosedCessna 172 · Lithonia, GAApr 11, 1971 · N79566 · Substantial damage NTSB MIA71DKG74Accident · No injuriesClosedCessna 150F · Cleveland, GAApr 9, 1971 · N8833G · Substantial damage NTSB MIA71DKG71Accident · No injuriesClosedPiper PA-28 · Fitzgerald, GAMar 30, 1971 · N5041S · Substantial damage NTSB MIA71AM083Accident · 2 fatalClosedPiper PA-24 · Americus, GAMar 15, 1971 · N6567P · Destroyed NTSB MIA71DKG70Accident · No injuriesClosedPiper PA-22 · Jonesboro, GAMar 14, 1971 · N2658P · Substantial damage NTSB MIA71FKG69Accident · Serious injuriesClosedHughes 269B · Lakeland, GAMar 11, 1971 · N9438F · Destroyed NTSB MIA71FKG67Accident · Serious injuriesClosedCessna A150K · Metter, GAMar 10, 1971 · N8498M · Substantial damage NTSB MIA71IM080Incident · No injuriesClosedBeech 65-80 · Fayetteville, GAMar 4, 1971 · N143 · 2 aircraft · Minor damage NTSB MIA71AM075Accident · 1 fatalClosedGlobe GC-1B · Norcross, GAFeb 25, 1971 · N78043 · Destroyed NTSB MIA71DKG68Accident · No injuriesClosedCessna 140 · Jonesboro, GAFeb 23, 1971 · N2869N · Substantial damage NTSB MIA71DKG66Accident · No injuriesClosedPiper PA-24 · Stone Mountain, GAFeb 18, 1971 · N7217P · Substantial damage NTSB MIA71FKG64Accident · Serious injuriesClosedPiper PA-28 · Savannah, GAFeb 14, 1971 · N6416R · Substantial damage NTSB MIA71FKG63Accident · No injuriesClosedCessna 182 · Atlanta, GAFeb 11, 1971 · N42120 · Substantial damage NTSB MIA71FKG62Accident · No injuriesClosedRyan ST-3KR · Decatur, GAFeb 6, 1971 · N55081 · Substantial damage NTSB MIA71DKG61Accident · No injuriesClosedCessna 310 · Cornelia, GAFeb 3, 1971 · N6846T · Substantial damage NTSB MIA71DKG59Accident · No injuriesClosedAeronca 7AC · Douglas, GAJan 31, 1971 · N82720 · Substantial damage NTSB MIA71AM063Accident · Minor injuriesClosedPiper PA-30 · Atlanta, GAJan 30, 1971 · N7632Y · Substantial damage NTSB MIA71FKG60Accident · No injuriesClosedPiper PA-24 · Americus, GAJan 27, 1971 · N5927P · Substantial damage NTSB MIA71FKG58Accident · No injuriesClosedPiper PA-24 · Garden City, GAJan 23, 1971 · N7072P · Substantial damage NTSB MIA71FKG57Accident · Serious injuriesClosedCessna 172 · Statesboro, GAJan 13, 1971 · N79570 · Destroyed NTSB MIA71FKG56Accident · No injuriesClosedPiper PA-24 · Macon, GAJan 7, 1971 · N5779P · Substantial damage