NTSB investigations, 1980, AR

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 per year

19642026
NTSB investigations, 1980, AR per year, 1964–2026: 3,153 cases
196485
196580
196687
1967109
196881
196989
197076
197192
197276
197382
197481
1975107
1976101
197791
197896
197990
198076
198172
198268
198346
198489
198549
198648
198746
198861
198948
199065
199153
199257
199355
199454
199558
199644
199740
199844
199949
200023
200121
200237
200337
200431
200537
200628
200717
200822
200921
201032
201122
201223
201321
201417
201521
201622
201716
201820
201914
202016
202119
202221
202323
202414
202520
202613

Latest cases

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\") = 1980
    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 FTW81FA017Accident · 2 fatalClosedPiper PA-32R · Hagarville, ARDec 14, 1980 · N12ML · DestroyedNTSB FTW81FPG07Accident · 1 fatalClosedBensen B8M · Sherrill, ARNov 29, 1980 · N3790K · DestroyedNTSB FTW81FPG06Accident · Serious injuriesClosedCessna 152 · Jasper, ARNov 28, 1980 · N714UG · DestroyedNTSB FTW81DPG08Accident · No injuriesClosedPiper PA-28R · Mountain Home, ARNov 28, 1980 · N43496 · Substantial damageNTSB FTW81FPG03Accident · Serious injuriesClosedCessna 170B · Lakeview, AROct 19, 1980 · N2853C · DestroyedNTSB FTW81FPG04Accident · Serious injuriesClosedPiper PA-28 · Benton, AROct 18, 1980 · N7588R · DestroyedNTSB FTW81FPG02Accident · No injuriesClosedCessna 320D · N Little Rock, AROct 3, 1980 · N3322Q · Substantial damageNTSB FTW81FA002Accident · Serious injuriesClosedCessna U206F · Lonoke, AROct 3, 1980 · N59179 · 2 aircraft · Substantial damageNTSB FTW81DPG01Accident · No injuriesClosedGrumman G-164A · Sherrill, AROct 1, 1980 · N7486 · Substantial damageNTSB FTW80FA126Accident · 4 fatalClosedPiper PA-24 · Hot Springs, ARSep 29, 1980 · N7839P · DestroyedNTSB FTW80DPG69Accident · No injuriesClosedPitts S-1 · Dumas, ARSep 24, 1980 · N1871 · Substantial damageNTSB FTW80DPG68Accident · No injuriesClosedCessna 172I · Marianna, ARSep 20, 1980 · N46047 · Substantial damageNTSB FTW80DA119Accident · No injuriesClosedPiper PA-28R · Mountain View, ARSep 20, 1980 · N32820 · Substantial damageNTSB FTW80DA115Accident · No injuriesClosedPiper PA-32 · Shedidan, ARSep 15, 1980 · N4YB · DestroyedNTSB FTW80DPG66Accident · No injuriesClosedAero Comdr S2R · Swifton, ARSep 9, 1980 · N4934X · DestroyedNTSB FTW80DPG67Accident · No injuriesClosedCessna 150 · Benton, ARSep 8, 1980 · N11485 · Substantial damageNTSB FTW80DPG64Accident · No injuriesClosedCessna T210M · Cotter, ARSep 6, 1980 · N6018N · Substantial damageNTSB FTW80FPG65Accident · Serious injuriesClosedCessna 150L · Clarksville, ARSep 4, 1980 · N17006 · Substantial damageNTSB FTW80DPG62Accident · No injuriesClosedCessna 150H · Monticello, ARSep 1, 1980 · N7251S · Substantial damageNTSB FTW80DPG61Accident · No injuriesClosedCessna 310G · Helena, ARAug 23, 1980 · N8962Z · Substantial damageNTSB FTW80DPG60Accident · Minor injuriesClosedCessna 188 · Marvell, ARAug 21, 1980 · N731SB · DestroyedNTSB FTW80DPG59Accident · Minor injuriesClosedSnow S2R · Cherry Valley, ARAug 12, 1980 · N4011Y · Substantial damageNTSB FTW80FA102Accident · 2 fatalClosedCessna 150H · Jonesboro, ARAug 10, 1980 · N6780S · DestroyedNTSB FTW80FPG58Accident · No injuriesClosedPiper PA-24 · Little Rock, ARAug 9, 1980 · N9154P · Substantial damageNTSB FTW80FPG57Accident · Serious injuriesClosedPiper PA-25 · Humphrey, ARAug 6, 1980 · N6933Z · Substantial damageNTSB FTW80DPG56Accident · No injuriesClosedCessna 188 · Bradley, ARAug 4, 1980 · N70382 · Substantial damageNTSB FTW80DPG55Accident · No injuriesClosedCessna 188 · Mcgehee, ARAug 1, 1980 · N9129G · Substantial damageNTSB FTW80DPG54Accident · No injuriesClosedSnow S2R · Hickory Ridge, ARJul 30, 1980 · N8528V · DestroyedNTSB FTW80DPG52Accident · Minor injuriesClosedCessna 177 · O'Neal, ARJul 26, 1980 · N34988 · Substantial damageNTSB FTW80DPG53Accident · No injuriesClosedAyres S2R · Winchester, ARJul 25, 1980 · N5048X · Substantial damageNTSB FTW80DPG49Accident · No injuriesClosedPiper PA-25 · Grady, ARJul 20, 1980 · N4550Y · Substantial damageNTSB FTW80DPG50Accident · No injuriesClosedGrumman G-164A · Tuckerman, ARJul 19, 1980 · N9942 · DestroyedNTSB FTW80DPG48Accident · No injuriesClosedCessna 188 · Paragould, ARJul 18, 1980 · N8145G · Substantial damageNTSB FTW80DPG46Accident · No injuriesClosedAir Tractor AT-301 · Palestine, ARJul 14, 1980 · N4364S · Substantial damageNTSB FTW80DPG47Accident · No injuriesClosedAeronca 7BCM · Bono, ARJul 13, 1980 · N6084V · Substantial damageNTSB FTW80DPG45Accident · No injuriesClosedCessna A188B · Tyronza, ARJul 13, 1980 · N91391 · Substantial damageNTSB FTW80DPG44Accident · No injuriesClosedGrumman G-164 · Heth, ARJul 8, 1980 · N48476 · Substantial damageNTSB FTW80DPG43Accident · No injuriesClosedPiper PA-11 · Hazen, ARJul 6, 1980 · N78689 · DestroyedNTSB FTW80FPG41Accident · No injuriesClosedCessna 175 · Sherrill, ARJul 3, 1980 · N7106M · Substantial damageNTSB FTW80DPG42Accident · Minor injuriesClosedPiper PA-18 · Hazen, ARJul 3, 1980 · N9735P · DestroyedNTSB FTW80DPG40Accident · No injuriesClosedGrumman G-164A · Cash, ARJul 2, 1980 · N6761Q · Substantial damageNTSB FTW80DPG51Accident · Minor injuriesClosedGrumman G-164B · Blythevl Afb, ARJun 26, 1980 · N48678 · DestroyedNTSB FTW80DPG39Accident · No injuriesClosedCessna 310 · Paris, ARJun 25, 1980 · N61DS · Substantial damageNTSB FTW80DPG38Accident · No injuriesClosedGrumman G-164 · Hazen, ARJun 25, 1980 · N8945H · Substantial damageNTSB FTW80FPG37Accident · No injuriesClosedBoeing PT-13D · N Little Rock, ARJun 22, 1980 · N75658 · Substantial damageNTSB FTW80DPG36Accident · No injuriesClosedGrumman G-164 · Cotton Plant, ARJun 13, 1980 · N5087 · Substantial damageNTSB FTW80DPG34Accident · No injuriesClosedGrumman G-164A · Conway, ARJun 8, 1980 · N7957 · Substantial damageNTSB FTW80DPG33Accident · No injuriesClosedCessna 172F · Benton, ARJun 4, 1980 · N5410R · Substantial damageNTSB FTW80DPG32Accident · No injuriesClosedCessna A188B · Evening Star, ARJun 3, 1980 · N9152G · DestroyedNTSB FTW80FPG30Accident · Serious injuriesClosedGlobe GC-1B · Carbon City, ARMay 27, 1980 · N3808K · Substantial damage