Skip to content

NTSB investigations, 1965

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") = 1965 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\") = 1965
  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") = 1965
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 MIA66A0070Accident · 2 fatalClosedCessna 172C · Castle Hayne, NCDec 19, 1965 · N8470X · Substantial damage NTSB LAX66D0199Accident · No injuriesClosedCessna 140 · San Diego, CADec 19, 1965 · N76403 · Substantial damage NTSB FTW66F0460Accident · Serious injuriesClosedCessna 172A · College Sta, TXDec 19, 1965 · N7190T · Substantial damage NTSB CHI66F0492Accident · No injuriesClosedBeechcraft N35 · Mishawaka, INDec 19, 1965 · N1241Z · Substantial damage NTSB CHI66F0483Accident · No injuriesClosedPiper PA-28 · Iron Mt, MIDec 19, 1965 · N8340W · Substantial damage NTSB CHI66F0477Accident · No injuriesClosedCessna 182 · Pontiac, MIDec 19, 1965 · N2156G · Substantial damage NTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INDec 19, 1965 · N1100P · 2 aircraft · Destroyed NTSB UNK66X0116Accident · No injuriesClosedNo American Navion · San Luis, MexicoDec 18, 1965 · N91585 · Substantial damage NTSB OAK66F0181Accident · No injuriesClosedCessna 150D · Lincoln, CADec 18, 1965 · N4316U · 2 aircraft · Substantial damage NTSB NYC66F0430Accident · Minor injuriesClosedPiper JC3-65 · Pepperell, MADec 18, 1965 · N33121 · Substantial damage NTSB NYC66F0417Accident · No injuriesClosedCessna 320 · Teterboro, NJDec 18, 1965 · N145MP · Substantial damage NTSB MKC66F0410Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNDec 18, 1965 · N78480 · Substantial damage NTSB LAX66F0202Accident · No injuriesClosedCessna 150 · Catalina Is, CADec 18, 1965 · N3980U · Substantial damage NTSB DEN66A0049Accident · Minor injuriesClosedHiller UH12L4 · Albuquerque, NMDec 18, 1965 · N9780C · Destroyed NTSB CHI66F0533Accident · No injuriesClosedBeechcraft K35 · Chicago, ILDec 18, 1965 · N635Q · Substantial damage NTSB CHI66F0485Accident · Serious injuriesClosedPiper PA28 · Urbana, ILDec 18, 1965 · N8208W · Destroyed NTSB CHI66D0553Accident · No injuriesClosedMooney M20 · Polo, ILDec 18, 1965 · N6455U · Substantial damage NTSB CHI66D0504Accident · No injuriesClosedPiper PA-24 · Indianapolis, INDec 18, 1965 · N8451P · Substantial damage NTSB SEA66D0179Accident · No injuriesClosedBeechcraft 35 · Pullman, WADec 17, 1965 · N3854N · Substantial damage NTSB OAK66D0166Accident · No injuriesClosedCessna 210 · Tracy, CADec 17, 1965 · N3805Y · Substantial damage NTSB NYC66D0434Accident · No injuriesClosedCessna 195 · Philadelphia, PADec 17, 1965 · N177US · Substantial damage NTSB MKC66F0325Accident · No injuriesClosedCessna 172F · St Louis, MODec 17, 1965 · N8621U · Substantial damage NTSB MIA66F0353Accident · No injuriesClosedPiper PA-22 · Greensboro, NCDec 17, 1965 · N4836Z · Substantial damage NTSB MIA66D0341Accident · No injuriesClosedCessna 210 · Opa Locka, FLDec 17, 1965 · N7465E · Substantial damage NTSB MIA66A0069Accident · 2 fatalClosedPiper J3C-65 · Metter, GADec 17, 1965 · N7060H · Substantial damage NTSB LAX66F0235Accident · No injuriesClosedPiper PA-28 · Laverne, CADec 17, 1965 · N4533R · Substantial damage NTSB FTW66D0455Accident · No injuriesClosedBeechcraft M35 · Oklahomacity, OKDec 17, 1965 · N9927R · No damage NTSB FTW66D0449Accident · No injuriesClosedBeechcraft M-55 · Cushing, OKDec 17, 1965 · N109WB · Substantial damage NTSB CHI66D0472Accident · No injuriesClosedLuscombe 8A · Waldo, OHDec 17, 1965 · N71180 · Substantial damage NTSB OAK66D0159Accident · No injuriesClosedNavion L-17B · Livermore, CADec 16, 1965 · N7733C · Substantial damage NTSB NYC66I0067Incident · Minor injuriesClosedBoeing B-727 · Atlantic Ocean (Atlantic Ocean)Dec 16, 1965 · N1631 · No damage NTSB NYC66D0453Accident · Minor injuriesClosedErcoupe 415-C · Londonderry Tp, PADec 16, 1965 · N2205H · Destroyed NTSB MKC66D0341Accident · No injuriesClosedCessna 150 · St Charles, MODec 16, 1965 · N8666S · Substantial damage NTSB MIA66F0402Accident · 1 fatalClosedBeechcraft A-23 · Southern Pines, NCDec 16, 1965 · N8867M · Destroyed NTSB FTW66A0058Incident · No injuriesClosedBoeing 727 · Amarillo, TXDec 16, 1965 · N9851TW · Minor damage NTSB CHI66F0528Accident · Minor injuriesClosedCessna 172 · Granite City, ILDec 16, 1965 · N5435T · Destroyed NTSB CHI66F0475Accident · No injuriesClosedErcoupe 415-C · Stevens Pt, WIDec 16, 1965 · N94196 · Substantial damage NTSB CHI66D0618Accident · No injuriesClosedCessna 182 · Meyer, ILDec 16, 1965 · N3419S · Substantial damage NTSB CHI66A0059Accident · No injuriesClosedCurtiss-Wrt C-46 · Detroit, MIDec 16, 1965 · N53594 · No damage NTSB ANC66A0022Accident · No injuriesClosedBeechcraft 35B33 · Anchorage, AKDec 16, 1965 · N9507Y · Substantial damage NTSB SEA66F0181Accident · No injuriesClosedCessna 150F · Redmond, WADec 15, 1965 · N8801S · Substantial damage NTSB OAK66F0172Accident · Minor injuriesClosedCessna 182 · Tahoe Valley, CADec 15, 1965 · N9078X · Substantial damage NTSB OAK66D0168Accident · No injuriesClosedPiper PA-28 · Modesto, CADec 15, 1965 · N6701W · Substantial damage NTSB NYC66D0462Accident · No injuriesClosedPiper PA-28 · Montgomery, NYDec 15, 1965 · N8944W · Substantial damage NTSB NYC66D0424Accident · Minor injuriesClosedCessna 172 · Pittsburg, PADec 15, 1965 · N2589U · Substantial damage NTSB NYC66D0373Accident · No injuriesClosedStinson L-5E · Mechanicsville, VADec 15, 1965 · N3707C · Substantial damage NTSB MIA66A0068Accident · No injuriesClosedN.American NA-265 · W Palm Beach, FLDec 15, 1965 · N757R · Substantial damage NTSB LAX66F0207Accident · No injuriesClosedBeechcraft 35 · Oxnard, CADec 15, 1965 · N306B · Substantial damage NTSB FTW66F0466Accident · Serious injuriesClosedPiper PA-32 · Alexandria, LADec 15, 1965 · N3341W · Destroyed NTSB DEN66A0048Accident · 3 fatalClosedLockheed L-1049 · Alamosa, CODec 15, 1965 · N6914C · Destroyed