Skip to content

NTSB investigations, 1969, NE

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MKC70D0309Accident · No injuriesClosedPiper PA-23 · Grand Isle, NEDec 31, 1969 · N441RV · Substantial damage NTSB MKC70A0036Accident · 2 fatalClosedCessna 180 · Pierce, NEDec 28, 1969 · N9117C · Destroyed NTSB MKC70F0310Accident · Minor injuriesClosedCessna 210J · Beatrice, NEDec 22, 1969 · N3368S · Substantial damage NTSB MKC70F0300Accident · No injuriesClosedMooney M20E · Lincoln, NEDec 14, 1969 · N1219X · Substantial damage NTSB MKC70D0296Accident · No injuriesClosedCessna 310D · Omaha, NEDec 11, 1969 · N6933T · Substantial damage NTSB MKC70D0298Accident · No injuriesClosedCessna 170 · Beatrice, NEDec 8, 1969 · N4182V · Substantial damage NTSB MKC70D0284Accident · No injuriesClosedCessna 185A · Hershey, NENov 27, 1969 · N4062Y · Substantial damage NTSB MKC70D0270Accident · No injuriesClosedCessna 210B · Genoa, NENov 26, 1969 · N9743X · Substantial damage NTSB MKC70A0028Accident · 1 fatalClosedMooney M20C · Lakeside, NENov 17, 1969 · N5961Q · Destroyed NTSB MKC70D0276Accident · No injuriesClosedPiper J-3 · Burwell, NENov 16, 1969 · N32843 · Substantial damage NTSB MKC70D0262Accident · Minor injuriesClosedCessna 170 · Grand Island, NENov 10, 1969 · N4029V · Substantial damage NTSB MKC70F0259Accident · Minor injuriesClosedChampion 7FC · Crawford, NENov 8, 1969 · N7527E · Substantial damage NTSB MKC70A0024Accident · 2 fatalClosedAmer Avco AA-1 · Columbus, NENov 2, 1969 · N5729L · Destroyed NTSB MKC70A0023Accident · 3 fatalClosedCessna 182A · Chadron, NEOct 29, 1969 · N9988B · Destroyed NTSB MKC70D0254Accident · Minor injuriesClosedPiper PA-28 · Sidney, NEOct 27, 1969 · N6987W · Substantial damage NTSB MKC70F0241Accident · Minor injuriesClosedAeronca 65-TAL · Lincoln, NEOct 19, 1969 · N39358 · Substantial damage NTSB MKC70F0252Accident · Serious injuriesClosedBrantly B-2B · Lakeside, NEOct 17, 1969 · N2164U · Substantial damage NTSB MKC70D0219Accident · No injuriesClosedPiper PA-28 · Gothenburg, NESep 20, 1969 · N5521U · Substantial damage NTSB MKC70F0227Accident · No injuriesClosedCessna 177 · Gibbon, NESep 14, 1969 · N2923X · Substantial damage NTSB MKC70D0201Accident · Minor injuriesClosedTalorcraft BC12-D · Papillion, NESep 9, 1969 · N95998 · Substantial damage NTSB MKC70D0174Accident · Minor injuriesClosedPiper J3C-65 · Broken Bow, NESep 5, 1969 · N98422 · Substantial damage NTSB MKC70D0159Accident · Minor injuriesClosedCessna 150 · Ogallala, NESep 3, 1969 · N8250S · Substantial damage NTSB MKC70F0205Accident · Serious injuriesClosedCallair A-9B · Ithaca, NEAug 31, 1969 · N7264V · Substantial damage NTSB MKC70D0208Accident · No injuriesClosedPiper PA-28 · Niobrara, NEAug 30, 1969 · N7688W · Substantial damage NTSB MKC70A0007Accident · 1 fatalClosedPiper PA-22 · Loup City, NEAug 30, 1969 · N3306A · Destroyed NTSB MKC70F0156Accident · No injuriesClosedCessna 182C · Angora, NEAug 27, 1969 · N8756T · Substantial damage NTSB MKC70F0161Accident · No injuriesClosedCessna 172G · Anselmo, NEAug 21, 1969 · N3702L · Substantial damage NTSB MKC70D0133Accident · No injuriesClosedPiper PA-28 · Rockville, NEAug 15, 1969 · N4316J · Substantial damage NTSB MKC70F0120Accident · No injuriesClosedBeech 95-C55 · Lincoln, NEAug 11, 1969 · N8000Y · Substantial damage NTSB MKC70F0110Accident · No injuriesClosedCessna 182 · Agnew, NEAug 7, 1969 · N5798B · Substantial damage NTSB MKC70A0003Accident · 1 fatalClosedCessna 150 · Kearney, NEAug 5, 1969 · N2459J · Destroyed NTSB MKC70F0160Accident · No injuriesClosedCallair A-9B · Phillips, NEAug 4, 1969 · N7706V · Substantial damage NTSB MKC70F0132Accident · No injuriesClosedBell 47G3B1 · Hemingford, NEAug 4, 1969 · N73249 · Substantial damage NTSB MKC70D0138Accident · No injuriesClosedPiper PA-18 · Merriman, NEAug 1, 1969 · N2368A · Substantial damage NTSB MKC70D0114Accident · No injuriesClosedPiper PA-25 · Lexington, NEJul 27, 1969 · N6668Z · Substantial damage NTSB MKC70D0108Accident · No injuriesClosedPiper PA-28 · Bloomfield, NEJul 21, 1969 · N3670K · Substantial damage NTSB MKC70F0085Accident · Serious injuriesClosedBeech A23-24 · Tecumseh, NEJul 19, 1969 · N6129N · Substantial damage NTSB MKC70F0079Accident · No injuriesClosedCessna 172 · Nebraska Cty, NEJul 17, 1969 · N46325 · Substantial damage NTSB MKC70D0052Accident · No injuriesClosedErcoupe 415-G · S.Sioux City, NEJul 4, 1969 · N94421 · Substantial damage NTSB MKC70D0043Accident · Minor injuriesClosedStinson 108-2 · Papillion, NEJul 3, 1969 · N9447K · Substantial damage NTSB MKC70D0062Accident · Serious injuriesClosedPiper PA-18 · Hayes Center, NEJul 2, 1969 · N3834Z · Destroyed NTSB MKC70D0112Accident · No injuriesClosedGlobe GC-1B · Norfolk, NEJun 29, 1969 · N2351B · Substantial damage NTSB MKC70D0027Accident · No injuriesClosedPiper PA-25 · Seward, NEJun 21, 1969 · N6069Z · Substantial damage NTSB MKC70F0038Accident · No injuriesClosedPiper PA-24 · Kearney, NEJun 19, 1969 · N6278P · Substantial damage NTSB OAK70F0040Accident · No injuriesClosedCessna TU206A · Lincoln, NEJun 14, 1969 · N4904F · Substantial damage NTSB MKC70D0028Accident · Minor injuriesClosedPiper PA-22 · Madrid, NEJun 13, 1969 · N7594D · Substantial damage NTSB MKC70D0026Accident · No injuriesClosedPiper PA-28 · Alliance, NEJun 9, 1969 · N6328R · Substantial damage NTSB MKC69F0461Accident · No injuriesClosedPiper PA-28 · Wahoo, NEJun 5, 1969 · N5256W · Substantial damage NTSB MKC70F0019Accident · 1 fatalClosedPiper PA-18 · Carleton, NEJun 4, 1969 · N3846Z · Destroyed NTSB MKC69D0475Accident · No injuriesClosedBeech A23-24 · Bloomfield, NEJun 3, 1969 · N5693S · Substantial damage