Skip to content

NTSB investigations, 1963

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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") = 1963 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\") = 1963
  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") = 1963
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 DCA63A0007Accident · No injuriesClosedDouglas DC-6B · Wildwood, NJMay 31, 1963 · N7919C · Substantial damage NTSB UNK63X0103Accident · Serious injuriesClosedLockheed 1049G · Manhattan, KSMay 28, 1963 · N189S · Destroyed NTSB NYC63A0189Accident · No injuriesClosedConvair 340 · Atlantic City, NJMay 28, 1963 · N8427H · Substantial damage NTSB MIA63A0139Accident · Serious injuriesClosedSud Aviatn SE 210 · Anniston, ALMay 27, 1963 · N1016U · Minor damage NTSB ANC63A0073Accident · Minor injuriesClosedBeech C18S · Peard Bay, AKMay 17, 1963 · N5080K · Substantial damage NTSB MIA63A0133Accident · No injuriesClosedLockheed 188A · Miami, FLMay 15, 1963 · N5013K · Substantial damage NTSB NYC63A0184Accident · No injuriesClosedConvair 340 · Newark, NJMay 8, 1963 · N3415 · Substantial damage NTSB MKC63A0074Accident · Serious injuriesClosedBoeing 707 · Des Moines, IAApr 18, 1963 · N785TW · No damage NTSB ANC63A0070Accident · No injuriesClosedCessna 180A · Mcintyre Pt, AKApr 10, 1963 · N5331D · Substantial damage NTSB ANC63A0068Accident · No injuriesClosedDehavilland DHC-2 · Savoonga, AKApr 2, 1963 · N3791G · Substantial damage NTSB MIA63A0130Accident · Serious injuriesClosedBoeing 707 · Panama Cty, St. Pierre & MiquelonMar 25, 1963 · N7072 · No damage NTSB CHI63A0156Accident · No injuriesClosedDouglas DC-3 · Peoria, ILMar 18, 1963 · N143D · Substantial damage NTSB OAK63A0071Accident · No injuriesClosedDouglas DC-7B · Oakland, CAMar 16, 1963 · N359AA · Substantial damage NTSB NYC63A0160Accident · No injuriesClosedDouglas DC-7B · Boston, MAMar 12, 1963 · N841D · Substantial damage NTSB NYC63A0149Accident · No injuriesClosedDouglas DC-7 · Boston, MAFeb 28, 1963 · N842D · No damage NTSB SEA63A0071Accident · Serious injuriesClosedCurtiss-Wrt C-46F · Puyallup, WAFeb 16, 1963 · N616Z · Destroyed NTSB MIA63A0114Accident · 43 fatalClosedBoeing 720B · Miami, FLFeb 12, 1963 · N724US · Destroyed NTSB OAK63A0064Accident · Serious injuriesClosedDouglas DC-6B · Mt.Hamilton, CAFeb 7, 1963 · N93123 · No damage NTSB UNK63X0102Accident · 4 fatalClosedLockheed 1049H · San Francisco, CAFeb 3, 1963 · N9740Z · Destroyed NTSB MKC63A0058Accident · 8 fatalClosedVickers 810 · Kansas City, MOJan 29, 1963 · N242V · Destroyed NTSB OAK63A0060Accident · No injuriesClosedDouglas DC-3C · Honolulu, HIJan 24, 1963 · N62044 · Substantial damage NTSB LAX63A0141Accident · Serious injuriesClosedDouglas DC-8 · Bakersfield, CAJan 22, 1963 · N8029U · No damage NTSB FTW63A0119Accident · 3 fatalClosedFairchild F-27 · Salt Lake City, UTJan 17, 1963 · N2703 · Destroyed NTSB ANC63A0060Accident · No injuriesClosedCessna T-50 · Bethel, AKJan 17, 1963 · N67643 · Substantial damage NTSB MIA63A0109Accident · No injuriesClosedDouglas DC-8 · Tampa, FLJan 14, 1963 · N802E · Substantial damage NTSB ANC63A0059Accident · 5 fatalClosedBeech AT-11 · Barter Isld, AKJan 14, 1963 · N65458 · Destroyed NTSB DCA63A0001Accident · 1 fatalClosedDouglas DC-7 · Memphis, TNJan 13, 1963 · N4875C · Substantial damage NTSB CHI63A0131Accident · No injuriesClosedConvair 880 · Chicago, ILJan 1, 1963 · N819TW · Substantial damage