NTSB investigations, 1981, AR

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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, 1981, 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\") = 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 FTW82FPG07Accident · No injuriesClosedCessna 177RG · Little Rock, ARDec 31, 1981 · N1925Q · Substantial damageNTSB FTW82FPG06Accident · 1 fatalClosedPiper J3C-65 · Star City, ARDec 26, 1981 · N20886 · Substantial damageNTSB FTW81IA027Incident · No injuriesClosedBeech A36 · Fayetteville, ARNov 30, 1981 · N66861 · Minor damageNTSB FTW82FPG05Accident · No injuriesClosedPiper PA-60 · El Dorado, ARNov 26, 1981 · N8098J · Substantial damageNTSB FTW82DPG04Accident · No injuriesClosedCessna 182G · Hughes, ARNov 18, 1981 · N3114S · Substantial damageNTSB FTW82DPG02Accident · Serious injuriesClosedCessna 177B · Crossett, AROct 29, 1981 · N34745 · DestroyedNTSB FTW82KPG01Accident · 1 fatalClosedPitts S-1 · Jonesboro, AROct 24, 1981 · N10S · Substantial damageNTSB FTW81DPG70Accident · No injuriesClosedAir Tractor AT-301 · Lonoke, ARSep 30, 1981 · N8593S · Substantial damageNTSB FTW82FPG69Accident · Minor injuriesClosedCessna 150F · England, ARSep 29, 1981 · N8039F · Substantial damageNTSB FTW81FPG65Accident · Serious injuriesClosedVans RV3 · Little Rock, ARSep 20, 1981 · N80LK · Substantial damageNTSB FTW81DPG66Accident · No injuriesClosedPiper PA-23 · Jonesboro, ARSep 20, 1981 · N6115Y · Substantial damageNTSB FTW81DPG67Accident · No injuriesClosedAyres S2-R · Harrisburg, ARSep 19, 1981 · N4018P · Substantial damageNTSB FTW81DPG64Accident · No injuriesClosedCessna A188B · Gin City, ARSep 7, 1981 · N731VD · Substantial damageNTSB FTW81FPG63Accident · No injuriesClosedBeech C24R · Searcy, ARSep 3, 1981 · N6014L · Substantial damageNTSB FTW81DPG62Accident · No injuriesClosedPiper PA-38 · Grubbs, ARAug 22, 1981 · N9331T · Substantial damageNTSB FTW81FPG60Accident · 1 fatalClosedPiper J3C-65 · Almyra, ARAug 13, 1981 · N7399H · Substantial damageNTSB FTW81FPG61Accident · No injuriesClosedPiper PA-23 · Malvern, ARAug 12, 1981 · N9MG · Substantial damageNTSB FTW81DPG59Accident · No injuriesClosedAero Comdr S2R · Swifton, ARAug 5, 1981 · N8817Q · Substantial damageNTSB FTW81DPG58Accident · No injuriesClosedGrumman G-164A · Piggott, ARAug 3, 1981 · N8370 · Substantial damageNTSB FTW81FPG56Accident · No injuriesClosedCessna 421C · Little Rock, ARJul 31, 1981 · N98777 · Substantial damageNTSB FTW81DPG57Accident · No injuriesClosedPiper PA-25 · Mcgehee, ARJul 30, 1981 · N7192Z · Substantial damageNTSB FTW81FA127Accident · 2 fatalClosedBellanca 8KCAB · Alma, ARJul 26, 1981 · N90980 · DestroyedNTSB FTW81FA123Accident · 2 fatalClosedLuscombe 8A · N Little Rock, ARJul 21, 1981 · N71889 · DestroyedNTSB FTW81DPG55Accident · Minor injuriesClosedGrumman G-164B · Bono, ARJul 21, 1981 · N8098K · Substantial damageNTSB FTW81DPG52Accident · No injuriesClosedCessna 188 · Gould, ARJul 14, 1981 · N2536J · Substantial damageNTSB FTW81DPG53Accident · No injuriesClosedCessna 188B · Beech Grove, ARJul 13, 1981 · N4943R · Substantial damageNTSB FTW81FPG54Accident · No injuriesClosedPiper PA-32 · Little Rock, ARJul 12, 1981 · N4807S · Substantial damageNTSB FTW81DPG51Accident · No injuriesClosedGrumman G-164 · Cash, ARJul 2, 1981 · N10264 · Substantial damageNTSB FTW81DPG49Accident · No injuriesClosedRockwell S2R · Bono, ARJun 27, 1981 · N4980X · Substantial damageNTSB FTW81FPG50Accident · No injuriesClosedHiller Acft UH-12E · Warren, ARJun 21, 1981 · N178HA · Substantial damageNTSB FTW81FA110Accident · 4 fatalClosedPiper PA-22 · Busch, ARJun 20, 1981 · N8773D · DestroyedNTSB FTW81DPG48Accident · No injuriesClosedCessna 188 · Lake Village, ARJun 19, 1981 · N731ZA · Substantial damageNTSB FTW81DPG47Accident · No injuriesClosedRockwell S2R · Dumas, ARJun 17, 1981 · N4932X · DestroyedNTSB FTW81FPG45Accident · 1 fatalClosedGrumman G-164A · Lonoke, ARJun 12, 1981 · N7219 · DestroyedNTSB FTW81DPG46Accident · No injuriesClosedGrumman G-164 · Holly Grove, ARJun 12, 1981 · N8936H · Substantial damageNTSB FTW81DPG44Accident · No injuriesClosedCessna 182RG · Springdale, ARJun 10, 1981 · N756CZ · Substantial damageNTSB FTW81DPG43Accident · Serious injuriesClosedJunior Ace 6E · Salem, ARJun 10, 1981 · N59370 · Substantial damageNTSB FTW81DPG42Accident · No injuriesClosedGrumman G-164A · Wilson, ARJun 9, 1981 · N7864 · Substantial damageNTSB FTW81FPG40Accident · No injuriesClosedGrumman G-164B · Wynne, ARJun 8, 1981 · N8693H · Substantial damageNTSB FTW81DPG41Accident · No injuriesClosedCessna 172RG · Grady, ARJun 8, 1981 · N9568B · Substantial damageNTSB FTW81DPG38Accident · No injuriesClosedGrumman G-164 · Manila, ARJun 8, 1981 · N608U · DestroyedNTSB FTW81FPG39Accident · No injuriesClosedPiper PA-24 · Stuttgart, ARJun 7, 1981 · N5745P · Substantial damageNTSB FTW81DPG36Accident · No injuriesClosedGrumman G-164 · Hughes, ARMay 30, 1981 · N11KQ · DestroyedNTSB FTW81DPG30Accident · No injuriesClosedGrumman G-164A · Hughes, ARMay 29, 1981 · N8911H · Substantial damageNTSB FTW81FPG35Accident · 1 fatalClosedAyers S2R · West Bay, ARMay 28, 1981 · N5630X · Substantial damageNTSB FTW81DPG34Accident · No injuriesClosedGrumman G-164B · Griffithville, ARMay 28, 1981 · N6564 · DestroyedNTSB FTW81DPG29Accident · No injuriesClosedAyers S2R · Stuttgart, ARMay 27, 1981 · N5004X · Substantial damageNTSB FTW81DPG33Accident · Serious injuriesClosedAir Tractor AT-300 · Foreman, ARMay 26, 1981 · N4323S · DestroyedNTSB FTW81DPG37Accident · No injuriesClosedGrumman G-164B · Corning, ARMay 22, 1981 · N6699K · Substantial damageNTSB FTW81DPG28Accident · No injuriesClosedGrumman G-164B · Lexa, ARMay 22, 1981 · N6778K · Substantial damage