Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 NYC73AGM14Accident · Serious injuriesClosedCessna 310N · Bedford, PADec 29, 1972 · N4101Q · Substantial damage NTSB NYC73AN087Accident · No injuriesClosedPiper PA-23 · Allentown, PADec 20, 1972 · N5811Y · Destroyed NTSB NYC73DHD73Accident · No injuriesClosedBrantly B-2 · Downingtown, PADec 19, 1972 · N4997C · Substantial damage NTSB NYC73AN088Accident · 2 fatalClosedAmer Avco AA-1A · Clermont, PADec 19, 1972 · N9409L · Substantial damage NTSB NYC73DGT06Accident · No injuriesClosedPiper PA-23 · Lititz, PADec 2, 1972 · N4040P · Substantial damage NTSB NYC73IN076Incident · No injuriesClosedBeech 99 · New Cumberland, PANov 30, 1972 · N7486N · Minor damage NTSB NYC73AN075Accident · 1 fatalClosedBeech D50 · Avoca, PANov 30, 1972 · N634H · Destroyed NTSB NYC73DHD20Accident · Minor injuriesClosedPiper PA-23 · Chester, PANov 25, 1972 · N6185Y · Substantial damage NTSB NYC73FGM13Accident · Serious injuriesClosedPiper PA-32 · Roaring Spring, PANov 22, 1972 · N8672N · Substantial damage NTSB NYC73AN072Accident · 1 fatalClosedBell 212 · Laughlintown, PANov 21, 1972 · N7064J · Substantial damage NTSB NYC73FHA11Accident · No injuriesClosedPiper PA-23 · Reading, PANov 10, 1972 · N5933Y · Substantial damage NTSB NYC73FGM12Accident · Serious injuriesClosedPiper PA-28 · Jeannette, PANov 6, 1972 · N2138R · Substantial damage NTSB NYC73AN062Accident · 1 fatalClosedChampion 7GCB · Honesdale, PANov 5, 1972 · N9881Y · Destroyed NTSB NYC73FGM11Accident · No injuriesClosedAero Comdr 500 · West Mifflin, PAOct 30, 1972 · N8494C · Substantial damage NTSB NYC73FHD17Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAOct 18, 1972 · N8662Y · Substantial damage NTSB NYC73AN052Accident · No injuriesClosedLockheed Howard · Philadelphia, PAOct 15, 1972 · N361MC · Destroyed NTSB NYC73AN050Accident · 2 fatalClosedBell 206A · Whitehaven, PAOct 7, 1972 · N6260N · Destroyed NTSB NYC73FGT04Accident · No injuriesClosedPiper PA-23 · Carlisle, PAOct 5, 1972 · N2236P · Substantial damage NTSB NYC73FGM10Accident · No injuriesClosedCessna 172H · Emlenton, PAOct 1, 1972 · N3818R · Substantial damage NTSB NYC73AN048Accident · 5 fatalClosedBeech 95-55 · Hamburg, PASep 29, 1972 · N914Q · Destroyed NTSB NYC73DHA08Accident · No injuriesClosedHughes 269A · Lenhartsville, PASep 23, 1972 · N8936F · Substantial damage NTSB NYC73DGT03Accident · No injuriesClosedCessna 172 · Ashland, PASep 18, 1972 · N3990F · Destroyed NTSB NYC73FHA06Accident · No injuriesClosedAeronca 7BCM · Perkasie, PASep 16, 1972 · N4008A · Substantial damage NTSB NYC73DHA07Accident · Minor injuriesClosedStinson 108-3 · Moscow, PASep 16, 1972 · N742C · Substantial damage NTSB NYC73FGM08Accident · No injuriesClosedCessna 172K · Jeannette, PASep 15, 1972 · N84763 · Substantial damage NTSB NYC73DGM09Accident · No injuriesClosedBeech A23 · Wattsburg, PASep 15, 1972 · N1411L · Substantial damage NTSB NYC73DHD13Accident · Minor injuriesClosedPiper PA-28 · Bristol, PASep 4, 1972 · N3696R · Destroyed NTSB NYC73FHA05Accident · No injuriesClosedCessna 140 · Montgmeryville, PASep 3, 1972 · N2192V · Substantial damage NTSB NYC73DHD12Accident · No injuriesClosedCessna 150 · Ambler, PASep 3, 1972 · N1422Q · Destroyed NTSB NYC73AN039Accident · 1 fatalClosedCessna 150G · Newtown, PAAug 31, 1972 · N3161J · Destroyed NTSB NYC73FHD14Accident · Minor injuriesClosedCessna 172 · Norristown, PAAug 28, 1972 · N7127G · Destroyed NTSB NYC73FHD11Accident · Minor injuriesClosedPiper PA-28 · Media, PAAug 20, 1972 · N3930R · Destroyed NTSB NYC73DGM06Accident · No injuriesClosedStarduster TOO · Volant, PAAug 20, 1972 · N3263 · Substantial damage NTSB NYC73FGM07Accident · No injuriesClosedCessna 182 · Ligonier, PAAug 19, 1972 · N1892X · Substantial damage NTSB NYC73FGM05Accident · Minor injuriesClosedCessna 140 · Slippery Rock, PAAug 19, 1972 · N72765 · Destroyed NTSB NYC73DGT02Accident · No injuriesClosedPiper J4 · Gettysburg, PAAug 13, 1972 · N26895 · Substantial damage NTSB NYC73FHD08Accident · No injuriesClosedNavion A · Philadelphia, PAAug 5, 1972 · N678E · Substantial damage NTSB NYC73AN046Accident · 1 fatalClosedCessna 182A · Avoca, PAJul 31, 1972 · N3792D · Destroyed NTSB NYC73FGM04Accident · Minor injuriesClosedPiper PA-18A · Butler, PAJul 30, 1972 · N9911D · Substantial damage NTSB NYC73DGM03Accident · No injuriesClosedStinson 108 · Central City, PAJul 29, 1972 · N40105 · Substantial damage NTSB NYC73FGM02Accident · No injuriesClosedGrumman G-164A · Freedom, PAJul 26, 1972 · N7480 · Substantial damage NTSB NYC73AN015Accident · 1 fatalClosedGlobe GC-1B · Coudersport, PAJul 23, 1972 · N3217K · Destroyed NTSB NYC73FHA04Accident · No injuriesClosedCessna 170 · Montrose, PAJul 17, 1972 · N2987D · Substantial damage NTSB NYC73FHA03Accident · No injuriesClosedChampion 7KCAB · Kutztown, PAJul 16, 1972 · N2753G · Substantial damage NTSB NYC73DHA02Accident · No injuriesClosedSchweizer 233A · Erwinna, PAJul 15, 1972 · N1241S · Substantial damage NTSB NYC73DGM01Accident · No injuriesClosedCessna 150L · Cuddy, PAJul 14, 1972 · N1288Q · Substantial damage NTSB NYC73FHA01Accident · No injuriesClosedChampion 7GCAA · Kutztown, PAJul 11, 1972 · N9090L · Substantial damage NTSB NYC73AN007Accident · No injuriesClosedCessna 172H · York, PAJul 6, 1972 · N3297L · Substantial damage NTSB NYC73DGT01Accident · No injuriesClosedCessna 172 · Huntingdon, PAJul 4, 1972 · N4173L · Substantial damage NTSB NYC73AN003Accident · 1 fatalClosedErco 415-C · Mcdonald, PAJul 4, 1972 · N94031 · Destroyed