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 MIA70F0095Accident · No injuriesClosedPiper PA-18 · Kennesaw, GAJun 15, 1969 · N100T · Substantial damage NTSB MIA69A0089Accident · Minor injuriesClosedConvair 440 · Macon, GAJun 10, 1969 · N4821C · Substantial damage NTSB MIA69A0086Accident · 2 fatalClosedPiper PA-12 · Villa Rica, GAJun 7, 1969 · N2366M · Destroyed NTSB MIA70F0001Accident · Minor injuriesClosedCessna 150 · Valdosta, GAJun 6, 1969 · N8775G · Substantial damage NTSB MIA69A0083Accident · 3 fatalClosedCessna 177 · Chamblee, GAJun 1, 1969 · N3347T · Destroyed NTSB MIA70D0049Accident · No injuriesClosedCessna 177 · Stone Mtn., GAMay 30, 1969 · N3180T · Substantial damage NTSB MIA69A0081Accident · 1 fatalClosedPiper PA-24 · Lawrenceville, GAMay 30, 1969 · N5938P · Destroyed NTSB MIA70F0092Accident · No injuriesClosedAero Comdr A-9B · Smithville, GAMay 29, 1969 · N7697V · Destroyed NTSB MIA69F0491Accident · Minor injuriesClosedCessna 140 · Temple, GAMay 28, 1969 · N76146 · Substantial damage NTSB MIA70F0082Accident · No injuriesClosedCessna 150G · Villa Rica, GAMay 25, 1969 · N3984J · Substantial damage NTSB MIA70F0257Accident · No injuriesClosedPiper PA-28 · Moultrie, GAMay 24, 1969 · N6465R · Substantial damage NTSB MIA70F0168Accident · No injuriesClosedCessna 182 · Marietta, GAMay 23, 1969 · N9262X · Substantial damage NTSB MIA70F0134Accident · No injuriesClosedLockheed PV-2 · Macon, GAMay 20, 1969 · N7273C · Substantial damage NTSB MIA70F0107Accident · No injuriesClosedCessna 182 · Atlanta, GAMay 17, 1969 · N2453Q · Substantial damage NTSB MIA70F0081Accident · No injuriesClosedCessna 411 · Augusta, GAMay 14, 1969 · N42E · Substantial damage NTSB MIA69D0451Accident · No injuriesClosedCessna 195B · Williamson, GAMay 14, 1969 · N2198C · Substantial damage NTSB MIA70F0126Accident · Minor injuriesClosedBeech C35 · Cecil, GAMay 9, 1969 · N5847C · Destroyed NTSB MIA69A0076Accident · 2 fatalClosedBeech V35 · Waycross, GAMay 9, 1969 · N755HB · Destroyed NTSB MIA70F0093Accident · No injuriesClosedLuscombe 8A · Lithonia, GAMay 4, 1969 · N2345K · Substantial damage NTSB MIA69F0483Accident · No injuriesClosedPiper PA-28 · Chamblee, GAMay 4, 1969 · N4668R · Substantial damage NTSB MIA69F0478Accident · No injuriesClosedCessna 172 · Cartersville, GAApr 29, 1969 · N2100Y · Substantial damage NTSB MIA69F0471Accident · No injuriesClosedPiper PA-12 · Tunnel Hill, GAApr 29, 1969 · N3767M · Substantial damage NTSB MIA69F0489Accident · No injuriesClosedPiper PA-24 · Atlanta, GAApr 28, 1969 · N5117P · Substantial damage NTSB MIA70F0027Accident · Serious injuriesClosedAeronca 65-TC · Cartersville, GAApr 20, 1969 · N31387 · Destroyed NTSB MIA70F0063Accident · No injuriesClosedCessna 310 · Valdosta, GAApr 15, 1969 · N5307A · Substantial damage NTSB MIA69D0422Accident · Minor injuriesClosedPiper PA-18 · Dial, GAApr 3, 1969 · N201T · Destroyed NTSB MIA69D0433Accident · No injuriesClosedCessna 140 · Jefferson, GAMar 31, 1969 · N2869N · Substantial damage NTSB MIA70F0050Accident · No injuriesClosedCessna 170A · Macon, GAMar 28, 1969 · N5444C · Substantial damage NTSB MIA69F0393Accident · No injuriesClosedCessna 150J · Chamblee, GAMar 19, 1969 · N50721 · Substantial damage NTSB MIA69A0055Accident · 1 fatalClosedPiper PA-24 · Warm Springs, GAMar 19, 1969 · N7631P · Destroyed NTSB MIA69D0468Accident · Minor injuriesClosedSchweizer SGU-2- · Sylvania, GAMar 2, 1969 · N5832V · Substantial damage NTSB MIA69D0394Accident · No injuriesClosedCessna 150 · Morrow, GAMar 1, 1969 · N3908U · Substantial damage NTSB MIA69F0463Accident · No injuriesClosedMooney M20G · Lithonia, GAFeb 27, 1969 · N3638N · Substantial damage NTSB MIA69F0431Accident · No injuriesClosedPiper PA-30 · Sandy Springs, GAFeb 19, 1969 · N7553Y · Destroyed NTSB MIA69F0409Accident · Serious injuriesClosedCessna 150 · Elko, GAFeb 19, 1969 · N4275U · Destroyed NTSB MIA69F0413Accident · No injuriesClosedCessna 150J · Alpharetta, GAFeb 13, 1969 · N51143 · Substantial damage NTSB MIA69A0046Accident · 2 fatalClosedBeech 95 · St.George, GAFeb 6, 1969 · N2724Y · Destroyed NTSB MIA69A0045Accident · 2 fatalClosedCessna 172 · Dalton, GAFeb 4, 1969 · N5871R · Substantial damage NTSB MIA69D0399Accident · No injuriesClosedPiper PA-28 · Macon, GAFeb 2, 1969 · N7680J · Substantial damage NTSB MIA69D0383Accident · No injuriesClosedPiper PA-18 · Saint Marys, GAFeb 2, 1969 · N2779A · Substantial damage NTSB MIA69A0040Accident · 1 fatalClosedMeyers 200 · Fairyland, GAJan 18, 1969 · N459C · Destroyed NTSB MIA70D0020Accident · No injuriesClosedPiper PA-24 · Ringgold, GAJan 15, 1969 · N7255P · Substantial damage NTSB MIA69F0452Accident · No injuriesClosedCessna 182 · Norcross, GAJan 12, 1969 · N4755D · Substantial damage NTSB MIA69F0363Accident · No injuriesClosedCessna 150G · Lithonia, GAJan 4, 1969 · N8607J · Substantial damage NTSB MIA69A0035Accident · No injuriesClosedCessna 337 · Chamblee, GADec 29, 1968 · N2115X · No damage NTSB MIA69A0034Accident · 4 fatalClosedSiai-Marche 205-22 · Tifton, GADec 27, 1968 · N997WA · Destroyed NTSB MIA69A0032Accident · No injuriesClosedCessna 182K · Rome, GADec 20, 1968 · N2812R · 2 aircraft · Substantial damage NTSB MIA69F0353Accident · No injuriesClosedCessna 172 · Fairburn, GADec 19, 1968 · N8134U · Substantial damage NTSB MIA69F0385Accident · No injuriesClosedBeech S35 · Dawson, GADec 11, 1968 · N5649K · Substantial damage NTSB MIA69A0030Accident · 1 fatalClosedCessna 172 · Stone Mountain, GADec 5, 1968 · N7039T · Destroyed