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 NYC71FGM41Accident · Minor injuriesClosedCessna 182A · Johnstown, PAApr 16, 1971 · N6333B · Substantial damage NTSB NYC71FGM38Accident · No injuriesClosedCessna 150 · West Mifflin, PAApr 13, 1971 · N61038 · Substantial damage NTSB NYC71FHA43Accident · No injuriesClosedPiper PA-28 · Easton, PAApr 11, 1971 · N9787J · Substantial damage NTSB NYC71FGM39Accident · Serious injuriesClosedPiper PA-28 · Bridgeville, PAApr 11, 1971 · N4319J · Substantial damage NTSB NYC71FGT14Accident · No injuriesClosedPiper PA-28 · Towanda, PAApr 10, 1971 · N6751W · Minor damage NTSB NYC71FGM37Accident · No injuriesClosedCessna 150H · Zelienople, PAApr 10, 1971 · N23239 · Substantial damage NTSB NYC71FGT13Accident · Minor injuriesClosedStinson 10-A · Hallam, PAApr 9, 1971 · N32203 · Substantial damage NTSB NYC71DHA42Accident · No injuriesClosedSikorsky S-55 · Tannersville, PAApr 9, 1971 · N1564 · Substantial damage NTSB NYC71FGM36Accident · Serious injuriesClosedBeech B23 · Indiana, PAApr 6, 1971 · N7633R · Substantial damage NTSB NYC71FGT12Accident · Serious injuriesClosedPiper PA-24 · Hesston, PAApr 4, 1971 · N8798P · Substantial damage NTSB NYC71FHG11Accident · Serious injuriesClosedStinson 108-3 · Mercersburg, PAMar 28, 1971 · N6529M · Substantial damage NTSB NYC71FGM35Accident · Minor injuriesClosedPiper PA-22 · Hawthorne, PAMar 28, 1971 · N6912D · Substantial damage NTSB NYC71FGM34Accident · Minor injuriesClosedTaylorcraft DCO-65 · Portage, PAMar 27, 1971 · N46134 · Destroyed NTSB NYC71IN091Incident · No injuriesClosedBeech C-45G · Philadelphia, PAMar 16, 1971 · N343V · Minor damage NTSB NYC71DHA37Accident · No injuriesClosedPiper PA-22 · Warrington, PAMar 12, 1971 · N2544A · Substantial damage NTSB NYC71FHA36Accident · No injuriesClosedPiper PA-23 · Montgomeryvile, PAMar 9, 1971 · N5603Y · Substantial damage NTSB NYC71DHD40Accident · No injuriesClosedCessna 210 · Downingtown, PAFeb 28, 1971 · N9600X · Substantial damage NTSB NYC71DHA35Accident · No injuriesClosedCessna 150 · Honesdale, PAFeb 28, 1971 · N6481T · Substantial damage NTSB NYC71FHA34Accident · No injuriesClosedPiper PA-28 · Perkasie, PAFeb 27, 1971 · N4825L · Substantial damage NTSB NYC71AN087Accident · 3 fatalClosedPiper PA-28 · Hallstead, PAFeb 17, 1971 · N9711J · Destroyed NTSB NYC71FGM33Accident · No injuriesClosedAeronca 7AC · Butler, PAFeb 16, 1971 · N84607 · Substantial damage NTSB NYC71FHA33Accident · No injuriesClosedPiper PA-28R · Forty Fort, PAFeb 10, 1971 · N7484J · Substantial damage NTSB NYC71FGM32Accident · No injuriesClosedSwearingen SA26T · Johnstown, PAFeb 9, 1971 · N1203S · Substantial damage NTSB NYC71FHA32Accident · Minor injuriesClosedCessna 150 · Stroudsburg, PAFeb 7, 1971 · N60430 · Destroyed NTSB NYC71DGM31Accident · No injuriesClosedPiper PA-28 · Aliquippa, PAFeb 6, 1971 · N6045W · Substantial damage NTSB NYC71DGM30Accident · Minor injuriesClosedPiper PA-28 · Ebensburg, PAFeb 6, 1971 · N7816W · Substantial damage NTSB NYC71FGM29Accident · Serious injuriesClosedLuscombe 8E · Dubois, PAJan 31, 1971 · N1808K · Substantial damage NTSB NYC71AN084Accident · 2 fatalClosedCessna 310L · Mountoursville, PAJan 26, 1971 · N2255F · Destroyed NTSB NYC71FGM27Accident · No injuriesClosedBeech A23 · Belle Vernon, PAJan 24, 1971 · N8742M · Substantial damage NTSB NYC71DHG09Accident · No injuriesClosedPiper PA-30 · Hershey, PAJan 23, 1971 · N8685Y · Substantial damage NTSB NYC71DHA30Accident · No injuriesClosedPiper PA-28 · Easton, PAJan 17, 1971 · N95414 · Substantial damage NTSB NYC71IN081Incident · No injuriesClosedBeech 35 · Franklin, PAJan 15, 1971 · N2855V · No damage NTSB NYC71FHA28Accident · No injuriesClosedCessna 150 · Allentown, PAJan 10, 1971 · N7791E · Substantial damage NTSB NYC71DGM26Accident · Minor injuriesClosedPiper PA-28 · Valencia, PAJan 9, 1971 · N3776R · Substantial damage NTSB NYC71DHD38Accident · No injuriesClosedPiper PA-28R · Bristol, PAJan 4, 1971 · N4979J · Substantial damage NTSB NYC71FHG08Accident · No injuriesClosedCessna 150 · New Cumberland, PAJan 3, 1971 · N6121G · Substantial damage NTSB NYC71FGM25Accident · No injuriesClosedMooney M20G · Belle Vernon, PAJan 2, 1971 · N3698N · Substantial damage NTSB NYC71DGM24Accident · No injuriesClosedPiper PA-22 · Johnstown, PAJan 1, 1971 · N2393P · Substantial damage NTSB NYC71FGM28Accident · No injuriesClosedBell 206A · Somerset, PADec 31, 1970 · N8172J · Substantial damage NTSB NYC71AN071Accident · 2 fatalClosedPiper PA-28 · Butler, PADec 18, 1970 · N4941L · Destroyed NTSB NYC71FHA40Accident · No injuriesClosedPiper PA-28 · Perkasie, PADec 8, 1970 · N5281S · Substantial damage NTSB NYC71FHD32Accident · No injuriesClosedBell 47G-4 · Philadelphia, PADec 2, 1970 · N73943 · Substantial damage NTSB NYC71DHA27Accident · No injuriesClosedPiper PA-28 · Morrisville, PADec 2, 1970 · N6445W · Substantial damage NTSB NYC71FHA23Accident · Minor injuriesClosedPiper PA-23 · Doylestown, PANov 30, 1970 · N4542P · Substantial damage NTSB NYC71FGM22Accident · No injuriesClosedStits SA6B · Finleyville, PANov 22, 1970 · N1292V · Substantial damage NTSB NYC71AN063Accident · 3 fatalClosedCessna 310P · Grove City, PANov 20, 1970 · N5789M · Destroyed NTSB NYC71AN060Accident · Serious injuriesClosedBeech G18S · Clinton, PANov 12, 1970 · N871MP · Destroyed NTSB NYC71AN059Accident · 2 fatalClosedCessna 421 · Bath, PANov 11, 1970 · N3155K · Destroyed NTSB NYC71AN058Accident · 1 fatalClosedBeech 95-A55 · Muncy, PANov 10, 1970 · N77WW · Destroyed NTSB NYC71FHA21Accident · No injuriesClosedPiper PA-24 · Easton, PANov 9, 1970 · N6541P · Substantial damage