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 OAK69F0160Accident · No injuriesClosedCessna 177 · Las Vegas, NVOct 13, 1968 · N2937X · Substantial damage NTSB NYC69F0221Accident · Minor injuriesClosedCessna 182 · Deer Park, NYOct 13, 1968 · N3436S · Substantial damage NTSB NYC69F0203Accident · No injuriesClosedCessna 177 · Newton, NJOct 13, 1968 · N3189T · Destroyed NTSB NYC69D0247Accident · No injuriesClosedLuscombe 8A · Glens Falls, NYOct 13, 1968 · N22094 · Substantial damage NTSB NYC69D0223Accident · No injuriesClosedFly Baby 1A · Coram, NYOct 13, 1968 · N343Y · Substantial damage NTSB NYC69A0046Accident · No injuriesClosedBeech B-99 · Hazelton, PAOct 13, 1968 · N336PL · Substantial damage NTSB MKC69F0218Accident · Serious injuriesClosedTaylorcraft BC12-D · Starbuck, MNOct 13, 1968 · N96035 · Minor damage NTSB MKC69D0239Accident · No injuriesClosedCessna 150G · Council Blfs, IAOct 13, 1968 · N2809S · Substantial damage NTSB MKC69D0230Accident · No injuriesClosedCessna 150 · Alma, KSOct 13, 1968 · N8895G · Substantial damage NTSB MKC69D0229Accident · No injuriesClosedPiper PA-28 · Crosby, NDOct 13, 1968 · N5553W · Substantial damage NTSB MKC69A0023Accident · 2 fatalClosedPiper PA-28 · Osceola, IAOct 13, 1968 · N9176W · Destroyed NTSB MIA69F0340Accident · 1 fatalClosedGyroplane M-2 · Chuluota, FLOct 13, 1968 · N4772S · Destroyed NTSB MIA69F0327Accident · Serious injuriesClosedBoeing PT-17 · Jesup, GAOct 13, 1968 · N52143 · Substantial damage NTSB MIA69F0249Accident · No injuriesClosedEaa Biplane PF · St.George, SCOct 13, 1968 · N155F · Substantial damage NTSB MIA69A0022Accident · No injuriesClosedCessna 310C · Lantana, FLOct 13, 1968 · N1721H · 2 aircraft · Substantial damage NTSB FTW69F0254Accident · No injuriesClosedPiper PA-28 · Shallowater, TXOct 13, 1968 · N6826W · Substantial damage NTSB FTW69F0253Accident · No injuriesClosedPiper PA-32 · Shallowater, TXOct 13, 1968 · N3453W · Substantial damage NTSB FTW69F0252Accident · Minor injuriesClosedCessna 120 · Dallas, TXOct 13, 1968 · N72767 · Substantial damage NTSB FTW69D0233Accident · Minor injuriesClosedCessna 172F · Athens, TXOct 13, 1968 · N7861U · Substantial damage NTSB FTW69D0225Accident · Minor injuriesClosedLuscombe 8F · Drumright, OKOct 13, 1968 · N3541G · Substantial damage NTSB DIA69F0090Accident · No injuriesClosedPiper PA-28 · Linthicum, MDOct 13, 1968 · N6274W · Destroyed NTSB DEN69F0158Accident · Serious injuriesClosedErco 415-C · Montrose, COOct 13, 1968 · N93542 · Substantial damage NTSB DEN69F0141Accident · No injuriesClosedCessna 185 · Veyo, UTOct 13, 1968 · N5700M · Substantial damage NTSB DEN69D0110Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMOct 13, 1968 · N8419W · Substantial damage NTSB DEN69A0019Accident · 2 fatalClosedFleet Acft 16B · Niwot, COOct 13, 1968 · N9427H · Destroyed NTSB CHI69F0317Accident · Minor injuriesClosedCessna 172D · Shawano, WIOct 13, 1968 · N2522Y · Destroyed NTSB CHI69D0324Accident · No injuriesClosedCessna 182 · Morris, ILOct 13, 1968 · N2692F · Substantial damage NTSB CHI69A0040Accident · 4 fatalClosedCessna 172 · Platteville, WIOct 13, 1968 · N8624B · Destroyed NTSB ANC69D0071Accident · Minor injuriesClosedPiper PA-14 · Anchorage, AKOct 13, 1968 · N5142H · Substantial damage NTSB OAK69D0168Accident · No injuriesClosedLuscombe 8A · Livermore, CAOct 12, 1968 · N28489 · Substantial damage NTSB MKC69F0264Accident · Serious injuriesClosedCessna 310 · Faith, SDOct 12, 1968 · N5347A · Substantial damage NTSB MKC69F0244Accident · Minor injuriesClosedCessna 177 · Whte Bear Lk, MNOct 12, 1968 · N2210Y · Substantial damage NTSB MKC69F0213Accident · No injuriesClosedGlobe GC-1B · Washburn, IAOct 12, 1968 · N3764K · Substantial damage NTSB MIA69F0294Accident · Minor injuriesClosedCessna 150F · Titusville, FLOct 12, 1968 · N6482F · Substantial damage NTSB LAX69D0165Accident · No injuriesClosedCessna 150 · Hesperia, CAOct 12, 1968 · N4270U · Substantial damage NTSB FTW69F0260Accident · No injuriesClosedPiper PA-25 · Woodrow, TXOct 12, 1968 · N6280Z · Substantial damage NTSB FTW69F0251Accident · Serious injuriesClosedPiper PA-18 · Anahuac, TXOct 12, 1968 · N2893Z · Substantial damage NTSB FTW69D0261Accident · No injuriesClosedPiper PA-22 · Perryton, TXOct 12, 1968 · N1749P · Substantial damage NTSB FTW69A0025Accident · 1 fatalClosedPiper PA-23 · La Grange, TXOct 12, 1968 · N1472P · Destroyed NTSB DIA69F0088Accident · No injuriesClosedNavion A · Culpeper, VAOct 12, 1968 · N4216A · Substantial damage NTSB DEN69D0129Accident · No injuriesClosedCessna 310F · Watkins, COOct 12, 1968 · N5821X · Substantial damage NTSB DEN69D0121Accident · No injuriesClosedReeves Teller · Watkins, COOct 12, 1968 · N1685 · Substantial damage NTSB CHI69F0316Accident · No injuriesClosedErco 415-C · Prairieton, INOct 12, 1968 · N93891 · Substantial damage NTSB CHI69F0311Accident · No injuriesClosedMooney M20A · Inkster, MIOct 12, 1968 · N1093C · Destroyed NTSB CHI69F0306Accident · No injuriesClosedPiper PA-28 · Lombard, ILOct 12, 1968 · N5491W · Destroyed NTSB CHI69D0318Accident · No injuriesClosedCessna 120 · Richland Ctr, WIOct 12, 1968 · N2874N · Substantial damage NTSB CHI69D0314Accident · No injuriesClosedCessna 177 · So.Branch, MIOct 12, 1968 · N2972X · Substantial damage NTSB ANC69D0064Accident · No injuriesClosedStinson 108-1 · Fairbanks, AKOct 12, 1968 · N8724K · Substantial damage NTSB ANC69A0021Accident · Serious injuriesClosedAero Comdr 680 · Tin City, AKOct 12, 1968 · N401M · Substantial damage NTSB NYC69D0218Accident · No injuriesClosedHelicom SAH100 · Finleyville, PAOct 11, 1968 · N828Z · Substantial damage