Skip to content

NTSB investigations, 1975, NE

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 MKC76DCJ20Accident · No injuriesClosedCessna 150 · Omaha, NEDec 19, 1975 · N7959F · Substantial damage NTSB MKC76FCJ19Accident · Serious injuriesClosedPiper J-3 · Neligh, NEDec 9, 1975 · N42511 · Destroyed NTSB MKC76DCJ18Accident · No injuriesClosedPiper PA-18 · Merriman, NENov 22, 1975 · N3820Z · Substantial damage NTSB MKC76DCJ17Accident · No injuriesClosedPiper PA-28R · Lincoln, NENov 5, 1975 · N41890 · Substantial damage NTSB MKC76FCJ16Accident · Serious injuriesClosedPiper PA-25 · Aurora, NEOct 14, 1975 · N6113Z · Destroyed NTSB MKC76FCJ15Accident · No injuriesClosedCessna 150 · Wayne, NEOct 10, 1975 · N3244X · Substantial damage NTSB MKC76FCJ14Accident · No injuriesClosedPiper PA-28 · Utica, NEOct 5, 1975 · N41371 · Substantial damage NTSB MKC76DCJ13Accident · Minor injuriesClosedPiper PA-28 · Oshkosh, NESep 20, 1975 · N9210J · Substantial damage NTSB MKC76AK017Accident · 1 fatalClosedRyan Navion · Burwell, NESep 7, 1975 · N4232K · Destroyed NTSB MKC76DCJ12Accident · No injuriesClosedPiper PA-32 · Ravenna, NESep 3, 1975 · N3233W · Substantial damage NTSB MKC76DCJ11Accident · No injuriesClosedCessna 188 · Winnebago, NEAug 23, 1975 · N9157R · Substantial damage NTSB MKC76FCJ10Accident · Serious injuriesClosedPiper PA-25 · Champion, NEAug 10, 1975 · N6048Z · Destroyed NTSB MKC76DCJ08Accident · No injuriesClosedPiper PA-25 · Benedict, NEAug 3, 1975 · N6454Z · Substantial damage NTSB MKC76FCJ07Accident · No injuriesClosedCessna 188 · Auburn, NEJul 29, 1975 · N5609J · Substantial damage NTSB MKC76DCJ06Accident · No injuriesClosedAero-Comdr A-9 · Palmer, NEJul 27, 1975 · N7775V · Substantial damage NTSB MKC76DCJ09Accident · No injuriesClosedPiper PA-25 · Minden, NEJul 24, 1975 · N8640L · Substantial damage NTSB MKC76DCJ05Accident · No injuriesClosedAeronca 7AC · Big Springs, NEJul 22, 1975 · N84555 · Substantial damage NTSB MKC76FCJ04Accident · No injuriesClosedPiper PA-18 · Hebron, NEJul 20, 1975 · N3985Z · Substantial damage NTSB MKC76FCJ03Accident · Minor injuriesClosedPiper PA-25 · Waco, NEJul 13, 1975 · N6481Z · Substantial damage NTSB MKC76DCJ02Accident · Minor injuriesClosedPiper PA-25 · Bushnell, NEJul 11, 1975 · N7061Z · Substantial damage NTSB MKC76AK005Accident · 2 fatalClosedLuscombe 8A · Wilber, NEJul 7, 1975 · N7794L · Destroyed NTSB MKC76FCJ01Accident · 1 fatalClosedPiper PA-25 · O Neill, NEJul 3, 1975 · N6361Z · Destroyed NTSB MKC76AK001Accident · 1 fatalClosedCessna 182P · Ashland, NEJul 2, 1975 · N106X · Destroyed NTSB MKC75DCJ62Accident · No injuriesClosedPiper PA-18A · Danbury, NEJun 30, 1975 · N8172D · Destroyed NTSB MKC75DCJ61Accident · No injuriesClosedSmith Mini · Lincoln, NEJun 26, 1975 · N1152 · Substantial damage NTSB MKC75FCJ60Accident · No injuriesClosedPiper PA-28R · Lyons, NEJun 16, 1975 · N4861T · Substantial damage NTSB MKC75FCJ59Accident · Minor injuriesClosedCarson Rell 47G · Oakdale, NEJun 11, 1975 · N617X · Substantial damage NTSB MKC75FCJ58Accident · No injuriesClosedAeronca 7AC · Lincoln, NEJun 7, 1975 · N83469 · No damage NTSB MKC75AK060Accident · Minor injuriesClosedPiper PA-25 · Gothenburg, NEJun 5, 1975 · N8626L · 2 aircraft · Substantial damage NTSB MKC75AK058Accident · 2 fatalClosedAeronca 7BCM · Ogallala, NEJun 1, 1975 · N73634 · Substantial damage NTSB MKC75AK057Accident · Minor injuriesClosedCessna 414 · Omaha, NEMay 29, 1975 · N82470 · Substantial damage NTSB MKC75FCJ57Accident · Serious injuriesClosedPiper PA-25 · Fairbury, NEMay 22, 1975 · N8717L · Destroyed NTSB MKC75FCJ56Accident · Serious injuriesClosedMooney M20D · Omaha, NEMay 21, 1975 · N6643W · Destroyed NTSB MKC75FCJ5KAccident · Minor injuriesClosedCessna 210E · Omaha, NEMay 19, 1975 · N4981U · Substantial damage NTSB MKC75DCJ54Accident · No injuriesClosedCessna 177A · Decatur, NEMay 18, 1975 · N30535 · Substantial damage NTSB MKC75FCJ53Accident · No injuriesClosedBrantly B305 · Omaha, NEMay 16, 1975 · N11MR · Destroyed NTSB MKC75FCJ52Accident · 1 fatalClosedBellanca 7GCBC · Waco, NEMay 7, 1975 · N54731 · Destroyed NTSB MKC75DCJ51Accident · No injuriesClosedCessna 150 · Kearney, NEMay 4, 1975 · N9982G · Substantial damage NTSB MKC75DCJ49Accident · Minor injuriesClosedCessna 172 · Scottsbluff, NEMar 30, 1975 · N3799R · Substantial damage NTSB MKC75DCJ50Accident · No injuriesClosedPiper PA-32 · Arnold, NEMar 29, 1975 · N44460 · Substantial damage NTSB MKC75FCJ47Accident · Serious injuriesClosedGlobe GC-1B · North Platte, NEMar 15, 1975 · N3758K · Substantial damage NTSB MKC75DCJ48Accident · No injuriesClosedBellanca 7KCAB · Gothenburg, NEMar 15, 1975 · N57691 · Substantial damage NTSB MKC75DCJ46Accident · Serious injuriesClosedCessna 172H · Columbus, NEFeb 26, 1975 · N3250L · No damage NTSB MKC75AK043Accident · 4 fatalClosedMooney M20E · Chadron, NEFeb 14, 1975 · N5793Q · Destroyed NTSB MKC75DCJ45Accident · No injuriesClosedBellanca 7KCAB · Potter, NEFeb 7, 1975 · N87028 · Substantial damage NTSB MKC75FCJ44Accident · No injuriesClosedCessna 120 · Milford, NEJan 8, 1975 · N2111V · Substantial damage NTSB MKC75AK034Accident · 3 fatalClosedCessna 177B · Garland, NEJan 5, 1975 · N30855 · Destroyed