Skip to content

NTSB investigations, 1967, PA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 NYC68F0346Accident · No injuriesClosedCessna 210B · Erie, PADec 30, 1967 · N9605X · Substantial damage NTSB NYC68A0084Accident · 3 fatalClosedPiper PA-31 · Muncy, PADec 28, 1967 · N9040Y · Destroyed NTSB NYC68F0305Accident · No injuriesClosedBeech 35R · Prospectville, PADec 27, 1967 · N1220 · Substantial damage NTSB NYC68F0319Accident · No injuriesClosedPiper PA-25 · Beaver Falls, PADec 23, 1967 · N4721Y · Substantial damage NTSB NYC68D0317Accident · No injuriesClosedCessna 337 · Belle Vernon, PADec 22, 1967 · N2464S · Substantial damage NTSB NYC68F0320Accident · No injuriesClosedCessna 337 · East Berlin, PADec 18, 1967 · N5355S · Substantial damage NTSB NYC68A0080Accident · 2 fatalClosedPiper PA-28 · Stowe, PADec 17, 1967 · N8883W · Destroyed NTSB NYC68F0330Accident · 1 fatalClosedBeech T-34 · Butler, PADec 15, 1967 · N9182R · Destroyed NTSB NYC68F0321Accident · Minor injuriesClosedBeech D18S · New Cumberland, PADec 12, 1967 · N5869C · Destroyed NTSB NYC68A0076Accident · 2 fatalClosedAero Comdr 560E · Seven Springs, PADec 11, 1967 · N6231D · Destroyed NTSB NYC68A0078Accident · No injuriesClosedCessna 182 · Philadelphia, PADec 10, 1967 · N3199R · Substantial damage NTSB NYC68F0308Accident · No injuriesClosedCessna 172H · Aliquippa, PADec 9, 1967 · N8262L · Substantial damage NTSB NYC68D0318Accident · No injuriesClosedPiper PA-22 · Coudersport, PADec 2, 1967 · N8953D · Substantial damage NTSB NYC68F0329Accident · No injuriesClosedCessna 150G · Bellefonte, PADec 1, 1967 · N904PS · Substantial damage NTSB NYC68F0296Incident · Serious injuriesClosedPiper PA-28 · Hershey, PANov 26, 1967 · N5776W · No damage NTSB NYC68F0288Accident · Minor injuriesClosedCessna 182 · Kimberton, PANov 18, 1967 · N5928B · Substantial damage NTSB NYC68D0281Accident · No injuriesClosedBeech G35 · Amber, PANov 18, 1967 · N4632D · Substantial damage NTSB NYC68F0299Accident · No injuriesClosedBeech TC-45G · Middletown, PANov 15, 1967 · N7200C · Substantial damage NTSB NYC68F0278Accident · No injuriesClosedBeech D95A · Latrobe, PANov 14, 1967 · N5754K · Substantial damage NTSB NYC68F0294Accident · Serious injuriesClosedMooney M20 · Scandia, PANov 12, 1967 · N1958Y · Substantial damage NTSB NYC68F0275Accident · No injuriesClosedCessna 172B · Ambler, PANov 11, 1967 · N7764X · Substantial damage NTSB NYC68D0252Accident · No injuriesClosedPiper PA-32 · Easton, PANov 9, 1967 · N4019W · Substantial damage NTSB NYC68F0257Accident · No injuriesClosedBeech A23 · Seneca, PANov 8, 1967 · N1458L · Substantial damage NTSB NYC68D0241Accident · No injuriesClosedPiper PA-28 · Minersville, PAOct 29, 1967 · M6988W · Substantial damage NTSB NYC68A0066Accident · No injuriesClosedPiper PA-32 · Allentown, PAOct 26, 1967 · N4159W · Substantial damage NTSB NYC68F0300Accident · Serious injuriesClosedTaylorcraft BC12-D · Midway, PAOct 22, 1967 · N5049M · Substantial damage NTSB NYC68D0265Accident · No injuriesClosedCessna 172 · Callicoon, PAOct 21, 1967 · N3858L · Substantial damage NTSB NYC68A0060Accident · No injuriesClosedViscount 745D · Allentown, PAOct 18, 1967 · N7440 · Substantial damage NTSB NYC68F0238Accident · No injuriesClosedBeech G35 · Avoca, PAOct 16, 1967 · N4542D · Substantial damage NTSB NYC68A0058Accident · No injuriesClosedBrantly B-2 · Philadelphia, PAOct 16, 1967 · N2119U · Substantial damage NTSB NYC68F0255Accident · No injuriesClosedBeech 35-B33 · Philadelphia, PAOct 12, 1967 · N785AA · Substantial damage NTSB NYC68F0221Accident · No injuriesClosedBeech 95-B55 · Hershey, PAOct 7, 1967 · N922B · Substantial damage NTSB NYC68D0254Accident · No injuriesClosedNavion G · Philadelphia, PAOct 7, 1967 · N2494T · Substantial damage NTSB NYC68D0210Accident · No injuriesClosedBeech 35-C33 · Montgomryville, PAOct 7, 1967 · N5861S · Substantial damage NTSB NYC68F0222Accident · No injuriesClosedBeech H18 · Selingsgrove, PASep 30, 1967 · N84D · Substantial damage NTSB NYC68A0051Accident · No injuriesClosedBensen BMX8 · Pottstown, PASep 27, 1967 · NNONE · Substantial damage NTSB NYC68D0201Accident · No injuriesClosedCessna 150 · Loganton, PASep 24, 1967 · N2928S · Substantial damage NTSB NYC68F0211Accident · No injuriesClosedCessna 172 · Monroeville, PASep 22, 1967 · N3932L · Substantial damage NTSB NYC68F0195Accident · No injuriesClosedPiper PA-28 · Newville, PASep 21, 1967 · N8008W · Substantial damage NTSB NYC68A0049Accident · 2 fatalClosedCessna 182 · Rothsville, PASep 21, 1967 · N6362A · Destroyed NTSB NYC68F0197Accident · No injuriesClosedMooney M-22 · Lititz, PASep 19, 1967 · N7707M · Substantial damage NTSB NYC68F0279Accident · No injuriesClosedCessna 140 · Bedford, PASep 18, 1967 · N89747 · Substantial damage NTSB NYC68F0177Accident · No injuriesClosedCessna 150C · Monroeville, PASep 18, 1967 · N7895Z · Substantial damage NTSB NYC68A0044Accident · No injuriesClosedBell 47G-2 · Shippensburg, PASep 15, 1967 · N866Z · Substantial damage NTSB NYC68F0187Accident · No injuriesClosedPiper PA-28 · Cresson, PASep 14, 1967 · N6972W · Substantial damage NTSB NYC68D0184Accident · Minor injuriesClosedPiper PA-22 · West Chester, PASep 11, 1967 · N5014Z · Substantial damage NTSB NYC68D0166Accident · No injuriesClosedSchweizer SGU222 · West Chester, PASep 11, 1967 · N9918J · Substantial damage NTSB NYC68D0160Accident · No injuriesClosedPiper PA-28 · Reedsville, PASep 10, 1967 · N9794J · Substantial damage NTSB NYC68F0178Accident · No injuriesClosedPiper PA-28 · Bristol, PASep 6, 1967 · N6589W · Substantial damage NTSB NYC68F0132Accident · No injuriesClosedBeech 95-C55 · Lehighton, PASep 6, 1967 · N2710T · Substantial damage