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.

NTSB ATL81FKG29Accident · No injuriesClosedTexas Hel M74A · Montezuma, GAJun 25, 1981 · N51860 · Substantial damageNTSB ATL81FA086Accident · Serious injuriesClosedLuscombe 8A · Tifton, GAJun 25, 1981 · N71658 · 2 aircraft · DestroyedNTSB ATL81FKG28Accident · No injuriesClosedPiper PA-18 · Carrollton, GAJun 20, 1981 · N5589J · Substantial damageNTSB ATL81FKG27Accident · No injuriesClosedPiper PA-28 · Dahlonega, GAJun 17, 1981 · N5707U · Substantial damageNTSB ATL81DLA07Accident · Minor injuriesClosedCessna 152 · Folkston, GAJun 16, 1981 · N89808 · DestroyedNTSB ATL81FKG26Accident · No injuriesClosedPiper PA-28 · Reynolds, GAJun 14, 1981 · N7309F · DestroyedNTSB ATL81FKG25Accident · No injuriesClosedCessna 172F · Statesboro, GAJun 14, 1981 · N1117T · Substantial damageNTSB ATL81DKG23Accident · No injuriesClosedCessna A188B · Albany, GAJun 11, 1981 · N9822G · Substantial damageNTSB ATL81DKG24Accident · Minor injuriesClosedGrum Amer AA-5A · Cochran, GAJun 9, 1981 · N26772 · DestroyedNTSB ATL81FKG22Accident · Minor injuriesClosedCessna 150L · Lawrenceville, GAJun 5, 1981 · N19156 · DestroyedNTSB ATL81DKG21Accident · No injuriesClosedPiper PA-25 · Vidalia, GAJun 4, 1981 · N6289Z · Substantial damageNTSB ATL81FKG20Accident · No injuriesClosedCessna 421 · Statesboro, GAMay 29, 1981 · N76ES · Substantial damageNTSB ATL81FKG19Accident · No injuriesClosedCessna 150 · Williamson, GAMay 21, 1981 · N5714E · DestroyedNTSB ATL81FA075Accident · 1 fatalClosedCessna 172 · Rocky Face, GAMay 21, 1981 · N5414R · DestroyedNTSB ATL81FKG18Accident · No injuriesClosedVarize 01 · Winder, GAMay 5, 1981 · N1RL · DestroyedNTSB ATL81DLA06Accident · No injuriesClosedCessna 150G · Waycross, GAMay 1, 1981 · N2994J · Substantial damageNTSB ATL81FKG17Accident · No injuriesClosedPiper PA-39 · Macon, GAApr 28, 1981 · N8959Y · Substantial damageNTSB ATL81FKG15Accident · No injuriesClosedBeech A23 · Cornelia, GAApr 24, 1981 · N3572R · Substantial damageNTSB ATL81FKG16Accident · No injuriesClosedCessna 172P · Carnesville, GAApr 23, 1981 · N53045 · Substantial damageNTSB ATL81DLA05Accident · No injuriesClosedPiper PA-28 · Brunswick, GAApr 20, 1981 · N7993W · Substantial damageNTSB ATL81DKG14Accident · No injuriesClosedCessna 150 · Oglethorpe, GAApr 18, 1981 · N6441T · DestroyedNTSB ATL81FKG13Accident · No injuriesClosedBeech H18 · Atlanta, GAApr 17, 1981 · N7998K · Substantial damageNTSB ATL81DLA04Accident · No injuriesClosedCessna 177 · Homerville, GAApr 17, 1981 · N2247Y · Substantial damageNTSB ATL81FKG12Accident · Minor injuriesClosedPiper PA-28 · Dalton, GAApr 10, 1981 · N9431J · Substantial damageNTSB ATL81FKG11Accident · No injuriesClosedBeech E55 · Atlanta, GAMar 18, 1981 · N7237R · Substantial damageNTSB ATL81FLA03Accident · No injuriesClosedCessna 177A · St Simons, GAMar 14, 1981 · N30415 · Substantial damageNTSB ATL81FKG10Accident · Serious injuriesClosedBeech D18 · Claxton, GAMar 2, 1981 · N80162 · Substantial damageNTSB ATL81FLA02Accident · Minor injuriesClosedHughes 269B · Valdosta, GAMar 1, 1981 · N9557F · Substantial damageNTSB ATL81DKG08Accident · No injuriesClosedBeech 58P · Jenkinsburg, GAFeb 23, 1981 · N15X · Substantial damageNTSB ATL81FKJ15Accident · 1 fatalClosedPiper PA-32 · Mobile, GAFeb 19, 1981 · N3898W · DestroyedNTSB ATL81FKG09Accident · No injuriesClosedCessna 182L · Statesboro, GAFeb 19, 1981 · N3149R · Substantial damageNTSB ATL81FKG07Accident · Serious injuriesClosedCessna 195B · Columbus, GAFeb 15, 1981 · N3018B · Substantial damageNTSB ATL81FA040Accident · 1 fatalClosedCessna 180K · Statesboro, GAFeb 1, 1981 · N2954K · Destroyed