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 MIA77FA012Accident · 2 fatalClosedCessna 182P · Savannah, GANov 26, 1976 · N21311 · Destroyed NTSB MIA77FKG07Accident · No injuriesClosedAero Comdr 500B · Savannah, GANov 18, 1976 · N22MC · Substantial damage NTSB MIA77DKG06Accident · No injuriesClosedErco 415-D · St.Mary'S, GANov 8, 1976 · N94677 · Substantial damage NTSB MIA77FA005Accident · 1 fatalClosedCessna R172E · Jonesboro, GAOct 29, 1976 · N3CD · Destroyed NTSB MIA77DKG05Accident · No injuriesClosedGrumman G-164 · Midville, GAOct 14, 1976 · N48596 · Destroyed NTSB MIA77FKG04Accident · No injuriesClosedGlobe GC-1B · Zebulon, GAOct 10, 1976 · N3320K · Substantial damage NTSB MIA77FA001Accident · 2 fatalClosedCessna 210L · Villanow, GAOct 7, 1976 · N2135S · Destroyed NTSB MIA77FKG03Accident · No injuriesClosedBeech B55 · Atlanta, GAOct 6, 1976 · N9299Q · Substantial damage NTSB MIA77DKG02Accident · No injuriesClosedPiper PA-32 · Valdosta, GAOct 3, 1976 · N3866W · Substantial damage NTSB MIA76FKH11Accident · No injuriesClosedCessna 180 · Fort Valley, GASep 29, 1976 · N1580C · Substantial damage NTSB MIA76DKH10Accident · No injuriesClosedStearman A75N1 · Albany, GASep 16, 1976 · N74188 · Substantial damage NTSB MIA76FKH09Accident · No injuriesClosedGrum Amer AA-1B · Brooks, GASep 10, 1976 · N1413R · Substantial damage NTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GASep 6, 1976 · N45256 · Substantial damage NTSB MIA76FKH07Accident · No injuriesClosedCessna 150 · Stone Mountain, GASep 5, 1976 · N66651 · Substantial damage NTSB MIA76FKH05Accident · Minor injuriesClosedPiper J3C-65 · Atlanta, GASep 5, 1976 · N70546 · Substantial damage NTSB MIA76FKH06Accident · Minor injuriesClosedCessna 177RG · Dahonega, GASep 3, 1976 · N2546V · Substantial damage NTSB MIA76DKH04Accident · Minor injuriesClosedCessna 188B · Quitman, GASep 1, 1976 · N9070R · Destroyed NTSB MIA76DKH03Accident · Minor injuriesClosedNavion L17B · Kennesaw, GASep 1, 1976 · N9509Z · Substantial damage NTSB MIA76DKH02Accident · Minor injuriesClosedWeatherly 201B · Shellman, GAAug 30, 1976 · N1285W · Substantial damage NTSB MIA76FKH01Accident · No injuriesClosedBell 47 · Augusta, GAAug 27, 1976 · N995D · Substantial damage NTSB MIA76FKG99Accident · Minor injuriesClosedPiper PA-25 · Albany, GAAug 26, 1976 · N9706P · Substantial damage NTSB MIA76FKG98Accident · Serious injuriesClosedCessna 172 · Shannon, GAAug 23, 1976 · N8494X · Substantial damage NTSB MIA76FKG96Accident · No injuriesClosedBoeing B-17G · Cordele, GAAug 17, 1976 · N3701G · Substantial damage NTSB MIA76FKG97Accident · Minor injuriesClosedCessna 310F · Columbus, GAAug 13, 1976 · N310Z · Substantial damage NTSB MIA76DKG95Accident · No injuriesClosedCessna 188 · Albany, GAAug 10, 1976 · N9822G · Substantial damage NTSB MIA76AM102Accident · 1 fatalClosedAero Comdr 680T · Alapaha, GAAug 8, 1976 · N601G · Destroyed NTSB MIA76FKG93Accident · 1 fatalClosedCessna A188B · Waynesboro, GAAug 6, 1976 · N53128 · Destroyed NTSB MIA76FKG94Accident · Minor injuriesClosedBoeing B-17G · Rochelle, GAAug 5, 1976 · N4710C · Destroyed NTSB MIA76AM100Accident · Serious injuriesClosedBoeing 727 · Atlanta, GAAug 2, 1976 · N8155G · No damage NTSB MIA76AM099Accident · 1 fatalClosedAero Comdr 100 · Donaldsonville, GAAug 2, 1976 · N4043X · Destroyed NTSB MIA76FKG91Accident · 1 fatalClosedPiper PA-36 · Blakely, GAJul 29, 1976 · N56322 · Destroyed NTSB MIA76FKG90Accident · Minor injuriesClosedCessna 188 · Butler, GAJul 29, 1976 · N91214 · Destroyed NTSB MIA76FKG91Accident · No injuriesClosedCessna 182M · Hampton, GAJul 27, 1976 · N70916 · Substantial damage NTSB MIA76DKG89Accident · No injuriesClosedCessna 150 · Gainesville, GAJul 27, 1976 · N22626 · Substantial damage NTSB MIA76FKG88Accident · No injuriesClosedGrumman G-164A · Hatley, GAJul 15, 1976 · N7904 · Substantial damage NTSB MIA76DKG87Accident · No injuriesClosedCessna 188B · Hawkinsville, GAJul 12, 1976 · N9136R · Substantial damage NTSB MIA76DKG86Accident · No injuriesClosedPiper PA-25 · Americus, GAJul 10, 1976 · N4460Y · Substantial damage NTSB MIA76FKG85Accident · No injuriesClosedPiper PA-36 · Blakely, GAJul 8, 1976 · N56498 · Substantial damage NTSB MIA76DKG84Accident · No injuriesClosedAero-Comdr 600S2R · Albany, GAJul 8, 1976 · N5584X · Destroyed NTSB MIA76AM076Accident · 1 fatalClosedPiper J3C-65 · Cartersville, GAJul 7, 1976 · N70419 · Destroyed NTSB MIA76AM095Accident · 1 fatalClosedCessna 337B · Augusta, GAJul 6, 1976 · N5464S · Destroyed NTSB MIA76FKG83Accident · No injuriesClosedPiper PA-28 · Ochlocknee, GAJul 4, 1976 · N15282 · Substantial damage NTSB MIA76FKG82Accident · No injuriesClosedGrumman G-164A · Quitman, GAJul 3, 1976 · N5377 · Substantial damage NTSB MIA76DKG81Accident · No injuriesClosedCessna 172 · Chauncey, GAJul 2, 1976 · N1707V · Substantial damage NTSB DEN76DKG80Accident · Minor injuriesClosedCessna 150 · Statesboro, GAJun 29, 1976 · N2462J · Substantial damage NTSB MIA76FKG79Accident · Serious injuriesClosedGrumman G-164A · Edison, GAJun 24, 1976 · N6657 · Destroyed NTSB MIA76FKG77Accident · Minor injuriesClosedCessna 150L · Jessup, GAJun 24, 1976 · N1560Q · Destroyed NTSB MIA76FKG76Accident · No injuriesClosedAero Comdr 600S2R · Bowden, GAJun 22, 1976 · N4163X · Substantial damage NTSB MIA76DKG75Accident · No injuriesClosedPiper PA-22 · Sautee, GAJun 19, 1976 · N3362Z · Substantial damage NTSB MIA76DKG78Accident · No injuriesClosedGrumman G-164A · Adel, GAJun 11, 1976 · N746Y · Substantial damage