NTSB investigations, 1976, NM

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1976, 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\") = 1976
    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 DEN77FA016Accident · 3 fatalClosedCessna 182P · Santa Rosa, NMDec 31, 1976 · N8338M · DestroyedNTSB DEN77FQA08Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMDec 26, 1976 · N7585R · Substantial damageNTSB DEN77FA014Accident · 2 fatalClosedBellanca 7GCBC · Clovis, NMDec 26, 1976 · N86942 · DestroyedNTSB DEN77FQA07Accident · No injuriesClosedBellanca 17-30A · Albuquerque, NMDec 18, 1976 · N8797V · Substantial damageNTSB DEN77FQA09Accident · No injuriesClosedGrum Amer AA5 · Ft.Sumner, NMDec 6, 1976 · N7100L · Substantial damageNTSB DEN77DQA06Accident · No injuriesClosedThorp T18 · Santa Fe, NMDec 1, 1976 · N7LN · Substantial damageNTSB DEN77FA012Accident · 2 fatalClosedPiper PA-28 · Farmington, NMNov 26, 1976 · N4208F · DestroyedNTSB DEN77DQA05Accident · No injuriesClosedCessna 182 · Farmington, NMNov 21, 1976 · N5581B · Substantial damageNTSB DEN77FA010Accident · 2 fatalClosedBellanca 17-30A · Taos, NMNov 19, 1976 · N4027B · DestroyedNTSB DEN77FA009Accident · No injuriesClosedN. American 265-60 · Albuquerque, NMNov 12, 1976 · N180AR · Substantial damageNTSB DEN77FQA04Accident · Minor injuriesClosedCessna TU206F · Albuquerque, NMNov 11, 1976 · N9678G · Substantial damageNTSB DEN77FA002Accident · 2 fatalClosedCessna 150 · Texico, NMOct 19, 1976 · N66113 · DestroyedNTSB DEN77DQA03Accident · No injuriesClosedBell 206B · Aztec, NMOct 17, 1976 · N9914K · Substantial damageNTSB DEN77FQA01Accident · No injuriesClosedCessna 150 · Valencia, NMOct 5, 1976 · N3643J · Substantial damageNTSB DEN76FQA64Accident · Minor injuriesClosedStinson 108-3 · Albuquerque, NMSep 25, 1976 · N6577M · Substantial damageNTSB DEN76AD072Accident · 2 fatalClosedPiper PA-31 · Pinon, NMSep 19, 1976 · N54294 · DestroyedNTSB DEN76AD071Accident · 2 fatalClosedPiper PA-28 · Scholle, NMSep 10, 1976 · N8981W · DestroyedNTSB DEN76DQD34Accident · Minor injuriesClosedCessna 188A · Hatch, NMSep 9, 1976 · N5643J · Substantial damageNTSB DEN76FQA63Accident · No injuriesClosedCessna T210G · Eagle Nest, NMSep 3, 1976 · N1128D · Substantial damageNTSB DEN76DQD33Accident · No injuriesClosedBoeing E75N1 · Animas, NMAug 22, 1976 · N58712 · Substantial damageNTSB DEN76FQA62Accident · No injuriesClosedCessna 310I · Farmington, NMAug 20, 1976 · N8071M · Substantial damageNTSB DEN76FQA61Accident · No injuriesClosedBeech 23 · Albuquerque, NMAug 16, 1976 · N9150S · Substantial damageNTSB DEN76AD065Accident · 2 fatalClosedPiper PA-28R · Melrose, NMAug 15, 1976 · N8776C · DestroyedNTSB DEN76DQA57Accident · No injuriesClosedHughes 269A-1 · Milagro, NMAug 14, 1976 · N8942F · Substantial damageNTSB DEN76FQD32Accident · No injuriesClosedBell 47G3B1 · Mesquite, NMAug 10, 1976 · N729AP · DestroyedNTSB DEN76FQA59Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMAug 7, 1976 · N8031L · Substantial damageNTSB DEN76DQD31Accident · No injuriesClosedCessna 15OJ · Silver City, NMAug 1, 1976 · N50651 · DestroyedNTSB DEN76FQA56Accident · Minor injuriesClosedCessna 150 · Tucumcari, NMJul 22, 1976 · N18155 · Substantial damageNTSB DEN76FQA55Accident · No injuriesClosedBeech 58P · Albuquerque, NMJul 20, 1976 · N7240R · Substantial damageNTSB DEN76DQA40Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJul 19, 1976 · N8901P · Substantial damageNTSB DEN76FQG06Accident · 1 fatalClosedEL Gringo 1 · Hobbs, NMJul 17, 1976 · N125CB · DestroyedNTSB DEN76FQA54Accident · No injuriesClosedPiper PA-23 · Ruidoso, NMJul 8, 1976 · N13986 · Substantial damageNTSB DEN76FQA53Accident · No injuriesClosedMooney M20C · Albuquerque, NMJul 7, 1976 · N6466U · Substantial damageNTSB DEN76DQG05Accident · Serious injuriesClosedPiper PA-25 · Lovington, NMJul 7, 1976 · N9889P · DestroyedNTSB DEN76FQA52Accident · No injuriesClosedCessna 177 · Albuquerque, NMJul 2, 1976 · N3147T · Substantial damageNTSB DEN76DQA51Accident · Minor injuriesClosedMeyers 200 · Tucumcari, NMJun 24, 1976 · N197M · Substantial damageNTSB DEN76FQD26Accident · No injuriesClosedTwin Engine D-16 · Las Cruces, NMJun 17, 1976 · N8624H · Substantial damageNTSB DEN76FQA50Accident · No injuriesClosedCessna 182K · Taos, NMJun 11, 1976 · N2445Q · Substantial damageNTSB DEN76FQA49Accident · No injuriesClosedCessna U206 · Farmington, NMJun 5, 1976 · N1356V · Substantial damageNTSB DEN76FQA48Accident · No injuriesClosedCessna 180 · Farmington, NMJun 5, 1976 · N3228D · Substantial damageNTSB DEN76FQA47Accident · No injuriesClosedPiper PA-24 · Los Lunas, NMMay 29, 1976 · N6178P · Substantial damageNTSB DEN76FQA46Accident · No injuriesClosedCessna T210 · Los Alamos, NMMay 26, 1976 · N6851R · Substantial damageNTSB DEN76FQG04Accident · Serious injuriesClosedPiper PA-28 · Hobbs, NMMay 25, 1976 · N4523X · DestroyedNTSB DEN76AD050Accident · 1 fatalClosedPiper PA-18 · Buckhorn, NMMay 14, 1976 · N3390Z · DestroyedNTSB DEN76DQD24Accident · No injuriesClosedCamair 480 · Lordsburg, NMMay 7, 1976 · N239 · Substantial damageNTSB DEN76DQA44Accident · No injuriesClosedRaven S-55A · Albuquerque, NMApr 25, 1976 · N54708 · Substantial damageNTSB DEN76FQA43Accident · Serious injuriesClosedPiper PA-32 · Albuquerque, NMApr 23, 1976 · N56801 · Substantial damageNTSB DEN76DQD21Accident · No injuriesClosedCessna 150 · Silver City, NMApr 23, 1976 · N9304U · Substantial damageNTSB DEN76FQA41Accident · Serious injuriesClosedCessna 172 · Albuquerque, NMApr 19, 1976 · N6741A · Substantial damageNTSB DEN76DQA42Accident · No injuriesClosedStarduster SA-300 · Socorro, NMApr 17, 1976 · N12SD · Substantial damage