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 MIA68D0448Accident · No injuriesClosedCessna 182 · Jefferson, GADec 12, 1967 · N6414A · Substantial damage NTSB MIA68F0292Accident · No injuriesClosedBeech A23 · Chamblee, GADec 5, 1967 · N3627Q · Substantial damage NTSB MIA68F0330Accident · No injuriesClosedBeech B35 · Atlanta, GADec 3, 1967 · N8847A · Substantial damage NTSB MIA68F0326Accident · No injuriesClosedCessna 310 · Chamblee, GADec 3, 1967 · N3684D · Substantial damage NTSB MIA68D0348Accident · No injuriesClosedCessna 150 · Douglasville, GADec 3, 1967 · N4331U · Substantial damage NTSB MIA68D0456Accident · No injuriesClosedPiper PA-28 · Moultrie, GANov 27, 1967 · N4766L · Substantial damage NTSB MIA68F0422Accident · Minor injuriesClosedCessna 185B · Chamblee, GANov 15, 1967 · N2560Z · Substantial damage NTSB MIA68D0291Accident · No injuriesClosedCessna 172 · Buena Vista, GANov 12, 1967 · N7864U · Substantial damage NTSB MIA68D0289Accident · No injuriesClosedChampion 7GCBC · Albany, GANov 12, 1967 · N8392V · Substantial damage NTSB MIA68D0285Accident · No injuriesClosedCessna 150 · Villa Rica, GANov 11, 1967 · N6254R · Substantial damage NTSB ANC68F0070Accident · No injuriesClosedPiper PA-24 · Marietta, GANov 11, 1967 · N7220P · Substantial damage NTSB MIA68D0436Accident · No injuriesClosedChampion 7EC · Senoia, GANov 5, 1967 · N7488B · Substantial damage NTSB MIA68F0309Accident · No injuriesClosedPiper PA-30 · Chamblee, GANov 4, 1967 · N7553Y · Substantial damage NTSB MIA68A0043Accident · 2 fatalClosedAero Comdr 560 · Calhoun, GANov 4, 1967 · N2677B · Destroyed NTSB MIA68F0327Accident · No injuriesClosedPiper PA-30 · Chamblee, GAOct 30, 1967 · N7615Y · Substantial damage NTSB MIA68D0381Accident · No injuriesClosedCessna 172 · Jonesboro, GAOct 29, 1967 · N8228B · Substantial damage NTSB MIA68F0343Accident · Serious injuriesClosedCessna 172 · Lithonia, GAOct 28, 1967 · N8511G · Destroyed NTSB MIA68D0331Accident · No injuriesClosedCessna 150 · Lithonia, GAOct 28, 1967 · N8122S · Substantial damage NTSB MIA68F0266Accident · No injuriesClosedHelio Acft H-391B · Lithonia, GAOct 26, 1967 · N4135D · Substantial damage NTSB MIA68D0356Accident · No injuriesClosedCessna 150 · Dahlonega, GAOct 22, 1967 · N8225F · Destroyed NTSB MIA68D0325Accident · Minor injuriesClosedPiper PA-28 · Augusta, GAOct 22, 1967 · N8347W · Substantial damage NTSB MIA68A0039Accident · No injuriesClosedAero-Comdr 200D · Albany, GAOct 21, 1967 · N2917T · Substantial damage NTSB MIA68D0247Accident · No injuriesClosedGlobe GC-1B · Kennesaw, GAOct 20, 1967 · N90310 · Substantial damage NTSB MIA68D0245Accident · No injuriesClosedMooney M20C · Lithonia, GAOct 14, 1967 · N2615W · Substantial damage NTSB MIA68F0312Accident · Serious injuriesClosedStinson L-5 · Blairsville, GAOct 8, 1967 · N64688 · Destroyed NTSB MIA68F0286Accident · Serious injuriesClosedPiper PA-28 · Macon, GAOct 8, 1967 · N4171J · Substantial damage NTSB MIA68F0272Accident · Minor injuriesClosedAero Comdr 200-D · Marietta, GAOct 8, 1967 · N2954T · Substantial damage NTSB MIA68A0035Accident · 3 fatalClosedCessna 172 · Villa Rica, GAOct 8, 1967 · N5625A · Destroyed NTSB MIA68F0235Accident · No injuriesClosedPiper PA-24 · Marietta, GAOct 4, 1967 · N6310P · Substantial damage NTSB MIA68F0306Accident · No injuriesClosedAeronca 11CC · Vidalia, GASep 22, 1967 · N4297E · Substantial damage NTSB MIA68F0213Accident · No injuriesClosedPiper PA-25 · Midville, GASep 15, 1967 · N7761Z · Substantial damage NTSB MIA68F0173Accident · No injuriesClosedAeronca 7AC · Cairo, GASep 13, 1967 · N85416 · Substantial damage NTSB MIA68F0250Accident · No injuriesClosedPiper PA-18 · Marietta, GASep 9, 1967 · N168T · Substantial damage NTSB MIA68F0241Accident · No injuriesClosedBeech H35 · Thomaston, GASep 9, 1967 · N4693D · Substantial damage NTSB MIA68F0236Accident · No injuriesClosedPiper PA-23 · Valdosta, GASep 4, 1967 · N3079P · Substantial damage NTSB MIA68F0195Accident · No injuriesClosedPiper PA-23 · Columbus, GASep 2, 1967 · N4584P · Substantial damage NTSB MIA68D0161Accident · No injuriesClosedMooney M20C · Chamberlee, GASep 2, 1967 · N2948L · Substantial damage NTSB MIA68D0166Accident · Minor injuriesClosedCessna 150 · Villa Rica, GASep 1, 1967 · N8488G · Substantial damage NTSB MIA68A0028Accident · 4 fatalClosedCessna 172H · Robertstown, GASep 1, 1967 · N2697L · Destroyed NTSB MIA68D0305Accident · No injuriesClosedPiper PA-28 · Sylvania, GAAug 27, 1967 · N9955W · Substantial damage NTSB MIA68F0208Accident · No injuriesClosedCessna 172 · Mcdonough, GAAug 26, 1967 · N8333X · Substantial damage NTSB MIA68D0201Accident · No injuriesClosedPiper PA-24 · Hinesville, GAAug 21, 1967 · N8813P · Substantial damage NTSB MIA68D0226Accident · No injuriesClosedPiper PA-25 · Douglas, GAAug 19, 1967 · N6638Z · Substantial damage NTSB MIA68D0202Accident · Minor injuriesClosedPiper PA-18 · Sylvester, GAAug 18, 1967 · N1390A · Destroyed NTSB MIA68F0180Accident · Serious injuriesClosedGrumman G-164 · Blakely, GAAug 15, 1967 · N749Y · Destroyed NTSB MIA68F0136Accident · No injuriesClosedCessna 140 · Dawson, GAAug 14, 1967 · N76110 · Substantial damage NTSB MIA68D0179Accident · No injuriesClosedCessna 185 · Atlanta, GAAug 13, 1967 · N9929X · Substantial damage NTSB MIA68F0182Accident · No injuriesClosedCessna 170B · Hampton, GAAug 12, 1967 · N2874C · Substantial damage NTSB MIA68F0165Accident · Serious injuriesClosedAeronca 11AC · Carnegie, GAAug 11, 1967 · N85840 · Substantial damage NTSB MIA68F0097Accident · No injuriesClosedBeech J50 · Atlanta, GAAug 11, 1967 · N9390Y · Substantial damage