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 NYC69F0206Accident · Minor injuriesClosedChampion 7JC · Meadville, PAAug 30, 1968 · N8954R · Substantial damage NTSB NYC69D0145Accident · No injuriesClosedCessna 172 · Manchester, PAAug 30, 1968 · N7500T · Substantial damage NTSB NYC69A0022Accident · 1 fatalClosedCessna 206 · Snowshoe, PAAug 21, 1968 · N2680X · Destroyed NTSB NYC69D0236Accident · No injuriesClosedPiper PA-28 · Bridgeville, PAAug 20, 1968 · N7115R · Substantial damage NTSB NYC69F0133Accident · 1 fatalClosedConvair BT-15 · Summit Station, PAAug 19, 1968 · N355H · Destroyed NTSB NYC69F0123Accident · No injuriesClosedPiper PA-28 · Pottstown, PAAug 15, 1968 · N3724K · Substantial damage NTSB NYC69F0126Accident · No injuriesClosedCessna 170B · Monroeville, PAAug 13, 1968 · N2243D · Substantial damage NTSB NYC69D0131Accident · No injuriesClosedStinson 108-1 · Central City, PAAug 11, 1968 · N8212K · Substantial damage NTSB NYC69F0118Accident · Serious injuriesClosedPiper PA-32 · Morrisville, PAAug 8, 1968 · N3709W · Destroyed NTSB NYC69F0178Accident · 1 fatalClosedBell 47G3B1 · Sipesville, PAAug 5, 1968 · N73247 · Destroyed NTSB NYC69A0016Accident · Serious injuriesClosedSud Aviatn SE 210 · Elwood, PAAug 5, 1968 · N1005 · No damage NTSB NYC69F0067Accident · Minor injuriesClosedPiper PA-28 · Honesdale, PAAug 4, 1968 · N5235L · Destroyed NTSB NYC69F0064Accident · Serious injuriesClosedPiper PA-22 · Warrington, PAAug 4, 1968 · N5848Z · Substantial damage NTSB NYC69F0103Accident · Minor injuriesClosedPiper PA-24 · Thomasville, PAAug 3, 1968 · N7373P · Substantial damage NTSB NYC69D0172Accident · Serious injuriesClosedPiper PA-22 · Kittanning, PAAug 3, 1968 · N4896Z · Substantial damage NTSB NYC69F0070Accident · Minor injuriesClosedBell 47G-4 · Newport, PAJul 30, 1968 · N1165W · Substantial damage NTSB NYC69F0100Accident · 1 fatalClosedSpezio SPT DAL-1 · Towanda, PAJul 27, 1968 · N6981 · Destroyed NTSB NYC69F0094Accident · No injuriesClosedCessna 182F · Paupack, PAJul 27, 1968 · N3426U · Substantial damage NTSB NYC69D0125Accident · Minor injuriesClosedPiper PA-22 · Monroeville, PAJul 21, 1968 · N5433Z · Substantial damage NTSB NYC69F0105Accident · No injuriesClosedPiper PA-22 · Leechburg, PAJul 20, 1968 · N3656Z · Substantial damage NTSB NYC69D0176Accident · No injuriesClosedPiper PA-20 · Conneaut Lake, PAJul 20, 1968 · N1580A · Substantial damage NTSB NYC69D0060Accident · No injuriesClosedPiper J-3 · Hamlin, PAJul 20, 1968 · N21574 · Substantial damage NTSB NYC68F0098Accident · No injuriesClosedBeech D18S · Delta, PAJul 20, 1968 · N303MW · Destroyed NTSB NYC69D0184Accident · No injuriesClosedCessna 140 · Penn Run, PAJul 16, 1968 · N76140 · Substantial damage NTSB NYC69D0110Accident · Minor injuriesClosedErco 415-C · Tarentum, PAJul 14, 1968 · N87035 · Substantial damage NTSB NYC69F0077Accident · Serious injuriesClosedPiper J-3 · Beaver Falls, PAJul 13, 1968 · N98831 · Destroyed NTSB NYC69F0035Accident · No injuriesClosedAeronca 7AC · Matamoras, PAJul 11, 1968 · N3035E · Substantial damage NTSB NYC69A0040Accident · Serious injuriesClosedBoeing 727 · Philipsburg, PAJul 11, 1968 · N894TW · No damage NTSB NYC69A0007Accident · 1 fatalClosedPiper PA-30 · Lock Haven, PAJul 9, 1968 · N8572Y · Destroyed NTSB NYC69F0046Accident · No injuriesClosedCessna 210 · West Mifflin, PAJul 7, 1968 · N3738Y · Substantial damage NTSB NYC69F0076Accident · No injuriesClosedBrantly B-2B · Monroeville, PAJul 6, 1968 · N5948X · Substantial damage NTSB NYC69F0039Accident · No injuriesClosedPiper PA-28 · Butler, PAJul 6, 1968 · N5167L · Substantial damage NTSB NYC69D0244Accident · No injuriesClosedCessna 177 · Penn Run, PAJul 4, 1968 · N3382T · Substantial damage NTSB NYC69D0024Accident · No injuriesClosedErcoupe 415-C · Tunkhannock, PAJul 4, 1968 · N99418 · Substantial damage NTSB NYC69A0004Accident · 2 fatalClosedLuscombe 8E · Sunbury, PAJul 4, 1968 · N2717K · Destroyed NTSB NYC69F0059Accident · No injuriesClosedBeech A23A · Waynesburg, PAJul 3, 1968 · N3678Q · Substantial damage NTSB NYC69A0001Accident · No injuriesClosedDouglas DC-7BF · Philadelphia, PAJul 2, 1968 · N762Z · Substantial damage NTSB NYC69F0055Accident · Serious injuriesClosedNelson PG185B · Finleyville, PAJun 30, 1968 · N68580 · Substantial damage NTSB NYC69F0040Accident · No injuriesClosedCessna 170 · West Mifflin, PAJun 28, 1968 · N3008A · Substantial damage NTSB NYC69D0051Accident · No injuriesClosedPiper PA-23 · Tarentum, PAJun 28, 1968 · N6279Y · Substantial damage NTSB NYC69D0027Accident · No injuriesClosedCessna 177 · Sharpsville, PAJun 23, 1968 · N2813X · Substantial damage NTSB NYC68A0136Accident · 6 fatalClosedCessna 401 · Mohrsville, PAJun 19, 1968 · N3248Q · Destroyed NTSB NYC69D0012Accident · No injuriesClosedBellanca 14-13 · Collegeville, PAJun 16, 1968 · N74444 · Substantial damage NTSB NYC68A0134Accident · 4 fatalClosedPiper PA-28R · Gardners, PAJun 16, 1968 · N3783T · Destroyed NTSB NYC69F0007Accident · No injuriesClosedPiper PA-30 · Reading, PAJun 15, 1968 · N7569Y · Substantial damage NTSB NYC69D0021Accident · No injuriesClosedPiper PA-22 · Ambler, PAJun 15, 1968 · N5483Z · Substantial damage NTSB NYC68A0132Accident · 1 fatalClosedPiper PA-28 · Cairnbrook, PAJun 13, 1968 · N9857W · Destroyed NTSB NYC69F0016Accident · No injuriesClosedCessna 411 · Ambler, PAJun 12, 1968 · N406VW · Substantial damage NTSB NYC68A0130Accident · 3 fatalClosedPiper PA-32 · Newfoundland, PAJun 12, 1968 · N4007R · Destroyed NTSB NYC68F0508Accident · Minor injuriesClosedCessna 172 · Gilbertsville, PAJun 10, 1968 · N8449L · Destroyed