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 NYC74DGT16Accident · No injuriesClosedCessna 172 · Selinsgrove, PAJan 27, 1974 · N46119 · Substantial damage NTSB NYC74IN066Incident · No injuriesClosedBoeing 737 · Allentown, PAJan 24, 1974 · N9154U · Minor damage NTSB NYC74FHD27Accident · No injuriesClosedPiper PA-28 · West Chester, PAJan 22, 1974 · N56118 · Substantial damage NTSB NYC74FHD24Accident · No injuriesClosedAmer Avco AA1-B · Bristol, PAJan 19, 1974 · N9605L · Substantial damage NTSB NYC74AN064Accident · 2 fatalClosedBell 47G-4A · Reading, PAJan 17, 1974 · N1412W · Destroyed NTSB NYC74FGT15Accident · No injuriesClosedCessna 172 · Carlisle, PAJan 15, 1974 · N8198L · Substantial damage NTSB NYC74FGM14Accident · No injuriesClosedPiper PA-28 · Central City, PAJan 8, 1974 · N2144T · Substantial damage NTSB ANC77FM028Accident · 12 fatalClosedBeech 99A · Johnstown, PAJan 6, 1974 · N125AE · Destroyed NTSB NYC74FGM15Incident · No injuriesClosedAerostar 600 · Zelienople, PAJan 5, 1974 · N7484S · Minor damage NTSB NYC74FGT14Accident · No injuriesClosedCessna 182 · New Cumberland, PAJan 4, 1974 · N52372 · Substantial damage NTSB NYC74FGM13Accident · No injuriesClosedPiper PA-28 · Jeannette, PAJan 4, 1974 · N8784N · Substantial damage NTSB NYC74AN061Accident · No injuriesClosedLear Jet 24 · Johnstown, PAJan 3, 1974 · N7500K · Substantial damage NTSB NYC74DHD25Accident · Minor injuriesClosedMooney M20C · Honeybrook, PAJan 1, 1974 · N7867V · Substantial damage NTSB NYC74FHA22Accident · Minor injuriesClosedPiper PA-23 · Reading, PADec 23, 1973 · N1478P · Destroyed NTSB NYC74AN059Accident · 3 fatalClosedBeech G35 · Langhorn, PADec 22, 1973 · N4561D · Destroyed NTSB NYC74AN058Accident · 2 fatalClosedCessna 177RG · Dravosburg, PADec 21, 1973 · N77RG · Destroyed NTSB NYC74FGM12Accident · No injuriesClosedErco 415-C · West Middlesex, PADec 11, 1973 · N2955H · Substantial damage NTSB NYC74AN051Accident · 2 fatalClosedBeech E18S · Corapolis, PADec 7, 1973 · N387B · Destroyed NTSB NYC74FHA20Accident · No injuriesClosedMooney M20C · Collegeville, PADec 4, 1973 · N6754U · Substantial damage NTSB NYC74DHA19Accident · No injuriesClosedPiper PA-24 · Schwenksville, PANov 28, 1973 · N5478P · Substantial damage NTSB NYC74FHA17Accident · Minor injuriesClosedCessna 172 · Moscow, PANov 26, 1973 · N92136 · Destroyed NTSB NYC74AN049Accident · 1 fatalClosedPiper PA-28 · Lake Scranton, PANov 26, 1973 · N4978L · Destroyed NTSB NYC74AN048Accident · 3 fatalClosedPiper PA-28 · Donnally Mills, PANov 25, 1973 · N8056W · Destroyed NTSB NYC74FHA18Accident · No injuriesClosedMooney M20A · Lake Sheridan, PANov 23, 1973 · N8331E · Substantial damage NTSB NYC74AN047Accident · 3 fatalClosedPiper PA-24 · Dupont, PANov 21, 1973 · N8149P · Destroyed NTSB NYC74AN046Accident · 1 fatalClosedBell 206A · Webster, PANov 20, 1973 · N461NC · 2 aircraft · Destroyed NTSB NYC74IN037Incident · No injuriesClosedBoeing 737 · Keating, PAOct 29, 1973 · N9053U · Minor damage NTSB NYC74FGM11Accident · No injuriesClosedPiper PA-28 · Clarion, PAOct 27, 1973 · N1814J · Substantial damage NTSB NYC74AN035Accident · 2 fatalClosedBell 47G-5 · Waynesburg, PAOct 25, 1973 · N8556F · Destroyed NTSB NYC74FHA14Accident · No injuriesClosedErco 415-D · Tunkhannock, PAOct 20, 1973 · N2396H · Substantial damage NTSB NYC74FGM10Accident · No injuriesClosedAero Comdr 200D · West Mifflin, PAOct 20, 1973 · N2962T · Substantial damage NTSB NYC74DGT13Accident · No injuriesClosedAeronca 15AC · Columbia C Rds, PAOct 20, 1973 · N1271H · Substantial damage NTSB NYC74DHD10Accident · Minor injuriesClosedCessna 172 · New London, PAOct 15, 1973 · N19842 · Substantial damage NTSB NYC74FGT12Accident · Minor injuriesClosedPiper PA-28 · York, PAOct 14, 1973 · N690FL · Substantial damage NTSB NYC74DHA15Accident · No injuriesClosedCessna 310 · Fleetville, PAOct 12, 1973 · N244S · Substantial damage NTSB NYC74DGM09Accident · No injuriesClosedPiper PA-28 · Jeanette, PAOct 11, 1973 · N4860T · Substantial damage NTSB NYC74AN032Accident · 1 fatalClosedSikorsky S-55B · Nemacolin, PAOct 9, 1973 · N414A · Destroyed NTSB NYC74FHA11Accident · Serious injuriesClosedPiper PA-28R · Lehighton, PAOct 8, 1973 · N3072R · Substantial damage NTSB NYC74DHA12Accident · No injuriesClosedBlanik L-13 · Erwinna, PAOct 7, 1973 · N90598 · Substantial damage NTSB NYC74FEM08Accident · Serious injuriesClosedMooney M20 · Dubois, PASep 30, 1973 · N6531B · Substantial damage NTSB NYC74DGT11Accident · No injuriesClosedErco 415-D · Hershey, PASep 30, 1973 · N3850H · Substantial damage NTSB NYC74FHD09Accident · No injuriesClosedCessna 310I · Ambler, PASep 28, 1973 · N12MS · Substantial damage NTSB NYC74FGT09Accident · No injuriesClosedBell 206B · Milesburg, PASep 28, 1973 · N7079J · Substantial damage NTSB NYC74DGT10Accident · No injuriesClosedStinson 108-2 · East Waterford, PASep 28, 1973 · N9745K · Substantial damage NTSB NYC74DGM07Accident · No injuriesClosedAeronca 7DC · Carrolltown, PASep 27, 1973 · N2768E · Substantial damage NTSB NYC74AN031Accident · 2 fatalClosedPiper PA-24 · Montoursville, PASep 27, 1973 · N8470P · Destroyed NTSB NYC74DGM06Accident · No injuriesClosedPiper PA-28 · Smicksburg, PASep 22, 1973 · N5233T · Substantial damage NTSB NYC74FGT08Accident · No injuriesClosedPiper PA-28R · Deer Lake, PASep 21, 1973 · N2685R · Substantial damage NTSB NYC74FGT07Accident · No injuriesClosedPiper PA-40 · Lamar, PASep 21, 1973 · N9999P · Destroyed NTSB NYC74FHA09Accident · Minor injuriesClosedPiper PA-22 · Prospectville, PASep 16, 1973 · N5826Z · Substantial damage