NTSB investigations, 1974, NM

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1974, NM per year, 1964–2026: 2,946 cases
196482
196588
196699
1967113
196899
196985
197086
197179
197269
197373
197474
197585
197664
197789
197898
197994
198068
198178
198272
198346
198456
198563
198641
198744
198848
198936
199033
199134
199226
199328
199427
199541
199641
199742
199843
199939
200042
200136
200233
200336
200429
200521
200626
200736
200831
200927
201027
201123
201219
201323
201428
201525
201618
201724
201827
201920
20208
202117
202216
202315
202424
202516
202616

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\") = 1974
    AND c.\"eventStateOrRegion\" = 'NM' 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 DEN75DQA25Accident · No injuriesClosedPiper PA-22 · Ruidoso, NMDec 21, 1974 · N8201C · Substantial damageNTSB DEN75AD033Accident · 3 fatalClosedMooney M20F · Watrous, NMDec 19, 1974 · N3890N · DestroyedNTSB DEN75FQA24Accident · Serious injuriesClosedBell 47G3B2 · Albuquerque, NMDec 17, 1974 · N4730R · Substantial damageNTSB DEN75FQA22Accident · No injuriesClosedAmer Avco AA-1A · Albuquerque, NMDec 17, 1974 · N9383L · Substantial damageNTSB DEN75FQA23Accident · No injuriesClosedBellanca 8GCBC · San Mateo, NMDec 2, 1974 · N88154 · Substantial damageNTSB DEN75FQA21Accident · Serious injuriesClosedCessna 180 · San Mateo, NMDec 1, 1974 · N3697C · DestroyedNTSB DEN75FQA20Accident · Serious injuriesClosedTaylorcraft DCO-65 · Raton, NMNov 10, 1974 · N49040 · Substantial damageNTSB DEN75FQA19Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNov 7, 1974 · N8107N · Substantial damageNTSB DEN75DQA18Accident · No injuriesClosedPiper PA-24 · Arrey, NMOct 27, 1974 · N9236P · Substantial damageNTSB FTW75DQG27Accident · No injuriesClosedCessna 150 · Texico, NMOct 23, 1974 · N1586Q · Substantial damageNTSB DEN75DQG05Accident · No injuriesClosedChampion 7GC · Field, NMOct 19, 1974 · N8517E · DestroyedNTSB DEN75DQA16Accident · No injuriesClosedCessna 182 · Albuquerque, NMSep 30, 1974 · N19107 · Substantial damageNTSB DEN75AQA15Accident · 1 fatalClosedPiper PA-28 · Farmington, NMSep 30, 1974 · N5280T · Substantial damageNTSB DEN75AD014Accident · 1 fatalClosedPiper PA-18 · Corona, NMSep 16, 1974 · N1585P · DestroyedNTSB DEN75DQA14Accident · Serious injuriesClosedBoeing E75N1 · Gallup, NMSep 10, 1974 · N5476N · Substantial damageNTSB DEN75FQA17Accident · No injuriesClosedMooney M20C · Zuni, NMSep 2, 1974 · N6445U · Substantial damageNTSB DEN75DQA13Accident · No injuriesClosedSchweizer SGS232 · Albuquerque, NMSep 1, 1974 · N5826V · Substantial damageNTSB DEN75AD005Accident · 2 fatalClosedCessna 170A · Bernardo, NMAug 25, 1974 · N5423C · DestroyedNTSB DEN75FQA12Accident · No injuriesClosedCessna 170B · Albuquerque, NMAug 21, 1974 · N2546C · Substantial damageNTSB DEN75DQA11Accident · No injuriesClosedBell 212 · Red Hill, NMAug 20, 1974 · N83033 · Substantial damageNTSB DEN75FQD09Accident · No injuriesClosedBoeing A75N1 · Las Cruces, NMAug 15, 1974 · N55987 · DestroyedNTSB DEN75FQD08Accident · Serious injuriesClosedCessna 150 · Condran Aaf, NMAug 14, 1974 · N22280 · Substantial damageNTSB DEN75DQA07Accident · No injuriesClosedLuscombe 8E · San Felipe, NMAug 3, 1974 · N2568K · Substantial damageNTSB DEN75DQA10Accident · Minor injuriesClosedCessna 206 · La Vida Msn, NMJul 31, 1974 · N4862F · Substantial damageNTSB DEN75FQD06Accident · No injuriesClosedBell 47G3B2 · Mesquite, NMJul 29, 1974 · N4730R · Substantial damageNTSB DEN75DQD05Accident · No injuriesClosedPiper PA-24 · Silver City, NMJul 29, 1974 · N9005P · Substantial damageNTSB DEN75FQA09Accident · Minor injuriesClosedNavion A · Aztec, NMJul 24, 1974 · N4951K · Substantial damageNTSB DEN75FQA06Accident · Serious injuriesClosedPiper PA-28 · Lybrook, NMJul 20, 1974 · N8313R · Substantial damageNTSB DEN75AQA05Accident · No injuriesClosedCessna 210A · Santa Fe, NMJul 14, 1974 · N6644X · Substantial damageNTSB DEN75FQA04Accident · No injuriesClosedBeech D55 · Bernalillo, NMJul 12, 1974 · N73681 · Substantial damageNTSB DEN75AQA02Accident · Minor injuriesClosedCessna 172G · Wagon Mound, NMJul 8, 1974 · N3735L · Substantial damageNTSB DEN75DQA03Accident · No injuriesClosedSchweizer SGS123 · Moriarty, NMJul 6, 1974 · N91880 · Substantial damageNTSB DEN75FQA08Accident · No injuriesClosedPiper PA-11 · Los Lunas, NMJul 3, 1974 · N4516M · Substantial damageNTSB DEN75FQA01Accident · No injuriesClosedCessna 150 · Albuquerque, NMJul 2, 1974 · N19150 · No damageNTSB DEN75DQD01Accident · Minor injuriesClosedPiper PA-28 · Columbus, NMJul 2, 1974 · N9894W · Substantial damageNTSB DEN75FQA52Accident · No injuriesClosedCessna 172 · Albuquerque, NMJun 26, 1974 · N19756 · Substantial damageNTSB DEN74DQD28Accident · No injuriesClosedErco 415-C · Animas, NMJun 23, 1974 · N99378 · Substantial damageNTSB DEN74DQA49Accident · No injuriesClosedBeech D18S · Raton, NMJun 23, 1974 · N215PB · Substantial damageNTSB DEN74FQA51Accident · No injuriesClosedPiper PA-28 · Jmez Pueblo, NMJun 18, 1974 · N5025T · Substantial damageNTSB LAX74AL081Accident · Minor injuriesClosedHughes 369HS · Luna, NMJun 14, 1974 · N9134F · DestroyedNTSB DEN74DQD26Accident · No injuriesClosedCessna 170B · Las Cruces, NMJun 9, 1974 · N43F · Substantial damageNTSB DEN74FQA48Accident · No injuriesClosedNavion A · Cerrillos, NMJun 1, 1974 · N91169 · Substantial damageNTSB DEN74FQA47Accident · No injuriesClosedCessna 182B · Farmington, NMMay 29, 1974 · N2308G · Substantial damageNTSB DEN74DQD25Accident · Minor injuriesClosedCessna 150L · Alamogordo, NMMay 29, 1974 · N1511Q · DestroyedNTSB DEN74FQA46Accident · No injuriesClosedCessna 150 · Albuquerque, NMMay 19, 1974 · N7904F · Substantial damageNTSB DEN74FQA45Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMMay 17, 1974 · N5180Y · Substantial damageNTSB DEN74FQA43Accident · 1 fatalClosedBensen B-8M · Cerrillos, NMMay 11, 1974 · N24836 · DestroyedNTSB DEN74FQD21Accident · No injuriesClosedCessna 182K · Ruidoso, NMMay 4, 1974 · N2504R · Substantial damageNTSB DEN74FQA44Accident · No injuriesClosedBeech A24R · Socorro, NMMay 4, 1974 · N6599R · DestroyedNTSB DEN74FQD19Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMApr 30, 1974 · N15905 · Substantial damage