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 NYC80FA032Accident · Serious injuriesClosedDouglas DC-9 · Southeast, PAApr 4, 1980 · N8922E · No damage NTSB NYC80FA030Accident · 1 fatalClosedCessna 150 · Pa Furnace, PAMar 27, 1980 · N6170K · Destroyed NTSB NYC80FA029Accident · 1 fatalClosedBell 47G-5A · Fayetteville, PAMar 27, 1980 · N58133 · Destroyed NTSB NYC80FA028Accident · 2 fatalClosedPiper PA-24 · East Freedom, PAMar 17, 1980 · N9226P · Destroyed NTSB NYC80FGM14Accident · No injuriesClosedCessna 150G · Marianna, PAMar 16, 1980 · N8433J · Substantial damage NTSB NYC80FGT08Accident · Serious injuriesClosedBeech P35 · York, PAMar 15, 1980 · N1765G · No damage NTSB NYC80FHA08Accident · No injuriesClosedBeech D50 · Avoca, PAMar 6, 1980 · N632Z · Substantial damage NTSB NYC80FGT07Accident · No injuriesClosedCessna 120 · Lititz, PAMar 4, 1980 · N1885N · Substantial damage NTSB NYC80FGM12Accident · No injuriesClosedPiper PA-30 · Waynesburg, PAMar 3, 1980 · N7315Y · Substantial damage NTSB NYC80FGT06Accident · No injuriesClosedCessna 150M · Thomasville, PAFeb 27, 1980 · N704HV · Substantial damage NTSB NYC80FHA07Accident · No injuriesClosedPiper PA-38 · Prospectiville, PAFeb 23, 1980 · N2499D · Substantial damage NTSB NYC80DHA06Accident · No injuriesClosedPiper PA-28 · Mount Pocono, PAFeb 17, 1980 · N2902S · Substantial damage NTSB NYC80FGT05Accident · No injuriesClosedCessna 175 · East Berlin, PAFeb 8, 1980 · N6585E · Substantial damage NTSB NYC80FA022Accident · 1 fatalClosedCessna 152 · Indian Head, PAJan 29, 1980 · N68326 · Substantial damage NTSB NYC80FGM10Accident · No injuriesClosedCessna 150M · Waynesburg, PAJan 26, 1980 · N704ST · Substantial damage NTSB NYC80DHA04Accident · No injuriesClosedPiper PA-38 · Easton, PAJan 21, 1980 · N2559C · Substantial damage NTSB NYC80DHA03Accident · No injuriesClosedCessna 172N · Reading, PAJan 6, 1980 · N5593E · Substantial damage NTSB NYC80FGM09Accident · No injuriesClosedCessna 140 · Butler, PADec 15, 1979 · N90035 · Substantial damage NTSB NYC80FGT04Accident · No injuriesClosedCessna 172RG · Camp Hill, PADec 6, 1979 · N6286R · Substantial damage NTSB NYC80FA014Accident · 1 fatalClosedPiper PA-28 · Watsontown, PANov 29, 1979 · N2916Q · Substantial damage NTSB NYC80FA013Accident · Serious injuriesClosedCessna U206G · Springbrook, PANov 26, 1979 · N732HT · Destroyed NTSB NYC80FGM08Accident · No injuriesClosedLake LA4200 · New Castle, PANov 25, 1979 · C-GLOV · Substantial damage NTSB NYC80FGT03Accident · No injuriesClosedPiper PA-28R · Still Creek, PANov 24, 1979 · N4524T · Substantial damage NTSB NYC80FGM07Accident · No injuriesClosedBeech A-23 · Latrobe, PANov 17, 1979 · N6919Q · Substantial damage NTSB NYC80DGT02Accident · No injuriesClosedCessna 172 · Gaines, PANov 15, 1979 · N12912 · Substantial damage NTSB NYC80FGM06Accident · No injuriesClosedCessna C152 · Belle Vernon, PANov 7, 1979 · N757RA · Substantial damage NTSB NYC80FGM05Accident · Minor injuriesClosedCessna 152 · Jeannette, PAOct 30, 1979 · N757FN · Substantial damage NTSB NYC80FGM04Accident · No injuriesClosedCessna TR-182 · Connellsville, PAOct 30, 1979 · N7188C · Substantial damage NTSB NYC80DHD05Accident · No injuriesClosedPiper PA-32 · West Chester, PAOct 29, 1979 · N55476 · Substantial damage NTSB NYC80DHA01Accident · No injuriesClosedBeech 58 · Reading, PAOct 27, 1979 · N6094S · Substantial damage NTSB NYC80FHD04Accident · Minor injuriesClosedAerospatle SA341G · Philadelphia, PAOct 23, 1979 · N119SF · Destroyed NTSB NYC80FGM03Accident · Minor injuriesClosedBeech A23 · Bradford, PAOct 22, 1979 · N8865M · Substantial damage NTSB NYC80FGT01Accident · No injuriesClosedSchweizer SGS135 · Port Matilda, PAOct 14, 1979 · N34182 · Substantial damage NTSB NYC80FA005Accident · 1 fatalClosedPiper PA-31 · Uniontown, PAOct 9, 1979 · N9277Y · Destroyed NTSB NYC80FGM02Accident · No injuriesClosedCessna 152 · Butler, PAOct 6, 1979 · N64932 · Substantial damage NTSB NYC80FGM01Accident · Minor injuriesClosedPiper PA-28 · Connellsville, PAOct 4, 1979 · N3075N · Substantial damage NTSB NYC79FGM48Accident · No injuriesClosedPiper PA-32 · Erie, PASep 24, 1979 · N6838J · Substantial damage NTSB NYC79DHA28Accident · No injuriesClosedCessna 182P · Moscow, PASep 21, 1979 · N52718 · Destroyed NTSB NYC79FGM47Accident · Minor injuriesClosedTeenie 2 · Greenville, PASep 17, 1979 · N7FB · Substantial damage NTSB NYC79FGT21Accident · No injuriesClosedCessna 150 · Atglen, PASep 15, 1979 · N2876V · Substantial damage NTSB NYC79FA098Accident · No injuriesClosedPiper PA-23 · Philadelphia, PASep 14, 1979 · N8017J · Substantial damage NTSB NYC79FA092Accident · 1 fatalClosedBellanca 17-30A · Hanover, PASep 9, 1979 · N102CB · Destroyed NTSB NYC79FHA26Accident · No injuriesClosedBoeing B75N1 · E Stroudsburg, PASep 7, 1979 · N747Q · Substantial damage NTSB NYC79FA090Accident · 3 fatalClosedPiper PA-28 · No.Whitehall, PASep 5, 1979 · N6275W · Destroyed NTSB NYC79FA088Accident · 1 fatalClosedAeronca 7AC · Edinboro, PASep 3, 1979 · N83122 · Destroyed NTSB NYC79DHA25Accident · No injuriesClosedCessna 172F · Brecknock, PASep 3, 1979 · N5689R · Substantial damage NTSB NYC80FA085Accident · 1 fatalClosedBeech 58 · Middletown, PAAug 30, 1979 · N868AF · Destroyed NTSB NYC79FGM46Accident · No injuriesClosedCessna 180 · Erie, PAAug 29, 1979 · N7746A · Substantial damage NTSB NYC79FGM45Accident · No injuriesClosedPiper PA-23 · Connellsville, PAAug 28, 1979 · N2033P · Substantial damage NTSB NYC79FA081Accident · 1 fatalClosedCessna 152 · Kunkletown, PAAug 19, 1979 · N49080 · Destroyed