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 MIA67D0097Accident · No injuriesClosedMooney M20C · Cedartown, GAJun 19, 1966 · N6954U · Substantial damage NTSB MIA67D0062Accident · Minor injuriesClosedWaco UPF-7 · Stone Mountain, GAJun 19, 1966 · N29324 · Substantial damage NTSB MIA66F0621Accident · No injuriesClosedMooney M20E · Fairburn, GAJun 19, 1966 · N1256X · Substantial damage NTSB MIA66A0146Accident · 4 fatalClosedNavion NAV-4 · Newman, GAJun 19, 1966 · N4610K · Destroyed NTSB MIA66D0078Accident · No injuriesClosedCessna 150 · Atlanta, GAJun 15, 1966 · N3972U · Substantial damage NTSB MIA67F0095Accident · Serious injuriesClosedStinson 108-2 · Atlanta, GAJun 12, 1966 · N40155 · Destroyed NTSB MIA67F0048Accident · Minor injuriesClosedCessna 182A · Ocilla, GAJun 12, 1966 · N3863D · Substantial damage NTSB MIA66D0617Accident · No injuriesClosedCessna 120 · Milledgeville, GAJun 5, 1966 · N3678V · Substantial damage NTSB MIA66D0614Accident · No injuriesClosedCessna 150 · Thomaston, GAJun 5, 1966 · N6033T · Substantial damage NTSB MIA67D0047Accident · No injuriesClosedCessna 140 · Blairsville, GAJun 3, 1966 · N2511N · Substantial damage NTSB MIA66F0585Accident · No injuriesClosedBeech S35 · Chamblee, GAMay 31, 1966 · N5632K · Substantial damage NTSB MIA67F0008Accident · No injuriesClosedCessna 195 · Cartersville, GAMay 29, 1966 · N3476V · Substantial damage NTSB MIA67F0067Accident · No injuriesClosedStearman A75 · Fitzgerald, GAMay 28, 1966 · N59881 · Substantial damage NTSB MIA66D0586Accident · No injuriesClosedPiper PA-22 · Sylvester, GAMay 22, 1966 · N3341A · Substantial damage NTSB MIA67F0066Accident · No injuriesClosedCallair A-5 · Camilla, GAMay 21, 1966 · N2917G · Destroyed NTSB MIA66F0584Accident · Serious injuriesClosedPiper PA-28 · St Simons Isld, GAMay 15, 1966 · N6432W · Destroyed NTSB MIA66A0131Accident · 1 fatalClosedCessna 150 · Lagrange, GAMay 13, 1966 · N3513J · Destroyed NTSB MIA66I0590Accident · 1 fatalClosedAeronca O-58 · Sylvania, GAMay 10, 1966 · N49769 · Destroyed NTSB MIA66D0540Accident · No injuriesClosedCessna 150 · Chamblee, GAMay 9, 1966 · N8821S · Substantial damage NTSB MIA66D0591Accident · No injuriesClosedCessna 182 · Atlanta, GAApr 30, 1966 · N3513Y · Substantial damage NTSB MIA66D0587Accident · No injuriesClosedPiper PA28 · Toccoa, GAApr 29, 1966 · N8200W · Substantial damage NTSB MIA67F0032Accident · No injuriesClosedCessna 182A · Stockbridge, GAApr 17, 1966 · N4090D · Substantial damage NTSB MIA66D0539Accident · No injuriesClosedPiper PA-28 · Ashburn, GAApr 13, 1966 · N4615R · Substantial damage NTSB MIA66D0514Accident · No injuriesClosedCessna 172 · Chamblee, GAMar 31, 1966 · N2526U · Substantial damage NTSB MIA66D0503Accident · No injuriesClosedCessna 172 · Dalton, GAMar 31, 1966 · N3792S · Substantial damage NTSB MIA66A0111Accident · No injuriesClosedBrantly B-2B · Stone Mountain, GAMar 27, 1966 · N2278U · Substantial damage NTSB MIA66D0532Accident · No injuriesClosedPiper PA-28 · Savannah, GAMar 25, 1966 · N6326W · Substantial damage NTSB MIA66F0483Accident · Serious injuriesClosedLuscombe 8A · Griffin, GAMar 19, 1966 · N2160B · Substantial damage NTSB MIA66D0526Accident · No injuriesClosedCessna 150 · Nicholis, GAMar 16, 1966 · N7970Z · Substantial damage NTSB MIA66D0456Accident · No injuriesClosedCessna 172 · Villa Rica, GAMar 9, 1966 · N8595U · Substantial damage NTSB MIA66D0482Accident · No injuriesClosedCessna 180 · Griffin, GAMar 8, 1966 · N2388C · Substantial damage NTSB MIA66F0509Accident · Minor injuriesClosedCessna 172 · Athens, GAMar 4, 1966 · N2586U · Substantial damage NTSB MIA66F0508Accident · No injuriesClosedPiper PA-22 · Hiltonia, GAMar 3, 1966 · N3345Z · Substantial damage NTSB MIA66D0468Accident · No injuriesClosedCessna 120 · Jonesboro, GAMar 1, 1966 · N2918N · Substantial damage NTSB MIA66A0098Accident · 4 fatalClosedNavion NAV-A · Ellijay, GAFeb 28, 1966 · N4097K · Destroyed NTSB MIA66A0096Accident · 4 fatalClosedCessna 182 · Muscogee, GAFeb 27, 1966 · N5314B · Destroyed NTSB MIA66F0511Accident · Serious injuriesClosedErc0 415-D · Silver City, GAFeb 26, 1966 · N2871H · Substantial damage NTSB MIA66F0475Accident · No injuriesClosedBeech D95A · Chamblee, GAFeb 25, 1966 · N1727B · Substantial damage NTSB MIA66D0444Accident · No injuriesClosedAeronca 7AC · Winder, GAFeb 19, 1966 · N2363E · Substantial damage NTSB MIA66F0439Accident · Minor injuriesClosedBeechcraft P35 · Gainsville, GAFeb 6, 1966 · N1527S · Substantial damage NTSB MIA66F0440Accident · Minor injuriesClosedPiper PA-12 · Forsyth, GAFeb 3, 1966 · N2782M · Substantial damage NTSB MIA66F0429Accident · No injuriesClosedMooney M20D · Stockbridge, GAJan 31, 1966 · N6737U · Substantial damage NTSB MIA66A0085Accident · 1 fatalClosedMooney M-20E · Manor, GAJan 29, 1966 · N7196U · Destroyed NTSB MIA66A0084Accident · 1 fatalClosedCessna 320D · Chatsworth, GAJan 26, 1966 · N4141T · Destroyed NTSB MIA66F0405Accident · No injuriesClosedCessna 182B · Stockbridge, GAJan 16, 1966 · N2667G · Substantial damage NTSB MIA66D0413Accident · No injuriesClosedPiper PA-24 · Statesboro, GAJan 11, 1966 · N5219P · Substantial damage NTSB UNK66X0118Accident · No injuriesClosedPiper PA-18 · Augusta, GAJan 9, 1966 · N2779A · Substantial damage NTSB MIA66F0407Accident · Minor injuriesClosedCessna 150E · Fairburn, GAJan 1, 1966 · N3054J · Destroyed NTSB MIA66F0389Accident · No injuriesClosedBoeing PT-13 · Atlanta, GADec 20, 1965 · N1714M · Substantial damage NTSB MIA66A0069Accident · 2 fatalClosedPiper J3C-65 · Metter, GADec 17, 1965 · N7060H · Substantial damage