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 MIA78FKG30Accident · No injuriesClosedCessna C-145 · Chamblee, GAMar 28, 1978 · N25487 · Substantial damage NTSB MIA78DKG31Accident · No injuriesClosedBeech A23 · Glenwood, GAMar 28, 1978 · N5652S · Substantial damage NTSB MIA78FKG29Accident · Serious injuriesClosedCessna 172 · Sparta, GAMar 26, 1978 · N8075L · Destroyed NTSB MIA78FKG28Accident · No injuriesClosedCessna R172K · Augusta, GAMar 23, 1978 · N736QV · Substantial damage NTSB MIA78DKG27Accident · No injuriesClosedGlobe GC-1A · Stone Mountain, GAMar 19, 1978 · N80956 · Substantial damage NTSB MIA78DLA20Accident · No injuriesClosedCessna 150M · Bainbridge, GAMar 16, 1978 · N6169K · Substantial damage NTSB MIA78FLA19Accident · No injuriesClosedCessna 150 · Barwick, GAMar 15, 1978 · N1667Q · Substantial damage NTSB MIA78FKG26Accident · Serious injuriesClosedCessna 175 · Elberton, GAMar 13, 1978 · N7272M · Substantial damage NTSB MIA78FKG25Accident · No injuriesClosedCessna 207 · Augusta, GAMar 8, 1978 · N1517U · Substantial damage NTSB MIA78FA051Accident · 2 fatalClosedCessna 172M · Griffing, GAMar 7, 1978 · N13304 · Destroyed NTSB MIA78FKG23Accident · Minor injuriesClosedCessna 150 · Lawrenceville, GAMar 5, 1978 · N50196 · Substantial damage NTSB MIA78FKG24Accident · No injuriesClosedCessna 172E · Lula, GAMar 4, 1978 · N3788S · Substantial damage NTSB MIA78FA048Accident · 2 fatalClosedPiper PA-30 · Waco, GAMar 2, 1978 · N7428Y · Destroyed NTSB MIA78DKG22Accident · No injuriesClosedPiper PA-18 · Albany, GAFeb 24, 1978 · N83575 · Substantial damage NTSB MIA78FA044Accident · 1 fatalClosedBeech A45 · Moultrie, GAFeb 18, 1978 · N7747C · Destroyed NTSB MIA78DA045Accident · 4 fatalClosedPiper PA-28 · Jekyll Island, GAFeb 18, 1978 · N620FL · Destroyed NTSB MIA78FKG21Accident · No injuriesClosedGrumman AA5-A · Savannah, GAFeb 15, 1978 · N26312 · Substantial damage NTSB MIA78FA041Accident · 1 fatalClosedCessna 150F · Jefferson, GAFeb 15, 1978 · N8318G · Destroyed NTSB MIA78FKG20Accident · No injuriesClosedCessna 150 · Roswell, GAFeb 11, 1978 · N4719X · Substantial damage NTSB MIA78FKG17Accident · Minor injuriesClosedCessna 150 · Palmetto, GAJan 30, 1978 · N6946G · Substantial damage NTSB MIA78FKQ18Accident · Serious injuriesClosedBeech 35 · Stone Mountain, GAJan 28, 1978 · N95QR · Destroyed NTSB MIA78FKG19Accident · No injuriesClosedPiper PA-28 · Stockbridge, GAJan 28, 1978 · N4506F · Substantial damage NTSB MIA78FKG16Accident · No injuriesClosedCessna 150 · Norcross, GAJan 27, 1978 · N63271 · Substantial damage NTSB MIA78FKG15Accident · No injuriesClosedErco 415C · Rome, GAJan 27, 1978 · N94382 · Substantial damage NTSB MIA78FKG14Accident · Serious injuriesClosedPitts Spcl S-1 · Newnan, GAJan 22, 1978 · N4EW · Substantial damage NTSB MIA78FKG13Accident · No injuriesClosedBeech D18 · Savannah, GAJan 16, 1978 · N1828D · 2 aircraft · Substantial damage NTSB MIA78FKG12Accident · Serious injuriesClosedCessna 150 · Newman, GAJan 16, 1978 · N63330 · Substantial damage NTSB MIA78FKG09Accident · Minor injuriesClosedPiper PA-28 · Grovetown, GAJan 7, 1978 · N6475R · Destroyed NTSB MIA78FA042Accident · 1 fatalClosedBeech C23 · Eatonton, GAJan 7, 1978 · N9BW · Destroyed NTSB MIA78FA026Accident · 3 fatalClosedCessna 177 · Albany, GADec 31, 1977 · N3296T · Destroyed NTSB MIA78FKG10Accident · No injuriesClosedPiper PA-32R · Ila, GADec 26, 1977 · N8475F · Substantial damage NTSB MIA78FA022Accident · 2 fatalClosedCessna 172 · Blairsville, GADec 24, 1977 · N4183L · Destroyed NTSB MIA78FA015Accident · 1 fatalClosedPiper PA-18 · Jeffersonville, GADec 15, 1977 · N4890P · Destroyed NTSB MIA78DLA09Accident · No injuriesClosedCessna 150 · Cairo, GADec 7, 1977 · N19195 · Substantial damage NTSB MIA78FLA08Accident · No injuriesClosedCessna 150 · Thomasville, GADec 2, 1977 · N704HX · Destroyed NTSB MIA78FKG07Accident · Serious injuriesClosedBellanca 17-30A · Marietta, GANov 30, 1977 · N6611V · Destroyed NTSB MIA78DLA07Accident · Minor injuriesClosedCessna 150 · Whigham, GANov 25, 1977 · N6546T · Substantial damage NTSB MIA78FKG06Accident · Minor injuriesClosedCessna 182Q · Albany, GANov 10, 1977 · N735CN · Substantial damage NTSB MIA78FKG05Accident · No injuriesClosedCessna 310J · Rome, GANov 8, 1977 · N3078L · Substantial damage NTSB MIA78DKG04Accident · No injuriesClosedCessna 170 · Hazelhurst, GANov 7, 1977 · N90906 · Substantial damage NTSB MIA77FA009Accident · 2 fatalClosedCessna 182K · Atlanta, GAOct 28, 1977 · N2842R · Destroyed NTSB MIA78FKG03Accident · Serious injuriesClosedCessna 140 · Calhoun, GAOct 21, 1977 · N2222V · Substantial damage NTSB MIA77FLA05Accident · No injuriesClosedPiper PA24 · Camilla, GAOct 14, 1977 · N6746P · Substantial damage NTSB MIA77FA005Accident · 2 fatalClosedPiper PA-28 · Brunswick, GAOct 14, 1977 · N8097N · Destroyed NTSB MIA78FA003Accident · No injuriesClosedCessna 207 · Atlanta, GAOct 13, 1977 · N91048 · Substantial damage NTSB MIA78DKG02Accident · No injuriesClosedCessna 140 · Tifton, GAOct 9, 1977 · N76817 · Destroyed NTSB MIA78FLA05Accident · No injuriesClosedCessna 310B · Cairo, GAOct 5, 1977 · N5387A · Substantial damage NTSB MIA78DKG01Accident · No injuriesClosedRogers Grow Triace · Warner Robbins, GAOct 5, 1977 · N185RG · Substantial damage NTSB MIA77FA095Accident · 1 fatalClosedCessna 182P · Stone Mountain, GASep 30, 1977 · N1833M · Destroyed NTSB MIA77DKG83Accident · No injuriesClosedPiper PA-24 · Jefferson, GASep 26, 1977 · N5339P · Substantial damage