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 NYC76FGT13Accident · Serious injuriesClosedSchweizer 2-33 · Unionville, PADec 3, 1975 · N2400W · Destroyed NTSB NYC76FGM16Accident · No injuriesClosedPiper PA-28R · Pittsburgh, PANov 30, 1975 · N3993X · Substantial damage NTSB NYC76DGM15Accident · No injuriesClosedBell 206B · Lumber City, PANov 29, 1975 · N49636 · Substantial damage NTSB IAD76II035Incident · No injuriesClosedLockheed L1329 · N Philadelphia, PANov 20, 1975 · N1 · Minor damage NTSB NYC76FGT11Accident · No injuriesClosedAerostar 600 · Blanchard, PANov 16, 1975 · N7466S · Substantial damage NTSB NYC76FGT12Accident · No injuriesClosedSchweizer 2-33 · Julian, PANov 15, 1975 · N7703S · Substantial damage NTSB NYC76FGT10Accident · Minor injuriesClosedSchweizer 1-23D · Wingate, PANov 14, 1975 · N7840C · Substantial damage NTSB NYC76FHD13Accident · Serious injuriesClosedPiper PA-28 · Coatesville, PANov 9, 1975 · N8771N · Substantial damage NTSB NYC76AN049Accident · 4 fatalClosedNa Rockwell 112 · State College, PANov 7, 1975 · N4QA · Destroyed NTSB NYC76FGM13Accident · No injuriesClosedCessna 150 · Brideville, PANov 6, 1975 · N11164 · Substantial damage NTSB NYC76FHM13Accident · No injuriesClosedAeronca 7AC · Erwinna, PANov 1, 1975 · N83219 · Substantial damage NTSB IAD76FGM12Accident · Minor injuriesClosedMooney M20B · Erie, PAOct 30, 1975 · N74535 · Substantial damage NTSB NYC76FGM11Accident · Minor injuriesClosedCessna 172K · Haydentown, PAOct 28, 1975 · N46698 · Substantial damage NTSB NYC76DHD12Accident · No injuriesClosedGrum Amer AA1-B · Bristol, PAOct 27, 1975 · N9605L · Substantial damage NTSB NYC76FGT09Accident · No injuriesClosedPiper PA-28 · Hanover, PAOct 26, 1975 · N16434 · Substantial damage NTSB NYC76FHA15Accident · No injuriesClosedCessna 182P · Franklin Forks, PAOct 22, 1975 · N58525 · Substantial damage NTSB NYC76AN044Accident · No injuriesClosedBell 47J-2 · Conshocken, PAOct 22, 1975 · N3939B · Substantial damage NTSB NYC76FGT08Accident · No injuriesClosedCessna 182K · Gettysburg, PAOct 15, 1975 · N2823R · Substantial damage NTSB NYC76FGM10Accident · Minor injuriesClosedPiper PA-28 · Freeport, PAOct 8, 1975 · N6097W · Substantial damage NTSB NYC76FGT07Accident · Minor injuriesClosedCessna 182 · Columbia, PAOct 6, 1975 · N6295A · Destroyed NTSB NYC76FGT06Accident · No injuriesClosedPitts Spcl · Maytown, PAOct 4, 1975 · N7T · Destroyed NTSB LAX76IL023Incident · Serious injuriesClosedLockheed 1011 · Philadelphia, PAOct 2, 1975 · N31013 · No damage NTSB NYC76DHA14Accident · Minor injuriesClosedCessna 140 · New Milford, PAOct 1, 1975 · N2187V · Substantial damage NTSB NYC76FGM09Accident · Minor injuriesClosedMorrison Teenie · Greenville, PASep 28, 1975 · N2486 · Substantial damage NTSB NYC76FHA11Accident · Serious injuriesClosedPiper PA-22 · Limeport, PASep 26, 1975 · N2930Z · Substantial damage NTSB NYC76FGM08Accident · No injuriesClosedCessna 411 · New Castle, PASep 23, 1975 · N3212R · Substantial damage NTSB NYC76FGT04Accident · Minor injuriesClosedPiper PA-22 · Centre Hall, PASep 14, 1975 · N3282B · Substantial damage NTSB NYC76FGT03Accident · No injuriesClosedGrum Amer AA1-B · New Oxford, PASep 14, 1975 · N9976L · Substantial damage NTSB NYC76DGM06Accident · No injuriesClosedMitsubishi MU-2B · Bedford, PASep 14, 1975 · N492MA · Substantial damage NTSB NYC76FGT05Accident · No injuriesClosedSchemp Cirrus · Fairfield, PASep 13, 1975 · N6485 · Substantial damage NTSB NYC76AN033Accident · 4 fatalClosedRockwell 690A · Nemacolin, PASep 12, 1975 · N847CE · Destroyed NTSB NYC7LDHA10Accident · No injuriesClosedPiper PA-32 · Prospectville, PASep 7, 1975 · N899MA · Substantial damage NTSB NYC76FGM05Accident · No injuriesClosedHiller Acft UH-12B · Beaver Falls, PASep 3, 1975 · N90424 · Substantial damage NTSB NYC76DGM24Accident · No injuriesClosedCessna 337 · Jeannette, PAAug 23, 1975 · N2323S · Substantial damage NTSB NYC76DHA08Accident · Minor injuriesClosedBellanca 7AC · Zieglerville, PAAug 20, 1975 · N9162L · Substantial damage NTSB NYC76FGT02Accident · No injuriesClosedAeronca 11AC · Pine Grove, PAAug 10, 1975 · N9589E · Substantial damage NTSB NYC76AN021Accident · 2 fatalClosedMaule ME4 · Hydetown, PAAug 9, 1975 · N51161 · Destroyed NTSB NYC76FHD03Accident · No injuriesClosedPiper PA-32 · Philadelphia, PAAug 8, 1975 · N56503 · Substantial damage NTSB NYC76FGM03Accident · Minor injuriesClosedPiper PA-22 · Cooperstown, PAAug 7, 1975 · N939A · Substantial damage NTSB NYC76FHA05Accident · No injuriesClosedPiper PA-32 · Clifford, PAAug 3, 1975 · N5528J · Substantial damage NTSB NYC76FHA04Accident · No injuriesClosedBeech A24R · Collegeville, PAAug 2, 1975 · N8034R · Destroyed NTSB NYC76DHA06Accident · No injuriesClosedPiper PA-28 · Shartlesville, PAJul 27, 1975 · N44699 · Substantial damage NTSB NYC76AN012Accident · 1 fatalClosedCessna 150 · Carlisle, PAJul 25, 1975 · N23465 · Destroyed NTSB NYC76IN035Incident · No injuriesClosedBeech 99 · Philadelphia, PAJul 23, 1975 · N1033S · Minor damage NTSB NYC76AN011Accident · 4 fatalClosedBeech 35-B33 · Pecks Pond, PAJul 19, 1975 · N101AB · Destroyed NTSB NYC76AN007Accident · 1 fatalClosedPiper PA-28 · Benton, PAJul 16, 1975 · N4843L · Destroyed NTSB NYC76AN005Accident · 1 fatalClosedMooney M20C · Newtown, PAJul 14, 1975 · N4030N · Destroyed NTSB NYC76FGM02Accident · No injuriesClosedCessna 182F · Volant, PAJul 13, 1975 · N3451U · Substantial damage NTSB NYC76FGM01Accident · Minor injuriesClosedCessna 150 · St Marys, PAJul 10, 1975 · N11813 · Substantial damage NTSB NYC76FHD01Accident · Serious injuriesClosedSchweizer SGS · Avondale, PAJul 6, 1975 · N34186 · Substantial damage