Skip to content

NTSB investigations, 1978, PA

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

19632026

NTSB investigations, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 NYC79FGM13Accident · No injuriesClosedGrum Amer AA-5A · Somerset, PADec 28, 1978 · N26078 · Substantial damage NTSB NYC79FHA06Accident · No injuriesClosedSchweizer 2-33A · Kutztown, PADec 23, 1978 · N2056T · Substantial damage NTSB NYC79FGM08Accident · Minor injuriesClosedEnstrom F28A · Washington, PADec 16, 1978 · N289Q · Substantial damage NTSB NYC79FGT07Accident · No injuriesClosedBeech C45H · Philipsburg, PADec 13, 1978 · N702AP · Substantial damage NTSB NYC79DGM07Accident · No injuriesClosedCessna 152 · Tarentum, PADec 13, 1978 · N757MB · Substantial damage NTSB NYC79FA012Accident · 3 fatalClosedCessna 172F · Mcadoo, PANov 23, 1978 · N5170F · Substantial damage NTSB NYC79FGT06Accident · No injuriesClosedPiper PA-28 · Shippensburg, PANov 22, 1978 · N98009 · Substantial damage NTSB NYC79FGT05Accident · No injuriesClosedPiper 601P · Lock Haven, PANov 17, 1978 · G-BVIP · Substantial damage NTSB NYC79FHA03Accident · No injuriesClosedPiper PA-28 · Prospectville, PANov 15, 1978 · N8706E · Substantial damage NTSB NYC79FGT04Accident · No injuriesClosedPiper PA-23 · Towanda, PANov 7, 1978 · N6159Y · Substantial damage NTSB NYC79FA008Accident · 1 fatalClosedCessna 152 · West Mifflin, PANov 5, 1978 · N25507 · Destroyed NTSB NYC79FGT03Accident · Minor injuriesClosedCessna 182 · New Oxford, PANov 4, 1978 · N21212 · Substantial damage NTSB NYC79FHA04Accident · No injuriesClosedAnderson AK-1 · Warminister, PAOct 30, 1978 · N21W · Substantial damage NTSB NYC79FGM06Accident · No injuriesClosedGreat Lakes Baby · Belle Vernon, PAOct 29, 1978 · N66DP · Substantial damage NTSB NYC79FGM05Accident · No injuriesClosedCessna 337 · Erie, PAOct 29, 1978 · N72389 · Substantial damage NTSB NYC79FA005Accident · 1 fatalClosedPiper PA-28 · Great Bend, PAOct 27, 1978 · N5622W · Destroyed NTSB NYC79FGT02Accident · 1 fatalClosedGyrocopter JW-1 · Smoketown, PAOct 22, 1978 · N4280 · Substantial damage NTSB NYC79FA004Accident · 2 fatalClosedEnstrom F-28A · Bakertown, PAOct 12, 1978 · N257Q · Destroyed NTSB NYC79DHA02Accident · No injuriesClosedPiper PA-28 · Lehighton, PAOct 11, 1978 · N7462R · Substantial damage NTSB NYC79FGM04Accident · No injuriesClosedPiper PA-22 · Franklin, PAOct 9, 1978 · N3209Z · Substantial damage NTSB NYC79FGM03Accident · Serious injuriesClosedExprmntl KR-2 · Belle Vernon, PAOct 9, 1978 · N26JL · Destroyed NTSB NYC79FGM02Accident · Minor injuriesClosedPiper PA-23 · Monroeville, PAOct 4, 1978 · N4862P · Substantial damage NTSB NYC79FGT01Accident · No injuriesClosedCessna 172 · Hanover, PAOct 3, 1978 · N9320H · Substantial damage NTSB NYC79DHA01Accident · No injuriesClosedCessna 150 · Avoca, PAOct 2, 1978 · N6625Y · Substantial damage NTSB NYC78FGM54Accident · No injuriesClosedPiper PA-28R · Pittsburgh, PASep 30, 1978 · N1143H · Substantial damage NTSB NYC78DHA40Accident · No injuriesClosedSchweitzer 1-35C · Kutztown, PASep 30, 1978 · N2776H · Substantial damage NTSB NYC78FA099Accident · No injuriesClosedPiper PA-28 · Beaver Falls, PASep 28, 1978 · N43165 · Destroyed NTSB NYC79FGM01Accident · Minor injuriesClosedDuster BU-18 · Eighty Four, PASep 23, 1978 · N12DQ · Substantial damage NTSB NYC78FHA37Accident · 1 fatalClosedSoneria II · Pipersville, PASep 23, 1978 · N81915 · Substantial damage NTSB NYC78DHA36Accident · No injuriesClosedBeech 23 · Warrington, PASep 23, 1978 · N23987 · Substantial damage NTSB NYC78FGM52Accident · Minor injuriesClosedPiper J-3 · Somerset, PASep 22, 1978 · N6720H · Substantial damage NTSB NYC78FHA38Accident · No injuriesClosedCessna 206 · Prospectville, PASep 21, 1978 · N1872N · Substantial damage NTSB NYC78FHA34Accident · No injuriesClosedStearman PT-17 · Pottstown, PASep 17, 1978 · N46Y · Substantial damage NTSB NYC78FGM51Accident · Serious injuriesClosedAeronca 7HC · Bridgeville, PASep 17, 1978 · N9845Y · Destroyed NTSB NYC78FA094Accident · 1 fatalClosedCessna 182 · Dupont, PASep 15, 1978 · N9237G · Substantial damage NTSB NYC78FA090Accident · 2 fatalClosedPiper PA-32 · Honesdale, PASep 10, 1978 · N789CC · Destroyed NTSB NYC78FA088Accident · No injuriesClosedHughes 269C · Derry, PASep 4, 1978 · N7466F · Substantial damage NTSB NYC78FGT16Accident · No injuriesClosedBeech F35 · White Pine, PASep 2, 1978 · N5023B · Substantial damage NTSB NYC78FGM50Accident · No injuriesClosedCessna 175B · Conneaut, PASep 2, 1978 · N8226T · Substantial damage NTSB NYC78FGM49Accident · Serious injuriesClosedSchweizer 2-33 · Freeport, PASep 2, 1978 · N33941 · Substantial damage NTSB NYC78FGT17Accident · No injuriesClosedLake 4-200 · Sunbury, PASep 1, 1978 · N62032 · Substantial damage NTSB NYC78FGM48Accident · No injuriesClosedPiper PA-28 · Grove City, PAAug 31, 1978 · N669FL · Substantial damage NTSB NYC78FGT14Accident · No injuriesClosedCessna 172 · Hershey, PAAug 29, 1978 · N833G · Substantial damage NTSB NYC78FGM47Accident · No injuriesClosedGrum Amer AA1-B · Mckeesport, PAAug 27, 1978 · N1480R · Substantial damage NTSB NYC78FA086Accident · No injuriesClosedCessna 150 · Duncannon, PAAug 27, 1978 · N714CR · Substantial damage NTSB NYC78FGT15Accident · No injuriesClosedGrum Amer AA-5B · Marietta, PAAug 26, 1978 · N1519R · Substantial damage NTSB NYC78FGT13Accident · Minor injuriesClosedPiper PA-28 · Thomasville, PAAug 21, 1978 · N652FL · Destroyed NTSB NYC78FGM45Accident · No injuriesClosedCessna 150 · Franklin, PAAug 17, 1978 · N10687 · Substantial damage NTSB NYC78FGM44Accident · Serious injuriesClosedCessna 337 · Cutty, PAAug 16, 1978 · N1146M · Substantial damage NTSB NYC78FGT12Accident · No injuriesClosedPiper PA-28 · Schaefferstown, PAAug 10, 1978 · N575V · Substantial damage