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 MIA70FKG15Accident · No injuriesClosedAero Comdr A9B · Sylvania, GAFeb 23, 1970 · N7748V · Destroyed NTSB MIA70DKG13Accident · No injuriesClosedCessna 150 · Chamblee, GAFeb 21, 1970 · N4062J · Substantial damage NTSB MIA70AM072Accident · 1 fatalClosedAeronca 7BCM · Augusta, GAFeb 21, 1970 · N2551B · Destroyed NTSB MIA70DKG14Accident · Minor injuriesClosedCessna 182 · Eastman, GAFeb 20, 1970 · N2920F · Substantial damage NTSB MIA70FKG12Accident · No injuriesClosedLear Jet 23 · Atlanta, GAFeb 14, 1970 · N43B · Substantial damage NTSB MIA70AM071Accident · 3 fatalClosedBeech D95A · Duluth, GAFeb 14, 1970 · N8808M · Destroyed NTSB MIA70DKG11Accident · No injuriesClosedLuscombe 8D · Stockbridge, GAFeb 7, 1970 · N41920 · Substantial damage NTSB MIA70DKG10Accident · No injuriesClosedCessna 150H · Pine Mountain, GAFeb 7, 1970 · N22638 · Substantial damage NTSB MIA70FKG09Accident · No injuriesClosedPiper PA-28 · Macon, GAFeb 5, 1970 · N8881W · Substantial damage NTSB MIA70FKG08Accident · No injuriesClosedCessna 150E · Atlanta, GAFeb 2, 1970 · N3972U · Destroyed NTSB MIA70AM064Accident · 1 fatalClosedLuscombe 8A · Brookfield, GAFeb 2, 1970 · N45505 · Destroyed NTSB MIA70FKG06Accident · Minor injuriesClosedCessna 172 · Marietta, GAJan 26, 1970 · N7645X · Substantial damage NTSB MIA70FKG05Accident · No injuriesClosedBeech 65-90 · Atlanta, GAJan 26, 1970 · N44F · Substantial damage NTSB MIA70FKG07Accident · No injuriesClosedBensen B-8M · Richmond Hill, GAJan 25, 1970 · N116R · Substantial damage NTSB MIA70FKG04Accident · No injuriesClosedCessna 177 · Villa Rica, GAJan 24, 1970 · N2312Y · Substantial damage NTSB MIA70AM063Accident · 2 fatalClosedCessna 172 · Dahlonega, GAJan 23, 1970 · N8949B · Destroyed NTSB MIA70FKG02Accident · Serious injuriesClosedBeech 95-A55 · Kennesaw, GAJan 15, 1970 · N9586Y · Substantial damage NTSB MIA70FKG01Accident · Serious injuriesClosedPiper PA-32 · Richland, GAJan 14, 1970 · N3245W · Destroyed NTSB MIA70D0301Accident · No injuriesClosedPiper PA-23 · Cedartown, GADec 27, 1969 · N3079P · Substantial damage NTSB MIA70F0303Accident · No injuriesClosedCessna 170A · Palmetto, GADec 25, 1969 · N9196A · Substantial damage NTSB MIA70D0302Accident · No injuriesClosedAero Comdr A-9B · Colquitt, GADec 24, 1969 · N7656V · Substantial damage NTSB MIA70D0313Accident · No injuriesClosedCessna 140 · Crawford, GADec 22, 1969 · N81046 · Substantial damage NTSB MIA70F0300Accident · No injuriesClosedCessna 150H · Kennesaw, GADec 18, 1969 · N7078S · Substantial damage NTSB MIA70F0307Accident · No injuriesClosedCessna 172F · Chamblee, GADec 14, 1969 · N8555U · Substantial damage NTSB MIA70F0306Accident · Minor injuriesClosedAero Comdr 200-D · Ashburn, GADec 12, 1969 · N2900T · Substantial damage NTSB MIA70A0044Accident · 2 fatalClosedCessna 210G · Valdosta, GADec 9, 1969 · N5919F · Destroyed NTSB MIA70F0311Accident · No injuriesClosedMooney M20A · Savannah, GADec 5, 1969 · N6005X · Substantial damage NTSB MIA70D0267Accident · No injuriesClosedAeronca 65-CA · Dallas, GANov 28, 1969 · N36527 · Substantial damage NTSB MIA70A0040Accident · 2 fatalClosedChampion 7FC · Midville, GANov 22, 1969 · N8508E · Destroyed NTSB MIA70F0239Accident · No injuriesClosedCessna 170A · Marietta, GANov 15, 1969 · N9913A · Substantial damage NTSB MIA70F0291Accident · No injuriesClosedBeech C-45H · Albany, GANov 14, 1969 · N9818Z · Destroyed NTSB MIA70F0238Accident · Serious injuriesClosedCessna 150 · Jonesboro, GANov 9, 1969 · N4157U · Destroyed NTSB MIA70D0235Accident · No injuriesClosedPiper PA-22 · Athens, GANov 6, 1969 · N4406A · Substantial damage NTSB MIA70F0297Accident · No injuriesClosedBeech V35 · Chamblee, GAOct 31, 1969 · N5622S · Substantial damage NTSB MIA70A0035Accident · 1 fatalClosedBeech 35 · Thomasville, GAOct 25, 1969 · N2817V · Destroyed NTSB MIA70D0310Accident · No injuriesClosedPiper PA-28 · Brunswick, GAOct 20, 1969 · N6925W · Substantial damage NTSB MIA70A0033Accident · 1 fatalClosedBeech V35 · Fort Gaines, GAOct 18, 1969 · N7944M · Destroyed NTSB MIA70F0285Accident · Serious injuriesClosedGrumman G-164 · Morgan, GAOct 17, 1969 · N651U · Destroyed NTSB MIA70A0032Accident · 4 fatalClosedBeech D18S · Macon, GAOct 17, 1969 · N5000S · Destroyed NTSB MIA70D0275Accident · No injuriesClosedCessna 120 · Savannah, GAOct 16, 1969 · N1600V · Substantial damage NTSB MIA71D0001Accident · No injuriesClosedCessna 177 · Valdosta, GAOct 14, 1969 · N3177T · Substantial damage NTSB MIA70F0251Accident · No injuriesClosedPiper PA-28 · Cochran, GAOct 11, 1969 · N8263W · Substantial damage NTSB MIA70D0312Accident · No injuriesClosedStinson 108-1 · Alma, GAOct 5, 1969 · N8518K · Substantial damage NTSB MIA70A0028Accident · 1 fatalClosedPiper PA-28 · Jessup, GAOct 1, 1969 · N6585J · Destroyed NTSB MIA70D0296Accident · No injuriesClosedPiper J-3 · Hopetn Plntion, GASep 28, 1969 · N46917 · Substantial damage NTSB MIA70A0022Accident · 1 fatalClosedNavion A · Williamson, GASep 19, 1969 · N8593H · Destroyed NTSB MIA70F0305Accident · No injuriesClosedCessna 182B · Ashburn, GASep 13, 1969 · N7187E · Substantial damage NTSB MIA70F0284Accident · Serious injuriesClosedPiper PA-25 · Rutledge, GASep 12, 1969 · N6109Z · Destroyed NTSB MIA70D0292Accident · No injuriesClosedPiper PA-28 · St.Simons, GASep 10, 1969 · N6392W · Substantial damage NTSB MIA70D0290Accident · Serious injuriesClosedCessna 172 · Canton, GASep 6, 1969 · N7067T · Substantial damage