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 MIA78FKG65Accident · No injuriesClosedHughes 269B · Swainboro, GAJul 29, 1978 · N9457F · Substantial damage NTSB MIA78DLA46Accident · No injuriesClosedCessna A188B · Moultrie, GAJul 25, 1978 · N48570 · Substantial damage NTSB MIA78FKG66Accident · No injuriesClosedPiper PA-20 · Millen, GAJul 23, 1978 · N1145C · Substantial damage NTSB MIA78FKG64Accident · Minor injuriesClosedCessna 150 · Athens, GAJul 22, 1978 · N60746 · Substantial damage NTSB MIA78FKG62Accident · No injuriesClosedMooney M20J · Atlanta, GAJul 21, 1978 · N201PC · Substantial damage NTSB MIA78FKG63Accident · Minor injuriesClosedGrumman G-164A · Lumpkin, GAJul 18, 1978 · N9829 · Destroyed NTSB MIA78FA103Accident · 3 fatalClosedPiper PA-30 · Albany, GAJul 10, 1978 · N41AC · Destroyed NTSB MIA78FKG58Accident · No injuriesClosedPDQ 2 · Marietta, GAJul 9, 1978 · N2279D · Substantial damage NTSB MIA78FKG59Accident · Serious injuriesClosedPiper PA-28 · Toccoa, GAJul 8, 1978 · N75313 · Destroyed NTSB MIA78FKG60Accident · 1 fatalClosedPiper PA-25 · Cordele, GAJul 7, 1978 · N4417Y · Destroyed NTSB MIA78FKG57Accident · No injuriesClosedCessna 188B · Sylvester, GAJul 6, 1978 · N6298G · Substantial damage NTSB MIA78DLA43Accident · No injuriesClosedPiper PA-23 · St Simons Isle, GAJul 5, 1978 · N7AD · Substantial damage NTSB MIA78DKG56Accident · No injuriesClosedPiper PA-28 · Toccoa, GAJul 4, 1978 · N5669U · Substantial damage NTSB MIA78FKG55Accident · Serious injuriesClosedCessna 188 · Brooklet, GAJul 3, 1978 · N3536Q · Destroyed NTSB MIA78DKG61Accident · No injuriesClosedEpps 1911 · Blairville, GAJul 2, 1978 · N9119 · Substantial damage NTSB MIA78FKG54Accident · Minor injuriesClosedPiper PA-28 · Ft Oglethorpe, GAJun 28, 1978 · N9733J · Destroyed NTSB MIA78FA098Accident · 1 fatalClosedHughes 269C · Atlanta, GAJun 23, 1978 · N9584F · Destroyed NTSB MIA78DLA40Accident · Serious injuriesClosedCessna A188B · Whigham, GAJun 22, 1978 · N9435R · Destroyed NTSB MIA78FKG52Accident · No injuriesClosedGrumman G-164B · Sylvester, GAJun 19, 1978 · N6623Q · Destroyed NTSB MIA78FKG51Accident · No injuriesClosedCessna 172 · Stone Mountain, GAJun 16, 1978 · N3715S · Substantial damage NTSB MIA78DA096Accident · No injuriesClosedLockheed L-1011 · Atlanta, GAJun 11, 1978 · N720DA · No damage NTSB MIA78FKG48Accident · No injuriesClosedCessna 177RG · Newman, GAJun 10, 1978 · N7507V · Substantial damage NTSB MIA78DKG49Accident · Minor injuriesClosedAmateur KR-1 · Gainesville, GAJun 10, 1978 · N91129 · Destroyed NTSB MIA78DLA37Accident · No injuriesClosedCessna 182 · Fargo, GAJun 8, 1978 · N7298N · Substantial damage NTSB MIA78FKG47Accident · No injuriesClosedCessna 210 · Ashburn, GAJun 4, 1978 · N9662T · Substantial damage NTSB MIA78DKG46Accident · Serious injuriesClosedCessna 182 · Atlanta, GAJun 3, 1978 · N70698 · Substantial damage NTSB MIA78FLA36Accident · Minor injuriesClosedPiper PA-28R · St.Simons, GAMay 29, 1978 · N5041S · Substantial damage NTSB MIA78FKG45Accident · Serious injuriesClosedSkybolt 1976 · Vidalia, GAMay 28, 1978 · N68063 · Destroyed NTSB MIA78FKG44Accident · Minor injuriesClosedCessna 172XP · Fairburn, GAMay 27, 1978 · N736LY · Substantial damage NTSB MIA78DLA35Accident · No injuriesClosedPiper PA-25 · Cairo, GAMay 26, 1978 · N76042 · Substantial damage NTSB MIA78FKG50Accident · No injuriesClosedPiper PA-36 · Byron, GAMay 17, 1978 · N57767 · Substantial damage NTSB MIA78FKG43Accident · No injuriesClosedCessna 188 · Cochran, GAMay 15, 1978 · N5657J · Substantial damage NTSB MIA78FKG40Accident · No injuriesClosedPiper PA-18 · Monroe, GAMay 15, 1978 · N100T · Substantial damage NTSB MIA78F1A30Accident · No injuriesClosedBoeing A75 · Pelham, GAMay 11, 1978 · N59031 · Substantial damage NTSB MIA78DKG42Accident · No injuriesClosedGrumman G-164B · Sylvester, GAMay 10, 1978 · N6623Q · Substantial damage NTSB MIA78DLA33Accident · No injuriesClosedCessna A188B · Moultrie, GAMay 8, 1978 · N6298G · Substantial damage NTSB MIA78FA078Accident · 3 fatalClosedPiper PA-28 · Jekyll Island, GAMay 7, 1978 · N47638 · Destroyed NTSB MIA78FKG41Accident · No injuriesClosedGrumman G-164A · Albany, GAMay 5, 1978 · N5360 · Substantial damage NTSB MIA78FA073Accident · 2 fatalClosedBellanca 7ECA · Columbus, GAApr 28, 1978 · N1874G · Destroyed NTSB MIA78FA072Accident · 2 fatalClosedBeech N35 · Kennesaw, GAApr 26, 1978 · N9495Y · Destroyed NTSB MIA78FKG38Accident · Serious injuriesClosedPiper PA-22 · Loganville, GAApr 23, 1978 · N69PK · Destroyed NTSB MIA78FKG39Accident · Serious injuriesClosedGrum Amer AA1-A · Atlanta, GAApr 22, 1978 · N9379L · Substantial damage NTSB MIA78FA070Accident · 3 fatalClosedPiper PA-28 · Atlanta, GAApr 22, 1978 · N5361L · Destroyed NTSB MIA78FKG37Accident · No injuriesClosedPiper PA-34 · Macon, GAApr 11, 1978 · N1401T · Substantial damage NTSB MIA78FKG36Accident · No injuriesClosedCessna 150 · Covington, GAApr 7, 1978 · N6489G · Substantial damage NTSB MIA78FKG35Accident · Minor injuriesClosedCessna 172 · Wrens, GAApr 5, 1978 · N7862G · Substantial damage NTSB MIA78DLA28Accident · No injuriesClosedCessna 180 · Waycross, GAApr 5, 1978 · N112GC · Substantial damage NTSB MIA78FKG33Accident · No injuriesClosedBeech 95-C55 · Atlanta, GAApr 3, 1978 · N9436S · Substantial damage NTSB MIA78DKG34Accident · No injuriesClosedCessna C150 · Jenkinsburg, GAApr 3, 1978 · N8132F · Destroyed NTSB MIA78FKG32Accident · Serious injuriesClosedCessna 210 · Gainesville, GAMar 29, 1978 · N8201M · Substantial damage