NTSB investigations, 1973, 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, 1973, 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\") = 1973
    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 FTW74DPG41Accident · No injuriesClosedPiper PA-32 · Mena, ARDec 24, 1973 · N4048R · Substantial damageNTSB FTW74FPG40Accident · No injuriesClosedBeech E55 · Fort Smith, ARDec 8, 1973 · N22JF · Substantial damageNTSB FTW74DPG38Accident · Minor injuriesClosedBeech B19 · Oxford, ARDec 3, 1973 · N1962W · DestroyedNTSB FTW74DPG39Accident · No injuriesClosedCessna 172 · Carlisle, ARNov 29, 1973 · N8462L · Substantial damageNTSB FTW74FPG37Accident · Serious injuriesClosedCessna 182N · Brookland, ARNov 8, 1973 · N9241 · DestroyedNTSB FTW74FPG35Accident · Serious injuriesClosedCessna 172E · Mt Home, AROct 28, 1973 · N3523S · Substantial damageNTSB FTW74DPG36Accident · Minor injuriesClosedBeech A23-19 · Salem, AROct 28, 1973 · N5982S · Substantial damageNTSB FTW74FPG34Accident · No injuriesClosedBeech 65-90 · De Queen, AROct 23, 1973 · N333CS · Substantial damageNTSB FTW74FPG33Accident · No injuriesClosedPiper PA-28 · Mena, AROct 20, 1973 · N5536W · Substantial damageNTSB FTW74FPG32Accident · Serious injuriesClosedPiper J3C-65 · Lepanto, AROct 18, 1973 · N33034 · DestroyedNTSB FTW74DPG31Accident · Minor injuriesClosedMooney M20C · Lakeview, AROct 12, 1973 · N2692W · Substantial damageNTSB FTW74FPG29Accident · Serious injuriesClosedCessna 172H · Carlisle, AROct 8, 1973 · N3790F · DestroyedNTSB FTW74DPG30Accident · No injuriesClosedAero Comdr S-2R · Fisher, AROct 8, 1973 · N5521X · DestroyedNTSB FTW74AF020Accident · No injuriesClosedPiper PA-34 · Pocahontas, AROct 7, 1973 · N1073U · Substantial damageNTSB FTW74FPG28Accident · No injuriesClosedCessna 150L · Joiner, AROct 2, 1973 · N18155 · 2 aircraft · Substantial damageNTSB FTW74FPG27Accident · Minor injuriesClosedPiper PA-25 · Rohwer, AROct 1, 1973 · N7351Z · DestroyedNTSB FTW74FPG26Accident · No injuriesClosedBell 47G2A1 · Little Rock, ARSep 29, 1973 · N73970 · Substantial damageNTSB DCA74AZ006Accident · 11 fatalClosedConvair 600 · Mena, ARSep 27, 1973 · N94230 · DestroyedNTSB FTW74FPG25Accident · No injuriesClosedCessna 180 · Hot Springs, ARSep 22, 1973 · VP-HCC · Substantial damageNTSB FTW74FPG24Accident · Serious injuriesClosedAeronca 7BC · Lake Village, ARSep 22, 1973 · N81875 · Substantial damageNTSB FTW74AF018Accident · 2 fatalClosedChampion 7KCAB · Jacksonville, ARSep 22, 1973 · N9003L · DestroyedNTSB FTW74DPG22Accident · No injuriesClosedN.American SNJ-5 · W Memphis, ARSep 19, 1973 · N66JL · Substantial damageNTSB FTW74FPG23Accident · Serious injuriesClosedBell 47G2 · Viola, ARSep 18, 1973 · N2870B · Substantial damageNTSB FTW74FRD12Accident · No injuriesClosedCessna 150 · Loreauville, ARSep 13, 1973 · N8983S · Substantial damageNTSB FTW74FPG21Accident · No injuriesClosedLuscombe 8A · Van Buren, ARSep 1, 1973 · N71153 · Substantial damageNTSB FTW74FPG19Accident · Serious injuriesClosedCessna 188 · Marvell, ARAug 30, 1973 · N21600 · DestroyedNTSB FTW74DPG18Accident · No injuriesClosedCommonwlth 185 · Jonesboro, ARAug 27, 1973 · N92830 · Substantial damageNTSB FTW74DPG17Accident · No injuriesClosedPiper J-3 · Stuttgart, ARAug 27, 1973 · N71022 · Substantial damageNTSB FTW74DPG16Accident · No injuriesClosedGrumman G-164 · Clarkedale, ARAug 27, 1973 · N8379 · Substantial damageNTSB FTW74FPG15Accident · No injuriesClosedCessna 182 · Arkadelphia, ARAug 26, 1973 · N91976 · Substantial damageNTSB FTW74DPG14Accident · Minor injuriesClosedPiper PA-18 · Barton, ARAug 20, 1973 · N4694Y · DestroyedNTSB FTW74DPG20Accident · Minor injuriesClosedCessna 172 · West Memphis, ARAug 18, 1973 · N7598X · Substantial damageNTSB FTW74FPG12Accident · 1 fatalClosedPiper PA-25 · Wabbaseka, ARAug 14, 1973 · N7238Z · DestroyedNTSB FTW74DPG11Accident · No injuriesClosedGrumman G-164A · Dewitt, ARAug 13, 1973 · N930X · DestroyedNTSB FTW74DPG10Accident · No injuriesClosedBell 47G · Black Rock, ARAug 9, 1973 · N163B · Substantial damageNTSB FTW74AF007Accident · 4 fatalClosedCessna 180 · Monticello, ARJul 29, 1973 · N9357C · DestroyedNTSB FTW74DPG07Accident · No injuriesClosedPiper PA-31 · West Helena, ARJul 27, 1973 · N117HC · Substantial damageNTSB FTW74DPG09Accident · No injuriesClosedPiper J-3 · Arkadelphia, ARJul 25, 1973 · N30799 · Substantial damageNTSB FTW74DPG08Accident · No injuriesClosedBoeing A75 · Conway, ARJul 25, 1973 · N55065 · Substantial damageNTSB FTW74DPG06Accident · No injuriesClosedGrumman G-164 · Stuttgart, ARJul 24, 1973 · N615Y · Substantial damageNTSB FTW74FPG04Accident · No injuriesClosedCessna 172I · Mena, ARJul 21, 1973 · N35555 · Substantial damageNTSB FTW74FPG05Accident · No injuriesClosedCallair A-5 · Arkadelphia, ARJul 19, 1973 · N9981C · Substantial damageNTSB FTW74FPG03Accident · No injuriesClosedBeech A23A · N.Little Rock, ARJul 18, 1973 · N4797J · Substantial damageNTSB FTW74FPG02Accident · No injuriesClosedCessna 337 · Hot Springs, ARJul 13, 1973 · N2146X · Substantial damageNTSB FTW74FPG01Accident · No injuriesClosedPiper PA-11 · Lewisville, ARJul 1, 1973 · N4768M · Substantial damageNTSB FTW73DPG66Accident · No injuriesClosedCessna 305 · Almyra, ARJun 28, 1973 · N1175D · Substantial damageNTSB FTW73DPG64Accident · No injuriesClosedBeech B55 · Pine Bluff, ARJun 25, 1973 · N8322N · Substantial damageNTSB FTW73DPG63Accident · No injuriesClosedCessna 188 · Mcgehee, ARJun 25, 1973 · N21801 · DestroyedNTSB FTW73DPG62Accident · No injuriesClosedCessna A188B · Tucker, ARJun 21, 1973 · N21720 · No damageNTSB FTW73FPG57Accident · No injuriesClosedCessna 170A · Conway, ARJun 10, 1973 · N8043A · Substantial damage