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 NYC68F0036Accident · Minor injuriesClosedCessna 182B · Newtown, PAJul 4, 1967 · N2754G · Substantial damage NTSB NYC68D0040Accident · No injuriesClosedCessna 140 · Corry, PAJul 4, 1967 · N89338 · Substantial damage NTSB NYC68F0024Accident · Serious injuriesClosedCessna 172 · Kutztown, PAJun 29, 1967 · N9885T · Destroyed NTSB NYC68F0049Accident · No injuriesClosedPiper PA-30 · Selinsgrove, PAJun 28, 1967 · N7412Y · Substantial damage NTSB NYC68F0046Accident · No injuriesClosedPiper PA-22 · Belle Vernon, PAJun 28, 1967 · N2561A · Substantial damage NTSB NYC67A0189Accident · No injuriesClosedBell 47D1 · Williamsburg, PAJun 27, 1967 · N3918A · Substantial damage NTSB NYC68F0051Accident · No injuriesClosedCessna 172 · Snow Shoe, PAJun 25, 1967 · N6909X · Destroyed NTSB NYC68F0047Accident · Minor injuriesClosedStinson 10A · Shippenville, PAJun 25, 1967 · N36707 · Substantial damage NTSB NYC68F0052Accident · No injuriesClosedBeech 23 · Selinsgrove, PAJun 24, 1967 · N2337Q · Substantial damage NTSB NYC68F0026Accident · No injuriesClosedBeech A23 · Kutztown, PAJun 24, 1967 · N5993S · Substantial damage NTSB NYC67A0187Accident · No injuriesClosedBell 47G-2 · Bedford, PAJun 24, 1967 · N6749D · Substantial damage NTSB NYC67A0185Accident · No injuriesClosedBell 47D1 · Pleasantville, PAJun 23, 1967 · N4924C · Substantial damage NTSB DCA67A0009Accident · 34 fatalClosedBritish AC 1-11 · Blossburg, PAJun 23, 1967 · N1116J · Destroyed NTSB NYC68F0041Accident · No injuriesClosedAeronca 11CC · Industry, PAJun 18, 1967 · N4178E · Substantial damage NTSB NYC68F0027Accident · No injuriesClosedCessna 180 · Monroeville, PAJun 18, 1967 · N1717C · Substantial damage NTSB NYC68F0028Accident · No injuriesClosedPiper PA-28 · Belle Vernon, PAJun 15, 1967 · N6613W · Substantial damage NTSB NYC68F0023Accident · Minor injuriesClosedCessna 172 · Central City, PAJun 15, 1967 · N2749U · Substantial damage NTSB NYC67A0177Accident · No injuriesClosedBrantly B-2 · Monroeville, PAJun 11, 1967 · N5948Y · Substantial damage NTSB NYC67D0686Accident · No injuriesClosedPiper PA-28 · Easton, PAJun 10, 1967 · N6691W · Substantial damage NTSB NYC68F0013Accident · No injuriesClosedCessna 182J · Everett, PAJun 8, 1967 · N3524F · Substantial damage NTSB NYC67F0701Accident · No injuriesClosedPiper PA-28 · West Mifflin, PAJun 7, 1967 · N6993W · Substantial damage NTSB NYC67F0702Accident · Minor injuriesClosedLuscombe 8A · Monroeville, PAJun 6, 1967 · N71666 · Substantial damage NTSB NYC68F0014Accident · No injuriesClosedMooney M20C · Sharon, PAJun 4, 1967 · N6808U · Substantial damage NTSB NYC68F0004Accident · No injuriesClosedPiper PA-22 · Indiana, PAJun 4, 1967 · N1780P · Substantial damage NTSB NYC67F0670Accident · Minor injuriesClosedVultee BT13A · Pottstown, PAJun 1, 1967 · N69687 · Substantial damage NTSB NYC67F0669Accident · No injuriesClosedPiper PA-28 · Prospectville, PAMay 31, 1967 · N8136W · Substantial damage NTSB NYC67A0180Accident · No injuriesClosedPiper PA-28 · Warrington, PAMay 30, 1967 · N5399W · Substantial damage NTSB NYC68F0002Accident · Minor injuriesClosedCessna 180 · Clarion, PAMay 29, 1967 · N7807A · Destroyed NTSB NYC67F0692Accident · No injuriesClosedCessna 172 · Cresson, PAMay 25, 1967 · N6670A · Substantial damage NTSB NYC67F0689Accident · No injuriesClosedPiper PA-33 · Lock Haven, PAMay 24, 1967 · N4600Y · Destroyed NTSB NYC67D0690Accident · Minor injuriesClosedCessna 195A · Columbia, PAMay 24, 1967 · N4454C · Substantial damage NTSB NYC67F0648Accident · No injuriesClosedPiper PA-28 · Allentown, PAMay 23, 1967 · N8433W · Substantial damage NTSB NYC68F0003Accident · Serious injuriesClosedSchweizer SGU222 · Butler, PAMay 21, 1967 · N2749Z · Substantial damage NTSB NYC62F0691Accident · No injuriesClosedPiper PA-28 · Johnstown, PAMay 20, 1967 · N6415R · Substantial damage NTSB NYC67A0163Accident · No injuriesClosedBell 47D1 · West Grove, PAMay 17, 1967 · N138B · Substantial damage NTSB NYC67A0162Accident · No injuriesClosedBell 47D1 · Milford Square, PAMay 17, 1967 · N925V · Substantial damage NTSB NYC67F0693Accident · No injuriesClosedMooney M20C · Mckees Rocks, PAMay 15, 1967 · N7168U · Substantial damage NTSB NYC67A0160Accident · Serious injuriesClosedBoeing 727 · Philadelphia, PAMay 15, 1967 · N8144N · No damage NTSB NYC67D0641Accident · No injuriesClosedPiper PA-28 · Hunlock Creek, PAMay 14, 1967 · N7388W · Substantial damage NTSB NYC67D0673Accident · No injuriesClosedPiper PA-28 · Lockhaven, PAMay 13, 1967 · N6506W · Substantial damage NTSB NYC67F0666Accident · No injuriesClosedStinson 108-2 · Matamoras, PAMay 10, 1967 · N9403K · Substantial damage NTSB NYC67F0659Accident · No injuriesClosedCessna 182J · Sayre, PAMay 10, 1967 · N3327F · Substantial damage NTSB NYC67D0647Accident · No injuriesClosedCessna 170 · Corry, PAMay 6, 1967 · N1827C · Substantial damage NTSB NYC67D0640Accident · No injuriesClosedPiper PA-24 · Prospectville, PAMay 5, 1967 · N2172M · Substantial damage NTSB NYC67F0646Accident · No injuriesClosedCessna 182H · West Mifflin, PAMay 2, 1967 · N2034X · Substantial damage NTSB NYC67D0680Accident · No injuriesClosedCessna 150E · Belle Vernon, PAApr 30, 1967 · N3977U · Substantial damage NTSB NYC67A0151Accident · 2 fatalClosedPiper PA-23 · Hershey, PAApr 30, 1967 · N8888 · Destroyed NTSB NYC67F0684Accident · No injuriesClosedPiper PA-22 · New Alexandria, PAApr 29, 1967 · N5725D · Substantial damage NTSB NYC67F0629Accident · No injuriesClosedPiper PA-22 · Gettysburg, PAApr 29, 1967 · N9951D · Substantial damage NTSB NYC67F0628Accident · Minor injuriesClosedCessna 150F · Duncannon, PAApr 29, 1967 · N8716S · Substantial damage