NTSB investigations, 1965, NM

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1965, 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\") = 1965
    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 DEN66D0184Accident · No injuriesClosedPiper PA-18 · Ruidoso, NMDec 28, 1965 · N3837Z · Substantial damageNTSB DEN66A0049Accident · Minor injuriesClosedHiller UH12L4 · Albuquerque, NMDec 18, 1965 · N9780C · DestroyedNTSB DEN66A0047Accident · 2 fatalClosedPiper PA-24 · Cuba, NMDec 11, 1965 · N6961P · DestroyedNTSB DEN66A0041Accident · No injuriesClosedHiller UH12L4 · Albuquerque, NMDec 6, 1965 · N9780C · Substantial damageNTSB DEN66F0176Accident · No injuriesClosedPitts Spcl S1C · Sunland Pk, NMDec 5, 1965 · N8L · Substantial damageNTSB DEN66F0168Accident · No injuriesClosedBeechcraft 35 · Albuquerque, NMDec 4, 1965 · N7268B · Substantial damageNTSB DEN66F0170Accident · No injuriesClosedBeechcraft K35 · Moriarity, NMNov 30, 1965 · N9517R · Substantial damageNTSB DEN66A0035Accident · 1 fatalClosedPiper PA-24 · Santa Fe, NMNov 22, 1965 · N5542P · DestroyedNTSB DEN66A0034Accident · 3 fatalClosedCessna 182E · Santa Fe, NMNov 20, 1965 · N3081Y · DestroyedNTSB DEN66F0160Accident · No injuriesClosedAero Cmdr 680-FL · Albuquerque, NMNov 17, 1965 · N770HB · Substantial damageNTSB DEN66F0171Accident · No injuriesClosedPiper PA-24 · Las Cruces, NMNov 16, 1965 · N6263P · Substantial damageNTSB DEN66D0151Accident · No injuriesClosedBeechcraft E-185 · Taos, NMNov 15, 1965 · N141Z · Substantial damageNTSB DEN66F0159Accident · No injuriesClosedAlon A2 · Sunland Pk, NMNov 14, 1965 · N6372V · Substantial damageNTSB DEN66A0032Accident · 1 fatalClosedCessna 310B · Glenwood, NMNov 11, 1965 · N6654B · DestroyedNTSB DEN66D0152Accident · No injuriesClosedCessna 150 · Carlsbad, NMNov 6, 1965 · N8931S · Substantial damageNTSB FTW66D0390Accident · No injuriesClosedCessna 182 · Portales, NMNov 4, 1965 · N8841T · Substantial damageNTSB DEN66D0139Accident · No injuriesClosedCessna 150 · Roswell, NMNov 3, 1965 · N7749E · Substantial damageNTSB DEN66D0138Accident · No injuriesClosedCessna 337 · Albuquerque, NMOct 29, 1965 · N6231F · Substantial damageNTSB DEN66D0144Accident · No injuriesClosedCessna 170 · Carlsbad, NMOct 24, 1965 · N4222V · Substantial damageNTSB DEN66F0163Accident · Serious injuriesClosedCessna 150F · Zuni, NMOct 18, 1965 · N8859S · DestroyedNTSB DEN66F0129Accident · No injuriesClosedPiper PA-23 · Albuquerque, NMOct 16, 1965 · N3163P · Substantial damageNTSB DEN66D0136Accident · Minor injuriesClosedCessna 150 · El Rito, NMOct 16, 1965 · N8877S · DestroyedNTSB DEN66D0121Accident · No injuriesClosedCessna 150 · Albuquerque, NMOct 16, 1965 · N4376U · Substantial damageNTSB DEN66F0130Accident · No injuriesClosedMooney M20A · Grants, NMOct 10, 1965 · N1078C · Substantial damageNTSB DEN66F0111Accident · Serious injuriesClosedCessna 320D · Albuquerque, NMOct 4, 1965 · N4104T · Substantial damageNTSB FTW66F0336Accident · No injuriesClosedNavion A · Clovis, NMOct 3, 1965 · N91165 · Substantial damageNTSB DEN66D0153Accident · No injuriesClosedPiper PA-30 · Farmington, NMOct 1, 1965 · N7007Y · Substantial damageNTSB DEN66F0123Accident · No injuriesClosedCessna 175 · Albuquerque, NMSep 30, 1965 · N7062M · Substantial damageNTSB DEN66F0115Accident · No injuriesClosedPiper PA-16 · Carlsbad, NMSep 26, 1965 · N5655H · Substantial damageNTSB DEN66F0104Accident · Minor injuriesClosedTemco D16A · Las Vegas, NMSep 21, 1965 · N715T · Substantial damageNTSB DEN66D0093Accident · No injuriesClosedCessna 180 · Belen, NMSep 5, 1965 · N3861C · Substantial damageNTSB DEN66F0103Accident · Serious injuriesClosedPiper PA-22 · Grants, NMSep 3, 1965 · N4802A · DestroyedNTSB DEN66D0097Accident · No injuriesClosedCessna 170B · Las Cruces, NMAug 29, 1965 · N2307D · Substantial damageNTSB DEN66D0102Accident · No injuriesClosedBeechcraft 95 · Albuquerque, NMAug 24, 1965 · N659T · Substantial damageNTSB DEN66D0087Accident · No injuriesClosedAeronca L-16 · Grants, NMAug 14, 1965 · N75064 · Substantial damageNTSB DEN66A0009Accident · 3 fatalClosedPiper PA-24 · Ruidoso, NMAug 13, 1965 · N7960P · DestroyedNTSB DEN66D0069Accident · Minor injuriesClosedLuscombe 8E · Grants, NMAug 5, 1965 · N71113 · Substantial damageNTSB DEN66D0077Accident · No injuriesClosedPiper PA-28 · Portales, NMAug 4, 1965 · N5678W · Substantial damageNTSB DEN66D0068Accident · No injuriesClosedPiper PA-22 · Shiprock, NMAug 3, 1965 · N3233B · Substantial damageNTSB DEN66D0067Accident · No injuriesClosedBeechcraft 23 · Albuquerque, NMJul 24, 1965 · N2336Z · Substantial damageNTSB DEN66D0051Accident · No injuriesClosedCessna 182 · Roy, NMJul 23, 1965 · N4850D · Substantial damageNTSB DEN66D0049Accident · No injuriesClosedPiper PA-24 · Lucy, NMJul 23, 1965 · N8004P · Substantial damageNTSB DEN66F0029Accident · No injuriesClosedBellanca 14-19 · Albuquerque, NMJul 19, 1965 · N9839B · Substantial damageNTSB DEN66F0041Accident · No injuriesClosedPiper PA-24 · Artesia, NMJul 18, 1965 · N5086P · Substantial damageNTSB DEN66F0040Accident · No injuriesClosedCessna 182 · Albuquerque, NMJul 17, 1965 · N3159Y · Substantial damageNTSB DEN66F0027Accident · Minor injuriesClosedErcoupe 415C · Socorro, NMJul 10, 1965 · N99645 · DestroyedNTSB DEN66D0086Accident · No injuriesClosedPiper PA-22 · Albuquerque, NMJul 6, 1965 · N7546D · Substantial damageNTSB DEN66D0050Accident · No injuriesClosedPiper PA-22 · Lavida Miss, NMJul 4, 1965 · N8718D · Substantial damageNTSB DEN66D0066Accident · No injuriesClosedCessna 190 · Gallup, NMJul 1, 1965 · N4451C · Substantial damageNTSB DEN65A0089Accident · No injuriesClosedGrumman TBM · Silver City, NMJun 30, 1965 · N7219C · Substantial damage