Skip to content

Final NTSB investigations, 1977

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

Final NTSB investigations, 1977 per year, 1962–2026: 171,584 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

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."completionStatus" = 'Completed' 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.\"completionStatus\" = 'Completed'
  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."completionStatus" = 'Completed'
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 FTW78DRD12Accident · No injuriesClosedHughes 369HS · Harahan, LADec 31, 1977 · N9104F · Substantial damage NTSB CHI78IA013Incident · Minor injuriesClosedBoeing 727 · Chicago, ILDec 31, 1977 · N8161G · 2 aircraft · Minor damage NTSB CHI78FEK06Accident · Minor injuriesClosedCessna 150 · Clairsville, OHDec 31, 1977 · N714GE · Substantial damage NTSB CHI78FEI08Accident · Serious injuriesClosedCessna 172E · Louisville, OHDec 31, 1977 · N3586S · Substantial damage NTSB ANC78DA008Accident · Serious injuriesClosedShort Bros SC-7 · Toksook Bay, AKDec 31, 1977 · N64AC · Destroyed NTSB SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WADec 30, 1977 · N7089C · Destroyed NTSB OAK78FVW07Accident · Serious injuriesClosedCessna 172 · Boulder City, NVDec 30, 1977 · N5951A · Destroyed NTSB NYC78FHM02Accident · No injuriesClosedMorrisey 2150A · Kent, NYDec 30, 1977 · N5139V · Destroyed NTSB MKC78FCA10Accident · Minor injuriesClosedHeying PDQ-2 · Creve Coeur, MODec 30, 1977 · N68079 · Substantial damage NTSB MKC78DCQ12Accident · Minor injuriesClosedCessna 150 · Russell, KSDec 30, 1977 · N704ES · Destroyed NTSB LAX78FUD03Accident · Minor injuriesClosedBellanca 7KCAB · Santa Monica, CADec 30, 1977 · N86862 · Substantial damage NTSB DEN78FTE21Accident · Serious injuriesClosedBeech A23-19 · Kings Canyon, CODec 30, 1977 · N3610Q · Destroyed NTSB OAK78FVD12Accident · No injuriesClosedCessna 210 · Livermore, CADec 29, 1977 · N59091 · Substantial damage NTSB OAK78DJA02Accident · No injuriesClosedEmair MA-1 · Lihue, HIDec 29, 1977 · N305MA · Substantial damage NTSB NYC78FNE04Accident · No injuriesClosedCessna 177 · Oxford, CTDec 29, 1977 · N2293Y · Substantial damage NTSB NYC78FHD03Accident · No injuriesClosedBeech V35A · Ocean City, NJDec 29, 1977 · N9012V · Substantial damage NTSB MKC78FCG12Accident · 1 fatalClosedCessna 177B · Grain Valley, MODec 29, 1977 · N34769 · Substantial damage NTSB MKC78DER19Accident · No injuriesClosedCessna 310Q · Rochester, MNDec 29, 1977 · N310JP · Substantial damage NTSB MKC78DCA12Accident · No injuriesClosedPiper PA-22 · Chesterfield, MODec 29, 1977 · N5467Z · 2 aircraft · Substantial damage NTSB FTW78FA021Accident · 2 fatalClosedCessna 152 · Teague, TXDec 29, 1977 · N714ZQ · Destroyed NTSB DEN78FTE20Accident · No injuriesClosedCessna 152 · Colorado Sprgs, CODec 29, 1977 · N25508 · Substantial damage 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 IAD78FA026Accident · Minor injuriesClosedPiper PA-32 · Raeford, NCDec 28, 1977 · N121MB · Substantial damage NTSB FTW78FPA10Accident · Serious injuriesClosedMitsubishi MU-2J · Addison, TXDec 28, 1977 · N245MA · Substantial damage NTSB NYC78FGM14Accident · No injuriesClosedPiper PA-28 · Martinsburg, PADec 27, 1977 · N43157 · Substantial damage NTSB NYC78FFJ09Accident · No injuriesClosedMooney M20C · Dunkirk, NYDec 27, 1977 · N6708U · Substantial damage NTSB NYC78FA017Accident · 2 fatalClosedHughes 269B · Quincy, MADec 27, 1977 · N9364F · Destroyed NTSB NYC78DNC08Accident · No injuriesClosedSchweizer SGS232 · Warren, VTDec 27, 1977 · N2432W · Substantial damage NTSB MKC78DCQ11Accident · No injuriesClosedCessna 172 · Phillipsburg, KSDec 27, 1977 · N75556 · Substantial damage NTSB MIA78FA024Accident · 4 fatalClosedBeech A24 · Alachua, FLDec 27, 1977 · N6962Q · Destroyed NTSB MIA78DKJ16Accident · No injuriesClosedPiper PA-32R · Selma, ALDec 27, 1977 · N3570Q · Substantial damage NTSB LAX78FA016Accident · 2 fatalClosedCessna 182A · El Cajon, CADec 27, 1977 · N3979D · Destroyed NTSB ANC78DAG17Accident · Serious injuriesClosedCessna 185D · Mt.Susitna, AKDec 27, 1977 · N1553F · Substantial damage NTSB SEA78DYM13Accident · No injuriesClosedPiper PA-28R · Aurora, ORDec 26, 1977 · N4936J · 2 aircraft · Minor damage NTSB OAK78DVA19Accident · No injuriesClosedCessna 150 · Chowchilla, CADec 26, 1977 · N18176 · Substantial damage NTSB NYC78FNE03Accident · Serious injuriesClosedMooney M20 · New Haven, CTDec 26, 1977 · N6806V · Substantial damage NTSB NYC78FA016Accident · 1 fatalClosedPiper PA-28 · Brooklyn, CTDec 26, 1977 · N713FL · Substantial damage NTSB NYC78DHD02Accident · Minor injuriesClosedPiper PA-28R · Lakewood, NJDec 26, 1977 · N55846 · Substantial damage NTSB MKC78FCA13Accident · No injuriesClosedCessna 195 · Willow Springs, MODec 26, 1977 · N195RW · Substantial damage NTSB MIA78FKG10Accident · No injuriesClosedPiper PA-32R · Ila, GADec 26, 1977 · N8475F · Substantial damage NTSB IAD78DLJ08Accident · No injuriesClosedCessna 172 · Raeford, NCDec 26, 1977 · N75600 · Substantial damage NTSB CHI78FEP07Accident · No injuriesClosedCessna 177 · Madison, WIDec 26, 1977 · N2011Q · Substantial damage NTSB CHI78FEI07Accident · Serious injuriesClosedPiper PA-28 · Walbridge, OHDec 26, 1977 · N6875J · Substantial damage NTSB CHI78DEM07Accident · No injuriesClosedCessna 150 · Crystal Falls, MIDec 26, 1977 · N7966G · Substantial damage NTSB LAX78FUM10Accident · No injuriesClosedPiper PA-28 · Santee, CADec 25, 1977 · N505GS · Substantial damage NTSB LAX78FA015Accident · 3 fatalClosedGrum Amer AA-5B · Desert Hot Spg, CADec 25, 1977 · N74787 · Destroyed