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 NYC78FGM54Accident · No injuriesClosedPiper PA-28R · Pittsburgh, PASep 30, 1978 · N1143H · Substantial damage NTSB NYC78DHA40Accident · No injuriesClosedSchweitzer 1-35C · Kutztown, PASep 30, 1978 · N2776H · Substantial damage NTSB NYC78FA099Accident · No injuriesClosedPiper PA-28 · Beaver Falls, PASep 28, 1978 · N43165 · Destroyed NTSB NYC79FGM01Accident · Minor injuriesClosedDuster BU-18 · Eighty Four, PASep 23, 1978 · N12DQ · Substantial damage NTSB NYC78FHA37Accident · 1 fatalClosedSoneria II · Pipersville, PASep 23, 1978 · N81915 · Substantial damage NTSB NYC78DHA36Accident · No injuriesClosedBeech 23 · Warrington, PASep 23, 1978 · N23987 · Substantial damage NTSB NYC78FGM52Accident · Minor injuriesClosedPiper J-3 · Somerset, PASep 22, 1978 · N6720H · Substantial damage NTSB NYC78FHA38Accident · No injuriesClosedCessna 206 · Prospectville, PASep 21, 1978 · N1872N · Substantial damage NTSB NYC78FHA34Accident · No injuriesClosedStearman PT-17 · Pottstown, PASep 17, 1978 · N46Y · Substantial damage NTSB NYC78FGM51Accident · Serious injuriesClosedAeronca 7HC · Bridgeville, PASep 17, 1978 · N9845Y · Destroyed NTSB NYC78FA094Accident · 1 fatalClosedCessna 182 · Dupont, PASep 15, 1978 · N9237G · Substantial damage NTSB NYC78FA090Accident · 2 fatalClosedPiper PA-32 · Honesdale, PASep 10, 1978 · N789CC · Destroyed NTSB NYC78FA088Accident · No injuriesClosedHughes 269C · Derry, PASep 4, 1978 · N7466F · Substantial damage NTSB NYC78FGT16Accident · No injuriesClosedBeech F35 · White Pine, PASep 2, 1978 · N5023B · Substantial damage NTSB NYC78FGM50Accident · No injuriesClosedCessna 175B · Conneaut, PASep 2, 1978 · N8226T · Substantial damage NTSB NYC78FGM49Accident · Serious injuriesClosedSchweizer 2-33 · Freeport, PASep 2, 1978 · N33941 · Substantial damage NTSB NYC78FGT17Accident · No injuriesClosedLake 4-200 · Sunbury, PASep 1, 1978 · N62032 · Substantial damage NTSB NYC78FGM48Accident · No injuriesClosedPiper PA-28 · Grove City, PAAug 31, 1978 · N669FL · Substantial damage NTSB NYC78FGT14Accident · No injuriesClosedCessna 172 · Hershey, PAAug 29, 1978 · N833G · Substantial damage NTSB NYC78FGM47Accident · No injuriesClosedGrum Amer AA1-B · Mckeesport, PAAug 27, 1978 · N1480R · Substantial damage NTSB NYC78FA086Accident · No injuriesClosedCessna 150 · Duncannon, PAAug 27, 1978 · N714CR · Substantial damage NTSB NYC78FGT15Accident · No injuriesClosedGrum Amer AA-5B · Marietta, PAAug 26, 1978 · N1519R · Substantial damage NTSB NYC78FGT13Accident · Minor injuriesClosedPiper PA-28 · Thomasville, PAAug 21, 1978 · N652FL · Destroyed NTSB NYC78FGM45Accident · No injuriesClosedCessna 150 · Franklin, PAAug 17, 1978 · N10687 · Substantial damage NTSB NYC78FGM44Accident · Serious injuriesClosedCessna 337 · Cutty, PAAug 16, 1978 · N1146M · Substantial damage NTSB NYC78FGT12Accident · No injuriesClosedPiper PA-28 · Schaefferstown, PAAug 10, 1978 · N575V · Substantial damage NTSB NYC78DHA32Accident · No injuriesClosedPiper PA-28 · Pottstown, PAAug 1, 1978 · N8669C · Substantial damage NTSB NYC78DHA31Accident · Minor injuriesClosedSchweizer 233 · Hilltown, PAJul 30, 1978 · N2467W · Substantial damage NTSB NYC78FGM43Accident · Serious injuriesClosedHughes 269C · Latrobe, PAJul 29, 1978 · N58170 · Substantial damage NTSB NYC78FA072Incident · No injuriesClosedNord 262-A · Philadelphia, PAJul 25, 1978 · N26225 · Minor damage NTSB NYC78FGM42Accident · Serious injuriesClosedPiper PA-28 · Altoona, PAJul 24, 1978 · N41310 · Destroyed NTSB NYC78FGM40Accident · Minor injuriesClosedCessna 180 · Freedom, PAJul 15, 1978 · N9227C · Destroyed NTSB NYC78FA070Accident · 1 fatalClosedPiper PA-22 · Huntingdon, PAJul 14, 1978 · N2393P · Destroyed NTSB NYC79FHD20Accident · Minor injuriesClosedStearman A75N1 · Oxford, PAJul 12, 1978 · N49680 · Destroyed NTSB NYC78FGM38Accident · No injuriesClosedPiper PA-24 · Port Allegany, PAJul 9, 1978 · N6366P · Substantial damage NTSB NYC78FGT11Accident · No injuriesClosedVari-Eze 1 · Lewisberry, PAJul 7, 1978 · N886 · Substantial damage NTSB NYC78FGM41Accident · No injuriesClosedAero Comdr 500S · Beaver Falls, PAJul 7, 1978 · N280MB · Substantial damage NTSB NYC78FGM39Accident · No injuriesClosedBeech N35 · Meadville, PAJul 6, 1978 · N9373Y · Substantial damage NTSB NYC78FGT10Accident · Serious injuriesClosedSikorsky S58DT · Harrisburg, PAJun 28, 1978 · N90940 · Substantial damage NTSB NYC78DHA29Accident · Minor injuriesClosedBeech A23 · New Hanover, PAJun 25, 1978 · N1453L · Substantial damage NTSB NYC78FA067Accident · 5 fatalClosedCessna 402 · Pottstown, PAJun 22, 1978 · N8283F · Destroyed NTSB NYC78FGM36Accident · No injuriesClosedPiper PA-23 · Coraopolis, PAJun 18, 1978 · N2033P · Substantial damage NTSB NYC78FHD15Accident · Minor injuriesClosedPiper PA-28 · Bristol, PAJun 16, 1978 · N75040 · Destroyed NTSB NYC78FHA27Accident · No injuriesClosedEnstrom F-28A · Ft Washington, PAJun 15, 1978 · N9569 · Substantial damage NTSB NYC78FGT09Accident · Minor injuriesClosedBeech A23 · State College, PAJun 15, 1978 · N3521R · Substantial damage NTSB NYC78FGM35Accident · No injuriesClosedBeech A24R · W.Mifflin, PAJun 10, 1978 · N9776L · Substantial damage NTSB NYC78FGM33Accident · No injuriesClosedHughes 269B · Latrobe, PAMay 30, 1978 · N19BL · Substantial damage NTSB NYC78DGM32Accident · No injuriesClosedKr-2 · Clarion, PAMay 30, 1978 · N54495 · Substantial damage NTSB NYC78FGM34Accident · No injuriesClosedCessna 172 · Erie, PAMay 29, 1978 · N737NZ · Substantial damage NTSB NYC78FA060Accident · 1 fatalClosedPiper PA-28 · Tannersville, PAMay 27, 1978 · N9041 · Substantial damage