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 MIA65F0055Accident · Serious injuriesClosedMorrisey 2150A · Gainesville, GAFeb 28, 1965 · N5146V · Destroyed NTSB MIA65D0003Accident · No injuriesClosedAero Cmdr 520 · Fayetteville, GAFeb 28, 1965 · N9093R · Substantial damage NTSB MIA65D0063Accident · No injuriesClosedPiper PA-28 · Atlanta, GAFeb 27, 1965 · N6220W · Substantial damage NTSB UNK65X1438Accident · Serious injuriesClosedPiper PA-12 · Dawson, GAFeb 19, 1965 · N7712H · Substantial damage NTSB UNK65X1436Accident · No injuriesClosedStinson 108-2 · Columbus, GAFeb 19, 1965 · N8019K · Substantial damage NTSB UNK65X1418Accident · No injuriesClosedCessna 150 · Buford, GAFeb 13, 1965 · N5696E · Destroyed NTSB UNK65X1415Accident · No injuriesClosedMooney 20A · Eastman, GAFeb 12, 1965 · N6062X · Substantial damage NTSB MIA65A0080Accident · No injuriesClosedCurtiss C-46 · Atlanta, GAFeb 8, 1965 · N67970 · Substantial damage NTSB UNK65X1364Accident · No injuriesClosedPiper PA23 · Atlanta, GAJan 28, 1965 · N5329Y · Substantial damage NTSB MIA65A0077Accident · 3 fatalClosedCessna 150 · Americus, GAJan 26, 1965 · N7901Z · Destroyed NTSB UNK65X1347Accident · No injuriesClosedPiper PA28 · Hazelhurst, GAJan 25, 1965 · N7655W · Substantial damage NTSB UNK65X1327Accident · No injuriesClosedBeechraft C35 · Stockbridge, GAJan 21, 1965 · N8066E · Substantial damage NTSB UNK65X1042Accident · No injuriesClosedPiper PA24 · Savannah, GADec 18, 1964 · N7781P · Substantial damage NTSB UNK65X0999Accident · No injuriesClosedBeechraft B50A · Atlanta, GADec 13, 1964 · N1378Z · Substantial damage NTSB UNK65X0931Accident · No injuriesClosedPiper PA24 · Athens, GADec 5, 1964 · N6993P · Substantial damage NTSB UNK65X0915Accident · No injuriesClosedCessna 172 · Jonesboro, GADec 4, 1964 · N5625A · Substantial damage NTSB UNK65X0871Accident · No injuriesClosedCessna 210 · Macon, GANov 28, 1964 · N7429E · Substantial damage NTSB UNK65X0745Accident · 6 fatalClosedBeechcraft A35 · Chatsworth, GANov 16, 1964 · N730B · Destroyed NTSB UNK65X0696Accident · Minor injuriesClosedChampion 7EC · Villa Rica, GANov 14, 1964 · N7598E · Substantial damage NTSB UNK65X0564Accident · No injuriesClosedCessna 150 · Jonesboro, GANov 5, 1964 · N1148Y · Substantial damage NTSB UNK65X0378Accident · No injuriesClosedPiper PA24 · Marietta, GAOct 22, 1964 · N7622P · Substantial damage NTSB UNK64X4143Accident · No injuriesClosedCallair A9 · Fort Valley, GASep 25, 1964 · N3612G · Destroyed NTSB UNK64X4071Accident · No injuriesClosedBeechcraft N35 · Atlanta, GASep 20, 1964 · N9450Y · Substantial damage NTSB UNK64X4033Accident · No injuriesClosedCallair A9 · Mill Haven, GASep 18, 1964 · N3579G · Substantial damage NTSB UNK64X3995Accident · Minor injuriesClosedGrumman G164 · Shellnan, GASep 15, 1964 · N597Y · Substantial damage NTSB UNK64X3931Accident · 1 fatalClosedCessna 140 · Darien, GASep 12, 1964 · N76246 · Substantial damage NTSB UNK64X3849Accident · No injuriesClosedCessna 180 · Centralhatchee, GASep 7, 1964 · N2493C · Substantial damage NTSB UNK64X3833Accident · 2 fatalClosedAero Comm 560 · Norcross, GASep 6, 1964 · N2680B · Destroyed NTSB UNK64X3762Accident · Minor injuriesClosedPiper PA18A · Winder, GASep 4, 1964 · N7294D · Substantial damage NTSB UNK64X3718Accident · Minor injuriesClosedPiper J3 · Unadilla, GASep 1, 1964 · N42819 · Substantial damage NTSB UNK64X3633Accident · No injuriesClosedHughes 269A · Waynesboro, GAAug 27, 1964 · N8758F · Substantial damage NTSB UNK64X3594Accident · Serious injuriesClosedPiper J3 · Senoia, GAAug 25, 1964 · N2220M · Destroyed NTSB UNK64X3577Accident · No injuriesClosedCallair A5T · Bainbridge, GAAug 24, 1964 · N2960G · Substantial damage NTSB UNK64X3557Accident · No injuriesClosedBeechcraft T34 · Jesup, GAAug 23, 1964 · N4946C · Substantial damage NTSB UNK64X3554Accident · No injuriesClosedCessna 175 · Cohutta, GAAug 23, 1964 · N6792E · Substantial damage NTSB UNK64X3541Accident · Minor injuriesClosedCallair A5 · Camillia, GAAug 22, 1964 · N9970C · Destroyed NTSB UNK64X3524Accident · 1 fatalClosedCessna 172 · Macon, GAAug 21, 1964 · N7364T · Destroyed NTSB UNK64X3515Accident · Minor injuriesClosedBoeing A75N1 · Edison, GAAug 21, 1964 · N54554 · Substantial damage NTSB UNK64X3497Accident · Serious injuriesClosedPiper J3C · Cassville, GAAug 20, 1964 · N70615 · Substantial damage NTSB UNK64X3445Accident · No injuriesClosedMooney M18C · Cuthbert, GAAug 18, 1964 · N4133 · Substantial damage NTSB UNK64X3420Accident · No injuriesClosedPiper PA12 · Carrolton, GAAug 16, 1964 · N2846M · Substantial damage NTSB UNK64X3414Accident · No injuriesClosedPiper PA24 · Cochran, GAAug 16, 1964 · N6394P · Substantial damage NTSB UNK64X3404Accident · 1 fatalClosedPiper PA-22 · Dalton, GAAug 15, 1964 · N3575A · Destroyed NTSB UNK64X3350Accident · Serious injuriesClosedBell 47G4 · Blakely, GAAug 12, 1964 · N3064G · Substantial damage NTSB UNK64X3218Accident · Serious injuriesClosedPiper PA25 · Berlin, GAAug 4, 1964 · N11984 · Destroyed NTSB UNK64X3217Accident · No injuriesClosedPiper PA24 · Rochelle, GAAug 4, 1964 · N7035P · Substantial damage NTSB UNK64X3214Accident · No injuriesClosedPiper PA11 · Tifton, GAAug 4, 1964 · N4649N · Substantial damage NTSB UNK64X3121Accident · No injuriesClosedBeechcraft G35 · Nashville, GAJul 30, 1964 · N4287D · Substantial damage NTSB UNK64X3076Accident · Minor injuriesClosedHughes 269A · Tennille, GAJul 27, 1964 · N8852F · Substantial damage NTSB UNK64X3057Accident · Serious injuriesClosedBoeing A75N1 · Americus, GAJul 26, 1964 · N73611 · Substantial damage