Skip to content

NTSB investigations, 1969

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") = 1969 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\") = 1969
  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") = 1969
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 MIA70F0252Accident · No injuriesClosedPiper PA-28 · Bolton, MSDec 14, 1969 · N7261F · Substantial damage NTSB MIA70D0245Accident · Minor injuriesClosedPiper PA-28 · Jenkinsville, SCDec 14, 1969 · N1829J · Substantial damage NTSB IAD70D0114Accident · No injuriesClosedPiper PA-32 · Mint Hill, NCDec 14, 1969 · N3502W · Substantial damage NTSB FTW70F0341Accident · No injuriesClosedLuscombe 8D · Weatherford, TXDec 14, 1969 · N39067 · Substantial damage NTSB FTW70D0327Accident · No injuriesClosedLuscombe 8A · Wagoner, OKDec 14, 1969 · N2140K · Substantial damage NTSB DEN70F0154Accident · No injuriesClosedCessna 310B · Salt Lake City, UTDec 14, 1969 · N1113T · Substantial damage NTSB DEN70A0040Accident · Serious injuriesClosedCessna 310 · Fort Stantn, NMDec 14, 1969 · N1122B · Destroyed NTSB SEA70I0024Incident · No injuriesClosedBoeing 747 · Renton, WADec 13, 1969 · N732PA · Minor damage NTSB SEA70D0144Accident · No injuriesClosedAero Comdr 520 · Salem, ORDec 13, 1969 · N2622B · Substantial damage NTSB NYC70D0230Accident · No injuriesClosedCessna 150F · Wellsboro, PADec 13, 1969 · N7933F · Substantial damage NTSB NYC70A0063Accident · Serious injuriesClosedBoeing 727 · Pittsburgh, PADec 13, 1969 · N8158G · No damage NTSB MKC70F0290Accident · No injuriesClosedCessna 150H · Winterset, IADec 13, 1969 · N6796S · Substantial damage NTSB MKC70D0302Accident · No injuriesClosedCessna 182G · Marshalltown, IADec 13, 1969 · N2467R · Substantial damage NTSB IAD70D0124Accident · Minor injuriesClosedCessna 150 · Poca, WVDec 13, 1969 · N5662G · Substantial damage NTSB FTW70F0329Accident · No injuriesClosedCessna 182 · Bay City, TXDec 13, 1969 · N92099 · Substantial damage NTSB DEN70D0153Accident · No injuriesClosedCessna 172 · Gallup, NMDec 13, 1969 · N3826L · No damage NTSB CHI70F0360Accident · No injuriesClosedCessna 170B · Carleton, MIDec 13, 1969 · N3530C · Destroyed NTSB CHI70D0399Accident · Serious injuriesClosedCessna 172 · Wadsworth, OHDec 13, 1969 · N46727 · Substantial damage NTSB ANC70D0085Accident · No injuriesClosedCessna 172 · Fairbanks, AKDec 13, 1969 · N8039X · Substantial damage NTSB NYC70F0234Accident · No injuriesClosedAmer Avco AA-1 · Norwood, MADec 12, 1969 · N5620L · Substantial damage NTSB MIA70F0306Accident · Minor injuriesClosedAero Comdr 200-D · Ashburn, GADec 12, 1969 · N2900T · Substantial damage NTSB MIA70D0268Accident · No injuriesClosedPiper PA-30 · Hattiesburg, MSDec 12, 1969 · N8768Y · Substantial damage NTSB FTW70F0320Accident · No injuriesClosedPiper PA-24 · Crane, TXDec 12, 1969 · N5697P · Substantial damage NTSB FTW70A0041Accident · 1 fatalClosedChampion 7ECA · Jeanerette, LADec 12, 1969 · N1875G · Destroyed NTSB DEN70D0152Accident · No injuriesClosedCessna 172 · Moriarty, NMDec 12, 1969 · N8292X · Substantial damage NTSB CHI70F0400Accident · No injuriesClosedCessna 182K · Chicago, ILDec 12, 1969 · N8555S · Substantial damage NTSB CHI70F0362Accident · No injuriesClosedCessna 182M · New Albany, INDec 12, 1969 · N71886 · Substantial damage NTSB OAK72AP007Accident · 2 fatalClosedNavion B · Etna, CADec 11, 1969 · N4600K · Destroyed NTSB OAK70F0193Accident · Serious injuriesClosedBeech 36 · Mammoth Lks, CADec 11, 1969 · N7847R · Substantial damage NTSB NYC70I0062Incident · No injuriesClosedFairchild FH-227 · Windsor Lock, CTDec 11, 1969 · N378NE · Minor damage NTSB NYC70D0228Accident · No injuriesClosedCessna 120 · Hancocks Brdge, NJDec 11, 1969 · N72147 · Substantial damage NTSB MKC70D0296Accident · No injuriesClosedCessna 310D · Omaha, NEDec 11, 1969 · N6933T · Substantial damage NTSB MIA70F0263Accident · Minor injuriesClosedLuscombe 8E · Largo, FLDec 11, 1969 · N1399B · Substantial damage NTSB MIA70A0048Accident · 1 fatalClosedCessna 210B · Mountain Cty, TNDec 11, 1969 · N38T · Destroyed NTSB LAX70A0035Accident · 2 fatalClosedCessna 150 · Sn Clemente, CADec 11, 1969 · N2426J · Destroyed NTSB LAX70A0033Accident · 2 fatalClosedBeech D95A · Big Sur, CADec 11, 1969 · N8619M · Destroyed NTSB IAD70D0116Accident · No injuriesClosedPiper PA-28 · Clinton, MDDec 11, 1969 · N9879W · Substantial damage NTSB FTW70F0345Accident · Serious injuriesClosedHughes 269A · Aiken, TXDec 11, 1969 · N8945F · Destroyed NTSB SEA70F0138Accident · Minor injuriesClosedCessna 172 · Port Townsnd, WADec 10, 1969 · N8692U · Destroyed NTSB SEA70D0120Accident · No injuriesClosedPiper PA-22 · Burley, IDDec 10, 1969 · N6729B · Substantial damage NTSB NYC70D0002Accident · No injuriesClosedHiller Acft FH1100 · Pt Washington, NYDec 10, 1969 · N515FH · Substantial damage NTSB NYC70A0061Accident · 3 fatalClosedPiper PA-23 · Passadumkeag, MEDec 10, 1969 · N5090Y · Destroyed NTSB MKC70A0032Accident · 2 fatalClosedBeech J35 · Barnesville, MNDec 10, 1969 · N8325D · Destroyed NTSB MIA70A0046Accident · No injuriesClosedBeech E18S · Montgomery, ALDec 10, 1969 · N679T · Substantial damage NTSB CHI70F0364Accident · No injuriesClosedCessna 150G · Cahokia, ILDec 10, 1969 · N3086S · Substantial damage NTSB ANC70I0047Incident · No injuriesClosedLockheed Ga 382B · Prudhoe Bay, AKDec 10, 1969 · N920NA · Minor damage NTSB SEA70D0124Accident · No injuriesClosedMaule M-4 · Great Falls, MTDec 9, 1969 · N9830M · Substantial damage NTSB NYC70F0237Accident · No injuriesClosedCessna 150G · Johnstown, PADec 9, 1969 · N2831S · Substantial damage NTSB MKC70D0301Accident · No injuriesClosedCessna 310P · Pocahontas, IADec 9, 1969 · N5733M · Substantial damage NTSB MIA70A0045Accident · No injuriesClosedCurtiss-Wrt C-46F · Tampa, FLDec 9, 1969 · N67938 · Substantial damage