Skip to content

NTSB investigations, 1968

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") = 1968 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\") = 1968
  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") = 1968
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 MKC69D0322Accident · No injuriesClosedBeech T-34 · Belle Frche, SDOct 11, 1968 · N34291 · Substantial damage NTSB LAX69F0185Accident · 1 fatalClosedCallair A-9B · Phoenix, AZOct 11, 1968 · N7672V · Destroyed NTSB FTW69A0024Accident · 3 fatalClosedPiper PA-28 · Georgetown, TXOct 11, 1968 · N9512W · Destroyed NTSB DEN69D0159Accident · No injuriesClosedCessna 172 · Hulett, WYOct 11, 1968 · N8214B · Substantial damage NTSB SEA69F0130Accident · Minor injuriesClosedTaylorcraft A · Bellevue, WAOct 10, 1968 · N19647 · Substantial damage NTSB OAK69F0177Accident · Serious injuriesClosedChampion 7EC · Livermore, CAOct 10, 1968 · N2588F · Substantial damage NTSB NYC69A0045Accident · 2 fatalClosedPiper PA-23 · Derry, PAOct 10, 1968 · N5140Y · Destroyed NTSB MKC69I0022Incident · No injuriesClosedBeech 18S · St Louis, MOOct 10, 1968 · N313A · Minor damage NTSB MKC69D0378Accident · No injuriesClosedCessna 150 · Avon, MNOct 10, 1968 · N3877J · Substantial damage NTSB MIA69F0281Accident · Minor injuriesClosedPiper PA-28 · Pensacola, FLOct 10, 1968 · N6698W · Substantial damage NTSB FTW69F0250Accident · No injuriesClosedPiper PA-24 · Oklahoma Cty, OKOct 10, 1968 · N5809P · Substantial damage NTSB FTW69F0249Accident · No injuriesClosedCessna EU206 · Euless, TXOct 10, 1968 · N5294U · Substantial damage NTSB DIA69A0019Accident · 2 fatalClosedPiper PA-28 · Blu Rdge Summt, MDOct 10, 1968 · N4561J · Destroyed NTSB CHI69A0039Accident · 1 fatalClosedTaylorcraft BC12-D · Ogilvie, MNOct 10, 1968 · N96557 · Destroyed NTSB ANC69A0022Accident · Minor injuriesClosedBell 47J-2 · Point Barrow, AKOct 10, 1968 · N73950 · Substantial damage NTSB NYC69D0217Accident · No injuriesClosedBeech A23 · Rochester, NHOct 9, 1968 · N1493L · Substantial damage NTSB MKC69A0021Accident · 1 fatalClosedCessna 195B · Loup City, NEOct 9, 1968 · N502E · Destroyed NTSB MIA69F0201Accident · Serious injuriesClosedGlobe GC-1B · Gulfport, MSOct 9, 1968 · N2323B · Destroyed NTSB MIA69D0191Accident · No injuriesClosedPiper PA-22 · Paris, TNOct 9, 1968 · N5737D · Substantial damage NTSB CHI69F0338Accident · No injuriesClosedPiper PA-23 · Painesville, OHOct 9, 1968 · N3297P · Substantial damage NTSB CHI69F0277Accident · No injuriesClosedBeech E18S · Detroit, MIOct 9, 1968 · N162F · Substantial damage NTSB SEA69I0023Incident · No injuriesClosedPiper PA-31 · Portland, OROct 8, 1968 · N1132 · Minor damage NTSB SEA69D0162Accident · No injuriesClosedCessna 172 · Tillamook, OROct 8, 1968 · N7100T · Substantial damage NTSB OAK69A0021Accident · 4 fatalClosedDehavilland DH-104 · Las Vegas, NVOct 8, 1968 · N4040B · Destroyed NTSB NYC69F0216Accident · Minor injuriesClosedCessna 180 · Canandaigua, NYOct 8, 1968 · N6823D · Substantial damage NTSB MKC69A0020Accident · 4 fatalClosedBeech N35 · Hetland, SDOct 8, 1968 · N957T · Destroyed NTSB FTW69D0248Accident · No injuriesClosedBoeing E75 · Pecos, TXOct 8, 1968 · N5221N · Substantial damage NTSB FTW69A0023Accident · 2 fatalClosedCessna 310L · Austin, TXOct 8, 1968 · N2219F · Destroyed NTSB DIA69F0099Accident · No injuriesClosedBeech 65-80 · Friendship, MDOct 8, 1968 · N51025 · Substantial damage NTSB DIA69F0082Accident · No injuriesClosedCarson-Bell 47-G · Sandston, VAOct 8, 1968 · N617X · Substantial damage NTSB DEN69A0017Accident · No injuriesClosedCessna 320 · Raton, NMOct 8, 1968 · N5748X · Substantial damage NTSB CHI69F0304Accident · No injuriesClosedAero Comdr 680 · Kalamazoo, MIOct 8, 1968 · N6861S · Substantial damage NTSB SEA69D0112Accident · No injuriesClosedBeech 35 · Burley, IDOct 7, 1968 · N4242Y · Destroyed NTSB OAK69D0173Accident · No injuriesClosedBeech A23 · San L Obispo, CAOct 7, 1968 · N1450L · Substantial damage NTSB OAK69D0167Accident · Minor injuriesClosedAeronca 11AC · Schellville, CAOct 7, 1968 · N9214E · Substantial damage NTSB NYC69F0237Accident · No injuriesClosedPiper PA-23 · Neptune, NJOct 7, 1968 · N5426Y · Substantial damage NTSB MKC69D0217Accident · No injuriesClosedPiper PA-22 · Salina, KSOct 7, 1968 · N9247D · Substantial damage NTSB MIA69F0192Accident · No injuriesClosedPiper L-4J · Memphis, TNOct 7, 1968 · N66332 · Substantial damage NTSB MIA69A0021Accident · 6 fatalClosedPiper PA-32 · Charleston, SCOct 7, 1968 · N3583W · Destroyed NTSB MIA69A0020Accident · 2 fatalClosedCessna 172E · Spring Place, GAOct 7, 1968 · N7732U · Destroyed NTSB FTW69A0022Accident · 4 fatalClosedCessna 172 · Hot Springs, AROct 7, 1968 · N8225U · Destroyed NTSB DEN69D0140Accident · No injuriesClosedCessna 172 · Gillette, WYOct 7, 1968 · N1638F · Substantial damage NTSB CHI69A0038Accident · 1 fatalClosedPiper PA-22 · Hobart, INOct 7, 1968 · N6113D · Destroyed NTSB OAK69D0152Accident · No injuriesClosedSchweizer SGS233 · Calistoga, CAOct 6, 1968 · N5726S · Substantial damage NTSB OAK69D0141Accident · No injuriesClosedPiper PA-24 · San Jose, CAOct 6, 1968 · N7833P · Substantial damage NTSB NYC69D0225Accident · No injuriesClosedPiper PA-28 · Rio Grande, NJOct 6, 1968 · N1870J · 2 aircraft · Substantial damage NTSB MKC69F0277Accident · No injuriesClosedPiper PA-12 · Bagley, MNOct 6, 1968 · N2995M · Substantial damage NTSB MKC69D0296Accident · Minor injuriesClosedPiper PA-22 · Devils Lake, NDOct 6, 1968 · N6054D · Substantial damage NTSB MKC69D0188Accident · No injuriesClosedBensen B-8 · Pratt, KSOct 6, 1968 · N9144 · Substantial damage NTSB MKC69A0019Accident · 4 fatalClosedCessna 172D · Lexington, MOOct 6, 1968 · N2428U · Destroyed