NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 FTW67A0066Accident · 1 fatalClosedCessna 150F · Anthony, NMDec 29, 1966 · N6693F · DestroyedNTSB DEN67A0038Accident · No injuriesClosedBeech E18S · Albuquerque, NMDec 22, 1966 · N820 · Substantial damageNTSB DEN67D0185Accident · No injuriesClosedCessna 172 · Crown Point, NMDec 20, 1966 · N4102Z · Substantial damageNTSB DEN67F0209Accident · No injuriesClosedCessna 172 · Albuquerque, NMDec 19, 1966 · N5038A · Substantial damageNTSB DEN67A0037Accident · Minor injuriesClosedBell 47G3B1 · Holloman Ab, NMDec 16, 1966 · N1362X · DestroyedNTSB DEN67F0180Accident · No injuriesClosedCessna 310C · Albuquerque, NMDec 12, 1966 · N1737H · Substantial damageNTSB DEN67F0177Accident · No injuriesClosedMooney M20A · Albuquerque, NMDec 9, 1966 · N8320E · Substantial damageNTSB DEN67D0181Accident · No injuriesClosedCessna 320 · Farmington, NMDec 9, 1966 · N3049T · Substantial damageNTSB DEN67A0034Accident · No injuriesClosedBell 47G3B1 · Holloman Ab, NMDec 2, 1966 · N1384X · Substantial damageNTSB DEN67F0162Accident · Serious injuriesClosedCessna 337 · Albuquerque, NMNov 26, 1966 · N3377K · No damageNTSB DEN67F0153Accident · No injuriesClosedCessna 150 · Albuquerque, NMNov 19, 1966 · N7931F · Substantial damageNTSB DEN37D0151Accident · No injuriesClosedCessna 182 · Farmington, NMNov 17, 1966 · N3140F · Substantial damageNTSB DEN67F0168Accident · No injuriesClosedCessna 182A · Las Cruces, NMNov 11, 1966 · N9922B · Substantial damageNTSB DEN67F0146Accident · No injuriesClosedCessna 182B · Raton, NMNov 6, 1966 · N7173E · Substantial damageNTSB DEN67F0143Accident · No injuriesClosedBeech B35 · Albuquerque, NMNov 3, 1966 · N621Z · Substantial damageNTSB DEN67D0161Accident · No injuriesClosedBellanca 14-133 · Portales, NMNov 3, 1966 · N6502N · Substantial damageNTSB DEN67D0160Accident · No injuriesClosedPiper PA-19 · White Sands, NMNov 3, 1966 · N10340 · Substantial damageNTSB DEN67D0144Accident · No injuriesClosedCessna 310 · Las Vegas, NMOct 31, 1966 · N3034D · Substantial damageNTSB DEN67F0123Accident · No injuriesClosedBeech A23 · Albuquerque, NMOct 26, 1966 · N2303W · Substantial damageNTSB DEN67D0124Accident · No injuriesClosedPiper PA-24 · Willard, NMOct 15, 1966 · N8581P · Substantial damageNTSB DEN67D0152Accident · No injuriesClosedMooney M20E · Lordsburg, NMOct 7, 1966 · N2669W · Substantial damageNTSB DEN67D0121Accident · No injuriesClosedPiper PA-24 · Santa Rose, NMOct 7, 1966 · N8651P · Substantial damageNTSB DEN67F0147Accident · No injuriesClosedErcoupe 415-C · Carlsbad, NMOct 5, 1966 · N99702 · Substantial damageNTSB DEN67F0120Accident · No injuriesClosedCessna 150 · Albuquerque, NMOct 3, 1966 · N8228S · Substantial damageNTSB DEN67F0098Accident · No injuriesClosedLark 95 · Deming, NMSep 21, 1966 · N9726C · Substantial damageNTSB DEN67A0024Accident · No injuriesClosedBell 47G3B1 · Alamogordo, NMSep 21, 1966 · N1381X · Substantial damageNTSB DEN67A0022Accident · 4 fatalClosedMooney M20B · Hobbs, NMSep 17, 1966 · N74784 · DestroyedNTSB DEN67F0099Accident · Serious injuriesClosedPiper PA-18 · Albuquerque, NMSep 12, 1966 · N4157Z · Substantial damageNTSB DEN67F0081Accident · No injuriesClosedCessna 172 · Roswell, NMSep 3, 1966 · N4398L · Substantial damageNTSB DEN67D0080Accident · Minor injuriesClosedStinson 108-3 · Whites City, NMSep 1, 1966 · N969C · Substantial damageNTSB DEN67D0115Accident · No injuriesClosedPiper PA-25 · Carlsbad, NMAug 30, 1966 · N6718Z · Substantial damageNTSB DEN67D0142Accident · No injuriesClosedCessna P206A · Santa Rosa, NMAug 29, 1966 · N2693X · Substantial damageNTSB DEN67F0091Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMAug 26, 1966 · N6101P · Substantial damageNTSB DEN67D0088Accident · No injuriesClosedPiper PA-24 · Taos, NMAug 24, 1966 · N7687P · Substantial damageNTSB DEN67F0125Accident · Serious injuriesClosedPiper PA-25 · Deming, NMAug 20, 1966 · N6121Z · DestroyedNTSB DEN67F0066Accident · Minor injuriesClosedCessna T-210F · Albuquerque, NMAug 14, 1966 · N6193R · Substantial damageNTSB DEN67D0039Accident · No injuriesClosedCessna 150 · Espanola, NMAug 13, 1966 · N6798F · Substantial damageNTSB DEN67D0072Accident · No injuriesClosedCessna 150 · Jal, NMAug 5, 1966 · N8208S · Substantial damageNTSB DEN67D0073Accident · No injuriesClosedPiper PA-28 · Raton, NMAug 4, 1966 · N6400W · Substantial damageNTSB DEN67D0089Accident · No injuriesClosedCessna 150 · Las Cruces, NMJul 30, 1966 · N8006F · Substantial damageNTSB DEN67D0045Accident · Minor injuriesClosedCessna 170B · Roswell, NMJul 29, 1966 · N2309D · Substantial damageNTSB DEN67A0011Accident · Serious injuriesClosedDouglas DC-3 · Gallup, NMJul 27, 1966 · N4994E · Substantial damageNTSB DEN66D0046Accident · No injuriesClosedCessna 175 · Santa Fe, NMJul 25, 1966 · N7557M · Substantial damageNTSB DEN67D0047Accident · No injuriesClosedCessna 172 · Quemado, NMJul 23, 1966 · N8182B · DestroyedNTSB DEN67D0065Accident · No injuriesClosedCessna 210B · Milnesand, NMJul 19, 1966 · N9629X · Substantial damageNTSB DEN67D0113Accident · Serious injuriesClosedBeech 35 · Columbus, NMJul 13, 1966 · N3253 · DestroyedNTSB DEN67D0026Accident · No injuriesClosedPiper PA-22 · Santa Rosa, NMJul 13, 1966 · N6067D · Substantial damageNTSB DEN67A0002Accident · 2 fatalClosedPiper PA-18 · Quemado, NMJul 7, 1966 · N3695Z · DestroyedNTSB DEN67D0090Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMJul 4, 1966 · N7574W · Substantial damageNTSB DEN67D0035Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJul 3, 1966 · N8758P · Substantial damage