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 MIA74AM097Accident · Minor injuriesClosedCessna 411 · Fitzgerald, GAMay 17, 1974 · N4917T · Substantial damage NTSB MIA74AM093Accident · 2 fatalClosedPiper PA-28 · Folkston, GAMay 14, 1974 · N8872N · Destroyed NTSB MIA74FKG77Accident · No injuriesClosedLet-Np-K L-13 · Monroe, GAMay 11, 1974 · N90868 · Destroyed NTSB MIA74FKG68Accident · No injuriesClosedCessna 195 · Crabapple, GAMay 5, 1974 · N1524D · Substantial damage NTSB MIA74FKG72Accident · No injuriesClosedBellanca 7ECA · Stockbridge, GAApr 28, 1974 · N86673 · Substantial damage NTSB MIA74DKG76Accident · No injuriesClosedPiper PA-32 · Winder, GAApr 28, 1974 · N3420W · Substantial damage NTSB MIA74FKG73Accident · No injuriesClosedCessna 172C · Dawson, GAApr 27, 1974 · N8441 · Substantial damage NTSB MIA74FKG75Accident · Minor injuriesClosedCessna 182G · Savannah, GAApr 20, 1974 · N2115R · Substantial damage NTSB MIA74FKG71Accident · Minor injuriesClosedBeech E18S · Atlanta, GAApr 17, 1974 · N255D · Substantial damage NTSB MIA74FKG70Accident · Serious injuriesClosedPiper PA-28 · Newman, GAApr 14, 1974 · N5594W · Substantial damage NTSB MIA74DKG74Accident · No injuriesClosedBell 47G · Blue Ridge, GAApr 10, 1974 · N25802 · Substantial damage NTSB MIA74AM086Accident · Serious injuriesClosedCessna 150G · Stone Mountain, GAApr 10, 1974 · N2748S · 2 aircraft · Destroyed NTSB MIA74DLA40Accident · No injuriesClosedBeech E33A · Destin, GAApr 7, 1974 · N7876R · Substantial damage NTSB NYC74IN087Incident · No injuriesClosedDouglas DC-9 · Atlanta, GAApr 6, 1974 · N971NE · No damage NTSB MIA74FKG69Accident · No injuriesClosedPiper PA-24 · Macon, GAApr 6, 1974 · N8973P · Substantial damage NTSB MIA74FKG67Accident · No injuriesClosedBeech 99 · St Simons Isl, GAMar 31, 1974 · N848NS · Destroyed NTSB MIA74FKG66Accident · No injuriesClosedPiper PA-23 · Augusta, GAMar 29, 1974 · N323GH · Substantial damage NTSB MIA74FKG65Accident · Serious injuriesClosedCessna 150L · Perry, GAMar 27, 1974 · N6603G · Substantial damage NTSB MIA74FKG63Accident · Serious injuriesClosedTemco D-16 · Marietta, GAMar 24, 1974 · N5232K · Destroyed NTSB MIA74FKG64Accident · Serious injuriesClosedCessna 337 · Mcrae, GAMar 23, 1974 · N5425S · Destroyed NTSB MIA74DKG61Accident · No injuriesClosedCessna 182N · St Simons Is, GAMar 17, 1974 · N92422 · Substantial damage NTSB MIA74FKG60Accident · No injuriesClosedCessna 175 · Snellville, GAMar 15, 1974 · N7622M · Substantial damage NTSB MIA74FKG59Accident · No injuriesClosedTemco GC-1B · Lawrenceville, GAMar 14, 1974 · N2428B · Substantial damage NTSB MIA74FKG58Accident · Minor injuriesClosedPiper PA-28R · Toccoa, GAMar 13, 1974 · N5225T · Substantial damage NTSB MIA74FKG57Accident · No injuriesClosedBeech 65-B80 · Thomasville, GAMar 11, 1974 · N208E · Substantial damage NTSB MIA74FKG56Accident · No injuriesClosedStarduster II · Brooks, GAMar 9, 1974 · N2498 · Substantial damage NTSB MIA74DKG62Accident · No injuriesClosedAmer Avco AA-1 · Thomson, GAMar 9, 1974 · N5605L · Substantial damage NTSB MIA74FKG55Accident · No injuriesClosedPiper PA-30 · Atlanta, GAMar 5, 1974 · N99EJ · Substantial damage NTSB MIA74FKG54Accident · No injuriesClosedCessna 310J · Mayfield, GAMar 2, 1974 · N3018L · Substantial damage NTSB MIA74AM076Accident · 1 fatalClosedCessna 175 · Fairburn, GAMar 1, 1974 · N9226B · Destroyed NTSB MIA74AM074Accident · 3 fatalClosedBeech A23A · Brooks, GAFeb 24, 1974 · N3655Q · Destroyed NTSB MIA74DKG53Accident · No injuriesClosedLuscombe 8A · Valdosta, GAFeb 23, 1974 · N71648 · Substantial damage NTSB MIA74DKG52Accident · No injuriesClosedHelio Acft H-295 · Trion, GAFeb 21, 1974 · N275ZD · Substantial damage NTSB MIA74AM087Accident · 1 fatalClosedBeech K35 · Jasper, GAFeb 19, 1974 · N610T · Destroyed NTSB MIA74FKG51Accident · Serious injuriesClosedCessna 150B · Palmetto, GAFeb 15, 1974 · N1122Y · Substantial damage NTSB MIA74FKG50Accident · Minor injuriesClosedAmer Avco AA-1B · Harris Neck, GAJan 27, 1974 · N9609L · Substantial damage NTSB MIA74AM059Accident · 3 fatalClosedCessna 172A · Jackson, GAJan 18, 1974 · N7779T · Destroyed NTSB MIA74AM060Accident · 2 fatalClosedPiper PA-28 · Waleska, GAJan 16, 1974 · N40940 · Destroyed NTSB MIA74FKG49Accident · No injuriesClosedMitsubishi MU-2K · Covington, GAJan 14, 1974 · N222HH · Substantial damage NTSB MIA74FKG48Accident · Minor injuriesClosedCessna 150L · Tifton, GADec 31, 1973 · N5389Q · Destroyed NTSB MIA74FKG47Accident · Serious injuriesClosedAeronca 7AC · Dalton, GADec 14, 1973 · N83556 · Substantial damage NTSB MIA74FKG46Accident · Minor injuriesClosedCessna 140 · Savannah, GADec 3, 1973 · N2220N · Substantial damage NTSB MIA74FKG45Accident · No injuriesClosedAeronca L-16 · Brunswick, GANov 30, 1973 · N2554B · Substantial damage NTSB MIA74DKG44Accident · No injuriesClosedCessna 172 · Covington, GANov 24, 1973 · N6910X · Substantial damage NTSB MIA74AM043Accident · 2 fatalClosedBeech E55 · Decatur, GANov 16, 1973 · N3917A · Destroyed NTSB MIA74FLG15Accident · No injuriesClosedMeyers 200B · Savannah, GANov 14, 1973 · N357CE · Substantial damage NTSB MIA74FKG43Accident · No injuriesClosedN.American 600S2R · Albany, GANov 14, 1973 · N5645X · Substantial damage NTSB MIA74FKG42Accident · No injuriesClosedCessna 150 · Atlanta, GANov 12, 1973 · N6662F · Substantial damage NTSB MIA74FKG38Accident · No injuriesClosedRoberts Bandit · Rocky Face, GAOct 25, 1973 · N71DR · Substantial damage NTSB MIA74DKG40Accident · No injuriesClosedCessna 172L · Thomson, GAOct 23, 1973 · N4277Q · Substantial damage