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 NYC76FGT01Accident · Minor injuriesClosedBeech A24R · Hughesville, PAJul 4, 1975 · N9754L · Destroyed NTSB NYC76FHA03Accident · Minor injuriesClosedTed Smith 601P · Collegeville, PAJul 2, 1975 · N3AD · Substantial damage NTSB NYC76DMA02Accident · Serious injuriesClosedMooney M20C · Sterling, PAJun 30, 1975 · N7104V · Substantial damage NTSB NYC75FGT22Accident · No injuriesClosedSidewinder Smyth · Annville, PAJun 30, 1975 · N77PG · Substantial damage NTSB NYC75FGT21Accident · Serious injuriesClosedPiper PA-28 · New Cumberland, PAJun 29, 1975 · N41991 · Destroyed NTSB NYC75FGM51Accident · No injuriesClosedWaco ASO · Belle Vernon, PAJun 29, 1975 · N268M · Substantial damage NTSB NYC76FGM49Accident · No injuriesClosedPiper PA-28 · Somerset, PAJun 22, 1975 · N6972W · Substantial damage NTSB NYC75FGM50Accident · No injuriesClosedCessna 182 · Belle Vernon, PAJun 22, 1975 · N42758 · Substantial damage NTSB NYC75FGM48Accident · No injuriesClosedPiper PA-28 · Ebensburg, PAJun 21, 1975 · N44597 · Substantial damage NTSB NYC75FGM47Accident · Minor injuriesClosedLuscombe 8A · Leechburg, PAJun 21, 1975 · N1544K · Substantial damage NTSB NYC75FGM46Accident · No injuriesClosedCessna 150L · Darlington, PAJun 20, 1975 · N11275 · Substantial damage NTSB NYC75FGT20Accident · Minor injuriesClosedMaule M5-210 · Lock Haven, PAJun 19, 1975 · N285X · Substantial damage NTSB NYC75DHD34Accident · No injuriesClosedCessna 150 · Coatesville, PAJun 18, 1975 · N6040G · Substantial damage NTSB NYC75FGM44Accident · Minor injuriesClosedAeronca 7DC · Ducansville, PAJun 17, 1975 · N2095A · Substantial damage NTSB NYC75AN118Accident · Serious injuriesClosedPiper PA-28 · Export, PAJun 17, 1975 · N922RD · Substantial damage NTSB NYC75FGM43Accident · No injuriesClosedBeech H35 · West Mifflin, PAJun 15, 1975 · N7914D · Substantial damage NTSB NYC75AN120Accident · No injuriesClosedTed Smith 600 · Philadelphia, PAJun 13, 1975 · N7408S · Substantial damage NTSB NYC75FGT19Accident · No injuriesClosedCessna 182 · New Holland, PAJun 10, 1975 · N2031X · Substantial damage NTSB NYC75AN117Accident · 2 fatalClosedAeronca 7AC · Macungie, PAJun 10, 1975 · N2630E · 2 aircraft · Substantial damage NTSB NYC75FGM42Accident · No injuriesClosedPiper PA-28 · Latrobe, PAJun 9, 1975 · N43495 · Destroyed NTSB NYC75DGM41Accident · No injuriesClosedScheibe 55 · Holidaysburg, PAJun 8, 1975 · N8364 · Substantial damage NTSB NYC75DGM40Accident · Minor injuriesClosedCessna 172K · Bedford, PAJun 6, 1975 · N79196 · Substantial damage NTSB NYC75FGM39Accident · Minor injuriesClosedPiper PA-28 · Marienville, PAMay 25, 1975 · N55974 · Destroyed NTSB NYC75DHA41Accident · Serious injuriesClosedSchweizer 2-32 · Mount Pocono, PAMay 24, 1975 · N65973 · Substantial damage NTSB NYC75DGM38Accident · No injuriesClosedCessna 182 · Bedford, PAMay 24, 1975 · N5819B · Substantial damage NTSB NYC75FHA42Accident · No injuriesClosedCamair 480 · Honesdale, PAMay 23, 1975 · N221 · Substantial damage NTSB NYC75AN108Accident · Serious injuriesClosedBell 47J-2A · Philadelphia, PAMay 20, 1975 · N1140W · Substantial damage NTSB NYC75DHD45Accident · No injuriesClosedCessna 150 · New London, PAMay 18, 1975 · N11483 · Substantial damage NTSB NYC75FGM37Accident · Serious injuriesClosedEnstrom F-28A · Mt Lebanon, PAMay 16, 1975 · N251Q · Substantial damage NTSB NYC75FHA40Accident · Minor injuriesClosedCessna 172K · E Stroudsburg, PAMay 14, 1975 · N7293G · Substantial damage NTSB NYC75AN107Accident · 1 fatalClosedPiper PA-28 · Berlin, PAMay 13, 1975 · N629FL · Destroyed NTSB NYC75DHD44Accident · No injuriesClosedEnstrom F-28A · East Goshen, PAMay 11, 1975 · N1903F · Substantial damage NTSB NYC75FGM36Accident · Serious injuriesClosedSchweizer SGU222 · Butler, PAMay 10, 1975 · N2749Z · Substantial damage NTSB NYC75DGM35Accident · No injuriesClosedStinson 108 · Clarion, PAApr 30, 1975 · N40105 · Destroyed NTSB NYC75AN103Accident · 3 fatalClosedBeech M35 · Phillipsburg, PAApr 29, 1975 · N9857R · Substantial damage NTSB NYC75DGM34Accident · No injuriesClosedChampion 7FC · Wattsburg, PAApr 27, 1975 · N9860Y · Substantial damage NTSB NYC75AN102Accident · Serious injuriesClosedLockheed 1011 · Philadelphia, PAApr 26, 1975 · N315EA · No damage NTSB NYC75FHD42Accident · Minor injuriesClosedCessna 150L · Toughkenamon, PAApr 23, 1975 · N5387Q · Destroyed NTSB NYC75DGM33Accident · No injuriesClosedCessna 172K · Beaver Falls, PAApr 23, 1975 · N7301G · Substantial damage NTSB NYC75DHA43Accident · No injuriesClosedCessna 177 · Montgomeryvile, PAApr 19, 1975 · N2846X · Substantial damage NTSB NYC75FHD41Accident · No injuriesClosedCessna 150M · New London, PAApr 13, 1975 · N3156V · Substantial damage NTSB NYC75DHA36Accident · No injuriesClosedCessna 170B · Hazleton, PAApr 12, 1975 · N3124A · Substantial damage NTSB NYC75FGM31Accident · Minor injuriesClosedPiper PA-28R · Butler, PAApr 2, 1975 · N56130 · 2 aircraft · Substantial damage NTSB NYC75FGM30Accident · No injuriesClosedNavion A · Huntingdon Twp, PAApr 2, 1975 · N4539K · Substantial damage NTSB NYC75DGT15Accident · No injuriesClosedCessna 182 · Belleville, PAApr 2, 1975 · N1144F · Substantial damage NTSB NYC75FGM32Accident · No injuriesClosedHiller Acft UH-12B · Beaver Falls, PAApr 1, 1975 · N90424 · Substantial damage NTSB NYC75FGM29Accident · Serious injuriesClosedMooney M20A · Monroeville, PAMar 30, 1975 · N6011X · Substantial damage NTSB NYC75FGM28Accident · No injuriesClosedSiai-Marche S205 · Drifting, PAMar 27, 1975 · N985WA · Substantial damage NTSB NYC75DGT17Accident · No injuriesClosedCessna 177 · New Holland, PAMar 27, 1975 · N29363 · Substantial damage NTSB DCA75AZ009Accident · Serious injuriesClosedDouglas DC-3C · Dubois, PAMar 27, 1975 · N6 · Destroyed