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 MIA68F0142Accident · No injuriesClosedCessna 182 · Jonesboro, GAAug 9, 1967 · N9999T · Substantial damage NTSB MIA68F0145Accident · No injuriesClosedBeech N35 · Royston, GAAug 1, 1967 · N1364Z · Substantial damage NTSB MIA68D0151Accident · No injuriesClosedPiper PA-25 · Elko, GAAug 1, 1967 · N7407Z · Substantial damage NTSB MIA68F0132Accident · Serious injuriesClosedCallair A-9B · Meigs, GAJul 30, 1967 · N7615V · Substantial damage NTSB MIA68D0191Accident · No injuriesClosedPiper PA-25 · Butler, GAJul 29, 1967 · N4620Y · Substantial damage NTSB MIA68D0252Accident · No injuriesClosedPiper PA-25 · Sylvester, GAJul 27, 1967 · N7725Z · Substantial damage NTSB MIA68F0006Accident · Minor injuriesClosedPiper PA-25 · Pitts, GAJul 24, 1967 · N74829 · Substantial damage NTSB MIA68F0183Accident · Serious injuriesClosedCessna 150 · Douglasville, GAJul 23, 1967 · N7007F · Substantial damage NTSB MIA68F0138Accident · No injuriesClosedPiper PA-25 · Taylorville, GAJul 23, 1967 · N6251Z · Substantial damage NTSB MIA68A0010Accident · 1 fatalClosedAeronca 7BCM · Albany, GAJul 19, 1967 · N81791 · Destroyed NTSB MIA68F0139Accident · Serious injuriesClosedPiper PA-18 · Taylorsville, GAJul 18, 1967 · N3769P · Destroyed NTSB MIA68F0125Accident · No injuriesClosedBellanca 17-30 · Covington, GAJul 17, 1967 · N6698V · Substantial damage NTSB MIA68D0124Accident · No injuriesClosedCessna 172 · Glenville, GAJul 17, 1967 · N4134L · Substantial damage NTSB MIA68D0212Accident · No injuriesClosedPiper PA-28 · Twin City, GAJul 16, 1967 · N8368R · Substantial damage NTSB MIA68D0108Accident · No injuriesClosedBoeing A75N1 · Dawson, GAJul 16, 1967 · N55267 · Substantial damage NTSB MIA68D0134Accident · No injuriesClosedLuscombe 8F · Savannah, GAJul 15, 1967 · N1430B · Substantial damage NTSB MIA68D0120Accident · No injuriesClosedCessna 172B · Villa Rica, GAJul 14, 1967 · N7710X · Destroyed NTSB MIA68D0197Accident · No injuriesClosedPiper PA-30 · Jonesboro, GAJul 13, 1967 · N7777N · Substantial damage NTSB MIA68D0171Accident · No injuriesClosedBoeing A75 · Colquitt, GAJul 13, 1967 · N9163R · Substantial damage NTSB MIA68F0042Accident · No injuriesClosedPiper PA-23 · Augusta, GAJul 5, 1967 · N5557Y · Substantial damage NTSB MIA68D0041Accident · No injuriesClosedCessna 150 · Lithonia, GAJul 3, 1967 · N8607J · Substantial damage NTSB MIA68D0115Accident · No injuriesClosedPiper PA-24 · Albany, GAJun 30, 1967 · N8614P · Substantial damage NTSB MIA68F0055Accident · No injuriesClosedPiper PA-25 · Cairo, GAJun 28, 1967 · N7684Z · Substantial damage NTSB MIA68D0080Accident · No injuriesClosedPiper PA-22 · Augusta, GAJun 25, 1967 · N3073Z · Substantial damage NTSB MIA68D0068Accident · No injuriesClosedCessna 150 · Brunswick, GAJun 25, 1967 · N6615F · Substantial damage NTSB MIA68F0116Accident · No injuriesClosedCessna 180 · Mcdonough, GAJun 24, 1967 · N1606C · Substantial damage NTSB MIA68F0081Accident · 1 fatalClosedCallair A-9 · Camilla, GAJun 24, 1967 · N3587G · Destroyed NTSB MIA68F0039Accident · No injuriesClosedMooney M20C · Mitchell, GAJun 22, 1967 · N2600W · Substantial damage NTSB MIA68D0067Accident · No injuriesClosedCessna 172C · Savannah Beach, GAJun 20, 1967 · N1628Y · Substantial damage NTSB MIA68F0046Accident · No injuriesClosedCessna 210 · Atlanta, GAJun 17, 1967 · N3755Y · Substantial damage NTSB MIA68F0031Accident · No injuriesClosedFairchild M-62A · Marietta, GAJun 17, 1967 · N51090 · Substantial damage NTSB MIA68F0029Accident · Serious injuriesClosedCessna 172 · Griswold, GAJun 17, 1967 · N8925B · Destroyed NTSB MIA68F0016Accident · No injuriesClosedPiper PA-28 · Jekyll Island, GAJun 15, 1967 · N8132W · Substantial damage NTSB MIA67A0129Accident · 2 fatalClosedCessna 150F · Cartersville, GAJun 13, 1967 · N8755G · Destroyed NTSB MIA67A0126Accident · 2 fatalClosedBrantly 305 · Chamblee, GAMay 29, 1967 · N2219U · Destroyed NTSB MIA67A0125Accident · No injuriesClosedCessna 182H · Atlanta, GAMay 26, 1967 · N8542S · Substantial damage NTSB MIA67D0582Accident · No injuriesClosedPiper PA-28 · Stone Mountain, GAMay 24, 1967 · N8997J · Substantial damage NTSB MIA67D0579Accident · No injuriesClosedCessna 172 · Palmetto, GAMay 24, 1967 · N9168B · Substantial damage NTSB MIA67D0575Accident · No injuriesClosedCessna 150 · Fairburn, GAMay 23, 1967 · N3585J · Substantial damage NTSB MIA68D0037Accident · No injuriesClosedBeech 35G · Chamblee, GAMay 19, 1967 · N4237D · Substantial damage NTSB MIA68D0052Accident · Minor injuriesClosedBeech P35 · Atlanta, GAMay 18, 1967 · N8620M · Substantial damage NTSB MIA67D0036Accident · No injuriesClosedCessna 150 · Dublin, GAMay 15, 1967 · N8154S · Substantial damage NTSB MIA68F0073Accident · No injuriesClosedCessna 310J · Atlanta, GAMay 12, 1967 · N3149L · 2 aircraft · Substantial damage NTSB MIA68F0032Accident · Minor injuriesClosedCessna 172B · Atlanta, GAMay 11, 1967 · N965MD · Substantial damage NTSB MIA67F0545Accident · Minor injuriesClosedMooney M20C · Roopville, GAMay 5, 1967 · N6589U · Destroyed NTSB MIA68D0010Accident · No injuriesClosedCessna 150 · Allentown, GAMay 1, 1967 · N4045J · Substantial damage NTSB MIA68D0083Accident · No injuriesClosedPiper PA-24 · Marietta, GAApr 30, 1967 · N7159P · Substantial damage NTSB MIA68D0114Accident · No injuriesClosedPiper PA-24 · Omega, GAApr 29, 1967 · N6148P · Substantial damage NTSB MIA67A0116Accident · 1 fatalClosedBeech E18S · Acworth, GAApr 28, 1967 · N918X · Destroyed NTSB MIA67A0115Accident · No injuriesClosedLockheed Ga L-1329 · Brunswick, GAApr 27, 1967 · N372H · Substantial damage