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 MIA69F0115Accident · Minor injuriesClosedPiper PA-22 · Sylvania, GAJul 6, 1968 · N7837D · Substantial damage NTSB MIA69F0030Accident · No injuriesClosedChampion 7ECA · Villa Rica, GAJul 5, 1968 · N8339V · Substantial damage NTSB MIA69A0001Accident · 1 fatalClosedAeronca 65-TC · Moultrie, GAJul 2, 1968 · N29476 · Destroyed NTSB MIA69F0157Accident · Serious injuriesClosedCessna 120 · Jonesboro, GAJun 30, 1968 · N1737N · Substantial damage NTSB MIA69D0202Accident · No injuriesClosedBellanca 14-19 · Blakely, GAJun 27, 1968 · N7691B · Substantial damage NTSB MIA69D0085Accident · No injuriesClosedCessna 150 · Pinehurst, GAJun 23, 1968 · N8121F · Substantial damage NTSB MIA69F0102Accident · Serious injuriesClosedPratt-Read PR-G1 · Monroe, GAJun 22, 1968 · N60235 · Substantial damage NTSB MIA69F0100Accident · No injuriesClosedBoeing A75N1 · Bainbridge, GAJun 19, 1968 · N59881 · Substantial damage NTSB MIA68A0108Accident · 2 fatalClosedPiper PA-30 · Statesboro, GAJun 17, 1968 · N7603Y · Destroyed NTSB MIA69F0073Accident · Serious injuriesClosedStinson 108-3 · Kennesaw, GAJun 16, 1968 · N635C · Substantial damage NTSB MIA69F0064Accident · Minor injuriesClosedTaylorcraft BC12-D · Lithonia, GAJun 15, 1968 · N43596 · Destroyed NTSB MIA69F0235Accident · Serious injuriesClosedBoeing E75N1 · Ashburn, GAJun 14, 1968 · N66490 · Destroyed NTSB MIA69D0262Accident · No injuriesClosedCessna 150F · Albany, GAJun 8, 1968 · N8267S · Substantial damage NTSB MIA68A0099Accident · 3 fatalClosedCessna 411 · Vidalia, GAJun 1, 1968 · N7395U · Destroyed NTSB MIA68F0528Accident · No injuriesClosedPiper PA-28 · Marietta, GAMay 22, 1968 · N8914W · Substantial damage NTSB MIA69F0032Accident · Serious injuriesClosedPiper J3L-65 · Dalton, GAMay 18, 1968 · N32839 · Destroyed NTSB MIA69F0052Accident · Minor injuriesClosedPiper J-3 · Tifton, GAMay 17, 1968 · N42774 · Substantial damage NTSB MIA69F0156Accident · No injuriesClosedMooney M20C · Calhoun, GAMay 11, 1968 · N7856V · Substantial damage NTSB MIA69D0089Accident · No injuriesClosedCessna 140 · Irwinville, GAMay 11, 1968 · N72586 · Substantial damage NTSB MIA68D0492Accident · No injuriesClosedCessna 150 · Jonesboro, GAMay 4, 1968 · N3521J · Substantial damage NTSB MIA69F0060Accident · No injuriesClosedCessna 150F · Fairburn, GAApr 19, 1968 · N6924F · Substantial damage NTSB MIA68D0502Accident · No injuriesClosedN.American SNJ-5 · Savannah, GAApr 18, 1968 · N5493V · Substantial damage NTSB MIA68A0068Accident · 1 fatalClosedMooney M20F · Rochelle, GAApr 14, 1968 · N3785N · Destroyed NTSB MIA68F0500Accident · No injuriesClosedCessna 120 · Jonesboro, GAApr 12, 1968 · N2114V · Substantial damage NTSB MIA68A0085Accident · 4 fatalClosedCessna 182 · Dahlonega, GAApr 10, 1968 · N3152R · Destroyed NTSB MIA68D0489Accident · No injuriesClosedCessna 150 · Roswell, GAApr 6, 1968 · N6622T · Substantial damage NTSB MIA68A0084Accident · 2 fatalClosedCessna 150G · Lilburn, GAApr 5, 1968 · N3724J · Destroyed NTSB MIA68F0488Accident · Serious injuriesClosedPiper PA-18A · Savannah, GAMar 28, 1968 · N8695D · Destroyed NTSB MIA68A0080Accident · No injuriesClosedLockhead PV-2 · Macon, GAMar 26, 1968 · N7414C · Substantial damage NTSB MIA68F0014Accident · No injuriesClosedCessna 150 · Stone Mountain, GAMar 21, 1968 · N3107J · Substantial damage NTSB MIA68D0501Accident · No injuriesClosedCessna 182H · Chamblee, GAMar 19, 1968 · N2046X · Substantial damage NTSB MIA68F0527Accident · Minor injuriesClosedAero Cmdr 500-A · Jeckyll Island, GAMar 12, 1968 · N9374R · Substantial damage NTSB MIA69D0057Accident · No injuriesClosedCessna 150 · Swainsboro, GAMar 10, 1968 · N8853S · Substantial damage NTSB MIA68A0079Accident · 1 fatalClosedCessna 182B · Morganton, GAMar 10, 1968 · N2511G · Destroyed NTSB MIA68A0076Accident · 2 fatalClosedCessna 150G · Columbus, GAMar 9, 1968 · N3037S · Destroyed NTSB MIA68F0505Accident · No injuriesClosedCessna 140 · Douglasville, GAFeb 25, 1968 · N72583 · Destroyed NTSB MIA68F0399Accident · Minor injuriesClosedAlon A-2 · Richland, GAFeb 13, 1968 · N5668F · Destroyed NTSB MIA68F0376Accident · No injuriesClosedPiper PA-28 · Lithonia, GAFeb 6, 1968 · N8368R · Substantial damage NTSB MIA68F0491Accident · Serious injuriesClosedPiper PA-22 · Sasser, GAJan 28, 1968 · N3133Z · Substantial damage NTSB MIA68F0396Accident · No injuriesClosedPiper PA-28 · Metter, GAJan 27, 1968 · N9602W · Substantial damage NTSB MIA68D0432Accident · No injuriesClosedPiper PA-23 · Dublin, GAJan 21, 1968 · N4846P · Substantial damage NTSB MIA68F0465Accident · No injuriesClosedPiper PA-28 · Savannah, GAJan 20, 1968 · N5797W · Substantial damage NTSB MIA68F0402Accident · No injuriesClosedCessna 150B · Duluth, GAJan 15, 1968 · N1122Y · Substantial damage NTSB MIA68F0359Accident · No injuriesClosedPiper PA-28 · Hazelhurst, GAJan 14, 1968 · N6780W · Substantial damage NTSB MIA68F0367Accident · No injuriesClosedPiper PA-22 · Moultrie, GAJan 9, 1968 · N9182D · Destroyed NTSB MIA69D0033Accident · No injuriesClosedPiper PA-22 · Gainesville, GADec 30, 1967 · N9249D · Substantial damage NTSB MIA68F0362Accident · No injuriesClosedCessna 150 · Douglasville, GADec 26, 1967 · N4239U · Substantial damage NTSB MIA68A0058Accident · 2 fatalClosedCessna 170B · Warm Springs, GADec 22, 1967 · N1953C · Destroyed NTSB MIA68D0506Accident · Minor injuriesClosedAero Comdr 100 · Brunswick, GADec 16, 1967 · N5540M · Destroyed NTSB MIA68F0377Accident · No injuriesClosedCessna 170A · Wadley, GADec 13, 1967 · N81Z · Substantial damage