Skip to content

Fatal NTSB investigations, 1979

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

Fatal NTSB investigations, 1979 per year, 1962–2026: 30,831 cases
1962	11
1963	13
1964	539
1965	560
1966	581
1967	625
1968	718
1969	655
1970	643
1971	664
1972	697
1973	731
1974	727
1975	692
1976	707
1977	713
1978	800
1979	691
1980	672
1981	705
1982	638
1983	651
1984	617
1985	555
1986	507
1987	496
1988	502
1989	484
1990	499
1991	482
1992	494
1993	437
1994	445
1995	456
1996	421
1997	402
1998	422
1999	404
2000	443
2001	412
2002	417
2003	440
2004	418
2005	428
2006	408
2007	387
2008	373
2009	359
2010	363
2011	398
2012	389
2013	344
2014	360
2015	365
2016	341
2017	338
2018	361
2019	381
2020	294
2021	321
2022	330
2023	295
2024	292
2025	275
2026	243

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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
  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."highestInjuryLevel" = 'Fatal'
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 NYC80FA017Accident · 2 fatalClosedCessna 172N · Lindenhurst, NYDec 30, 1979 · N738WX · Destroyed NTSB CHI80FA020Accident · 3 fatalClosedPiper PA-28 · Royal Oak, MIDec 30, 1979 · N4512P · Destroyed NTSB SEA80FTA07Accident · 1 fatalClosedScorpion 133 · Nashua, MTDec 29, 1979 · NONE · Destroyed NTSB NYC80FA016Accident · 2 fatalClosedPiper PA-28 · Broad Brook, CTDec 28, 1979 · N16436 · Destroyed NTSB DEN80FA016Accident · 1 fatalClosedBeech B60 · Hayden, CODec 28, 1979 · N6030S · Destroyed NTSB CHI80FA019Accident · 2 fatalClosedPiper PA-28R · Kankakee, ILDec 28, 1979 · N7644J · Destroyed NTSB DEN79FA015Accident · 5 fatalClosedCessna 421B · Eagle.Co, CODec 26, 1979 · N100RV · Destroyed NTSB MKC80FA017Accident · 1 fatalClosedCessna 175 · Shawnee, KSDec 23, 1979 · N7253M · Destroyed NTSB DEN80FA014Accident · 1 fatalClosedPiper PA-23 · Grand Lake, CODec 23, 1979 · N2013P · Substantial damage NTSB MKC80FA016Accident · 1 fatalClosedCessna 150G · Anthony, KSDec 22, 1979 · N8409J · Destroyed NTSB MIA80FA022Accident · 4 fatalClosedBeech E18S · Orlando, FLDec 22, 1979 · N198B · Destroyed NTSB LAX80FA031Accident · 2 fatalClosedBellanca 8KCAB · San Fernando, CADec 22, 1979 · N5032K · Substantial damage NTSB FTW80FA028Accident · 2 fatalClosedBeech 65-90 · Leeville, LADec 22, 1979 · N724N · Destroyed NTSB DEN80FA013Accident · 1 fatalClosedRockwell 500B · Santa Fe, NMDec 22, 1979 · N6194X · Destroyed NTSB MKC80FA015Accident · 1 fatalClosedCessna 152 · Olathe, KSDec 21, 1979 · N25494 · Destroyed NTSB MIA80FA021Accident · 5 fatalClosedPiper PA-32 · Woodbine, GADec 21, 1979 · N3802W · Destroyed NTSB MIA80DA023Accident · 4 fatalClosedPiper PA-23 · Missing AircraftDec 21, 1979 · N1435P · Destroyed NTSB LAX80FA027Accident · 5 fatalClosedCessna 172M · Lebec, CADec 21, 1979 · N6714H · Destroyed NTSB FTW80FA027Accident · 1 fatalClosedCessna 172H · Moshiem, TXDec 21, 1979 · N1792F · Destroyed NTSB FTW80FA026Accident · 2 fatalClosedCessna 182E · Comfort, TXDec 21, 1979 · N2853Y · Destroyed NTSB FTW80FA025Accident · 1 fatalClosedCessna 182 · Story, ARDec 21, 1979 · N5393B · Destroyed NTSB FTW80FA024Accident · 4 fatalClosedCessna 421B · Locust Grove, ARDec 21, 1979 · N5428J · Destroyed NTSB DEN80FA012Accident · 2 fatalClosedMitsubishi MU-2B · Provo, UTDec 21, 1979 · N200BR · Destroyed NTSB CHI80FA016Accident · 2 fatalClosedCessna 172K · Edwardsville, ILDec 21, 1979 · N736UL · Destroyed NTSB CHI80DA018Accident · 2 fatalClosedBeech B58 · Taylorville, ILDec 21, 1979 · N2058X · Destroyed NTSB CHI80DA017Accident · 2 fatalClosedCessna 310R · Green Bay, WIDec 21, 1979 · N78ST · Destroyed NTSB LAX80FA114Accident · 2 fatalClosedPiper PA-32R · Safford, AZDec 20, 1979 · N9877K · Destroyed NTSB MIA80FLA12Accident · 1 fatalClosedNavion H · Waycross, GADec 18, 1979 · N2552T · Destroyed NTSB FTW80FA023Accident · 1 fatalClosedCessna 180K · Harvey, LADec 18, 1979 · N2594K · Substantial damage NTSB NYC80FA015Accident · 1 fatalClosedCessna 172 · Washingtnville, NYDec 16, 1979 · N6647A · Destroyed NTSB MIA80FA019Accident · 2 fatalClosedN American P-51D · Eufaula, ALDec 16, 1979 · N7711C · Destroyed NTSB IAD80FA017Accident · 7 fatalClosedBeech A65 · Lexington, KYDec 16, 1979 · N154F · Destroyed NTSB CHI80FA015Accident · 1 fatalClosedPiper PA-28 · Mansfield, OHDec 16, 1979 · N5515F · Destroyed NTSB MIA80FA018Accident · 4 fatalClosedRaven S-55A · Davie, FLDec 15, 1979 · N64RR · Destroyed NTSB LAX80FA025Accident · 1 fatalClosedMooney M20J · Palo Alto, CADec 15, 1979 · N201UN · Destroyed NTSB FTW80FRG13Accident · 1 fatalClosedErco 415-C · Troy, TXDec 15, 1979 · N93477 · Destroyed NTSB FTW80FA022Accident · 2 fatalClosedCessna A185F · Venice, LADec 15, 1979 · N1850R · Destroyed NTSB FTW80FA021Accident · 2 fatalClosedPiper PA-28 · Sonora, TXDec 15, 1979 · N57329 · Destroyed NTSB CHI80FA014Accident · 1 fatalClosedHughes 269C · West Milton, OHDec 15, 1979 · N7483F · Destroyed NTSB IAD80FA016Accident · 1 fatalClosedPiper PA-23 · Knoxville, TNDec 14, 1979 · N3242P · Destroyed NTSB DEN80FTE12Accident · 2 fatalClosedDelta Dyke · Broomfield, CODec 13, 1979 · N99DD · Substantial damage NTSB SEA80FAMS1Accident · 4 fatalClosedPiper PA-24 · Missing AircraftDec 11, 1979 · N6171P · Destroyed NTSB SEA80FA047Accident · 4 fatalClosedPiper PA-24 · White Pass, WADec 11, 1979 · N6171P · Destroyed NTSB MKC80FA014Accident · 1 fatalClosedCessna 182S · Womack, MODec 11, 1979 · N3594U · Destroyed NTSB SEA80FA014Accident · 2 fatalClosedCessna 182 · Idaho Falls, IDDec 9, 1979 · N470PP · Destroyed NTSB LAX80FA024Accident · 1 fatalClosedAerostar 601P · Bishop, CADec 9, 1979 · N600WW · Destroyed NTSB LAX80FA023Accident · 3 fatalClosedCessna 172M · Huntington Bch, CADec 9, 1979 · N20647 · Destroyed NTSB SEA80FA013Accident · 1 fatalClosedCessna T210M · Pasco, WADec 8, 1979 · N732QJ · Destroyed NTSB SEA80FA012Accident · 2 fatalClosedAeronca 65-CA · Mountain Home, IDDec 8, 1979 · N31929 · Substantial damage NTSB SEA80FA011Accident · 2 fatalClosedBeech V35A · Sublett, IDDec 7, 1979 · N7950R · Destroyed