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 NYC76FGM49Accident · No injuriesClosedBeech G18S · Beaver Falls, PASep 16, 1976 · N340K · Substantial damage NTSB NYC76FHA55Accident · No injuriesClosedBrantly 305 · Telford, PASep 15, 1976 · N2201U · Substantial damage NTSB NYC76FHA54Accident · No injuriesClosedBellanca 17-30 · Allentown, PASep 14, 1976 · N1291R · Substantial damage NTSB NYC76IN125Incident · Minor injuriesClosedDehavilland DHC-6 · Franklin, PASep 13, 1976 · N915SA · No damage NTSB NYC76DHA53Accident · No injuriesClosedLuscombe 8A · Sterling, PASep 12, 1976 · N45960 · Substantial damage NTSB NYC76FHA51Accident · No injuriesClosedErco 415-CD · Jamison, PASep 6, 1976 · N3822H · Substantial damage NTSB NYC76DHD44Accident · No injuriesClosedCessna 150J · Blue Bell, PASep 6, 1976 · N60753 · Destroyed NTSB NYC76DHA52Accident · No injuriesClosedPiper PA-28 · Prospectville, PASep 5, 1976 · N4745L · Substantial damage NTSB NYC76FGM48Accident · No injuriesClosedPiper PA-28 · Mount Pleasant, PAAug 29, 1976 · N8266N · Substantial damage NTSB NYC76FGT76Accident · Serious injuriesClosedBowers Fly Baby · Kralltown, PAAug 25, 1976 · N8Q · Substantial damage NTSB NYC76FHA50Accident · No injuriesClosedGrum Amer AA-5 · Allentown, PAAug 22, 1976 · N7133L · Substantial damage NTSB NYC76DHA49Accident · Minor injuriesClosedSchweizer SGS126 · Erwinna, PAAug 21, 1976 · N1102S · Substantial damage NTSB NYC76DGM46Accident · Minor injuriesClosedPiper PA-22 · Zelienople, PAAug 20, 1976 · N3431Z · Substantial damage NTSB NYC76FGT28Accident · No injuriesClosedPiper PA-28 · Lock Haven, PAAug 19, 1976 · N44597 · Substantial damage NTSB NYC76FGT27Accident · No injuriesClosedBell 47D1 · Zion Grove, PAAug 18, 1976 · N919B · Substantial damage NTSB NYC76AN123Accident · 1 fatalClosedAeronca 11BC · Bally, PAAug 18, 1976 · N9807E · Substantial damage NTSB NYC76FGM45Accident · No injuriesClosedTed Smith 600 · West Mifflin, PAAug 17, 1976 · N7484S · Substantial damage NTSB NYC76DHD38Accident · No injuriesClosedPiper PA-28 · Toughkenamon, PAAug 17, 1976 · N41963 · Substantial damage NTSB NYC76FGM44Accident · No injuriesClosedCessna 180 · Delmont, PAAug 15, 1976 · N4731U · Substantial damage NTSB NYC76FGM43Accident · No injuriesClosedBeech A-23 · Somerset, PAAug 10, 1976 · N3557R · Substantial damage NTSB NYC76FGM42Accident · No injuriesClosedSportavia RF-5B · Penfield, PAAug 10, 1976 · N55SM · Substantial damage NTSB IAD76AI091Accident · Serious injuriesClosedBoeing 727 · Bethlehem, PAAug 8, 1976 · N854AA · No damage NTSB NYC76AN118Accident · 1 fatalClosedCessna 195 · Newburg, PAAug 4, 1976 · N193C · Destroyed NTSB NYC76FGT26Accident · Minor injuriesClosedSchweizer SGS233 · Fredericksburg, PAAug 3, 1976 · N2440W · Substantial damage NTSB NYC76FHA44Accident · No injuriesClosedSchweizer SGS233 · Kutztown, PAAug 1, 1976 · N33920 · Substantial damage NTSB NYC76FGM41Accident · No injuriesClosedSchleicher ASW-15 · Claysburg, PAAug 1, 1976 · N15DC · Substantial damage NTSB NYC76FHD34Accident · Serious injuriesClosedGrum Amer AA-5A · West Chester, PAJul 30, 1976 · N9683U · Substantial damage NTSB NYC76FHA46Accident · Serious injuriesClosedEnstrom F-28A · Collegeville, PAJul 20, 1976 · N9589 · Destroyed NTSB NYC76FGT26Accident · No injuriesClosedSchweizer SGU222 · Fredericksburg, PAJul 20, 1976 · N3844A · No damage NTSB NYC76FGT24Accident · No injuriesClosedPiper PA-28 · Centre Hall, PAJul 20, 1976 · N9214K · Substantial damage NTSB NYC76FGM40Accident · Serious injuriesClosedTaylorcraft BC12-D · Somerset, PAJul 18, 1976 · N95098 · Substantial damage NTSB NYC76AN112Accident · 3 fatalClosedPiper PA-28 · Zelienople, PAJul 17, 1976 · N4942T · Destroyed NTSB NYC76FGT22Accident · Serious injuriesClosedBellanca 7GCBC · Hanover, PAJul 14, 1976 · N53968 · Substantial damage NTSB NYC76FGM38Accident · No injuriesClosedGrum Amer AA1 · Erie, PAJul 6, 1976 · N5972L · Substantial damage NTSB NYC76FHA43Accident · No injuriesClosedPiper PA-28 · Saylorsburg, PAJul 5, 1976 · N4742L · Substantial damage NTSB NYC76DHA42Accident · No injuriesClosedBoeing E75 · Willow Grove, PAJul 2, 1976 · N9077H · Substantial damage NTSB NYC76FGM37Accident · No injuriesClosedPiper J-3 · Jeanette, PAJun 28, 1976 · N42574 · Substantial damage NTSB NYC76DHA41Accident · Minor injuriesClosedCessna 180 · Greentown, PAJun 28, 1976 · N2223C · Substantial damage NTSB NYC76FGM36Accident · No injuriesClosedCessna 182 · Delmont, PAJun 27, 1976 · N3555F · Substantial damage NTSB DCA76AZ029Accident · Serious injuriesClosedDouglas DC-9 · Philadelphia, PAJun 23, 1976 · N994VJ · Destroyed NTSB NYC76FGM35Accident · Serious injuriesClosedBell 204-B · Masontown, PAJun 22, 1976 · N1308X · Substantial damage NTSB NYC76FHA38Accident · Serious injuriesClosedNavion F · Frederick, PAJun 20, 1976 · N238 · Substantial damage NTSB NYC76FGM34Accident · No injuriesClosedBrantly B-2B · Greenburg, PAJun 8, 1976 · N2255U · Substantial damage NTSB NYC76AN103Accident · 1 fatalClosedPiper J3C-65 · Rockhill Furn, PAJun 6, 1976 · N7081H · Destroyed NTSB NYC76DHA35Accident · No injuriesClosedCessna 150 · Tunkhannock, PAJun 5, 1976 · N3092V · Substantial damage NTSB NYC76FGT21Accident · No injuriesClosedPiper PA-22 · Tower City, PAJun 3, 1976 · N40M · Substantial damage NTSB NYC76AN101Accident · 6 fatalClosedPiper PA-23 · Newville, PAJun 1, 1976 · N13991 · Destroyed NTSB NYC76FGT20Accident · No injuriesClosedPiper PA-28 · Morris, PAMay 27, 1976 · N8841J · Substantial damage NTSB NYC76AN100Accident · 1 fatalClosedBellanca 17-30A · Sewickley, PAMay 26, 1976 · N8817 · Destroyed NTSB NYC76DHA36Accident · No injuriesClosedDuster BJ18 · Martins Creek, PAMay 23, 1976 · N3ST · Substantial damage