Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MKC71DCJ36Accident · No injuriesClosedCessna 172E · Ewing, NEDec 31, 1970 · N3948S · Substantial damage NTSB MKC71DCJ35Accident · No injuriesClosedCessna 182 · Ewing, NEDec 26, 1970 · N71754 · Substantial damage NTSB MKC71FCJ34Accident · No injuriesClosedBeech K35 · Sidney, NEDec 24, 1970 · N6002E · Substantial damage NTSB MKC71DCJ33Accident · Minor injuriesClosedPiper J3C-65 · Indianola, NEDec 13, 1970 · N92449 · Substantial damage NTSB MKC71FCJ31|MKC71FCJ32Accident · No injuriesClosedCessna 150 · Columbus, NEDec 6, 1970 · N60327 · 2 aircraft · Substantial damage NTSB MKC71DCJ29Accident · No injuriesClosedErcoupe 415-E · Harvard, NEDec 3, 1970 · N94840 · Substantial damage NTSB MKC71FCJ30Accident · No injuriesClosedBeech V35A · Omaha, NENov 27, 1970 · N388WE · Substantial damage NTSB MKC71IK026Incident · Minor injuriesClosedConvair 580 · Lincoln, NENov 3, 1970 · N73102 · Minor damage NTSB MKC71FCJ27Accident · Serious injuriesClosedPiper PA-28 · Auburn, NEOct 24, 1970 · N1503J · Destroyed NTSB MKC71DCJ26Accident · No injuriesClosedPiper PA-28 · Hartington, NEOct 17, 1970 · N9145J · Substantial damage NTSB MKC71AK019Accident · 1 fatalClosedPiper PA-28R · Sidney, NEOct 16, 1970 · N5026S · Destroyed NTSB MKC71FCJ25Accident · Serious injuriesClosedPiper PA-22 · Atkinson, NEOct 10, 1970 · N4402A · Substantial damage NTSB MKC71DCJ24Accident · No injuriesClosedBeech 95-C55 · Omaha, NEOct 3, 1970 · N9591Q · Substantial damage NTSB MKC71FCJ23Accident · Minor injuriesClosedCessna 172 · Pleasnt Dale, NESep 30, 1970 · N5602T · Substantial damage NTSB MKC71DCJ22Accident · No injuriesClosedPiper PA-24 · North Platte, NESep 13, 1970 · N7170P · Substantial damage NTSB MKC71FCJ21Accident · No injuriesClosedStinson 108-1 · Lincoln, NESep 7, 1970 · N9059K · Substantial damage NTSB MKC71FCJ19Accident · No injuriesClosedCessna 421A · Beatrice, NESep 1, 1970 · N3392Q · Substantial damage NTSB MKC71DCJ20Accident · No injuriesClosedCessna 182E · Imperial, NEAug 23, 1970 · N9350X · Substantial damage NTSB MKC71FCJ18Accident · No injuriesClosedCessna 210 · Minden, NEAug 21, 1970 · N3961Y · Substantial damage NTSB MKC71FCJ16Accident · No injuriesClosedCessna 140 · Lincoln, NEAug 10, 1970 · N2400V · Substantial damage NTSB MKC71AK008Accident · 1 fatalClosedPiper PA-18 · Merriman, NEAug 9, 1970 · N9060D · Destroyed NTSB MKC71AK006Accident · 4 fatalClosedCessna 182L · Pierce, NEAug 8, 1970 · N3364R · Destroyed NTSB MKC71DCJ17Accident · No injuriesClosedPiper PA-22 · Humphrey, NEAug 7, 1970 · N6025D · Substantial damage NTSB MKC71FCG15Accident · No injuriesClosedChampion 7FC · Springfield, NEAug 6, 1970 · N8901R · Substantial damage NTSB MKC71FCJ14Accident · 1 fatalClosedPiper PA-25 · Minden, NEAug 4, 1970 · N8580L · Destroyed NTSB MKC71FCJ12Accident · No injuriesClosedPiper PA-28 · Bassett, NEAug 1, 1970 · N4151J · Substantial damage NTSB MKC71FCJ10Accident · No injuriesClosedCessna 182L · Lincoln, NEJul 30, 1970 · N42823 · Substantial damage NTSB MKC71DCJ13Accident · No injuriesClosedCessna 188A · Oxford, NEJul 30, 1970 · N3538Q · Substantial damage NTSB MKC71FCJ11Incident · No injuriesClosedPiper PA-25 · Gothenburg, NEJul 28, 1970 · N8626L · Minor damage NTSB MKC71FCJ09Accident · No injuriesClosedCallair A-9B · Giltner, NEJul 27, 1970 · N7706V · Substantial damage NTSB MKC71DCJ08Accident · No injuriesClosedErco 415-C · Wahoo, NEJul 26, 1970 · N87421 · Substantial damage NTSB MKC71DCJ07Accident · No injuriesClosedMooney M20C · Sutherland, NEJul 23, 1970 · N78874 · Substantial damage NTSB MKC71DCJ06Accident · No injuriesClosedPiper PA-18 · Shickley, NEJul 18, 1970 · N4719A · Substantial damage NTSB MKC71FCJ05Accident · No injuriesClosedMooney M20C · Davenport, NEJul 15, 1970 · N9257M · Substantial damage NTSB MKC71DCJ04Accident · No injuriesClosedBoeing B75N1 · Franklin, NEJul 13, 1970 · N5527N · Substantial damage NTSB MKC71AK001Accident · 2 fatalClosedPiper PA-20 · Mullen, NEJul 12, 1970 · N7088K · Destroyed NTSB MKC71FCJ03Accident · No injuriesClosedPiper PA-28R · Deshler, NEJul 9, 1970 · N2900R · Substantial damage NTSB MKC71FCJ02Accident · No injuriesClosedBeech G35 · Beatrice, NEJul 8, 1970 · N3898B · Substantial damage NTSB MKC71FCJ01Accident · Minor injuriesClosedCessna 172 · Millard, NEJul 7, 1970 · N8271B · Destroyed NTSB MKC70DCJ32Accident · No injuriesClosedPiper PA-28 · S.Sioux City, NEJun 25, 1970 · N8259N · Substantial damage NTSB MKC70DCJ33Accident · No injuriesClosedCessna 150 · Lincoln, NEJun 24, 1970 · N3314J · Substantial damage NTSB MKC70DCJ29Accident · Minor injuriesClosedPiper PA-25 · Elwood, NEJun 21, 1970 · N6714Z · Substantial damage NTSB MKC70FCJ28Accident · No injuriesClosedMooney M20F · Lincoln, NEJun 20, 1970 · N9318V · Substantial damage NTSB MKC70DCJ31Accident · No injuriesClosedPiper PA-32 · Taylor, NEJun 19, 1970 · N3332W · Substantial damage NTSB MKC70DCJ30Accident · No injuriesClosedCessna 170B · Wolbach, NEJun 14, 1970 · N2442D · Substantial damage NTSB MKC70DCJ27Accident · No injuriesClosedBell 47D1 · David City, NEJun 4, 1970 · N903B · Substantial damage NTSB MKC70FCJ25Accident · No injuriesClosedPiper PA-24 · Sidney, NEMay 29, 1970 · N5516P · Destroyed NTSB MKC70FCJ26Accident · No injuriesClosedPiper PA-25 · Gurley, NEMay 26, 1970 · N4445Y · Substantial damage NTSB MKC70FCJ23Accident · No injuriesClosedBeech A23A · Loup City, NEMay 24, 1970 · N2307W · Substantial damage NTSB MKC70DCJ24Accident · No injuriesClosedPiper PA-18 · Clay Center, NEMay 23, 1970 · N4252Z · Substantial damage