Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 NYC69D0291Accident · No injuriesClosedCessna 150 · Coraopolis, PADec 28, 1968 · N4297U · Substantial damage NTSB NYC69A0069Accident · 2 fatalClosedPiper PA-28 · Indian Head, PADec 24, 1968 · N7189W · Destroyed NTSB DCA69A0007Accident · 20 fatalClosedConvair 580 · Bradford, PADec 24, 1968 · N5802 · Destroyed NTSB NYC69A0067Accident · 3 fatalClosedPiper PA-28 · Coatesville, PADec 22, 1968 · N5368L · Destroyed NTSB NYC69F0308Accident · Serious injuriesClosedPiper PA-28 · Mckean, PADec 19, 1968 · N833F · Substantial damage NTSB NYC69F0280Accident · No injuriesClosedCessna 177 · Carbondale, PADec 19, 1968 · N29417 · Substantial damage NTSB NYC69I0064Incident · No injuriesClosedBeech B99 · Philadelphia, PADec 18, 1968 · N749A · Minor damage NTSB NYC69D0262Accident · No injuriesClosedPiper PA-22 · Warrington, PADec 8, 1968 · N4738Z · Substantial damage NTSB NYC69A0058Accident · 2 fatalClosedCessna 182 · Clarion, PADec 1, 1968 · N7100E · Destroyed NTSB NYC69D0282Accident · No injuriesClosedCessna 172 · Warren, PANov 29, 1968 · N4643L · Substantial damage NTSB NYC69F0273Accident · No injuriesClosedPiper J3L-65 · Monroeville, PANov 28, 1968 · N30362 · Substantial damage NTSB NYC69F0276Accident · Serious injuriesClosedMooney M20C · Lock Haven, PANov 26, 1968 · N6798N · Substantial damage NTSB NYC69F0279Accident · No injuriesClosedPiper PA-28 · Brookville, PANov 24, 1968 · N5107W · Substantial damage NTSB NYC69F0261Accident · Minor injuriesClosedBensen B8M · Ivyland, PANov 24, 1968 · N4791G · Destroyed NTSB NYC69D0246Accident · No injuriesClosedCessna 172 · Wycote Village, PANov 23, 1968 · N2627L · Substantial damage NTSB NYC69F0259Accident · No injuriesClosedPiper PA-22 · Bessemer, PANov 21, 1968 · N8294C · Substantial damage NTSB NYC69A0055Accident · No injuriesClosedPiper PA-28 · Hazelton, PANov 13, 1968 · N981MA · Substantial damage NTSB NYC69A0053Accident · 4 fatalClosedPiper PA-23 · Churchville, PANov 7, 1968 · N4946P · Destroyed NTSB NYC69A0052Accident · 1 fatalClosedCessna 402 · Allentown, PANov 7, 1968 · N8419F · Destroyed NTSB NYC69D0239Accident · No injuriesClosedCessna 150 · Stroudsburg, PAOct 27, 1968 · N6790S · Substantial damage NTSB NYC69D0224Accident · No injuriesClosedPiper PA-20 · Warrington, PAOct 26, 1968 · N7333K · Substantial damage NTSB NYC69A0047Accident · 2 fatalClosedPiper PA-24 · Fleming, PAOct 26, 1968 · N5025P · Destroyed NTSB NYC69F0220Accident · Serious injuriesClosedBell 47G-2 · Harrisburg, PAOct 20, 1968 · N6719D · Destroyed NTSB NYC69A0046Accident · No injuriesClosedBeech B-99 · Hazelton, PAOct 13, 1968 · N336PL · Substantial damage NTSB NYC69D0218Accident · No injuriesClosedHelicom SAH100 · Finleyville, PAOct 11, 1968 · N828Z · Substantial damage NTSB NYC69A0045Accident · 2 fatalClosedPiper PA-23 · Derry, PAOct 10, 1968 · N5140Y · Destroyed NTSB NYC69D0187Accident · No injuriesClosedStinson 108-2 · Hallstead, PASep 28, 1968 · N9372K · Substantial damage NTSB NYC69D0241Accident · No injuriesClosedCessna 150 · Matamoras, PASep 24, 1968 · N23272 · Substantial damage NTSB NYC69F0179Accident · 2 fatalClosedPiccard AX6-PT · Penndel, PASep 19, 1968 · N3191 · Substantial damage NTSB NYC69D0240Accident · No injuriesClosedAero Comdr 100 · Lehighton, PASep 19, 1968 · N4145X · Substantial damage NTSB NYC69A0036Accident · Serious injuriesClosedBeech TC-45G · Franklin, PASep 18, 1968 · N7200C · Destroyed NTSB NYC69A0034Accident · Serious injuriesClosedPiper PA-28 · Easton, PASep 16, 1968 · N3742T · Destroyed NTSB NYC69F0173Accident · Minor injuriesClosedErco 415-C · Jersey Shore, PASep 15, 1968 · N99157 · Substantial damage NTSB NYC69F0169Accident · No injuriesClosedCessna 177 · Kutztown, PASep 8, 1968 · N3238T · Substantial damage NTSB NYC69D0155Accident · Minor injuriesClosedSchweizer SGU222 · Hershey, PASep 8, 1968 · N3841A · Substantial damage NTSB NYC69F0212Accident · Serious injuriesClosedCessna 150H · Monroeville, PASep 7, 1968 · N6985S · Substantial damage NTSB NYC69D0183Accident · No injuriesClosedStinson 108-3 · Dublin, PASep 7, 1968 · N6866M · Substantial damage NTSB NYC69A0028Accident · No injuriesClosedN.American NA-265 · Avoca, PASep 6, 1968 · N2009 · Substantial damage NTSB NYC69A0026Accident · 3 fatalClosedPiper PA-24 · Dallas, PASep 2, 1968 · N5578P · Destroyed NTSB NYC69D0171Accident · No injuriesClosedCessna 180 · Beaver Falls, PASep 1, 1968 · N2493C · Substantial damage NTSB NYC69D0161Accident · Minor injuriesClosedPiper PA-28 · Honesdale, PASep 1, 1968 · N5240L · Substantial damage NTSB NYC69F0207Accident · No injuriesClosedBeech K35 · Central City, PAAug 31, 1968 · N639Q · Substantial damage NTSB NYC69F0185Accident · Minor injuriesClosedPiper PA-28 · Rew, PAAug 31, 1968 · N4748L · Substantial damage NTSB NYC69F0170Accident · Minor injuriesClosedFournier RF4D · Sharon, PAAug 31, 1968 · N2189 · Substantial damage NTSB NYC69F0206Accident · Minor injuriesClosedChampion 7JC · Meadville, PAAug 30, 1968 · N8954R · Substantial damage NTSB NYC69D0145Accident · No injuriesClosedCessna 172 · Manchester, PAAug 30, 1968 · N7500T · Substantial damage NTSB NYC69A0022Accident · 1 fatalClosedCessna 206 · Snowshoe, PAAug 21, 1968 · N2680X · Destroyed NTSB NYC69D0236Accident · No injuriesClosedPiper PA-28 · Bridgeville, PAAug 20, 1968 · N7115R · Substantial damage NTSB NYC69F0133Accident · 1 fatalClosedConvair BT-15 · Summit Station, PAAug 19, 1968 · N355H · Destroyed NTSB NYC69F0123Accident · No injuriesClosedPiper PA-28 · Pottstown, PAAug 15, 1968 · N3724K · Substantial damage