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 MIA79FA112Accident · 1 fatalClosedPiper PA-28 · Canton, GAAug 12, 1979 · N6322R · Destroyed NTSB MIA79FKG59Accident · Minor injuriesClosedChampion 7ECA · Social Circle, GAAug 10, 1979 · N2550F · Destroyed NTSB MIA79DKG60Accident · Serious injuriesClosedCessna 188B · Waynesboro, GAAug 10, 1979 · N4800Q · Substantial damage NTSB MIA79FKG64Accident · Minor injuriesClosedPiper PA-23 · Atlanta, GAAug 8, 1979 · C-GAKE · Substantial damage NTSB MIA79FKG61Accident · No injuriesClosedCessna 188T · Albany, GAAug 8, 1979 · N9822G · Substantial damage NTSB MIA79DKG57Accident · No injuriesClosedHughes 269C · Montezuma, GAAug 7, 1979 · N7422F · Substantial damage NTSB MIA79FKG58Accident · Serious injuriesClosedAyres S2R · Leesburg, GAAug 4, 1979 · N4004U · Destroyed NTSB MIA79DLA42Accident · No injuriesClosedSnow S-2R · Camilla, GAAug 1, 1979 · N4887X · Substantial damage NTSB MIA79DLA41Accident · No injuriesClosedCessna 150 · Camilla, GAJul 27, 1979 · N50635 · Substantial damage NTSB MIA79DKG56Accident · No injuriesClosedPiper PA-36 · Denton, GAJul 25, 1979 · N57880 · Substantial damage NTSB MIA79FLA40Accident · No injuriesClosedLockheed 18 · Brunswick, GAJul 24, 1979 · N33LM · Substantial damage NTSB MIA79FKG55Accident · No injuriesClosedCessna 310C · Chamblee, GAJul 18, 1979 · N1DY · Substantial damage NTSB MIA79DLA38Accident · No injuriesClosedCessna 150 · Waycross, GAJul 14, 1979 · N18646 · Substantial damage NTSB MIA79FKG53Accident · No injuriesClosedPiper PA-23 · Sapelo Island, GAJul 9, 1979 · N4026P · Substantial damage NTSB MIA79DLA37Accident · Minor injuriesClosedCessna 172 · Folkston, GAJul 8, 1979 · N8451U · Destroyed NTSB MIA79DLA35Accident · No injuriesClosedCessna A188 · Pelham, GAJul 2, 1979 · N8179V · Substantial damage NTSB MIA79DKG52Accident · No injuriesClosedGrumman G-164 · Fitzgerald, GAJun 28, 1979 · N621U · Substantial damage NTSB MIA79FKG51Accident · No injuriesClosedPiper PA-23 · Griffin, GAJun 24, 1979 · N4406P · Substantial damage NTSB MIA79DA098Accident · Serious injuriesClosedLockheed L-1011 · Atlanta, GAJun 24, 1979 · N724DA · No damage NTSB MIA79FKG49Accident · 1 fatalClosedPiper PA-25 · Wrightsville, GAJun 18, 1979 · N9534P · Destroyed NTSB MIA79DKG47Accident · No injuriesClosedSchweizer SGU222 · Williamson, GAJun 16, 1979 · N5822V · Substantial damage NTSB MIA79FAQ96Accident · 1 fatalClosedBeech 65 · Preston, GAJun 13, 1979 · N111WP · Destroyed NTSB MIA79DLA30Accident · Minor injuriesClosedCessna 150 · Mayday, GAJun 10, 1979 · N6577F · Substantial damage NTSB MIA79FKG50Accident · No injuriesClosedCessna 120 · Lagrange, GAJun 8, 1979 · N1845N · Substantial damage NTSB MIA79DKG45Accident · No injuriesClosedPiper PA-30 · Jefferson, GAMay 30, 1979 · N7555Y · Substantial damage NTSB MIA79DKG44Accident · No injuriesClosedBellanca 7KCAB · Tunnel Hill, GAMay 28, 1979 · N8728 · Substantial damage NTSB MIA79FKG43Accident · No injuriesClosedPiper PA-28 · Thomaston, GAMay 24, 1979 · N6396R · Substantial damage NTSB MIA79DKG42Accident · Minor injuriesClosedAir Tractor AT-301 · Americus, GAMay 22, 1979 · N86985 · Destroyed NTSB MIA79FKG41Accident · 1 fatalClosedPitts Spec S-1 · Warner Robins, GAMay 15, 1979 · N42R · Destroyed NTSB MIA79FKG39Accident · Minor injuriesClosedGrum Amer AA1C · Blue Ridge, GAMay 13, 1979 · N9564U · Substantial damage NTSB MIA79DKG40Accident · No injuriesClosedLuscombe 8E · Athens, GAMay 12, 1979 · N1896K · Substantial damage NTSB MIA79FKG37Accident · Serious injuriesClosedPiper PA-30B · Ball Ground, GAMay 11, 1979 · N8152Y · Destroyed NTSB MIA79FKG38Accident · No injuriesClosedBeech V35B · Butler, GAMay 9, 1979 · N2022Y · Substantial damage NTSB MIA79FKG36Accident · No injuriesClosedCessna 150 · Springfield, GAMay 6, 1979 · N6298T · Substantial damage NTSB MIA79DA080Accident · 1 fatalClosedPiper PA-16 · Savannah, GAMay 6, 1979 · N5203H · Destroyed NTSB MIA79FKG33Accident · 1 fatalClosedCessna 150 · Hawkinsville, GAApr 21, 1979 · N66550 · No damage NTSB MIA79FKG34Accident · Serious injuriesClosedAeronca 11BC · Warner Robins, GAApr 19, 1979 · N86054 · Substantial damage NTSB MIA79FKG32Accident · No injuriesClosedBeech 35-33 · Hawkinsville, GAApr 16, 1979 · N995T · Substantial damage NTSB MIA79FKG31Accident · Serious injuriesClosedLockheed L-18 · Lincolton, GAApr 12, 1979 · N250W · Destroyed NTSB MIA79FKG30Accident · Serious injuriesClosedDehavilland DHC-1 · Fayetteville, GAApr 7, 1979 · N122LT · Destroyed NTSB MIA79FKG29Accident · No injuriesClosedCessna 152 · Cobbtown, GAApr 5, 1979 · N49155 · Substantial damage NTSB MIA79FKG28Accident · Serious injuriesClosedPiper PA-22 · Lawrenceville, GAMar 18, 1979 · N7149B · Destroyed NTSB MIA79FKG27Accident · 1 fatalClosedPDQ 2 · Kennesaw, GAMar 18, 1979 · N2279D · Destroyed NTSB MIA79FKG25Accident · No injuriesClosedPiper PA-24 · Hawkinsville, GAMar 18, 1979 · N7622P · Substantial damage NTSB MIA79DKG26Accident · No injuriesClosedBeech B33 · Athens, GAMar 16, 1979 · N8839M · Substantial damage NTSB MIA79FKG24Accident · No injuriesClosedMooney M20C · Peachtree City, GAMar 13, 1979 · N1956Y · Substantial damage NTSB MIA79FKG23Accident · Serious injuriesClosedCessna 310C · Augusta, GAMar 10, 1979 · N1717H · Substantial damage NTSB MIA79FKG22Accident · Minor injuriesClosedPiper PA-28 · Jesup, GAMar 7, 1979 · N4825T · Substantial damage NTSB MIA79FLA16Accident · No injuriesClosedAeronca 7AC · Blakely, GAMar 6, 1979 · N83796 · Substantial damage NTSB MIA79DKG21Accident · No injuriesClosedMooney M20F · Pine Mountain, GAMar 5, 1979 · N6808V · Substantial damage