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 NYC66A0048Accident · No injuriesClosedBensen B8M · Benton, PAOct 3, 1965 · N1138 · Substantial damage NTSB NYC66F0253Accident · No injuriesClosedBeechcraft C-35 · Newton, PASep 30, 1965 · N325AA · Substantial damage NTSB NYC66F0254Accident · Serious injuriesClosedPiper PA-28 · Philadelphia, PASep 28, 1965 · N6378W · Substantial damage NTSB NYC66D0296Accident · No injuriesClosedCessna 175 · Bedford, PASep 26, 1965 · N7036M · Substantial damage NTSB NYC66F0319Accident · No injuriesClosedHelio MK2 · Shippenville, PASep 23, 1965 · N5456E · Substantial damage NTSB NYC66D0360Accident · No injuriesClosedCessna 172 · Erie, PASep 22, 1965 · N5360R · Substantial damage NTSB NYC66F0238Accident · No injuriesClosedPiper PA-23 · Allentown, PASep 21, 1965 · N286GB · Substantial damage NTSB NYC66D0255Accident · No injuriesClosedMooney M20A · Avondale, PASep 17, 1965 · N6567B · Substantial damage NTSB NYC66D0336Accident · Minor injuriesClosedPiper J3C-65 · Brockport, PASep 11, 1965 · N92357 · Substantial damage NTSB NYC66F0227Accident · No injuriesClosedStinson 108-2 · Franklin, PASep 6, 1965 · N964D · Substantial damage NTSB NYC66F0199Accident · No injuriesClosedPiper PA-28 · Morrisville, PASep 5, 1965 · N6142W · Substantial damage NTSB NYC66A0032Accident · 1 fatalClosedStinson 108-3 · Milroy, PASep 5, 1965 · N6353M · Destroyed NTSB NYC66D0197Accident · No injuriesClosedAeronca 7AC · West Chester, PASep 4, 1965 · N85627 · Substantial damage NTSB NYC66F0221Accident · No injuriesClosedPiper J3C · Monroeville, PASep 3, 1965 · N98679 · Substantial damage NTSB NYC66F0208Accident · No injuriesClosedCessna 180 · Tarentum, PASep 3, 1965 · N4998A · Substantial damage NTSB NYC66A0030Accident · 1 fatalClosedNavion A · St Marys, PASep 2, 1965 · N5115K · Destroyed NTSB NYC66A0029Accident · 4 fatalClosedMaule BD-M-4 · Champion, PASep 1, 1965 · N4735T · Destroyed NTSB NYC66D0229Accident · No injuriesClosedNavion B · Elysburg, PAAug 31, 1965 · N5259K · Substantial damage NTSB NYC66D0198Accident · No injuriesClosedPiper PA-22 · State College, PAAug 31, 1965 · N6164D · Substantial damage NTSB NYC66F0233Accident · Serious injuriesClosedPiper PA15 · Bloomsburg, PAAug 30, 1965 · N4132H · Destroyed NTSB NYC66F0214Accident · Minor injuriesClosedNavion 4 · Austin, PAAug 26, 1965 · N4270K · Destroyed NTSB NYC66F0205Accident · No injuriesClosedCessna 182A · Dravosburg, PAAug 23, 1965 · N4732D · Substantial damage NTSB NYC66A0027Accident · Minor injuriesClosedBrantly 305 · Millheim, PAAug 23, 1965 · N2202U · Substantial damage NTSB NYC66F0230Accident · No injuriesClosedCessna 140 · Keating, PAAug 16, 1965 · N76066 · Substantial damage NTSB NYC66D0187Accident · No injuriesClosedBeechcraft F-35 · Philadelphia, PAAug 16, 1965 · N3387C · Substantial damage NTSB NYC66A0023Accident · 1 fatalClosedPiper PA-22 · Greencastle, PAAug 15, 1965 · N3834P · Substantial damage NTSB NYC66F0166Accident · No injuriesClosedNo American SNJ-5 · Monroeville, PAAug 14, 1965 · N9813C · Substantial damage NTSB NYC66F0200Accident · No injuriesClosedNavion B · Annville, PAAug 12, 1965 · N5290K · Substantial damage NTSB NYC66F0133Accident · Serious injuriesClosedAeronca 7AC · Warrington, PAAug 10, 1965 · N2477E · Substantial damage NTSB NYC66F0165Accident · No injuriesClosedLuscombe 8A · Dallastown, PAAug 8, 1965 · N1225B · Substantial damage NTSB NYC66D0162Accident · Minor injuriesClosedHelisoar HP-10 · Kutztown, PAAug 8, 1965 · N294B · Substantial damage NTSB NYC66F0256Accident · No injuriesClosedCessna 310B · Bristol, PAAug 7, 1965 · N3693D · Substantial damage NTSB NYC66F0170Accident · No injuriesClosedBeechcraft C-18S · Beaver Falls, PAAug 7, 1965 · N7377C · Substantial damage NTSB NYC66F0191Accident · Minor injuriesClosedGlobe GC-1B · Florence, PAAug 6, 1965 · N80839 · Substantial damage NTSB NYC66F0118Accident · No injuriesClosedPiper PA-22 · Waynesburg, PAJul 31, 1965 · N2768P · Substantial damage NTSB NYC66D0181Accident · No injuriesClosedPiper PA-22 · Blairsville, PAJul 30, 1965 · N5328Z · Substantial damage NTSB NYC66D0083Accident · No injuriesClosedPiper PA-22 · Honesdale, PAJul 29, 1965 · N5407Z · Substantial damage NTSB NYC66D0150Accident · No injuriesClosedPiper PA-28 · West Mifflin, PAJul 28, 1965 · N6613W · Substantial damage NTSB NYC66A0015Accident · 1 fatalClosedPiper PA-22 · Johnstown, PAJul 28, 1965 · N6151D · Destroyed NTSB NYC66F0076Accident · No injuriesClosedCessna 172 · Kutztown, PAJul 25, 1965 · N3589S · Substantial damage NTSB NYC66A0012Accident · Serious injuriesClosedOnvair C V-440 · Montorsville, PAJul 23, 1965 · N815H · Destroyed NTSB NYC66F0180Accident · No injuriesClosedGlobe GC-1B · Butler, PAJul 19, 1965 · N78104 · Substantial damage NTSB NYC66D0078Accident · No injuriesClosedChampion 7FC · Doylestown, PAJul 18, 1965 · N9880B · Substantial damage NTSB NYC66A0005Accident · 4 fatalClosedCessna 310D · 5s Mercersburg, PAJul 11, 1965 · N6735T · Destroyed NTSB NYC66A0004Accident · 1 fatalClosedMid Mustang M-M-1 · Elizabethville, PAJul 11, 1965 · N8718E · Destroyed NTSB NYC66F0127Accident · No injuriesClosedPiper PA-22 · Bethel Park, PAJul 4, 1965 · N4518A · Substantial damage NTSB NYC66F0112Accident · No injuriesClosedCessna 170A · Irwin, PAJul 4, 1965 · N3850V · Substantial damage NTSB NYC66F0117Accident · No injuriesClosedMooney M20D · West Mifflin, PAJul 3, 1965 · N6615U · Substantial damage NTSB NYC66F0034Accident · No injuriesClosedGlobe GC-1A · Allentown, PAJul 1, 1965 · N80579 · Substantial damage NTSB NYC65A0156Accident · 1 fatalClosedCessna 170 · Neffsville, PAJun 27, 1965 · N4080V · 2 aircraft · Minor damage