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 MIA76FKG74Accident · No injuriesClosedBeech B35 · Mcrae, GAJun 7, 1976 · N4523V · Substantial damage NTSB MIA76FKG73Accident · No injuriesClosedBeech D18S · Perry, GAJun 7, 1976 · N642B · Substantial damage NTSB MIA76FKG72Accident · No injuriesClosedCessna 180 · Jefferson, GAJun 6, 1976 · N2945A · Substantial damage NTSB MIA76FKG71Accident · Serious injuriesClosedPiper PA-28 · Chamblee, GAJun 6, 1976 · N56521 · Substantial damage NTSB MIA76FKG70Accident · No injuriesClosedCessna A188B · Ellaville, GAJun 1, 1976 · N9337R · Destroyed NTSB MIA76DKG69Accident · No injuriesClosedAdams A50S · Stockbridge, GAMay 30, 1976 · N18801 · Destroyed NTSB MIA76AM088Accident · 1 fatalClosedCessna 172A · Milledgeville, GAMay 27, 1976 · N7848T · Destroyed NTSB MIA76AM087Accident · Serious injuriesClosedDouglas DC-8 · Atlanta, GAMay 27, 1976 · N806E · No damage NTSB MIA76FKG68Accident · No injuriesClosedCessna 172 · Columbus, GAMay 26, 1976 · N4268Q · Substantial damage NTSB MIA76DKG67Accident · No injuriesClosedPiper PA-25 · Estel, GAMay 26, 1976 · N6145Z · Substantial damage NTSB MIA76AM086Accident · 2 fatalClosedCessna 172M · Lavonia, GAMay 24, 1976 · N9941Q · Destroyed NTSB MIA76FKG65Accident · 1 fatalClosedPiccard AX-6 · Toccoa, GAMay 18, 1976 · N61US · Substantial damage NTSB MIA76FKG64Accident · No injuriesClosedStinson V-77 · Jonesboro, GAMay 17, 1976 · N9195H · Destroyed NTSB MIA76AM083Accident · 1 fatalClosedPiper PA-22 · Lyons, GAMay 16, 1976 · N3813P · Destroyed NTSB MIA76FKG66Accident · No injuriesClosedBeech B19 · Valdosta, GAMay 12, 1976 · N1951W · Substantial damage NTSB MIA76FKG63Accident · No injuriesClosedGrumman G-164A · Sasser, GAMay 12, 1976 · N7929 · Substantial damage NTSB MIA76FKG62Accident · No injuriesClosedBeech 95-A55 · Atlanta, GAMay 7, 1976 · N3EY · Substantial damage NTSB MIA76FKG61Accident · 1 fatalClosedMustang 2 · Macon, GAMay 4, 1976 · N76JD · Destroyed NTSB MIA76FKG60Accident · No injuriesClosedBell 47G · Stockbridge, GAMay 3, 1976 · N4070B · Substantial damage NTSB MIA76FKG59Accident · No injuriesClosedPiper PA-24 · Perry, GAApr 29, 1976 · N8892P · Substantial damage NTSB MIA76AM080Accident · 1 fatalClosedGlobe GC-1B · Valdosta, GAApr 26, 1976 · N78037 · Destroyed NTSB MIA76FKG58Accident · Serious injuriesClosedPiper PA-23 · Jonesboro, GAApr 24, 1976 · N2068P · Destroyed NTSB MIA76FKG57Accident · No injuriesClosedCessna 120 · St Simon Is, GAApr 20, 1976 · N2942N · Substantial damage NTSB MIA76FKG55Accident · No injuriesClosedCessna 150K · Fayetteville, GAApr 19, 1976 · N6489G · Substantial damage NTSB MIA76DKG56Accident · Serious injuriesClosedRaven RX-6 · Albany, GAApr 18, 1976 · N8692L · No damage NTSB MIA76FKG46Accident · No injuriesClosedPiper PA-28 · Stone Mountain, GAApr 17, 1976 · N9515J · Substantial damage NTSB MIA76DKG54Accident · No injuriesClosedPiper PA-18 · Leesburg, GAApr 12, 1976 · N9669P · Substantial damage NTSB MIA76FKG50Accident · No injuriesClosedPiper PA-34 · Savannah, GAApr 10, 1976 · N16389 · Substantial damage NTSB MIA76FKG53Accident · No injuriesClosedPiper PA-32 · Dalton, GAApr 7, 1976 · N41481 · Substantial damage NTSB MIA76FKG52Accident · Serious injuriesClosedMooney M20A · Midville, GAApr 4, 1976 · N8122E · Substantial damage NTSB MIA76FKG51Accident · Serious injuriesClosedHughes 269A · Comer, GAApr 3, 1976 · N8897F · Substantial damage NTSB MIA76DKG49Accident · No injuriesClosedCessna 185F · Resaca, GAMar 18, 1976 · N2530S · Substantial damage NTSB MIA76FKG48Accident · No injuriesClosedAero Comdr 500S · Jonesboro, GAMar 16, 1976 · N4590 · Substantial damage NTSB MIA76FKG47Accident · No injuriesClosedCessna 172 · Savannah, GAMar 14, 1976 · C-GAOC · Destroyed NTSB MIA76FKG45Accident · Minor injuriesClosedCessna 180 · Jefferson, GAFeb 29, 1976 · N76F · Substantial damage NTSB MIA76FKG44Accident · 1 fatalClosedAeronca 7AC · Griffin, GAFeb 29, 1976 · N1911E · Destroyed NTSB MIA76DKG43Accident · No injuriesClosedCessna 150M · Chamblee, GAFeb 21, 1976 · N3104V · Substantial damage NTSB MIA76FKG42Accident · No injuriesClosedBell TH13T · Atlanta, GAFeb 17, 1976 · N3GF · Substantial damage NTSB MIA76AM062Accident · 4 fatalClosedPiper PA-28R · Kennesaw, GAFeb 12, 1976 · N3954T · Destroyed NTSB MIA76AM061Accident · 2 fatalClosedBoeing E75 · Palmetto, GAFeb 10, 1976 · N622S · Destroyed NTSB MIA76FKG41Accident · No injuriesClosedCessna 150J · Tifton, GAFeb 4, 1976 · N50886 · Substantial damage NTSB MIA76AM059Accident · 3 fatalClosedCessha 182 · Mayfield, GAJan 30, 1976 · N3659U · Destroyed NTSB MIA76AM058Accident · 2 fatalClosedBeech V35 · Meigs, GAJan 30, 1976 · N2CB · Destroyed NTSB MIA76FKG40Accident · No injuriesClosedCessna A188B · Albany, GAJan 24, 1976 · N9509G · Substantial damage NTSB MIA76FKG39Accident · Minor injuriesClosedBeech B35 · Atlanta, GAJan 22, 1976 · N5237C · Substantial damage NTSB MIA76AM103Accident · Serious injuriesClosedBoeing 727 · Atlanta, GADec 22, 1975 · N454DA · No damage NTSB MIA76FKG38Accident · Serious injuriesClosedLake LA4200 · Ringgold, GADec 21, 1975 · N1082L · Substantial damage NTSB MIA76FKG37Accident · No injuriesClosedPiper PA-28R · Brunswick, GANov 29, 1975 · N3874T · Substantial damage NTSB MIA76FKG36Accident · No injuriesClosedCessna 170B · Fayetteville, GANov 28, 1975 · N3140A · Substantial damage NTSB MIA76AM045Accident · 2 fatalClosedCessna 120 · Warner Robins, GANov 22, 1975 · N3593V · Destroyed