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 NYC76AN097Accident · 1 fatalClosedCessna 172 · Marklesburg, PAMay 19, 1976 · N56F · Destroyed NTSB NYC76FHA33Accident · No injuriesClosedLuscombe 8A · Skippack, PAMay 17, 1976 · N77832 · Substantial damage NTSB NYC76FHA31Accident · Minor injuriesClosedCessna 172K · Ashfield, PAMay 16, 1976 · N46428 · Substantial damage NTSB NYC76FGM33Accident · No injuriesClosedCessna 172 · Butler, PAMay 14, 1976 · N84225 · Substantial damage NTSB NYC76FHA30Accident · Minor injuriesClosedCessna 182B · Portland, PAMay 11, 1976 · N7241E · Substantial damage NTSB NYC76FHA29Accident · No injuriesClosedEnstrom F-28A · Coopersburg, PAMay 8, 1976 · N290Q · Substantial damage NTSB NYC76FGT23Accident · No injuriesClosedSchweizer SGS126 · Monterey, PAMay 8, 1976 · N8653R · Substantial damage NTSB NYC76FGM32Accident · No injuriesClosedCessna 175 · Butler, PAMay 4, 1976 · N7133M · Substantial damage NTSB NYC76AN094Accident · 3 fatalClosedCessna 182 · Hilltown, PAMay 1, 1976 · N52903 · Destroyed NTSB NYC76FHA27Accident · Minor injuriesClosedCessna 172F · Lehighton, PAApr 28, 1976 · N8893U · Substantial damage NTSB NYC76DHD27Accident · No injuriesClosedPitts S-1C · Bristol, PAApr 19, 1976 · N1EY · Substantial damage NTSB NYC76FHA26Accident · Minor injuriesClosedCessna 150 · Bushkill, PAApr 17, 1976 · N60445 · Substantial damage NTSB NYC76DHA25Accident · No injuriesClosedPiper PA-24 · Clark Summit, PAApr 16, 1976 · N7696P · Substantial damage NTSB NYC76FHA24Accident · No injuriesClosedHelio Acft HST550 · Gilbertsville, PAApr 10, 1976 · N9550A · Substantial damage NTSB NYC76FGM31Accident · No injuriesClosedTaylorcraft BL-12 · Waynesburg, PAApr 4, 1976 · N36159 · Substantial damage NTSB NYC76FGM30Accident · No injuriesClosedCessna 150B · Mt Pleasant, PAMar 28, 1976 · N6221Y · Substantial damage NTSB NYC76FGT18Accident · Serious injuriesClosedVolksplane JP-1 · New Cumberland, PAMar 26, 1976 · N2063 · Substantial damage NTSB NYC76DGM29Accident · No injuriesClosedPiper PA-28 · Greenville, PAMar 26, 1976 · N203CB · Substantial damage NTSB NYC76FGT19Accident · No injuriesClosedCessna T210L · Gaines, PAMar 21, 1976 · N60636 · Substantial damage NTSB NYC76FGM28Accident · Minor injuriesClosedCougar SBS · Uniontown, PAMar 15, 1976 · N26010 · Substantial damage NTSB NYC76FHA22Accident · No injuriesClosedCessna 310 · Allentown, PAMar 12, 1976 · N6715T · Substantial damage NTSB NYC76FGM27Accident · No injuriesClosedGrum Amer AA-5 · Central City, PAMar 7, 1976 · N5847L · Substantial damage NTSB NYC76AN085Accident · 1 fatalClosedAero Comdr 560E · Reading, PAMar 4, 1976 · N3842C · Destroyed NTSB NYC76FGM26Accident · No injuriesClosedCessna 170 · Zelienople, PAFeb 29, 1976 · N3976V · Substantial damage NTSB NYC76DHD18Accident · No injuriesClosedCessna 172M · Atglen, PAFeb 26, 1976 · N4467R · Substantial damage NTSB NYC76FGM25Accident · No injuriesClosedCessna T310Q · Erie, PAFeb 25, 1976 · N5455X · Substantial damage NTSB NYC76AN082Accident · 1 fatalClosedCessna 150 · Frackville, PAFeb 22, 1976 · N19165 · Destroyed NTSB NYC76FHM20Accident · No injuriesClosedSikorsky S-51 · Perkasie, PAFeb 20, 1976 · N92868 · Substantial damage NTSB NYC76AN081Accident · 1 fatalClosedPiper PA-18A · Summerdale, PAFeb 18, 1976 · N6970D · Destroyed NTSB NYC76AN079Accident · 1 fatalClosedTaylorcraft BC12-D · Minorsville, PAFeb 16, 1976 · N43435 · Destroyed NTSB NYC76FGT15Accident · No injuriesClosedCessna 210 · New Cumberland, PAFeb 12, 1976 · N5975F · Substantial damage NTSB NYC76AN075Accident · 1 fatalClosedPiper PA-28 · Allentown, PAFeb 10, 1976 · N7844C · Destroyed NTSB NYC76FGT14Accident · No injuriesClosedCessna 172M · Myerstown, PAFeb 4, 1976 · N13600 · Substantial damage NTSB NYC76AN072Accident · No injuriesClosedBeech E18S · Erie, PAJan 30, 1976 · N43T · Substantial damage NTSB NYC76DGM23Accident · No injuriesClosedPiper PA-28 · Beaver Falls, PAJan 22, 1976 · N4489X · Substantial damage NTSB NYC76DGM22Accident · No injuriesClosedSwearingen SA26AT · Indiana, PAJan 22, 1976 · N97D · Substantial damage NTSB NYC76DGM21Accident · No injuriesClosedCessna 172 · Titusville, PAJan 16, 1976 · N4293Q · Substantial damage NTSB NYC76IN064Incident · No injuriesClosedIsrael Ind 1121B · Erie, PAJan 13, 1976 · N84 · Minor damage NTSB NYC76FGM20Accident · No injuriesClosedPiper PA-28 · Indiana, PAJan 6, 1976 · N4561R · Substantial damage NTSB NYC76DHD15Accident · No injuriesClosedCessna 150L · West Chester, PADec 28, 1975 · N1240Q · 2 aircraft · Substantial damage NTSB NYC76AN060Accident · 1 fatalClosedBeech D18S · Bloserville, PADec 24, 1975 · N91A · Destroyed NTSB NYC76AN059Accident · Serious injuriesClosedBeech C55 · Doylestown, PADec 23, 1975 · N236WC · Destroyed NTSB NYC76DHD07Accident · No injuriesClosedCessna 150 · West Chester, PADec 20, 1975 · N1410Q · Substantial damage NTSB NYC76FGM14Accident · Minor injuriesClosedPiper PA-28R · Greenville, PADec 18, 1975 · N2766R · Substantial damage NTSB NYC76AN055Accident · 1 fatalClosedPiper PA-28R · Erie, PADec 14, 1975 · N393HP · Destroyed NTSB NYC76FHD14Accident · Minor injuriesClosedPiper PA-32 · Kennett Square, PADec 13, 1975 · N4005R · Destroyed NTSB NYC76FGM19Accident · No injuriesClosedBeech S35 · Meadville, PADec 11, 1975 · N239S · Substantial damage NTSB NYC76DGM18Accident · No injuriesClosedStinson 108 · Listonburg, PADec 6, 1975 · N8212K · Substantial damage NTSB NYC76DGM17Accident · No injuriesClosedFunk B75L · Slippery Rock, PADec 5, 1975 · N22683 · Substantial damage NTSB NYC76FHA18Accident · Minor injuriesClosedPiper PA-28 · Avoca, PADec 3, 1975 · N5140L · Substantial damage