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 NYC67F0035Accident · No injuriesClosedLuscombe 8F · West Mifflin, PAMay 27, 1966 · N1544B · Substantial damage NTSB NYC66F0669Accident · No injuriesClosedCessna 150 · West Mifflin, PAMay 26, 1966 · N7944Z · Substantial damage NTSB NYC66A0134Accident · Minor injuriesClosedBrantly B2B · Rostraver, PAMay 23, 1966 · N2188U · Destroyed NTSB NYC66F0701Accident · Serious injuriesClosedBeech SNB-5 · Milroy, PAMay 18, 1966 · N91373 · Destroyed NTSB NYC66D0671Accident · No injuriesClosedCessna 150 · Mt.Pocono, PAMay 15, 1966 · N7016X · Substantial damage NTSB NYC66D0692Accident · Minor injuriesClosedChampion 7FC · Sharpsville, PAMay 14, 1966 · N8597E · Substantial damage NTSB NYC66F0700Accident · No injuriesClosedPiper PA-28 · Williamsport, PAMay 13, 1966 · N9018W · Substantial damage NTSB NYC66A0131Accident · No injuriesClosedBell 47G-5 · Hickory, PAMay 13, 1966 · N8599F · Substantial damage NTSB NYC66D0651Accident · No injuriesClosedCessna 170B · Montgomery, PAMay 8, 1966 · N3417C · Substantial damage NTSB NYC66D0650Accident · Minor injuriesClosedCessna 150 · Honesdale, PAMay 8, 1966 · N4468V · Substantial damage NTSB NYC66A0128Accident · 4 fatalClosedPiper PA-23 · Indian Head, PAMay 8, 1966 · N5823Y · Destroyed NTSB NYC66A0126Accident · 2 fatalClosedPiper J3C-65 · Jim Thorpe, PAMay 8, 1966 · N91947 · Destroyed NTSB NYC66A0125Accident · 6 fatalClosedHoward DGA15P · Gilbertville, PAMay 7, 1966 · N9120H · Destroyed NTSB NYC66D0662Accident · No injuriesClosedPiper PA-22 · New Holland, PAMay 6, 1966 · N1493A · Substantial damage NTSB NYC66F0652Accident · No injuriesClosedCessna 310F · Elysburg, PAMay 4, 1966 · N6757X · Substantial damage NTSB NYC66F0642Accident · No injuriesClosedPiper PA-22 · Sayre, PAApr 30, 1966 · N4604Z · Substantial damage NTSB NYC66F0622Accident · Minor injuriesClosedPiper PA-32 · Bethel Park, PAApr 27, 1966 · N3374W · Substantial damage NTSB NYC66F0677Accident · Serious injuriesClosedErc0 415D · Bedford, PAApr 26, 1966 · N2560H · Substantial damage NTSB NYC66F0620Accident · No injuriesClosedCessna 172D · Justice, PAApr 26, 1966 · N2541Y · Substantial damage NTSB NYC66I0123Incident · No injuriesClosedBoeing 707 · Philadelphia, PAApr 24, 1966 · N7516A · Minor damage NTSB NYC66F0632Accident · No injuriesClosedPiper PA-28 · Sadsburyville, PAApr 23, 1966 · N5721W · Substantial damage NTSB NYC66A0121Accident · 1 fatalClosedHelio Acft H-250 · James Creek, PAApr 23, 1966 · N5454E · Destroyed NTSB NYC66D0648Accident · No injuriesClosedPiper J5A · New Baltimore, PAApr 22, 1966 · N33276 · Substantial damage NTSB NYC66A0119Accident · 4 fatalClosedBeech S35 · Clayville, PAApr 19, 1966 · N711AA · Destroyed NTSB NYC67A0118Accident · No injuriesClosedBell 47D1 · Peach Glen, PAApr 18, 1966 · N925B · Substantial damage NTSB NYC66F0617Accident · No injuriesClosedCessna 182 · Osceola, PAApr 18, 1966 · N3135U · Substantial damage NTSB NYC66D0607Accident · No injuriesClosedCessna 175 · Philipsburg, PAApr 18, 1966 · N7123M · Substantial damage NTSB NYC66D0612Accident · No injuriesClosedMooney 20E · Butler, PAApr 16, 1966 · N6027Q · Substantial damage NTSB NYC66D0592Accident · No injuriesClosedCessna 172 · Reading, PAApr 16, 1966 · N8691U · Substantial damage NTSB NYC66F0634Accident · No injuriesClosedNavion B · West Chester, PAApr 9, 1966 · N5380K · Substantial damage NTSB NYC66D0624Accident · No injuriesClosedPiper PA-22 · Aliquippa, PAApr 8, 1966 · N6718B · Substantial damage NTSB NYC66F0591Accident · Minor injuriesClosedPiper PA-28 · Prospectville, PAApr 5, 1966 · N6497W · Destroyed NTSB NYC66F0641Accident · No injuriesClosedBeech 35 · West Mifflin, PAApr 3, 1966 · N517B · Substantial damage NTSB NYC66D0603Accident · No injuriesClosedMooney M20C · New Holland, PAApr 3, 1966 · N6273U · Substantial damage NTSB NYC66F0625Accident · No injuriesClosedPiper PA-20 · Somerset, PAApr 2, 1966 · N7396K · Substantial damage NTSB NYC66A0106Accident · No injuriesClosedConvair 340 · Bradford, PAApr 1, 1966 · N5804 · Substantial damage NTSB NYC66F0610Accident · No injuriesClosedPiper PA-28 · Somerset, PAMar 23, 1966 · N4567R · Substantial damage NTSB NYC66F0579Accident · Minor injuriesClosedPiper PA-24 · Shippenville, PAMar 22, 1966 · N5607B · Substantial damage NTSB NYC66D0568Accident · No injuriesClosedCessna 140 · Corry, PAMar 21, 1966 · N89404 · Substantial damage NTSB NYC66D0551Accident · No injuriesClosedStinson 108-1 · Mohrsville, PAMar 20, 1966 · N97870 · Substantial damage NTSB NYC66F0565Accident · No injuriesClosedCessna 172G · Coraopolis, PAMar 19, 1966 · N3837L · Substantial damage NTSB NYC66D0584Accident · No injuriesClosedPiper PA-22 · New Albany, PAMar 19, 1966 · N7803D · Substantial damage NTSB NYC66A0102Accident · 2 fatalClosedPiper PA-28 · Falls Creek, PAMar 18, 1966 · N8181W · Destroyed NTSB NYC66D0534Accident · No injuriesClosedBeechcraft M88 · Ambler, PAMar 10, 1966 · N885E · Substantial damage NTSB NYC66F0556Accident · No injuriesClosedPiper PA-23 · Snydertown, PAMar 9, 1966 · N4562P · Substantial damage NTSB NYC66F0529Accident · No injuriesClosedCessna 150 · West Mifflin, PAMar 9, 1966 · N3977U · Substantial damage NTSB NYC66F0509Accident · No injuriesClosedPiper PA-23 · Mt Pocono, PAMar 2, 1966 · N5994Y · Substantial damage NTSB NYC66F0499Accident · No injuriesClosedCessna 172 · West Mifflin, PAMar 1, 1966 · N5439R · Substantial damage NTSB NYC66D0093Accident · No injuriesClosedBrantly B-2B · Mohrsville, PAFeb 27, 1966 · N2280U · Substantial damage NTSB NYC66F0567Accident · No injuriesClosedLuscombe 8A · Tarentum, PAFeb 20, 1966 · N45825 · Substantial damage