NTSB investigations, 1981, GA
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.
Cases, newest first
Query with SQL
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 year(c.\"eventDate\") = 1981
AND 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 year(c."eventDate") = 1981 AND 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 ATL81FKG29Accident · No injuriesClosedTexas Hel M74A · Montezuma, GANTSB ATL81FA086Accident · Serious injuriesClosedLuscombe 8A · Tifton, GANTSB ATL81FKG28Accident · No injuriesClosedPiper PA-18 · Carrollton, GANTSB ATL81FKG27Accident · No injuriesClosedPiper PA-28 · Dahlonega, GANTSB ATL81DLA07Accident · Minor injuriesClosedCessna 152 · Folkston, GANTSB ATL81FKG26Accident · No injuriesClosedPiper PA-28 · Reynolds, GANTSB ATL81FKG25Accident · No injuriesClosedCessna 172F · Statesboro, GANTSB ATL81DKG23Accident · No injuriesClosedCessna A188B · Albany, GANTSB ATL81DKG24Accident · Minor injuriesClosedGrum Amer AA-5A · Cochran, GANTSB ATL81FKG22Accident · Minor injuriesClosedCessna 150L · Lawrenceville, GANTSB ATL81DKG21Accident · No injuriesClosedPiper PA-25 · Vidalia, GANTSB ATL81FKG20Accident · No injuriesClosedCessna 421 · Statesboro, GANTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GANTSB ATL81FA075Accident · 1 fatalClosedCessna 172 · Rocky Face, GANTSB ATL81FKG18Accident · No injuriesClosedVarize 01 · Winder, GANTSB ATL81DLA06Accident · No injuriesClosedCessna 150G · Waycross, GANTSB ATL81FKG17Accident · No injuriesClosedPiper PA-39 · Macon, GANTSB ATL81FKG15Accident · No injuriesClosedBeech A23 · Cornelia, GANTSB ATL81FKG16Accident · No injuriesClosedCessna 172P · Carnesville, GANTSB ATL81DLA05Accident · No injuriesClosedPiper PA-28 · Brunswick, GANTSB ATL81DKG14Accident · No injuriesClosedCessna 150 · Oglethorpe, GANTSB ATL81FKG13Accident · No injuriesClosedBeech H18 · Atlanta, GANTSB ATL81DLA04Accident · No injuriesClosedCessna 177 · Homerville, GANTSB ATL81FKG12Accident · Minor injuriesClosedPiper PA-28 · Dalton, GANTSB ATL81FKG11Accident · No injuriesClosedBeech E55 · Atlanta, GANTSB ATL81FLA03Accident · No injuriesClosedCessna 177A · St Simons, GANTSB ATL81FKG10Accident · Serious injuriesClosedBeech D18 · Claxton, GANTSB ATL81FLA02Accident · Minor injuriesClosedHughes 269B · Valdosta, GANTSB ATL81DKG08Accident · No injuriesClosedBeech 58P · Jenkinsburg, GANTSB ATL81FKJ15Accident · 1 fatalClosedPiper PA-32 · Mobile, GANTSB ATL81FKG09Accident · No injuriesClosedCessna 182L · Statesboro, GANTSB ATL81FKG07Accident · Serious injuriesClosedCessna 195B · Columbus, GANTSB ATL81FA040Accident · 1 fatalClosedCessna 180K · Statesboro, GA