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 SEA68D0237Accident · No injuriesClosedCessna 182 · Wenatchee, WADec 19, 1967 · N2846R · Substantial damage NTSB MKC68F0472Accident · No injuriesClosedCessna 175 · Fenton, MODec 19, 1967 · N7593M · Substantial damage NTSB MKC68D0384Accident · No injuriesClosedAero Comdr 100 · Broken Bow, NEDec 19, 1967 · N2931T · Substantial damage NTSB MIA68F0347Accident · Minor injuriesClosedCessna 210 · Bay Minette, ALDec 19, 1967 · N4803U · Substantial damage NTSB MIA68D0358Accident · Minor injuriesClosedCessna 172 · Dunedin, FLDec 19, 1967 · N8074L · Destroyed NTSB FTW68A0063Accident · 1 fatalClosedPiper PA-24 · Manvel, TXDec 19, 1967 · N6885P · Destroyed NTSB CHI68F0497Accident · No injuriesClosedCessna 310H · Cincinnati, OHDec 19, 1967 · N1068Q · 2 aircraft · Substantial damage NTSB CHI68F0491Accident · No injuriesClosedBeech 65-80 · Midland, MIDec 19, 1967 · N883J · Substantial damage NTSB CHI68D0539Accident · No injuriesClosedPiper PA-28 · Roselle, ILDec 19, 1967 · N9105W · Substantial damage NTSB CHI68D0521Accident · No injuriesClosedLuscombe 8E · Richmond, INDec 19, 1967 · N2632K · Substantial damage NTSB ANC68D0091Accident · No injuriesClosedPiper PA-18 · Anchorage, AKDec 19, 1967 · N3774Z · Substantial damage NTSB NYC68F0328Accident · No injuriesClosedPiper PA-23 · Winooski, VTDec 18, 1967 · N5691Y · Destroyed NTSB NYC68F0320Accident · No injuriesClosedCessna 337 · East Berlin, PADec 18, 1967 · N5355S · Substantial damage NTSB FTW68F0400Accident · No injuriesClosedCessna 15OF · Alexandria, LADec 18, 1967 · N8697S · Substantial damage NTSB FTW68F0399Accident · Minor injuriesClosedCessna 210C · Gatesville, TXDec 18, 1967 · N3928Y · Substantial damage NTSB DIA68D0142Accident · No injuriesClosedBeech A23 · Smyrna, DEDec 18, 1967 · N5782V · Substantial damage NTSB DIA68A0026Accident · 3 fatalClosedPiper PA-28 · Monroe, NCDec 18, 1967 · N7197W · Destroyed NTSB DEN68D0188Accident · No injuriesClosedPiper PA-28 · Clines Cnrs, NMDec 18, 1967 · N9671J · Substantial damage NTSB DEN68D0160Accident · No injuriesClosedBeech V35A · Clines Crns, NMDec 18, 1967 · N7087N · Substantial damage NTSB OAK68D0306Accident · No injuriesClosedPiper PA-18 · Davis, CADec 17, 1967 · N3374B · Substantial damage NTSB OAK68D0233Accident · No injuriesClosedPiper PA-22 · Crescnt Cty, CADec 17, 1967 · N3959P · Substantial damage NTSB NYC68F0313Accident · No injuriesClosedCessna 150G · Wallkill, NYDec 17, 1967 · N3346J · Substantial damage NTSB NYC68F0311Accident · No injuriesClosedPiper PA-28 · Skaneateles, NYDec 17, 1967 · N3921K · Substantial damage NTSB NYC68D0326Accident · Minor injuriesClosedPiper PA-23 · Sea Side Heght, NJDec 17, 1967 · N3005P · Substantial damage NTSB NYC68D0310Accident · No injuriesClosedCessna 172 · Groton, CTDec 17, 1967 · N5329T · Substantial damage NTSB NYC68A0080Accident · 2 fatalClosedPiper PA-28 · Stowe, PADec 17, 1967 · N8883W · Destroyed NTSB MIA68F0371Accident · No injuriesClosedPiper PA-28 · Hialeah, FLDec 17, 1967 · N6801W · Substantial damage NTSB MIA68F0333Accident · No injuriesClosedCessna 206 · Toa Baja, PRDec 17, 1967 · N4650F · Substantial damage NTSB MIA68D0349Accident · No injuriesClosedCessna 150 · Miami, FLDec 17, 1967 · N4218U · Substantial damage NTSB LAX68F0251Accident · Serious injuriesClosedBeech A45 · Corona, CADec 17, 1967 · N6978C · Destroyed NTSB LAX68D0302Accident · No injuriesClosedCessna 150 · Johannesburg, CADec 17, 1967 · N7178F · Substantial damage NTSB LAX68D0246Accident · No injuriesClosedPiper PA-28 · Carlsbad, CADec 17, 1967 · N5738W · Substantial damage NTSB DIA68F0138Accident · Serious injuriesClosedFairchild M-62A · Roaring River, NCDec 17, 1967 · N46151 · Destroyed NTSB DEN68F0180Accident · No injuriesClosedPiper PA-23 · Tucumcari, NMDec 17, 1967 · N2225P · Substantial damage NTSB CHI68F0513Accident · Minor injuriesClosedPorterfield LP-65 · Taylor Ridge, ILDec 17, 1967 · N37853 · Substantial damage NTSB CHI68F0503Accident · Minor injuriesClosedMooney M20C · Shadyside, OHDec 17, 1967 · N79800 · Substantial damage NTSB CHI68D0562Accident · No injuriesClosedPiper PA-23 · Cleveland, OHDec 17, 1967 · N4351P · Substantial damage NTSB UNK68X0113Accident · No injuriesClosedCessna 310 · Navojoa, MexicoDec 16, 1967 · N1793H · Minor damage NTSB SEA68F0233Accident · No injuriesClosedCessna 182C · Springfield, ORDec 16, 1967 · N8900T · Substantial damage NTSB OAK68F0254Accident · No injuriesClosedDehaviland DHC-6 · Honolulu, HIDec 16, 1967 · N8081N · Substantial damage NTSB OAK68D0316Accident · No injuriesClosedBeech 35 · Milford, CADec 16, 1967 · N3702N · Substantial damage NTSB NYC68D0312Accident · No injuriesClosedBeech A23 · New Bedford, MADec 16, 1967 · N5784V · Substantial damage NTSB NYC68A0079Accident · 4 fatalClosedPiper PA-28 · Bridgeport, CTDec 16, 1967 · N9736J · Destroyed NTSB MKC68F0391Accident · Minor injuriesClosedCessna 150 · Rosemount, MNDec 16, 1967 · N2484J · Substantial damage NTSB MKC68D0372Accident · No injuriesClosedPiper PA-22 · Marshalltown, IADec 16, 1967 · N6724B · Substantial damage NTSB MIA68D0506Accident · Minor injuriesClosedAero Comdr 100 · Brunswick, GADec 16, 1967 · N5540M · Destroyed NTSB MIA68D0369Accident · No injuriesClosedCessna 150 · Pell City, ALDec 16, 1967 · N3316J · Substantial damage NTSB LAX68D0262Accident · No injuriesClosedCessna 172A · Baker, CADec 16, 1967 · N7211T · Substantial damage NTSB DEN68D0194Accident · No injuriesClosedPiper PA-18A · Gillette, WYDec 16, 1967 · N4594A · Substantial damage NTSB DEN68D0182Accident · No injuriesClosedCessna 150 · Longmont, CODec 16, 1967 · N1901Z · Substantial damage