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 FTW66D0489Accident · No injuriesClosedBeechcraft P-35 · Hilltop Lakes, TXDec 24, 1965 · N1720G · Substantial damage NTSB FTW66D0463Accident · No injuriesClosedBeechcraft B-55 · Oklahoma Cty, OKDec 24, 1965 · N145ZB · Substantial damage NTSB FTW66D0462Accident · No injuriesClosedCessna 170B · Magnolia, ARDec 24, 1965 · N3522C · Substantial damage NTSB FTW66D0452Accident · No injuriesClosedCessna 172 · Altus, OKDec 24, 1965 · N5950R · Substantial damage NTSB DEN66D0196Accident · No injuriesClosedPiper PA-24 · Riverton, WYDec 24, 1965 · N6648P · Substantial damage NTSB CHI66F0502Accident · No injuriesClosedBeechcraft B55 · Paducah, KYDec 24, 1965 · N5812S · Substantial damage NTSB NYC66F0427Accident · No injuriesClosedCessna 172 · Lewiston, MEDec 23, 1965 · N8197B · Substantial damage NTSB NYC66D0399Accident · No injuriesClosedPiper PA-28 · Hartford, CTDec 23, 1965 · N7649W · Substantial damage NTSB MIA66F0372Accident · Minor injuriesClosedNavion A · Cumblnd City, TNDec 23, 1965 · N4896K · Substantial damage NTSB MIA66D0385Accident · No injuriesClosedBellanca 14-13 · Knoxville, TNDec 23, 1965 · N86835 · Substantial damage NTSB LAX66D0209Accident · Minor injuriesClosedChampion 7FC · San Diego, CADec 23, 1965 · N9896B · Substantial damage NTSB FTW66D0488Accident · No injuriesClosedNavion A · Harlingen, TXDec 23, 1965 · N4507K · Substantial damage NTSB ANC66A0026Accident · 2 fatalClosedPiper PA-24 · Umiat, AKDec 23, 1965 · N6093P · Destroyed NTSB SEA66A0038Accident · Minor injuriesClosedSikorsky S-55 · Seaside, ORDec 22, 1965 · N73893 · Destroyed NTSB NYC66F0428Accident · No injuriesClosedPiper PA-28 · Montour Falls, NYDec 22, 1965 · N9055W · Substantial damage NTSB NYC66F0401Accident · Minor injuriesClosedPiper PA-22 · Butler, PADec 22, 1965 · N5843Z · Substantial damage NTSB NYC66D0436Accident · No injuriesClosedPiper PA-28 · Manchester, NHDec 22, 1965 · N6642W · Substantial damage NTSB MKC66F0343Accident · No injuriesClosedBeechcraft 23 · So St Paul, MNDec 22, 1965 · N8799M · Substantial damage NTSB MKC66A0035Accident · 1 fatalClosedMooney M-20C · Timber Lake, SDDec 22, 1965 · N7880V · Destroyed NTSB MIA66F0379Accident · No injuriesClosedPiper PA-24 · Orlando, FLDec 22, 1965 · N8387P · Substantial damage NTSB MIA66F0357Accident · No injuriesClosedBeechcraft A35 · Miami, FLDec 22, 1965 · N609B · Substantial damage NTSB MIA66F0348Accident · No injuriesClosedPiper PA-28 · Picayune, MSDec 22, 1965 · N6757W · Substantial damage NTSB MIA66F0345Accident · Minor injuriesClosedCessna 310C · Memphis, TNDec 22, 1965 · N627W · Substantial damage NTSB LAX66A0049Accident · Serious injuriesClosedDouglas DC-8 · San Diego, CADec 22, 1965 · N8061U · No damage NTSB FTW66F0481Accident · Minor injuriesClosedErcoupe 415-C · Lahoma, OKDec 22, 1965 · N93605 · Substantial damage NTSB DEN66A0050Accident · 2 fatalClosedCessna 182 · Laveen, AZDec 22, 1965 · N9944B · Destroyed NTSB MKC66F0375Accident · No injuriesClosedBeech N35 · Springfield, MODec 21, 1965 · N1224Z · Substantial damage NTSB MIA66A0071Accident · No injuriesClosedPiper PA-23 · Huntsville, ALDec 21, 1965 · N5636Y · Substantial damage NTSB LAX66F0198Accident · No injuriesClosedCessna 150E · Compton, CADec 21, 1965 · N3548J · Substantial damage NTSB OAK66D0161Accident · No injuriesClosedSnow S2C · San Ardo, CADec 20, 1965 · N1636S · Substantial damage NTSB NYC66D0396Accident · No injuriesClosedPiper PA-22 · Danbury, CTDec 20, 1965 · N4967Z · Substantial damage NTSB MIA66F0392Accident · Serious injuriesClosedBeech A23 · Pahokee, FLDec 20, 1965 · N2308W · Substantial damage NTSB MIA66F0389Accident · No injuriesClosedBoeing PT-13 · Atlanta, GADec 20, 1965 · N1714M · Substantial damage NTSB MIA66F0384Accident · No injuriesClosedCessna 310 · Miami, FLDec 20, 1965 · N4822B · Substantial damage NTSB LAX66F0189Accident · No injuriesClosedCessna 150 · Santa Ana, CADec 20, 1965 · N2528J · Substantial damage NTSB LAX66D0216Accident · No injuriesClosedCessna 140A · Lancaster, CADec 20, 1965 · N9475A · Substantial damage NTSB FTW66F0450Accident · No injuriesClosedCessna 170 · Guthrie, OKDec 20, 1965 · N4192V · Substantial damage NTSB FTW66D0451Accident · No injuriesClosedCessna 310D · Thornwell, LADec 20, 1965 · N6899T · Substantial damage NTSB FTW66A0059Accident · 1 fatalClosedPiper J3 · Arlington, TXDec 20, 1965 · N38620 · Destroyed NTSB DEN66D0212Accident · No injuriesClosedCessna 150 · Littleton, CODec 20, 1965 · N8435G · Substantial damage NTSB ANC66A0025Accident · No injuriesClosedCessna 180 · Bethel, AKDec 20, 1965 · N2714X · Substantial damage NTSB ANC66A0024Accident · No injuriesClosedGrumman G-73 · Bethel, AKDec 20, 1965 · N1208 · Substantial damage NTSB UNK66X0117Accident · No injuriesClosedBeech D18S · Ixcalak, MexicoDec 19, 1965 · N45T · Destroyed NTSB SEA66D0200Accident · No injuriesClosedAeronca 7AC · Billings, MTDec 19, 1965 · N1128N · Substantial damage NTSB NYC66F0429Accident · No injuriesClosedPiper PA-28 · Narrowsburg, NYDec 19, 1965 · N7981W · Substantial damage NTSB NYC66D0490Accident · No injuriesClosedPiper PA-12 · Morganville, NJDec 19, 1965 · N92713 · Substantial damage NTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MADec 19, 1965 · N3083N · Substantial damage NTSB MKC66D0334Accident · Minor injuriesClosedCessna 172 · Wichita, KSDec 19, 1965 · N7648X · Destroyed NTSB MIA66F0366Accident · Minor injuriesClosedBeech A35 · Lake Worth, FLDec 19, 1965 · N8661A · Destroyed NTSB MIA66D0436Accident · No injuriesClosedBeechcraft C35 · Hazelgreen, ALDec 19, 1965 · N1882D · Substantial damage