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 NYC73AN048Accident · 5 fatalClosedBeech 95-55 · Hamburg, PASep 29, 1972 · N914Q · Destroyed NTSB NYC73DHA08Accident · No injuriesClosedHughes 269A · Lenhartsville, PASep 23, 1972 · N8936F · Substantial damage NTSB NYC73DGT03Accident · No injuriesClosedCessna 172 · Ashland, PASep 18, 1972 · N3990F · Destroyed NTSB NYC73FHA06Accident · No injuriesClosedAeronca 7BCM · Perkasie, PASep 16, 1972 · N4008A · Substantial damage NTSB NYC73DHA07Accident · Minor injuriesClosedStinson 108-3 · Moscow, PASep 16, 1972 · N742C · Substantial damage NTSB NYC73FGM08Accident · No injuriesClosedCessna 172K · Jeannette, PASep 15, 1972 · N84763 · Substantial damage NTSB NYC73DGM09Accident · No injuriesClosedBeech A23 · Wattsburg, PASep 15, 1972 · N1411L · Substantial damage NTSB NYC73DHD13Accident · Minor injuriesClosedPiper PA-28 · Bristol, PASep 4, 1972 · N3696R · Destroyed NTSB NYC73FHA05Accident · No injuriesClosedCessna 140 · Montgmeryville, PASep 3, 1972 · N2192V · Substantial damage NTSB NYC73DHD12Accident · No injuriesClosedCessna 150 · Ambler, PASep 3, 1972 · N1422Q · Destroyed NTSB NYC73AN039Accident · 1 fatalClosedCessna 150G · Newtown, PAAug 31, 1972 · N3161J · Destroyed NTSB NYC73FHD14Accident · Minor injuriesClosedCessna 172 · Norristown, PAAug 28, 1972 · N7127G · Destroyed NTSB NYC73FHD11Accident · Minor injuriesClosedPiper PA-28 · Media, PAAug 20, 1972 · N3930R · Destroyed NTSB NYC73DGM06Accident · No injuriesClosedStarduster TOO · Volant, PAAug 20, 1972 · N3263 · Substantial damage NTSB NYC73FGM07Accident · No injuriesClosedCessna 182 · Ligonier, PAAug 19, 1972 · N1892X · Substantial damage NTSB NYC73FGM05Accident · Minor injuriesClosedCessna 140 · Slippery Rock, PAAug 19, 1972 · N72765 · Destroyed NTSB NYC73DGT02Accident · No injuriesClosedPiper J4 · Gettysburg, PAAug 13, 1972 · N26895 · Substantial damage NTSB NYC73FHD08Accident · No injuriesClosedNavion A · Philadelphia, PAAug 5, 1972 · N678E · Substantial damage NTSB NYC73AN046Accident · 1 fatalClosedCessna 182A · Avoca, PAJul 31, 1972 · N3792D · Destroyed NTSB NYC73FGM04Accident · Minor injuriesClosedPiper PA-18A · Butler, PAJul 30, 1972 · N9911D · Substantial damage NTSB NYC73DGM03Accident · No injuriesClosedStinson 108 · Central City, PAJul 29, 1972 · N40105 · Substantial damage NTSB NYC73FGM02Accident · No injuriesClosedGrumman G-164A · Freedom, PAJul 26, 1972 · N7480 · Substantial damage NTSB NYC73AN015Accident · 1 fatalClosedGlobe GC-1B · Coudersport, PAJul 23, 1972 · N3217K · Destroyed NTSB NYC73FHA04Accident · No injuriesClosedCessna 170 · Montrose, PAJul 17, 1972 · N2987D · Substantial damage NTSB NYC73FHA03Accident · No injuriesClosedChampion 7KCAB · Kutztown, PAJul 16, 1972 · N2753G · Substantial damage NTSB NYC73DHA02Accident · No injuriesClosedSchweizer 233A · Erwinna, PAJul 15, 1972 · N1241S · Substantial damage NTSB NYC73DGM01Accident · No injuriesClosedCessna 150L · Cuddy, PAJul 14, 1972 · N1288Q · Substantial damage NTSB NYC73FHA01Accident · No injuriesClosedChampion 7GCAA · Kutztown, PAJul 11, 1972 · N9090L · Substantial damage NTSB NYC73AN007Accident · No injuriesClosedCessna 172H · York, PAJul 6, 1972 · N3297L · Substantial damage NTSB NYC73DGT01Accident · No injuriesClosedCessna 172 · Huntingdon, PAJul 4, 1972 · N4173L · Substantial damage NTSB NYC73AN003Accident · 1 fatalClosedErco 415-C · Mcdonald, PAJul 4, 1972 · N94031 · Destroyed NTSB NYC72AN167Accident · 2 fatalClosedCessna 310 · Reading, PAJun 29, 1972 · N5250A · Destroyed NTSB NYC72AN163Accident · 4 fatalClosedBell 206A · New Cumberland, PAJun 26, 1972 · N25BB · Destroyed NTSB NYC72AN159Accident · 1 fatalClosedBeech 35-C33 · Oil City, PAJun 23, 1972 · N2726T · Destroyed NTSB NYC72FGT11Accident · Serious injuriesClosedPiper PA-30 · Lock Haven, PAJun 18, 1972 · N8829Y · Destroyed NTSB NYC72FGM51Accident · No injuriesClosedBeech A23 · New Castle, PAJun 18, 1972 · N5763V · Substantial damage NTSB NYC72AN157Accident · 3 fatalClosedBeech 23 · Spring Run, PAJun 18, 1972 · N2378Q · Destroyed NTSB NYC72AN156Accident · Minor injuriesClosedBell 206A · Dingmans Ferry, PAJun 18, 1972 · N1494W · Destroyed NTSB NYC72IN154Incident · No injuriesClosedDouglas DC-8 · Philadelphia, PAJun 17, 1972 · N8615 · No damage NTSB NYC72DHA40Accident · No injuriesClosedSchleicher KA-6 · Kunkletown, PAJun 11, 1972 · N1510 · Substantial damage NTSB NYC72DGM49Accident · No injuriesClosedPiper PA-22 · Sugar Grove, PAJun 11, 1972 · N31462 · Substantial damage NTSB NYC72IN149Incident · Minor injuriesClosedBoeing 737 · Pittsburgh, PAJun 9, 1972 · N9072U · No damage NTSB NYC72DGM50Accident · Serious injuriesClosedHiller Acft FH1100 · Jefferson, PAJun 8, 1972 · N5059F · No damage NTSB NYC72FGT12Accident · Serious injuriesClosedPiper PA-28 · Emigsville, PAJun 4, 1972 · N7847N · Substantial damage NTSB NYC72DGM48Accident · Minor injuriesClosedPitts Spcl S-1 · Derry, PAMay 29, 1972 · N513W · Destroyed NTSB NYC72DHA39Accident · Minor injuriesClosedSchleicher KA-6 · Dingmans Ferry, PAMay 28, 1972 · N29JG · Substantial damage NTSB NYC72DGT10Accident · Minor injuriesClosedAeronca 7AC · Centre Hall, PAMay 23, 1972 · N84539 · Substantial damage NTSB NYC72DGM47Accident · No injuriesClosedCessna 150 · Sharon, PAMay 21, 1972 · N8521J · Substantial damage NTSB NYC72DGM46Accident · No injuriesClosedCessna 150H · Dubois, PAMay 19, 1972 · N23156 · Substantial damage NTSB NYC72FHA38Accident · No injuriesClosedPiper PA-24 · Easton, PAMay 13, 1972 · N9378P · Substantial damage