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 MIA69D0306Accident · Minor injuriesClosedPiper PA-28 · Clemson, SCNov 15, 1968 · N5110L · Substantial damage NTSB LAX69D0191Accident · Minor injuriesClosedPiper PA-22 · Bonita, AZNov 15, 1968 · N7426D · Substantial damage NTSB FTW69F0316Accident · No injuriesClosedPiper PA-28 · Canadian, TXNov 15, 1968 · N9670J · Substantial damage NTSB CHI69F0359Accident · No injuriesClosedMaule M-4210 · Clarkston, MINov 15, 1968 · N2014U · Substantial damage NTSB CHI69A0050Accident · 2 fatalClosedCessna 150 · Frankfort, ILNov 15, 1968 · N22532 · Destroyed NTSB NYC69F0269Accident · Serious injuriesClosedBell 206A · Hampden, MANov 14, 1968 · N3523T · Destroyed NTSB MKC69F0284Accident · No injuriesClosedCessna 172 · Carrollton, MONov 14, 1968 · N4097F · Substantial damage NTSB MKC69D0273Accident · No injuriesClosedBeech A23-19 · Lake Elmo, MNNov 14, 1968 · N4769J · Substantial damage NTSB LAX69D0187Accident · No injuriesClosedBeech D35 · Apple Valley, CANov 14, 1968 · N2916B · Substantial damage NTSB ANC69D0077Accident · No injuriesClosedChampion 7ECA · Whittier, AKNov 14, 1968 · N9618S · Substantial damage NTSB OAK69F0174Accident · No injuriesClosedCessna 172 · Reno, NVNov 13, 1968 · N46384 · Substantial damage NTSB NYC69D0271Accident · No injuriesClosedNavion A · Cooperstown, NYNov 13, 1968 · N8909H · Substantial damage NTSB NYC69A0055Accident · No injuriesClosedPiper PA-28 · Hazelton, PANov 13, 1968 · N981MA · Substantial damage NTSB MKC69F0292Accident · No injuriesClosedBeech A45 · Valley City, NDNov 13, 1968 · N9087C · Substantial damage NTSB MKC69D0304Accident · No injuriesClosedCessna 150H · Hinton, MONov 13, 1968 · N22113 · Substantial damage NTSB MIA69F0236Accident · No injuriesClosedCessna 175 · San Juan, PRNov 13, 1968 · N7082M · Substantial damage NTSB FTW69F0321Accident · Serious injuriesClosedCessna 150 · Bowie, TXNov 13, 1968 · N23177 · Destroyed NTSB FTW69D0293Accident · No injuriesClosedCessna 182 · Liberty, TXNov 13, 1968 · N2879R · Substantial damage NTSB FTW69A0032Accident · 1 fatalClosedMooney M20 · Wayne, OKNov 13, 1968 · N873B · Destroyed NTSB DEN70A0001Accident · 2 fatalClosedBeech 35 · Moab, UTNov 13, 1968 · N2700V · Destroyed NTSB DEN69D0138Accident · No injuriesClosedBeech 35C33A · Albuquerque, NMNov 13, 1968 · N8310N · Substantial damage NTSB DEN69A0023Accident · 1 fatalClosedPiper PA-23 · Cheyenne, WYNov 13, 1968 · N4877P · Destroyed NTSB CHI69F0349Accident · No injuriesClosedCessna 140 · Elyria, OHNov 13, 1968 · N4268N · Substantial damage NTSB LAX69D0203Accident · No injuriesClosedBell 206A · Long Beach, CANov 12, 1968 · N696MR · Substantial damage NTSB LAX69A0027Accident · No injuriesClosedConvair 580 · Santa Barbara, CANov 12, 1968 · N73135 · Substantial damage NTSB LAX69A0026Accident · No injuriesClosedDehavilland DHC-6 · Avalon, CANov 12, 1968 · N64150 · Substantial damage NTSB LAX69A0025Accident · 1 fatalClosedCessna 150F · Fallbrook, CANov 12, 1968 · N7817F · Destroyed NTSB DEN69F0156Accident · No injuriesClosedBeech D35 · Broomfield, CONov 12, 1968 · N2911B · Substantial damage NTSB CHI69D0358Accident · No injuriesClosedCessna 172 · Roselle, ILNov 12, 1968 · N2444Y · Substantial damage NTSB ANC69A0029Accident · 1 fatalClosedCessna 185 · Anaktuvuk Ps, AKNov 12, 1968 · N2256T · Substantial damage NTSB OAK69D0172Accident · No injuriesClosedBeech C35 · San Bruno, CANov 11, 1968 · N133L · Substantial damage NTSB NYC69D0257Accident · No injuriesClosedCessna 150 · Aptistown, NJNov 11, 1968 · N8467J · Substantial damage NTSB MKC69F0262Accident · No injuriesClosedCessna 172 · Cavalier, NDNov 11, 1968 · N1619F · Substantial damage NTSB MKC69F0254Accident · No injuriesClosedBeech V35 · Des Moines, IANov 11, 1968 · N3798Q · Substantial damage NTSB MKC69D0267Accident · No injuriesClosedBeech A23 · Millard, NENov 11, 1968 · N4753J · Substantial damage NTSB FTW69O0007Accident · Minor injuriesClosedCessna 195 · Calamahue, MexicoNov 11, 1968 · N4382N · Substantial damage NTSB ANC69A0028Accident · 4 fatalClosedCessna 180H · Anchorage, AKNov 11, 1968 · N9932V · Destroyed NTSB SEA69A0028Accident · 1 fatalClosedCessna 150H · Spirit Lake, WANov 10, 1968 · N22166 · Destroyed NTSB SEA69A0027Accident · 2 fatalClosedPiper PA-16 · Pine City, WANov 10, 1968 · N6804K · Substantial damage NTSB SEA69A0026Accident · 2 fatalClosedStinson 108 · Vancouver, WANov 10, 1968 · N422C · Destroyed NTSB OAK69A0030Accident · 1 fatalClosedPiper PA-28 · Durkee, ORNov 10, 1968 · N7273W · Substantial damage NTSB MKC69D0259Accident · No injuriesClosedCessna 182L · Garden City, KSNov 10, 1968 · N42105 · Substantial damage NTSB MIA69F0274Accident · Serious injuriesClosedBeech A23A · Dorado Beach, PRNov 10, 1968 · N2342W · Destroyed NTSB MIA69D0232Accident · No injuriesClosedPiper PA-32 · Atlantic Ocean (Atlantic Ocean)Nov 10, 1968 · N5589J · Destroyed NTSB LAX69D0208Accident · No injuriesClosedCessna 150 · Holbrook, AZNov 10, 1968 · N8233S · Substantial damage NTSB LAX69D0202Accident · Minor injuriesClosedCessna 150 · Redlands, CANov 10, 1968 · N7863E · Substantial damage NTSB LAX69D0184Accident · Minor injuriesClosedLuscombe 8A · Torrance, CANov 10, 1968 · N45902 · Substantial damage NTSB FTW69D0280Accident · No injuriesClosedCessna 172 · Fort Smith, ARNov 10, 1968 · N8382L · Substantial damage NTSB CHI69D0394Accident · No injuriesClosedPiper PA-28 · Wheeling, ILNov 10, 1968 · N6494J · Substantial damage NTSB CHI69D0352Accident · Minor injuriesClosedBensen B8M · Gilbertsville, KYNov 10, 1968 · N336Y · Destroyed