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 CHI66F0476Accident · No injuriesClosedCessna 310J · Cincinnati, OHDec 15, 1965 · N222 · Substantial damage NTSB SEA66A0037Accident · No injuriesClosedBell 47G-2 · Auburn, WADec 14, 1965 · N2865B · Substantial damage NTSB OAK66A0027Accident · No injuriesClosedHughes 269A · Sonoma, CADec 14, 1965 · N8823F · Substantial damage NTSB NYC66F0391Accident · No injuriesClosedCessna 150E · Ronkonkoma, NYDec 14, 1965 · N4050U · Substantial damage NTSB MIA66F0409Accident · No injuriesClosedPiper PA-24 · New Bern, NCDec 14, 1965 · N6830P · Substantial damage NTSB MIA66F0386Accident · No injuriesClosedBeechcraft 23 · Knoxville, TNDec 14, 1965 · N2399Z · Substantial damage NTSB MIA66A0067Accident · No injuriesClosedJodel D1190S · Wilmington, NCDec 14, 1965 · N2803Q · Substantial damage NTSB FTW66F0459Accident · No injuriesClosedCessna 150B · Longview, TXDec 14, 1965 · N7289X · Substantial damage NTSB UNK66X0115Accident · No injuriesClosedPiper PA-24 · Ciudad Anahac, MexicoDec 13, 1965 · N6711P · Substantial damage NTSB NYC66A0066Accident · 1 fatalClosedPiper PA-28 · Reading, PADec 13, 1965 · N8911T · Destroyed NTSB LAX66F0191Accident · Minor injuriesClosedCessna 182B · Ocotillo, CADec 13, 1965 · N2780G · Substantial damage NTSB LAX66D0200Accident · No injuriesClosedCessna 170B · Carlsbad, CADec 13, 1965 · N8261A · Substantial damage NTSB NYC66A0065Accident · 1 fatalClosedPiper PA-30 · White Plains, NYDec 12, 1965 · N7056Y · Destroyed NTSB MIA66D0361Accident · No injuriesClosedPiper J3C-65 · St George, SCDec 12, 1965 · N98519 · Substantial damage NTSB MIA66A0066Accident · 1 fatalClosedCessna 172B · Oneonta, ALDec 12, 1965 · N7543X · Destroyed NTSB LAX66D0196Accident · No injuriesClosedPiper PA-28 · Santa Monica, CADec 12, 1965 · N139SF · Substantial damage NTSB LAX66D0174Accident · No injuriesClosedCessna 150 · Torrance, CADec 12, 1965 · N3560J · Substantial damage NTSB LAX66A0048Accident · 1 fatalClosedCessna 172C · Montello, NVDec 12, 1965 · N8445X · Destroyed NTSB FTW66F0431Accident · Minor injuriesClosedTaylorcraft DCO-65 · Gurdon, ARDec 12, 1965 · N58603 · Substantial damage NTSB FTW66F0414Accident · No injuriesClosedCessna 150 · Shreveport, LADec 12, 1965 · N8897S · Substantial damage NTSB DEN66A0045Accident · 3 fatalClosedBeech B95 · Aspen, CODec 12, 1965 · N9975R · Destroyed NTSB DEN66A0044Accident · 2 fatalClosedCessna 120 · Kingman, AZDec 12, 1965 · N89805 · Destroyed NTSB ANC66D0075Accident · No injuriesClosedCessna 180C · Stevens Vilg, AKDec 12, 1965 · N9173T · Substantial damage NTSB SEA66F0182Accident · Minor injuriesClosedTaylorcraft DC0-65 · Kent, WADec 11, 1965 · N49174 · Substantial damage NTSB SEA66D0187Accident · No injuriesClosedPiper PA-22 · Eugene, ORDec 11, 1965 · N6956D · Substantial damage NTSB OAK66A0028Accident · 3 fatalClosedCessna 182E · El Portal, CADec 11, 1965 · N3167Y · Destroyed NTSB NYC66F0398Accident · No injuriesClosedCessna 172 · Gaithersburg, MDDec 11, 1965 · N6836X · Substantial damage NTSB MIA66F0342Accident · No injuriesClosedPiper PA-22 · Wendell, NCDec 11, 1965 · N2312P · 2 aircraft · Substantial damage NTSB FTW66F0430Accident · Minor injuriesClosedPiper PA-22 · Fort Worth, TXDec 11, 1965 · N2370P · Substantial damage NTSB FTW66D0454Accident · No injuriesClosedCessna 150 · Bryan, TXDec 11, 1965 · N6243T · Substantial damage NTSB FTW66D0439Accident · No injuriesClosedCessna 182 · Pecos, TXDec 11, 1965 · N3598U · Substantial damage NTSB DEN66A0047Accident · 2 fatalClosedPiper PA-24 · Cuba, NMDec 11, 1965 · N6961P · Destroyed NTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CODec 11, 1965 · N1469Y · Destroyed NTSB ANC66D0079Accident · No injuriesClosedPiper PA-22 · Anchorage, AKDec 11, 1965 · N5601Z · Substantial damage NTSB SEA66F0204Accident · No injuriesClosedPiper PA-22 · Scio, ORDec 10, 1965 · N9312D · Substantial damage NTSB NYC66D0397Accident · No injuriesClosedBeechcraft A-23 · Princeton, NJDec 10, 1965 · N3534R · Substantial damage NTSB MIA66F0378Accident · No injuriesClosedPiper PA-24 · Nashville, TNDec 10, 1965 · N8719P · Substantial damage NTSB MIA66D0373Accident · No injuriesClosedPiper PA-28 · Savannah, GADec 10, 1965 · N5797W · Substantial damage NTSB MIA66D0360Accident · No injuriesClosedPiper PA-28 · La Parguera, PRDec 10, 1965 · N5417W · Substantial damage NTSB FTW66F0504Accident · Serious injuriesClosedPiper PA-23 · Dexter, TXDec 10, 1965 · N52024 · Substantial damage NTSB FTW66F0480Accident · No injuriesClosedCessna 182 · Hot Springs, ARDec 10, 1965 · N9073T · Substantial damage NTSB FTW66A0057Accident · 1 fatalClosedBeech 35-B33 · Goliad, TXDec 10, 1965 · N9752Y · Destroyed NTSB CHI66F0521Accident · Serious injuriesClosedCessna 172D · Walworth, WIDec 10, 1965 · N2085Y · Destroyed NTSB CHI66F0491Accident · Serious injuriesClosedLuscombe 8A · Findlay, OHDec 10, 1965 · N1274B · Substantial damage NTSB CHI66D0498Accident · No injuriesClosedPiper PA-28 · Mansfield, OHDec 10, 1965 · N7739W · Substantial damage NTSB CHI66A0058Accident · 1 fatalClosedCessna 150F · South Bend, INDec 10, 1965 · N8072S · Destroyed NTSB CHI66A0057Accident · 2 fatalClosedCessna 172 · Stone, KYDec 10, 1965 · N3947S · Destroyed NTSB SEA66D0195Accident · No injuriesClosedBellanca 14-13 · Billings, MTDec 9, 1965 · N86720 · Substantial damage NTSB NYC66D0409Accident · No injuriesClosedBeech J35 · New Paltz, NYDec 9, 1965 · N8292D · Substantial damage NTSB MKC66D0436Accident · No injuriesClosedCessna 170 · Russell, KSDec 9, 1965 · N8001A · Substantial damage