Skip to content

NTSB investigations, PA

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, newest first

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 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 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 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 NYC72FGM05Accident · No injuriesClosedAeronca 7CCM · Irwin, PAJul 25, 1971 · N4635E · Substantial damage NTSB NYC72DGM06Accident · No injuriesClosedCessna 172I · Franklin, PAJul 23, 1971 · N8424L · Substantial damage NTSB NYC72FGM04Accident · No injuriesClosedMooney M20F · Monroeville, PAJul 21, 1971 · N2988L · Substantial damage NTSB NYC72DHA05Accident · No injuriesClosedPiper PA-28 · E.Stroudsburg, PAJul 14, 1971 · N7856N · Substantial damage NTSB NYC72FGM03Accident · No injuriesClosedBrantly B2B · Williamsburg, PAJul 10, 1971 · N2180U · Substantial damage NTSB NYC72AN005Accident · 2 fatalClosedMooney M20F · Plum Borough, PAJul 8, 1971 · N9651M · Substantial damage NTSB NYC72FGM02Accident · Minor injuriesClosedCessna 120 · Cambridge Spgs, PAJul 7, 1971 · N76105 · Substantial damage NTSB NYC72AN004Accident · 3 fatalClosedPiper PA-28 · Hershey, PAJul 7, 1971 · N5920U · Destroyed NTSB NYC72FHA02Accident · Minor injuriesClosedCessna 140 · Line Lexington, PAJul 5, 1971 · N1903V · Substantial damage NTSB NYC72FHA01Accident · Minor injuriesClosedHiller UH12B · Lansdale, PAJul 4, 1971 · N5303V · Substantial damage NTSB NYC72FHA03Accident · No injuriesClosedBell 47G · Long Pond, PAJul 3, 1971 · N973B · Substantial damage NTSB NYC72FGM01Accident · No injuriesClosedMooney M20F · Warren, PAJul 2, 1971 · N6805V · Substantial damage NTSB NYC71FHA54Accident · Serious injuriesClosedCessna 337 · Avoca, PAJun 27, 1971 · N6313F · Substantial damage NTSB NYC71FGT18Accident · Serious injuriesClosedCessna 177A · Newville, PAJun 23, 1971 · N836DB · Substantial damage NTSB NYC72DGM12Accident · No injuriesClosedBeech 35 · Eighty-Four, PAJun 20, 1971 · N545V · Substantial damage NTSB NYC71FGM53Accident · No injuriesClosedMooney M20F · West Mifflin, PAJun 20, 1971 · N3856N · Substantial damage NTSB NYC71AN122Accident · 2 fatalClosedPiper PA-28 · Uniontown, PAJun 17, 1971 · N9228J · Destroyed NTSB NYC71FHA55Accident · No injuriesClosedHawker S Fury · Reading, PAJun 14, 1971 · CF-CHB · Substantial damage NTSB NYC71FGM52Accident · Minor injuriesClosedCessna 150J · Beaver Falls, PAJun 12, 1971 · N50840 · Substantial damage NTSB OAK71IP052Incident · Minor injuriesClosedBoeing 707 · Phillipsburg, PAJun 11, 1971 · N6729TW · No damage NTSB NYC71FHA52Accident · Minor injuriesClosedCessna 172 · Fleetville, PAJun 8, 1971 · N7392G · Substantial damage NTSB NYC71FGM51Accident · Serious injuriesClosedPiper PA-28R · Bedford, PAJun 4, 1971 · N4925J · Substantial damage NTSB NYC71AN116Accident · No injuriesClosedHam-Flugzeu HFB320 · Coraopolis, PAJun 4, 1971 · N380EX · Substantial damage NTSB NYC71FGM50Accident · Serious injuriesClosedCessna 150F · Valencia, PAMay 31, 1971 · N7142F · Substantial damage NTSB NYC71DGM48Accident · No injuriesClosedAero Comdr 100 · Connellsville, PAMay 30, 1971 · N4102X · Substantial damage NTSB NYC71FHA53Accident · Serious injuriesClosedCessna 180 · Tamiment, PAMay 29, 1971 · N4520B · Destroyed NTSB NYC71DHA50Accident · No injuriesClosedWolf Hirth L0-150 · Matamoras, PAMay 29, 1971 · N3500G · Substantial damage NTSB NYC71DGM49Accident · No injuriesClosedCessna 140 · Clarion, PAMay 29, 1971 · N2003N · Substantial damage NTSB IAD71AI054Accident · 4 fatalClosedCessna 310C · Dunlo, PAMay 27, 1971 · N1765H · Destroyed NTSB NYC71AN114Accident · 1 fatalClosedPiper PA-28 · Reading, PAMay 26, 1971 · N1697T · Substantial damage NTSB NYC71FGM47Accident · No injuriesClosedStinson 108-3 · Delmont, PAMay 20, 1971 · N6214M · Substantial damage NTSB NYC71FHA48Accident · No injuriesClosedCessna 150 · Allentown, PAMay 19, 1971 · N17084 · Substantial damage NTSB NYC71DHD56Accident · No injuriesClosedCessna 172 · Philadelphia, PAMay 19, 1971 · N2878L · Substantial damage NTSB NYC71FGM46Accident · Minor injuriesClosedCessna 150F · Monroeville, PAMay 16, 1971 · N8562G · Substantial damage NTSB NYC71FHA47Accident · No injuriesClosedChampion 7FC · Kutztown, PAMay 15, 1971 · N7570B · Substantial damage NTSB NYC71FHA46Accident · Minor injuriesClosedErco 415-C · Warrington, PAMay 15, 1971 · N94324 · Substantial damage NTSB NYC71FHD61Accident · No injuriesClosedCessna 310N · Philadelphia, PAMay 14, 1971 · N4145Q · Substantial damage NTSB NYC71FHD53Accident · No injuriesClosedAmer Avco AA1 · Bristol, PAMay 14, 1971 · N5742L · Substantial damage NTSB NYC71AN111Accident · 2 fatalClosedCessna 172A · Bethel, PAMay 12, 1971 · CC-PBS · Destroyed NTSB NYC71AN109Accident · 3 fatalClosedCessna 180 · Tarentum, PAMay 9, 1971 · N180AM · Destroyed NTSB NYC71FGT17Accident · Minor injuriesClosedPiper PA-22 · Bloomsburg, PAMay 7, 1971 · N3241Z · Substantial damage NTSB NYC71AN107Accident · 3 fatalClosedBeech E35 · Indiana, PAMay 3, 1971 · N7366B · Destroyed NTSB NYC71FGM44Accident · Minor injuriesClosedPiper PA-28 · Edinboro, PAMay 2, 1971 · N1836T · Destroyed NTSB NYC71FGM45Accident · No injuriesClosedCessna 172 · Beaver Falls, PAMay 1, 1971 · N35723 · Substantial damage NTSB NYC71FGM43Accident · No injuriesClosedPiper PA-28 · New Castle, PAApr 28, 1971 · N9850W · Substantial damage NTSB NYC71FGT19Accident · No injuriesClosedMaule M-4 · Fairfield, PAApr 24, 1971 · N12024 · Destroyed NTSB NYC71FGM42Accident · Minor injuriesClosedBell 47G4A · Franklin, PAApr 23, 1971 · N1413W · Destroyed NTSB NYC71AN105Accident · No injuriesClosedPiper PA-23 · Coraopolis, PAApr 21, 1971 · N8017J · Substantial damage NTSB NYC71FGM40Accident · No injuriesClosedAero Comdr 100 · Connellsville, PAApr 19, 1971 · N5500M · Substantial damage NTSB NYC71FGT15Accident · No injuriesClosedBoeing A75N1 · Philipsburg, PAApr 18, 1971 · N93X · Substantial damage