Skip to content

NTSB investigations, 1964

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.

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 UNK65X0960Accident · No injuriesClosedMooney 20B · Columbia, MODec 9, 1964 · N74741 · Substantial damage NTSB UNK65X0959Accident · No injuriesClosedPiper PA28 · Lincoln Park, NJDec 9, 1964 · N6050W · Substantial damage NTSB UNK65X0958Accident · No injuriesClosedPiper PA28 · Bakersfield, CADec 9, 1964 · N6069W · Substantial damage NTSB UNK65X0957Accident · No injuriesClosedPiper PA23 · San Juan, PRDec 9, 1964 · N4082P · Substantial damage NTSB UNK65X0956Accident · 1 fatalClosedPiper PA28 · Waterville, OHDec 8, 1964 · N5527W · Destroyed NTSB UNK65X0955Accident · No injuriesClosedCessna 310B · Hopkins, MNDec 8, 1964 · N547M · Substantial damage NTSB UNK65X0954Accident · No injuriesClosedErcoupe 415C · El Reno, OKDec 8, 1964 · N93578 · Substantial damage NTSB UNK65X0953Accident · No injuriesClosedCessna 150 · Ypsilanti, MIDec 8, 1964 · N5673E · Substantial damage NTSB UNK65X0952Accident · No injuriesClosedPiper PA18 · Eureka, AKDec 8, 1964 · N4881A · Substantial damage NTSB UNK65X0951Incident · No injuriesClosedBoeing 707 131B · New York, NYDec 7, 1964 · N796TW · No damage NTSB UNK65X0950Accident · 3 fatalClosedBell 47J2 · Venice, LADec 7, 1964 · N73229 · Destroyed NTSB UNK65X0949Accident · No injuriesClosedBell 47G4 · Bedminster, NJDec 7, 1964 · N73996 · Substantial damage NTSB UNK65X0948Accident · Serious injuriesClosedCessna 182 · Belzoni, MSDec 7, 1964 · N3062Y · Destroyed NTSB UNK65X0947Accident · No injuriesClosedCessna 172 · Riverside, CADec 7, 1964 · N3090U · Substantial damage NTSB UNK65X0946Accident · No injuriesClosedPiper PA18 · Parkview, NMDec 7, 1964 · N6999V · Substantial damage NTSB UNK65X0945Accident · No injuriesClosedStinson 108-3 · Croton, NYDec 7, 1964 · N4087C · Substantial damage NTSB UNK65X0944Accident · No injuriesClosedNavion G · Lake Placid, NYDec 7, 1964 · N2429T · Substantial damage NTSB UNK65X0943Accident · No injuriesClosedCessna 182 · Fayetteville, NCDec 7, 1964 · N2890Y · Substantial damage NTSB UNK65X0942Accident · No injuriesClosedCessna 180 · Franklin, LADec 7, 1964 · N9224T · Substantial damage NTSB UNK65X0941Accident · No injuriesClosedBeechcraft 23 · Muleshoe, TXDec 7, 1964 · N2393L · Substantial damage NTSB UNK65X0940Incident · No injuriesClosedBoeing 727 · New York, NYDec 6, 1964 · N1971 · Minor damage NTSB UNK65X0939Accident · No injuriesClosedBeechraft 35 · Knoxville, TNDec 6, 1964 · N400X · Substantial damage NTSB UNK65X0938Accident · 1 fatalClosedPiper PA-23 · Bimini Bwi, WNDec 6, 1964 · N1420P · Substantial damage NTSB UNK65X0937Accident · Minor injuriesClosedCessna 182 · Calif Valley, CADec 6, 1964 · N3719U · Substantial damage NTSB UNK65X0936Accident · No injuriesClosedPiper PA22 · Windfall, INDec 6, 1964 · N5687Z · Substantial damage NTSB UNK65X0935Accident · No injuriesClosedPiper PA24 · Bedford, INDec 6, 1964 · N6863P · Substantial damage NTSB UNK65X0934Accident · Minor injuriesClosedChampion 7FC · Opa Locka, FLDec 6, 1964 · N9851Y · Substantial damage NTSB UNK65X0933Accident · No injuriesClosedPiper PA28 · Hobart, INDec 6, 1964 · N6347W · Substantial damage NTSB UNK65X0932Accident · No injuriesClosedCessna 120 · Houston, TXDec 5, 1964 · N90137 · Substantial damage NTSB UNK65X0931Accident · No injuriesClosedPiper PA24 · Athens, GADec 5, 1964 · N6993P · Substantial damage NTSB UNK65X0930Accident · No injuriesClosedPiper PA22 · Marquette, KSDec 5, 1964 · N3652A · Substantial damage NTSB UNK65X0929Accident · 2 fatalClosedCessna 140 · New Smyrna Be, FLDec 5, 1964 · N81089 · Destroyed NTSB UNK65X0928Accident · No injuriesClosedBoeing 75 · Normangee, TXDec 5, 1964 · N5214N · Destroyed NTSB UNK65X0927Accident · Serious injuriesClosedSikorsky S52 · Brandon, FLDec 5, 1964 · N9426H · No damage NTSB UNK65X0926Accident · Minor injuriesClosedStits SA3A · Eureka, CADec 5, 1964 · N3354G · Substantial damage NTSB UNK65X0925Accident · No injuriesClosedCessna 185 · Bethel, AKDec 5, 1964 · N9826X · Destroyed NTSB UNK65X0924Accident · No injuriesClosedAeronca 7AC · Rialto, CADec 5, 1964 · N2559E · Substantial damage NTSB UNK65X0923Accident · No injuriesClosedPiper PA22 · Kansas City, KSDec 5, 1964 · N8298C · Substantial damage NTSB UNK65X0922Accident · No injuriesClosedPiper PA28 · Huntsville, ALDec 5, 1964 · N5581W · Substantial damage NTSB UNK65X0921Accident · No injuriesClosedBellanca 14-19 · Kearney, NEDec 5, 1964 · N520A · Substantial damage NTSB UNK65X0920Accident · No injuriesClosedCessna 170B · Fall River, KSDec 5, 1964 · N2265D · Destroyed NTSB UNK65X0919Accident · No injuriesClosedPiper PA28 · Franklin, CADec 5, 1964 · N5506W · Substantial damage NTSB MIA65A0061Accident · 1 fatalClosedBellanca 14-19 · Bronson, FLDec 5, 1964 · N8820R · Destroyed NTSB UNK65X0918Accident · No injuriesClosedCurtiss C46 · Oliktok Pt, AKDec 4, 1964 · N4860V · Substantial damage NTSB UNK65X0917Accident · Minor injuriesClosedCessna 140A · Ardmore, OKDec 4, 1964 · N5369C · Destroyed NTSB UNK65X0916Accident · No injuriesClosedSnow S2C · Chowchilla, CADec 4, 1964 · N1600S · Substantial damage NTSB UNK65X0915Accident · No injuriesClosedCessna 172 · Jonesboro, GADec 4, 1964 · N5625A · Substantial damage NTSB UNK65X0914Accident · No injuriesClosedChampion 7EC · Pacoima, CADec 4, 1964 · N4328C · Substantial damage NTSB UNK65X0913Accident · 4 fatalClosedCessna 206 · Fayetteville, ARDec 4, 1964 · N5089U · Destroyed NTSB UNK65X0912Accident · No injuriesClosedCessna 172 · Westherford, TXDec 4, 1964 · N2360U · Substantial damage