Skip to content

NTSB investigations, 1977, NE

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MKC78FA016Accident · 2 fatalClosedLuscombe 8E · Gordon, NEDec 23, 1977 · N1226K · Destroyed NTSB MKC78DCJ07Accident · Minor injuriesClosedMooney M10 · Emerson, NEDec 16, 1977 · N9525V · Substantial damage NTSB MKC78DCJ06Accident · No injuriesClosedCessna 180 · Lakeside, NEDec 9, 1977 · N47249 · Substantial damage NTSB MKC78DCJ05Accident · Serious injuriesClosedMooney M10 · Wayne, NEDec 3, 1977 · N9548V · Destroyed NTSB MKC78FCJ04Accident · No injuriesClosedPiper PA-28R · Omaha, NENov 18, 1977 · N2241Q · Substantial damage NTSB MKC78FCJ03Accident · No injuriesClosedNavion NAV-A · Omaha, NENov 3, 1977 · N4955K · Substantial damage NTSB MKC78FA004Accident · 4 fatalClosedPiper PA-28 · Blair, NEOct 23, 1977 · N55184 · Destroyed NTSB MKC78FA002Accident · 2 fatalClosedGrumann AA-5A · Pierce, NEOct 23, 1977 · N9762U · Destroyed NTSB MKC78DCJ02Accident · No injuriesClosedCessna 150 · Hastings, NEOct 18, 1977 · N714RC · Substantial damage NTSB MKC78FCJ01Accident · No injuriesClosedPiper PA-30 · Atkinson, NEOct 15, 1977 · N8468Y · Substantial damage NTSB MKC78FCJ47Accident · No injuriesClosedCessna 310A · Lincoln, NESep 22, 1977 · N17U · Substantial damage NTSB MKC77DCJ46Accident · No injuriesClosedBeech 35-C33 · Mccook, NESep 10, 1977 · N887R · Substantial damage NTSB MKC77DCJ45Accident · No injuriesClosedCessna 150M · Angora, NESep 4, 1977 · N66553 · Substantial damage NTSB MKC77FCJ44Accident · No injuriesClosedCessna 150 · Papillion, NESep 1, 1977 · N63090 · Substantial damage NTSB MKC77FCJ43Accident · No injuriesClosedCessna 182 · North Platte, NEAug 20, 1977 · N71699 · Substantial damage NTSB MKC77DCJ42Accident · No injuriesClosedCallair A-9B · St.Paul, NEAug 20, 1977 · N7652V · Substantial damage NTSB MKC77FCJ41Accident · Serious injuriesClosedMooney M10 · South Sioux, NEAug 16, 1977 · N9507V · Destroyed NTSB MKC77FCJ37Accident · No injuriesClosedPiper PA-32 · Lincoln, NEAug 16, 1977 · N8674N · Substantial damage NTSB MKC77DCJ40Accident · No injuriesClosedCessna 170A · Arcadia, NEAug 16, 1977 · N747Z · Substantial damage NTSB MKC77DCJ39Accident · No injuriesClosedCessna 140 · Kimball, NEAug 14, 1977 · N72720 · Substantial damage NTSB MKC77DCJ38Accident · No injuriesClosedMooney M20E · Omaha, NEAug 14, 1977 · N5618Q · Substantial damage NTSB MKC77DCJ36Accident · No injuriesClosedPiper PA-20 · Grant, NEAug 4, 1977 · N7477K · Substantial damage NTSB MKC77DCJ34Accident · No injuriesClosedCessna 188B · Clearwater, NEJul 31, 1977 · N9081R · Substantial damage NTSB MKC77DCJ35Accident · No injuriesClosedPiper PA-18 · Cody, NEJul 30, 1977 · N83332 · Substantial damage NTSB MKC77DCJ33Accident · Minor injuriesClosedPiper PA-25 · Callaway, NEJul 29, 1977 · N9813P · Destroyed NTSB MKC77DCJ32Accident · Minor injuriesClosedCessna 188 · Trumbull, NEJul 27, 1977 · N6048G · Substantial damage NTSB MKC77FA031Accident · 3 fatalClosedBeech C35 C35 · Omaha, NEJul 24, 1977 · N1857D · Destroyed NTSB MKC77DCJ31Accident · No injuriesClosedCessna A188A · Rising City, NEJul 22, 1977 · N4408Q · Substantial damage NTSB MKC77DCJ30Accident · No injuriesClosedCessna 305A · Scottsbluff, NEJul 17, 1977 · N1FR · Substantial damage NTSB MKC77FCJ29Accident · No injuriesClosedStinson 108-2 · Scotts Bluff, NEJul 11, 1977 · N225C · Substantial damage NTSB MKC77FCJ28Accident · No injuriesClosedChampion 7GCAA · Neligh, NEJul 3, 1977 · N9093L · Substantial damage NTSB MKC77DCJ27Accident · No injuriesClosedBell 47G5A · Red Cloud, NEJun 29, 1977 · N7989J · Substantial damage NTSB MKC77DCJ26Accident · No injuriesClosedGrumman G-164A · Sidney, NEJun 28, 1977 · N48594 · Substantial damage NTSB MKC77DCJ25Accident · Minor injuriesClosedPiper PA-28 · Gothenburg, NEJun 22, 1977 · N57301 · Substantial damage NTSB MKC77DCJ24Accident · No injuriesClosedCessna 172 · Papillion, NEJun 10, 1977 · N39495 · Substantial damage NTSB MKC77FA024Accident · 4 fatalClosedCessna 172M · Gordon, NEJun 7, 1977 · N80078 · Destroyed NTSB MKC77DCJ23Accident · Minor injuriesClosedBellanca 8GCBC · Kearney, NEJun 4, 1977 · N88429 · Substantial damage NTSB MKC77DCJ22Accident · No injuriesClosedBell 206B · Wahoo, NEJun 2, 1977 · N59442 · Substantial damage NTSB MKC77DCJ21Accident · No injuriesClosedCessna 150 · Ashland, NEMay 28, 1977 · N704UK · Substantial damage NTSB MKC77FCJ20Accident · No injuriesClosedBell 47G · Elgin, NEMay 17, 1977 · N617X · Substantial damage NTSB MKC77DCJ19Accident · No injuriesClosedPiper PA-18A · Oshkosh, NEMay 12, 1977 · N3591A · Substantial damage NTSB MKC77DCJ48Accident · No injuriesClosedSportavia RF4-D · Central City, NEApr 28, 1977 · N7723 · Substantial damage NTSB MKC77DCJ18Accident · No injuriesClosedPiper PA-18 · Bassett, NEApr 25, 1977 · N9396D · Substantial damage NTSB MKC77FCJ17Accident · Serious injuriesClosedCessna T210L · Holdrege, NEApr 16, 1977 · N1727X · Substantial damage NTSB MKC77DCJ16Accident · No injuriesClosedCessna 175 · Omaha, NEApr 10, 1977 · N6560E · Substantial damage NTSB MKC77DCJ15Accident · No injuriesClosedPiper PA-22 · Whitman, NEMar 14, 1977 · N4812A · Substantial damage NTSB MKC77DCJ13Accident · No injuriesClosedCessna 120 · Weeping Water, NEMar 7, 1977 · N77048 · Substantial damage NTSB MKC77DCJ12Accident · No injuriesClosedCessna 185 · Lincoln, NEMar 6, 1977 · N9885X · Substantial damage NTSB MKC77FA016Accident · 2 fatalClosedBellanca 8KCAB · Valparaiso, NEFeb 26, 1977 · N53980 · Destroyed NTSB MKC77DCJ11Accident · No injuriesClosedGlobe GC-1B · Tekamah, NEFeb 9, 1977 · N3746K · Destroyed