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 ATL80FKG22Accident · No injuriesClosedPiper PA-38 · Jefferson, GASep 3, 1980 · N2446F · Substantial damage NTSB ATL80DLA13Accident · No injuriesClosedHughes 269B · Meigs, GASep 3, 1980 · N9303F · Substantial damage NTSB ATL80FA088Accident · 1 fatalClosedAerostar 601P · Summerville, GASep 2, 1980 · N90463 · Destroyed NTSB ATL80FKG23Accident · No injuriesClosedCessna T210N · Jonesboro, GAAug 30, 1980 · N4966C · Destroyed NTSB ATL80DLA12Accident · No injuriesClosedCessna 172 · Jekyll Island, GAAug 30, 1980 · N739FX · Substantial damage NTSB ATL80FLA10Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 28, 1980 · N8353Y · Substantial damage NTSB ATL80FLA11Accident · No injuriesClosedCessna A188 · Hopeful, GAAug 26, 1980 · N8179V · Substantial damage NTSB ATL80FKG21Accident · No injuriesClosedCessna 182 · Douglas, GAAug 22, 1980 · N229C · Substantial damage NTSB ATL80DKG20Accident · No injuriesClosedCessna 152 · Lawrenceville, GAAug 21, 1980 · N25843 · Substantial damage NTSB ATL80DLA08Accident · No injuriesClosedRockwell S-2R · Colquitt, GAAug 20, 1980 · N4926X · Substantial damage NTSB ATL80DLA07Accident · No injuriesClosedGrumman G-164A · Cairo, GAAug 19, 1980 · N8528 · Substantial damage NTSB ATL80DLA09Accident · Serious injuriesClosedBell 47G · Blakely, GAAug 16, 1980 · N1159W · Substantial damage NTSB ATL80FLA06Accident · No injuriesClosedTom Cat MK-5A · Quitman, GAAug 15, 1980 · N3575B · Substantial damage NTSB ATL80DKG19Accident · No injuriesClosedCessna 188 · Albany, GAAug 13, 1980 · N9822G · Substantial damage NTSB ATL80FKG18Accident · Minor injuriesClosedCessna R182 · Chamblee, GAAug 6, 1980 · N78RG · Substantial damage NTSB ATL80FLA05Accident · No injuriesClosedCessna A188B · Moultrie, GAAug 2, 1980 · N9364R · Substantial damage NTSB ATL80FKG16Accident · Serious injuriesClosedPiper PA-25 · Unadilla, GAJul 26, 1980 · N4970Y · Destroyed NTSB ATL80DKG15Accident · Minor injuriesClosedCessna 177B · Stone Mt, GAJul 22, 1980 · N13589 · Substantial damage NTSB ATL80DKG14Accident · No injuriesClosedPiper PA-25 · Dudley, GAJul 22, 1980 · N9529P · Destroyed NTSB ATL80DKG11Accident · No injuriesClosedCessna 152 · Griffin, GAJul 19, 1980 · N66934 · Substantial damage NTSB ATL80FKG13Accident · No injuriesClosedCessna 310G · Jasper, GAJul 17, 1980 · N8936Z · Substantial damage NTSB ATL80FKG10Accident · No injuriesClosedCessna 150H · Stockbridge, GAJul 17, 1980 · N6581S · Substantial damage NTSB ATL80DKG12Accident · No injuriesClosedPiper PA-25 · Screven, GAJul 17, 1980 · N8660L · Substantial damage NTSB ATL80DKG08Accident · No injuriesClosedBellanca 7KCAB · Stockbridge, GAJul 14, 1980 · N8623V · Substantial damage NTSB ATL80DKG09Accident · No injuriesClosedGrum Amer AA5-B · Americus, GAJul 5, 1980 · N28862 · Substantial damage NTSB ATL80FA066Accident · 2 fatalClosedBeech C18S · Wassaw Is, GAJul 4, 1980 · N35MS · Destroyed NTSB ATL80FA064Accident · Serious injuriesClosedBeech B65 · Kenessaw, GAJul 2, 1980 · N22PC · Destroyed NTSB ATL80FA063Accident · 2 fatalClosedPiper J-3 · Williamson, GAJun 28, 1980 · N42914 · Destroyed NTSB ATL80FA057Accident · No injuriesClosedSud Avn SE-210 · Atlanta, GAJun 19, 1980 · N905MW · Destroyed NTSB ATL81FA055Accident · 1 fatalClosedGrumman F8F-2 · Commerce, GAJun 18, 1980 · N9885C · Destroyed NTSB ATL80FKG06Accident · No injuriesClosedCessna 152 · Stone Mountain, GAJun 12, 1980 · N48875 · Substantial damage NTSB ATL80IA052Incident · No injuriesClosedCessna P210N · Nashville, GAJun 7, 1980 · N3859P · Minor damage NTSB ATL80FKG05Accident · Serious injuriesClosedCessna 172 · Warner Robins, GAJun 6, 1980 · N5783T · Destroyed NTSB ATL80DKG04Accident · No injuriesClosedPiper PA-28 · Hephzibah, GAMay 30, 1980 · N4466J · Substantial damage NTSB ATL80FKG03Accident · No injuriesClosedMooney M20C · Columbus, GAMay 26, 1980 · N5832Q · Substantial damage NTSB ATL80FKG02Accident · No injuriesClosedBeech D45 · Stone Mountain, GAMay 26, 1980 · N4900S · Substantial damage NTSB ATL80IA048Incident · No injuriesClosedDouglas DC-8 · Atlanta, GAMay 22, 1980 · N1300L · Minor damage NTSB ATL80FLA04Accident · Serious injuriesClosedCessna 150 · Thomasville, GAMay 21, 1980 · N8029F · Destroyed NTSB ATL80FLA03Accident · No injuriesClosedBrantley B-2B · Valdosta, GAMay 10, 1980 · N2252U · Substantial damage NTSB ATL80DLA02Accident · No injuriesClosedVarga 2150A · Valdosta, GAMay 10, 1980 · N8348J · Substantial damage NTSB ATL80FLA01Accident · No injuriesClosedCessna 140 · St Marys, GAMay 6, 1980 · N76366 · Substantial damage NTSB ATL80FKG01Accident · No injuriesClosedPiper PA-25 · Irwinville, GAMay 5, 1980 · N4682Y · Substantial damage NTSB MIA80FA060Accident · 1 fatalClosedCessna 337 · Atlanta, GAMay 4, 1980 · N6208F · Destroyed NTSB MIA80FKG24Accident · No injuriesClosedCessna 140A · Atlanta, GAApr 30, 1980 · N5674C · Substantial damage NTSB MIA80DLA22Accident · Minor injuriesClosedCessna T-188C · Blackshear, GAApr 25, 1980 · N2877J · Substantial damage NTSB MIA80FA056Accident · 1 fatalClosedCessna 150L · Alamo, GAApr 21, 1980 · N18648 · Destroyed NTSB MIA80DKG23Accident · Minor injuriesClosedPiper PA-18 · Sylvester, GAApr 10, 1980 · N9063D · Destroyed NTSB ATL80FA091Accident · 4 fatalClosedPiper PA-44 · Helen, GAApr 8, 1980 · N3011D · Destroyed NTSB MIA80DLA20Accident · No injuriesClosedBeech V35 · St.Simon Is, GAApr 5, 1980 · N461A · Substantial damage NTSB MIA80FA048Accident · 2 fatalClosedCessna 182P · Chamblee, GAMar 20, 1980 · N9953E · Destroyed