NTSB investigations, 1971, AR

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1971, 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\") = 1971
    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 FTW72DPG58Accident · No injuriesClosedCessna 150 · Heth, ARDec 27, 1971 · N61242 · Substantial damageNTSB FTW72FPG57Accident · Serious injuriesClosedChampion 7GCBC · Parkin, ARDec 20, 1971 · N1851G · DestroyedNTSB FTW72FPG56Accident · Serious injuriesClosedCessna 150E · Hot Springs, ARDec 3, 1971 · N4020U · DestroyedNTSB FTW72DPG55Accident · No injuriesClosedCessna 177 · Carlisle, ARNov 16, 1971 · N29380 · Substantial damageNTSB FTW72FPG54Accident · No injuriesClosedCessna 150 · Jacksonville, ARNov 7, 1971 · N6182T · Substantial damageNTSB FTW72FPG53Accident · No injuriesClosedBeech 95-B55 · De Queen, AROct 30, 1971 · N8925M · Substantial damageNTSB FTW72FPG52Accident · No injuriesClosedLuscombe 8F · Marion, AROct 24, 1971 · N8291 · Substantial damageNTSB FTW72FPG48Accident · No injuriesClosedTaylorcraft BC1265 · Benton, AROct 17, 1971 · N29741 · Substantial damageNTSB FTW72FPG49Accident · No injuriesClosedMitsubishi MU-2B · Van Buren, AROct 15, 1971 · N3540X · Substantial damageNTSB FTW72DPG47Accident · No injuriesClosedPiper PA-25 · Joiner, AROct 15, 1971 · N6924Z · No damageNTSB FTW72DPG46Accident · No injuriesClosedCessna 172B · Banks, AROct 15, 1971 · N8093X · Substantial damageNTSB FTW72FPG50Accident · No injuriesClosedHarvard MK IV · West Memphis, AROct 9, 1971 · N4447 · Substantial damageNTSB FTW72DPG45Accident · Minor injuriesClosedGrumman G-164 · Trumann, AROct 8, 1971 · N6656 · DestroyedNTSB FTW72FPG44Accident · No injuriesClosedCessna 172 · El Dorado, AROct 7, 1971 · N84805 · Substantial damageNTSB FTW72DPG43Accident · No injuriesClosedPiper PA-25 · Osceola, ARSep 23, 1971 · N8839L · Substantial damageNTSB FTW72AF016Accident · 2 fatalClosedPiper J3C-65 · Springdale, ARSep 20, 1971 · N3633K · DestroyedNTSB FTW72FPG42Accident · 1 fatalClosedPiper PA-25 · Mccrory, ARSep 11, 1971 · N7640Z · DestroyedNTSB FTW72DPG39Accident · No injuriesClosedPiper PA-16 · De Queen, ARSep 8, 1971 · N5729H · Substantial damageNTSB FTW72DPG36Accident · No injuriesClosedCessna 188 · Van Buren, ARSep 8, 1971 · N9871V · Substantial damageNTSB FTW72DPG38Accident · No injuriesClosedSchweizer SGS233 · Abbott, ARSep 5, 1971 · N7759S · Substantial damageNTSB FTW72DPG37Accident · Minor injuriesClosedCessna 150G · Abbott, ARSep 5, 1971 · N6296S · Substantial damageNTSB FTW72FPG41Accident · No injuriesClosedBoeing E75N1 · Aubrey, ARSep 3, 1971 · N75692 · Substantial damageNTSB FTW72FPG40Accident · No injuriesClosedBoeing E75N1 · Aubrey, ARSep 3, 1971 · N75667 · Substantial damageNTSB FTW72FPG51Accident · Minor injuriesClosedPiper PA-25 · Stephens, ARSep 2, 1971 · N8647L · Substantial damageNTSB FTW72DPG34Accident · No injuriesClosedPiper PA-25 · Tyronza, ARSep 1, 1971 · N6919Z · Substantial damageNTSB FTW72FRJ06Accident · No injuriesClosedLake LA-4 · Texarkana, ARAug 28, 1971 · N2038L · Substantial damageNTSB FTW72DPG31Accident · No injuriesClosedLuscombe 8A · Humnoke, ARAug 26, 1971 · N71353 · Substantial damageNTSB FTW72FPG32Accident · Serious injuriesClosedPiper PA-18A · W.Helena, ARAug 25, 1971 · N1857A · DestroyedNTSB FTW72DPG33Accident · No injuriesClosedCessna 188 · Marvell, ARAug 25, 1971 · N5526S · Substantial damageNTSB FTW72DPG30Accident · No injuriesClosedGrumman G-164 · Moro, ARAug 22, 1971 · N521Y · Substantial damageNTSB FTW72DPG28Accident · Minor injuriesClosedBoeing D75N1 · Joiner, ARAug 20, 1971 · N73444 · Substantial damageNTSB FTW72FPG27Accident · 1 fatalClosedAero Comdr A-9B · Mccrory, ARAug 16, 1971 · N7683V · DestroyedNTSB FTW72DPG23Accident · No injuriesClosedSnow 600S2D · Parkin, ARAug 16, 1971 · N1725S · Substantial damageNTSB FTW72DPG26Accident · No injuriesClosedGrumman G-164 · Truman, ARAug 14, 1971 · N615U · Substantial damageNTSB FTW72DPG25Accident · No injuriesClosedPiper PA-18 · West Memphis, ARAug 14, 1971 · N116T · Substantial damageNTSB FTW72DPG22Accident · No injuriesClosedPiper PA-25 · Holly Grove, ARAug 12, 1971 · N8523L · Substantial damageNTSB FTW72FPG21Accident · No injuriesClosedPiper PA-18 · West Helena, ARAug 11, 1971 · N9855D · Substantial damageNTSB FTW72FPG18Accident · No injuriesClosedCessna 195 · Jonesboro, ARAug 9, 1971 · N2159C · Substantial damageNTSB FTW72DPG24Accident · No injuriesClosedGrumman G-164A · Tubbell, ARAug 7, 1971 · N5369 · Substantial damageNTSB FTW72FPG19Accident · No injuriesClosedCessna 140 · N Little Rock, ARAug 6, 1971 · N2025V · Substantial damageNTSB FTW72DPG17Accident · No injuriesClosedBoeing E75 · Dumas, ARAug 5, 1971 · N3996B · Substantial damageNTSB FTW72FPG15Accident · 1 fatalClosedBoeing E75 · Dumas, ARJul 31, 1971 · N5362N · DestroyedNTSB FTW72FPG16Accident · No injuriesClosedGrumman G-164 · Keo, ARJul 29, 1971 · N5364 · Substantial damageNTSB FTW72DPG14Accident · No injuriesClosedPiper PA-25 · Heth, ARJul 27, 1971 · N8780L · Substantial damageNTSB FTW72FPG12Accident · 1 fatalClosedPiper PA-25 · Star City, ARJul 21, 1971 · N7400Z · DestroyedNTSB FTW72FPG11Accident · Minor injuriesClosedCessna 150F · Nashville, ARJul 21, 1971 · N8398G · Substantial damageNTSB FTW72FPG10Accident · No injuriesClosedCessna 182N · Mt Ida, ARJul 18, 1971 · N92272 · Substantial damageNTSB FTW72FPG05Accident · No injuriesClosedPiper PA-25 · Beech Grove, ARJul 13, 1971 · N7528Z · Substantial damageNTSB FTW72DPG03Accident · Serious injuriesClosedPiper PA-25 · Lake Village, ARJul 12, 1971 · N4680Y · DestroyedNTSB FTW72DPG04Accident · Minor injuriesClosedPitts Spcl S1C · West Helena, ARJul 11, 1971 · N111JM · Substantial damage