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 MIA72FKG79Accident · Serious injuriesClosedLuscombe 8A · St Simons Is, GAMar 12, 1972 · N45557 · Substantial damage NTSB MIA72DKG81Accident · No injuriesClosedMaule M4-220 · Pine Mountain, GAMar 12, 1972 · N40301 · Substantial damage NTSB MIA72FKG78Accident · Serious injuriesClosedPiper PA-28R · Chamblee, GAMar 6, 1972 · N4384T · Destroyed NTSB MIA72FKG77Accident · No injuriesClosedPiper PA-28 · Fairburn, GAMar 1, 1972 · N4625J · Substantial damage NTSB MIA72AM088Accident · Serious injuriesClosedCessna 310J · Cartersville, GAMar 1, 1972 · N15CM · 2 aircraft · Substantial damage NTSB MIA72FKG76Accident · No injuriesClosedCessna 172 · Morven, GAFeb 29, 1972 · N6212E · Substantial damage NTSB MIA72AM087Accident · 3 fatalClosedBeech D55 · Dallas, GAFeb 28, 1972 · N8087R · Destroyed NTSB MIA72FKG74Accident · No injuriesClosedCessna 172H · Ephesus, GAFeb 26, 1972 · N1438F · Substantial damage NTSB MIA72AM086Accident · Serious injuriesClosedDouglas DC8-51 · Alma, GAFeb 26, 1972 · N821E · No damage NTSB MIA72FKG75Accident · Serious injuriesClosedMooney M20E · Augusta, GAFeb 24, 1972 · N7867V · Minor damage NTSB MIA72FKG72Accident · Minor injuriesClosedStits SA3A · Stockbridge, GAFeb 5, 1972 · N75357 · Substantial damage NTSB MIA72FKG73Accident · No injuriesClosedBeech E18S · Tocca, GAJan 29, 1972 · N116FC · Substantial damage NTSB MIA72FKG77Accident · No injuriesClosedCessna 210 · Chamblee, GAJan 22, 1972 · N9463T · Substantial damage NTSB MIA72AM071Accident · 1 fatalClosedCessna 310D · Mableton, GAJan 20, 1972 · N162G · Destroyed NTSB MIA72FKG69Accident · No injuriesClosedAeronca 7AC · Cartersville, GAJan 19, 1972 · N2625E · Substantial damage NTSB MIA72FKG68Accident · No injuriesClosedCessna 172L · Athens, GAJan 13, 1972 · N3825Q · Substantial damage NTSB MIA72DKG67Accident · No injuriesClosedChampion 7GCAA · Folkston, GAJan 12, 1972 · N9524S · Substantial damage NTSB MIA72FKG66Accident · No injuriesClosedCessna 182 · Atlanta, GAJan 9, 1972 · N2785F · Substantial damage NTSB MIA72FKG65Accident · Serious injuriesClosedCessna 150 · Fayetteville, GAJan 9, 1972 · N704X · Substantial damage NTSB MIA72DKG64Accident · No injuriesClosedPiper PA-28 · Covington, GAJan 7, 1972 · N541FL · Substantial damage NTSB MIA72AM061Accident · 3 fatalClosedSiai-Marche S205 · Carters, GADec 28, 1971 · N995WA · Destroyed NTSB MIA72FKG62Accident · Serious injuriesClosedMooney M-20F · Columbus, GADec 25, 1971 · N9592M · Substantial damage NTSB MIA72FKG70Accident · No injuriesClosedMaule M-4 · Statesboro, GADec 24, 1971 · N2052U · Substantial damage NTSB MIA72FKG63Accident · Minor injuriesClosedPiper PA-28 · Homerville, GADec 24, 1971 · N7260F · Substantial damage NTSB MIA72DKG61Accident · Minor injuriesClosedCessna 172H · Athens, GADec 23, 1971 · N3852R · Substantial damage NTSB MIA72IM055Incident · No injuriesClosedBoeing 727 · Atlanta, GADec 21, 1971 · N8168G · Minor damage NTSB MIA72AM056Accident · 2 fatalClosedCessna 150F · Dalton, GADec 21, 1971 · N8014F · Destroyed NTSB MIA72AM052Accident · 1 fatalClosedSchweizer SGS233 · Williamson, GADec 12, 1971 · N1201S · Substantial damage NTSB MIA72FKG60Accident · 1 fatalClosedFly Baby Swords · Winder, GADec 11, 1971 · N2011 · Destroyed NTSB MIA72FKG58Accident · Minor injuriesClosedPiper PA-22 · Lafayette, GADec 4, 1971 · N5961D · Substantial damage NTSB MIA72FKG59Accident · No injuriesClosedAeronca 7AC · Hampton, GANov 30, 1971 · N83644 · Substantial damage NTSB MIA72FKG56Accident · No injuriesClosedBellanca 14-19 · Cairo, GANov 28, 1971 · N7655B · Substantial damage NTSB MIA72FKG57Accident · Serious injuriesClosedPiper J3C-65 · Cedartown, GANov 26, 1971 · N3586N · Substantial damage NTSB MIA72DKG48Accident · No injuriesClosedSchweizer 2-33A · Sylvania, GANov 21, 1971 · N7537 · Substantial damage NTSB MIA72FKG53Accident · No injuriesClosedPitts Spcl SC-1 · Douglasville, GANov 15, 1971 · N6119 · Substantial damage NTSB MIA72FKG55Accident · Minor injuriesClosedPiper PA-22 · Wrens, GANov 14, 1971 · N884A · Substantial damage NTSB MIA72FKG54Accident · No injuriesClosedAerostar 601 · Rome, GANov 7, 1971 · N7431S · Substantial damage NTSB MIA72AM042Accident · 2 fatalClosedPiper PA-22 · Watkinsville, GANov 7, 1971 · N5443Z · Destroyed NTSB MIA72FKG51Accident · Serious injuriesClosedCessna 180H · Hartwell, GAOct 26, 1971 · N75L · Destroyed NTSB MIA72FKG50Accident · 1 fatalClosedAero Comdr 112 · Albany, GAOct 25, 1971 · N112AC · Destroyed NTSB MIA72FKG49Accident · Serious injuriesClosedGlobe GC-1B · Cordele, GAOct 23, 1971 · N3351K · Substantial damage NTSB MIA72AM036Accident · 2 fatalClosedBeech A35 · Homerville, GAOct 17, 1971 · N8544A · Destroyed NTSB MIA72DKG47Accident · No injuriesClosedGlobe GC-1B · Albany, GAOct 16, 1971 · N2414B · Substantial damage NTSB MIA72AM037Accident · 2 fatalClosedCessna U206C · Waleska, GAOct 15, 1971 · N29223 · Destroyed NTSB MIA72AM034Accident · 1 fatalClosedCessna 172H · Fitzgerald, GAOct 10, 1971 · N1448F · Minor damage NTSB MIA72DKG46Accident · No injuriesClosedPiper PA-28 · Waycross, GAOct 3, 1971 · N6954W · Substantial damage NTSB MIA72FKG45Accident · Minor injuriesClosedAero-Comdr S2R · Albany, GASep 28, 1971 · N29A · Destroyed NTSB MIA72AM031Accident · 2 fatalClosedCessna 337F · Cherrylog, GASep 26, 1971 · N1743M · Destroyed NTSB MIA72AM030Accident · 3 fatalClosedMaule M4210C · Eatonton, GASep 25, 1971 · N2004U · Destroyed NTSB MIA72FKG44Accident · No injuriesClosedHughes 269B · Arlington, GASep 23, 1971 · N9489F · Substantial damage