Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 NYC72AN085Accident · 1 fatalClosedPiper PA-28 · Malvern, PADec 30, 1971 · N6047W · Destroyed NTSB NYC72DHA28Accident · No injuriesClosedBeech B23 · Doylestown, PADec 26, 1971 · N6127N · Substantial damage NTSB NYC72FGM27Accident · Serious injuriesClosedBeech 23 · Mcmurray, PADec 25, 1971 · N2379Z · Substantial damage NTSB NYC72AN083Accident · 1 fatalClosedCessna 150B · Allentown, PADec 24, 1971 · N1180Y · Destroyed NTSB NYC72AN078Accident · 4 fatalClosedChampion 7KCAB · Erwinna, PADec 12, 1971 · N5197X · 2 aircraft · Destroyed NTSB NYC72FGM25Accident · No injuriesClosedMooney M20C · Monroeville, PADec 11, 1971 · N78921 · Substantial damage NTSB NYC72FGM24Accident · No injuriesClosedCessna 182K · Sharon, PADec 11, 1971 · N2742Q · Substantial damage NTSB NYC72FGM23Accident · No injuriesClosedCessna 172L · West Mifflin, PADec 10, 1971 · N2853Q · Substantial damage NTSB NYC72DGM26Accident · No injuriesClosedCessna 172 · Somerset, PADec 5, 1971 · N8285L · Substantial damage NTSB NYC72AN070Accident · 3 fatalClosedCessna 170B · Fallston, PANov 28, 1971 · N2535D · 2 aircraft · Destroyed NTSB NYC72FHA27Accident · No injuriesClosedPiper PA-28 · Quakertown, PANov 26, 1971 · N471FL · Substantial damage NTSB NYC72FGT06Accident · No injuriesClosedCessna 195 · Hershey, PANov 23, 1971 · N4338N · Substantial damage NTSB NYC72FHA26Accident · No injuriesClosedSchweizer SGS126 · Kutztown, PANov 21, 1971 · N1136S · Substantial damage NTSB NYC72FHA25Accident · No injuriesClosedAero Comdr 500-S · Allentown, PANov 13, 1971 · N5031E · Substantial damage NTSB NYC72FHA24Accident · No injuriesClosedBeech S35 · Breinigsville, PANov 9, 1971 · N5770K · Substantial damage NTSB NYC72DGM22Accident · No injuriesClosedPiper PA-28 · Valencia, PANov 6, 1971 · N7140R · Substantial damage NTSB NYC72DHA23Accident · No injuriesClosedPiper PA-32 · Hamburg, PANov 5, 1971 · N3559W · Substantial damage NTSB NYC72AN061Accident · 4 fatalClosedPiper PA-28 · Boalsburg, PAOct 31, 1971 · N9287J · Destroyed NTSB NYC72FGM21Accident · Minor injuriesClosedPiper PA-22 · Somerset, PAOct 30, 1971 · N7423D · Substantial damage NTSB NYC72FHD19Accident · No injuriesClosedBeech 95-55 · Philadelphia, PAOct 29, 1971 · N77MW · Substantial damage NTSB NYC72AN059Accident · 4 fatalClosedBeech B99 · Bath, PAOct 24, 1971 · N986MA · Destroyed NTSB NYC72FGM20Accident · No injuriesClosedCessna 150L · Bridgeville, PAOct 23, 1971 · N1310Q · Substantial damage NTSB NYC72FGT05Accident · No injuriesClosedCessna 182E · Dushore, PAOct 19, 1971 · N9391X · Substantial damage NTSB NYC72FHA20Accident · No injuriesClosedBeech B23 · Thompson, PAOct 17, 1971 · N6118N · Substantial damage NTSB NYC72AN051Accident · 1 fatalClosedPiper PA-28R · Washingtnville, PAOct 10, 1971 · N2941R · Destroyed NTSB NYC72DHA18Accident · No injuriesClosedCessna 150 · Perkasie, PAOct 8, 1971 · N6759G · Substantial damage NTSB NYC72AN049Accident · 4 fatalClosedCessna 172L · Meyerstown, PAOct 8, 1971 · N7527G · 2 aircraft · Substantial damage NTSB NYC72AN048Accident · 3 fatalClosedMooney M21 · Zelienople, PAOct 8, 1971 · N9472V · Destroyed NTSB NYC72FGM19Accident · Minor injuriesClosedPiper PA-28 · Franklin, PAOct 4, 1971 · N6097W · Substantial damage NTSB NYC72AN047Accident · 2 fatalClosedNavion B · Hazleton, PAOct 4, 1971 · N5259K · Destroyed NTSB NYC72DGM17Accident · Minor injuriesClosedPiper PA-32 · Central City, PASep 25, 1971 · N3698W · Substantial damage NTSB NYC72FGM16Accident · Serious injuriesClosedGibson VPI · Belle Vernon, PASep 24, 1971 · N5186 · Substantial damage NTSB NYC72FHA17Accident · No injuriesClosedCessna 172 · Kempton, PASep 23, 1971 · N7558G · Substantial damage NTSB NYC72FHD15Accident · No injuriesClosedPiper PA-39 · Ambler, PASep 22, 1971 · N8898Y · Substantial damage NTSB NYC72DGM18Accident · No injuriesClosedStarduster TOO · Indiana, PASep 22, 1971 · N2361 · Substantial damage NTSB NYC72FHA16Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PASep 21, 1971 · N1205S · Substantial damage NTSB NYC72AN042Accident · 2 fatalClosedPiper PA-28 · Orson, PASep 19, 1971 · N5507F · Destroyed NTSB NYC72AN043Accident · 4 fatalClosedPiper PA-23 · Mainesburg, PASep 18, 1971 · CF-KKM · Destroyed NTSB NYC72AN038Accident · Minor injuriesClosedLockheed PV-1 · Philadelphia, PASep 11, 1971 · N725YC · Destroyed NTSB NYC72FHD13Accident · No injuriesClosedBeech 70 · Philadelphia, PASep 9, 1971 · N795Q · Substantial damage NTSB NYC72FGM14Accident · No injuriesClosedPiper PA-22 · Prospect, PASep 8, 1971 · N7348D · Substantial damage NTSB NYC72DGM15Accident · No injuriesClosedCessna 150 · Eighty Four, PASep 5, 1971 · N61038 · Substantial damage NTSB NYC72FHA15Accident · No injuriesClosedAero Comdr 100 · Warrington, PASep 3, 1971 · N3859X · Substantial damage NTSB NYC72FGM13Accident · No injuriesClosedPiper PA-24 · Brookville, PASep 2, 1971 · N5737P · Substantial damage NTSB NYC72FGT03Accident · Minor injuriesClosedPiper PA-39 · W Milton, PAAug 31, 1971 · N8843Y · Destroyed NTSB NYC72FHA14Accident · No injuriesClosedErco 415-C · Doylestown, PAAug 29, 1971 · N87089 · Substantial damage NTSB NYC72DHA12Accident · No injuriesClosedCessna 172 · Collegeville, PAAug 23, 1971 · N7227G · Substantial damage NTSB NYC72DHA11Accident · No injuriesClosedPiper PA-28 · Prospectville, PAAug 23, 1971 · N7307J · Substantial damage NTSB NYC72DHD09Accident · No injuriesClosedPiper PA-24 · Gap, PAAug 22, 1971 · N7753P · Substantial damage NTSB NYC72DHA10Accident · No injuriesClosedPiper PA-28 · Souderton, PAAug 22, 1971 · N6214W · Substantial damage