Skip to content

NTSB investigations, 1964

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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
  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.

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
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB UNK65X1107Accident · No injuriesClosedPiper PA18 · Alzada, MTDec 23, 1964 · N7598K · Substantial damage NTSB UNK65X1106Accident · No injuriesClosedMaule M4 · Rosholt, SDDec 23, 1964 · N4734T · Substantial damage NTSB UNK65X1105Accident · 1 fatalClosedPiper PA-22 · Winona, MNDec 23, 1964 · N3142Z · Destroyed NTSB UNK65X1104Accident · Serious injuriesClosedRyan ST-3KR · Lubbock, TXDec 23, 1964 · N579S · Destroyed NTSB UNK65X1103Accident · No injuriesClosedAero Cmdr 680E · Jacksonville, FLDec 23, 1964 · N58G · Substantial damage NTSB UNK65X1102Accident · No injuriesClosedPiper PA30 · Niagara Falls, NYDec 23, 1964 · N7547Y · Substantial damage NTSB UNK65X1101Accident · No injuriesClosedBeech 35 · Broken Arrow, OKDec 23, 1964 · N2863V · Substantial damage NTSB UNK65X1100Accident · No injuriesClosedBeechcraft B55 · Allentown, PADec 23, 1964 · N6845Q · Substantial damage NTSB UNK65X1099Accident · No injuriesClosedBell 47J2 · Philadelphia, PADec 22, 1964 · N73216 · Substantial damage NTSB UNK65X1098Accident · 1 fatalClosedCessna 175 · Leeds, ALDec 22, 1964 · N7086M · Substantial damage NTSB UNK65X1097Accident · Minor injuriesClosedHughes 269A · Cortada, PRDec 22, 1964 · N9383F · Substantial damage NTSB UNK65X1096Accident · Minor injuriesClosedAeronca 11BC · Ft Francis, CanadaDec 22, 1964 · N86236 · Substantial damage NTSB UNK65X1095Incident · No injuriesClosedDouglas DC-8 · New York, NYDec 22, 1964 · N810PA · No damage NTSB UNK65X1094Accident · No injuriesClosedMooney M21 · Grinnell, IADec 22, 1964 · N6679U · Substantial damage NTSB UNK65X1093Accident · 3 fatalClosedBeechcraft 95-B55 · Good Thunder, MNDec 22, 1964 · N8849M · Destroyed NTSB UNK65X1092Accident · No injuriesClosedCessna 185 · Seldovia, AKDec 22, 1964 · N9918X · Substantial damage NTSB UNK65X1091Accident · No injuriesClosedPiper PA-22 · Palm Springs, CADec 22, 1964 · N2678A · Destroyed NTSB UNK65X1090Accident · No injuriesClosedHoward DGA-15 · West Chicago, ILDec 22, 1964 · N75599 · Substantial damage NTSB UNK65X1089Accident · No injuriesClosedBeechraft D95 · Groveland, ILDec 22, 1964 · N8613M · Substantial damage NTSB UNK65X1088Accident · No injuriesClosedChampion 7FC · Sparks, NVDec 22, 1964 · N7597B · Substantial damage NTSB UNK65X1087Accident · No injuriesClosedBeechraft 35B33 · Gregory, SDDec 22, 1964 · N1548Z · Substantial damage NTSB UNK65X1086Accident · No injuriesClosedPiper PA28 · Addison, TXDec 22, 1964 · N6323W · Substantial damage NTSB UNK65X1085Accident · No injuriesClosedPiper PA22 · Andrews, TXDec 22, 1964 · N8764D · Destroyed NTSB UNK65X1084Accident · 2 fatalClosedStinson 108 · Salem, ORDec 21, 1964 · N97562 · Destroyed NTSB UNK65X1083Accident · No injuriesClosedCessna 120 · Yerington, NVDec 21, 1964 · N3036N · Substantial damage NTSB UNK65X1082Incident · No injuriesClosedBoeing 707 351C · Travis Afb, CADec 21, 1964 · N356U · Minor damage NTSB UNK65X1081Accident · No injuriesClosedPiper PA30 · Chicago, ILDec 21, 1964 · N7495Y · Substantial damage NTSB UNK65X1080Accident · No injuriesClosedCessna 310 · Young, AZDec 21, 1964 · N5282A · Substantial damage NTSB UNK65X1079Accident · No injuriesClosedCessna 337 · Wichita, KSDec 21, 1964 · N2119X · Substantial damage NTSB UNK65X1078Accident · No injuriesClosedBeechraft M35 · Van Nuys, CADec 21, 1964 · N9775R · Substantial damage NTSB UNK65X1077Accident · No injuriesClosedHughes 269A · Columbus, NEDec 20, 1964 · N8704F · Substantial damage NTSB UNK65X1076Accident · No injuriesClosedBell 47H1 · Washington, DCDec 20, 1964 · N2475B · Substantial damage NTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXDec 20, 1964 · N5966E · Destroyed NTSB UNK65X1074Accident · No injuriesClosedCessna 140 · Bonner Springs, KSDec 20, 1964 · N89799 · Substantial damage NTSB UNK65X1073Accident · No injuriesClosedPiper PA28 · Elmore City, OKDec 20, 1964 · N5767W · Substantial damage NTSB UNK65X1072Accident · No injuriesClosedPiper PA22 · St Cloud, MNDec 20, 1964 · N8814C · Substantial damage NTSB UNK65X1071Accident · No injuriesClosedPiper J3C · Salisbury, VTDec 20, 1964 · N70925 · Substantial damage NTSB UNK65X1070Accident · No injuriesClosedAeronca 11AC · Gerogetown, MNDec 20, 1964 · N85906 · Substantial damage NTSB UNK65X1069Accident · No injuriesClosedCessna 172E · Miami, FLDec 20, 1964 · N3920S · Substantial damage NTSB UNK65X1068Accident · No injuriesClosedPiper PA28 · Chicago, ILDec 20, 1964 · N7677W · Substantial damage NTSB UNK65X1067Accident · No injuriesClosedPiper PA28 · Moab, UTDec 20, 1964 · N7761W · Substantial damage NTSB UNK65X1066Accident · No injuriesClosedCessna 170B · Blairstown, NJDec 20, 1964 · N4524C · Substantial damage NTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILDec 19, 1964 · N72353 · Destroyed NTSB UNK65X1064Accident · 2 fatalClosedPiper PA-24 · Huntington Lk, CADec 19, 1964 · N5552P · Destroyed NTSB UNK65X1063Accident · No injuriesClosedPiper PA24 · Santa Monica, CADec 19, 1964 · N6633P · Substantial damage NTSB UNK65X1062Accident · No injuriesClosedPiper PA28 · Lisbon, INDec 19, 1964 · N5788W · Substantial damage NTSB UNK65X1061Accident · No injuriesClosedPiper PA24 · Bunnell, FLDec 19, 1964 · N6407P · Substantial damage NTSB UNK65X1060Accident · 1 fatalClosedCessna 175 · Cloverdale, CADec 19, 1964 · N7226M · Destroyed NTSB UNK65X1059Accident · 1 fatalClosedPiper PA-24 · Ogden, UTDec 19, 1964 · N5875P · Destroyed NTSB UNK65X1058Accident · Serious injuriesClosedPiper PA24 · Indianapolis, INDec 19, 1964 · N8451P · No damage