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 MIA79DKG20Accident · No injuriesClosedCessna 170 · Douglas, GAMar 2, 1979 · N4046V · Substantial damage NTSB MIA79FA055Accident · 1 fatalClosedCessna 150 · Albany, GAFeb 27, 1979 · N11306 · Destroyed NTSB MIA79DKG19Accident · No injuriesClosedBeech B58 · Augusta, GAFeb 20, 1979 · N31BW · Substantial damage NTSB MIA79DKG18Accident · No injuriesClosedBeech F33C · Claxton, GAFeb 19, 1979 · N8176R · Substantial damage NTSB MIA79FA048Accident · 1 fatalClosedBeech E35 · Brunswick, GAFeb 6, 1979 · N2059C · Substantial damage NTSB MIA79FKG17Accident · No injuriesClosedCessna 310 · Atlanta, GAFeb 2, 1979 · N3078L · Substantial damage NTSB MIA79FKG16Accident · No injuriesClosedDouglas DC-3 · Williamson, GAJan 21, 1979 · N133D · Substantial damage NTSB MIA79FKG15Accident · Serious injuriesClosedPdq-2 E · Stockbridge, GAJan 16, 1979 · N2282T · Substantial damage NTSB MIA79FKG14Accident · Minor injuriesClosedCessna 182 · Louisville, GAJan 3, 1979 · N2610Q · Substantial damage NTSB MIA79FA034Accident · 1 fatalClosedPiper PA-30 · Lafayette, GADec 31, 1978 · N7031Y · Destroyed NTSB MIA79FKG12Accident · No injuriesClosedCessna 152 · Atlanta, GADec 12, 1978 · N67309 · Substantial damage NTSB MIA79DKG11Accident · No injuriesClosedPiper PA-28 · Dawson, GADec 4, 1978 · N9632J · Substantial damage NTSB MIA79FKG09Accident · Minor injuriesClosedCessna 177 · Augusta, GADec 3, 1978 · N30839 · Substantial damage NTSB MIA79FA025Accident · 5 fatalClosedPiper PA-32R · Albany, GANov 30, 1978 · N7063F · Destroyed NTSB MIA79DLA10Accident · No injuriesClosedCessna A188A · Hortence, GANov 19, 1978 · N1566M · Substantial damage NTSB MIA79FLA08Accident · No injuriesClosedCessna 210M · St.Marys, GANov 8, 1978 · N761AX · Substantial damage NTSB MIA79FKG10Accident · No injuriesClosedCessna 172 · Chamblee, GANov 8, 1978 · N7208G · Substantial damage NTSB MIA79FKG08Accident · Minor injuriesClosedAerospatle SA315B · Atlanta, GANov 4, 1978 · N62339 · Substantial damage NTSB MIA79FKG07Accident · No injuriesClosedAeronca 7AC · Hampton, GAOct 28, 1978 · N1823E · Substantial damage NTSB MIA79DLA05Accident · No injuriesClosedCessna 310 · Cairo, GAOct 20, 1978 · N5387A · Substantial damage NTSB MIA79FKG06Accident · No injuriesClosedCessna 150 · Madison, GAOct 18, 1978 · N60791 · Substantial damage NTSB MIA79FKG04Accident · No injuriesClosedCessna 337G · Chamblee, GAOct 15, 1978 · N53620 · Substantial damage NTSB MIA79FKG05Accident · No injuriesClosedCessna 140 · Sugar Valley, GAOct 12, 1978 · N2511N · Substantial damage NTSB MIA79FKG03Accident · No injuriesClosedHelio Acft H-295 · Atlanta, GAOct 11, 1978 · N275ZD · Destroyed NTSB MIA79DLA03Accident · Minor injuriesClosedCessna A188B · Waycross, GAOct 11, 1978 · N4771Q · Destroyed NTSB MIA79FKG01Accident · Serious injuriesClosedGlobe Swift GC-1B · Hampton, GAOct 2, 1978 · N78327 · Substantial damage NTSB MIA79FKG02Accident · Serious injuriesClosedPiper PA-22 · Stone Mountain, GAOct 1, 1978 · N7846D · Minor damage NTSB MIA78FA126Accident · 2 fatalClosedCessna 337G · Atlanta, GASep 22, 1978 · N1309L · Destroyed NTSB MIA78FKG82Accident · No injuriesClosedCessna 188B · Brooklett, GASep 20, 1978 · N4962Q · Substantial damage NTSB MIA78FKG81Accident · Minor injuriesClosedBeech A23-19 · Juniper, GASep 19, 1978 · N5988S · Substantial damage NTSB MIA78FKG80Accident · No injuriesClosedPiper PA-24 · Dawson, GASep 14, 1978 · N7632P · Substantial damage NTSB MIA78FKG79Accident · Serious injuriesClosedPiper PA-28R · Stockbridge, GASep 14, 1978 · N2649Q · Destroyed NTSB MIA78FKG78Accident · Minor injuriesClosedGrumman G164A · Albany, GASep 13, 1978 · N7929 · Substantial damage NTSB MIA78DLA51Accident · No injuriesClosedAero Comdr S2R · Camilla, GASep 13, 1978 · N8480V · Substantial damage NTSB MIA78FKG76Accident · Serious injuriesClosedCessna 152 · Birmingham, GAAug 29, 1978 · N49143 · Destroyed NTSB MIA78FKG75Accident · Serious injuriesClosedAero Comdr S2R · Summer, GAAug 25, 1978 · N4863X · Substantial damage NTSB MIA78DLA47Accident · No injuriesClosedGrumman G-164A · Cairo, GAAug 21, 1978 · N5186 · Destroyed NTSB MIA78FKG73Accident · Serious injuriesClosedBellanca 7GCBC · Monroe, GAAug 20, 1978 · N9511S · Destroyed NTSB MIA78FKG74Accident · No injuriesClosedBell 47D1 · Hartwell, GAAug 19, 1978 · N74123 · Substantial damage NTSB MIA78DKG77Accident · No injuriesClosedHoak TR-1 · Stockbridge, GAAug 19, 1978 · N26112 · Substantial damage NTSB MIA78DLA48Accident · No injuriesClosedCessna 188B · Colquitt, GAAug 18, 1978 · N9094R · Substantial damage NTSB MIA78FKG72Accident · No injuriesClosedCessna 188B · Broxton, GAAug 17, 1978 · N5622G · Substantial damage NTSB MIA78FKG53Accident · No injuriesClosedCessna 188B · Cordele, GAAug 16, 1978 · N9449R · Destroyed NTSB MIA78FKG71Accident · Minor injuriesClosedPiper PA-36 · Cordele, GAAug 13, 1978 · N59692 · Destroyed NTSB MIA78FA113Accident · No injuriesClosedPiper PA-28 · Statenville, GAAug 13, 1978 · N6301W · Substantial damage NTSB MIA79FLA34Accident · 1 fatalClosedBell 47G2 · Omega, GAAug 12, 1978 · N6729D · Destroyed NTSB MIA78FKG70Accident · No injuriesClosedCessna 150 · Savannah, GAAug 7, 1978 · N5699E · Substantial damage NTSB MIA78DKG69Accident · No injuriesClosedCessna A188B · Pineview, GAAug 5, 1978 · N731KE · Substantial damage NTSB MIA78FKG68Accident · No injuriesClosedHunting-Pem MK-51 · Sylvester, GAAug 3, 1978 · N51951 · Destroyed NTSB MIA78FKG67Accident · Serious injuriesClosedHughes 269C · Buena Vista, GAJul 30, 1978 · N7413F · Destroyed