NTSB investigations, 1964, 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, 1964, 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\") = 1964
    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 UNK65X1148Accident · No injuriesClosedCessna 172 · Grants, NMDec 26, 1964 · N5156A · Substantial damageNTSB UNK65X1041Accident · No injuriesClosedBeechraft S35 · Chama, NMDec 18, 1964 · N8888G · Substantial damageNTSB UNK65X0946Accident · No injuriesClosedPiper PA18 · Parkview, NMDec 7, 1964 · N6999V · Substantial damageNTSB UNK65X0591Accident · No injuriesClosedPiper PA24 · Corona, NMNov 7, 1964 · N5985P · Substantial damageNTSB UNK65X0448Accident · No injuriesClosedBeechcraft 35 · Sunland Par, NMOct 27, 1964 · N3051V · DestroyedNTSB UNK65X0439Accident · Serious injuriesClosedPiper PA-24 · Albuquerque, NMOct 25, 1964 · N5139P · Substantial damageNTSB UNK65X0406Accident · No injuriesClosedNavion A · Las Cruces, NMOct 24, 1964 · N7980A · DestroyedNTSB UNK65X0389Accident · No injuriesClosedMorrow II · Hobbs, NMOct 23, 1964 · N75281 · Substantial damageNTSB UNK65X0342Accident · No injuriesClosedMooney M20C · Cebolla, NMOct 20, 1964 · N6437U · DestroyedNTSB UNK65X0263Accident · No injuriesClosedMooney M20D · Socorro, NMOct 13, 1964 · N6830U · Substantial damageNTSB UNK65X0210Accident · No injuriesClosedCessna 182 · Albuquerque, NMOct 9, 1964 · N9922B · Substantial damageNTSB UNK65X0198Accident · No injuriesClosedPiper PA18A · Socorro, NMOct 8, 1964 · N9271D · Substantial damageNTSB UNK65X0158Incident · No injuriesClosedConvair 240 · Roswell, NMOct 6, 1964 · N94240 · No damageNTSB UNK65X0129Accident · No injuriesClosedPiper PA24 · Columbus, NMOct 3, 1964 · N5243P · Substantial damageNTSB UNK64X4194Accident · No injuriesClosedBeechcraft A35 · Albuquerque, NMSep 28, 1964 · N8639A · Substantial damageNTSB UNK64X4174Accident · No injuriesClosedPiper PA22 · Alameda, NMSep 27, 1964 · N9994D · Substantial damageNTSB UNK64X4098Accident · No injuriesClosedNavion · Silver City, NMSep 22, 1964 · N8705H · Substantial damageNTSB UNK64X3991Accident · No injuriesClosedCessna 310D · Farmington, NMSep 14, 1964 · N6759T · Minor damageNTSB UNK64X3989Accident · No injuriesClosedMooney MK21 · Farmington, NMSep 14, 1964 · N6203U · Substantial damageNTSB UNK64X3979Accident · No injuriesClosedConvair CV-440 · Farmington, NMSep 14, 1964 · N73126 · Substantial damageNTSB UNK64X3814Accident · No injuriesClosedBeechcraft A23 · Springer, NMSep 6, 1964 · N8777M · Substantial damageNTSB UNK64X3799Accident · Minor injuriesClosedPiper PA28 · Coyote, NMSep 5, 1964 · N8636W · Substantial damageNTSB UNK64X3658Accident · No injuriesClosedLuscombe 8F · Albuquerque, NMAug 29, 1964 · N1373B · Substantial damageNTSB UNK64X3657Accident · No injuriesClosedCessna 195 · White Sands, NMAug 29, 1964 · N7607C · Substantial damageNTSB UNK64X3544Accident · No injuriesClosedSchweizer 123H · Jal, NMAug 22, 1964 · N10382 · Substantial damageNTSB UNK64X3506Accident · No injuriesClosedPiper PA24 · Socorro, NMAug 21, 1964 · N6160P · Substantial damageNTSB UNK64X3505Accident · No injuriesClosedErcoupe 415C · Alamogordo, NMAug 21, 1964 · N93517 · Substantial damageNTSB UNK64X3459Accident · Minor injuriesClosedPiper PA12 · Grants, NMAug 18, 1964 · N2795M · Substantial damageNTSB UNK64X3425Accident · No injuriesClosedCessna 140 · Farmington, NMAug 16, 1964 · N2787N · DestroyedNTSB UNK64X3340Accident · No injuriesClosedMooney MK20A · Santa Rosa, NMAug 12, 1964 · N1080C · Substantial damageNTSB UNK64X3254Accident · No injuriesClosedPiper PA22 · Alameda, NMAug 7, 1964 · N8034D · Substantial damageNTSB UNK64X3115Accident · No injuriesClosedCessna 182 · Gallup, NMJul 30, 1964 · N6478A · Substantial damageNTSB UNK64X3043Accident · Minor injuriesClosedPiper PA23 · Albuquerque, NMJul 25, 1964 · N5268Y · Substantial damageNTSB UNK64X3017Accident · No injuriesClosedCessna 180 · Albuquerque, NMJul 25, 1964 · N4909A · Substantial damageNTSB UNK64X2993Accident · No injuriesClosedCessna 182 · Gallup, NMJul 23, 1964 · N5871B · Substantial damageNTSB UNK64X2984IncidentClosedDouglas DC3 · Gallup, NMJul 23, 1964 · N64910 · Substantial damageNTSB UNK64X2944Accident · No injuriesClosedPiper PA25 · Gallup, NMJul 20, 1964 · N7134Z · Substantial damageNTSB UNK64X2885Accident · No injuriesClosedBell 47G3B · Reserve, NMJul 17, 1964 · N73246 · Substantial damageNTSB UNK64X2869Accident · 4 fatalClosedBeechcraft G18S · Toadlena, NMJul 16, 1964 · N9423Y · DestroyedNTSB UNK64X2805Accident · Minor injuriesClosedBeechcraft 23 · Springer, NMJul 13, 1964 · N2395Z · DestroyedNTSB UNK64X2784Accident · 4 fatalClosedPiper PA24 · Tijeras, NMJul 12, 1964 · N8339P · DestroyedNTSB UNK64X2734Accident · No injuriesClosedBeechcraft B55 · Albuquerque, NMJul 9, 1964 · N2260 · Substantial damageNTSB UNK64X2723Accident · No injuriesClosedBellanca 14192 · Farmington, NMJul 9, 1964 · N7678B · Substantial damageNTSB UNK64X2718Accident · No injuriesClosedMooney MK20B · Las Cruces, NMJul 8, 1964 · N74546 · Substantial damageNTSB UNK64X2674Accident · Serious injuriesClosedCessna 195 · Clines Corners, NMJul 5, 1964 · N3467V · DestroyedNTSB UNK64X2658Accident · No injuriesClosedPiper PA28 · Rosweell, NMJul 5, 1964 · N7486W · Substantial damageNTSB UNK64X2578Accident · No injuriesClosedCessna 170B · Albuquerque, NMJun 30, 1964 · N3444D · Substantial damageNTSB UNK64X2563Accident · Serious injuriesClosedCessna 150 · Cloudcroft, NMJun 29, 1964 · N4227U · DestroyedNTSB UNK64X2528Accident · Serious injuriesClosedPiper PA22 · Cowles, NMJun 27, 1964 · N6179D · DestroyedNTSB UNK64X2496Accident · No injuriesClosedBeechcraft D35 · Las Cruces, NMJun 26, 1964 · N2710V · Substantial damage