Skip to content

NTSB investigations, 1977, PA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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

19632026

NTSB investigations, 1977, PA per year, 1963–2026: 4,232 cases
1963	2
1964	157
1965	149
1966	172
1967	192
1968	154
1969	132
1970	136
1971	153
1972	104
1973	118
1974	143
1975	131
1976	123
1977	116
1978	124
1979	109
1980	89
1981	92
1982	96
1983	81
1984	84
1985	75
1986	64
1987	64
1988	65
1989	45
1990	65
1991	47
1992	47
1993	48
1994	41
1995	55
1996	38
1997	56
1998	40
1999	41
2000	47
2001	34
2002	35
2003	29
2004	37
2005	33
2006	36
2007	35
2008	33
2009	30
2010	19
2011	27
2012	39
2013	27
2014	24
2015	35
2016	32
2017	33
2018	28
2019	30
2020	19
2021	28
2022	35
2023	11
2024	19
2025	17
2026	12

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."eventStateOrRegion" = 'PA' 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\") = 1977
    AND c.\"eventStateOrRegion\" = 'PA' 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") = 1977
  AND c."eventStateOrRegion" = 'PA' 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 NYC78FGM14Accident · No injuriesClosedPiper PA-28 · Martinsburg, PADec 27, 1977 · N43157 · Substantial damage NTSB NYC78FGT02Accident · Serious injuriesClosedPiper PA-32 · Ogdensburg, PADec 12, 1977 · N300RM · Substantial damage NTSB NYC78FGM13Accident · Minor injuriesClosedCessna 150H · Corry, PADec 12, 1977 · N50161 · Substantial damage NTSB NYC78FGM12Accident · No injuriesClosedBeech 95-B55 · Dubois, PADec 12, 1977 · N4561S · Substantial damage NTSB NYC78FA013Accident · 2 fatalClosedBeech D95A · Richland, PADec 12, 1977 · N1199T · Substantial damage NTSB NYC78DHA07Accident · No injuriesClosedCessna 340 · Allentown, PANov 29, 1977 · N5RF · Substantial damage NTSB NYC78FHA05Accident · No injuriesClosedCessna 172 · Slatington, PANov 25, 1977 · N3790S · Substantial damage NTSB NYC78FA009Accident · 1 fatalClosedPiper PA-28R · North Wales, PANov 23, 1977 · N1018L · Destroyed NTSB NYC78FGM10Accident · Serious injuriesClosedGrum Amer AA-5A · Seven Springs, PANov 20, 1977 · N9993U · Substantial damage NTSB NYC78FHA06Accident · Minor injuriesClosedWaco UPF7 · Tannersville, PANov 19, 1977 · N167K · Substantial damage NTSB NYC78FGM09Accident · Minor injuriesClosedPiper PA-28 · Jeannette, PANov 19, 1977 · N4873T · Substantial damage NTSB NYC78FGT01Accident · Serious injuriesClosedLark 2BB2 · Tyrone, PANov 18, 1977 · N28TD · Substantial damage NTSB NYC78FGM08Accident · Serious injuriesClosedAero Comdr 560E · Queen, PANov 17, 1977 · N3837C · Substantial damage NTSB NYC78DHA04Accident · No injuriesClosedEnstrom F28A · Scranton, PANov 7, 1977 · N9272 · Substantial damage NTSB NYC78FHA03Accident · Minor injuriesClosedCessna 150M · Bethel, PANov 1, 1977 · N714HG · Destroyed NTSB NYC78FGM07Accident · No injuriesClosedHelio Acft 391 · Bedford, PAOct 28, 1977 · N4169D · Substantial damage NTSB NYC78FGM06Accident · Minor injuriesClosedBeechcraft B58 · Ebensburg, PAOct 26, 1977 · N830CC · Substantial damage NTSB NYC78FGM05Accident · No injuriesClosedMaule M-5 · Butler, PAOct 20, 1977 · N396X · Substantial damage NTSB NYC77DGM03Accident · No injuriesClosedPiper PA-28 · Belle Vernon, PAOct 16, 1977 · N5829U · Substantial damage NTSB NYC78FHA01Accident · No injuriesClosedSchweizer 2-33 · Beltzville, PAOct 15, 1977 · N1196S · Substantial damage NTSB NYC78FGM04Accident · No injuriesClosedTaylorcraft L-2M · Finleyville, PAOct 15, 1977 · N47282 · Substantial damage NTSB NYC78DGM02Accident · Serious injuriesClosedCessna 150 · Edinboro, PAOct 10, 1977 · N61084 · Substantial damage NTSB NYC78FGM01Accident · No injuriesClosedPiper PA-32 · Corry, PAOct 7, 1977 · N33408 · Substantial damage NTSB NYC77FGM47Accident · No injuriesClosedPitts Spcl · Franklin, PASep 29, 1977 · N2232 · Substantial damage NTSB NYC77FA099Accident · 2 fatalClosedCessna 402B · Mercer, PASep 29, 1977 · N69338 · Destroyed NTSB NYC77FGM48Accident · No injuriesClosedBell 206B · Clearfield, PASep 28, 1977 · N301JT · Substantial damage NTSB NYC78FGM46Accident · No injuriesClosedPiper PA-28 · Monroeville, PASep 24, 1977 · N41491 · Substantial damage NTSB NYC77FGM45Accident · Serious injuriesClosedMiniplane DS · Ebensburg, PASep 18, 1977 · N4671T · Destroyed NTSB NYC77FGM44Accident · No injuriesClosedPiper PA-22 · Titusville, PASep 18, 1977 · N3240Z · Substantial damage NTSB NYC77DHD31Accident · No injuriesClosedCessna 150 · Blue Bell, PASep 12, 1977 · N63176 · Substantial damage NTSB NYC77DHA26Accident · No injuriesClosedGlobe GC1B · Pottstown, PASep 11, 1977 · N78110 · Substantial damage NTSB NYC77FHA37Accident · No injuriesClosedCessna 310 · Doylestown, PASep 8, 1977 · N310W · Substantial damage NTSB NYC77FGM43Accident · Minor injuriesClosedCessna 172 · Somerset, PASep 7, 1977 · N9881T · Substantial damage NTSB NYC77FGM42Accident · Minor injuriesClosedPiper PA-28 · New Florence, PASep 5, 1977 · N6379W · Substantial damage NTSB NYC77FGM41Accident · No injuriesClosedBeech 23 · Finleyville, PASep 5, 1977 · N2363J · Substantial damage NTSB NYC77FA095Accident · 2 fatalClosedTaylorcraft BC1265 · Oval, PASep 5, 1977 · N36128 · Substantial damage NTSB NYC77DHA35Accident · No injuriesClosedCessna 195 · Ottsville, PASep 1, 1977 · N195JW · Substantial damage NTSB NYC77FGM40Accident · No injuriesClosedNavion A · Belle Vernon, PAAug 31, 1977 · N4131K · Substantial damage NTSB NYC77FA092Accident · Serious injuriesClosedNord-Avion 262 · Philadelphia, PAAug 31, 1977 · N7885A · No damage NTSB NYC77FA089Accident · 1 fatalClosedCessna 195B · Mt Holley Spgs, PAAug 28, 1977 · N4404C · Destroyed NTSB NYC77FA088Accident · 4 fatalClosedBeech F35 · North Wales, PAAug 28, 1977 · N3357C · Destroyed NTSB NYC77FGM39Accident · No injuriesClosedBlumfeldt Sport · Washington, PAAug 26, 1977 · N9052 · Substantial damage NTSB NYC77FHA33Accident · Serious injuriesClosedPiper PA-32 · Mt.Pocona, PAAug 25, 1977 · N4023W · Substantial damage NTSB NYC77FHD27Accident · Minor injuriesClosedPiper PA-28R · West Chester, PAAug 23, 1977 · N3932R · Substantial damage NTSB NYC77FGM38Accident · Minor injuriesClosedCessna 172 · Champion, PAAug 21, 1977 · N13501 · Substantial damage NTSB NYC77FA085Accident · 1 fatalClosedBeech P35 · Pittsburgh, PAAug 21, 1977 · N446Q · Destroyed NTSB NYC77FGM37Accident · No injuriesClosedStarduster TOO · Grove City, PAAug 20, 1977 · N3263 · Substantial damage NTSB NYC77FGM36Accident · No injuriesClosedGrum Amer AA1-B · Pittsburgh, PAAug 19, 1977 · N1481R · Substantial damage NTSB NYC77FA084Accident · 1 fatalClosedDehavilland DHC-2 · Morrisville, PAAug 19, 1977 · N67690 · Destroyed NTSB NYC77FA082Accident · Serious injuriesClosedBeech G18S · Pittsburgh, PAAug 17, 1977 · N75FA · Substantial damage