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 NYC66F0519Accident · No injuriesClosedCessna 175 · Tarentum, PAFeb 20, 1966 · N6500E · Substantial damage NTSB NYC66D0487Accident · No injuriesClosedPiper PA-22 · Collegeville, PAFeb 20, 1966 · N5764Z · Substantial damage NTSB NYC66D0485Accident · No injuriesClosedPiper PA-28 · Lehighton, PAFeb 14, 1966 · N6091W · Substantial damage NTSB NYC66A0089Accident · 4 fatalClosedPiper PA-24 · Hellam, PAFeb 13, 1966 · N7513P · Destroyed NTSB NYC66F0513Accident · Minor injuriesClosedCessna 140 · Bellefonte, PAFeb 12, 1966 · N72921 · Substantial damage NTSB NYC66F0508Accident · No injuriesClosedCessna 150 · New Cumberland, PAFeb 12, 1966 · N7842E · Substantial damage NTSB NYC66F0495Accident · No injuriesClosedTaylorcraft BC-65 · Tarentum, PAFeb 12, 1966 · N22657 · Substantial damage NTSB NYC66A0087Accident · No injuriesClosedFairchild F-27J · Gr.Pttsbrg Apt, PAFeb 10, 1966 · N2709J · Substantial damage NTSB NYC66A0086Accident · Minor injuriesClosedBrantly 305 · Cowansville, PAFeb 7, 1966 · N2207U · Substantial damage NTSB NYC66F0459Accident · Minor injuriesClosedPiper PA-28 · Doylestown, PAFeb 5, 1966 · N8896W · Substantial damage NTSB NYC66D0510Accident · No injuriesClosedChampion 7EC · New Wilmington, PAFeb 5, 1966 · N9067B · Substantial damage NTSB NYC66D0479Accident · No injuriesClosedPiper PA-28 · Clearfield, PAFeb 5, 1966 · N8546W · Substantial damage NTSB NYC66A0083Accident · Minor injuriesClosedBell 47D1 · Broqueville, PAFeb 2, 1966 · N225B · Substantial damage NTSB NYC66F0461Accident · No injuriesClosedCessna 182 · Doylestown, PAFeb 1, 1966 · N3239Y · Substantial damage NTSB NYC66D0468Accident · No injuriesClosedCessna 172 · Emlenton, PAJan 29, 1966 · N6258E · Substantial damage NTSB NYC66A0081Accident · 3 fatalClosedBeech B95A · Erie, PAJan 27, 1966 · N598C · Destroyed NTSB NYC66D0451Accident · No injuriesClosedPiper PA-28 · Pottstown, PAJan 26, 1966 · N7833W · Substantial damage NTSB NYC66F0454Accident · No injuriesClosedPiper PA-28 · West Mifflin, PAJan 25, 1966 · N8840J · Substantial damage NTSB NYC66F0492Accident · No injuriesClosedPiper PA 28 · Oss Township, PAJan 22, 1966 · CF-OYW · Substantial damage NTSB NYC66F0478Accident · No injuriesClosedPiper PA-28 · Friedens, PAJan 21, 1966 · N4567R · 2 aircraft · Substantial damage NTSB NYC66D0472Accident · No injuriesClosedPiper PA-28 · Nottingham, PAJan 19, 1966 · N5721W · Substantial damage NTSB NYC66A0076Accident · 3 fatalClosedNavion G · Moosic, PAJan 19, 1966 · N2404T · Destroyed NTSB NYC66D0433Accident · No injuriesClosedCessna 150 · Ambler, PAJan 14, 1966 · N8425G · Substantial damage NTSB NYC66A0070Accident · No injuriesClosedBell Cntntl · Philadelphia, PAJan 7, 1966 · N73872 · Substantial damage NTSB NYC66D0420Accident · No injuriesClosedCessna 310C · Philadelphia, PADec 31, 1965 · N6703T · Substantial damage NTSB NYC66F0405Accident · No injuriesClosedPiper P A-28 · Mt Alton, PADec 28, 1965 · N8418W · Substantial damage NTSB NYC66F0401Accident · Minor injuriesClosedPiper PA-22 · Butler, PADec 22, 1965 · N5843Z · Substantial damage NTSB NYC66D0434Accident · No injuriesClosedCessna 195 · Philadelphia, PADec 17, 1965 · N177US · Substantial damage NTSB NYC66D0453Accident · Minor injuriesClosedErcoupe 415-C · Londonderry Tp, PADec 16, 1965 · N2205H · Destroyed NTSB NYC66D0424Accident · Minor injuriesClosedCessna 172 · Pittsburg, PADec 15, 1965 · N2589U · Substantial damage NTSB NYC66A0066Accident · 1 fatalClosedPiper PA-28 · Reading, PADec 13, 1965 · N8911T · Destroyed NTSB NYC66A0064Accident · 2 fatalClosedMaule M-4 · Windber, PADec 4, 1965 · N4719T · Destroyed NTSB NYC66F0410Accident · No injuriesClosedAero Cmdr 680-E · Philadelphia, PADec 3, 1965 · N9375R · Substantial damage NTSB NYC66D0364Accident · No injuriesClosedBeechcraft A-23 · Doylestown, PANov 28, 1965 · N3552R · Substantial damage NTSB NYC66D0362Accident · No injuriesClosedPiper PA-28 · Langhorne, PANov 23, 1965 · N6523W · Substantial damage NTSB NYC66F0363Accident · No injuriesClosedNavion A · Morrisville, PANov 21, 1965 · N4047K · Substantial damage NTSB NYC66D0383Accident · No injuriesClosedCessna 210E · New Cumberland, PANov 21, 1965 · N4900U · Substantial damage NTSB NYC66F0392Accident · Serious injuriesClosedCessna 190 · Latrobe, PANov 20, 1965 · N1598D · Destroyed NTSB NYC66D0355Accident · No injuriesClosedStinson 108-1 · Mechanicsburg, PANov 20, 1965 · N8535K · Substantial damage NTSB NYC66F0353Accident · No injuriesClosedCessna 182 · Kutztown, PANov 16, 1965 · N2432R · Substantial damage NTSB NYC66D0352Accident · No injuriesClosedPiper PA-28 · Mt Pocono, PANov 14, 1965 · N8751W · Substantial damage NTSB NYC66A0053Accident · Serious injuriesClosedDouglas DC-3 · Coraopolis, PANov 9, 1965 · N52 · Destroyed NTSB NYC66D0346Accident · No injuriesClosedMooney M20C · Kane, PANov 8, 1965 · N6672R · Substantial damage NTSB NYC66F0326Accident · No injuriesClosedStearman Hamond · Honesdale, PANov 7, 1965 · N15525 · Substantial damage NTSB NYC66D0335Accident · No injuriesClosedCessna 175 · Lewiston, PANov 1, 1965 · N7531M · Substantial damage NTSB NYC66F0393Accident · No injuriesClosedPiper PA-24 · West Mifflin, PAOct 31, 1965 · N5276P · Substantial damage NTSB NYC66F0376Accident · No injuriesClosedBellanca 14-13 · Somerset, PAOct 31, 1965 · N74392 · Substantial damage NTSB NYC66F0347Accident · No injuriesClosedPiper PA24 · Lock Haven, PAOct 31, 1965 · N8317P · Substantial damage NTSB NYC66D0345Accident · No injuriesClosedPiper PA-22 · Butler, PAOct 17, 1965 · N4318A · 2 aircraft · Substantial damage NTSB NYC66F0289Accident · No injuriesClosedCessna 150 · West Chester, PAOct 16, 1965 · N5633E · Substantial damage