Skip to content

NTSB investigations, 1967

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") = 1967 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\") = 1967
  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") = 1967
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 CHI68F0501Accident · Minor injuriesClosedBeech K35 · Wheeling, ILDec 16, 1967 · N801R · Substantial damage NTSB CHI68F0500Accident · No injuriesClosedBeech C-45 · Waterford, MIDec 16, 1967 · N9800H · Substantial damage NTSB ANC68F0074Accident · No injuriesClosedPiper PA-18 · Sitka, AKDec 16, 1967 · N4581A · Substantial damage NTSB ANC68A0034Accident · Minor injuriesClosedCessna 180 · Teller, AKDec 16, 1967 · N9173T · Substantial damage NTSB OAK68A0051Accident · No injuriesClosedHughes 269A · Salinas, CADec 15, 1967 · N8837F · Destroyed NTSB NYC68F0330Accident · 1 fatalClosedBeech T-34 · Butler, PADec 15, 1967 · N9182R · Destroyed NTSB MKC68F0428Accident · No injuriesClosedCessna 310B · St.Paul, MNDec 15, 1967 · N5347A · Substantial damage NTSB LAX68F0270Accident · No injuriesClosedAero Comdr 680 · Van Nuys, CADec 15, 1967 · N680S · Substantial damage NTSB LAX68F0259Accident · No injuriesClosedBeech D18S · Phoenix, AZDec 15, 1967 · N7526 · Substantial damage NTSB FTW68F0385Accident · Serious injuriesClosedCessna 150 · Lorena, TXDec 15, 1967 · N8088F · Substantial damage NTSB DEN68A0026Accident · 2 fatalClosedPiper PA-32 · Corona, NMDec 15, 1967 · N3408W · Destroyed NTSB ANC68A0033Accident · No injuriesClosedBell 47G-2A · Anchorage, AKDec 15, 1967 · N8495E · Substantial damage NTSB OAK68D0247Accident · No injuriesClosedGrumman G-164 · Merced, CADec 14, 1967 · N703Y · Substantial damage NTSB NYC68F0314Accident · No injuriesClosedCessna 310 · Flushing, NYDec 14, 1967 · N3693D · Substantial damage NTSB MIA68F0341Accident · Minor injuriesClosedLuscombe 8A · Sarasota, FLDec 14, 1967 · N45934 · Destroyed NTSB MIA68D0322Accident · No injuriesClosedCessna 150 · Hollywood, FLDec 14, 1967 · N8851G · Substantial damage NTSB DIA68D0139Accident · No injuriesClosedChampion 7ECA · Georgetown, DEDec 14, 1967 · N6342N · Substantial damage NTSB CHI68F0495Accident · No injuriesClosedCessna 310C · Prairie D Sac, WIDec 14, 1967 · N1796H · Destroyed NTSB OAK68D0304Accident · No injuriesClosedCessna 150 · Vacaville, CADec 13, 1967 · N2400J · Substantial damage NTSB OAK68D0232Accident · No injuriesClosedCessna 210 · Oakland, CADec 13, 1967 · N450A · Substantial damage NTSB OAK68D0228Accident · No injuriesClosedCessna 172 · Vacaville, CADec 13, 1967 · N6850X · Substantial damage NTSB OAK68A0050Accident · 2 fatalClosedBell 47J-2A · Hanalei, HIDec 13, 1967 · N8501F · Destroyed NTSB MKC68D0426Accident · No injuriesClosedPiper PA-22 · Fayette, MODec 13, 1967 · N5969Z · Substantial damage NTSB MIA68F0377Accident · No injuriesClosedCessna 170A · Wadley, GADec 13, 1967 · N81Z · Substantial damage NTSB MIA68F0363Accident · No injuriesClosedCessna 150F · Bartow, FLDec 13, 1967 · N8758G · Substantial damage NTSB LAX68F0265Accident · No injuriesClosedCessna 411 · Phoenix, AZDec 13, 1967 · N617EJ · Substantial damage NTSB FTW68F0369Accident · No injuriesClosedPiper PA-25 · Gonzales, LADec 13, 1967 · N6519Z · Destroyed NTSB DEN68F0169Accident · No injuriesClosedCessna 210 · Salt Lake City, UTDec 13, 1967 · N8469Z · Substantial damage NTSB CHI68F0446Accident · No injuriesClosedCessna 150G · Ypsilanti, MIDec 13, 1967 · N2776S · Substantial damage NTSB OAK68F0249Accident · Serious injuriesClosedCessna 150F · Wahaiwa, HIDec 12, 1967 · N6285R · Destroyed NTSB NYC68I0077Incident · No injuriesClosedDouglas DC-8 · Jamaica, NYDec 12, 1967 · N8606 · Minor damage NTSB NYC68F0321Accident · Minor injuriesClosedBeech D18S · New Cumberland, PADec 12, 1967 · N5869C · Destroyed NTSB MKC68F0420Accident · Minor injuriesClosedBeech 65-A90 · Iowa City, IADec 12, 1967 · N772K · Substantial damage NTSB MKC68D0425Accident · No injuriesClosedPiper PA-23 · Montrose, MODec 12, 1967 · N6059Y · Substantial damage NTSB MKC68D0373Accident · No injuriesClosedPiper PA-28 · Iowa City, IADec 12, 1967 · N6426W · Substantial damage NTSB MIA68F0307Accident · No injuriesClosedAero Comdr 680 · Decatur, ALDec 12, 1967 · N8302 · Substantial damage NTSB MIA68D0448Accident · No injuriesClosedCessna 182 · Jefferson, GADec 12, 1967 · N6414A · Substantial damage NTSB MIA68D0340Accident · No injuriesClosedCessna 210B · Kissimmee, FLDec 12, 1967 · N9656X · Substantial damage NTSB MIA68D0335Accident · No injuriesClosedAero Comdr 100 · Bunnell, FLDec 12, 1967 · N3899X · Substantial damage NTSB MIA68A0054Accident · 2 fatalClosedAero Comdr 560E · Kingshill, VIDec 12, 1967 · N8448C · Destroyed NTSB LAX68D0239Accident · No injuriesClosedPiper PA-28 · Torrance, CADec 12, 1967 · N6466W · Substantial damage NTSB FTW68F0384Accident · No injuriesClosedCessna 150G · Addison, TXDec 12, 1967 · N2731S · Substantial damage NTSB FTW68D0398Accident · No injuriesClosedBeech A23 · Conway, ARDec 12, 1967 · N3621Q · Substantial damage NTSB OAK68D0248Accident · No injuriesClosedBeech H35 · Monterey, CADec 11, 1967 · N4634D · Substantial damage NTSB OAK68A0049Accident · Minor injuriesClosedBell 47G3B1 · Honolulu, HIDec 11, 1967 · N1346X · Destroyed NTSB NYC68A0076Accident · 2 fatalClosedAero Comdr 560E · Seven Springs, PADec 11, 1967 · N6231D · Destroyed NTSB LAX68F0249Accident · No injuriesClosedPiper PA-24 · Tucson, AZDec 11, 1967 · N7740P · Substantial damage NTSB FTW68F0397Accident · No injuriesClosedBeech H35 · Anson, TXDec 11, 1967 · N5566D · Substantial damage NTSB CHI68A0054Accident · Serious injuriesClosedVickers 745D · Canton, OHDec 11, 1967 · N7429 · Substantial damage NTSB SEA68D0221Accident · No injuriesClosedPiper PA-18 · Preston, IDDec 10, 1967 · N1148A · Substantial damage