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 DCA77AA012Accident · 8 fatalClosedPiper PA-31T · Bressler, PAFeb 24, 1977 · N631PT · Destroyed NTSB NYC77DHD11Accident · No injuriesClosedPiper PA-32 · Blue Bell, PAFeb 20, 1977 · N8982W · Substantial damage NTSB NYC77FHA15Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PAFeb 16, 1977 · N33993 · Substantial damage NTSB NYC77FGM13Accident · No injuriesClosedCessna 180 · Apollo, PAFeb 12, 1977 · N3458Y · Substantial damage NTSB NYC77DHA14Accident · No injuriesClosedGrum Amer AA-5 · Montgomeryvill, PAFeb 12, 1977 · N72472 · Substantial damage NTSB NYC77FHD07Accident · No injuriesClosedBell 206B · Philadelphia, PAFeb 8, 1977 · N83005 · Substantial damage NTSB NYC77FGT08Accident · No injuriesClosedPiper PA-23 · Lock Haven, PAJan 28, 1977 · N62719 · Substantial damage NTSB NYC77FGM12Accident · Minor injuriesClosedPiper PA-28 · Adrian, PAJan 23, 1977 · N75021 · Substantial damage NTSB NYC77FHD06Accident · No injuriesClosedCessna 172M · West Chester, PAJan 22, 1977 · N61641 · Substantial damage NTSB NYC77FHA12Accident · Minor injuriesClosedCessna 150 · Honesdale, PAJan 21, 1977 · N22029 · Substantial damage NTSB NYC77FGT07Accident · No injuriesClosedAero Comdr 680F · Neffsville, PAJan 15, 1977 · N1666C · Substantial damage NTSB NYC77FGM11Accident · No injuriesClosedLuscombe 8A · Slippery Rock, PAJan 13, 1977 · N2907K · Substantial damage NTSB NYC77IA027Incident · No injuriesClosedFairchild F-27J · Philadelphia, PAJan 11, 1977 · N517T · Minor damage NTSB NYC77FHA11Accident · Minor injuriesClosedPiper PA-24 · Allentown, PAJan 9, 1977 · N8014P · Substantial damage NTSB NYC77FGM10Accident · No injuriesClosedCessna 150L · Corry, PAJan 9, 1977 · N6849G · Substantial damage NTSB NYC77FGM09Accident · Minor injuriesClosedEnstrom F-28C · Fallentimber, PAJan 8, 1977 · N537H · Substantial damage NTSB NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PADec 25, 1976 · N3788J · Destroyed NTSB NYC77FA023Accident · Serious injuriesClosedConvair 580 · Bradford, PADec 21, 1976 · N5811 · No damage NTSB NYC77FHA09Accident · Minor injuriesClosedPiper PA-28 · Claussville, PADec 20, 1976 · N75269 · Substantial damage NTSB NYC77FGM07Accident · No injuriesClosedCessna 340 · Belle Vernon, PADec 20, 1976 · N1388G · Substantial damage NTSB NYC77FGT06Accident · No injuriesClosedCessna 177B · Mifflintown, PADec 18, 1976 · N34328 · Substantial damage NTSB NYC77FGM08Accident · No injuriesClosedPiper PA-32 · Ligonier, PADec 18, 1976 · N15852 · Substantial damage NTSB NYC77FGM06Accident · No injuriesClosedBeech B19 · Belle Vernon, PADec 14, 1976 · N6961R · Substantial damage NTSB NYC77FGM05Accident · No injuriesClosedPiper PA-24 · Monongahela, PADec 10, 1976 · N8052P · Substantial damage NTSB NYC77FGM04Accident · Serious injuriesClosedPiper PA-24 · Smithfield, PADec 10, 1976 · N7AG · Substantial damage NTSB NYC77IA020Incident · No injuriesClosedBoeing 727 · Philadelphia, PADec 7, 1976 · N8106N · Minor damage NTSB NYC77FGT03Accident · Minor injuriesClosedStits SA3B · Lititz, PANov 30, 1976 · N1941L · Substantial damage NTSB NYC77FHA05Accident · Serious injuriesClosedBellanca 17-31A · Barto, PANov 27, 1976 · N103MV · Substantial damage NTSB NYC77FGT04Accident · Minor injuriesClosedPiper PA-28 · Philipsburg, PANov 26, 1976 · N75049 · Substantial damage NTSB NYC77FGT02Accident · No injuriesClosedChampion 7GCAA · Anneville, PANov 25, 1976 · N9612S · Substantial damage NTSB NYC77FHD04Accident · No injuriesClosedPiper PA-22 · Bristol, PANov 21, 1976 · N5718Z · Destroyed NTSB NYC77FA014Accident · 1 fatalClosedCessna 172M · Conneautville, PANov 20, 1976 · N80778 · Destroyed NTSB NYC77DHA06Accident · No injuriesClosedChampion 7ECA · Dalton, PANov 19, 1976 · N2501F · Substantial damage NTSB NYC77FA012Accident · 1 fatalClosedPiper PA-22 · Warren Center, PANov 12, 1976 · N973A · Destroyed NTSB NYC77FHA04Accident · Minor injuriesClosedAeronca 11AC · Hazleton, PANov 7, 1976 · N86042 · Destroyed NTSB NYC77FA004Accident · 4 fatalClosedPiper PA-28 · Elizabethville, PAOct 18, 1976 · N55989 · Substantial damage NTSB NYC77FA005Accident · 1 fatalClosedPiper PA-28 · Frenchville, PAOct 17, 1976 · N4189J · Destroyed NTSB NYC77FHD01Accident · No injuriesClosedCessna 150 · West Chester, PAOct 16, 1976 · N63150 · Substantial damage NTSB NYC77FHA01Accident · Serious injuriesClosedBellanca 7GCBC · Center Square, PAOct 16, 1976 · N7AK · Substantial damage NTSB NYC77FGM02Accident · Serious injuriesClosedBellanca 14-19 · Fort Littleton, PAOct 15, 1976 · N526A · Substantial damage NTSB NYC77DHA08Accident · No injuriesClosedPiper PA-28R · Shultzville, PAOct 15, 1976 · N43731 · Substantial damage NTSB NYC76FHA02Accident · Serious injuriesClosedCessna 170B · Analomink, PAOct 15, 1976 · N2922D · Destroyed NTSB NYC77FA003Accident · 1 fatalClosedAeronca 15AC · Erwinna, PAOct 14, 1976 · N1269H · Substantial damage NTSB NYC77DGM01Accident · Minor injuriesClosedPiper PA-18 · Emporium, PAOct 5, 1976 · N8787D · Substantial damage NTSB NYC77FGT01Accident · No injuriesClosedN. American AT-6C · Port Matilda, PAOct 4, 1976 · N9543C · Substantial damage NTSB NYC77FA001Accident · 2 fatalClosedBeech E55 · Bradford, PAOct 1, 1976 · N4055S · Destroyed NTSB NYC76FGM53Accident · Minor injuriesClosedPiper PA-32 · Indiana, PASep 26, 1976 · N43216 · Substantial damage NTSB NYC76FGM52Accident · No injuriesClosedCessna 150F · Cooperstown, PASep 25, 1976 · N6245R · Substantial damage NTSB NYC76FGM51Accident · Minor injuriesClosedBeech A35 · North East, PASep 22, 1976 · N8650A · Substantial damage NTSB NYC76FGM50Accident · No injuriesClosedCessna 150L · Beaver Falls, PASep 19, 1976 · N17266 · Substantial damage