Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 NYC71FGM28Accident · No injuriesClosedBell 206A · Somerset, PADec 31, 1970 · N8172J · Substantial damage NTSB NYC71AN071Accident · 2 fatalClosedPiper PA-28 · Butler, PADec 18, 1970 · N4941L · Destroyed NTSB NYC71FHA40Accident · No injuriesClosedPiper PA-28 · Perkasie, PADec 8, 1970 · N5281S · Substantial damage NTSB NYC71FHD32Accident · No injuriesClosedBell 47G-4 · Philadelphia, PADec 2, 1970 · N73943 · Substantial damage NTSB NYC71DHA27Accident · No injuriesClosedPiper PA-28 · Morrisville, PADec 2, 1970 · N6445W · Substantial damage NTSB NYC71FHA23Accident · Minor injuriesClosedPiper PA-23 · Doylestown, PANov 30, 1970 · N4542P · Substantial damage NTSB NYC71FGM22Accident · No injuriesClosedStits SA6B · Finleyville, PANov 22, 1970 · N1292V · Substantial damage NTSB NYC71AN063Accident · 3 fatalClosedCessna 310P · Grove City, PANov 20, 1970 · N5789M · Destroyed NTSB NYC71AN060Accident · Serious injuriesClosedBeech G18S · Clinton, PANov 12, 1970 · N871MP · Destroyed NTSB NYC71AN059Accident · 2 fatalClosedCessna 421 · Bath, PANov 11, 1970 · N3155K · Destroyed NTSB NYC71AN058Accident · 1 fatalClosedBeech 95-A55 · Muncy, PANov 10, 1970 · N77WW · Destroyed NTSB NYC71FHA21Accident · No injuriesClosedPiper PA-24 · Easton, PANov 9, 1970 · N6541P · Substantial damage NTSB NYC71DGM23Accident · No injuriesClosedPiper PA-24 · Germania, PANov 9, 1970 · N5954P · Substantial damage NTSB NYC71FGM21Accident · No injuriesClosedBeech M35 · Emporium, PANov 2, 1970 · N9583R · Substantial damage NTSB NYC71FGM20Accident · No injuriesClosedPiper PA-28 · Jeannette, PAOct 29, 1970 · N3649R · Substantial damage NTSB NYC71DHD29Accident · Minor injuriesClosedPiper PA-28 · Philadelphia, PAOct 27, 1970 · N95474 · Substantial damage NTSB NYC71DHA19Accident · Minor injuriesClosedPiper PA-28 · Buckingham, PAOct 25, 1970 · N9646J · Substantial damage NTSB NYC71FHG10Accident · No injuriesClosedPiper PA-18C · Annville, PAOct 24, 1970 · N4068A · Substantial damage NTSB NYC71FGM19Accident · No injuriesClosedBeech 23 · Washington, PAOct 23, 1970 · N2328L · Substantial damage NTSB NYC71FGM17Accident · Serious injuriesClosedPiper PA-28 · Washington, PAOct 18, 1970 · N8702N · Substantial damage NTSB NYC71DHD26Accident · No injuriesClosedPiper PA-28R · Ambler, PAOct 18, 1970 · N3720T · Substantial damage NTSB NYC71DGM18Accident · Minor injuriesClosedCessna 172K · Russell, PAOct 14, 1970 · N79150 · Substantial damage NTSB NYC71AN048Accident · No injuriesClosedPiper PA-23 · Erie, PAOct 12, 1970 · N4377P · Substantial damage NTSB NYC71AN044Accident · 1 fatalClosedBeech G35 · Rockton, PAOct 7, 1970 · N312NF · Destroyed NTSB NYC71AN043Accident · 2 fatalClosedAero Comdr 500-B · Mahaffey, PAOct 4, 1970 · N701X · Destroyed NTSB NYC71FHG07Accident · No injuriesClosedPiper PA-28 · Marietta, PAOct 3, 1970 · N7847N · Substantial damage NTSB NYC71FGM16Accident · Minor injuriesClosedCessna 172H · Smethport, PASep 28, 1970 · N3241L · Substantial damage NTSB NYC71FGM15Accident · No injuriesClosedBell 47G-4A · Grove City, PASep 28, 1970 · N4051G · Substantial damage NTSB NYC71DHD24Accident · Serious injuriesClosedPiper J3C-65 · Bristol, PASep 26, 1970 · N92451 · Minor damage NTSB NYC71FGM14Accident · No injuriesClosedEnstrom F-28A · Marianna, PASep 23, 1970 · N4894 · Substantial damage NTSB NYC71DHG06Accident · No injuriesClosedCessna 180 · Marietta, PASep 20, 1970 · N3222D · Substantial damage NTSB NYC71AN040Accident · 1 fatalClosedAmer Avco AA-1 · Leesport, PASep 20, 1970 · N5769L · Destroyed NTSB NYC71DHA18Accident · No injuriesClosedSchweizer SGS233 · Kutztown, PASep 17, 1970 · N7543 · Substantial damage NTSB NYC71FHA16Accident · Minor injuriesClosedMooney M20C · Collegeville, PASep 16, 1970 · N6572U · Destroyed NTSB NYC71AN036Accident · No injuriesClosedFairchild FH-227 · Philadelphia, PASep 15, 1970 · N7810M · Substantial damage NTSB NYC71FHG05Accident · No injuriesClosedPiper PA-28 · Wellsboro, PASep 12, 1970 · N6389J · Substantial damage NTSB NYC71AN033Accident · No injuriesClosedPiper PA-28R · Coraopolis, PASep 10, 1970 · N3745T · Substantial damage NTSB NYC71FHA14Accident · Serious injuriesClosedCessna 177 · Marshals Creek, PASep 8, 1970 · N3110T · Destroyed NTSB NYC71FHA15Accident · No injuriesClosedBeech 35-B33 · Forty Fort, PASep 7, 1970 · N1548Z · Substantial damage NTSB NYC71FGM13Accident · Serious injuriesClosedEmons HP-10 · Hustontown, PASep 4, 1970 · N25D · Destroyed NTSB NYC71AN032Accident · 4 fatalClosedPiper PA-28 · Minersville, PASep 4, 1970 · N8289N · Destroyed NTSB NYC71FHA13Accident · No injuriesClosedHiller Acft UH-12A · Fountainville, PAAug 30, 1970 · N10322 · Substantial damage NTSB NYC71FGM12Accident · No injuriesClosedHelio Acft H-295 · Saxonburg, PAAug 30, 1970 · N6469V · Substantial damage NTSB NYC71FHA12Accident · Minor injuriesClosedCessna 150 · Collegeville, PAAug 27, 1970 · N50919 · Substantial damage NTSB NYC71DGM11Accident · No injuriesClosedAeronca 11AC · Ebensburg, PAAug 26, 1970 · N9645E · Substantial damage NTSB NYC71FGM10Accident · No injuriesClosedCessna 177A · Bedford, PAAug 24, 1970 · N30418 · Substantial damage NTSB NYC71AN026Accident · 1 fatalClosedCessna 150 · Warren Center, PAAug 24, 1970 · N6332S · Substantial damage NTSB NYC71FGM09Accident · No injuriesClosedTaylor Titch · Finleyville, PAAug 17, 1970 · N5571 · Substantial damage NTSB NYC71FHD15Accident · Minor injuriesClosedLuscombe 8E · Phoenixville, PAAug 16, 1970 · N1663K · Substantial damage NTSB NYC71FHG04Accident · Serious injuriesClosedCessna 170 · Lockhaven, PAAug 14, 1970 · N4080V · Substantial damage