Skip to content

NTSB investigations, PA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC81FHD24Accident · No injuriesClosedEnstrom F-28A · New London, PAMay 17, 1981 · N9608 · Substantial damage NTSB NYC81FGM18Accident · No injuriesClosedCessna 170B · Belle Vernon, PAMay 8, 1981 · N250K · Substantial damage NTSB NYC81DHA11Accident · Minor injuriesClosedCessna 172 · Erwinna, PAMay 3, 1981 · N21294 · Substantial damage NTSB NYC81FHA10Accident · Minor injuriesClosedCessna 150G · Stroudsburg, PAMay 2, 1981 · N4073J · Substantial damage NTSB NYC81FHD21Accident · No injuriesClosedBeech B-35 · New London, PAMay 1, 1981 · N5253C · Substantial damage NTSB NYC81FGM19Accident · No injuriesClosedPiper PA-28 · Clearfield, PAApr 22, 1981 · N2695T · Substantial damage NTSB NYC81FA042Accident · 1 fatalClosedCessna 401A · State College, PAApr 21, 1981 · N6265Q · Destroyed NTSB NYC81FA041Accident · 2 fatalClosedCessna 320 · West Mifflin, PAApr 20, 1981 · N5500E · Destroyed NTSB NYC81FHD19Accident · No injuriesClosedPiper PA-28 · West Chester, PAApr 16, 1981 · N8754E · Substantial damage NTSB NYC81FGM17Accident · No injuriesClosedBeech B19 · Bridgeville, PAApr 12, 1981 · N18888 · Substantial damage NTSB NYC81FGM16Accident · No injuriesClosedCessna 180 · Apollo, PAApr 12, 1981 · N3327D · Substantial damage NTSB NYC81FGM15Accident · No injuriesClosedCessna 172E · Irwin, PAApr 7, 1981 · N5718T · Substantial damage NTSB NYC81FA037Accident · No injuriesClosedPiper J3 · Canton, PAApr 2, 1981 · N21609 · Substantial damage NTSB NYC81FA036Accident · Serious injuriesClosedPiper PA-12 · Leroy Township, PAMar 28, 1981 · N2918M · Substantial damage NTSB NYC81FHD17Accident · No injuriesClosedPiper PA-28 · Bristol, PAMar 27, 1981 · N2876Z · Substantial damage NTSB NYC81DHA07Accident · No injuriesClosedPiper PA-38 · Easton, PAMar 23, 1981 · N2535A · Substantial damage NTSB NYC81FGM13Accident · No injuriesClosedPitts S-1 · Somerset, PAMar 22, 1981 · N70JM · Substantial damage NTSB NYC81FGM14Accident · No injuriesClosedPiper PA-38 · Beaver Falls, PAMar 21, 1981 · N2552D · Substantial damage NTSB NYC81FGM12Accident · No injuriesClosedPiper PA-28R · Indiana, PAMar 15, 1981 · N4957J · Substantial damage NTSB NYC81DHA08Accident · No injuriesClosedCessna 172 · Morgantown, PAMar 14, 1981 · N5721R · Destroyed NTSB NYC81FGT02Accident · Serious injuriesClosedCessna 402B · Bloomsburg, PAMar 11, 1981 · N7888Q · Destroyed NTSB NYC81FA031Accident · Minor injuriesClosedBeech H18 · Hazelton, PAMar 11, 1981 · N161SP · Substantial damage NTSB NYC81FHD13Accident · Minor injuriesClosedCessna 177RG · Philadelphia, PAFeb 25, 1981 · N34144 · Destroyed NTSB NYC81FGM11Accident · No injuriesClosedAeronca 11AC · Elizabeth, PAFeb 15, 1981 · N3769E · Substantial damage NTSB NYC81FA024Accident · Serious injuriesClosedBeech C-45H · Dillsburg, PAFeb 2, 1981 · N45437 · Destroyed NTSB NYC81FGM10Accident · No injuriesClosedAeronca 7EC · Butler, PAJan 25, 1981 · N7578B · Substantial damage NTSB NYC81FA020Accident · Serious injuriesClosedAgusta A109-A · Pittsburgh, PAJan 16, 1981 · N86NR · Destroyed NTSB NYC81IA019Incident · No injuriesClosedPiper PA-32 · Coatesville, PAJan 15, 1981 · N2147N · Minor damage NTSB NYC81FA017Accident · 1 fatalClosedPiper PA-32 · Philadelphia, PADec 28, 1980 · N3694W · Destroyed NTSB NYC81FGM09Accident · No injuriesClosedHiller Acft FH1100 · Somerset, PADec 25, 1980 · N5042F · Substantial damage NTSB NYC81FA012Accident · 3 fatalClosedPiper PA-20 · East Berlin, PANov 26, 1980 · N7453K · Destroyed NTSB NYC81FGM07Accident · No injuriesClosedPiper PA-38 · Grove City, PANov 21, 1980 · N2414F · Substantial damage NTSB NYC81FA010Accident · 1 fatalClosedBeech H18 · Troxelville, PANov 18, 1980 · N701CC · Destroyed NTSB NYC81FGM06Accident · Serious injuriesClosedCherokee RM-A-1 · Eighty Four, PANov 16, 1980 · N481J · Substantial damage NTSB NYC81FGM05Accident · No injuriesClosedCessna 172H · Clarion, PANov 14, 1980 · N2649L · Substantial damage NTSB NYC81FHD08Accident · Minor injuriesClosedEnstrom F-28A · Lima, PANov 11, 1980 · N90775 · Destroyed NTSB NYC81DHA03Accident · No injuriesClosedCessna 172 · Ambler, PANov 6, 1980 · N12178 · Substantial damage NTSB NYC81FGT01Accident · Minor injuriesClosedCessna 150 · Pine Grove Mls, PANov 2, 1980 · N22981 · Substantial damage NTSB NYC81FGM04Accident · Serious injuriesClosedAerosport Quail · Rostraver, PANov 2, 1980 · N9185A · Substantial damage NTSB NYC81FHD06Accident · Serious injuriesClosedCessna 150K · Coatsville, PAOct 30, 1980 · N6040G · Destroyed NTSB NYC81FGM03Accident · No injuriesClosedLuscombe 8A · Belle Vernon, PAOct 27, 1980 · N1190K · Substantial damage NTSB NYC81FGM02Accident · No injuriesClosedCessna 152 · Indiana, PAOct 18, 1980 · N25520 · Substantial damage NTSB NYC81FHA02Accident · No injuriesClosedDornier D0-28 · Scranton, PAOct 15, 1980 · 4X-CFA · Substantial damage NTSB NYC80FGM01Accident · Minor injuriesClosedCessna 177 · Jeannette, PAOct 12, 1980 · N2262Y · Substantial damage NTSB NYC80FGM33Accident · Minor injuriesClosedCessna T210F · Economy Boro, PASep 25, 1980 · N6120R · Substantial damage NTSB NYC80FA091Accident · No injuriesClosedBell 47G-4A · Holbrook, PASep 24, 1980 · N13PL · Destroyed NTSB NYC80DHA32Accident · No injuriesClosedBellanca 17-30 · Pottstown, PASep 20, 1980 · N8863V · Substantial damage NTSB NYC80FA089Accident · 3 fatalClosedPiper PA-22 · Hyner, PASep 18, 1980 · N9527D · Destroyed NTSB NYC80IA086Incident · No injuriesClosedNord 262 · Philadelphia, PASep 16, 1980 · N481A · Minor damage NTSB NYC80FA088Accident · No injuriesClosedPiper PA-28 · Montgomeryvill, PASep 14, 1980 · N5055F · Substantial damage