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 UNK64X3009Accident · No injuriesClosedPiper PA22 · Mifflinburg, PAJul 24, 1964 · N2309P · Substantial damage NTSB UNK64X3008Accident · No injuriesClosedGlobe Swift GC1B · Butler, PAJul 24, 1964 · N80839 · Substantial damage NTSB UNK64X2986Accident · Serious injuriesClosedPiper PA-22 · Gaines, PAJul 23, 1964 · N5806D · Substantial damage NTSB UNK64X2959Accident · No injuriesClosedPiper PA22 · Hershey, PAJul 21, 1964 · N3222Z · Substantial damage NTSB UNK64X2942Accident · No injuriesClosedBrantly B2B · Kutztown, PAJul 20, 1964 · N2255U · Substantial damage NTSB UNK64X2923Accident · No injuriesClosedCessna 210 · Coal Center, PAJul 19, 1964 · N9660T · Substantial damage NTSB UNK64X2862Accident · No injuriesClosedMooney M1855C · Philadelphia, PAJul 16, 1964 · N4169 · Substantial damage NTSB UNK64X2776Accident · Minor injuriesClosedPiper PA22 · Matamoras, PAJul 12, 1964 · N9032D · Substantial damage NTSB UNK64X2750Accident · Minor injuriesClosedCessna 150 · Ambler, PAJul 10, 1964 · N7969E · Destroyed NTSB UNK64X2744Accident · No injuriesClosedBeechcraft D18 · Ambler, PAJul 10, 1964 · N711K · Substantial damage NTSB UNK64X2660Accident · No injuriesClosedPiper PA22 · Clarks Summit, PAJul 5, 1964 · N55632 · Substantial damage NTSB UNK64X2601Accident · Serious injuriesClosedConvair CV-880 · Allentown, PAJul 1, 1964 · N803TW · No damage NTSB UNK64X2537Accident · No injuriesClosedCessna 140 · Collegeville, PAJun 28, 1964 · N72347 · Destroyed NTSB UNK64X2510Accident · No injuriesClosedPiper PA22 · Stroudsburg, PAJun 27, 1964 · N8618D · Substantial damage NTSB UNK64X2488Incident · No injuriesClosedMartin M-202A · Philadelphia, PAJun 26, 1964 · N173A · Minor damage NTSB UNK64X2428Accident · 3 fatalClosedBeechcraft 35 · Harrisburg, PAJun 21, 1964 · N2801V · Destroyed NTSB UNK64X2420Accident · Minor injuriesClosedPiper PA22 · Apollo, PAJun 21, 1964 · N2533P · Substantial damage NTSB UNK64X2353Accident · Minor injuriesClosedPiper PA22 · New Alexander, PAJun 18, 1964 · N7559D · Substantial damage NTSB UNK64X2342Accident · No injuriesClosedBell 47G2A1 · Bridgeton, PAJun 17, 1964 · N3075G · Substantial damage NTSB UNK64X2233Accident · No injuriesClosedBeechcraft 35 · West Mifflin, PAJun 11, 1964 · N2815V · Substantial damage NTSB UNK64X2089Accident · No injuriesClosedNavion A · Hershey, PAJun 3, 1964 · N4541K · Substantial damage NTSB UNK64X2023Accident · No injuriesClosedLuscombe 8A · Shippensburg, PAMay 30, 1964 · N45480 · Destroyed NTSB UNK64X1996Accident · Minor injuriesClosedPiper PA22 · W Mifflin, PAMay 28, 1964 · N644A · Substantial damage NTSB UNK64X1993Accident · Minor injuriesClosedCessna 195 · Greentown, PAMay 28, 1964 · N110U · Destroyed NTSB UNK64X1937Accident · No injuriesClosedPiper PA22 · Selinsgrove, PAMay 24, 1964 · N3048Z · Substantial damage NTSB UNK64X1914Accident · No injuriesClosedCessna 172 · Eagles Mere, PAMay 23, 1964 · N5424T · Substantial damage NTSB UNK64X1899Accident · No injuriesClosedFunk B85C · Corry, PAMay 23, 1964 · N81190 · Substantial damage NTSB UNK64X1878Accident · Minor injuriesClosedPiper PA22 · Pymatuning Lke, PAMay 22, 1964 · N5931Z · Destroyed NTSB UNK64X1866Accident · No injuriesClosedBellanca 1419 · Gardenville, PAMay 21, 1964 · N511A · Substantial damage NTSB UNK64X1800Accident · No injuriesClosedPiper PA16 · Annville, PAMay 17, 1964 · N5977H · Substantial damage NTSB UNK64X1797Accident · No injuriesClosedStinson 108-3 · Greentown, PAMay 17, 1964 · N6783M · Substantial damage NTSB UNK64X1769Accident · Serious injuriesClosedStinson 108 · Uniontown, PAMay 14, 1964 · N9712F · Destroyed NTSB UNK64X1764Accident · No injuriesClosedDehavilland 104 · Allentown, PAMay 14, 1964 · N918V · Substantial damage NTSB UNK64X1623Accident · No injuriesClosedLuscombe 8A · Carmichaels, PAMay 5, 1964 · N71932 · Substantial damage NTSB UNK64X1619Accident · No injuriesClosedBell 47G · Tannersville, PAMay 4, 1964 · N953B · Substantial damage NTSB UNK64X1610Accident · No injuriesClosedCessna 172 · Ambler, PAMay 4, 1964 · N3057U · Substantial damage NTSB UNK64X1581Accident · No injuriesClosedLuscombe 8A · Monroeville, PAMay 3, 1964 · N2819K · Substantial damage NTSB UNK64X1579Accident · No injuriesClosedMooney M20C · Beaver Falls, PAMay 3, 1964 · N6833U · Substantial damage NTSB UNK64X1556Accident · No injuriesClosedPiper PA22 · Carrolton, PAMay 2, 1964 · N5779Z · Substantial damage NTSB UNK64X1486Accident · No injuriesClosedAero Comm 500B · Bellefonte, PAApr 27, 1964 · N6268X · Substantial damage NTSB UNK64X1371Accident · No injuriesClosedPiper PA12 · Morrisville, PAApr 19, 1964 · N3088M · Substantial damage NTSB UNK64X1349Accident · No injuriesClosedPiper PA24 · Allentown, PAApr 17, 1964 · N5406P · Substantial damage NTSB UNK64X1305Accident · No injuriesClosedCessna 120 · Monroeville, PAApr 14, 1964 · N4256N · Substantial damage NTSB UNK64X1303Accident · 1 fatalClosedNavion B · Altoona, PAApr 13, 1964 · N5234K · Destroyed NTSB UNK64X1286Accident · No injuriesClosedErcoupe 415C · Oxford, PAApr 12, 1964 · N94633 · Substantial damage NTSB UNK64X1192Accident · No injuriesClosedSwift GC1B · Latrobe, PAApr 5, 1964 · N78320 · Substantial damage NTSB UNK64X1191Accident · No injuriesClosedPiper PA24 · Lancaster, PAApr 5, 1964 · N7788P · Substantial damage NTSB UNK64X1173Accident · Serious injuriesClosedSchweizer SGU222 · Hilltown, PAApr 4, 1964 · N91864 · Substantial damage NTSB UNK64X1128Accident · Minor injuriesClosedPiper PA-22 · Dravosburg, PAApr 1, 1964 · N5793Z · Substantial damage NTSB UNK64X1093Accident · No injuriesClosedCessna 172 · Honesdale, PAMar 29, 1964 · N9884T · Substantial damage