Skip to content

Fatal NTSB investigations, 1977

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1977 per year, 1962–2026: 30,836 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	248

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."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\") = 1977
    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") = 1977
  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 OAK78DA012Accident · 2 fatalClosedPiper PA-28R · Ke-Ahole, HIDec 31, 1977 · N56357 · Destroyed NTSB MIA78FA026Accident · 3 fatalClosedCessna 177 · Albany, GADec 31, 1977 · N3296T · Destroyed NTSB LAX78FA017Accident · 2 fatalClosedCessna 152 · Ojai, CADec 31, 1977 · N24945 · Substantial damage NTSB SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WADec 30, 1977 · N7089C · Destroyed NTSB MKC78FCG12Accident · 1 fatalClosedCessna 177B · Grain Valley, MODec 29, 1977 · N34769 · Substantial damage NTSB FTW78FA021Accident · 2 fatalClosedCessna 152 · Teague, TXDec 29, 1977 · N714ZQ · Destroyed NTSB SEA78FA015Accident · 2 fatalClosedGrum Amer AA-5A · Anaconda, MTDec 28, 1977 · N9968U · Destroyed NTSB NYC78FA018Accident · 3 fatalClosedCessna 180 · Berlin, NHDec 28, 1977 · N456LM · Substantial damage NTSB NYC78FA017Accident · 2 fatalClosedHughes 269B · Quincy, MADec 27, 1977 · N9364F · Destroyed NTSB MIA78FA024Accident · 4 fatalClosedBeech A24 · Alachua, FLDec 27, 1977 · N6962Q · Destroyed NTSB LAX78FA016Accident · 2 fatalClosedCessna 182A · El Cajon, CADec 27, 1977 · N3979D · Destroyed NTSB NYC78FA016Accident · 1 fatalClosedPiper PA-28 · Brooklyn, CTDec 26, 1977 · N713FL · Substantial damage NTSB LAX78FA015Accident · 3 fatalClosedGrum Amer AA-5B · Desert Hot Spg, CADec 25, 1977 · N74787 · Destroyed NTSB MIA78FA022Accident · 2 fatalClosedCessna 172 · Blairsville, GADec 24, 1977 · N4183L · Destroyed NTSB MIA78DA025Accident · 3 fatalClosedPiper PA-28 · Mayaguez (Atlantic Ocean)Dec 24, 1977 · N4901J · Destroyed NTSB IAD78FA025Accident · 2 fatalClosedCessna 206F · Sylva, NCDec 24, 1977 · N8290Q · Destroyed NTSB MKC78FA016Accident · 2 fatalClosedLuscombe 8E · Gordon, NEDec 23, 1977 · N1226K · Destroyed NTSB MIA78FA020Accident · 2 fatalClosedCessna 150 · Plantation, FLDec 23, 1977 · N10608 · Destroyed NTSB FTW78DQD08Accident · 1 fatalClosedCessna 177RG · Coyanosa, TXDec 23, 1977 · CF-BTL · Destroyed NTSB SEA78FA014Accident · 7 fatalClosedAero Cmdr 520 · Cheshire, ORDec 22, 1977 · C-GHUN · Destroyed NTSB NYC78FA019Accident · 1 fatalClosedCessna 404 · Buffalo, NYDec 22, 1977 · N404SA · Destroyed NTSB FTW78FA019Accident · 2 fatalClosedPiper PA-28R · Giddings, TXDec 22, 1977 · N116MM · Destroyed NTSB OAK78FA011Accident · 1 fatalClosedCessna 172M · Orland, CADec 21, 1977 · N12699 · Destroyed NTSB NYC78FA015Accident · 1 fatalClosedBeagle B206 · Greenwich, CTDec 20, 1977 · N1008B · Destroyed NTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRDec 19, 1977 · N862JA · Destroyed NTSB ANC78FA005Accident · 2 fatalClosedHiller Acft FH1100 · Anchor Point, AKDec 19, 1977 · N18845 · Destroyed NTSB OAK78FA010Accident · 1 fatalClosedCessna U206 · Little River, CADec 18, 1977 · N29275 · Destroyed NTSB FTW78FRA11Accident · 1 fatalClosedLuscombe 8A · Pearland, TXDec 18, 1977 · N1285K · 2 aircraft · Destroyed NTSB DCA78AA005Accident · 3 fatalClosedDouglas DC-8F · Kaysville, UTDec 18, 1977 · N8047U · Destroyed NTSB MIA78AF019Accident · 1 fatalClosedCessna 150 · Dauphin Island, ALDec 17, 1977 · N6589T · Destroyed NTSB LAX78FA013Accident · 2 fatalClosedPiper PA-30 · Van Nuys, CADec 17, 1977 · N922JS · Substantial damage NTSB CHI78FA012Accident · 1 fatalClosedCessna U206F · Garrettsville, OHDec 17, 1977 · N1045V · Destroyed NTSB SEA78FA013Accident · 1 fatalClosedCessna 152 · Quincy, WADec 16, 1977 · N757TC · Destroyed NTSB MKC78FA014Accident · 1 fatalClosedPiper PA-28R · Waukon, IADec 16, 1977 · N44988 · Destroyed NTSB MIA78DA023Accident · 1 fatalClosedPiper PA-31 · Kingston (Atlantic Ocean)Dec 16, 1977 · N483LC · Destroyed NTSB DEN78FA016Accident · 2 fatalClosedLake LA-4 · Albuquerque, NMDec 16, 1977 · N6011V · Destroyed NTSB MIA78FA015Accident · 1 fatalClosedPiper PA-18 · Jeffersonville, GADec 15, 1977 · N4890P · Destroyed NTSB MKC78FA013Accident · 2 fatalClosedPiper PA-34 · Davenport, IADec 14, 1977 · N1634H · Destroyed NTSB LAX78FA014Accident · 1 fatalClosedBellanca 7ECA · Catalina Islnd, CADec 14, 1977 · N5233X · Destroyed NTSB LAX78FA006Accident · 2 fatalClosedCessna 150G · Laguna Beach, CADec 14, 1977 · N8312J · Destroyed NTSB IAD78FA022Accident · 2 fatalClosedPiper PA-28 · Ocracoke, NCDec 14, 1977 · N7285W · Destroyed NTSB FTW78FA018Accident · 1 fatalClosedCessna 210D · Hot Springs, ARDec 13, 1977 · TI-AIC · Destroyed NTSB DCA78AA001Accident · 29 fatalClosedDouglas DC-3 · Evansville, INDec 13, 1977 · N51071 · Destroyed NTSB NYC78FA013Accident · 2 fatalClosedBeech D95A · Richland, PADec 12, 1977 · N1199T · Substantial damage NTSB OAK78FA008Accident · 1 fatalClosedPiper PA-28 · Watsonville, CADec 11, 1977 · N475FL · Destroyed NTSB FTW78FA017Accident · 3 fatalClosedPiper PA-24 · Kerrville, TXDec 11, 1977 · N7126P · Destroyed NTSB IAD78FA020Accident · 1 fatalClosedPiper PA-28R · Elizabethtown, KYDec 10, 1977 · N9406N · Destroyed NTSB MKC78FA012Accident · 2 fatalClosedPiper PA-28R · Fordland, MODec 8, 1977 · N38775 · Destroyed NTSB FTW78FA016Accident · 17 fatalClosedS.N.I.A.S. SA330J · Intracstl City, LADec 8, 1977 · N4730S · Destroyed NTSB DEN78FA013Accident · 3 fatalClosedCessna 182 · Socorro, NMDec 8, 1977 · N6488A · Destroyed