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 MIA73DKG42Accident · No injuriesClosedCessna 150H · Canton, GAOct 11, 1972 · N23486 · Substantial damage NTSB MIA73DKG41Accident · No injuriesClosedCallair A-9 · Fairmount, GAOct 8, 1972 · N7233V · Substantial damage NTSB MIA73FKG43Accident · 1 fatalClosedPiper J3C-65 · Lagrange, GAOct 7, 1972 · N7398H · No damage NTSB MIA73FKG38Accident · No injuriesClosedPiper PA-28 · Jonesboro, GASep 26, 1972 · N2660T · Substantial damage NTSB MIA73FKG40Accident · Serious injuriesClosedCessna 336 · Augusta, GASep 25, 1972 · N1794Z · Destroyed NTSB MIA73FKG36Accident · No injuriesClosedCessna 401 · Gainesville, GASep 20, 1972 · N7822F · Substantial damage NTSB MIA73DKG39Accident · No injuriesClosedCessna 180 · Augusta, GASep 20, 1972 · N92CP · Substantial damage NTSB MIA73FKG37Accident · Minor injuriesClosedPiper PA-28 · Kennesaw, GASep 17, 1972 · N5096T · 2 aircraft · Substantial damage NTSB MIA73FKG35Accident · No injuriesClosedPiper PA-24 · Augusta, GASep 16, 1972 · N8552P · Substantial damage NTSB MIA73FKG33Accident · Serious injuriesClosedHughes 269A · Elberton, GASep 6, 1972 · N8917F · Destroyed NTSB MIA73DKG18Accident · No injuriesClosedAmer Avco AA1A · Ft Benning, GASep 6, 1972 · N9305L · Substantial damage NTSB MIA73AM024Accident · 2 fatalClosedPiper PA-28 · Alma, GAAug 29, 1972 · N95391 · Destroyed NTSB MIA73DKG31Accident · No injuriesClosedMooney M20 · Stone Mountain, GAAug 25, 1972 · N3595X · Substantial damage NTSB MIA73AM022Accident · 3 fatalClosedCessna 337C · Mount Vernon, GAAug 24, 1972 · N2584S · Destroyed NTSB MIA73AM020Accident · No injuriesClosedFord MTR 5-AT-B · Peachtree City, GAAug 23, 1972 · N9637 · Substantial damage NTSB MIA73DKG30Accident · No injuriesClosedPiper J-3C · Quitman, GAAug 22, 1972 · N98483 · Substantial damage NTSB MIA73DKG28Accident · No injuriesClosedTaylorcraft BC-65 · Monteith, GAAug 20, 1972 · N23606 · Substantial damage NTSB MIA73FKG26Accident · No injuriesClosedAero Comdr 520 · Thomson, GAAug 18, 1972 · N2636B · Substantial damage NTSB MIA73DKG27Accident · No injuriesClosedCessna 310 · Atlanta, GAAug 16, 1972 · N1310 · Substantial damage NTSB MIA73DKG23Accident · No injuriesClosedPiper PA-24 · Hartwell, GAAug 15, 1972 · N6145P · Destroyed NTSB MIA73FKG24Accident · Serious injuriesClosedThorp T-18 · Marietta, GAAug 13, 1972 · N110JH · Destroyed NTSB MIA73DKG25Accident · No injuriesClosedCessna 150 · Hortense, GAAug 13, 1972 · N8715S · Substantial damage NTSB MIA73FKG22Accident · No injuriesClosedPiper PA-18 · Cordele, GAAug 12, 1972 · N7266K · Substantial damage NTSB MIA73FKG21Accident · 1 fatalClosedCessna A188A · Sylvester, GAAug 5, 1972 · N4409Q · Destroyed NTSB MIA73DKG20Accident · No injuriesClosedAero Comdr A-9B · Vienna, GAAug 4, 1972 · N8021V · Destroyed NTSB MIA73FKG19Accident · No injuriesClosedBeech 58 · Lithonia, GAAug 1, 1972 · N8400C · Substantial damage NTSB MIA73FKG17Accident · No injuriesClosedPiper PA-25 · Chula, GAJul 30, 1972 · N8596L · Substantial damage NTSB MIA73FKG16Accident · No injuriesClosedPiper PA-22 · Lithonia, GAJul 29, 1972 · N1518P · Substantial damage NTSB MIA73DKG15Accident · No injuriesClosedPiper PA-25 · Shellman, GAJul 26, 1972 · N4460Y · Substantial damage NTSB MIA73FKG11Accident · No injuriesClosedAero Comdr A-9 · Warrenton, GAJul 25, 1972 · N7622V · Substantial damage NTSB MIA73AM011Accident · 3 fatalClosedMooney M-20C · Texas, GAJul 25, 1972 · N5951Q · Destroyed NTSB MIA73DKG14Accident · No injuriesClosedGrumman G-164A · Sardis, GAJul 24, 1972 · N6571 · Substantial damage NTSB MIA73FKG10Accident · No injuriesClosedCessna 207 · Morven, GAJul 23, 1972 · N1504U · Substantial damage NTSB MIA73FKG09Accident · Serious injuriesClosedCessna 150E · Atlanta, GAJul 23, 1972 · N2568J · Substantial damage NTSB MIA73DKG08Accident · Minor injuriesClosedPiper PA-18A · Cordele, GAJul 22, 1972 · N9473D · Substantial damage NTSB MIA73FKGO7Accident · 2 fatalClosedStarduster SA300 · Peachtree City, GAJul 20, 1972 · N4706 · Destroyed NTSB MIA73DKG06Accident · No injuriesClosedCessna 150 · Butler, GAJul 20, 1972 · N8308G · Substantial damage NTSB MIA73DKG13Accident · No injuriesClosedCessna 140 · Claxton, GAJul 14, 1972 · N2220N · Substantial damage NTSB MIA73DKG12Accident · No injuriesClosedPiper PA-22 · Savannah, GAJul 13, 1972 · N1948P · Substantial damage NTSB MIA73DKG32Accident · No injuriesClosedLuscombe 8A · Macon, GAJul 11, 1972 · N71990 · Substantial damage NTSB MIA73FKG05Accident · No injuriesClosedCessna 172A · Rome, GAJul 9, 1972 · N7782T · Substantial damage NTSB MIA73AM008Accident · 3 fatalClosedCessna 182P · Lyons, GAJul 6, 1972 · N7357Q · Destroyed NTSB MIA73DKG03Accident · No injuriesClosedCessna A188 · Sylvester, GAJul 3, 1972 · N2133U · Substantial damage NTSB MIA73DKG04Accident · No injuriesClosedPiper PA-18 · Adairsville, GAJul 2, 1972 · N234T · Substantial damage NTSB MIA73AM004Accident · 2 fatalClosedSchweizer SGS233 · Williamson, GAJul 2, 1972 · N1199S · Destroyed NTSB MIA73DKG02Accident · Minor injuriesClosedPiper J-3 · Kathleen, GAJul 1, 1972 · N122JT · Substantial damage NTSB MIA73AM001Accident · 2 fatalClosedMidamerican 172 · Vidalia, GAJul 1, 1972 · N6418B · Destroyed NTSB MIA72DKH25Accident · No injuriesClosedCessna 150 · St Marys, GAJun 30, 1972 · N23304 · Substantial damage NTSB MIA72FKH24Accident · No injuriesClosedBeech M35 · Chamblee, GAJun 29, 1972 · N9483Y · Substantial damage NTSB MIA72DKH21Accident · Minor injuriesClosedCessna A188 · Shellman, GAJun 27, 1972 · N5661J · Substantial damage