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 MIA67F0291Accident · Minor injuriesClosedN.American P-51D · Chamblee, GAOct 2, 1966 · N13410 · Substantial damage NTSB MIA67F0246Accident · No injuriesClosedCessna 182A · Cairo, GASep 28, 1966 · N2150G · Substantial damage NTSB MIA67D0197Accident · No injuriesClosedPiper PA-32 · Calhoun, GASep 23, 1966 · N3518W · Substantial damage NTSB MIA67D0205Accident · No injuriesClosedCessna 210 · Elberton, GASep 22, 1966 · N2389F · Substantial damage NTSB MIA67A0036Accident · Serious injuriesClosedDouglas DC-8 · Macon, GASep 22, 1966 · N820E · No damage NTSB MIA67D0196Accident · No injuriesClosedPiper PA-30 · Milledgeville, GASep 20, 1966 · N8123Y · Substantial damage NTSB MIA67F0209Accident · No injuriesClosedStinson 108-3 · Marietta, GASep 10, 1966 · N885C · Substantial damage NTSB MIA67D0177Accident · No injuriesClosedBeech 95-B55 · Douglas, GASep 8, 1966 · N455HC · Substantial damage NTSB MIA67F0250Accident · No injuriesClosedMooney M20C · Augusta, GASep 3, 1966 · N6281U · Substantial damage NTSB MIA67F0179Accident · Minor injuriesClosedCessna 150 · Milan, GASep 3, 1966 · N8966S · Substantial damage NTSB MIA67D0178Accident · No injuriesClosedCessna 172 · Lithonia, GASep 2, 1966 · N5588R · Substantial damage NTSB MIA67D0204Accident · No injuriesClosedCessna 150 · Plains, GAAug 28, 1966 · N6924F · Substantial damage NTSB MIA67D0149Accident · No injuriesClosedPiper PA-22 · Villa Rica, GAAug 28, 1966 · N9249D · Substantial damage NTSB CHI67F0195Accident · Serious injuriesClosedPiper PA-25 · Sylvania, GAAug 26, 1966 · N7525Z · Destroyed NTSB MIA67F0202Accident · Serious injuriesClosedPiper PA-25 · Sylvester, GAAug 25, 1966 · N7683Z · Destroyed NTSB MIA67F0159Accident · No injuriesClosedCessna 172F · Cochran, GAAug 23, 1966 · N8309U · Substantial damage NTSB MIA67F0226Accident · Serious injuriesClosedPiper J3C-65 · Millen, GAAug 22, 1966 · N98711 · Substantial damage NTSB MIA67F0237Accident · No injuriesClosedPiper PA-25 · Rosier, GAAug 18, 1966 · N6606Z · Substantial damage NTSB MIA67F0176Accident · Minor injuriesClosedPiper J3 · Roberta, GAAug 18, 1966 · N7218H · Substantial damage NTSB MIA67F0172Accident · No injuriesClosedPiper PA-25 · Cordele, GAAug 18, 1966 · N4419Y · Destroyed NTSB MIA67F0133Accident · No injuriesClosedPiper PA-22 · Claxton, GAAug 18, 1966 · N4335A · Substantial damage NTSB MIA67F0194Accident · No injuriesClosedPiper PA-25 · Shellman, GAAug 17, 1966 · N6406Z · Substantial damage NTSB MIA67F0170Accident · No injuriesClosedPiper PA-24 · Townsend, GAAug 17, 1966 · N5307P · Substantial damage NTSB MIA67D0135Accident · No injuriesClosedCessna 310 · Tifton, GAAug 14, 1966 · N4875B · Substantial damage NTSB MIA67F0173Accident · No injuriesClosedAero Cmdr 200-D · Albany, GAAug 10, 1966 · N2900T · Substantial damage NTSB MIA67D0150Accident · No injuriesClosedCessna 210-5A · Columbus, GAAug 3, 1966 · N4869U · Substantial damage NTSB MIA67D0116Accident · Minor injuriesClosedPiper PA-28 · Autreyville, GAJul 30, 1966 · N9115J · Substantial damage NTSB MIA67D0117Accident · No injuriesClosedCessna 172 · Nashville, GAJul 29, 1966 · N3971L · Substantial damage NTSB MIA67A0018Accident · 1 fatalClosedStearman A75N1 · Edison, GAJul 29, 1966 · N64807 · Destroyed NTSB MIA67F0146Accident · No injuriesClosedCallair A-5T · Oliver, GAJul 25, 1966 · N2965G · Substantial damage NTSB MIA67F0107Accident · No injuriesClosedCessna 310 · Atlanta, GAJul 25, 1966 · N3684D · Substantial damage NTSB MIA67F0092Accident · Serious injuriesClosedPiper PA-25 · Metter, GAJul 23, 1966 · N7246Z · Destroyed NTSB MIA67F0083Accident · No injuriesClosedCallair A-6 · Baconton, GAJul 23, 1966 · N2930G · Destroyed NTSB MIA67F0076Accident · No injuriesClosedPiper PA-24 · Marietta, GAJul 19, 1966 · N8613P · Substantial damage NTSB MIA67A0010Accident · No injuriesClosedHughes 269B · Americus, GAJul 19, 1966 · N9438F · Substantial damage NTSB MIA67D0152Accident · No injuriesClosedPiper PA-24 · Commerce, GAJul 17, 1966 · N7307P · Substantial damage NTSB MIA67F0046Accident · Minor injuriesClosedPiper PA-24 · Marietta, GAJul 15, 1966 · N7946P · Substantial damage NTSB MIA67F0075Accident · Minor injuriesClosedPiper PA-25 · Ocilla, GAJul 14, 1966 · N7355Z · Destroyed NTSB MIA67A0005Accident · 2 fatalClosedRepublic RC-3 · Jonesboro, GAJul 9, 1966 · N6697K · Substantial damage NTSB MIA67F0081Accident · No injuriesClosedPiper PA-25 · Montezuma, GAJul 8, 1966 · N7515Z · Substantial damage NTSB MIA67F0008Accident · Serious injuriesClosedCessna 150 · Fort Benning, GAJul 4, 1966 · N7964E · Substantial damage NTSB MIA67F0080Accident · Serious injuriesClosedTaylorcraft BC-65 · Stockbridge, GAJul 3, 1966 · N2447M · Substantial damage NTSB MIA67F0091Accident · No injuriesClosedCallair A-9 · Meigs, GAJul 2, 1966 · N8296H · Destroyed NTSB MIA67F0074Accident · No injuriesClosedPiper PA-23 · Sylvester, GAJul 2, 1966 · N1376P · Substantial damage NTSB MIA67F0136Accident · Serious injuriesClosedErco 415C · Blairsville, GAJun 28, 1966 · N3823H · Destroyed NTSB MIA67F0054Accident · No injuriesClosedGrumman G-164 · Sasser, GAJun 27, 1966 · N692Y · Destroyed NTSB MIA67D0049Accident · No injuriesClosedCessna 150 · Fayetteville, GAJun 27, 1966 · N7181X · Substantial damage NTSB MIA67F0134Accident · No injuriesClosedBeech G17S · Atlanta, GAJun 23, 1966 · N291Y · Substantial damage NTSB MIA66A0148Accident · No injuriesClosedHughes 269B · Cordele, GAJun 23, 1966 · N9438F · Substantial damage NTSB MIA67F0031Accident · Serious injuriesClosedDart Acft GC · Marietta, GAJun 21, 1966 · N31697 · 2 aircraft · Destroyed