Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MKC72FCJ42Accident · No injuriesClosedTemco GC-1B · Grand Island, NEDec 24, 1971 · N2329B · Substantial damage NTSB MKC72DCJ43Accident · No injuriesClosedCessna 150 · Taylor, NEDec 24, 1971 · N7989F · Substantial damage NTSB MKC72AK039Accident · 1 fatalClosedCessna 150 · Ashland, NEDec 20, 1971 · N23217 · Destroyed NTSB MKC72FCJ41Accident · Minor injuriesClosedPiper PA-28 · Lincoln, NEDec 19, 1971 · N6710J · Substantial damage NTSB MKC72FCJ40Accident · Minor injuriesClosedPiper PA-28R · Scribner, NEDec 13, 1971 · N4981J · Substantial damage NTSB MKC72FCJ39Accident · No injuriesClosedPiper PA-24 · Scribner, NEDec 12, 1971 · N5095P · Substantial damage NTSB MKC72AK034Accident · No injuriesClosedBeech Volpar · Grand Island, NEDec 8, 1971 · N113S · Substantial damage NTSB MKC72DCJ38Accident · Minor injuriesClosedChampion 7GCBC · Hershey, NENov 23, 1971 · N1802G · Substantial damage NTSB MKC72DCJ37Accident · No injuriesClosedWaco UKC · Columbus, NENov 14, 1971 · N14086 · Substantial damage NTSB MKC72FCJ36Accident · Minor injuriesClosedPiper PA-22 · Nehawka, NENov 10, 1971 · N2304P · Destroyed NTSB MKC72FCJ35Accident · No injuriesClosedPiper PA-22 · Ayr, NENov 7, 1971 · N4851Z · Substantial damage NTSB MKC72FCJ34Accident · Serious injuriesClosedPiper J3C-65 · Atkinson, NEOct 24, 1971 · N73418 · Destroyed NTSB MKC72DCJ33Accident · No injuriesClosedBeech A23-24 · Oneill, NEOct 12, 1971 · N2324W · Substantial damage NTSB MKC72DCJ32Accident · Minor injuriesClosedCessna 170B · Valentine, NEOct 7, 1971 · N1988C · Substantial damage NTSB MKC72DCJ30Accident · No injuriesClosedCessna 170B · Memphis, NEOct 6, 1971 · N3253A · Substantial damage NTSB MKC72DCJ29Accident · No injuriesClosedPiper PA-28 · Glenvil, NEOct 3, 1971 · N6744W · Substantial damage NTSB MKC72DCJ27Accident · No injuriesClosedCessna 182 · Norden, NESep 18, 1971 · N6377B · Substantial damage NTSB MKC72AK019Accident · 2 fatalClosedPiper PA-18 · Seneca, NESep 18, 1971 · N7166K · Destroyed NTSB MKC72DCJ28Accident · No injuriesClosedCessna 150 · Papillion, NESep 17, 1971 · N22915 · Substantial damage NTSB MKC72DCJ26Accident · No injuriesClosedPiper PA-24 · Boelus, NESep 13, 1971 · N6383P · Substantial damage NTSB MKC72DCJ25Accident · No injuriesClosedCessna 177 · Leigh, NESep 11, 1971 · N30535 · Substantial damage NTSB MKC72FCJ24Accident · No injuriesClosedCessna 177 · Omaha, NESep 9, 1971 · N3242T · Substantial damage NTSB MKC72DCJ31Accident · No injuriesClosedPiper PA-24 · Fremont, NESep 9, 1971 · N7729P · Substantial damage NTSB MKC72DCJ23Accident · No injuriesClosedGrumman G-44 · Ogallala, NESep 1, 1971 · N4617N · Substantial damage NTSB MKC72FCJ22Accident · Minor injuriesClosedCallair A-9 · Stromsburg, NEAug 30, 1971 · N7209V · Substantial damage NTSB MKC72FCJ21Accident · No injuriesClosedSmith DSA · Lincoln, NEAug 29, 1971 · N1152 · Substantial damage NTSB MKC72FCJ20Accident · No injuriesClosedWrong Bros. Z · Lincoln, NEAug 27, 1971 · N6138 · Substantial damage NTSB MKC72FCJ19Accident · Serious injuriesClosedBell 47D1 · Bellwood, NEAug 21, 1971 · N903B · Destroyed NTSB MKC72FCJ18Accident · Serious injuriesClosedCessna 182H · Central City, NEAug 16, 1971 · N1946X · Substantial damage NTSB MKC72FCJ17Accident · No injuriesClosedPiper PA-25 · Gering, NEAug 12, 1971 · N7746Z · Destroyed NTSB MKC72FCJ15Accident · No injuriesClosedCessna 120 · Lincoln, NEAug 11, 1971 · N2765N · Substantial damage NTSB MKC72FCJ16Accident · No injuriesClosedCessna 182 · Spalding, NEAug 10, 1971 · N5539B · Substantial damage NTSB MKC72FCJ13Accident · No injuriesClosedCessna 188 · Lexington, NEAug 9, 1971 · N8059V · Substantial damage NTSB MKC72DCJ14Accident · No injuriesClosedPiper PA-25 · Callaway, NEAug 8, 1971 · N4394Y · Substantial damage NTSB MKC72DCJ12Accident · No injuriesClosedCessna 150C · Omaha, NEAug 2, 1971 · N7898Z · Substantial damage NTSB MKC72DCJ11Accident · No injuriesClosedCessna 210 · Millard, NEJul 30, 1971 · N1819F · Substantial damage NTSB MKC72DCJ10Accident · No injuriesClosedCessna 150 · Papillion, NEJul 30, 1971 · N8106S · Substantial damage NTSB MKC72DCJ09Accident · No injuriesClosedAero Comdr 100 · Atkinson, NEJul 26, 1971 · N4066X · Substantial damage NTSB MKC72FCJ08Accident · No injuriesClosedBeech J35 · Ogallala, NEJul 23, 1971 · N8345D · Substantial damage NTSB MKC72FCJ06Accident · No injuriesClosedPiper PA-24 · Chadron, NEJul 19, 1971 · CF-QXK · Substantial damage NTSB MKC72DCJ07Accident · Serious injuriesClosedCessna 172 · Oneill, NEJul 17, 1971 · N7336A · Substantial damage NTSB MKC72DCJ05Accident · No injuriesClosedCessna 310G · Columbus, NEJul 10, 1971 · N8957Z · Substantial damage NTSB MKC72DCJ04Accident · No injuriesClosedCessna 150 · Omaha, NEJul 8, 1971 · N6943G · Substantial damage NTSB MKC72DCJ02Accident · No injuriesClosedPiper PA-25 · Fremont, NEJul 2, 1971 · N6316Z · Substantial damage NTSB MKC72FCJ03Accident · No injuriesClosedPiper PA-24 · Offutt Afb, NEJul 1, 1971 · N5742P · Substantial damage NTSB MKC72FCJ01Accident · Minor injuriesClosedGrumman G-164 · Ainsworth, NEJul 1, 1971 · N730Y · Destroyed NTSB MKC71DCJ77Accident · Minor injuriesClosedPiper PA-25 · Alma, NEJun 30, 1971 · N6928Z · Substantial damage NTSB MKC71DCJ76Accident · No injuriesClosedCessna 172E · Ainsworth, NEJun 22, 1971 · N3770S · Substantial damage NTSB MKC71DCJ74Accident · No injuriesClosedCessna 177 · Fremont, NEJun 22, 1971 · N3103T · Substantial damage NTSB MKC71FCJ75Accident · No injuriesClosedChampion 7GC · Ord, NEJun 20, 1971 · N4856E · Substantial damage