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 MIA77FKG68Accident · No injuriesClosedBeech 18S · Atlanta, GASep 23, 1977 · N72V · Substantial damage NTSB MIA77FKG81Accident · 1 fatalClosedAero Comdr 600S2R · Albany, GASep 22, 1977 · N8493V · Destroyed NTSB MIA77FKG77Accident · No injuriesClosedCessna 337 · Atlanta, GASep 14, 1977 · N225X · Substantial damage NTSB MIA77FLA54Accident · 2 fatalClosedCessna 188-B · Nashville, GASep 13, 1977 · N9600G · Destroyed NTSB MIA77FKG79Accident · Minor injuriesClosedAero Comdr S2R · Cordele, GASep 12, 1977 · N8834Q · Substantial damage NTSB MIA77FKG76Accident · No injuriesClosedPiper PA36 · Byromville, GASep 12, 1977 · N57831 · Substantial damage NTSB MIA77DKG80Accident · No injuriesClosedCessna 140 · Blairsville, GASep 12, 1977 · N2458N · Substantial damage NTSB MIA77FKG75Accident · Serious injuriesClosedCessna 210 · Columbus, GASep 11, 1977 · N2271S · Destroyed NTSB MIA77FKG78Accident · No injuriesClosedHughes 269 · Montezuma, GASep 10, 1977 · N7404F · Substantial damage NTSB MIA77FKG74Accident · No injuriesClosedPiper PA-25 · Dudley, GASep 8, 1977 · N7571Z · Substantial damage NTSB MIA77FA085Accident · 3 fatalClosedPiper PA-28 · Danville, GASep 7, 1977 · N43485 · Destroyed NTSB MIA77FLA53Accident · Serious injuriesClosedPiper PA-23 · Valdosta, GASep 6, 1977 · N2063P · Substantial damage NTSB MIA77FKG72Accident · No injuriesClosedGrumman G-164A · Cuthbert, GASep 6, 1977 · N9829 · Substantial damage NTSB MIA77FKG73Accident · No injuriesClosedPiper PA-28 · Albany, GASep 1, 1977 · N32122 · Substantial damage NTSB MIA77DKG71Accident · No injuriesClosedBellanca 7KACB · Tunnel Hill, GASep 1, 1977 · N8728 · Substantial damage NTSB MIA77FKG65Accident · Minor injuriesClosedPiper PA-32R · Atlanta, GAAug 31, 1977 · N8498F · Substantial damage NTSB MIA77DLA48Accident · No injuriesClosedGrumman G-164A · Colquitt, GAAug 24, 1977 · N15289 · Destroyed NTSB MIA77DKG70Accident · No injuriesClosedHughes 269A · Royston, GAAug 24, 1977 · N8869F · Destroyed NTSB MIA77FLA47Accident · No injuriesClosedCessna 188B · Enigma, GAAug 21, 1977 · N9392G · Destroyed NTSB MIA77FKG67Accident · No injuriesClosedHughes 269B · Montezuma, GAAug 20, 1977 · N9318F · Substantial damage NTSB MIA77FKG69Accident · No injuriesClosedHughes 269C · Montezuma, GAAug 19, 1977 · N7404F · Substantial damage NTSB MIA77FKG66Accident · No injuriesClosedBeech B23 · Hazelhurst, GAAug 17, 1977 · N7733R · Destroyed NTSB MIA77DKG63Accident · No injuriesClosedCessna A188B · Rocky Ford, GAAug 16, 1977 · N8279G · Destroyed NTSB MIA77DKG64Accident · No injuriesClosedAero Comdr A-9 · Sylvania, GAAug 12, 1977 · N8032V · Substantial damage NTSB MIA77FKG62Accident · No injuriesClosedBell 47G-2 · Brookfield, GAAug 8, 1977 · N6729D · Destroyed NTSB MIA77DLA45Accident · No injuriesClosedCessna 150 · Nashville, GAAug 6, 1977 · N6428T · Substantial damage NTSB MIA77FKG61Accident · No injuriesClosedStinson 108-1 · Stanfordville, GAAug 4, 1977 · N97885 · Substantial damage NTSB MIA77FA074Accident · 1 fatalClosedCessna 182D · Cusseta, GAAug 3, 1977 · N9127X · Destroyed NTSB MIA77DKG60Accident · Minor injuriesClosedPiper PA-25 · Rebecca, GAAug 3, 1977 · N4414Y · Destroyed NTSB MIA77FKG59Accident · No injuriesClosedCessna 188B · Statesboro, GAAug 2, 1977 · N9104R · Destroyed NTSB MIA77FKG58Accident · Minor injuriesClosedPiper PA-25 · Murray, GAJul 29, 1977 · N4350Y · Destroyed NTSB MIA77FKG57Accident · Minor injuriesClosedPiper J-3 · Athens, GAJul 27, 1977 · N33026 · Substantial damage NTSB MIA77FKG56Accident · No injuriesClosedCessna 150F · Milledgeville, GAJul 27, 1977 · N8629G · Substantial damage NTSB MIA77FA071Accident · 5 fatalClosedCessna 172L · Vienna, GAJul 27, 1977 · N19691 · Destroyed NTSB MIA77FKG55Accident · Serious injuriesClosedPiper PA-28 · Atlanta, GAJul 26, 1977 · N16536 · Destroyed NTSB MIA77DKG53Accident · No injuriesClosedRockwell Thrush · Vada, GAJul 25, 1977 · N4199X · Substantial damage NTSB MIA77FKG20Accident · Minor injuriesClosedCessna 140 · Whitesburg, GAJul 24, 1977 · N3119N · Substantial damage NTSB MIA77DKG49Accident · No injuriesClosedCessna 150 · Shell Bluff, GAJul 14, 1977 · N16110 · Substantial damage NTSB MIA77FKG52Accident · No injuriesClosedPiper PA-25 · Sylvania, GAJul 13, 1977 · N4710Z · Substantial damage NTSB MIA77FKG51Accident · Minor injuriesClosedEL Tomcat MK5A · Colquitt, GAJul 12, 1977 · N9014T · Destroyed NTSB MIA77FKG50Accident · No injuriesClosedGrumman 164A · Bainbridge, GAJul 11, 1977 · N9513 · Substantial damage NTSB MIA77FKG45Accident · No injuriesClosedCessna 150 · Atlanta, GAJul 11, 1977 · N3797J · Substantial damage NTSB MIA77FKG44Accident · Minor injuriesClosedBellanca 8KCAB · Jonesboro, GAJul 11, 1977 · N1153E · Substantial damage NTSB MIA77DKG46Accident · No injuriesClosedCessna 150 · Peachtree City, GAJul 11, 1977 · N8255S · Substantial damage NTSB MIA77FK648Accident · No injuriesClosedChampion 7HC · Savannah, GAJul 9, 1977 · N8576E · Substantial damage NTSB MIA77DKG85Accident · Minor injuriesClosedLuscombe 8E · Lavonia, GAJul 7, 1977 · N2673K · Substantial damage NTSB MIA77DKG43Accident · No injuriesClosedPiper PA-25 · Climax, GAJul 6, 1977 · N4632Y · Destroyed NTSB MIA77DKG42Accident · No injuriesClosedCessna 210 · Folkston, GAJul 6, 1977 · N9472T · Substantial damage NTSB MIA77DKG41Accident · No injuriesClosedBell 47-D1 · Berlin, GAJul 2, 1977 · N908B · Substantial damage NTSB MIA77DKG39Accident · No injuriesClosedGrumman G-164 · Hopeful, GAJun 24, 1977 · N48369 · Substantial damage