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 NYC79DA041Accident · No injuriesClosedBoeing 727 · Philadelphia, PAApr 19, 1979 · N6821 · Substantial damage NTSB NYC79FGM22Accident · 2 fatalClosedPiper PA-22 · Monroeville, PAApr 7, 1979 · N5720D · Destroyed NTSB NYC79FGM20Accident · No injuriesClosedPiper PA-32 · Connellsville, PAApr 6, 1979 · N36473 · Substantial damage NTSB NYC79FA036Accident · 4 fatalClosedBell 206B · Sipesville, PAApr 4, 1979 · N70RB · Destroyed NTSB NYC79FA034Accident · 2 fatalClosedPiper PA-34 · Philadelphia, PAApr 3, 1979 · N6211J · Destroyed NTSB NYC79FGT12Accident · No injuriesClosedCessna 172 · New Cumberland, PAMar 28, 1979 · N5413R · Substantial damage NTSB NYC79FGM19Accident · No injuriesClosedPiper PA-32 · New Castle, PAMar 20, 1979 · N56953 · Substantial damage NTSB NYC79DGT11Accident · No injuriesClosedPiccard AX6 · Huntsdale, PAMar 17, 1979 · N62US · Destroyed NTSB NYC79FA028Accident · 4 fatalClosedPiper PA-28R · Palmerton, PAMar 4, 1979 · N5964V · Destroyed NTSB NYC79FGT10Accident · No injuriesClosedNavion A · New Cumberland, PAFeb 25, 1979 · N91701 · Substantial damage NTSB NYC79FGM17Accident · No injuriesClosedCessna 310R · Latrobe, PAFeb 25, 1979 · N3597G · Substantial damage NTSB NYC79FGM18Accident · No injuriesClosedBeech E18S · Latrobe, PAFeb 23, 1979 · N342T · Substantial damage NTSB NYC79FGT09Accident · No injuriesClosedCessna 170 · Bloserville, PAFeb 22, 1979 · N4220V · Substantial damage NTSB NYC79FHA10Accident · No injuriesClosedCessna 152 · Slatington, PAFeb 18, 1979 · N49080 · Substantial damage NTSB NYC79FGM16Accident · No injuriesClosedSwearingen SA26AT · Butler, PAFeb 12, 1979 · N52LF · Substantial damage NTSB NYC79FGM15Accident · No injuriesClosedCessna 150 · Belle Vernon, PAFeb 11, 1979 · N9377U · Substantial damage NTSB NYC79FGM14Accident · No injuriesClosedBeech 58 · Beaver Falls, PAFeb 7, 1979 · N15BB · Substantial damage NTSB NYC79FGM11Accident · No injuriesClosedMooney M20F · Butler, PAFeb 3, 1979 · N9261V · Substantial damage NTSB NYC79FGM12Accident · No injuriesClosedCessna 152 · Latrobe, PAFeb 2, 1979 · N24956 · Substantial damage NTSB NYC79FA023Accident · Serious injuriesClosedBeech C45 · Reading, PAJan 31, 1979 · N346V · Substantial damage NTSB NYC79FGM10Accident · No injuriesClosedCessna 310L · Washington, PAJan 26, 1979 · N3335X · Substantial damage NTSB NYC79FA021Accident · No injuriesClosedBeech H18 · Pittsburgh, PAJan 25, 1979 · N135W · Substantial damage NTSB NYC79FGM09Accident · No injuriesClosedBeech BE-58 · Beaver Falls, PAJan 20, 1979 · N15BB · Substantial damage NTSB NYC79FA030Accident · 2 fatalClosedGrum Amer AA-1B · Milroy, PAJan 5, 1979 · N6536L · Destroyed NTSB NYC79FGT08Accident · No injuriesClosedN.American NAVI0N · Chambersburg, PAJan 3, 1979 · N8704H · Substantial damage NTSB NYC79DHA07Accident · No injuriesClosedAerostar 601P · Reading, PAJan 1, 1979 · N90521 · Substantial damage NTSB NYC79FGM13Accident · No injuriesClosedGrum Amer AA-5A · Somerset, PADec 28, 1978 · N26078 · Substantial damage NTSB NYC79FHA06Accident · No injuriesClosedSchweizer 2-33A · Kutztown, PADec 23, 1978 · N2056T · Substantial damage NTSB NYC79FGM08Accident · Minor injuriesClosedEnstrom F28A · Washington, PADec 16, 1978 · N289Q · Substantial damage NTSB NYC79FGT07Accident · No injuriesClosedBeech C45H · Philipsburg, PADec 13, 1978 · N702AP · Substantial damage NTSB NYC79DGM07Accident · No injuriesClosedCessna 152 · Tarentum, PADec 13, 1978 · N757MB · Substantial damage NTSB NYC79FA012Accident · 3 fatalClosedCessna 172F · Mcadoo, PANov 23, 1978 · N5170F · Substantial damage NTSB NYC79FGT06Accident · No injuriesClosedPiper PA-28 · Shippensburg, PANov 22, 1978 · N98009 · Substantial damage NTSB NYC79FGT05Accident · No injuriesClosedPiper 601P · Lock Haven, PANov 17, 1978 · G-BVIP · Substantial damage NTSB NYC79FHA03Accident · No injuriesClosedPiper PA-28 · Prospectville, PANov 15, 1978 · N8706E · Substantial damage NTSB NYC79FGT04Accident · No injuriesClosedPiper PA-23 · Towanda, PANov 7, 1978 · N6159Y · Substantial damage NTSB NYC79FA008Accident · 1 fatalClosedCessna 152 · West Mifflin, PANov 5, 1978 · N25507 · Destroyed NTSB NYC79FGT03Accident · Minor injuriesClosedCessna 182 · New Oxford, PANov 4, 1978 · N21212 · Substantial damage NTSB NYC79FHA04Accident · No injuriesClosedAnderson AK-1 · Warminister, PAOct 30, 1978 · N21W · Substantial damage NTSB NYC79FGM06Accident · No injuriesClosedGreat Lakes Baby · Belle Vernon, PAOct 29, 1978 · N66DP · Substantial damage NTSB NYC79FGM05Accident · No injuriesClosedCessna 337 · Erie, PAOct 29, 1978 · N72389 · Substantial damage NTSB NYC79FA005Accident · 1 fatalClosedPiper PA-28 · Great Bend, PAOct 27, 1978 · N5622W · Destroyed NTSB NYC79FGT02Accident · 1 fatalClosedGyrocopter JW-1 · Smoketown, PAOct 22, 1978 · N4280 · Substantial damage NTSB NYC79FA004Accident · 2 fatalClosedEnstrom F-28A · Bakertown, PAOct 12, 1978 · N257Q · Destroyed NTSB NYC79DHA02Accident · No injuriesClosedPiper PA-28 · Lehighton, PAOct 11, 1978 · N7462R · Substantial damage NTSB NYC79FGM04Accident · No injuriesClosedPiper PA-22 · Franklin, PAOct 9, 1978 · N3209Z · Substantial damage NTSB NYC79FGM03Accident · Serious injuriesClosedExprmntl KR-2 · Belle Vernon, PAOct 9, 1978 · N26JL · Destroyed NTSB NYC79FGM02Accident · Minor injuriesClosedPiper PA-23 · Monroeville, PAOct 4, 1978 · N4862P · Substantial damage NTSB NYC79FGT01Accident · No injuriesClosedCessna 172 · Hanover, PAOct 3, 1978 · N9320H · Substantial damage NTSB NYC79DHA01Accident · No injuriesClosedCessna 150 · Avoca, PAOct 2, 1978 · N6625Y · Substantial damage