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 MIA74FKG39Accident · No injuriesClosedAero Comdr 680-FL · Kennesaw, GAOct 20, 1973 · N347R · Substantial damage NTSB MIA74FKG41Accident · No injuriesClosedHughes 269A · Hartwell, GAOct 15, 1973 · N8917F · Substantial damage NTSB MIA74DKG36Accident · No injuriesClosedPiper PA-24 · Gainesville, GAOct 7, 1973 · N7329F · Substantial damage NTSB MIA74FKG44Accident · No injuriesClosedEnstrom F-28A · Atlanta, GAOct 3, 1973 · N4870 · Substantial damage NTSB MIA74FKG33Accident · No injuriesClosedGrumman G-164A · Quitman, GASep 27, 1973 · N7833 · Substantial damage NTSB MIA74FKG32Accident · Minor injuriesClosedCessna 414 · Perry, GASep 26, 1973 · N816TP · Destroyed NTSB MIA74FKG31Accident · No injuriesClosedCessna 182 · Waresboro, GASep 26, 1973 · N2912Y · Substantial damage NTSB MIA74FKG30Accident · 1 fatalClosedAero Comdr A-9B · Jordan, GASep 22, 1973 · N7664V · Destroyed NTSB MIA74DKG37Accident · No injuriesClosedBellanca 7ECA · Statesboro, GASep 20, 1973 · N5195T · Substantial damage NTSB MIA74DKG35Accident · No injuriesClosedBeech H35 · Albany, GASep 18, 1973 · N8317D · Substantial damage NTSB MIA74FKG29Accident · Serious injuriesClosedCessna 150G · Jonesboro, GASep 17, 1973 · N2218J · Substantial damage NTSB MIA74DKG28Accident · No injuriesClosedPiper PA-25 · Cochran, GASep 17, 1973 · N4682Y · Substantial damage NTSB MIA74FKG27Accident · No injuriesClosedAero Comdr S-2R · Smithville, GASep 11, 1973 · N8902Q · Substantial damage NTSB MIA74FKG25Accident · No injuriesClosedCessna 172G · Prattsburg, GASep 9, 1973 · N5863R · Substantial damage NTSB MIA74FKG24Accident · Minor injuriesClosedBeech B35 · Bainbridge, GASep 9, 1973 · N5555K · Substantial damage NTSB MIA74FKG26Accident · Minor injuriesClosedCessna 140 · Stockbridge, GASep 8, 1973 · N76217 · Destroyed NTSB MIA74FKG23Accident · No injuriesClosedPiper PA-30 · Sylvania, GASep 2, 1973 · N7902Y · Substantial damage NTSB MIA74FKG22Accident · No injuriesClosedRyan ST3KR · Villa Rica, GASep 2, 1973 · N46751 · Substantial damage NTSB MIA74FKG21Accident · No injuriesClosedCessna 172F · Jasper, GASep 1, 1973 · N7870U · Substantial damage NTSB MIA74FKG19Accident · 1 fatalClosedBoeing A75 · Cordele, GAAug 25, 1973 · N1515M · Destroyed NTSB MIA74FKG18Accident · Serious injuriesClosedAero Comdr S2R · Pineview, GAAug 24, 1973 · N8920Q · Destroyed NTSB MIA74FKG15Accident · Minor injuriesClosedPiper PA-22 · Atlanta, GAAug 22, 1973 · N5617Z · Substantial damage NTSB MIA74FKG16Accident · No injuriesClosedAero Comdr A-9B · Statesboro, GAAug 20, 1973 · N7661V · Destroyed NTSB MIA74FKG14Accident · No injuriesClosedGlobe GC-1B · Cordele, GAAug 20, 1973 · N7CE · Substantial damage NTSB MIA74DKG13Accident · No injuriesClosedGrumman G-164A · Perry, GAAug 16, 1973 · N7996 · Substantial damage NTSB MIA74FKG20Accident · No injuriesClosedPiper PA-30 · Jesup, GAAug 12, 1973 · N7695Y · Substantial damage NTSB MIA74DKG11Accident · No injuriesClosedCessna 140 · Thomaston, GAAug 12, 1973 · N77166 · Substantial damage NTSB MIA74DKG17Accident · No injuriesClosedCessna 188 · Cochran, GAAug 11, 1973 · N5657J · Substantial damage NTSB MIA74FKG10Accident · No injuriesClosedAero Comdr A-9B · Pitts, GAAug 10, 1973 · N7746V · Substantial damage NTSB MIA74AM016Accident · 1 fatalClosedBeech 23 · Fitzgerald, GAAug 4, 1973 · N2386L · Destroyed NTSB MIA74AM011Accident · 2 fatalClosedPiper PA-28R · Nahunta, GAAug 1, 1973 · N10JJ · Destroyed NTSB MIA74AM009Accident · 4 fatalClosedBeech V35A · Georgetown, GAJul 27, 1973 · N7623N · Destroyed NTSB MIA74DKG07Accident · No injuriesClosedCessna 172 · St.Simons Isle, GAJul 22, 1973 · N20181 · Substantial damage NTSB MIA74FKG06Accident · No injuriesClosedBeech G18S · Augusta, GAJul 21, 1973 · N1500Z · Substantial damage NTSB MIA74FKG05Accident · No injuriesClosedGrumman G-164 · Fitzgerald, GAJul 18, 1973 · N643U · Substantial damage NTSB MIA74DKG12Accident · No injuriesClosedFairchild 24K · Jekyll Island, GAJul 18, 1973 · N20629 · Substantial damage NTSB MIA74DKG09Accident · No injuriesClosedAero Comdr A-9B · Bainbridge, GAJul 16, 1973 · N8025V · Substantial damage NTSB MIA74AM004Accident · 1 fatalClosedBeech 60 · Valdosta, GAJul 13, 1973 · N7282D · Destroyed NTSB MIA74FKG04Accident · No injuriesClosedCessna 150 · Dalton, GAJul 12, 1973 · N3796J · Substantial damage NTSB MIA74DKG03Accident · No injuriesClosedCessna 150 · Swainsboro, GAJul 7, 1973 · N22558 · Substantial damage NTSB MIA74DKG02Accident · No injuriesClosedPiper PA-24 · Helen, GAJul 7, 1973 · N8760P · Substantial damage NTSB MIA74FKG01Accident · No injuriesClosedBeech B35 · Sapelo Island, GAJul 4, 1973 · N8859A · Substantial damage NTSB MIA74DKG87Accident · No injuriesClosedBoeing 75N1 · Rebecca, GAJun 26, 1973 · N5815V · Substantial damage NTSB MIA73FKG86Accident · 2 fatalClosedPiel-Emraud 301 · Palmetto, GAJun 24, 1973 · N1308 · Destroyed NTSB MIA73FKG85Accident · Serious injuriesClosedCallair A-9 · Mcrae, GAJun 24, 1973 · N3611G · Destroyed NTSB MIA73FKG84Accident · No injuriesClosedGrumman G-164A · Blakely, GAJun 22, 1973 · N6588 · Substantial damage NTSB MIA73AM114Accident · 1 fatalClosedPiper PA-28 · Mableton, GAJun 22, 1973 · N6911W · Destroyed NTSB MIA74FKG83Accident · No injuriesClosedLuscombe 8A · Fairburn, GAJun 18, 1973 · N2329K · Substantial damage NTSB MIA73FKG79Accident · 1 fatalClosedPiper PA-25 · Pineview, GAJun 13, 1973 · N4884Y · Destroyed NTSB MIA73DKG82Accident · No injuriesClosedCessna 170A · Cochran, GAJun 6, 1973 · N9506A · Substantial damage