Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 NYC76DHD15Accident · No injuriesClosedCessna 150L · West Chester, PADec 28, 1975 · N1240Q · 2 aircraft · Substantial damage NTSB NYC76AN060Accident · 1 fatalClosedBeech D18S · Bloserville, PADec 24, 1975 · N91A · Destroyed NTSB NYC76AN059Accident · Serious injuriesClosedBeech C55 · Doylestown, PADec 23, 1975 · N236WC · Destroyed NTSB NYC76DHD07Accident · No injuriesClosedCessna 150 · West Chester, PADec 20, 1975 · N1410Q · Substantial damage NTSB NYC76FGM14Accident · Minor injuriesClosedPiper PA-28R · Greenville, PADec 18, 1975 · N2766R · Substantial damage NTSB NYC76AN055Accident · 1 fatalClosedPiper PA-28R · Erie, PADec 14, 1975 · N393HP · Destroyed NTSB NYC76FHD14Accident · Minor injuriesClosedPiper PA-32 · Kennett Square, PADec 13, 1975 · N4005R · Destroyed NTSB NYC76FGM19Accident · No injuriesClosedBeech S35 · Meadville, PADec 11, 1975 · N239S · Substantial damage NTSB NYC76DGM18Accident · No injuriesClosedStinson 108 · Listonburg, PADec 6, 1975 · N8212K · Substantial damage NTSB NYC76DGM17Accident · No injuriesClosedFunk B75L · Slippery Rock, PADec 5, 1975 · N22683 · Substantial damage NTSB NYC76FHA18Accident · Minor injuriesClosedPiper PA-28 · Avoca, PADec 3, 1975 · N5140L · Substantial damage NTSB NYC76FGT13Accident · Serious injuriesClosedSchweizer 2-33 · Unionville, PADec 3, 1975 · N2400W · Destroyed NTSB NYC76FGM16Accident · No injuriesClosedPiper PA-28R · Pittsburgh, PANov 30, 1975 · N3993X · Substantial damage NTSB NYC76DGM15Accident · No injuriesClosedBell 206B · Lumber City, PANov 29, 1975 · N49636 · Substantial damage NTSB IAD76II035Incident · No injuriesClosedLockheed L1329 · N Philadelphia, PANov 20, 1975 · N1 · Minor damage NTSB NYC76FGT11Accident · No injuriesClosedAerostar 600 · Blanchard, PANov 16, 1975 · N7466S · Substantial damage NTSB NYC76FGT12Accident · No injuriesClosedSchweizer 2-33 · Julian, PANov 15, 1975 · N7703S · Substantial damage NTSB NYC76FGT10Accident · Minor injuriesClosedSchweizer 1-23D · Wingate, PANov 14, 1975 · N7840C · Substantial damage NTSB NYC76FHD13Accident · Serious injuriesClosedPiper PA-28 · Coatesville, PANov 9, 1975 · N8771N · Substantial damage NTSB NYC76AN049Accident · 4 fatalClosedNa Rockwell 112 · State College, PANov 7, 1975 · N4QA · Destroyed NTSB NYC76FGM13Accident · No injuriesClosedCessna 150 · Brideville, PANov 6, 1975 · N11164 · Substantial damage NTSB NYC76FHM13Accident · No injuriesClosedAeronca 7AC · Erwinna, PANov 1, 1975 · N83219 · Substantial damage NTSB IAD76FGM12Accident · Minor injuriesClosedMooney M20B · Erie, PAOct 30, 1975 · N74535 · Substantial damage NTSB NYC76FGM11Accident · Minor injuriesClosedCessna 172K · Haydentown, PAOct 28, 1975 · N46698 · Substantial damage NTSB NYC76DHD12Accident · No injuriesClosedGrum Amer AA1-B · Bristol, PAOct 27, 1975 · N9605L · Substantial damage NTSB NYC76FGT09Accident · No injuriesClosedPiper PA-28 · Hanover, PAOct 26, 1975 · N16434 · Substantial damage NTSB NYC76FHA15Accident · No injuriesClosedCessna 182P · Franklin Forks, PAOct 22, 1975 · N58525 · Substantial damage NTSB NYC76AN044Accident · No injuriesClosedBell 47J-2 · Conshocken, PAOct 22, 1975 · N3939B · Substantial damage NTSB NYC76FGT08Accident · No injuriesClosedCessna 182K · Gettysburg, PAOct 15, 1975 · N2823R · Substantial damage NTSB NYC76FGM10Accident · Minor injuriesClosedPiper PA-28 · Freeport, PAOct 8, 1975 · N6097W · Substantial damage NTSB NYC76FGT07Accident · Minor injuriesClosedCessna 182 · Columbia, PAOct 6, 1975 · N6295A · Destroyed NTSB NYC76FGT06Accident · No injuriesClosedPitts Spcl · Maytown, PAOct 4, 1975 · N7T · Destroyed NTSB LAX76IL023Incident · Serious injuriesClosedLockheed 1011 · Philadelphia, PAOct 2, 1975 · N31013 · No damage NTSB NYC76DHA14Accident · Minor injuriesClosedCessna 140 · New Milford, PAOct 1, 1975 · N2187V · Substantial damage NTSB NYC76FGM09Accident · Minor injuriesClosedMorrison Teenie · Greenville, PASep 28, 1975 · N2486 · Substantial damage NTSB NYC76FHA11Accident · Serious injuriesClosedPiper PA-22 · Limeport, PASep 26, 1975 · N2930Z · Substantial damage NTSB NYC76FGM08Accident · No injuriesClosedCessna 411 · New Castle, PASep 23, 1975 · N3212R · Substantial damage NTSB NYC76FGT04Accident · Minor injuriesClosedPiper PA-22 · Centre Hall, PASep 14, 1975 · N3282B · Substantial damage NTSB NYC76FGT03Accident · No injuriesClosedGrum Amer AA1-B · New Oxford, PASep 14, 1975 · N9976L · Substantial damage NTSB NYC76DGM06Accident · No injuriesClosedMitsubishi MU-2B · Bedford, PASep 14, 1975 · N492MA · Substantial damage NTSB NYC76FGT05Accident · No injuriesClosedSchemp Cirrus · Fairfield, PASep 13, 1975 · N6485 · Substantial damage NTSB NYC76AN033Accident · 4 fatalClosedRockwell 690A · Nemacolin, PASep 12, 1975 · N847CE · Destroyed NTSB NYC7LDHA10Accident · No injuriesClosedPiper PA-32 · Prospectville, PASep 7, 1975 · N899MA · Substantial damage NTSB NYC76FGM05Accident · No injuriesClosedHiller Acft UH-12B · Beaver Falls, PASep 3, 1975 · N90424 · Substantial damage NTSB NYC76DGM24Accident · No injuriesClosedCessna 337 · Jeannette, PAAug 23, 1975 · N2323S · Substantial damage NTSB NYC76DHA08Accident · Minor injuriesClosedBellanca 7AC · Zieglerville, PAAug 20, 1975 · N9162L · Substantial damage NTSB NYC76FGT02Accident · No injuriesClosedAeronca 11AC · Pine Grove, PAAug 10, 1975 · N9589E · Substantial damage NTSB NYC76AN021Accident · 2 fatalClosedMaule ME4 · Hydetown, PAAug 9, 1975 · N51161 · Destroyed NTSB NYC76FHD03Accident · No injuriesClosedPiper PA-32 · Philadelphia, PAAug 8, 1975 · N56503 · Substantial damage NTSB NYC76FGM03Accident · Minor injuriesClosedPiper PA-22 · Cooperstown, PAAug 7, 1975 · N939A · Substantial damage