Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 NYC80FGM09Accident · No injuriesClosedCessna 140 · Butler, PADec 15, 1979 · N90035 · Substantial damage NTSB NYC80FGT04Accident · No injuriesClosedCessna 172RG · Camp Hill, PADec 6, 1979 · N6286R · Substantial damage NTSB NYC80FA014Accident · 1 fatalClosedPiper PA-28 · Watsontown, PANov 29, 1979 · N2916Q · Substantial damage NTSB NYC80FA013Accident · Serious injuriesClosedCessna U206G · Springbrook, PANov 26, 1979 · N732HT · Destroyed NTSB NYC80FGM08Accident · No injuriesClosedLake LA4200 · New Castle, PANov 25, 1979 · C-GLOV · Substantial damage NTSB NYC80FGT03Accident · No injuriesClosedPiper PA-28R · Still Creek, PANov 24, 1979 · N4524T · Substantial damage NTSB NYC80FGM07Accident · No injuriesClosedBeech A-23 · Latrobe, PANov 17, 1979 · N6919Q · Substantial damage NTSB NYC80DGT02Accident · No injuriesClosedCessna 172 · Gaines, PANov 15, 1979 · N12912 · Substantial damage NTSB NYC80FGM06Accident · No injuriesClosedCessna C152 · Belle Vernon, PANov 7, 1979 · N757RA · Substantial damage NTSB NYC80FGM05Accident · Minor injuriesClosedCessna 152 · Jeannette, PAOct 30, 1979 · N757FN · Substantial damage NTSB NYC80FGM04Accident · No injuriesClosedCessna TR-182 · Connellsville, PAOct 30, 1979 · N7188C · Substantial damage NTSB NYC80DHD05Accident · No injuriesClosedPiper PA-32 · West Chester, PAOct 29, 1979 · N55476 · Substantial damage NTSB NYC80DHA01Accident · No injuriesClosedBeech 58 · Reading, PAOct 27, 1979 · N6094S · Substantial damage NTSB NYC80FHD04Accident · Minor injuriesClosedAerospatle SA341G · Philadelphia, PAOct 23, 1979 · N119SF · Destroyed NTSB NYC80FGM03Accident · Minor injuriesClosedBeech A23 · Bradford, PAOct 22, 1979 · N8865M · Substantial damage NTSB NYC80FGT01Accident · No injuriesClosedSchweizer SGS135 · Port Matilda, PAOct 14, 1979 · N34182 · Substantial damage NTSB NYC80FA005Accident · 1 fatalClosedPiper PA-31 · Uniontown, PAOct 9, 1979 · N9277Y · Destroyed NTSB NYC80FGM02Accident · No injuriesClosedCessna 152 · Butler, PAOct 6, 1979 · N64932 · Substantial damage NTSB NYC80FGM01Accident · Minor injuriesClosedPiper PA-28 · Connellsville, PAOct 4, 1979 · N3075N · Substantial damage NTSB NYC79FGM48Accident · No injuriesClosedPiper PA-32 · Erie, PASep 24, 1979 · N6838J · Substantial damage NTSB NYC79DHA28Accident · No injuriesClosedCessna 182P · Moscow, PASep 21, 1979 · N52718 · Destroyed NTSB NYC79FGM47Accident · Minor injuriesClosedTeenie 2 · Greenville, PASep 17, 1979 · N7FB · Substantial damage NTSB NYC79FGT21Accident · No injuriesClosedCessna 150 · Atglen, PASep 15, 1979 · N2876V · Substantial damage NTSB NYC79FA098Accident · No injuriesClosedPiper PA-23 · Philadelphia, PASep 14, 1979 · N8017J · Substantial damage NTSB NYC79FA092Accident · 1 fatalClosedBellanca 17-30A · Hanover, PASep 9, 1979 · N102CB · Destroyed NTSB NYC79FHA26Accident · No injuriesClosedBoeing B75N1 · E Stroudsburg, PASep 7, 1979 · N747Q · Substantial damage NTSB NYC79FA090Accident · 3 fatalClosedPiper PA-28 · No.Whitehall, PASep 5, 1979 · N6275W · Destroyed NTSB NYC79FA088Accident · 1 fatalClosedAeronca 7AC · Edinboro, PASep 3, 1979 · N83122 · Destroyed NTSB NYC79DHA25Accident · No injuriesClosedCessna 172F · Brecknock, PASep 3, 1979 · N5689R · Substantial damage NTSB NYC80FA085Accident · 1 fatalClosedBeech 58 · Middletown, PAAug 30, 1979 · N868AF · Destroyed NTSB NYC79FGM46Accident · No injuriesClosedCessna 180 · Erie, PAAug 29, 1979 · N7746A · Substantial damage NTSB NYC79FGM45Accident · No injuriesClosedPiper PA-23 · Connellsville, PAAug 28, 1979 · N2033P · Substantial damage NTSB NYC79FA081Accident · 1 fatalClosedCessna 152 · Kunkletown, PAAug 19, 1979 · N49080 · Destroyed NTSB NYC79FGM44Accident · Serious injuriesClosedEnstrom F28C · Erie, PAAug 18, 1979 · N573H · Destroyed NTSB NYC79FA079Accident · 1 fatalClosedCessna 172M · Mount Union, PAAug 18, 1979 · N6630H · Destroyed NTSB NYC79FGM42Accident · No injuriesClosedBeech B-24R · Youngsville, PAAug 12, 1979 · N9250S · Substantial damage NTSB NYC79FHA20Accident · No injuriesClosedPiper PA-38 · Prospectville, PAAug 9, 1979 · N9387T · Substantial damage NTSB NYC79DHA24Accident · Minor injuriesClosedCessna 172 · Lederach, PAAug 9, 1979 · N145ML · Substantial damage NTSB NYC79IA072Incident · No injuriesClosedShort Bros SD3-30 · Reading, PAAug 6, 1979 · N724SA · Minor damage NTSB NYC79FHA18Accident · No injuriesClosedCessna 172 · Germansville, PAAug 2, 1979 · N1543Y · Substantial damage NTSB NYC79FGM41Accident · Minor injuriesClosedPitts S1S · Bedford, PAAug 1, 1979 · N8004 · Substantial damage NTSB NYC79FGM39Accident · No injuriesClosedCessna 177RG · Johnstown, PAJul 31, 1979 · N2559V · Substantial damage NTSB NYC79FGM40Accident · No injuriesClosedHughes 300C · Barnesboro, PAJul 30, 1979 · N8641F · Destroyed NTSB NYC79FGM38Accident · Serious injuriesClosedPiper PA-28 · Greensburg, PAJul 30, 1979 · N69EJ · Destroyed NTSB NYC79FA067Accident · 1 fatalClosedLuscombe 8A · Clarion, PAJul 28, 1979 · N1159B · Destroyed NTSB UNK79X0114Accident · Minor injuriesClosedCessna 150 · Willow Grove, PAJul 26, 1979 · N63150 · Destroyed NTSB NYC79FGM37Accident · No injuriesClosedGrum Amer AA-1 · Monroeville, PAJul 22, 1979 · N5908L · Substantial damage NTSB NYC79DA069Incident · No injuriesClosedPiper PA-24 · Pittsburgh, PAJul 19, 1979 · N8250P · No damage NTSB NYC79FGM35Accident · No injuriesClosedCessna 150 · Zelienople, PAJul 17, 1979 · N19138 · Substantial damage NTSB NYC79FA058Accident · 4 fatalClosedPiper PA-28 · Blng Springs, PAJul 15, 1979 · N2216G · Destroyed