Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 NYC70D0238Accident · No injuriesClosedCessna 150H · Zelienople, PADec 28, 1969 · N23183 · Substantial damage NTSB NYC70D0224Accident · Minor injuriesClosedCessna 180 · Greeley, PADec 21, 1969 · N9322C · Substantial damage NTSB NYC70F0004Accident · No injuriesClosedBell 47G-4A · Allentown, PADec 19, 1969 · N1391X · Substantial damage NTSB NYC70D0230Accident · No injuriesClosedCessna 150F · Wellsboro, PADec 13, 1969 · N7933F · Substantial damage NTSB NYC70A0063Accident · Serious injuriesClosedBoeing 727 · Pittsburgh, PADec 13, 1969 · N8158G · No damage NTSB NYC70F0237Accident · No injuriesClosedCessna 150G · Johnstown, PADec 9, 1969 · N2831S · Substantial damage NTSB NYC70D0001Accident · No injuriesClosedCessna 150 · Kng Of Prussia, PANov 30, 1969 · N7960F · Substantial damage NTSB NYC70F0211Accident · No injuriesClosedCessna 150F · Irwin, PANov 7, 1969 · N8048S · Substantial damage NTSB NYC70I0050Incident · No injuriesClosedSud Aviatio NSE 21 · Philadelphia, PANov 6, 1969 · N1015U · 2 aircraft · Minor damage NTSB NYC70FIK01Accident · Serious injuriesClosedPiper PA-28 · Berlin, PANov 6, 1969 · N6793W · Destroyed NTSB NYC70I0049Incident · Minor injuriesClosedBoeing 737 · Tannersville, PANov 5, 1969 · N9008U · No damage NTSB NYC70F0183Accident · No injuriesClosedCessna 150 · Collegeville, PAOct 26, 1969 · N60443 · Substantial damage NTSB NYC70I0045Incident · No injuriesClosedBeech E18S · Philadelphia, PAOct 20, 1969 · N340V · Minor damage NTSB NYC70A0044Accident · 2 fatalClosedCessna 120 · Seneca, PAOct 18, 1969 · N72392 · Destroyed NTSB NYC70D0198Accident · No injuriesClosedPiper PA-22 · Erie, PAOct 13, 1969 · N5841Z · Substantial damage NTSB NYC70F0199Accident · Minor injuriesClosedCessna A150K · Jeannette, PAOct 12, 1969 · N8347M · Substantial damage NTSB NYC70F0177Accident · No injuriesClosedMidget II 1-A · Langhorne, PAOct 12, 1969 · N7191 · Substantial damage NTSB NYC70F0193Accident · No injuriesClosedOldfield BGL · Export, PAOct 11, 1969 · N181H · Substantial damage NTSB NYC70F0190Accident · No injuriesClosedCessna 172I · Belle Vernon, PAOct 10, 1969 · N8471L · Substantial damage NTSB NYC70D0179Accident · Minor injuriesClosedBeech D18S · Karthaus, PAOct 2, 1969 · N4193 · Substantial damage NTSB NYC70F0155Accident · Serious injuriesClosedCessna 185 · West Chester, PASep 29, 1969 · N9952X · Substantial damage NTSB NYC70F0151Accident · No injuriesClosedStinson 108-1 · Perkasie, PASep 29, 1969 · N8915K · Substantial damage NTSB NYC70D0187Accident · No injuriesClosedBeech A90 · Bradford, PASep 29, 1969 · N769K · Substantial damage NTSB NYC70A0037Accident · 2 fatalClosedChampion 7KCAB · Elizabethtown, PASep 29, 1969 · N1841G · Destroyed NTSB NYC70D0212Accident · Minor injuriesClosedPiper PA-28 · Coudersport, PASep 26, 1969 · N4542R · Substantial damage NTSB NYC70F0156Accident · No injuriesClosedCessna 310L · Reading, PASep 24, 1969 · N3319X · Substantial damage NTSB NYC70A0034Accident · Serious injuriesClosedBoeing 727 · Philadelphia, PASep 15, 1969 · N12303 · No damage NTSB NYC70F0132Accident · No injuriesClosedCessna 140 · Hellertown, PASep 14, 1969 · N2196N · Substantial damage NTSB NYC70F0163Accident · Minor injuriesClosedStinson V-77 · Waynesburg, PASep 12, 1969 · N9393H · Substantial damage NTSB NYC70F0138Accident · Serious injuriesClosedBlom Turbnt · Dover, PASep 6, 1969 · N12051 · Substantial damage NTSB NYC70A0031Accident · 4 fatalClosedPiper PA-30 · Port Royal, PASep 4, 1969 · N7005Y · Destroyed NTSB NYC70F0145Accident · Minor injuriesClosedGrumman G-44A · Wrightsville, PAAug 30, 1969 · N1595V · Substantial damage NTSB NYC70A0028Accident · 3 fatalClosedPiper PA-30 · Bradford, PAAug 30, 1969 · N8391Y · Destroyed NTSB NYC70F0147Accident · No injuriesClosedBeech 95-B55 · Forest City, PAAug 29, 1969 · N97Q · Substantial damage NTSB NYC70F0097Accident · No injuriesClosedCessna 172B · Schwenksville, PAAug 28, 1969 · N7764X · Substantial damage NTSB NYC70D0120Accident · No injuriesClosedPiper PA-32 · Berwick, PAAug 28, 1969 · N3753W · Substantial damage NTSB NYC70D0099Accident · No injuriesClosedCessna 150 · Allentown, PAAug 26, 1969 · N7124F · Substantial damage NTSB NYC70A0027Accident · 1 fatalClosedPiper PA-22 · Langhorne, PAAug 24, 1969 · N3339Z · Destroyed NTSB NYC70A0026Accident · 1 fatalClosedPiper J-5A · Kittanning, PAAug 23, 1969 · N38649 · Destroyed NTSB NYC70FIK04Accident · Serious injuriesClosedCessna 310N · Coraopolis, PAAug 20, 1969 · N4195Q · Substantial damage NTSB NYC70D0133Accident · No injuriesClosedCessna 150 · Ambler, PAAug 16, 1969 · N60743 · Substantial damage NTSB NYC70F0125Accident · No injuriesClosedCessna 177 · West Mifflin, PAAug 15, 1969 · N30173 · Substantial damage NTSB NYC70D0124Accident · No injuriesClosedBeech 35-C33 · Philadelphia, PAAug 15, 1969 · N474K · Substantial damage NTSB NYC70F0103Accident · Serious injuriesClosedTaylorcraft BC12-D · Elmhurst, PAAug 13, 1969 · N95573 · Substantial damage NTSB NYC70D0114Accident · No injuriesClosedPiper PA-22 · Oxford, PAAug 9, 1969 · N5459Z · Substantial damage NTSB NYC70F0188Accident · No injuriesClosedStinson 10A · Washington, PAAug 3, 1969 · N31561 · Substantial damage NTSB NYC70D0141Accident · No injuriesClosedPiper PA-28 · Clarion, PAAug 2, 1969 · N8013N · Substantial damage NTSB NYC70D0122Accident · Serious injuriesClosedPiper PA-16 · Mountain Home, PAAug 1, 1969 · N5682H · Substantial damage NTSB NYC70I0013Incident · No injuriesClosedLear Jet 25 · Williamsport, PAJul 27, 1969 · N167J · Minor damage NTSB NYC70A0014Accident · 3 fatalClosedBeech D18S · Jersey Shore, PAJul 27, 1969 · N319 · Destroyed