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 MIA66D0373Accident · No injuriesClosedPiper PA-28 · Savannah, GADec 10, 1965 · N5797W · Substantial damage NTSB MIA66F0387Accident · 1 fatalClosedAeronca 7AC · Claxton, GADec 5, 1965 · N81509 · Destroyed NTSB MIA66D0380Accident · Minor injuriesClosedAeronca L-16 · Clyattville, GADec 5, 1965 · N2555B · Substantial damage NTSB MIA66A0062Accident · 1 fatalClosedCessna 172 · St Marys, GANov 27, 1965 · N6232E · Destroyed NTSB MIA66F0381Accident · Serious injuriesClosedCessna 172 · Baxley, GANov 26, 1965 · N9709T · Destroyed NTSB MIA66A0058Accident · No injuriesClosedBrantly B-2B · Fort Valley, GANov 20, 1965 · N2164U · Substantial damage NTSB MIA66F0388Accident · No injuriesClosedPiper PA-24 · Columbus, GANov 19, 1965 · N5210P · Substantial damage NTSB MIA66F0327Accident · No injuriesClosedWaco UEC · Macon, GANov 19, 1965 · N13037 · Substantial damage NTSB MIA66A0055Accident · 4 fatalClosedBeechcraft M35 · Red Oak, GANov 11, 1965 · N9742R · Destroyed NTSB MIA66I0053Incident · No injuriesClosedDouglas DC-7 · Atlanta, GANov 5, 1965 · N8215H · Substantial damage NTSB MIA66D0316Accident · No injuriesClosedBeechcraft M-23 · Milledgeville, GANov 4, 1965 · N8723M · Substantial damage NTSB MIA66A0052Accident · Minor injuriesClosedPiper PA-24 · Homer, GANov 4, 1965 · N6579P · Substantial damage NTSB MIA66A0048Accident · No injuriesClosedMartin B-26C · Atlanta, GAOct 29, 1965 · N5546N · Substantial damage NTSB MIA66A0045Accident · 2 fatalClosedCessna 205 · St Simons Isle, GAOct 22, 1965 · N4819U · Destroyed NTSB MIA66F0314Accident · No injuriesClosedCessna 172 · Ludowici, GAOct 21, 1965 · N7367T · Substantial damage NTSB MIA66F0319Accident · Serious injuriesClosedPiper PA-28 · Chamblee, GAOct 17, 1965 · N6209W · Destroyed NTSB MIA66A0041Accident · 2 fatalClosedBrantly B-2 · Griffin, GAOct 13, 1965 · N5975X · Destroyed NTSB MIA66D0265Accident · No injuriesClosedCessna 120 · Chamblee, GAOct 3, 1965 · N3185N · Substantial damage NTSB MIA66D0268Accident · No injuriesClosedPiper PA-28 · Jonesboro, GAOct 2, 1965 · N5824W · Substantial damage NTSB MIA66F0271Accident · No injuriesClosedBeechcraft 35 · Pine Mountain, GASep 25, 1965 · N2962V · Substantial damage NTSB MIA66A0033Accident · 1 fatalClosedCessna 170B · Chamblee, GASep 22, 1965 · N3513C · Substantial damage NTSB MIA66F0269Accident · No injuriesClosedPiper PA-25 · Pinehurst, GASep 21, 1965 · N6976Z · Substantial damage NTSB MIA66F0272Accident · Serious injuriesClosedPiper PA28 · Valdosta, GASep 18, 1965 · N6336W · No damage NTSB MIA66A0032Accident · 2 fatalClosedCessna 150 · Resaca, GASep 16, 1965 · N7960E · Destroyed NTSB MIA66D0242Accident · No injuriesClosedCommonwelth 185 · Jonesboro, GASep 11, 1965 · N60966 · Substantial damage NTSB MIA66F0220Accident · No injuriesClosedCessna 150 · Griffin, GASep 10, 1965 · N3080J · Substantial damage NTSB MIA66A0029Accident · No injuriesClosedBeechcraft D-18S · Atlanta, GASep 8, 1965 · N57CC · Substantial damage NTSB MIA66D0230Accident · No injuriesClosedPiper PA-28 · Columbus, GASep 5, 1965 · N6673W · Substantial damage NTSB MIA66D0219Accident · Minor injuriesClosedPiper PA-22 · Savannah, GASep 4, 1965 · N977A · Destroyed NTSB MIA66F0197Accident · No injuriesClosedPiper PA-22 · Chamblee, GASep 1, 1965 · N8915C · Substantial damage NTSB MIA66D0203Accident · No injuriesClosedBellanca 14-13 · Dawson, GASep 1, 1965 · N7614E · Substantial damage NTSB MIA66D0235Accident · No injuriesClosedCessna 182 · Hartwell, GAAug 31, 1965 · N2072D · Substantial damage NTSB MIA66A0024Accident · No injuriesClosedCurtis C-46F · Atlanta, GAAug 31, 1965 · N606Z · Substantial damage NTSB MIA66F0157Accident · No injuriesClosedCallair A-5 · Pelham, GAAug 28, 1965 · N9970C · Substantial damage NTSB MIA66F0202Accident · No injuriesClosedPiper PA-25 · Cochran, GAAug 23, 1965 · N7390Z · Substantial damage NTSB MIA66D0199Accident · No injuriesClosedPiper PA-28 · Chamblee, GAAug 22, 1965 · N7027W · Substantial damage NTSB MIA66F0171Accident · No injuriesClosedPiper PA-25 · Harrison, GAAug 21, 1965 · N7497Z · Destroyed NTSB MIA66F0168Accident · No injuriesClosedCessna 175 · Rhine, GAAug 21, 1965 · N9443B · Substantial damage NTSB MIA66F0172Accident · No injuriesClosedLuscombe 8A · Macon, GAAug 20, 1965 · N1706K · Substantial damage NTSB MIA66F0160Accident · No injuriesClosedPiper PA-25 · Girard, GAAug 16, 1965 · N7246Z · Substantial damage NTSB MIA66F0148Accident · No injuriesClosedGrumman G-164 · Smithville, GAAug 16, 1965 · N609U · Destroyed NTSB MIA66F0181Accident · Serious injuriesClosedPiper PA-18 · Lenox, GAAug 5, 1965 · N1316A · Destroyed NTSB MIA66F0092Accident · No injuriesClosedPiper PA-25 · Pinehurst, GAAug 2, 1965 · N6510Z · Substantial damage NTSB MIA66F0155Accident · No injuriesClosedPiper PA-18 · Tifton, GAJul 19, 1965 · N9469D · Substantial damage NTSB MIA66F0089Accident · No injuriesClosedAeronca 15AC · Atlanta, GAJul 19, 1965 · N1217H · Substantial damage NTSB MIA66F0110Accident · Serious injuriesClosedTaylorcraft BC12D1 · Savannah, GAJul 18, 1965 · N44214 · Destroyed NTSB MIA66D0111Accident · No injuriesClosedSlingsby SL4 · Madison, GAJul 18, 1965 · N256JB · Substantial damage NTSB MIA66F0109Accident · Minor injuriesClosedBoeing A-75N1 · Bronwood, GAJul 15, 1965 · N62142 · Substantial damage NTSB MIA66D0124Accident · No injuriesClosedCessna 180 · Lafayette, GAJul 15, 1965 · N6577A · Substantial damage NTSB MIA66A0009Accident · 1 fatalClosedPiper PA-18A · Jacksonville, GAJul 14, 1965 · N9922D · Destroyed