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 MIA75DKG72Accident · No injuriesClosedCessna 150 · Rome, GAMay 19, 1975 · N8103S · Substantial damage NTSB MIA75AM080Accident · 2 fatalClosedPiper J3C-65 · Damascus, GAMay 18, 1975 · N3415N · Destroyed NTSB MIA75DKG82Accident · No injuriesClosedCessna 177 · Brooks, GAMay 11, 1975 · N3228T · Substantial damage NTSB MIA75DKG71Accident · No injuriesClosedPiper PA-25 · Byron, GAMay 5, 1975 · N6966Z · Destroyed NTSB MIA75FKG70Accident · No injuriesClosedRyan ST-3KR · Zebulon, GAApr 26, 1975 · N262SR · 2 aircraft · Substantial damage NTSB MIA75DKG69Accident · No injuriesClosedCessna 188 · Coolidge, GAApr 26, 1975 · N70489 · Substantial damage NTSB MIA75FKG68Accident · Serious injuriesClosedCessna 182 · Thomaston, GAApr 23, 1975 · N2467Q · Substantial damage NTSB MIA75FKG67Accident · No injuriesClosedPiper PA-30 · Patterson, GAApr 14, 1975 · N7873Y · Substantial damage NTSB MIA75FKG66Accident · No injuriesClosedSchweizer SGS2 · Williamson, GAApr 5, 1975 · N1181S · Substantial damage NTSB MIA75FKG65Accident · No injuriesClosedCessna 172L · Calhoun, GAApr 1, 1975 · N1026M · Substantial damage NTSB MIA75DKG64Accident · No injuriesClosedCessna 206 · Thomasville, GAApr 1, 1975 · N1253V · Substantial damage NTSB MIA75FKG63Accident · No injuriesClosedGrumman G-164 · Smithville, GAMar 29, 1975 · N936X · Destroyed NTSB MIA75DKG62Accident · No injuriesClosedBellanca 8GCBC · Whigham, GAMar 27, 1975 · N88127 · Substantial damage NTSB MIA75FKG61Accident · Serious injuriesClosedBeech 95B55 · Chamblee, GAMar 26, 1975 · N5710K · Destroyed NTSB MIA75FKG60Accident · No injuriesClosedAmer Avco AA1-B · Commerce, GAMar 5, 1975 · N9697L · Substantial damage NTSB MIA75FKG58Accident · Minor injuriesClosedMaule 220C · Chamblee, GAFeb 23, 1975 · N62013 · Substantial damage NTSB MIA75FKG59Accident · No injuriesClosedBushby MM1 · Thomasville, GAFeb 22, 1975 · N7191 · Substantial damage NTSB MIA75FKG57Accident · No injuriesClosedCessna 150G · Folkston, GAJan 31, 1975 · N3866J · Destroyed NTSB MIA75DK656Accident · Minor injuriesClosedCessna 150G · Ellijay, GAJan 19, 1975 · N2592Q · Substantial damage NTSB IAD75AI043Accident · 1 fatalClosedPiper PA-22 · Chamblee, GAJan 15, 1975 · N1447C · Destroyed NTSB MIA75DKG55Accident · Minor injuriesClosedPiper PA-23 · Bruswick, GAJan 9, 1975 · N5667Y · Substantial damage NTSB MIA75FKG54Accident · No injuriesClosedCessna 172G · Baxley, GAJan 5, 1975 · N5867R · Substantial damage NTSB MIA75AM040Accident · 2 fatalClosedPiper PA-30 · Atlanta, GADec 30, 1974 · N7007Y · Destroyed NTSB MIA75FKG53Accident · Serious injuriesClosedCessna 310K · Atlanta, GADec 20, 1974 · N7056L · Destroyed NTSB MIA75AM037Accident · 1 fatalClosedTemco GC1B · Lafayette, GADec 20, 1974 · N3881K · Destroyed NTSB MIA75AM035Accident · 2 fatalClosedBeech 95-B55 · Atlanta, GADec 20, 1974 · N1633A · Destroyed NTSB MIA75FKG52Accident · No injuriesClosedCessna 182G · St Marys, GADec 14, 1974 · N3725U · Substantial damage NTSB MIA75FKG51Accident · No injuriesClosedBeech K35 · Dalton, GADec 4, 1974 · N6025E · Substantial damage NTSB MIA75FKG50Accident · No injuriesClosedCessna P206 · Augusta, GADec 2, 1974 · N8776Z · Substantial damage NTSB MIA75DKG49Accident · Minor injuriesClosedBell 205A1 · Homerville, GANov 29, 1974 · N59441 · Substantial damage NTSB MIA75DKG47Accident · No injuriesClosedCessna 172 · Stone Mountain, GANov 28, 1974 · N7051Q · Substantial damage NTSB MIA75DKG45Accident · No injuriesClosedCessna 182 · Hillsboro, GANov 15, 1974 · N3368F · Substantial damage NTSB MIA75FKG31Accident · No injuriesClosedCessna 150 · Marietta, GANov 13, 1974 · N8511J · Substantial damage NTSB MIA75FKG38Accident · No injuriesClosedBeech 55 · Augusta, GANov 9, 1974 · N14MB · Substantial damage NTSB MIA75DKG46Accident · No injuriesClosedPiper PA-18 · Resaca, GANov 5, 1974 · N9099D · Substantial damage NTSB MIA75FKG43Accident · Minor injuriesClosedPiper PA-28 · Thomasville, GAOct 28, 1974 · CG-MRN · Substantial damage NTSB MIA75FKG41Accident · No injuriesClosedCessna 310 · Chamblee, GAOct 24, 1974 · N3684D · Substantial damage NTSB MIA74DKG42Accident · No injuriesClosedBellanca 7GCA · Griffin, GAOct 24, 1974 · N8921R · Substantial damage NTSB MIA75FKG40Accident · Serious injuriesClosedLuscombe 8E · Brooks, GAOct 20, 1974 · N1181K · Destroyed NTSB MIA75DKG37Accident · No injuriesClosedCessna 310G · Albany, GAOct 18, 1974 · N2906R · Substantial damage NTSB MIA75FKG39Accident · Serious injuriesClosedPiper PA-32 · Atlanta, GAOct 17, 1974 · N8901N · Substantial damage NTSB MIA75AM022Accident · No injuriesClosedMitsubishi MU-2B · Savannah, GAOct 14, 1974 · N222HH · Minor damage NTSB MIA75FKG36Accident · No injuriesClosedAeronca 7AC · Jonesboro, GAOct 13, 1974 · N83644 · Substantial damage NTSB MIA75DKG35Accident · Minor injuriesClosedPiper PA-18 · Brooklet, GAOct 9, 1974 · N5777D · Destroyed NTSB MIA75FKG31Accident · No injuriesClosedCessna 120 · Stockbridge, GAOct 6, 1974 · N2481N · Substantial damage NTSB MIA75FKG33Accident · Minor injuriesClosedCessna 120 · Dawson, GASep 23, 1974 · N1875N · Substantial damage NTSB MIA75FKG27Accident · No injuriesClosedCallair A-9 · Newington, GASep 23, 1974 · N96252 · Destroyed NTSB MIA75FKG32Accident · 1 fatalClosedFlag Scootr HEC-1 · Claxton, GASep 21, 1974 · N3443 · Destroyed NTSB MIA75AM021Accident · No injuriesClosedBeech D18S · Atlanta, GASep 18, 1974 · N7002 · Substantial damage NTSB MIA74DKG44Accident · No injuriesClosedCessna 150H · Carrollton, GASep 18, 1974 · N22514 · Substantial damage