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 MIA80FKG21Accident · Minor injuriesClosedPiper PA-22 · Register, GAMar 19, 1980 · N6174D · Substantial damage NTSB MIA80DLA39Accident · No injuriesClosedCessna 172 · Folkston, GAMar 18, 1980 · N9963V · Substantial damage NTSB MIA80DKG25Accident · No injuriesClosedPiper PA-31T · Canton, GAMar 18, 1980 · N208SW · Substantial damage NTSB MIA80FKG22Accident · No injuriesClosedPiper PA-30 · Gainesville, GAMar 16, 1980 · N7858Y · Substantial damage NTSB IAD80FA030Accident · 4 fatalClosedPiper PA-34 · Pine Mountain, GAMar 7, 1980 · N36074 · Destroyed NTSB MIA80FA044Accident · 3 fatalClosedMooney M20K · Blairsville, GAMar 6, 1980 · N231GQ · Destroyed NTSB MIA80FKG20Accident · No injuriesClosedAero Comdr 680T · Chamblee, GAMar 2, 1980 · N6514V · Substantial damage NTSB MIA80FA037Accident · 3 fatalClosedBeech V35 · Valdosta, GAFeb 24, 1980 · N5620S · Destroyed NTSB MIA80FKG19Accident · No injuriesClosedSchweizer 2-33A · Williamson, GAFeb 23, 1980 · N33928 · Substantial damage NTSB IAD80FA026Accident · 2 fatalClosedBeech 95-B55 · Cumming, GAFeb 19, 1980 · N88LR · Destroyed NTSB MIA80FKG18Accident · No injuriesClosedCessna 150 · Columbus, GAFeb 18, 1980 · N45384 · Destroyed NTSB MIA80FKG17Accident · No injuriesClosedErco 415-C · Columbus, GAFeb 11, 1980 · N2599H · Substantial damage NTSB MIA80FKG16Accident · Serious injuriesClosedGrum Amer AA-5A · Atlanta, GAFeb 2, 1980 · N26673 · Destroyed NTSB MIA80FKG15Accident · Serious injuriesClosedPiper PA-12 · Columbus, GAJan 20, 1980 · N2684M · Substantial damage NTSB MIA80FA021Accident · 5 fatalClosedPiper PA-32 · Woodbine, GADec 21, 1979 · N3802W · Destroyed NTSB MIA80FLA12Accident · 1 fatalClosedNavion H · Waycross, GADec 18, 1979 · N2552T · Destroyed NTSB MIA80FKG14Accident · Minor injuriesClosedAeronca 11AC · Fitzgerald, GADec 12, 1979 · N9552E · Substantial damage NTSB MIA79FLA10Accident · No injuriesClosedBell 206B · Sea Island, GADec 10, 1979 · N59530 · Substantial damage NTSB MIA80FKG13Accident · Serious injuriesClosedCessna T337F · Athens, GADec 8, 1979 · N1119M · Substantial damage NTSB MIA80FKG12Accident · Minor injuriesClosedCessna 310K · Jesup, GADec 6, 1979 · N6983L · Substantial damage NTSB MIA80FKG11Accident · No injuriesClosedBeech 58 · Atlanta, GANov 25, 1979 · N66839 · Substantial damage NTSB MIA80FKG10Accident · No injuriesClosedCessna 182 · Dawson, GANov 21, 1979 · N738CE · Substantial damage NTSB MIA80DKG09Accident · No injuriesClosedPiper PA-38 · Statesboro, GANov 10, 1979 · N2317B · Substantial damage NTSB MIA80FKG07Accident · Serious injuriesClosedPiper PA-28 · Jonesboro, GANov 3, 1979 · N3038Q · Substantial damage NTSB MIA80DKG08Accident · No injuriesClosedGrumman G-164 · Springfield, GANov 1, 1979 · N8057K · Substantial damage NTSB MIA80FKG05Accident · No injuriesClosedBeech 60 · Montezuma, GAOct 30, 1979 · N4762M · Substantial damage NTSB MIA80FKG06Accident · No injuriesClosedBeech A45 · Fayetteville, GAOct 27, 1979 · N5240V · Substantial damage NTSB MIA80FLA04Accident · No injuriesClosedErco 415-C · Camila, GAOct 21, 1979 · N99982 · Substantial damage NTSB MIA80FKG04Accident · No injuriesClosedCessna 152 · Athens, GAOct 13, 1979 · N25889 · Substantial damage NTSB MIA80FKG03Accident · No injuriesClosedCessna 152 · Snellville, GAOct 13, 1979 · N67825 · Substantial damage NTSB MIA80FKG01Accident · No injuriesClosedCessna 150 · Jonesboro, GAOct 7, 1979 · N11791 · Substantial damage NTSB MIA80FKG02Accident · Serious injuriesClosedAdams,Md AX-6 · Helen, GAOct 6, 1979 · N5659 · Destroyed NTSB MIA79DKG71Accident · No injuriesClosedCessna 182Q · Brooklet, GASep 20, 1979 · N759EG · Substantial damage NTSB MIA79FKG70Accident · No injuriesClosedCessna 172M · Atlanta, GASep 16, 1979 · N8177L · Substantial damage NTSB MIA79FKG68Accident · No injuriesClosedCessna 172 · Marietta, GASep 16, 1979 · N696IH · Substantial damage NTSB MIA79FA123Accident · 2 fatalClosedCessna 182P · Folkston, GASep 16, 1979 · N9197M · Destroyed NTSB MIA79FA122Accident · 2 fatalClosedPiper PA-28 · Alma, GASep 16, 1979 · N15029 · Destroyed NTSB MIA79DLA52Accident · Serious injuriesClosedCessna 150 · Brunswick, GASep 7, 1979 · N5603G · No damage NTSB MIA79FKG69Accident · 2 fatalClosedCavalier SA-102 · Cumming, GASep 2, 1979 · N2892 · Destroyed NTSB MIA79FLA48Accident · No injuriesClosedBell 47D1 · Hahira, GASep 1, 1979 · N908B · Destroyed NTSB MIA79FKG67Accident · Minor injuriesClosedCessna 182P · Chamblee, GASep 1, 1979 · N1442M · Substantial damage NTSB MIA79DLA51Accident · Minor injuriesClosedPiper PA-25 · Nashville, GASep 1, 1979 · N6842Z · Substantial damage NTSB MIA79FKG66Accident · Minor injuriesClosedMooney M20D · Atlanta, GAAug 31, 1979 · N6638U · Substantial damage NTSB MIA79DLA49Accident · Serious injuriesClosedPiper PA-25 · Moultire, GAAug 31, 1979 · N9512P · Destroyed NTSB MIA79FKG65Accident · Minor injuriesClosedAero Cmndr S2R600 · Narabi, GAAug 29, 1979 · N8816Q · Destroyed NTSB MIA79DLA47Accident · Minor injuriesClosedPiper PA-25 · Norman Park, GAAug 29, 1979 · N8581L · Substantial damage NTSB MIA79DLA45Accident · No injuriesClosedCessna 170B · Willacoochee, GAAug 25, 1979 · N3115B · Substantial damage NTSB MIA79FKG63Accident · Serious injuriesClosedCessna 150L · Kennesaw, GAAug 21, 1979 · N18036 · Destroyed NTSB MIA79DLA44Accident · No injuriesClosedCessna 152 · Nashville, GAAug 19, 1979 · N89803 · Substantial damage NTSB MIA79DKG62Accident · Minor injuriesClosedCallair A9A · Mcrae, GAAug 14, 1979 · N8412V · Destroyed