NTSB investigations, 1981, AR

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\" = 'AR' 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 FTW81DPG27Accident · Minor injuriesClosedBell 47E · Fair Oaks, ARMay 21, 1981 · N51846 · DestroyedNTSB FTW81FPG32Accident · No injuriesClosedBeech 77 · Carlisle, ARMay 20, 1981 · N60430 · DestroyedNTSB FTW81FPG31Accident · Serious injuriesClosedBeech 95-B55 · Little Rock, ARMay 20, 1981 · N9571Q · DestroyedNTSB FTW81DPG26Accident · No injuriesClosedBeech B58 · Benton, ARMay 13, 1981 · N6745M · Substantial damageNTSB FTW81FPG25Accident · Serious injuriesClosedCessna 152 · N Little Rock, ARMay 11, 1981 · N757AU · DestroyedNTSB FTW81DPG24Accident · No injuriesClosedGrumman G-164A · Trumann, ARMay 8, 1981 · N8595H · Substantial damageNTSB FTW81FPG23Accident · No injuriesClosedCessna 182RG · Hickory Ridge, ARMay 3, 1981 · N4760S · Substantial damageNTSB FTW81DPG22Accident · No injuriesClosedGrumman G-164B · Coy, ARApr 29, 1981 · N8148K · Substantial damageNTSB FTW81DPG21Accident · No injuriesClosedCessna 150 · Marshall, ARApr 29, 1981 · N50494 · Substantial damageNTSB FTW81DPG20Accident · No injuriesClosedCessna 188 · Burdette, ARApr 28, 1981 · N9948G · DestroyedNTSB FTW81DPG19Accident · No injuriesClosedCessna 172 · Bay, ARApr 26, 1981 · N79078 · Substantial damageNTSB FTW81DPG18Accident · No injuriesClosedBeech C55 · El Dorado, ARApr 17, 1981 · N44W · Substantial damageNTSB FTW81FRJ12Accident · Minor injuriesClosedPiper PA-32 · Texarkana, ARApr 12, 1981 · N3726W · DestroyedNTSB FTW81DPG17Accident · No injuriesClosedPiper PA-25 · Monette, ARApr 10, 1981 · N82349 · Substantial damageNTSB FTW81DRG16Accident · Serious injuriesClosedCessna 210 · Lakeview, ARApr 3, 1981 · N8146G · Substantial damageNTSB FTW81DPG15Accident · No injuriesClosedCessna 401 · Jonesboro, ARMar 23, 1981 · N8434F · Substantial damageNTSB FTW81DPG13Accident · No injuriesClosedPiper PA-25 · Keiser, ARMar 12, 1981 · N82378 · Substantial damageNTSB FTW81DPG12Accident · Serious injuriesClosedPiper PA-22 · Rogers, ARMar 10, 1981 · N3343Z · Substantial damageNTSB FTW81DPG11Accident · No injuriesClosedPiper PA-31 · Mountain Home, ARMar 1, 1981 · N7579L · Substantial damageNTSB FTW81DPG10Accident · No injuriesClosedGrumman G-164B · Carlisle, ARFeb 23, 1981 · N48487 · Substantial damageNTSB FTW81DA032Accident · Minor injuriesClosedBeech 95-C55 · Little Rock, ARFeb 13, 1981 · N44LP · Substantial damageNTSB FTW81DPG09Accident · Minor injuriesClosedCessna 172H · Fordyce, ARJan 29, 1981 · N1442F · Substantial damage