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 NYC69F0469Accident · No injuriesClosedBeech B23 · Doylestown, PAMay 23, 1969 · N825AL · Substantial damage NTSB NYC69F0461Accident · Serious injuriesClosedPiper PA-22 · Sharon, PAMay 19, 1969 · N2426P · Substantial damage NTSB NYC69D0454Accident · No injuriesClosedPitt Spec · Butler, PAMay 18, 1969 · N232WS · Substantial damage NTSB NYC69D0462Accident · No injuriesClosedCessna 150 · West Chester, PAMay 11, 1969 · N2866S · Substantial damage NTSB NYC69D0445Accident · No injuriesClosedPiper PA-28 · Thomasville, PAMay 10, 1969 · N4657R · Substantial damage NTSB NYC69F0456Accident · No injuriesClosedPiper PA-22 · Gratz, PAMay 6, 1969 · N6510Z · Substantial damage NTSB NYC69F0475Accident · Minor injuriesClosedCessna 150H · Midway, PAMay 5, 1969 · N7132S · Substantial damage NTSB NYC69F0411Accident · Serious injuriesClosedCessna 172D · Darragh, PAMay 4, 1969 · N2350U · Destroyed NTSB NYC69D0406Accident · No injuriesClosedPiper PA-28 · Mt Pocono, PAMay 3, 1969 · N1793J · Substantial damage NTSB NYC69D0444Accident · No injuriesClosedPiper PA-28 · West Chester, PAMay 1, 1969 · N4978L · Substantial damage NTSB NYC69F0453Accident · No injuriesClosedMooney M20G · West Mifflin, PAApr 30, 1969 · N6806N · Substantial damage NTSB NYC69D0398Accident · Minor injuriesClosedCessna 180 · Easton, PAApr 28, 1969 · N3664C · Destroyed NTSB NYC69F0425Accident · Minor injuriesClosedPiper PA-28 · Hershey, PAApr 27, 1969 · N7384J · Substantial damage NTSB NYC69A0098Accident · No injuriesClosedCessna 150F · Mechanicsburg, PAApr 27, 1969 · N8063F · Substantial damage NTSB NYC69F0408Accident · Serious injuriesClosedCessna 150F · Monroeville, PAApr 26, 1969 · N3128X · Substantial damage NTSB NYC69D0391Accident · No injuriesClosedPiper PA-28 · Lehighton, PAApr 24, 1969 · N8021W · Substantial damage NTSB NYC69A0096Accident · 1 fatalClosedCessna 182 · Smithfield, PAApr 23, 1969 · N3137Q · Destroyed NTSB NYC69D0423Accident · No injuriesClosedBell 47G · Mercersburg, PAApr 21, 1969 · N938B · Substantial damage NTSB NYC69D0393Accident · No injuriesClosedCessna 172 · Fogelsville, PAApr 17, 1969 · N8831U · Substantial damage NTSB NYC69I0093Incident · No injuriesClosedAero Comdr 1121 · Allentown, PAApr 15, 1969 · N1190Z · Minor damage NTSB NYC69F0428Accident · Minor injuriesClosedPiper PA-22 · Titusville, PAApr 13, 1969 · N7733D · Substantial damage NTSB NYC69F0403Accident · No injuriesClosedBeech T-34 · Coraopolis, PAApr 13, 1969 · N7722B · Substantial damage NTSB NYC69F0402Accident · Minor injuriesClosedCessna 140A · Coudersport, PAApr 13, 1969 · N3780V · Substantial damage NTSB NYC69D0397Accident · No injuriesClosedLuscombe 8E · Wellsboro, PAApr 13, 1969 · N1976B · Substantial damage NTSB NYC69D0396Accident · No injuriesClosedPiper PA-22 · James Creek, PAApr 12, 1969 · N5139Z · Substantial damage NTSB NYC69D0395Accident · No injuriesClosedPiper PA-28 · Orwigsburg, PAApr 12, 1969 · N1750J · Substantial damage NTSB NYC69F0394Accident · No injuriesClosedBell 47G2A1 · Dunbar, PAApr 8, 1969 · N1215W · Substantial damage NTSB NYC69F0407Accident · No injuriesClosedCessna 177 · Connellsville, PAMar 23, 1969 · N3339T · Substantial damage NTSB NYC69D0365Accident · No injuriesClosedPiper PA-22 · Ebensburg, PAMar 23, 1969 · N5507Z · Substantial damage NTSB NYC69D0388Accident · Minor injuriesClosedCessna 150H · Zelienople, PAMar 22, 1969 · N23210 · Substantial damage NTSB NYC69D0353Accident · No injuriesClosedAeronca 65-C · Scranton, PAMar 16, 1969 · N22476 · Substantial damage NTSB NYC69A0087Accident · 4 fatalClosedPiper PA-24 · Ogletown, PAMar 14, 1969 · N7183P · Destroyed NTSB NYC69D0344Accident · No injuriesClosedCessna 172 · Myerstown, PAMar 11, 1969 · N3993S · Substantial damage NTSB NYC69D0354Accident · No injuriesClosedHughes 269A · Montgomryville, PAMar 7, 1969 · N8896F · Substantial damage NTSB NYC69D0358Accident · No injuriesClosedPiper PA-28 · Easton, PAMar 6, 1969 · N5779F · Substantial damage NTSB NYC69A0085Accident · No injuriesClosedBeech D18S · Coraopolis, PAMar 6, 1969 · N2279 · Substantial damage NTSB NYC69D0390Accident · No injuriesClosedCessna 337 · Ambler, PAMar 4, 1969 · N2112X · Substantial damage NTSB NYC69F0363Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAMar 3, 1969 · N8609Y · Substantial damage NTSB NYC69D0352Accident · No injuriesClosedCessna 310D · Kutztown, PAMar 1, 1969 · N6781T · Substantial damage NTSB NYC69F0328Accident · No injuriesClosedEaa Biplane B-2 · Monroeville, PAFeb 22, 1969 · N1119B · Substantial damage NTSB NYC69F0327Accident · Minor injuriesClosedCessna 177 · Maytown, PAFeb 22, 1969 · N3102T · Destroyed NTSB NYC69F0317Accident · No injuriesClosedPiper PA-28 · Ambler, PAFeb 17, 1969 · N7307J · Substantial damage NTSB NYC69F0349Accident · Minor injuriesClosedStinson 108 · Aliquippa, PAFeb 16, 1969 · N8539K · Substantial damage NTSB NYC69F0338Accident · Minor injuriesClosedBell 47G-4A · Gwynedd, PAFeb 16, 1969 · N4093G · Destroyed NTSB NYC69F0364Accident · No injuriesClosedPiper PA-23 · Johnstown, PAFeb 12, 1969 · N1046P · Substantial damage NTSB NYC69D0350Accident · No injuriesClosedCessna 180 · Erie, PAFeb 8, 1969 · CF-LGL · Substantial damage NTSB NYC69D0305Accident · Minor injuriesClosedCessna 150 · Sweet Valley, PAFeb 2, 1969 · N60182 · Substantial damage NTSB NYC69F0325Accident · No injuriesClosedSwift GC1B · Forty Fort, PAJan 26, 1969 · N2336B · Substantial damage NTSB NYC69F0300Accident · No injuriesClosedPiper PA-28 · Hershey, PAJan 26, 1969 · N9980W · Substantial damage NTSB NYC69A0076Accident · 2 fatalClosedPiper PA-24 · New Holland, PAJan 24, 1969 · N110KS · Destroyed