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 UNK65X0426Accident · No injuriesClosedTaylorcraft BC1265 · Slate Run, PAOct 25, 1964 · N23888 · Destroyed NTSB UNK65X0408Accident · No injuriesClosedCesna 310 · Kylertown, PAOct 24, 1964 · N6705T · Substantial damage NTSB UNK65X0354Incident · No injuriesClosedBoeing 727-23 · Allentown, PAOct 21, 1964 · N1791 · No damage NTSB UNK65X0353Accident · No injuriesClosedCessna T-50 · Collegeville, PAOct 21, 1964 · N69841 · Substantial damage NTSB UNK65X0327Accident · No injuriesClosedBeechcraft 23 · Clark Summits, PAOct 18, 1964 · N8727M · Substantial damage NTSB UNK65X0324Accident · No injuriesClosedAeronca 7DC · Bridgeville, PAOct 18, 1964 · N4533E · Substantial damage NTSB UNK65X0294Accident · No injuriesClosedBeechcraft K35 · State College, PAOct 16, 1964 · N3085C · Substantial damage NTSB UNK65X0196Accident · No injuriesClosedCessna 140 · Slate Run, PAOct 8, 1964 · N89012 · Destroyed NTSB UNK65X0172Accident · No injuriesClosedAeronca 65C · Dalton, PAOct 7, 1964 · N22392 · Substantial damage NTSB UNK65X0163Accident · No injuriesClosedCessna 182F · Lancaster, PAOct 6, 1964 · N3532Y · Substantial damage NTSB UNK65X0154Accident · No injuriesClosedCessna 150 · Allentown, PAOct 5, 1964 · N6560T · Substantial damage NTSB UNK65X0119Accident · No injuriesClosedPiper PA30 · Reading, PAOct 3, 1964 · N7178Y · Substantial damage NTSB UNK64X4220Accident · No injuriesClosedLuscombe 8E · Butler, PASep 30, 1964 · N2527K · Substantial damage NTSB UNK64X4178Accident · No injuriesClosedCessna 172 · Lancaster, PASep 27, 1964 · N5150A · Substantial damage NTSB UNK64X4135Incident · No injuriesClosedBoeing 707 131B · Reading, PASep 25, 1964 · N6781TW · Minor damage NTSB UNK64X4057Accident · 3 fatalClosedCessna 170B · Ickesburg, PASep 19, 1964 · N4460B · Destroyed NTSB UNK64X4034Accident · No injuriesClosedPiper PA24 · Phildelphia, PASep 18, 1964 · N7867P · Substantial damage NTSB UNK64X4015Accident · No injuriesClosedPiper PA22 · Blawnox, PASep 17, 1964 · N7032B · Substantial damage NTSB UNK64X3999Accident · No injuriesClosedPiper PA24 · Ulysses, PASep 16, 1964 · N6123P · Substantial damage NTSB UNK64X3990Accident · No injuriesClosedPiper PA28 · Lewistown, PASep 14, 1964 · N8606W · Substantial damage NTSB UNK64X3969Accident · No injuriesClosedNavion · Honesdale, PASep 13, 1964 · N8718H · Substantial damage NTSB UNK64X3952Accident · 1 fatalClosedCessna 175 · Quakertown, PASep 13, 1964 · N8382T · Destroyed NTSB UNK64X3915Accident · Minor injuriesClosedPiper PA28 · Martinsburg, PASep 11, 1964 · N5166W · Substantial damage NTSB UNK64X3903Accident · No injuriesClosedNavion B · State College, PASep 10, 1964 · N5223K · Destroyed NTSB UNK64X3894Accident · Minor injuriesClosedPiper PA23 · Lehighton, PASep 10, 1964 · N5540Y · Destroyed NTSB UNK64X3883Accident · Minor injuriesClosedErcoupe 415C · Easton, PASep 9, 1964 · N94396 · Substantial damage NTSB UNK64X3869Accident · Minor injuriesClosedCessna 140 · Mt Pleasant, PASep 8, 1964 · N140FC · Substantial damage NTSB UNK64X3818Accident · No injuriesClosedPiper PA24 · Pittsburgh, PASep 6, 1964 · N6805P · Substantial damage NTSB UNK64X3665Accident · No injuriesClosedBeechcraft E18 · Reading, PAAug 29, 1964 · N5632D · Substantial damage NTSB UNK64X3576Accident · No injuriesClosedNavion B · Lebanon, PAAug 24, 1964 · N5290K · Substantial damage NTSB UNK64X3552Accident · No injuriesClosedStinson 108 · Aliquippa, PAAug 23, 1964 · N8320K · Substantial damage NTSB UNK64X3545Accident · Minor injuriesClosedBeechcraft C45H · Gilbertsville, PAAug 22, 1964 · N74838 · Substantial damage NTSB UNK64X3413Accident · No injuriesClosedCessna 310 · Butler, PAAug 16, 1964 · N1871H · Substantial damage NTSB UNK64X3406Accident · Serious injuriesClosedPiper J3 · Monroeville, PAAug 15, 1964 · N98679 · Substantial damage NTSB UNK64X3393Accident · No injuriesClosedSilvaire 8F · Cambridge, PAAug 15, 1964 · N9936C · Substantial damage NTSB UNK64X3372Accident · 2 fatalClosedCessna T-50 · New Florence, PAAug 13, 1964 · N61812 · Destroyed NTSB UNK64X3358Accident · No injuriesClosedPiper J3 · Greensburg, PAAug 13, 1964 · N2089M · Substantial damage NTSB UNK64X3349Accident · Minor injuriesClosedBrantly B2 · Beaver Falls, PAAug 12, 1964 · N5997X · Substantial damage NTSB UNK64X3210Accident · No injuriesClosedBellanca 14132 · Cresson, PAAug 4, 1964 · N74392 · Substantial damage NTSB UNK64X3190Accident · No injuriesClosedMooney MK21 · Easton, PAAug 3, 1964 · N74574 · Substantial damage NTSB UNK64X3186Accident · 2 fatalClosedPiper PA-22 · Bloomsburg, PAAug 2, 1964 · N8109D · Destroyed NTSB UNK64X3150Accident · Minor injuriesClosedFairchild M62A3 · Mt.Cobb, PAAug 1, 1964 · N69595 · Destroyed NTSB UNK64X3113Accident · No injuriesClosedBell 47G · Dublin, PAJul 29, 1964 · N616X · Substantial damage NTSB UNK64X3104Accident · No injuriesClosedCessna 172 · Clarion, PAJul 29, 1964 · N1304Y · Substantial damage NTSB UNK64X3079Accident · 1 fatalClosedNavion NAV-4 · Mount Pocono, PAJul 27, 1964 · N4303K · Destroyed NTSB UNK64X3071Accident · No injuriesClosedPiper PA23 · Clairion, PAJul 27, 1964 · N1396P · Substantial damage NTSB UNK64X3062Accident · No injuriesClosedAero Comm 560A · Clarks Sunmit, PAJul 27, 1964 · N2751B · Substantial damage NTSB UNK64X3052Accident · Minor injuriesClosedPiper J-3 · Harmonsburg, PAJul 26, 1964 · N27068 · Substantial damage NTSB UNK64X3040Accident · No injuriesClosedFairchild PT26 · Dowington, PAJul 25, 1964 · N37157 · Substantial damage NTSB UNK64X3032Accident · No injuriesClosedPiper J3 · Bridgeville, PAJul 25, 1964 · N7203H · Substantial damage