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 UNK65X1008Accident · No injuriesClosedCessna 182E · Austin, TXDec 14, 1964 · N3012Y · Substantial damage NTSB CHI66D0214Accident · No injuriesClosedPiper PA-24 · Peoria, ILDec 14, 1964 · N6237P · Substantial damage NTSB UNK65X1007Accident · 1 fatalClosedCessna 120 · Anaheim, CADec 13, 1964 · N1708V · 2 aircraft · Substantial damage NTSB UNK65X1006Accident · No injuriesClosedTaylorcraft BC12D · Poteet, TXDec 13, 1964 · N29785 · Substantial damage NTSB UNK65X1005Accident · 2 fatalClosedPiper PA-18 · Carrington Isl., UTDec 13, 1964 · N6977D · Destroyed NTSB UNK65X1004Accident · No injuriesClosedHiller UH12A · Austin, TXDec 13, 1964 · N6444D · Substantial damage NTSB UNK65X1003Accident · No injuriesClosedCessna 150 · Columbia, MODec 13, 1964 · N606T · Substantial damage NTSB UNK65X1002Accident · No injuriesClosedAero Cmdr 560A · Santee, CADec 13, 1964 · N2736B · Substantial damage NTSB UNK65X1001Accident · No injuriesClosedDehavilland DH104 · Worcester, MADec 13, 1964 · N357G · Substantial damage NTSB UNK65X1000Accident · No injuriesClosedLake LA4 · Winslow, AZDec 13, 1964 · N1134L · Substantial damage NTSB UNK65X0999Accident · No injuriesClosedBeechraft B50A · Atlanta, GADec 13, 1964 · N1378Z · Substantial damage NTSB UNK65X0998Accident · No injuriesClosedBeechraft C35 · Pine Bluff, ARDec 13, 1964 · N2029D · Substantial damage NTSB UNK65X0997Accident · No injuriesClosedAeronca 7AC · West Edmeston, NYDec 13, 1964 · N1599E · Destroyed NTSB UNK65X0996Accident · Minor injuriesClosedCessna 185 · Buras, LADec 13, 1964 · N2690Z · Substantial damage NTSB UNK65X0995Accident · No injuriesClosedCessna 170A · Rosemount, MNDec 13, 1964 · N9965A · Substantial damage NTSB UNK65X0994Accident · No injuriesClosedCessna 175 · Mt Pleasant, IADec 13, 1964 · N9365B · Destroyed NTSB MIA65 0063Accident · 1 fatalClosedPiper PA-20 · Batesville, MSDec 13, 1964 · N7091K · Destroyed NTSB UNK65X0993Accident · No injuriesClosedCessna 182 · Olathe, KSDec 12, 1964 · N2316G · 2 aircraft · Minor damage NTSB UNK65X0992Accident · 2 fatalClosedRyan ST3KR · Altus, OKDec 12, 1964 · N88717 · Destroyed NTSB UNK65X0991Accident · 1 fatalClosedCessna 190 · Bradford, ILDec 12, 1964 · N4497C · Destroyed NTSB UNK65X0990Accident · 1 fatalClosedDerringer D-1 · Palos Verdes, CADec 12, 1964 · N88941 · Destroyed NTSB UNK65X0989Accident · Minor injuriesClosedPiper PA-22 · Blythe, CADec 12, 1964 · N5861Z · Substantial damage NTSB UNK65X0988Accident · No injuriesClosedCessna 182 · Flagstaff, AZDec 12, 1964 · N3150Y · Substantial damage NTSB UNK65X0987Accident · No injuriesClosedMooney M20B · Emporia, KSDec 12, 1964 · N74587 · Substantial damage NTSB UNK65X0986Accident · No injuriesClosedPiper PA22 · Wayne, NEDec 12, 1964 · N4348A · Substantial damage NTSB UNK65X0985Accident · Minor injuriesClosedCessna 172 · Larned, KSDec 12, 1964 · N8812B · Destroyed NTSB UNK65X0984Accident · No injuriesClosedPiper PA22 · Piney Point, MDDec 12, 1964 · N5015Z · Substantial damage NTSB UNK65X0983Accident · No injuriesClosedBeechcraft S35 · Plainfield, KSDec 12, 1964 · N6864Q · Substantial damage NTSB UNK65X0982Accident · No injuriesClosedCessna 182 · Columbia, SCDec 11, 1964 · N9019T · Substantial damage NTSB UNK65X0981Accident · Serious injuriesClosedBeechcraft H-35 · Bladenboro, NCDec 11, 1964 · N5510D · Destroyed NTSB UNK65X0980Incident · No injuriesClosedCessna 185 · Homer, AKDec 11, 1964 · N9918X · Minor damage NTSB UNK65X0979Accident · No injuriesClosedBeechcraft H18 · Worcester, MADec 11, 1964 · N919X · Substantial damage NTSB UNK65X0978Accident · No injuriesClosedLuscombe 8-A · San Diego, CADec 11, 1964 · N71263 · Substantial damage NTSB UNK65X0977Accident · No injuriesClosedCessna 182 · Mendota, CADec 11, 1964 · N5704B · Substantial damage NTSB UNK65X0976Accident · Minor injuriesClosedPiper PA22 · Lagrange, NCDec 11, 1964 · N1285C · Destroyed NTSB UNK65X0975Accident · No injuriesClosedCessna 150 · Blue Springs, MODec 11, 1964 · N4122U · Substantial damage NTSB UNK65X0974Accident · No injuriesClosedCessna 172 · Kingman, AZDec 11, 1964 · N1326Y · Substantial damage NTSB UNK65X0973Accident · No injuriesClosedCessna 150 · Willimantic, CTDec 11, 1964 · N7990Z · Substantial damage NTSB UNK65X0972Accident · 1 fatalClosedCessna 310 · Napa, CADec 10, 1964 · N3016D · Destroyed NTSB UNK65X0971Accident · 4 fatalClosedCessna 172 · Torrance, CADec 10, 1964 · N8022B · Destroyed NTSB UNK65X0970Accident · 1 fatalClosedHughes 269A · Moraga, CADec 10, 1964 · N8811F · Destroyed NTSB UNK65X0969Accident · Serious injuriesClosedAeronca 7AC · Le Sueur, MNDec 10, 1964 · N7946A · Substantial damage NTSB UNK65X0968Accident · No injuriesClosedPiper PA24 · Philadelphia, PADec 10, 1964 · N6638P · Substantial damage NTSB UNK65X0967Accident · No injuriesClosedPiper PA22 · Lockport, ILDec 10, 1964 · N5526Z · Substantial damage NTSB UNK65X0966Accident · No injuriesClosedLuscombe 8A · Tullahoma, TNDec 10, 1964 · N1342B · Substantial damage NTSB UNK65X0965Accident · No injuriesClosedCessna 150 · Lima, OHDec 10, 1964 · N5879E · Substantial damage NTSB UNK65X0964Accident · 1 fatalClosedCessna 185 · Norton Sound, AKDec 9, 1964 · N4064Y · Destroyed NTSB UNK65X0963Accident · Serious injuriesClosedTaylorcraft BC12D · Albany, MODec 9, 1964 · N95752 · Substantial damage NTSB UNK65X0962Accident · Serious injuriesClosedCessna 210 · Sayre, OKDec 9, 1964 · N9554T · Substantial damage NTSB UNK65X0961Accident · No injuriesClosedPiper PA-28 · Burbank, CADec 9, 1964 · N7490W · Substantial damage