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 NYC79FGM44Accident · Serious injuriesClosedEnstrom F28C · Erie, PAAug 18, 1979 · N573H · Destroyed NTSB NYC79FA079Accident · 1 fatalClosedCessna 172M · Mount Union, PAAug 18, 1979 · N6630H · Destroyed NTSB NYC79FGM42Accident · No injuriesClosedBeech B-24R · Youngsville, PAAug 12, 1979 · N9250S · Substantial damage NTSB NYC79FHA20Accident · No injuriesClosedPiper PA-38 · Prospectville, PAAug 9, 1979 · N9387T · Substantial damage NTSB NYC79DHA24Accident · Minor injuriesClosedCessna 172 · Lederach, PAAug 9, 1979 · N145ML · Substantial damage NTSB NYC79IA072Incident · No injuriesClosedShort Bros SD3-30 · Reading, PAAug 6, 1979 · N724SA · Minor damage NTSB NYC79FHA18Accident · No injuriesClosedCessna 172 · Germansville, PAAug 2, 1979 · N1543Y · Substantial damage NTSB NYC79FGM41Accident · Minor injuriesClosedPitts S1S · Bedford, PAAug 1, 1979 · N8004 · Substantial damage NTSB NYC79FGM39Accident · No injuriesClosedCessna 177RG · Johnstown, PAJul 31, 1979 · N2559V · Substantial damage NTSB NYC79FGM40Accident · No injuriesClosedHughes 300C · Barnesboro, PAJul 30, 1979 · N8641F · Destroyed NTSB NYC79FGM38Accident · Serious injuriesClosedPiper PA-28 · Greensburg, PAJul 30, 1979 · N69EJ · Destroyed NTSB NYC79FA067Accident · 1 fatalClosedLuscombe 8A · Clarion, PAJul 28, 1979 · N1159B · Destroyed NTSB UNK79X0114Accident · Minor injuriesClosedCessna 150 · Willow Grove, PAJul 26, 1979 · N63150 · Destroyed NTSB NYC79FGM37Accident · No injuriesClosedGrum Amer AA-1 · Monroeville, PAJul 22, 1979 · N5908L · Substantial damage NTSB NYC79DA069Incident · No injuriesClosedPiper PA-24 · Pittsburgh, PAJul 19, 1979 · N8250P · No damage NTSB NYC79FGM35Accident · No injuriesClosedCessna 150 · Zelienople, PAJul 17, 1979 · N19138 · Substantial damage NTSB NYC79FA058Accident · 4 fatalClosedPiper PA-28 · Blng Springs, PAJul 15, 1979 · N2216G · Destroyed NTSB NYC79FGT20Accident · Serious injuriesClosedCessna 175 · Hanover, PAJul 14, 1979 · N7260M · Destroyed NTSB NYC79FA057Accident · 2 fatalClosedPiper PA-18S · Shenley, PAJul 14, 1979 · N4399A · Destroyed NTSB NYC79FA056Accident · 2 fatalClosedBell 206B · Philadelphia, PAJul 14, 1979 · N1443W · Destroyed NTSB NYC79FA051Accident · No injuriesClosedPiper PA-32 · Blue Bell, PAJul 12, 1979 · N720JB · Substantial damage NTSB NYC79FGM32Accident · Minor injuriesClosedLuscombe 8A · Albion, PAJul 8, 1979 · N45922 · Substantial damage NTSB NYC79FGM33Accident · No injuriesClosedPiper PA-22 · Zelienople, PAJul 7, 1979 · N9741D · Substantial damage NTSB NYC79FGT19Accident · No injuriesClosedGrumman AA1B · Elizabethtown, PAJul 5, 1979 · N1604R · Substantial damage NTSB NYC79FGM31Accident · No injuriesClosedCessna 152 · West Mifflin, PAJul 3, 1979 · N757VT · Substantial damage NTSB NYC79FHA16Accident · No injuriesClosedCessna 150G · Slatington, PAJul 1, 1979 · N8397J · Substantial damage NTSB NYC79FA051Accident · Minor injuriesClosedBeech C45H · Slatington, PAJun 29, 1979 · N281M · Destroyed NTSB NYC79FGM30Accident · No injuriesClosedCessna 150 · Kittanning, PAJun 27, 1979 · N18077 · Substantial damage NTSB NYC79FHD17Accident · No injuriesClosedCessna 150 · Coatesville, PAJun 24, 1979 · N5826G · Substantial damage NTSB NYC80FGM13Accident · No injuriesClosedPiper PA-38 · Latrobe, PAJun 23, 1979 · N6292A · Substantial damage NTSB NYC79FGT18Accident · Serious injuriesClosedCessna 172 · Shippensburg, PAJun 22, 1979 · N12544 · Substantial damage NTSB NYC79FGT17Accident · Minor injuriesClosedBell 47D-1 · Hanover, PAJun 19, 1979 · N59326 · Substantial damage NTSB NYC79FHA15Accident · Serious injuriesClosedBell 47G-2 · Waupwallopen, PAJun 16, 1979 · N2884B · Substantial damage NTSB NYC79FGM29Accident · No injuriesClosedPiper PA-28 · Erie, PAJun 12, 1979 · N43218 · Substantial damage NTSB NYC79FHA17Accident · No injuriesClosedPiper PA-23 · Prospectville, PAJun 10, 1979 · N62721 · Substantial damage NTSB NYC79FGM28Accident · No injuriesClosedCessna 150 · Waterford, PAMay 31, 1979 · N21974 · Substantial damage NTSB NYC79FHA14Accident · Serious injuriesClosedPiper PA-28 · Berwick, PAMay 22, 1979 · N8730N · Destroyed NTSB NYC79FGM25Accident · No injuriesClosedMooney M20B · Emporium, PAMay 20, 1979 · N74543 · Substantial damage NTSB NYC79FGM23Accident · Serious injuriesClosedPiper PA-32 · Bradford, PAMay 14, 1979 · N4126R · Substantial damage NTSB NYC79FGM27Accident · No injuriesClosedBeech 18S · Beaver Falls, PAMay 11, 1979 · N3787B · Substantial damage NTSB NYC79FGM23Accident · No injuriesClosedPiper PA-22 · Conneaut, PAMay 8, 1979 · N9809D · Substantial damage NTSB NYC79FGM21Accident · No injuriesClosedBeech C23 · Central City, PAMay 7, 1979 · N1996L · Substantial damage NTSB NYC79FGT15Accident · 1 fatalClosedGrumman AA1 · Mountville, PAMay 6, 1979 · N6404L · Substantial damage NTSB NYC79DHA13Accident · Serious injuriesClosedBell 47G · Weatherly, PAMay 6, 1979 · N73979 · Substantial damage NTSB NYC79FA045Accident · 2 fatalClosedBeech C-23 · Saltsburg, PAMay 5, 1979 · N6550R · Substantial damage NTSB NYC79FGM36Accident · No injuriesClosedCessna 150 · Northeast, PAApr 25, 1979 · N6474G · Substantial damage NTSB NYC79DHA12Accident · No injuriesClosedGrumman AA-5B · Easton, PAApr 25, 1979 · N28805 · Substantial damage NTSB NYC79FGT14Accident · No injuriesClosedPiper PA-18 · Lancaster, PAApr 22, 1979 · N331T · Substantial damage NTSB NYC79DHA11Accident · No injuriesClosedAeronca 11AC · Poyntelle, PAApr 22, 1979 · N3295E · Substantial damage NTSB NYC79FGT13Accident · No injuriesClosedCessna 182L · Middletown, PAApr 19, 1979 · N42612 · Substantial damage