NTSB investigations, 1972, 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, 1972, 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\") = 1972
    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 FTW73IF028Incident · Minor injuriesClosedBoeing 707 · Little Rock, ARDec 14, 1972 · N7569A · No damageNTSB FTW73DPG33Accident · No injuriesClosedCessna 120 · Beebe, ARNov 5, 1972 · N76602 · Substantial damageNTSB FTW73FPG32Accident · Serious injuriesClosedAero Comdr A-9B · Gould, AROct 20, 1972 · N7948V · DestroyedNTSB FTW73FPG30Accident · Serious injuriesClosedBantam Burton · El Dorado, AROct 14, 1972 · N3920 · Substantial damageNTSB FTW73FPG31Accident · Serious injuriesClosedBoeing A75 · Moro, AROct 13, 1972 · N57989 · Substantial damageNTSB FTW73DPG29Accident · No injuriesClosedCessna 120 · Corning, AROct 12, 1972 · N76324 · Substantial damageNTSB FTW73DPG27Accident · No injuriesClosedPiper PA-28 · Judsonia, AROct 7, 1972 · N3664K · Substantial damageNTSB FTW73FRJ19Accident · No injuriesClosedPiper J4A · Texarkana, AROct 3, 1972 · N29640 · Substantial damageNTSB FTW73FPG28Accident · 1 fatalClosedSnow S2A · Chatfield, AROct 3, 1972 · N9405R · DestroyedNTSB FTW73FPG26Accident · Minor injuriesClosedCessna 172 · N.Little Rock, AROct 1, 1972 · N5473R · Substantial damageNTSB FTW73DPG25Accident · No injuriesClosedCessna 337B · Lonoke, ARSep 30, 1972 · N5453S · Substantial damageNTSB FTW74DPG24Accident · No injuriesClosedCallair A-9 · Rudy, ARSep 27, 1972 · N8237H · Substantial damageNTSB FTW73AF010Accident · 1 fatalClosedMooney M20A · Peach Orchard, ARSep 25, 1972 · N1068C · DestroyedNTSB FTW73DPG34Accident · No injuriesClosedBell 47D · Plumerville, ARSep 20, 1972 · N925V · Substantial damageNTSB FTW73FPG23Accident · No injuriesClosedCessna 188 · Scott, ARSep 18, 1972 · N5609J · Substantial damageNTSB FTW73DPG21Accident · Minor injuriesClosedCessna 172 · Ashdown, ARSep 17, 1972 · N8405X · Substantial damageNTSB FTW73DPG20Accident · No injuriesClosedCessna 120 · Lakeview, ARSep 17, 1972 · N89729 · Substantial damageNTSB FTW73FRJ17Accident · 1 fatalClosedAero Comdr A-9 · Garland City, ARSep 13, 1972 · N8029V · Substantial damageNTSB FTW73FPG22Accident · No injuriesClosedCessna 188B · Marvell, ARSep 12, 1972 · N21626 · Substantial damageNTSB FTW73FPG19Accident · Minor injuriesClosedBoeing E75 · Elaine, ARSep 11, 1972 · N1614M · DestroyedNTSB FTW73FRJ18Accident · No injuriesClosedCessna 182E · Texarkana, ARSep 9, 1972 · N3353Y · Minor damageNTSB FTW73FPG18Accident · No injuriesClosedCessna 182E · Pocahontas, ARSep 6, 1972 · N9341X · Substantial damageNTSB FTW73DRJ12Accident · No injuriesClosedCessna 150F · Texarkana, ARSep 3, 1972 · N6639F · Substantial damageNTSB FTW73DPG17Accident · No injuriesClosedAmer Avco AA1-A · Caraway, ARSep 2, 1972 · N9497L · Substantial damageNTSB FTW73FPG15Accident · No injuriesClosedCessna 188 · Elaine, ARAug 29, 1972 · N8014V · Substantial damageNTSB FTW73DPG16Accident · No injuriesClosedBoeing 75 · St Charles, ARAug 26, 1972 · N1383V · DestroyedNTSB FTW73FPG14Accident · Minor injuriesClosedCessna 182F · Scranton, ARAug 20, 1972 · N3582U · Substantial damageNTSB FTW73FPG13Accident · No injuriesClosedPiper PA-20 · Booneville, ARAug 13, 1972 · N6988K · Substantial damageNTSB FTW73FPG12Accident · No injuriesClosedGrumman G-164 · Wynne, ARAug 9, 1972 · N612U · Substantial damageNTSB FTW73FPG11Accident · No injuriesClosedAero Comdr A-9A · Boydell, ARAug 8, 1972 · N671W · Substantial damageNTSB FTW73FPG10Accident · No injuriesClosedPiper J-5 · Van, ARAug 7, 1972 · N32886 · Substantial damageNTSB FTW73DPG06Accident · No injuriesClosedGrumman G-164 · Weiner, ARAug 1, 1972 · N602Y · Substantial damageNTSB FTW73FPG08Accident · Serious injuriesClosedStearman E75N1 · Pollard, ARJul 31, 1972 · N38979 · Substantial damageNTSB FTW73FPG07Accident · No injuriesClosedGrumman G-164A · Coy, ARJul 26, 1972 · N6563 · DestroyedNTSB FTW73DPG05Accident · No injuriesClosedPiper PA-25 · Eudora, ARJul 23, 1972 · N4704Y · Substantial damageNTSB FTW73FPG09Accident · Minor injuriesClosedPiper PA-22 · Arkansas City, ARJul 20, 1972 · N4562A · Substantial damageNTSB FTW73DPG03Accident · No injuriesClosedGrumman G-164A · Hazen, ARJul 19, 1972 · N6579 · Substantial damageNTSB FTW73DPG04Accident · No injuriesClosedSnow S2A · Almyra, ARJul 17, 1972 · N9415R · Substantial damageNTSB FTW73DPG02Accident · No injuriesClosedLuscombe 8E · Monticello, ARJul 13, 1972 · N2716K · Substantial damageNTSB FTW73DPG01Accident · No injuriesClosedGrumman G-164 · Mayflower, ARJul 1, 1972 · N355Y · Substantial damageNTSB FTW72FPG87Accident · No injuriesClosedSnow S2A · Almyra, ARJun 30, 1972 · N9401R · Substantial damageNTSB FTW72FPG88Accident · No injuriesClosedBoeing A75 · De Witt, ARJun 24, 1972 · N62465 · Substantial damageNTSB FTW72FPG86Accident · 1 fatalClosedCessna A188 · Jerome, ARJun 21, 1972 · N3515Q · DestroyedNTSB FTW72FPG84Accident · 2 fatalClosedGrumman G-164A · Crawfordsvlle, ARJun 11, 1972 · N7234 · Substantial damageNTSB FTW72FPG85Accident · No injuriesClosedGrumman G-164A · Jerome, ARJun 10, 1972 · N6658 · Substantial damageNTSB FTW72FPG83Accident · Minor injuriesClosedCessna A188A · Hickory Ridge, ARJun 5, 1972 · N5682J · Substantial damageNTSB FTW72AF082Accident · 2 fatalClosedCessna 210E · Monticello, ARJun 4, 1972 · N2371F · DestroyedNTSB FTW72FPG82Accident · Minor injuriesClosedCessna 182 · Guion, ARJun 1, 1972 · N7174 · Substantial damageNTSB FTW72FPG81Accident · Serious injuriesClosedCessna 150 · Guion, ARJun 1, 1972 · N22570 · Substantial damageNTSB FTW72FPG79Accident · 1 fatalClosedBoeing A75N1 · Hazen, ARMay 29, 1972 · N65735 · Destroyed