Skip to content

NTSB investigations, 1974, PA

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1974, PA per year, 1963–2026: 4,233 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	13

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") = 1974 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\") = 1974
    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") = 1974
  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 NYC75FGT10Accident · No injuriesClosedPiper PA-24 · Frackville, PADec 31, 1974 · N5197P · Substantial damage NTSB NYC75DHA26Accident · No injuriesClosedStinson 108-1 · Spring City, PADec 31, 1974 · N8854K · Substantial damage NTSB NYC75AN078Accident · 2 fatalClosedPiper PA-32 · Fairchance, PADec 30, 1974 · N32264 · Destroyed NTSB NYC75DHD28Accident · No injuriesClosedPiper PA-32 · West Chester, PADec 26, 1974 · N56982 · Substantial damage NTSB NYC75FHD27Accident · Minor injuriesClosedErco 415-C · West Chester, PADec 23, 1974 · N99907 · Substantial damage NTSB NYC75DHA24Accident · No injuriesClosedCessna 150 · Honesdale, PADec 18, 1974 · N4593U · Substantial damage NTSB NYC75AN074Accident · 3 fatalClosedCessna 172 · Philipsburg, PADec 12, 1974 · N5868A · Destroyed NTSB NYC75IN073Incident · No injuriesClosedBeech G18S · Philadelphia, PADec 10, 1974 · N730M · Minor damage NTSB NYC75FHA23Accident · No injuriesClosedPiper PA-23 · Forty Fort, PADec 3, 1974 · N1071D · Substantial damage NTSB NYC75AN071Accident · No injuriesClosedCessna 402B · Meadville, PADec 3, 1974 · N8203P · Substantial damage NTSB NYC75AN069Accident · 4 fatalClosedCessna 182 · Erie, PANov 28, 1974 · N2433X · Destroyed NTSB NYC75DHA22Accident · No injuriesClosedPiper PA-28 · Queen City, PANov 24, 1974 · N2438R · Substantial damage NTSB NYC75FGM21Accident · Minor injuriesClosedPiper PA-34 · Edensburg, PANov 23, 1974 · N15260 · Destroyed NTSB NYC75FGM19Accident · No injuriesClosedNavion A · Martinsburg, PANov 17, 1974 · N4505K · Substantial damage NTSB NYC75FGM18Accident · No injuriesClosedPiper PA-28 · Franklin, PANov 16, 1974 · N55458 · Substantial damage NTSB NYC75AN062Accident · No injuriesClosedPiper PA-23 · Philadelphia, PANov 15, 1974 · N40254 · Substantial damage NTSB NYC75DHD12Accident · No injuriesClosedChampion 7GCAA · West Chester, PANov 9, 1974 · N86647 · Substantial damage NTSB NYC75FGM17Accident · No injuriesClosedBeech A23A · Meyersdale, PANov 3, 1974 · N7936L · Substantial damage NTSB NYC75FHA20Accident · No injuriesClosedPiper PA-24 · Reading, PAOct 29, 1974 · N9056P · Substantial damage NTSB NYC75FGM16Accident · Minor injuriesClosedCessna 210 · Johnstown, PAOct 28, 1974 · N7320E · Substantial damage NTSB NYC75FGT09Accident · No injuriesClosedBeech E18S · Mcsherrytown, PAOct 27, 1974 · N3666G · Substantial damage NTSB NYC75FGM15Accident · Minor injuriesClosedBrantly B-2B · Sharon, PAOct 26, 1974 · N2280U · Substantial damage NTSB NYC75FGM14Accident · No injuriesClosedBeech 65 · Clarion, PAOct 19, 1974 · N836U · Substantial damage NTSB NYC74AN050Accident · 1 fatalClosedPiper PA-28 · Montgomeryvl, PAOct 18, 1974 · N4825L · Destroyed NTSB NYC75AN049Accident · No injuriesClosedPiper PA-23 · Clarion, PAOct 15, 1974 · N40217 · Substantial damage NTSB NYC75AN046Accident · 1 fatalClosedN.American F-51D · Chatham, PAOct 13, 1974 · N5412V · Destroyed NTSB NYC75FHA19Accident · No injuriesClosedStinson 108-1 · Berwick, PAOct 11, 1974 · N8904K · Substantial damage NTSB NYC75AN043Accident · Minor injuriesClosedPiper PA-31 · Shartlesville, PAOct 7, 1974 · N61454 · Substantial damage NTSB NYC75FHA17Accident · No injuriesClosedCessna 150 · Slatington, PAOct 6, 1974 · N6594T · Substantial damage NTSB NYC75FHA18Accident · Serious injuriesClosedCessna 180 · Hazelton, PAOct 5, 1974 · N55RC · Substantial damage NTSB NYC75AN041Accident · 1 fatalClosedBeech B23 · Collegeville, PAOct 1, 1974 · N6118N · Destroyed NTSB NYC75DGM13Accident · No injuriesClosedTaylorcraft DCO-65 · Jamestown, PASep 30, 1974 · N46111 · Substantial damage NTSB NYC75FHD23Accident · No injuriesClosedEnstrom F-28A · Ambler, PASep 29, 1974 · N48801 · Substantial damage NTSB NYC75FHD21Accident · No injuriesClosedCessna 320D · Ambler, PASep 28, 1974 · N4118T · Substantial damage NTSB NYC75DHA16Accident · No injuriesClosedCessna 170B · E Stroudsburg, PASep 27, 1974 · N2978D · Substantial damage NTSB NYC75FGM12Accident · No injuriesClosedCessna 140 · Monroeville, PASep 23, 1974 · N2770N · Substantial damage NTSB NYC75DHD13Incident · No injuriesClosedCessna 182 · N.Philadelphia, PASep 22, 1974 · N3706D · Minor damage NTSB NYC75DHD19Accident · No injuriesClosedMaule M-4 · Coatesville, PASep 21, 1974 · N4737T · Substantial damage NTSB NYC75AN039Accident · 2 fatalClosedCessna 172H · Bluebell, PASep 20, 1974 · N3258L · Destroyed NTSB IAD75AI014Accident · Serious injuriesClosedBritish AC 1-11 · Pittsburgh, PASep 20, 1974 · N1548 · No damage NTSB NYC75FGT08Accident · Minor injuriesClosedBeech A23 · Benton, PASep 15, 1974 · N6090N · Substantial damage NTSB NYC75FGM11Accident · No injuriesClosedPiper PA-22 · West Hickory, PASep 14, 1974 · N9193D · Substantial damage NTSB NYC75FHA14Accident · No injuriesClosedBeech A90 · Reading, PASep 13, 1974 · N312RF · Substantial damage NTSB NYC75DHA15Accident · No injuriesClosedPiper PA-32 · Clarks Summit, PASep 10, 1974 · N56441 · Substantial damage NTSB NYC75FGM10Accident · Minor injuriesClosedCessna 172 · Sharon, PASep 9, 1974 · N3908S · Substantial damage NTSB NYC75AN034Accident · 1 fatalClosedPiper PA-28 · Allentown, PASep 8, 1974 · N40762 · 2 aircraft · Destroyed NTSB NYC75FGM09Accident · Minor injuriesClosedCessna 150H · Ogletown, PASep 1, 1974 · N6680S · Substantial damage NTSB NYC75DHD16Accident · No injuriesClosedCessna 177 · Philadelphia, PASep 1, 1974 · N3434T · Substantial damage NTSB NYC75AN029Accident · 4 fatalClosedPiper PA-24 · Phillipsburg, PASep 1, 1974 · N8363P · Destroyed NTSB NYC75AN012Accident · 1 fatalClosedPiper PA-32 · Somerset, PASep 1, 1974 · N4190W · Destroyed