Skip to content

NTSB investigations, 1968, NE

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year

19622026

NTSB investigations, 1968, NE per year, 1962–2026: 1,895 cases
1962	1
1964	58
1965	67
1966	72
1967	89
1968	80
1969	88
1970	74
1971	93
1972	64
1973	52
1974	71
1975	47
1976	64
1977	52
1978	49
1979	41
1980	36
1981	34
1982	42
1983	39
1984	40
1985	31
1986	27
1987	21
1988	16
1989	22
1990	13
1991	24
1992	20
1993	21
1994	20
1995	16
1996	14
1997	14
1998	28
1999	23
2000	13
2001	19
2002	14
2003	12
2004	11
2005	15
2006	17
2007	11
2008	13
2009	15
2010	13
2011	7
2012	21
2013	11
2014	11
2015	11
2016	10
2017	9
2018	12
2019	13
2020	9
2021	9
2022	14
2023	10
2024	17
2025	11
2026	4

Where

Latest cases

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 AND c."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA' 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
    AND c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
  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
  AND c."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA'
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 MKC69D0314Accident · No injuriesClosedHawker-Sdly DH 125 · Lincoln, NEDec 31, 1968 · N700M · Substantial damage NTSB MKC69D0385Accident · Minor injuriesClosedPiper J3C-65 · Ewing, NEDec 11, 1968 · N31026 · Destroyed NTSB MKC69D0288Accident · No injuriesClosedLuscombe 8E · Omaha, NEDec 4, 1968 · N2780K · Substantial damage NTSB MKC69D0272Accident · No injuriesClosedCessna 172G · Hartington, NENov 22, 1968 · N5945R · Substantial damage NTSB MKC69D0267Accident · No injuriesClosedBeech A23 · Millard, NENov 11, 1968 · N4753J · Substantial damage NTSB MKC69D0281Accident · No injuriesClosedPiper PA-28 · Alliance, NENov 3, 1968 · N5729W · Substantial damage NTSB MKC69F0274Accident · Minor injuriesClosedCessna 337B · Fullerton, NEOct 29, 1968 · N2334S · Substantial damage NTSB MKC69F0236Accident · No injuriesClosedPiper PA-28 · Western, NEOct 17, 1968 · N9419W · Substantial damage NTSB MKC69A0021Accident · 1 fatalClosedCessna 195B · Loup City, NEOct 9, 1968 · N502E · Destroyed NTSB MKC69F0224Accident · Serious injuriesClosedTaylorcraft BC12 · Hershey, NESep 23, 1968 · N36460 · Substantial damage NTSB MKC69F0147Accident · No injuriesClosedCessna 140 · Thedford, NESep 10, 1968 · N89640 · Substantial damage NTSB MKC69D0209Accident · No injuriesClosedCessna 177 · Milford, NESep 6, 1968 · N29462 · Substantial damage NTSB MKC69D0133Accident · No injuriesClosedCessna 170B · Scottsbluff, NESep 1, 1968 · N8379A · Substantial damage NTSB MKC69F0171Accident · No injuriesClosedMooney M20G · Oxford, NEAug 31, 1968 · N3672N · Substantial damage NTSB MKC69F0111Accident · No injuriesClosedCessna 150G · Saronville, NEAug 27, 1968 · N3468J · Substantial damage NTSB MKC69F0148Accident · No injuriesClosedPiper PA-25 · David City, NEAug 25, 1968 · N7392Z · Substantial damage NTSB MKC69D0122Accident · No injuriesClosedCessna 182K · Arthur, NEAug 25, 1968 · N2679R · Substantial damage NTSB MKC69D0120Accident · No injuriesClosedCessna 170 · Sargent, NEAug 25, 1968 · N2782C · Substantial damage NTSB MKC69D0112Accident · No injuriesClosedCessna A188 · Aurora, NEAug 16, 1968 · N8090V · Substantial damage NTSB MKC69D0055Accident · No injuriesClosedCessna 172 · Exeter, NEAug 11, 1968 · N5133A · Substantial damage NTSB MKC69F0087Accident · No injuriesClosedCessna 188 · Elgin, NEAug 4, 1968 · N9803V · Substantial damage NTSB MKC69D0110Accident · No injuriesClosedChampion 7GCBC · Alliance, NEAug 4, 1968 · N771MR · Substantial damage NTSB MKC69F0102Accident · No injuriesClosedCessna 150 · North Platte, NEAug 3, 1968 · N6241R · Substantial damage NTSB MKC69A0007Accident · Serious injuriesClosedAeronca 7AC · Lexington, NEAug 3, 1968 · N2966E · 2 aircraft · Destroyed NTSB MKC69F0091Accident · No injuriesClosedCallair A-9A · Chapman, NEAug 2, 1968 · N7298V · Substantial damage NTSB MKC69D0105Accident · No injuriesClosedPiper PA-25 · Mccool Jct., NEAug 2, 1968 · N6153Z · Substantial damage NTSB MKC69F0101Accident · Minor injuriesClosedCallair A-6 · Weston, NEAug 1, 1968 · N2910G · Substantial damage NTSB MKC69D0100Accident · No injuriesClosedPiper PA-28 · Clearwater, NEJul 30, 1968 · N9150W · Substantial damage NTSB MKC69F0058Accident · No injuriesClosedPiper PA-18 · Sutton, NEJul 26, 1968 · N7476D · Substantial damage NTSB MKC69I0003Incident · Minor injuriesClosedConvair 580 · Pawnee City, NEJul 23, 1968 · N73121 · No damage NTSB MKC69F0208Accident · No injuriesClosedCessna 310C · Omaha, NEJul 23, 1968 · N6699B · Substantial damage NTSB MKC69D0121Accident · No injuriesClosedCessna 210 · York, NEJul 23, 1968 · N9454T · Substantial damage NTSB MKC69D0067Accident · No injuriesClosedChampion 7GCBC · Merriman, NEJul 23, 1968 · N5130T · Substantial damage NTSB MKC69F0050Accident · No injuriesClosedPiper PA-28 · Schuyler, NEJul 22, 1968 · N9458J · Substantial damage NTSB MKC69D0092Accident · No injuriesClosedCessna 150 · No.Platte, NEJul 19, 1968 · N8209F · Substantial damage NTSB MKC69F0040Accident · No injuriesClosedPiper PA-20 · Fort Calhoun, NEJul 13, 1968 · N7044K · Substantial damage NTSB MKC69F0039Accident · No injuriesClosedBellanca 14-19 · Falls City, NEJul 13, 1968 · N8543R · Substantial damage NTSB MKC69F0042Accident · Minor injuriesClosedCessna 150 · Agnew, NEJul 7, 1968 · N6212R · Substantial damage NTSB MKC69F0054Accident · Minor injuriesClosedAlon A-2 · Gretna, NEJun 30, 1968 · N5484F · Destroyed NTSB MKC69D0049Accident · No injuriesClosedPiper PA-25 · Guide Rock, NEJun 28, 1968 · N6362Z · Substantial damage NTSB MKC69D0038Accident · Minor injuriesClosedPiper PA-18A · Naper, NEJun 18, 1968 · N3397B · Destroyed NTSB MKC69D0022Accident · No injuriesClosedBeech S35 · Scribner, NEJun 14, 1968 · N5887S · Substantial damage NTSB MKC69F0004Accident · No injuriesClosedPiper PA-24 · Norfolk, NEJun 11, 1968 · N6985P · Substantial damage NTSB MKC69F0023Accident · No injuriesClosedCessna 177 · Omaha, NEJun 4, 1968 · N2923X · Substantial damage NTSB MKC69D0043Accident · No injuriesClosedPiper PA-28 · Ellsworth, NEJun 2, 1968 · N5953W · Substantial damage NTSB MKC68D0584Accident · Minor injuriesClosedPiper PA-22 · Alliance, NEJun 2, 1968 · N877A · Substantial damage NTSB MKC68D0579Accident · No injuriesClosedCessna 177 · Columbus, NEJun 2, 1968 · N3103T · Substantial damage NTSB MKC68D0589Accident · No injuriesClosedCessna 150 · Syracuse, NEMay 31, 1968 · N6937F · Substantial damage NTSB MKC69F0019Accident · Serious injuriesClosedRyan ST-3KR · Papillion, NEMay 30, 1968 · N48758 · Destroyed NTSB MKC68F0605Accident · No injuriesClosedCessna 150 · Lincoln, NEMay 30, 1968 · N3118J · Substantial damage