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 UNK65X1057Accident · Serious injuriesClosedCessna 182 · Las Vegas, NVDec 19, 1964 · N8588T · Destroyed NTSB UNK65X1056Accident · No injuriesClosedCessna 150 · San Carlos, CADec 19, 1964 · N5973E · 2 aircraft · Substantial damage NTSB UNK65X1055Accident · Minor injuriesClosedCessna 172 · St Nazianz, WIDec 19, 1964 · N4271F · Substantial damage NTSB UNK65X1054Accident · No injuriesClosedAeronca 7GCM · Cloquet, MNDec 19, 1964 · N82067 · Substantial damage NTSB UNK65X1053Accident · No injuriesClosedPiper PA22 · Marshfield, WIDec 19, 1964 · N940A · Substantial damage NTSB UNK65X1052Accident · No injuriesClosedTaylorcraft BC12D · Brewer, MEDec 19, 1964 · N44336 · Substantial damage NTSB UNK65X1051Accident · No injuriesClosedBeechraft C45H · Harbor Sprgs, MIDec 19, 1964 · N431P · Substantial damage NTSB UNK65X1050Accident · No injuriesClosedCessna 172 · Mesquite, NVDec 19, 1964 · N5503T · Substantial damage NTSB UNK65X1049Accident · No injuriesClosedPiper PA24 · Midland, TXDec 19, 1964 · N8289P · Substantial damage NTSB UNK65X1048Accident · No injuriesClosedBeechcraft 35-33 · Mansfield, LADec 19, 1964 · N939T · Destroyed NTSB UNK65X1047Accident · 2 fatalClosedBeechcraft C-50 · Altadena, CADec 18, 1964 · N4931B · Destroyed NTSB UNK65X1046Accident · No injuriesClosedBeechraft C45H · Boerne, TXDec 18, 1964 · N413TB · Substantial damage NTSB UNK65X1045Accident · Minor injuriesClosedBrantly B2B · Hawthorn, PADec 18, 1964 · N2264U · Substantial damage NTSB UNK65X1044Accident · No injuriesClosedHughes 269A · Broomfield, CODec 18, 1964 · N8891F · Substantial damage NTSB UNK65X1043Accident · No injuriesClosedHughes 269B · Davis, CADec 18, 1964 · N9374F · Substantial damage NTSB UNK65X1042Accident · No injuriesClosedPiper PA24 · Savannah, GADec 18, 1964 · N7781P · Substantial damage NTSB UNK65X1041Accident · No injuriesClosedBeechraft S35 · Chama, NMDec 18, 1964 · N8888G · Substantial damage NTSB UNK65X1040Accident · No injuriesClosedTaylorcraft BC12D · Charlotte, MIDec 18, 1964 · N5066M · Substantial damage NTSB UNK65X1039Accident · No injuriesClosedGlobe GC1B · Purcell, OKDec 18, 1964 · N3398K · Substantial damage NTSB UNK65X1038Accident · No injuriesClosedCessna 185 · Honolulu, HIDec 17, 1964 · N4105Y · Substantial damage NTSB UNK65X1037Accident · No injuriesClosedBeechraft D18S · Muskegon, MIDec 17, 1964 · N57G · Substantial damage NTSB UNK65X1036Accident · No injuriesClosedPiper J3 · Birch Bay, WADec 17, 1964 · N92145 · Substantial damage NTSB UNK65X1035Accident · No injuriesClosedPiper PA28 · Old Town, MEDec 17, 1964 · N6413W · Substantial damage NTSB UNK65X1034Accident · No injuriesClosedMooney M20A · Urg, ORDec 17, 1964 · N1095B · Substantial damage NTSB UNK65X1033Accident · No injuriesClosedPiper PA24 · Sugar Land, TXDec 17, 1964 · N6388P · Substantial damage NTSB NYC65A0089Accident · 2 fatalClosedCessna 182G · Kasson, WVDec 17, 1964 · N3283S · Destroyed NTSB UNK65X1032Accident · No injuriesClosedConvair PBY6A · Phoenix, AZDec 16, 1964 · N7057C · Substantial damage NTSB UNK65X1031Accident · No injuriesClosedCessna 172 · Middleburg, VADec 16, 1964 · N7790U · Substantial damage NTSB UNK65X1030Accident · No injuriesClosedMooney M20C · San Jose, CADec 16, 1964 · N6998U · Substantial damage NTSB UNK65X1029Accident · No injuriesClosedCessna 172D · Louisville, KYDec 16, 1964 · N2070Y · Substantial damage NTSB UNK65X1028Accident · No injuriesClosedCessna 310C · Bedford, PADec 16, 1964 · N1779H · Substantial damage NTSB UNK65X1027Accident · No injuriesClosedCessna 120 · Avon, OHDec 16, 1964 · N81068 · Substantial damage NTSB UNK65X1026Accident · No injuriesClosedNavion G · Hendersonville, NCDec 16, 1964 · N2405T · Substantial damage NTSB UNK65X1025Accident · No injuriesClosedStinson 108-1 · Groveland, FLDec 16, 1964 · N8645K · Substantial damage NTSB UNK65X1024Accident · No injuriesClosedPiper PA22 · Sanford, TXDec 16, 1964 · N3751A · Substantial damage NTSB UNK65X1023Accident · No injuriesClosedCessna 310B · Shreveport, LADec 15, 1964 · N5363A · Substantial damage NTSB UNK65X1022Accident · No injuriesClosedVickers VI745D · Franklin, PADec 15, 1964 · N505W · Substantial damage NTSB UNK65X1021Accident · No injuriesClosedBellanca 14-19 · North Canton, OHDec 15, 1964 · N8825R · Substantial damage NTSB UNK65X1020Accident · No injuriesClosedBellanca 14-13 · Lexington, MADec 15, 1964 · N86803 · Destroyed NTSB UNK65X1019Accident · No injuriesClosedGlobe GC1B · Lexington, NCDec 15, 1964 · N78243 · Substantial damage NTSB UNK65X1018Accident · No injuriesClosedCessna 172 · Teterboro, NJDec 15, 1964 · N5413T · Substantial damage NTSB UNK65X1017Accident · No injuriesClosedErcoupe 415C · Sunray, TXDec 15, 1964 · N93988 · Substantial damage NTSB UNK65X1016Accident · No injuriesClosedCessna 310B · Willoughby, OHDec 14, 1964 · N6965T · Substantial damage NTSB UNK65X1015Accident · No injuriesClosedHiller UH-12B · Pharr, TXDec 14, 1964 · N10195 · Substantial damage NTSB UNK65X1014Accident · No injuriesClosedBeechraft F35 · Frankfort, INDec 14, 1964 · N4251B · Substantial damage NTSB UNK65X1013Accident · No injuriesClosedCamair 480 · Van Nuys, CADec 14, 1964 · N188V · Substantial damage NTSB UNK65X1012Accident · No injuriesClosedPiper PA12 · Littlefork, MNDec 14, 1964 · N2624M · Substantial damage NTSB UNK65X1011Accident · No injuriesClosedBeechraft N35 · Centerville, IADec 14, 1964 · N545T · Substantial damage NTSB UNK65X1010Accident · No injuriesClosedAeronca 11AC · Spring Valley, NYDec 14, 1964 · N86248 · Substantial damage NTSB UNK65X1009Accident · No injuriesClosedPiper PA28 · Lumberton, NJDec 14, 1964 · N8743W · Substantial damage