NTSB investigations, 1977, AR

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1977, 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\") = 1977
    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 FTW78FPG11Accident · Minor injuriesClosedCessna 170A · Heber Springs, ARDec 21, 1977 · N9074A · DestroyedNTSB FTW78FA018Accident · 1 fatalClosedCessna 210D · Hot Springs, ARDec 13, 1977 · TI-AIC · DestroyedNTSB FTW78DPG10Accident · No injuriesClosedCessna 150 · Newark, ARDec 9, 1977 · N560MA · Substantial damageNTSB FTW78FPG09Accident · No injuriesClosedBeech 95-B55 · Siloam Springs, ARDec 6, 1977 · N8322N · Substantial damageNTSB FTW78DPG08Accident · No injuriesClosedGrumman G-164A · Hazen, ARDec 4, 1977 · N5070 · DestroyedNTSB FTW78FRJ09Accident · Serious injuriesClosedCessna 150G · Texarkana, ARNov 27, 1977 · N3240X · DestroyedNTSB FTW78FA012Accident · 2 fatalClosedPiper PA-18 · Waldron, ARNov 21, 1977 · N83441 · DestroyedNTSB FTW78DPG06Accident · No injuriesClosedMustang II · Wheatley, ARNov 13, 1977 · N18811 · Substantial damageNTSB FTW78DPG07Accident · No injuriesClosedPiper PA-28 · West Helena, ARNov 12, 1977 · N4531X · Substantial damageNTSB FTW78FPG05Accident · No injuriesClosedPiper PA-24 · Booneville, ARNov 5, 1977 · N5581P · Substantial damageNTSB FTW78FPG04Accident · No injuriesClosedBenson B8M · Rogers, AROct 22, 1977 · N4355 · Substantial damageNTSB FTW78DPG03Accident · No injuriesClosedBellanca 8GCBC · Marianna, AROct 12, 1977 · N8558V · Substantial damageNTSB FTW77FPG01Accident · No injuriesClosedPiper PA-34 · Little Rock, AROct 4, 1977 · N41192 · Substantial damageNTSB FTW77FPG90Accident · No injuriesClosedPiper PA-25 · Caraway, ARSep 28, 1977 · N9865P · Substantial damageNTSB FTW77DPG89Accident · No injuriesClosedGrumman G-164 · Hughes, ARSep 28, 1977 · N659Y · DestroyedNTSB FTW77DPG88Accident · No injuriesClosedPiper PA-25 · Paragould, ARSep 27, 1977 · N6884Z · Substantial damageNTSB FTW77FPG91Accident · 1 fatalClosedAeronca 7AC · Slovak, ARSep 22, 1977 · N2358E · DestroyedNTSB FTW77FPG87Accident · No injuriesClosedBeech D18S · Pine Bluff, ARSep 21, 1977 · N240E · Substantial damageNTSB FTW77FPG86Accident · No injuriesClosedBell 47G2H1 · Mountain View, ARSep 19, 1977 · N38926 · DestroyedNTSB FTW77FPG85Accident · No injuriesClosedCessna 188B · Portland, ARSep 12, 1977 · N731HL · DestroyedNTSB FTW77DPG84Accident · Serious injuriesClosedPiper PA-25 · Gregory, ARSep 6, 1977 · N9715P · DestroyedNTSB FTW77DPG82Accident · No injuriesClosedCessna 170A · West Helena, ARSep 3, 1977 · N9939A · Substantial damageNTSB FTW77DPG81Accident · No injuriesClosedPiper PA-25 · Piggott, ARSep 2, 1977 · N8545L · DestroyedNTSB FTW77DPG83Accident · No injuriesClosedPiper PA-25 · Leachville, ARSep 1, 1977 · N4798Y · Substantial damageNTSB FTW77DPG80Accident · No injuriesClosedAero Commdr S-2R · Reydell, ARAug 23, 1977 · N5501X · Substantial damageNTSB FTW77FPG78Accident · No injuriesClosedSnow S-2R · Wilmot, ARAug 22, 1977 · N8466V · Substantial damageNTSB FTW77FPG79Accident · No injuriesClosedFairchild M-62 · Jonesboro, ARAug 18, 1977 · N69256 · Substantial damageNTSB FTW77FPG77Accident · 1 fatalClosedWeatherly 201B · Cornerstone, ARAug 15, 1977 · N1259W · 2 aircraft · Substantial damageNTSB FTW77DPG75Accident · No injuriesClosedGrumman G-164A · De Valls, ARAug 15, 1977 · N8945H · Substantial damageNTSB FTW77FPG76Accident · No injuriesClosedGrumman G-164A · Tillar, ARAug 12, 1977 · N4665 · Substantial damageNTSB FTW77DPG74Accident · No injuriesClosedPiper PA-28 · Lead Hill, ARAug 8, 1977 · N4420X · DestroyedNTSB FTW77FPG73Accident · Serious injuriesClosedPiper PA-24 · Garfield, ARAug 6, 1977 · N8907P · DestroyedNTSB FTW77DPG72Accident · No injuriesClosedGrumman G-164A · England, ARAug 3, 1977 · N4832 · Substantial damageNTSB FTW77DPG70Accident · No injuriesClosedCessna 188 · Mcgehee, ARJul 23, 1977 · N4946Q · Substantial damageNTSB FTW77FPG71Accident · No injuriesClosedGrumman G-164A · Stuttgart, ARJul 21, 1977 · N8742H · Substantial damageNTSB FTW77FPG68Accident · No injuriesClosedGrumman G-164 · Keo, ARJul 21, 1977 · N4638 · Substantial damageNTSB FTW77FPG69Accident · Minor injuriesClosedCessna 411 · Paragould, ARJul 20, 1977 · N3253R · Substantial damageNTSB FTW77FPG67Accident · No injuriesClosedCessna 310 · El Dorado, ARJul 15, 1977 · N3647D · Substantial damageNTSB FTW77DPG65Accident · No injuriesClosedPiper PA-25 · Manila, ARJul 14, 1977 · N9511P · Substantial damageNTSB FTW77FPG66Accident · No injuriesClosedCessna 188 · Brookland, ARJul 13, 1977 · N9815V · DestroyedNTSB FTW77FPG64Accident · No injuriesClosedPiper PA-25 · Coy, ARJul 12, 1977 · N9837P · DestroyedNTSB FTW77DPG63Accident · No injuriesClosedGrumman G-164A · Clarendon, ARJul 8, 1977 · N5361 · Substantial damageNTSB FTW77DPG62Accident · No injuriesClosedGrumman G-164A · Jonesboro, ARJul 8, 1977 · N8672H · Substantial damageNTSB FTW77DPG61Accident · No injuriesClosedGrumman G-164A · Hunter, ARJul 7, 1977 · N7485 · Substantial damageNTSB FTW77FPG58Accident · Serious injuriesClosedAeronca 7AC · Almond, ARJul 6, 1977 · N85695 · Substantial damageNTSB FTW77DPG57Accident · No injuriesClosedAero Comdr S-2R · Beedeville, ARJul 6, 1977 · N5649X · Substantial damageNTSB FTW77FPG55Accident · Serious injuriesClosedPiper PA-25 · Des Arc, ARJul 5, 1977 · N4685Y · DestroyedNTSB FTW77FPG60Accident · No injuriesClosedPiper PA-24 · Russellville, ARJul 2, 1977 · N7757P · Substantial damageNTSB FTW77DPG56Accident · No injuriesClosedPiper PA-28R · Mt.Olive, ARJul 2, 1977 · N38140 · Substantial damageNTSB FTW77DPG54Accident · No injuriesClosedCessna A188B · Parkin, ARJul 2, 1977 · N4909Q · Destroyed