Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 MKC80DCJ04Accident · No injuriesClosedCessna 172 · Harrison, NEDec 9, 1979 · N3799R · Substantial damage NTSB MKC80FA010Accident · 6 fatalClosedPiper PA-23 · Columbus, NENov 25, 1979 · N6496Y · Destroyed NTSB MKC80DCJ17Accident · No injuriesClosedCessna 185F · Lyons, NENov 23, 1979 · N80873 · Substantial damage NTSB MKC80DCJ03Accident · Minor injuriesClosedNavion B · Norfolk, NENov 23, 1979 · N5177K · Substantial damage NTSB MKC80FCJ02Accident · Minor injuriesClosedCessna 150J · Nebraska City, NENov 17, 1979 · N50467 · Substantial damage NTSB MKC79DCJ01Accident · Minor injuriesClosedCessna 150 · O'Neill, NEOct 10, 1979 · N7959F · Substantial damage NTSB MKC79DCJ39Accident · No injuriesClosedPiper PA-28 · Omaha, NESep 23, 1979 · N54435 · Substantial damage NTSB MKCM.FA059Accident · No injuriesClosedBeech 36 · Bassett, NESep 21, 1979 · N50NB · Substantial damage NTSB MKC79FA052Accident · 1 fatalClosedMong Sport MS-2 · Sidney, NESep 6, 1979 · N563A · Destroyed NTSB MKC79DCJ38Accident · No injuriesClosedBeech C23 · O'Neill, NEAug 24, 1979 · N6014M · Substantial damage NTSB MKC79DCJ37Accident · Minor injuriesClosedPiper PA-28 · Hartington, NEAug 17, 1979 · N754WW · Substantial damage NTSB MKC79DCJ35Accident · No injuriesClosedCessna 177RG · North Platte, NEAug 12, 1979 · N33281 · Substantial damage NTSB MKC79DCJ34Accident · No injuriesClosedPiper PA-32 · Hay Springs, NEAug 11, 1979 · N3397W · Substantial damage NTSB MKC79DCJ33Accident · Minor injuriesClosedPiper PA-28 · Hay Springs, NEAug 11, 1979 · N4513R · Substantial damage NTSB MKC79DCJ36Accident · No injuriesClosedCessna P206A · Kearney, NEAug 10, 1979 · N2679X · Substantial damage NTSB MKC79DCJ30Accident · No injuriesClosedEnstrom F28C · Auburn, NEJul 28, 1979 · N51717 · Substantial damage NTSB MKC79FCJ31Accident · No injuriesClosedHughes 269C · Shelton, NEJul 27, 1979 · N58320 · Substantial damage NTSB MKC79DCJ27Accident · Minor injuriesClosedPiper PA-25 · Kearney, NEJul 17, 1979 · N4865Y · Substantial damage NTSB MKC79DCJ26Accident · No injuriesClosedCessna 188A · Bassett, NEJul 15, 1979 · N8131V · Substantial damage NTSB MKC79DCJ29Accident · No injuriesClosedCessna A188B · Hartington, NEJul 12, 1979 · N9275R · Substantial damage NTSB MKC79DCJ28Accident · No injuriesClosedCallair A-9 · Kimball, NEJul 12, 1979 · N8294H · Substantial damage NTSB MKC79DCJ25Accident · Minor injuriesClosedCessna 172 · Omaha, NEJun 30, 1979 · N5520D · Destroyed NTSB MKC79DCJ24Accident · No injuriesClosedCessna 177B · Haigler, NEJun 26, 1979 · N30782 · Substantial damage NTSB MKC79FCJ23Accident · Serious injuriesClosedBeech H35 · Wilcox, NEJun 14, 1979 · N5426D · Destroyed NTSB MKC79DCJ22Accident · No injuriesClosedGrumman AA5A · Oneill, NEJun 2, 1979 · N9910U · Substantial damage NTSB MKC79FCJ20Accident · Serious injuriesClosedCessna 172A · Anselmo, NEMay 19, 1979 · N6842X · Substantial damage NTSB MKC79DCJ21Accident · No injuriesClosedPiper PA-25 · Hemingford, NEMay 19, 1979 · N6765Z · Substantial damage NTSB MKC79DCJ19Accident · No injuriesClosedCessna 188 · Huntley, NEMay 18, 1979 · N4807R · Substantial damage NTSB MKC79FCJ18Accident · No injuriesClosedCessna 170A · Sidney, NEMay 6, 1979 · N747Z · Substantial damage NTSB MKC79FCJ17Accident · No injuriesClosedBeech B24R · Bertrand, NEMay 6, 1979 · N9345S · Substantial damage NTSB MKC79FCJ16Accident · No injuriesClosedAerospatle 341G · York, NEApr 28, 1979 · N341FR · Substantial damage NTSB MKC79DCJ15Accident · Minor injuriesClosedCessna 150 · Weeping Water, NEApr 22, 1979 · N8085S · Substantial damage NTSB MKC79DCD17Accident · No injuriesClosedCessna 150 · Omaha, NEApr 22, 1979 · N17033 · Substantial damage NTSB MKC79DCJ14Accident · No injuriesClosedPiper PA-18 · North Platte, NEApr 21, 1979 · N57753 · Substantial damage NTSB MKC79DCJ13Accident · Minor injuriesClosedCessna 150 · Tecumseh, NEApr 14, 1979 · N2809S · Substantial damage NTSB MKC79DCJ12Accident · No injuriesClosedCessna 172 · Kearney, NEMar 13, 1979 · N8945V · Substantial damage NTSB MKC79FCJ09Accident · No injuriesClosedCessna 414A · Lincoln, NEFeb 17, 1979 · N30FB · Substantial damage NTSB MKC79DCJ10Accident · No injuriesClosedPiper PA-32R · Ainsworth, NEFeb 16, 1979 · N2174A · Substantial damage NTSB MKC79DCJ11Accident · No injuriesClosedCessna 185 · York, NEFeb 14, 1979 · N5172R · Substantial damage NTSB MKC79FA016Accident · 2 fatalClosedCessna 180J · Blair, NEJan 22, 1979 · N7836K · Destroyed NTSB MKC79FCJ07Accident · No injuriesClosedCessna 177A · Holland, NEJan 1, 1979 · N30288 · Substantial damage