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 MIA75DKG30Accident · No injuriesClosedStinson 108-2 · Stone Mountain, GASep 17, 1974 · N888D · Substantial damage NTSB MIA75DKG28Accident · No injuriesClosedBreezy DP2 · Claxton, GASep 11, 1974 · N1276 · Substantial damage NTSB MIA75AM017Accident · 1 fatalClosedBellanca 14-193 · Jeffersonville, GASep 3, 1974 · N8840R · Destroyed NTSB MIA75FKG25Accident · 1 fatalClosedAero Comdr A-9B · Sylvania, GASep 1, 1974 · N7748V · Destroyed NTSB MIA75DKG29Accident · Minor injuriesClosedHughes 269B · Alma, GAAug 30, 1974 · N9301F · Destroyed NTSB MIA75DKG26Accident · No injuriesClosedCessna 172 · Jonesboro, GAAug 29, 1974 · N1622F · Destroyed NTSB MIA75DKG24Accident · No injuriesClosedChampion 7GCA · Stockbridge, GAAug 27, 1974 · N86752 · Substantial damage NTSB MIA75DKG23Accident · Minor injuriesClosedAero Comdr A-9B · Whigham, GAAug 23, 1974 · N7728V · Substantial damage NTSB MIA75DKG22Accident · No injuriesClosedPiper PA-25 · Climax, GAAug 22, 1974 · N4682Y · Substantial damage NTSB MIA75FKG21Accident · Serious injuriesClosedSchempp SH · Perry, GAAug 21, 1974 · N15PE · Destroyed NTSB MIA75FKG20Accident · No injuriesClosedHelio Acft H-295 · Macon, GAAug 20, 1974 · N6475V · Substantial damage NTSB MIA75FKG19Accident · Minor injuriesClosedBoeing A75N1 · Blakely, GAAug 20, 1974 · N65871 · Substantial damage NTSB MIA75FKG17Accident · No injuriesClosedGrumman G-164A · Perry, GAAug 20, 1974 · N7996 · Destroyed NTSB MIA75FKG18Accident · No injuriesClosedCessna 182C · Hampton, GAAug 19, 1974 · N8776T · Substantial damage NTSB MIA74FKG11Accident · Minor injuriesClosedCallair A-9B · Monroe, GAAug 19, 1974 · N7636V · Destroyed NTSB MIA75FKG16Accident · No injuriesClosedAmer Avco AA1-B · Fairburn, GAAug 2, 1974 · N6526L · Substantial damage NTSB MIA75FKG15Accident · No injuriesClosedBeech 65 · Atlanta, GAAug 2, 1974 · N9865 · Substantial damage NTSB MIA75DKG14Accident · No injuriesClosedGrumman G-164A · Edison, GAAug 2, 1974 · N6659 · Substantial damage NTSB MIA75FKG13Accident · Serious injuriesClosedCessna 150 · Stockbridge, GAAug 1, 1974 · N1751Q · Substantial damage NTSB MIA75FKG12Accident · No injuriesClosedCessna 150J · Baxley, GAJul 31, 1974 · N60549 · Substantial damage NTSB MIA74FKG10Accident · Minor injuriesClosedEnstrom F-28A · Atlanta, GAJul 31, 1974 · N9582 · Substantial damage NTSB MIA75FKG07Accident · Minor injuriesClosedCessna 182J · Cumming, GAJul 28, 1974 · N3519F · Destroyed NTSB MIA75DKG08Accident · No injuriesClosedPiper PA-28 · Columbus, GAJul 28, 1974 · N41879 · Substantial damage NTSB MIA75AM010Accident · 2 fatalClosedBeech N35 · Atlanta, GAJul 28, 1974 · N9380Y · Substantial damage NTSB MIA75DKG09Accident · No injuriesClosedPiper PA-24 · Americus, GAJul 27, 1974 · N6973P · Substantial damage NTSB MIA75FKG05Accident · Minor injuriesClosedPiper PA-28 · Douglas, GAJul 25, 1974 · N4162J · Destroyed NTSB MIA75DKG06Accident · No injuriesClosedCessna 188 · Hawkinsville, GAJul 25, 1974 · N3544Q · Substantial damage NTSB MIA75FKG04Accident · No injuriesClosedBeech B95 · Carrollton, GAJul 16, 1974 · N9591R · Destroyed NTSB MIA75FKG03Accident · No injuriesClosedCessna 150L · Monroe, GAJul 10, 1974 · N7303G · Substantial damage NTSB MIA75AM004Incident · No injuriesClosedLockheed 1011 · Atlanta, GAJul 8, 1974 · N308EA · Minor damage NTSB NYC75AN003Accident · 1 fatalClosedPiper PA-31 · Chatsworth, GAJul 5, 1974 · N11HW · Substantial damage NTSB MIA75FKG02Accident · No injuriesClosedMooney M20C · Vidalia, GAJul 4, 1974 · N5920Q · Substantial damage NTSB MIA75AM003Accident · Serious injuriesClosedLockheed 1011 · Atlanta, GAJul 3, 1974 · N706DA · Minor damage NTSB MIA75FKG01Accident · 1 fatalClosedAero Comdr A-9B · Hawkinsville, GAJul 2, 1974 · N7720V · Destroyed NTSB MIA75DKG90Accident · No injuriesClosedBell 206A · Blairsville, GAJun 25, 1974 · N7881S · Substantial damage NTSB MIA74FKG88Accident · No injuriesClosedErco 415-E · Stockbridge, GAJun 25, 1974 · N94770 · Substantial damage NTSB MIA74FKG89Accident · No injuriesClosedPiper PA-28 · Pembroke, GAJun 23, 1974 · N8879N · Substantial damage NTSB MIA74FKG87Accident · Minor injuriesClosedCessna 150 · Marietta, GAJun 22, 1974 · N10056 · Substantial damage NTSB MIA74FKG86Accident · Minor injuriesClosedCessna 150G · Williamson, GAJun 16, 1974 · N8588J · Destroyed NTSB MIA74AM101Accident · 2 fatalClosedAeronca 7AC · Macon, GAJun 16, 1974 · N81908 · Destroyed NTSB MIA74DKG85Accident · No injuriesClosedPiper PA-25 · Fort Valley, GAJun 14, 1974 · N7210Z · Destroyed NTSB MIA74DKG84Accident · No injuriesClosedPiper PA-25 · Warwick, GAJun 12, 1974 · N8760L · Substantial damage NTSB MIA74DKG83Accident · No injuriesClosedCessna 140 · Brunswick, GAJun 11, 1974 · N2172N · Substantial damage NTSB MIA74DKG82Accident · No injuriesClosedAero Comdr A-9 · Smithville, GAJun 11, 1974 · N8031V · Substantial damage NTSB MIA74AM099Accident · 2 fatalClosedBellanca 17-30A · Blairsville, GAJun 6, 1974 · N8891V · Destroyed NTSB MIA74FKG81Accident · Serious injuriesClosedMooney M20C · Chamblee, GAJun 4, 1974 · N6774N · Substantial damage NTSB MIA74DKG80Accident · No injuriesClosedCessna 150 · Cedartown, GAMay 24, 1974 · N18027 · Substantial damage NTSB MIA74FKG79Accident · Minor injuriesClosedCessna 210T · Albany, GAMay 23, 1974 · N6124R · Substantial damage NTSB MIA74AM095Accident · Serious injuriesClosedPiper PA-30 · Atlanta, GAMay 20, 1974 · N8723Y · Substantial damage NTSB MIA74DKG78Accident · No injuriesClosedAmer Avco AA5 · Jonesboro, GAMay 19, 1974 · N6041L · Substantial damage