Skip to content

NTSB investigations, 1977

180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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, 1977 per year, 1962–2026: 180,581 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,514
1984	3,405
1985	3,055
1986	2,831
1987	2,774
1988	2,685
1989	2,502
1990	2,479
1991	2,419
1992	2,328
1993	2,283
1994	2,229
1995	2,281
1996	2,150
1997	2,121
1998	2,195
1999	2,175
2000	2,183
2001	2,031
2002	2,000
2003	2,062
2004	1,930
2005	2,001
2006	1,826
2007	1,984
2008	1,882
2009	1,783
2010	1,786
2011	1,848
2012	1,834
2013	1,561
2014	1,534
2015	1,581
2016	1,662
2017	1,635
2018	1,687
2019	1,626
2020	1,396
2021	1,645
2022	1,700
2023	1,678
2024	1,693
2025	1,655
2026	1,342

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 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
  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
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