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 NYC75AN001Accident · 5 fatalClosedPiper PA-23 · Acme, PAJul 4, 1974 · N5084Y · Destroyed NTSB NYC75FGT01Accident · No injuriesClosedPiper PA-34 · Myerstown, PAJul 3, 1974 · N42866 · Substantial damage NTSB NYC74FGM44Accident · Serious injuriesClosedCessna 172 · Jeannette, PAJun 29, 1974 · N1192M · Destroyed NTSB NYC74FGM43Accident · No injuriesClosedAero Comdr 680FP · W Mifflin, PAJun 28, 1974 · N900L · Substantial damage NTSB NYC74FGM42Accident · Serious injuriesClosedErco 415-D · Bethel Park, PAJun 27, 1974 · N2570H · Destroyed NTSB NYC74FGM41Accident · No injuriesClosedHughes 269B · Berlin, PAJun 24, 1974 · N9390F · Substantial damage NTSB NYC74FGM40Accident · No injuriesClosedBeech 23 · Monroeville, PAJun 20, 1974 · N4018T · Substantial damage NTSB NYC74FHA34Accident · Serious injuriesClosedPiper PA-24 · Andreas, PAJun 18, 1974 · N5236P · Substantial damage NTSB NYC74FGT23Accident · No injuriesClosedCessna 172M · Lewisburg, PAJun 18, 1974 · N12623 · Substantial damage NTSB NYC74FGM39Accident · 1 fatalClosedCessna 150 · Tarentum, PAJun 18, 1974 · N3058S · Destroyed NTSB NYC74AN110Accident · 3 fatalClosedAerostar 600 · Perkasie, PAJun 15, 1974 · N14ES · Destroyed NTSB NYC74AN109Accident · 2 fatalClosedBrantly B-28 · Philadelphia, PAJun 13, 1974 · N2176U · Destroyed NTSB NYC74FGM37Accident · No injuriesClosedPiper PA-12 · Mt Pleasant, PAJun 11, 1974 · N2492M · Substantial damage NTSB NYC74DHA33Accident · No injuriesClosedCessna 180 · Greentown, PAJun 11, 1974 · N2223C · Substantial damage NTSB NYC74FGT22Accident · Minor injuriesClosedCessna 182 · Minersville, PAJun 7, 1974 · N8558T · Substantial damage NTSB NYC74FGT21Accident · No injuriesClosedCessna 170B · Hanover, PAJun 6, 1974 · N3417C · Substantial damage NTSB NYC75DGT20Accident · No injuriesClosedCessna 172 · Mill Creek, PAJun 2, 1974 · N7253Q · Substantial damage NTSB NYC74FGM36Accident · No injuriesClosedGlobe GC-1B · Mt Pleasant, PAJun 1, 1974 · N80956 · Substantial damage NTSB NYC74FGM34Accident · No injuriesClosedCessna 172M · Bradford, PAMay 27, 1974 · N12375 · Substantial damage NTSB NYC74FGM33Accident · No injuriesClosedCessna 150K · Ohiopyle, PAMay 26, 1974 · N5714G · Destroyed NTSB NYC74FGM32Accident · No injuriesClosedCessna 150 · Belle Vernon, PAMay 18, 1974 · N4565U · Substantial damage NTSB NYC74DGM31Accident · No injuriesClosedPiper PA-28 · Johnstown, PAMay 16, 1974 · N6437R · Substantial damage NTSB NYC74FGM30Accident · No injuriesClosedNavion D · West Mifflin, PAMay 15, 1974 · N96Q · Substantial damage NTSB NYC74FGM29Accident · Minor injuriesClosedCessna 210 · Connellsville, PAMay 14, 1974 · N59210 · Substantial damage NTSB IAD74FIA16Accident · No injuriesClosedFlug-Undfah DIA-18 · Latrobe, PAMay 13, 1974 · N1111H · Substantial damage NTSB NYC74IN093Incident · No injuriesClosedBoeing 707 · Philadelphia, PAMay 8, 1974 · N778TW · Minor damage NTSB NYC74FGM28Accident · No injuriesClosedBeech N35 · Butler, PAMay 4, 1974 · N9373Y · Substantial damage NTSB NYC74FGM27Accident · Minor injuriesClosedCessna 182D · Meyersdale, PAMay 2, 1974 · N9118X · Substantial damage NTSB NYC74DHD36Accident · No injuriesClosedAmer Avco AA1-A · Bristol, PAApr 29, 1974 · N9259L · Substantial damage NTSB NYC74DGM26Accident · No injuriesClosedNavion B · Valencia, PAApr 29, 1974 · N300CB · Substantial damage NTSB NYC74FGT19Accident · No injuriesClosedPiper PA-32 · Lock Haven, PAApr 28, 1974 · N1428S · Substantial damage NTSB NYC74FGT18Accident · Minor injuriesClosedForney F-1 · Shippensburg, PAApr 28, 1974 · N3003G · Substantial damage NTSB NYC74DGM35Accident · No injuriesClosedCessna 310I · Belle Vernon, PAApr 27, 1974 · N445V · Substantial damage NTSB NYC74FHA29Accident · No injuriesClosedBoeing E-75 · E Stroudsburg, PAApr 21, 1974 · N33621 · Substantial damage NTSB NYC74FGM25Accident · No injuriesClosedPiper PA-23 · Connelsville, PAApr 19, 1974 · N5209Y · Substantial damage NTSB NYC74AN092Accident · 2 fatalClosedPiper PA-30 · Champion, PAApr 19, 1974 · N7296Y · Destroyed NTSB NYC74DGM24Accident · No injuriesClosedCessna 150 · Williamburg, PAApr 17, 1974 · N6259G · Destroyed NTSB NYC74FGM23Accident · No injuriesClosedCessna 150L · Waynesburg, PAApr 12, 1974 · N1495Q · Substantial damage NTSB NYC74AN079Accident · No injuriesClosedDehavilland DH114 · Philadelphia, PAMar 26, 1974 · N782R · Substantial damage NTSB NYC74FGM22Accident · No injuriesClosedPiper PA-30 · West Mifflin, PAMar 21, 1974 · N8700Y · Substantial damage NTSB NYC74FGM20Accident · No injuriesClosedPiper PA-23 · Meadville, PAMar 16, 1974 · N5676Y · Substantial damage NTSB NYC74FGM21Accident · No injuriesClosedAeronca 65-LA · Mckean, PAMar 15, 1974 · N26331 · Substantial damage NTSB NYC74FGM19Accident · No injuriesClosedAmer Avco AA-5 · Cooperstown, PAMar 12, 1974 · N6019L · Substantial damage NTSB NYC74FHA25Accident · Serious injuriesClosedPiper PA-28 · Pottstown, PAMar 6, 1974 · N732FL · Substantial damage NTSB NYC74FGM18Accident · No injuriesClosedCessna 175A · Delmont, PAFeb 26, 1974 · N7082E · Substantial damage NTSB NYC74DGT17Accident · No injuriesClosedCessna 150 · University Pk, PAFeb 26, 1974 · N1931Z · Substantial damage NTSB NYC74FGM17Accident · No injuriesClosedCessna 150L · Evans City, PAFeb 10, 1974 · N1399Q · Substantial damage NTSB NYC74FGM16Accident · Serious injuriesClosedPiper J3C-65 · Waynesburg, PAFeb 3, 1974 · N88361 · Substantial damage NTSB NYC74AN067Accident · 2 fatalClosedPiper PA-28 · Emlenton, PAJan 28, 1974 · N6481J · Destroyed NTSB NYC74FHA24Accident · No injuriesClosedPiper PA-28 · Birchwood, PAJan 27, 1974 · N9784W · Substantial damage