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 NYC75FHD39Accident · No injuriesClosedBeech B55 · Blue Bell, PAMar 24, 1975 · N44AC · Substantial damage NTSB NYC75FHD36Accident · No injuriesClosedCessna 421B · Ambler, PAMar 19, 1975 · N410DC · Substantial damage NTSB NYC75FGT14Accident · No injuriesClosedCessna 150 · University Pk, PAMar 18, 1975 · N904PS · Substantial damage NTSB NYC75FGT13Accident · Minor injuriesClosedPiper PA-28 · Schafferstown, PAMar 16, 1975 · N3544K · Substantial damage NTSB NYC75DHA34Accident · No injuriesClosedPiper PA-28 · Penns Forrest, PAMar 16, 1975 · N6523W · Substantial damage NTSB NYC75DGT16Accident · No injuriesClosedSchleicher KA6 · Lemont, PAMar 15, 1975 · N1771R · Substantial damage NTSB NYC75FGM27Accident · No injuriesClosedPiper PA-24 · Erie, PAMar 13, 1975 · CF-ZKH · Substantial damage NTSB NYC75FHD37Accident · No injuriesClosedEnstrom F-28 · Glenmore, PAMar 5, 1975 · N9559 · Destroyed NTSB NYC75FHD31Accident · No injuriesClosedBeech C35 · West Grove, PAMar 1, 1975 · N5821C · Substantial damage NTSB NYC75DHD14Accident · No injuriesClosedCessna 182J · Philadelphia, PAMar 1, 1975 · N3309F · Substantial damage NTSB NYC75FGM26Accident · No injuriesClosedCessna 182J · Zelienople, PAFeb 28, 1975 · N3393F · Substantial damage NTSB NYC75FGM25Accident · Minor injuriesClosedEnstrom F28A · Erie, PAFeb 24, 1975 · N246Q · Substantial damage NTSB NYC75FGT12Accident · No injuriesClosedEnstrom F-28A · Montoursville, PAFeb 22, 1975 · N9567 · Substantial damage NTSB NYC75DHA32Accident · No injuriesClosedCessna 182 · Collegville, PAFeb 22, 1975 · N2654F · Substantial damage NTSB NYC75FGM24Accident · No injuriesClosedPiper PA-28 · Johnstown, PAFeb 20, 1975 · N5009T · Substantial damage NTSB NYC75DGT18Accident · No injuriesClosedCessna 150L · Thomasville, PAFeb 20, 1975 · N16074 · Substantial damage NTSB NYC75FGM23Accident · No injuriesClosedCessna 150 · Pittsburgh, PAFeb 13, 1975 · N7451G · Substantial damage NTSB NYC75DGT11Accident · No injuriesClosedCessna 182 · Morris, PAJan 24, 1975 · N52808 · Substantial damage NTSB NYC75FHA28Accident · No injuriesClosedEnstrom F-28A · New Hope, PAJan 19, 1975 · N9238 · Substantial damage NTSB NYC75FGM22Accident · No injuriesClosedCessna 320 · Washington, PAJan 17, 1975 · N5716X · Substantial damage NTSB NYC75FGT10Accident · No injuriesClosedPiper PA-24 · Frackville, PADec 31, 1974 · N5197P · Substantial damage NTSB NYC75DHA26Accident · No injuriesClosedStinson 108-1 · Spring City, PADec 31, 1974 · N8854K · Substantial damage NTSB NYC75AN078Accident · 2 fatalClosedPiper PA-32 · Fairchance, PADec 30, 1974 · N32264 · Destroyed NTSB NYC75DHD28Accident · No injuriesClosedPiper PA-32 · West Chester, PADec 26, 1974 · N56982 · Substantial damage NTSB NYC75FHD27Accident · Minor injuriesClosedErco 415-C · West Chester, PADec 23, 1974 · N99907 · Substantial damage NTSB NYC75DHA24Accident · No injuriesClosedCessna 150 · Honesdale, PADec 18, 1974 · N4593U · Substantial damage NTSB NYC75AN074Accident · 3 fatalClosedCessna 172 · Philipsburg, PADec 12, 1974 · N5868A · Destroyed NTSB NYC75IN073Incident · No injuriesClosedBeech G18S · Philadelphia, PADec 10, 1974 · N730M · Minor damage NTSB NYC75FHA23Accident · No injuriesClosedPiper PA-23 · Forty Fort, PADec 3, 1974 · N1071D · Substantial damage NTSB NYC75AN071Accident · No injuriesClosedCessna 402B · Meadville, PADec 3, 1974 · N8203P · Substantial damage NTSB NYC75AN069Accident · 4 fatalClosedCessna 182 · Erie, PANov 28, 1974 · N2433X · Destroyed NTSB NYC75DHA22Accident · No injuriesClosedPiper PA-28 · Queen City, PANov 24, 1974 · N2438R · Substantial damage NTSB NYC75FGM21Accident · Minor injuriesClosedPiper PA-34 · Edensburg, PANov 23, 1974 · N15260 · Destroyed NTSB NYC75FGM19Accident · No injuriesClosedNavion A · Martinsburg, PANov 17, 1974 · N4505K · Substantial damage NTSB NYC75FGM18Accident · No injuriesClosedPiper PA-28 · Franklin, PANov 16, 1974 · N55458 · Substantial damage NTSB NYC75AN062Accident · No injuriesClosedPiper PA-23 · Philadelphia, PANov 15, 1974 · N40254 · Substantial damage NTSB NYC75DHD12Accident · No injuriesClosedChampion 7GCAA · West Chester, PANov 9, 1974 · N86647 · Substantial damage NTSB NYC75FGM17Accident · No injuriesClosedBeech A23A · Meyersdale, PANov 3, 1974 · N7936L · Substantial damage NTSB NYC75FHA20Accident · No injuriesClosedPiper PA-24 · Reading, PAOct 29, 1974 · N9056P · Substantial damage NTSB NYC75FGM16Accident · Minor injuriesClosedCessna 210 · Johnstown, PAOct 28, 1974 · N7320E · Substantial damage NTSB NYC75FGT09Accident · No injuriesClosedBeech E18S · Mcsherrytown, PAOct 27, 1974 · N3666G · Substantial damage NTSB NYC75FGM15Accident · Minor injuriesClosedBrantly B-2B · Sharon, PAOct 26, 1974 · N2280U · Substantial damage NTSB NYC75FGM14Accident · No injuriesClosedBeech 65 · Clarion, PAOct 19, 1974 · N836U · Substantial damage NTSB NYC74AN050Accident · 1 fatalClosedPiper PA-28 · Montgomeryvl, PAOct 18, 1974 · N4825L · Destroyed NTSB NYC75AN049Accident · No injuriesClosedPiper PA-23 · Clarion, PAOct 15, 1974 · N40217 · Substantial damage NTSB NYC75AN046Accident · 1 fatalClosedN.American F-51D · Chatham, PAOct 13, 1974 · N5412V · Destroyed NTSB NYC75FHA19Accident · No injuriesClosedStinson 108-1 · Berwick, PAOct 11, 1974 · N8904K · Substantial damage NTSB NYC75AN043Accident · Minor injuriesClosedPiper PA-31 · Shartlesville, PAOct 7, 1974 · N61454 · Substantial damage NTSB NYC75FHA17Accident · No injuriesClosedCessna 150 · Slatington, PAOct 6, 1974 · N6594T · Substantial damage NTSB NYC75FHA18Accident · Serious injuriesClosedCessna 180 · Hazelton, PAOct 5, 1974 · N55RC · Substantial damage