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 NYC75AN041Accident · 1 fatalClosedBeech B23 · Collegeville, PAOct 1, 1974 · N6118N · Destroyed NTSB NYC75DGM13Accident · No injuriesClosedTaylorcraft DCO-65 · Jamestown, PASep 30, 1974 · N46111 · Substantial damage NTSB NYC75FHD23Accident · No injuriesClosedEnstrom F-28A · Ambler, PASep 29, 1974 · N48801 · Substantial damage NTSB NYC75FHD21Accident · No injuriesClosedCessna 320D · Ambler, PASep 28, 1974 · N4118T · Substantial damage NTSB NYC75DHA16Accident · No injuriesClosedCessna 170B · E Stroudsburg, PASep 27, 1974 · N2978D · Substantial damage NTSB NYC75FGM12Accident · No injuriesClosedCessna 140 · Monroeville, PASep 23, 1974 · N2770N · Substantial damage NTSB NYC75DHD13Incident · No injuriesClosedCessna 182 · N.Philadelphia, PASep 22, 1974 · N3706D · Minor damage NTSB NYC75DHD19Accident · No injuriesClosedMaule M-4 · Coatesville, PASep 21, 1974 · N4737T · Substantial damage NTSB NYC75AN039Accident · 2 fatalClosedCessna 172H · Bluebell, PASep 20, 1974 · N3258L · Destroyed NTSB IAD75AI014Accident · Serious injuriesClosedBritish AC 1-11 · Pittsburgh, PASep 20, 1974 · N1548 · No damage NTSB NYC75FGT08Accident · Minor injuriesClosedBeech A23 · Benton, PASep 15, 1974 · N6090N · Substantial damage NTSB NYC75FGM11Accident · No injuriesClosedPiper PA-22 · West Hickory, PASep 14, 1974 · N9193D · Substantial damage NTSB NYC75FHA14Accident · No injuriesClosedBeech A90 · Reading, PASep 13, 1974 · N312RF · Substantial damage NTSB NYC75DHA15Accident · No injuriesClosedPiper PA-32 · Clarks Summit, PASep 10, 1974 · N56441 · Substantial damage NTSB NYC75FGM10Accident · Minor injuriesClosedCessna 172 · Sharon, PASep 9, 1974 · N3908S · Substantial damage NTSB NYC75AN034Accident · 1 fatalClosedPiper PA-28 · Allentown, PASep 8, 1974 · N40762 · 2 aircraft · Destroyed NTSB NYC75FGM09Accident · Minor injuriesClosedCessna 150H · Ogletown, PASep 1, 1974 · N6680S · Substantial damage NTSB NYC75DHD16Accident · No injuriesClosedCessna 177 · Philadelphia, PASep 1, 1974 · N3434T · Substantial damage NTSB NYC75AN029Accident · 4 fatalClosedPiper PA-24 · Phillipsburg, PASep 1, 1974 · N8363P · Destroyed NTSB NYC75AN012Accident · 1 fatalClosedPiper PA-32 · Somerset, PASep 1, 1974 · N4190W · Destroyed NTSB NYC75DHA12Accident · No injuriesClosedPiper PA-28 · Prospectville, PAAug 29, 1974 · N627FL · Substantial damage NTSB NYC75FHA11Accident · No injuriesClosedCessna 172 · E Stroudsburg, PAAug 25, 1974 · N2463Y · Substantial damage NTSB NYC75AN022Accident · 2 fatalClosedCessna 172 · Catasauqua, PAAug 23, 1974 · N8191L · Destroyed NTSB NYC75FHD14Accident · No injuriesClosedBeech 35 · Toughkenoman, PAAug 21, 1974 · N2956V · Substantial damage NTSB NYC74FGT07Accident · No injuriesClosedBell 47G · Orangeville, PAAug 21, 1974 · N938B · Substantial damage NTSB NYC75FGM07Accident · No injuriesClosedBeech D50E · Pittsburgh, PAAug 18, 1974 · N536D · Substantial damage NTSB NYC75DHA08Accident · No injuriesClosedAero Comdr 500 · Berwick, PAAug 18, 1974 · N999B · Substantial damage NTSB NYC75FGT06Accident · No injuriesClosedGrumman G-73 · Minersville, PAAug 17, 1974 · N168W · Substantial damage NTSB NYC75FGT05Accident · No injuriesClosedBeech A23-24 · Clarance, PAAug 15, 1974 · N9117T · Substantial damage NTSB NYC75FGM06Accident · No injuriesClosedPiper PA-23 · Washington, PAAug 2, 1974 · N2000P · Substantial damage NTSB NYC75FGM05Accident · No injuriesClosedAmer Avco AA5 · Cooperstown, PAAug 2, 1974 · N6024L · Substantial damage NTSB NYC75AN017Accident · No injuriesClosedLear 24 · Shoemakersvlle, PAAug 2, 1974 · N500PP · Substantial damage NTSB NYC75FGM04Accident · No injuriesClosedBell 47G-5 · Sligo, PAAug 1, 1974 · N6277N · Substantial damage NTSB NYC75FHD10Accident · No injuriesClosedEnstrom F-28A · Media, PAJul 31, 1974 · N4890 · Substantial damage NTSB NYC75FHA06Accident · No injuriesClosedPiper PA-34 · Reading, PAJul 31, 1974 · N1040U · Substantial damage NTSB NYC75FHA05Accident · No injuriesClosedPiper PA-32 · Honesdale, PAJul 31, 1974 · N8967N · Substantial damage NTSB NYC75FHA04Accident · No injuriesClosedBeech A23 · Clarks Summit, PAJul 31, 1974 · N8858M · Substantial damage NTSB NYC75FGM03Accident · Minor injuriesClosedCessna 182 · Beaver Falls, PAJul 29, 1974 · N42946 · Substantial damage NTSB NYC74AN014Accident · 1 fatalClosedAeronca 7AC · Roseville, PAJul 28, 1974 · N1842E · Destroyed NTSB NYC75FGM02Accident · No injuriesClosedPiper PA-32 · Sheffield, PAJul 27, 1974 · N8958N · Substantial damage NTSB NYC74AN015Accident · No injuriesClosedPiper PA-32 · Emporium, PAJul 27, 1974 · N4206R · Substantial damage NTSB NYC75FGM01Accident · No injuriesClosedPiper PA-28R · Pittsburgh, PAJul 24, 1974 · N4809T · Substantial damage NTSB NYC75AN011Accident · No injuriesClosedBeech 99 · Middletown, PAJul 23, 1974 · N133AE · Substantial damage NTSB NYC75AN009Accident · No injuriesClosedPiper PA-34 · Philadelphia, PAJul 21, 1974 · N5264T · Substantial damage NTSB NYC75DHD07Accident · No injuriesClosedCessna 172M · Bristol, PAJul 20, 1974 · N20235 · Substantial damage NTSB NYC75FGT03Accident · Minor injuriesClosedBensen B-8-VW · Harrisburg, PAJul 16, 1974 · N1709 · Substantial damage NTSB NYC75DHA03Accident · No injuriesClosedCessna 150 · Gilbertville, PAJul 14, 1974 · N18146 · Substantial damage NTSB NYC75FHA01Accident · No injuriesClosedBell 206B · Allentown, PAJul 11, 1974 · N22JC · Substantial damage NTSB NYC75FHD01Accident · No injuriesClosedCessna 150 · Philadelphia, PAJul 6, 1974 · N6953F · Substantial damage NTSB NYC75FGT02Accident · No injuriesClosedNavion A · Wellsboro, PAJul 4, 1974 · N8883H · Substantial damage