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 NYC66F0110Accident · Minor injuriesClosedPiper PA-28 · West Mifflin, PAJun 20, 1965 · N8046W · Substantial damage NTSB NYC66F0080Accident · No injuriesClosedPiper PA-23 · Ambler, PAJun 19, 1965 · N1325P · Substantial damage NTSB NYC66F0106Accident · No injuriesClosedCessna 120 · Beaver Falls, PAJun 15, 1965 · N2729N · Substantial damage NTSB NYC65A0145Accident · No injuriesClosedLockheed 1329 · Dillsburg, PAJun 10, 1965 · N9214R · Substantial damage NTSB NYC65D0235Accident · No injuriesClosedPiper PA-28 · Bethel, PAJun 3, 1965 · N6088W · Substantial damage NTSB NYC65F0234Accident · Minor injuriesClosedCessna 172 · Easton, PAMay 30, 1965 · N36445 · Substantial damage NTSB NYC66F0019Accident · No injuriesClosedCessna 140 · Zelienople, PAMay 26, 1965 · N508D · Substantial damage NTSB NYC66F0290Accident · No injuriesClosedHelio MK2 · Youngwood, PAMay 25, 1965 · N5451E · Substantial damage NTSB NYC65F0236Accident · No injuriesClosedCessna 150 · Newburg, PAMay 23, 1965 · N3075J · Destroyed NTSB NYC65D0222Accident · No injuriesClosedBeechcraft B-95 · Bristol, PAMay 21, 1965 · N1176 · Substantial damage NTSB NYC66F0023Accident · No injuriesClosedMooney M20 · West Mifflin, PAMay 20, 1965 · N900G · Substantial damage NTSB NYC65F0191Accident · No injuriesClosedAero Cmdr 680E · Warminster, PAMay 18, 1965 · N262X · Substantial damage NTSB NYC65F0213Accident · No injuriesClosedCessna 170 · Elizabethville, PAMay 17, 1965 · N2896C · Substantial damage NTSB NYC66D0052Accident · No injuriesClosedStinson 108-1 · Bridgeville, PAMay 16, 1965 · N8914K · Substantial damage NTSB NYC65F0220Accident · No injuriesClosedMooney 20C · Monroeville, PAMay 15, 1965 · N6535U · Substantial damage NTSB NYC66D0022Accident · No injuriesClosedPiper PA-28 · Hazleton, PAMay 14, 1965 · N5376W · Substantial damage NTSB NYC65F0184Accident · No injuriesClosedPiper PA-22 · Trexlertown, PAMay 14, 1965 · N2314P · Destroyed NTSB NYC65D0195Accident · No injuriesClosedCessna 205 · Ambler, PAMay 8, 1965 · N8331Z · Substantial damage NTSB NYC66D0051Accident · No injuriesClosedBeechcraft S-35 · Aliquippa, PAMay 2, 1965 · N5775K · Substantial damage NTSB NYC65F0179Accident · No injuriesClosedMaule M-4 · Mt Pleasant, PAMay 1, 1965 · N4740T · Substantial damage NTSB NYC65A0134Accident · 1 fatalClosedAeronca C-2 · Limerick, PAMay 1, 1965 · N10308 · Destroyed NTSB NYC65A0131Accident · No injuriesClosedBell 47G4 · West Mifflin, PAApr 29, 1965 · N1151W · Substantial damage NTSB NYC65F0115Accident · No injuriesClosedPiper PA-24 · Prospectville, PAApr 25, 1965 · N6327P · Substantial damage NTSB NYC65F0149Accident · Minor injuriesClosedCessna 182B · Reading, PAApr 24, 1965 · N2789G · Substantial damage NTSB NYC65D0216Accident · No injuriesClosedPiper J3L · Kinzua, PAApr 24, 1965 · N35855 · Substantial damage NTSB NYC65D0210Accident · No injuriesClosedPiper PA-28 · Port Allegany, PAApr 24, 1965 · N5329W · Substantial damage NTSB NYC65F0190Accident · Serious injuriesClosedAeronca 7CCM · Ebensburg, PAApr 20, 1965 · N4635E · Substantial damage NTSB NYC65F0137Accident · No injuriesClosedPiper PA-28 · Lake Ariel, PAApr 20, 1965 · N5207W · Substantial damage NTSB NYC65D0237Accident · No injuriesClosedPiper PA-22 · Distant, PAApr 20, 1965 · N3046Z · Substantial damage NTSB NYC65F0239Accident · No injuriesClosedErcoupe 415C · Clearfield, PAApr 19, 1965 · N99303 · Substantial damage NTSB NYC65F0165Accident · No injuriesClosedPiper PA-24 · Irvona, PAApr 19, 1965 · N8417P · Substantial damage NTSB NYC65F0111Accident · No injuriesClosedCessna 180 · Allentown, PAApr 19, 1965 · N3675C · Substantial damage NTSB NYC65A0126Accident · 3 fatalClosedBeechcraft D50 · Hollidaysburg, PAApr 18, 1965 · N4341D · Destroyed NTSB NYC65F0228Accident · No injuriesClosedCessna 310B · Philadelphia, PAApr 17, 1965 · N5362A · Substantial damage NTSB NYC65A0128Accident · 2 fatalClosedPiper PA-24 · Johnstown, PAApr 17, 1965 · N7397P · Destroyed NTSB NYC65A0123Accident · 1 fatalClosedPiper PA-23 · Millville, PAApr 15, 1965 · N5482Y · Destroyed NTSB NYC65F0147Accident · Serious injuriesClosedSchweizer SGU · Mars, PAApr 11, 1965 · N2749Z · Substantial damage NTSB NYC65F0116Accident · No injuriesClosedStinson 108-2 · Allentown, PAApr 11, 1965 · N386C · Substantial damage NTSB NYC65A0121Accident · 2 fatalClosedPiper PA-12 · Watsontown, PAApr 10, 1965 · N7843H · Destroyed NTSB NYC65A0124Accident · 1 fatalClosedPiper PA-25 · Philipsburg, PAApr 7, 1965 · N7335Z · Destroyed NTSB NYC65D0138Accident · No injuriesClosedFS Bert BF4 · Finleyville, PAMar 30, 1965 · N62F · Substantial damage NTSB NYC65F0125Accident · No injuriesClosedCessna 172F · Ambler, PAMar 27, 1965 · N8432U · Substantial damage NTSB UNK65X1478Accident · Serious injuriesClosedNelson PG185B · Acme, PAMar 21, 1965 · N68585 · Substantial damage NTSB NYC65F0068Accident · No injuriesClosedCessna 140 · Prospectville, PAMar 21, 1965 · N89286 · Substantial damage NTSB NYC65F0079Accident · Serious injuriesClosedGlobe GC-1B · Quakertown, PAMar 16, 1965 · N211U · Destroyed NTSB NYC65D0095Accident · No injuriesClosedPiper PA-22 · Corsica, PAMar 14, 1965 · N2562A · Substantial damage NTSB NYC65F0065Accident · No injuriesClosedPiper PA-28 · Morrisville, PAMar 13, 1965 · N7710W · Substantial damage NTSB NYC65A0113Accident · 2 fatalClosedLockheed L-18 · Philipsburg, PAMar 5, 1965 · N600N · Destroyed NTSB NYC65F0078Accident · No injuriesClosedCessna 180 · Freedom, PAMar 1, 1965 · N3214D · Substantial damage NTSB NYC65F0073Accident · Serious injuriesClosedCessna 310D · Tipton, PAMar 1, 1965 · N6965T · Destroyed