Skip to content

NTSB investigations, PA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC80FGM32Accident · No injuriesClosedSchleicher ASW-19 · Tyronne, PASep 10, 1980 · N437AS · Substantial damage NTSB NYC80FGM31Accident · No injuriesClosedPiper PA-28R · Monroeville, PASep 10, 1980 · N4822T · Substantial damage NTSB NYC80FGT21Accident · 1 fatalClosedBensen B-8M · Columbia, PASep 8, 1980 · N3776N · Destroyed NTSB NYC80DHA31Accident · No injuriesClosedCessna A185E · Pottstown, PASep 7, 1980 · N1922U · Substantial damage NTSB NYC80FGM28Accident · Minor injuriesClosedFunk B75L · Slippery Rock, PASep 1, 1980 · N22683 · Substantial damage NTSB NYC80;GM29Accident · No injuriesClosedBLN Works FF-7 · Indiana, PAAug 31, 1980 · N2127H · Substantial damage NTSB NYC80FGT20Accident · Serious injuriesClosedSchreder HP-11A · Julian, PAAug 29, 1980 · N4742G · Substantial damage NTSB NYC80FHA30Accident · Serious injuriesClosedBoeing B75N1 · Erwinna, PAAug 26, 1980 · N65565 · Substantial damage NTSB NYC80FGT19Accident · No injuriesClosedHughes 269C · Renova, PAAug 20, 1980 · N9572E · Destroyed NTSB NYC80FGM27Accident · Minor injuriesClosedPiper PA-31 · Windber, PAAug 20, 1980 · N4FT · Substantial damage NTSB NYC80FHA28Accident · Minor injuriesClosedCessna 172 · Perkasia, PAAug 18, 1980 · N2409L · Substantial damage NTSB NYC80FHD24Accident · Serious injuriesClosedCessna 177B · Ambler, PAAug 16, 1980 · N34280 · Destroyed NTSB NYC80FGM26Accident · No injuriesClosedCessna 152 · Connellsville, PAAug 9, 1980 · N46483 · Substantial damage NTSB NYC80FHA26Accident · No injuriesClosedCessna 150L · Collegeville, PAAug 6, 1980 · N10079 · Destroyed NTSB NYC80DA062Accident · No injuriesClosedCessna 172 · Mifflintown, PAJul 27, 1980 · N5757E · Substantial damage NTSB DCA80AA022Accident · 3 fatalClosedPiper PA-31 · Philadelphia, PAJul 25, 1980 · N5MS · Destroyed NTSB NYC80IA057Incident · No injuriesClosedBritish AC 1-11 · Pittsburgh, PAJul 14, 1980 · N549 · No damage NTSB NYC80FGT16Accident · No injuriesClosedBell 47G · Gettysburg, PAJul 12, 1980 · N2795A · Substantial damage NTSB NYC80DHA24Accident · Minor injuriesClosedSchleicher ASW-19 · Franklin Forks, PAJul 10, 1980 · N78RC · Substantial damage NTSB NYC80FGM25Accident · No injuriesClosedCessna 210 · Waynesburg, PAJul 7, 1980 · N6673X · Substantial damage NTSB NYC80FA051Accident · 3 fatalClosedPiper PA-28 · Clearfield, PAJul 3, 1980 · N8903J · Destroyed NTSB NYC80FGT15Accident · No injuriesClosedMooney M20C · Mt Union, PAJul 2, 1980 · N7173V · Substantial damage NTSB NYC80FHA20Accident · No injuriesClosedPiper PA-22 · Hallstead, PAJun 24, 1980 · N8610D · Substantial damage NTSB NYC80FHA19Accident · Serious injuriesClosedMitchell U-2 · Doylestown, PAJun 24, 1980 · N83CM · Substantial damage NTSB NYC80FHA18Accident · 2 fatalClosedThorp T-18 · Quakertown, PAJun 22, 1980 · N59374 · Destroyed NTSB NYC80FGT14Accident · No injuriesClosedDehavilland DHC-2 · Chambersburg, PAJun 22, 1980 · N5330G · Substantial damage NTSB NYC80DHA17Accident · No injuriesClosedPiper PA-28 · Clifford, PAJun 20, 1980 · N98134 · Substantial damage NTSB NYC80FA046Accident · 1 fatalClosedLuscombe 8A · Fairview, PAJun 16, 1980 · N71667 · Destroyed NTSB NYC80FHA16Accident · Serious injuriesClosedRaven S55 · Upr Mkfld Twp, PAJun 14, 1980 · N57069 · No damage NTSB NYC80FGM24Accident · No injuriesClosedCessna 150 · New Castle, PAJun 14, 1980 · N22856 · Substantial damage NTSB NYC80FHA21Accident · Minor injuriesClosedShort Bros SD3-30 · Allentown, PAJun 3, 1980 · N844SA · Substantial damage NTSB NYC80DHD16Accident · No injuriesClosedGrum-Amer AA-5B · Bristol, PAJun 2, 1980 · N4516V · Substantial damage NTSB NYC80FGM21Accident · No injuriesClosedHughes 269C · Scottdale, PAMay 29, 1980 · N7426F · Substantial damage NTSB NYC80FGM22Accident · No injuriesClosedCessna 182 · Wattersonville, PAMay 27, 1980 · N3047Q · Substantial damage NTSB NYC80FGT13Accident · No injuriesClosedJohnson HP-11A · Fairfield, PAMay 26, 1980 · N417J · Substantial damage NTSB NYC80FGM23Accident · No injuriesClosedPiper PA-28 · Cooperstown, PAMay 23, 1980 · N2224F · Substantial damage NTSB NYC80FGM20Accident · Minor injuriesClosedMooney M20C · Claysville, PAMay 23, 1980 · N3608H · Substantial damage NTSB NYC80FHD12Accident · No injuriesClosedGrum-Amer AA-5A · Bristol, PAMay 22, 1980 · N9904U · Substantial damage NTSB NYC80FGM19Accident · No injuriesClosedCessna 150 · Everett, PAMay 19, 1980 · N18067 · Substantial damage NTSB NYC80FGT12Accident · No injuriesClosedBell 47G · Gettysburg, PAMay 7, 1980 · N9738Z · Substantial damage NTSB NYC80FHA13Accident · Minor injuriesClosedCessna 172 · Allentown, PAMay 5, 1980 · N1124F · Substantial damage NTSB NYC80FHA09Accident · Minor injuriesClosedCessna 140 · Slatington, PAMay 4, 1980 · N72581 · Substantial damage NTSB NYC80FHA10Accident · Minor injuriesClosedPiper PA-28R · Westrockhill, PAMay 3, 1980 · N5110S · Substantial damage NTSB NYC80FGT11Accident · No injuriesClosedLockheed PV-2 · Philipsburg, PAMay 2, 1980 · N7086C · Substantial damage NTSB NYC80FGM18Accident · No injuriesClosedBeech A35 · Zelienople, PAMay 1, 1980 · N8519A · Substantial damage NTSB NYC80FGT09Accident · No injuriesClosedPiper PA-28 · Myerstown, PAApr 21, 1980 · N8523C · Substantial damage NTSB NYC80FGT10Accident · No injuriesClosedSchweizer SGS233 · Jersey Shore, PAApr 20, 1980 · N2440W · Substantial damage NTSB NYC80FGM16Accident · 2 fatalClosedGlen-Co RAG-1 · Connoqunsg, PAApr 20, 1980 · N4963E · Destroyed NTSB NYC80FGM17Accident · No injuriesClosedPiper PA-23 · New Castle, PAApr 18, 1980 · N971FT · Substantial damage NTSB NYC80FGM15Accident · No injuriesClosedCessna 182 · Belle Vernon, PAApr 16, 1980 · N97243 · Substantial damage