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 MIA77FKG40Accident · No injuriesClosedCessna 120 · Jackson, GAJun 23, 1977 · N3104N · Substantial damage NTSB MIA77DKG38Accident · No injuriesClosedAero Comdr 500B · Brunswick, GAJun 23, 1977 · N175DG · Substantial damage NTSB MIA77FKG37Accident · Serious injuriesClosedSchweizer L-34 · Williamson, GAJun 19, 1977 · N7658 · Destroyed NTSB MIA77FKG36Accident · No injuriesClosedCessna 182M · Hampton, GAJun 19, 1977 · N71391 · Substantial damage NTSB MIA77DKG47Accident · No injuriesClosedEnstrom F28A · Flovilla, GAJun 19, 1977 · N287Q · Substantial damage NTSB MIA77FKG35Accident · Minor injuriesClosedGrumman G-164A · Camilla, GAJun 16, 1977 · N953X · Substantial damage NTSB MIA77FKG34Accident · No injuriesClosedCessna A188A · Cairo, GAJun 13, 1977 · N5695J · Substantial damage NTSB MIA77FA062Accident · Serious injuriesClosedDouglas DC-3 · Newton, GAJun 13, 1977 · N38AP · Substantial damage NTSB MIA77FA061Accident · 1 fatalClosedPiper PA-16 · Valdosta, GAJun 13, 1977 · N5827H · Destroyed NTSB MIA77FA060Accident · 1 fatalClosedGrum Amer AA-1A · Atlanta, GAJun 2, 1977 · N9373L · Substantial damage NTSB MIA77FKG33Accident · Serious injuriesClosedPiper PA-32 · Athens, GAMay 31, 1977 · N3838W · Substantial damage NTSB MIA77DKG32Accident · No injuriesClosedPiper PA-25 · Rebecca, GAMay 31, 1977 · N8809L · Substantial damage NTSB MIA77DKG31Accident · No injuriesClosedCessna A188B · Rochelle, GAMay 30, 1977 · N9631G · Destroyed NTSB MIA77FKG30Accident · Minor injuriesClosedBell 206B · Franklin, GAMay 28, 1977 · N2299W · Substantial damage NTSB MIA77DKG29Accident · No injuriesClosedPiper PA-22 · Newnan, GAMay 20, 1977 · N3115Z · Substantial damage NTSB MIA77DKG22Accident · No injuriesClosedAero Comdr 112A · Kennesaw, GAMay 13, 1977 · N1341J · Destroyed NTSB MIA77FKG27Accident · Serious injuriesClosedEL Tomcat MK5A · Ray City, GAMay 4, 1977 · N3575B · Substantial damage NTSB MIA77FKG28Accident · No injuriesClosedCessna 150 · Fitzgerald, GAMay 3, 1977 · N60521 · Substantial damage NTSB MIA77DKG26Accident · No injuriesClosedLuscombe 8A · Dalton, GAApr 27, 1977 · N1448K · Substantial damage NTSB MIA77FKG25Accident · Minor injuriesClosedCessna 177 · Jonesboro, GAApr 18, 1977 · N2808X · Destroyed NTSB MIA77AA054Accident · 4 fatalClosedBellanca 14-13 · Thomaston, GAApr 16, 1977 · N74483 · Destroyed NTSB MIA77FKG23Accident · Serious injuriesClosedCessna 150 · Atlanta, GAApr 14, 1977 · N3489V · Minor damage NTSB MIA77FKG24Accident · No injuriesClosedCessna 150 · Monroe, GAApr 11, 1977 · N3524J · Substantial damage NTSB DCA77AA015Accident · 62 fatalClosedDouglas DC-9 · New Hope, GAApr 4, 1977 · N1335U · Destroyed NTSB MIA77FA050Accident · 2 fatalClosedBeech C24R · Monroe, GAApr 3, 1977 · N23969 · Destroyed NTSB MIA77FA049Accident · Serious injuriesClosedMitsubishi MU-2B · Augusta, GAApr 1, 1977 · N100SW · Destroyed NTSB MIA77FA048Accident · 1 fatalClosedCessna 207 · Atlanta, GAMar 30, 1977 · N91073 · Destroyed NTSB MIA77FA047Accident · 2 fatalClosedPiper PA-32 · Lilburn, GAMar 24, 1977 · N5256S · Destroyed NTSB MIA78FKG08Accident · No injuriesClosedAero Comdr 560 · Albany, GAMar 19, 1977 · N732Z · Substantial damage NTSB MIA77FA045Accident · 2 fatalClosedCessna 182A · Ochlocknee, GAMar 14, 1977 · N2150G · Destroyed NTSB MIA77DA044Accident · Serious injuriesClosedLockheed L-1011 · Atlanta, GAMar 12, 1977 · N329 · No damage NTSB MIA77FA038Accident · 6 fatalClosedBeech H35 · Claxton, GAMar 6, 1977 · N626Q · Destroyed NTSB MIA77FKG21Accident · No injuriesClosedCessna 150J · Savannah, GAMar 5, 1977 · N5566G · Substantial damage NTSB MIA77FA042Accident · 2 fatalClosedBeech M35 · Fargo, GAMar 5, 1977 · N9746R · Destroyed NTSB MIA77FKG22Accident · No injuriesClosedPiper PA-28 · Norcross, GAFeb 26, 1977 · N2897T · Substantial damage NTSB MIA77FA032Accident · Serious injuriesClosedBell 206B · Atlanta, GAFeb 18, 1977 · N14824 · Substantial damage NTSB MIA77FKG20Accident · No injuriesClosedChampion 7HC · Vidalia, GAFeb 8, 1977 · N8902R · Substantial damage NTSB MIA77DKG19Accident · No injuriesClosedBoeing PT17 · Albany, GAFeb 1, 1977 · N74188 · Substantial damage NTSB MIA77FKG18Accident · No injuriesClosedEnstrom F28A · Atlanta, GAJan 28, 1977 · N4877 · Substantial damage NTSB MIA77DKG16Accident · No injuriesClosedCessna 120 · Dawsonville, GAJan 27, 1977 · N76278 · Substantial damage NTSB MIA77FKG17Accident · No injuriesClosedCessna 402B · Lawrenceville, GAJan 24, 1977 · N17BT · Substantial damage NTSB MIA77FKG15Accident · Minor injuriesClosedAero Comdr 100 · Newman, GAJan 14, 1977 · N4117X · Substantial damage NTSB MIA77FKG14Accident · Serious injuriesClosedPiper PA-28 · Cleveland, GADec 30, 1976 · N5922W · Destroyed NTSB MIA77DKG10Accident · No injuriesClosedCessna 150F · Elberton, GADec 24, 1976 · N7804F · Substantial damage NTSB MIA77FKG12Accident · Serious injuriesClosedPiper J3 · Greensboro, GADec 19, 1976 · N42595 · Destroyed NTSB MIA77FKG09Accident · No injuriesClosedPiper PA-30 · Macon, GADec 19, 1976 · N8983Y · Substantial damage NTSB MIA77DKG13Accident · No injuriesClosedGrum Amer AA-5 · Fairmont, GADec 19, 1976 · N71921 · Substantial damage NTSB MIA77FKG11Accident · No injuriesClosedCessna U206A · Palmetto, GADec 17, 1976 · N4819F · Substantial damage NTSB MIA77FKG01Accident · No injuriesClosedCessna 210L · Marietta, GADec 14, 1976 · N2440S · Substantial damage NTSB MIA77DKG08Accident · No injuriesClosedBell 47D1 · Vanceville, GADec 12, 1976 · N3575 · Substantial damage