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 NYC68F0197Accident · No injuriesClosedMooney M-22 · Lititz, PASep 19, 1967 · N7707M · Substantial damage NTSB NYC68F0279Accident · No injuriesClosedCessna 140 · Bedford, PASep 18, 1967 · N89747 · Substantial damage NTSB NYC68F0177Accident · No injuriesClosedCessna 150C · Monroeville, PASep 18, 1967 · N7895Z · Substantial damage NTSB NYC68A0044Accident · No injuriesClosedBell 47G-2 · Shippensburg, PASep 15, 1967 · N866Z · Substantial damage NTSB NYC68F0187Accident · No injuriesClosedPiper PA-28 · Cresson, PASep 14, 1967 · N6972W · Substantial damage NTSB NYC68D0184Accident · Minor injuriesClosedPiper PA-22 · West Chester, PASep 11, 1967 · N5014Z · Substantial damage NTSB NYC68D0166Accident · No injuriesClosedSchweizer SGU222 · West Chester, PASep 11, 1967 · N9918J · Substantial damage NTSB NYC68D0160Accident · No injuriesClosedPiper PA-28 · Reedsville, PASep 10, 1967 · N9794J · Substantial damage NTSB NYC68F0178Accident · No injuriesClosedPiper PA-28 · Bristol, PASep 6, 1967 · N6589W · Substantial damage NTSB NYC68F0132Accident · No injuriesClosedBeech 95-C55 · Lehighton, PASep 6, 1967 · N2710T · Substantial damage NTSB NYC68F0133Accident · No injuriesClosedN American P-51 · Pottstown, PASep 5, 1967 · N5478V · Destroyed NTSB NYC68D0162Accident · No injuriesClosedCessna 172 · East Berlin, PASep 4, 1967 · N5754R · Substantial damage NTSB NYC68A0040Accident · 2 fatalClosedLuscombe 8A · Morgan, PASep 2, 1967 · N77955 · Destroyed NTSB NYC68A0038Accident · No injuriesClosedSikorsky S-55B · Pittsfield, PASep 1, 1967 · N6872C · Destroyed NTSB NYC68F0165Accident · No injuriesClosedCessna 310 · Ambler, PAAug 29, 1967 · N4440 · Substantial damage NTSB NYC68D0115Accident · No injuriesClosedPiper PA-28 · Morrisville, PAAug 22, 1967 · N6142W · Substantial damage NTSB NYC68A0029Accident · 1 fatalClosedPiper PA-28 · Petersburg, PAAug 20, 1967 · N7358W · Destroyed NTSB NYC68D0118Accident · No injuriesClosedCessna 172 · New Hope, PAAug 19, 1967 · N7393T · Substantial damage NTSB NYC68D0176Accident · No injuriesClosedPiper PA-24 · Meadville, PAAug 16, 1967 · N7618P · Substantial damage NTSB NYC68D0173Accident · No injuriesClosedCessna 172 · Philadelphia, PAAug 15, 1967 · N2627L · Substantial damage NTSB NYC68D0093Accident · No injuriesClosedPiper PA-28 · Collegeville, PAAug 15, 1967 · N7712W · Substantial damage NTSB NYC68F0125Accident · No injuriesClosedPiper PA-22 · Butler, PAAug 13, 1967 · N5895Z · Substantial damage NTSB NYC68F0109Accident · Minor injuriesClosedCherokee II · Hershey, PAAug 12, 1967 · N10342 · Substantial damage NTSB NYC68D0121Accident · No injuriesClosedPiper PA-22 · Somerset, PAAug 9, 1967 · N9185D · Substantial damage NTSB NYC68D0120Accident · No injuriesClosedPiper PA-28 · Mt.Pleasant, PAAug 8, 1967 · N7090R · Substantial damage NTSB NYC68D0119Accident · No injuriesClosedBeech B50 · Montoursville, PAAug 8, 1967 · N276SS · Substantial damage NTSB NYC68F0110Accident · Serious injuriesClosedPiper PA-24 · Nottingham, PAAug 6, 1967 · N8090P · Destroyed NTSB NYC68F0108Accident · No injuriesClosedPiper PA-24 · Philadelphia, PAAug 6, 1967 · N7027P · Substantial damage NTSB NYC68D0122Accident · No injuriesClosedAeronca 11AC · Morrisdale, PAAug 5, 1967 · N9645E · Substantial damage NTSB NYC68F0131Accident · No injuriesClosedEaa B-2 · Monroeville, PAAug 4, 1967 · N1119B · Substantial damage NTSB NYC68A0022Accident · 3 fatalClosedBeech 95-C55 · Lancaster, PAAug 4, 1967 · N477AP · Destroyed NTSB NYC68F0063Accident · No injuriesClosedCessna 150G · Collegeville, PAAug 1, 1967 · N8307J · Substantial damage NTSB NYC68D0126Accident · No injuriesClosedBeech J35 · Meadeville, PAJul 31, 1967 · N634B · Substantial damage NTSB NYC68F0143Accident · No injuriesClosedPiper PA-28 · Erie, PAJul 30, 1967 · N8449R · Substantial damage NTSB NYC68D0130Accident · No injuriesClosedGlobe GC-1B · Cherry Tree, PAJul 30, 1967 · N3215K · Substantial damage NTSB NYC68A0016Accident · Serious injuriesClosedHiller UH-12L · Allentown, PAJul 30, 1967 · N90458 · Substantial damage NTSB NYC68F0188Accident · No injuriesClosedMaule M-4 · New Alexandria, PAJul 27, 1967 · N9858M · Substantial damage NTSB NYC68A0015Accident · No injuriesClosedGrumman G-159 · New Cumberland, PAJul 25, 1967 · N205M · Destroyed NTSB NYC68F0080Accident · No injuriesClosedAeronca 7AC · Monroeville, PAJul 23, 1967 · N85148 · Substantial damage NTSB NYC68D0070Accident · No injuriesClosedNavion B · Elysburg, PAJul 23, 1967 · N5259K · Substantial damage NTSB NYC68F0075Accident · No injuriesClosedRepublic RC-3 · Beaver, PAJul 22, 1967 · N6055K · Substantial damage NTSB NYC68D0007Accident · No injuriesClosedCessna 120 · Honesdale, PAJul 22, 1967 · N77354 · Substantial damage NTSB NYC68F0081Accident · No injuriesClosedPiper PA-28 · Cresson, PAJul 21, 1967 · N5609W · Substantial damage NTSB NYC68A0011Accident · No injuriesClosedBell 47-D1 · Waterford, PAJul 20, 1967 · N310A · Substantial damage NTSB NYC68F0082Accident · No injuriesClosedCougar I · Minersville, PAJul 16, 1967 · N1112Y · Substantial damage NTSB NYC68F0069Accident · No injuriesClosedTaylorcraft BC12-D · Mt Pleasant, PAJul 10, 1967 · N43203 · Substantial damage NTSB NYC68F0042Accident · No injuriesClosedGlobe GC-1B · Lehighton, PAJul 10, 1967 · N78128 · Substantial damage NTSB NYC68A0004Accident · No injuriesClosedPiper PA-23 · Pottstown, PAJul 10, 1967 · N5806Y · Substantial damage NTSB NYC68D0072Accident · No injuriesClosedTaylorcraft BC12-D · Hanover, PAJul 9, 1967 · N43505 · Substantial damage NTSB NYC68F0030Accident · No injuriesClosedStinson 108-1 · Mt.Pocono, PAJul 5, 1967 · N8420K · Substantial damage