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 MIA67F0556Accident · No injuriesClosedCessna 150E · Dawson, GAApr 26, 1967 · N4010U · Substantial damage NTSB MIA67D0553Accident · No injuriesClosedBeech A23A · Butler, GAApr 23, 1967 · N2312W · Substantial damage NTSB MIA67A0108Accident · 1 fatalClosedPiper PA-18A · Albany, GAApr 21, 1967 · N1199A · Destroyed NTSB MIA67F0538Accident · No injuriesClosedBeech C35 · Albany, GAApr 19, 1967 · N5847C · Substantial damage NTSB MIA67F0573Accident · No injuriesClosedCessna 310I · Omega, GAApr 18, 1967 · N8133M · Substantial damage NTSB MIA67F0488Accident · No injuriesClosedBeech A23 · Savannah, GAApr 18, 1967 · N3628Q · Substantial damage NTSB MIA67F0528Accident · No injuriesClosedPiper PA-28 · Macon, GAApr 14, 1967 · N9772J · Substantial damage NTSB MIA67D0507Accident · No injuriesClosedCessna 150 · Mcdonough, GAApr 11, 1967 · N6454T · Substantial damage NTSB MIA67F0497Accident · No injuriesClosedPiper PA-22 · Augusta, GAApr 9, 1967 · N4972Z · Substantial damage NTSB MIA67F0565Accident · No injuriesClosedCessna 172 · Dudley, GAApr 5, 1967 · N6973X · Substantial damage NTSB MIA67F0552Accident · No injuriesClosedPiper PA-28 · Newnan, GAApr 1, 1967 · N8945W · Substantial damage NTSB MIA67D0540Accident · No injuriesClosedCessna 150 · Leary, GAApr 1, 1967 · N8775G · Substantial damage NTSB MIA67A0101Accident · 1 fatalClosedCessna 150F · Lawrenceville, GAMar 29, 1967 · N8821S · Destroyed NTSB MIA67D0542Accident · No injuriesClosedCessna 172 · Lincolnton, GAMar 25, 1967 · N5504R · Substantial damage NTSB MIA67A0096Accident · 2 fatalClosedCessna 172E · Donalsonville, GAMar 25, 1967 · N7730U · Destroyed NTSB MIA67D0557Accident · No injuriesClosedCessna 172 · Savannah, GAMar 22, 1967 · N7446T · Substantial damage NTSB MIA67D0485Accident · No injuriesClosedBeech A35 · St.Simons Isle, GAMar 17, 1967 · N722B · Substantial damage NTSB MIA68F0014Accident · No injuriesClosedN.American P-51D · Clermont, GAMar 16, 1967 · N6175C · Destroyed NTSB MIA67F0469Accident · No injuriesClosedCessna 210 · Columbus, GAMar 15, 1967 · N3835Y · Substantial damage NTSB MIA67D0480Accident · No injuriesClosedBeech A23 · Athens, GAMar 13, 1967 · N4718J · Substantial damage NTSB MIA67D0442Accident · No injuriesClosedCessna 172 · Jonesboro, GAMar 13, 1967 · N6650A · Substantial damage NTSB MIA67A0094Accident · 1 fatalClosedBensen B-8M · Perry, GAMar 11, 1967 · NONE · Destroyed NTSB MIA67D0481Accident · No injuriesClosedCessna 180 · Wadley, GAMar 10, 1967 · N5190E · Substantial damage NTSB MIA67D0455Accident · No injuriesClosedCessna 150 · Lithonia, GAFeb 23, 1967 · N8217S · Substantial damage NTSB MIA67F0440Accident · Serious injuriesClosedMooney M20E · Chatsworth, GAFeb 17, 1967 · N2735W · Destroyed NTSB MIA67A0085Accident · No injuriesClosedMartin 404 · Atlanta, GAFeb 17, 1967 · N142S · Substantial damage NTSB MIA67F0428Accident · No injuriesClosedPiper PA-23 · Atlanta, GAFeb 3, 1967 · N3050P · Substantial damage NTSB MIA67D0418Accident · No injuriesClosedKt.Twister KT-85 · Atlanta, GAFeb 1, 1967 · N4258A · Substantial damage NTSB MIA67F0377Accident · No injuriesClosedAero Comdr 200-D · Albany, GAJan 25, 1967 · N2779T · Substantial damage NTSB MIA67F0356Accident · No injuriesClosedPiper PA-30 · Jonesboro, GAJan 24, 1967 · N7030Y · Substantial damage NTSB MIA67F0406Accident · No injuriesClosedBeech B50 · Atlanta, GAJan 22, 1967 · N85TM · Substantial damage NTSB MIA67F0378Accident · No injuriesClosedChampion 7ECA · Dawson, GAJan 16, 1967 · N8374V · Substantial damage NTSB MIA67F0404Accident · No injuriesClosedErcoupe 415-C · Lithonia, GAJan 6, 1967 · N99318 · Substantial damage NTSB MIA67A0071Accident · 2 fatalClosedCessna 170B · Lawrenceville, GAJan 2, 1967 · N3219A · Destroyed NTSB MIA67A0070Accident · 3 fatalClosedPiper PA-24 · Rebecca, GAJan 2, 1967 · N7377P · Destroyed NTSB MIA67F0381Accident · No injuriesClosedChampion 7ECA · Bainbridge, GADec 31, 1966 · N2570F · Substantial damage NTSB MIA67A0069Accident · 2 fatalClosedBeech 35 · St.Marys, GADec 31, 1966 · N3279V · Destroyed NTSB MIA67D0347Accident · No injuriesClosedCessna 150 · Montrose, GADec 25, 1966 · N8600S · Substantial damage NTSB MIA67D0341Accident · No injuriesClosedErco 415-D · Logansville, GADec 19, 1966 · N99143 · Substantial damage NTSB MIA67D0324Accident · Minor injuriesClosedCessna 172 · Lakeland, GADec 3, 1966 · N7752X · Substantial damage NTSB MIA67F0321Accident · No injuriesClosedCessna 210 · Atlanta, GADec 2, 1966 · N2340F · Substantial damage NTSB MIA67A0063Accident · No injuriesClosedCessna 320D · Mcrae, GADec 2, 1966 · N4124T · Substantial damage NTSB MIA67A0061Accident · Minor injuriesClosedDouglas A-26B · Dorchester, GANov 26, 1966 · N3157G · Destroyed NTSB MIA67F0279Accident · No injuriesClosedBellanca 14-13 · T. Simons Isle, GANov 8, 1966 · N74384 · Substantial damage NTSB MIA67F0274Accident · Serious injuriesClosedBoeing A75N1 · Vienna, GAOct 21, 1966 · N9906H · Substantial damage NTSB MIA67F0275Accident · No injuriesClosedPiper PA-23 · Atlanta, GAOct 20, 1966 · N3050P · Substantial damage NTSB MIA67F0239Accident · No injuriesClosedBeech 35 · Jonesboro, GAOct 20, 1966 · N3129V · Substantial damage NTSB MIA67A0047Accident · 3 fatalClosedCessna 210 · Fairburn, GAOct 18, 1966 · N6534X · Destroyed NTSB MIA67D0227Accident · No injuriesClosedPiper J4A · Warner Robins, GAOct 15, 1966 · N26730 · Substantial damage NTSB MIA67D0223Accident · No injuriesClosedCessna 182 · Carrollton, GAOct 10, 1966 · N3516U · Substantial damage