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 NYC67F0190Accident · No injuriesClosedPiper PA-28 · West Mifflin, PAAug 28, 1966 · N6393W · Substantial damage NTSB NYC67F0247Accident · No injuriesClosedCessna 172B · Annville, PAAug 25, 1966 · N8094X · Substantial damage NTSB NYC67F0241Accident · No injuriesClosedCessna 190 · Liverpool, PAAug 21, 1966 · N1513D · Substantial damage NTSB NYC67D0181Accident · No injuriesClosedCessna 150 · Ambler, PAAug 20, 1966 · N3187X · Substantial damage NTSB NYC67D0333Accident · No injuriesClosedCessna 170 · New Wilmington, PAAug 18, 1966 · N2595V · Substantial damage NTSB NYC67D0159Accident · No injuriesClosedCessna 120 · Mineral Point, PAAug 15, 1966 · N1767N · Substantial damage NTSB NYC67D0183Accident · No injuriesClosedStinson 108-1 · New Cumberland, PAAug 13, 1966 · CF-SJT · Substantial damage NTSB NYC67I0024Incident · No injuriesClosedConvair 880 · Philadelphia, PAAug 10, 1966 · N8816E · Substantial damage NTSB NYC67F0124Accident · No injuriesClosedCessna 337 · Kutztown, PAAug 9, 1966 · N2219X · Substantial damage NTSB NYC67A0040Accident · Serious injuriesClosedBoeing 707123 · Harrisburg, PAAug 9, 1966 · N7504 · No damage NTSB NYC67D0233Accident · No injuriesClosedPiper PA-28 · Waynesburg, PAAug 7, 1966 · N6403R · Substantial damage NTSB NYC67F0169Accident · No injuriesClosedWaco UPF-7 · Centre Hall, PAAug 6, 1966 · N32073 · Substantial damage NTSB NYC67F0096Accident · No injuriesClosedPiper PA-30 · Hershey, PAJul 25, 1966 · N7767Y · Substantial damage NTSB NYC67D0158Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAJul 25, 1966 · N7626Y · Substantial damage NTSB NYC67F0150Accident · Serious injuriesClosedBeech A23 · West Mifflin, PAJul 24, 1966 · N2351W · Destroyed NTSB NYC67F0139Accident · No injuriesClosedPiper PA-12 · Annville, PAJul 24, 1966 · N87809 · Substantial damage NTSB NYC67F0074Accident · No injuriesClosedCessna 172F · Reading, PAJul 24, 1966 · N8691U · Substantial damage NTSB NYC67A0017Accident · 1 fatalClosedCessna 140 · Mt.Bethel, PAJul 23, 1966 · N2412N · Destroyed NTSB NYC67A0016Accident · No injuriesClosedBell 47G2A1 · St.Marys, PAJul 19, 1966 · N73983 · Substantial damage NTSB NYC67A0013Accident · 2 fatalClosedPiper J3C-65 · Clarion, PAJul 15, 1966 · N32916 · Destroyed NTSB NYC67F0058Accident · No injuriesClosedPiper PA-22 · Prospectville, PAJul 12, 1966 · N4736Z · Substantial damage NTSB NYC67D0092Accident · No injuriesClosedBeech F35 · Philadelphia, PAJul 12, 1966 · N3387C · Substantial damage NTSB NYC67F0387Accident · No injuriesClosedCessna 172F · Sharon, PAJul 9, 1966 · N5721R · Substantial damage NTSB NYC67A0008Accident · Serious injuriesClosedBell 47G-4A · Edinboro, PAJul 9, 1966 · N1317X · Substantial damage NTSB NYC67D0160Accident · No injuriesClosedPiper PA-22 · Dubois, PAJul 7, 1966 · N5006Z · Substantial damage NTSB NYC67F0038Accident · No injuriesClosedCessna 182 · Danville, PAJul 6, 1966 · N200R · Substantial damage NTSB NYC67F0060Accident · Minor injuriesClosedLuscombe 8A · Welsh Run, PAJul 5, 1966 · N71666 · Substantial damage NTSB NYC67D0664Accident · No injuriesClosedTaylorcraft BC-12D · Cowansville, PAJul 5, 1966 · N95000 · Substantial damage NTSB NYC67A0004Accident · 2 fatalClosedPine Air Superv · Mt Pocono, PAJul 5, 1966 · N174SV · Destroyed NTSB NYC67F0082Accident · Minor injuriesClosedCessna 180 · Beaver Falls, PAJul 3, 1966 · N3214D · Substantial damage NTSB NYC67F0081Accident · No injuriesClosedMooney 20E · Pittsburgh, PAJul 3, 1966 · N1978Y · Substantial damage NTSB NYC67F0039Accident · No injuriesClosedPiper PA28 · Eagles Mere, PAJul 3, 1966 · N7813W · Substantial damage NTSB NYC67D0179Accident · No injuriesClosedNavion A · Blairsville, PAJun 30, 1966 · N91140 · Substantial damage NTSB NYC67F0043Accident · Minor injuriesClosedChampion 7ECA · Baden, PAJun 29, 1966 · N9562S · Substantial damage NTSB NYC67D0021Accident · No injuriesClosedCessna 150 · Collegeville, PAJun 23, 1966 · N6167T · Substantial damage NTSB NYC67D0044Accident · Minor injuriesClosedLuscombe 8E · Matamoras, PAJun 21, 1966 · N77944 · Substantial damage NTSB NYC66A0155Accident · No injuriesClosedBell 47G2A1 · New Bethlehem, PAJun 21, 1966 · N73983 · Substantial damage NTSB NYC67D0042Accident · No injuriesClosedStinson 108-1 · Monroeville, PAJun 12, 1966 · N8325K · Substantial damage NTSB NYC66A0147Accident · 1 fatalClosedMooney M-18C · Slate Run, PAJun 12, 1966 · N4170 · Destroyed NTSB NYC67D0005Accident · No injuriesClosedCessna 150 · Neffsville, PAJun 8, 1966 · N8806S · Substantial damage NTSB NYC67D0006Accident · No injuriesClosedCessna 150 · Huntingdon, PAJun 5, 1966 · N6806F · Substantial damage NTSB NYC67D0001Accident · No injuriesClosedStinson 108-1 · Mercer, PAJun 5, 1966 · N8995K · Substantial damage NTSB NYC66A0141Accident · Minor injuriesClosedBell 47G · Burnt Cabins, PAJun 4, 1966 · N4228A · Substantial damage NTSB NYC66A0144Accident · No injuriesClosedCessna 210E · Ambler, PAJun 2, 1966 · N4900U · Substantial damage NTSB NYC66F0678Accident · No injuriesClosedCessna 205 · E.Stroudsburg, PAJun 1, 1966 · N8211Z · Substantial damage NTSB NYC66D0710Accident · Minor injuriesClosedBeech A23-19 · Waynesburg, PAMay 31, 1966 · N2368W · Substantial damage NTSB NYC66A0139Accident · Minor injuriesClosedAir-Space 18A · Pittsburgh, PAMay 31, 1966 · N6168S · Substantial damage NTSB NYC66D0708Accident · No injuriesClosedPiper PA28 · Thomasville, PAMay 30, 1966 · N6126W · Substantial damage NTSB NYC66D0689Accident · No injuriesClosedPiper PA-22 · Lakewood, PAMay 29, 1966 · N7132B · Substantial damage NTSB NYC67F0023Accident · No injuriesClosedForney 415C · Northeast, PAMay 28, 1966 · N37113 · Substantial damage