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 UNK64X3011Accident · Minor injuriesClosedPiper PA18 · Lenox, GAJul 24, 1964 · N7285K · Substantial damage NTSB UNK64X2972Accident · No injuriesClosedBoeing A75N1 · Dawson, GAJul 22, 1964 · N53793 · Substantial damage NTSB UNK64X2971Accident · No injuriesClosedPiper PA25 · Screvin, GAJul 22, 1964 · N6776Z · Destroyed NTSB UNK64X2957Accident · Minor injuriesClosedBoing A75N1 · Damascus, GAJul 21, 1964 · N62288 · Destroyed NTSB UNK64X2893Accident · No injuriesClosedPiper PA23 · Atlanta, GAJul 18, 1964 · N4594P · Substantial damage NTSB UNK64X2857Accident · No injuriesClosedMooney MK20A · Atlanta, GAJul 16, 1964 · N6031X · Substantial damage NTSB UNK64X2846Accident · Minor injuriesClosedCessna 210 · Chamblee, GAJul 15, 1964 · N9678X · Substantial damage NTSB UNK64X2818Accident · No injuriesClosedBeechcraft 23 · Columbus, GAJul 14, 1964 · N2325J · Substantial damage NTSB UNK64X2736Accident · No injuriesClosedAeronca 7BM · Augusta, GAJul 9, 1964 · N81545 · Substantial damage NTSB UNK64X2553Accident · No injuriesClosedPiper PA18 · Atlanta, GAJun 28, 1964 · N723C · Substantial damage NTSB UNK64X2478Accident · No injuriesClosedCessna 172 · Cloudland, GAJun 25, 1964 · N2492U · Substantial damage NTSB UNK64X2318Accident · No injuriesClosedCessna 150 · Butler, GAJun 16, 1964 · N7204X · Substantial damage NTSB UNK64X2300Accident · No injuriesClosedNavion NAV4 · Lithonia, GAJun 15, 1964 · N4381K · Substantial damage NTSB UNK64X2288Accident · No injuriesClosedCessna 172 · Cairo, GAJun 14, 1964 · N6886A · Substantial damage NTSB UNK64X2129Accident · No injuriesClosedPiper PA22 · Lithonia, GAJun 5, 1964 · N3234Z · Substantial damage NTSB UNK64X2015Accident · No injuriesClosedCessna 120 · Folkstown, GAMay 30, 1964 · N5N · Substantial damage NTSB UNK64X1973Accident · No injuriesClosedErcoupe 415C · Mccaysville, GAMay 27, 1964 · N99864 · Substantial damage NTSB UNK64X1967Incident · No injuriesClosedBoeing B-720 · Alma, GAMay 27, 1964 · N8708E · No damage NTSB UNK64X1951Accident · No injuriesClosedPiper PA22 · Columbus, GAMay 25, 1964 · N9976D · Substantial damage NTSB UNK64X1918Accident · No injuriesClosedCessna 175 · Brunswick, GAMay 23, 1964 · N8341T · Substantial damage NTSB UNK64X1806Accident · No injuriesClosedAeronca 11CC · Mt Vernon, GAMay 17, 1964 · N4297E · Substantial damage NTSB UNK64X1540Accident · No injuriesClosedMooney M21 · Atlanta, GAMay 1, 1964 · N6903U · Substantial damage NTSB UNK64X1389Accident · No injuriesClosedCessna 182D · Atlanta, GAApr 20, 1964 · N3271Y · Substantial damage NTSB UNK64X1384Accident · No injuriesClosedPiper PA25 · Ft. Valley, GAApr 19, 1964 · N6614Z · Destroyed NTSB UNK64X1376Accident · No injuriesClosedBeechcraft B23 · Savannah, GAApr 19, 1964 · N2327Q · Substantial damage NTSB UNK64X1140Accident · No injuriesClosedCessna 310G · St Simons Is, GAApr 3, 1964 · N395BS · Substantial damage NTSB UNK64X1097Accident · Minor injuriesClosedPiper PA22 · Cecil, GAMar 29, 1964 · N962A · Substantial damage NTSB UNK64X1094Accident · No injuriesClosedBellanca 14132 · Waycross, GAMar 29, 1964 · N74332 · Substantial damage NTSB UNK64X0898Accident · No injuriesClosedBeechcraft 35 · Savannah, GAMar 13, 1964 · N2953V · Destroyed NTSB UNK64X0684Accident · No injuriesClosedMooney M20A · Covington, GAFeb 24, 1964 · N8390E · Substantial damage NTSB UNK64X0671Accident · No injuriesClosedMooney M21 · Columbus, GAFeb 23, 1964 · N1362W · Substantial damage NTSB UNK64X0590Accident · No injuriesClosedPiper PA24 · Chamblee, GAFeb 16, 1964 · N6579P · Substantial damage NTSB UNK64X0543Accident · Minor injuriesClosedPiper PA22 · Carrolton, GAFeb 12, 1964 · N4534A · Substantial damage NTSB UNK64X0539Accident · Minor injuriesClosedCessna 120 · Cuthbert, GAFeb 11, 1964 · N1771N · Destroyed NTSB UNK64X0448Accident · 2 fatalClosedChampion 7GCB · Lithonia, GAFeb 3, 1964 · N9972Y · Destroyed NTSB UNK64X0353Accident · No injuriesClosedPiper PA30 · Columbus, GAJan 25, 1964 · N7215Y · Substantial damage NTSB UNK64X0328Accident · No injuriesClosedPiper PA24 · Atlanta, GAJan 23, 1964 · N7038P · Substantial damage NTSB UNK64X0319Accident · No injuriesClosedBeechcraft F35 · Moultrie, GAJan 22, 1964 · N4230B · 2 aircraft · Substantial damage NTSB UNK64X0175Accident · No injuriesClosedCessna 150A · Atlanta, GAJan 6, 1964 · N7088X · Destroyed NTSB MIA64A0050Accident · No injuriesClosedDouglas DC-7B · Atlanta, GANov 1, 1963 · N823D · Substantial damage NTSB MIA64A0049Accident · No injuriesClosedConvair 440 · Atlanta, GANov 1, 1963 · N4815C · Substantial damage NTSB MIA62A0090Accident · No injuriesClosedCurtiss-Wrt C-46A · Macon, GADec 4, 1962 · N5131B · Substantial damage