Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 DEN73AD029Accident · 7 fatalClosedPiper PA-32 · Kearney, NEDec 28, 1972 · N8915N · Destroyed NTSB MKC73FCJ26Accident · No injuriesClosedBeech D95A · North Platte, NENov 28, 1972 · N816G · Substantial damage NTSB MKC73DCJ25Accident · No injuriesClosedPiper PA-34 · Grand Island, NENov 26, 1972 · N1063U · Substantial damage NTSB MKC73DCJ24Accident · No injuriesClosedPiper PA-28 · Ogallala, NENov 24, 1972 · N2683T · Substantial damage NTSB MKC73FCJ23Accident · Minor injuriesClosedCessna 150F · Papillion, NENov 19, 1972 · N1806S · Substantial damage NTSB MKC73AK039Accident · 2 fatalClosedPiper PA-24 · Fremont, NENov 12, 1972 · N5095P · Destroyed NTSB MKC73FCJ22Accident · No injuriesClosedPiper PA-34 · Ogallala, NENov 9, 1972 · N4523T · Substantial damage NTSB MKC73AK036Accident · 1 fatalClosedCessna 150F · Long Pine, NENov 5, 1972 · N7704F · Destroyed NTSB MKC73DCJ21Accident · No injuriesClosedChampion 7KCAB · Ogallala, NENov 3, 1972 · N1631G · Substantial damage NTSB MKC73FCJ20Accident · No injuriesClosedBeech B95A · Lincoln, NEOct 10, 1972 · N1299Z · Substantial damage NTSB MKC73FCJ19Accident · No injuriesClosedCessna 337F · Omaha, NESep 16, 1972 · N55BC · Substantial damage NTSB MKC73FCJ18Accident · No injuriesClosedCessna 320B · Lincoln, NESep 13, 1972 · N9805L · Substantial damage NTSB MKC73DCJ17Accident · Minor injuriesClosedAeronca 7FC · Chadron, NEAug 20, 1972 · N7527E · Substantial damage NTSB MKC73FCJ16Accident · No injuriesClosedCessna 150H · Wahoo, NEAug 17, 1972 · N22909 · Substantial damage NTSB MKC73DCJ15Accident · No injuriesClosedPiper PA-22 · Ravenna, NEAug 15, 1972 · N2759P · Substantial damage NTSB MKC73DCJ14Accident · No injuriesClosedAeronca 11AC · Taylor, NEAug 11, 1972 · N9148E · Substantial damage NTSB MKC73DCJ13Accident · Minor injuriesClosedPiper PA-18 · Paxton, NEAug 11, 1972 · N1894A · Substantial damage NTSB MKC73AK013Accident · 2 fatalClosedPiper PA-28R · Lincoln, NEAug 3, 1972 · N301LC · Destroyed NTSB MKC73FCJ11Accident · No injuriesClosedLuscombe 11A · Papillion, NEJul 29, 1972 · N1631B · Substantial damage NTSB MKC73FCJ10Accident · No injuriesClosedBeech H35 · North Platte, NEJul 28, 1972 · N336B · Substantial damage NTSB MKC73FCJ09Accident · No injuriesClosedNaval Fcty N3N-3 · Lincoln, NEJul 23, 1972 · N44758 · Substantial damage NTSB MKC73DCJ12Accident · No injuriesClosedPiper PA-18 · Hyannis, NEJul 22, 1972 · N4077Z · Substantial damage NTSB MKC73FCJ08Accident · No injuriesClosedBeech V35 · Oneill, NEJul 19, 1972 · N3705Q · Substantial damage NTSB MKC73DCJ07Accident · No injuriesClosedPiper PA-25 · Humbolt, NEJul 10, 1972 · N4886Y · Substantial damage NTSB MKC73DCJ06Accident · No injuriesClosedCessna 177 · Papillion, NEJul 9, 1972 · N29397 · Substantial damage NTSB MKC73DCJ03Accident · No injuriesClosedCessna 185 · Geneva, NEJul 9, 1972 · N4061Y · Substantial damage NTSB MKC73FCJ04Accident · No injuriesClosedPiper PA-24 · Ord, NEJul 8, 1972 · N8620P · Substantial damage NTSB MKC73DCJ05Accident · No injuriesClosedCessna 182 · Pender, NEJul 8, 1972 · N2720F · Substantial damage NTSB MKC73FCJ02Accident · Minor injuriesClosedCessna 140 · North Platte, NEJul 6, 1972 · N89183 · Substantial damage NTSB MKC73DCJ01Accident · No injuriesClosedPiper PA-25 · Oshkosh, NEJul 4, 1972 · N6692Z · Substantial damage NTSB MKC72FCJ74Accident · No injuriesClosedPiper PA-18 · Gibbon, NEJun 13, 1972 · N3884P · Substantial damage NTSB MKC72FCJ73Accident · Minor injuriesClosedBeech A35 · Kearney, NEJun 10, 1972 · N8420A · Substantial damage NTSB MKC72FCJ72Accident · No injuriesClosedPiper PA-22 · Omaha, NEJun 3, 1972 · N3377A · Destroyed NTSB MKC72DCJ71Accident · No injuriesClosedPiper PA-25 · Crawford, NEJun 2, 1972 · N4997Y · Destroyed NTSB MKC72DCJ69Accident · No injuriesClosedCessna 150 · Blair, NEMay 31, 1972 · N7974Z · Substantial damage NTSB MKC72DCJ68Accident · No injuriesClosedCessna 150 · Lincoln, NEMay 28, 1972 · N60771 · Substantial damage NTSB MKC72FCJ67Accident · Serious injuriesClosedPiper PA-30 · Weepng Water, NEMay 26, 1972 · N7112Y · Substantial damage NTSB MKC72DCJ70Accident · No injuriesClosedPiper PA-25 · Broken Bow, NEMay 26, 1972 · N4895Y · Substantial damage NTSB MKC72FCJ66Accident · No injuriesClosedBeech S35 · Lincoln, NEMay 25, 1972 · N215Q · Substantial damage NTSB MKC72FCJ65Accident · No injuriesClosedCessna 337B · Omaha, NEMay 24, 1972 · N5471S · Substantial damage NTSB MKC72FCJ63Accident · Serious injuriesClosedPiper PA-22 · Lincoln, NEMay 21, 1972 · N8525C · Destroyed NTSB MKC72FCJ64Accident · No injuriesClosedCessna 150H · Arapahoe, NEMay 18, 1972 · N22009 · Destroyed NTSB MKC72DCJ62Accident · No injuriesClosedPiper PA-28 · Broken Bow, NEMay 16, 1972 · N4975L · Substantial damage NTSB MKC72FCJ61Accident · No injuriesClosedCessna 172 · Greenwood, NEMay 8, 1972 · N7095A · Substantial damage NTSB MKC72FCJ60Accident · 1 fatalClosedBoeing 75N1 · Amherst, NEMay 5, 1972 · N61247 · Destroyed NTSB MKC72FCJ59Accident · No injuriesClosedPiper PA-34 · Omaha, NEMay 2, 1972 · N1060U · Substantial damage NTSB MKC72FCJ58Accident · Serious injuriesClosedStinson 108-2 · Seward, NEApr 16, 1972 · N8047K · Destroyed NTSB MKC72DCJ57Accident · No injuriesClosedCessna 182F · Dannebrog, NEApr 7, 1972 · N3538Y · Substantial damage NTSB MKC72FCJ56Accident · No injuriesClosedPiper PA-30 · North Platte, NEMar 31, 1972 · N7164Y · Substantial damage NTSB MKC72AK058Accident · 1 fatalClosedBeech F35 · Kimball, NEMar 30, 1972 · N3368C · Destroyed