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 NYC73FGM25Accident · Serious injuriesClosedAmer Avco AA-1 · Roulette, PAApr 15, 1973 · N5742L · Substantial damage NTSB NYC73DGM27Accident · No injuriesClosedPiper PA-28 · Westover, PAApr 15, 1973 · N1337T · Substantial damage NTSB NYC73DGM26Accident · No injuriesClosedPiper PA-28 · Johnstown, PAApr 15, 1973 · N8013N · Substantial damage NTSB NYC73FHA21Accident · Serious injuriesClosedPiper PA-28 · Langhorne, PAApr 14, 1973 · N4897T · Substantial damage NTSB NYC73AN131Accident · 1 fatalClosedPiper PA-32 · Coraopolis, PAApr 10, 1973 · N4237R · Destroyed NTSB NYC73DGM24Accident · No injuriesClosedCessna 150 · Franklin, PAApr 6, 1973 · N6400G · Substantial damage NTSB NYC73AN128Accident · 1 fatalClosedPiper PA-24 · Nixon, PAMar 31, 1973 · N8738P · Substantial damage NTSB NYC73FGM23Accident · No injuriesClosedCessna 150J · Smithton, PAMar 27, 1973 · N61300 · Substantial damage NTSB NYC73FHD29Accident · No injuriesClosedCessna 150 · Bristol, PAMar 23, 1973 · N60758 · Substantial damage NTSB NYC73DHD28Accident · No injuriesClosedChampion 7EC · Ambler, PAMar 23, 1973 · N7420B · Substantial damage NTSB NYC73DGM21Accident · No injuriesClosedBell 206A · Rimersburg, PAMar 22, 1973 · N8030 · Substantial damage NTSB NYC73FGM22Accident · No injuriesClosedCessna 150J · Beaver Falls, PAMar 21, 1973 · N60173 · Substantial damage NTSB NYC73FGM20Accident · No injuriesClosedCessna 150J · Belle Vernon, PAMar 20, 1973 · N5582G · Substantial damage NTSB NYC73AN123Accident · Serious injuriesClosedBoeing 727 · Harrisburg, PAMar 17, 1973 · N7002 · No damage NTSB NYC73FHA17Accident · Serious injuriesClosedCessna 150H · Pen Argyl, PAMar 16, 1973 · N23310 · Destroyed NTSB NYC73DHA19Accident · No injuriesClosedPiper PA-22 · Prospectville, PAMar 14, 1973 · N8842C · Substantial damage NTSB NYC73AN121Accident · 1 fatalClosedPiper PA-28 · Martinsburg, PAMar 7, 1973 · N7816W · Substantial damage NTSB NYC73AN120Accident · 3 fatalClosedPiper PA-28 · Falls Creek, PAMar 6, 1973 · N2082T · Substantial damage NTSB NYC73DGM19Accident · No injuriesClosedCessna 150 · West Mifflin, PAFeb 25, 1973 · N60319 · Substantial damage NTSB NYC73FGT08Accident · Minor injuriesClosedCessna 150L · Halifax, PAFeb 23, 1973 · N6591G · Substantial damage NTSB NYC73FGM18Accident · No injuriesClosedCessna 310N · West Mifflin, PAFeb 18, 1973 · N5081Q · Substantial damage NTSB NYC73DHA15Accident · No injuriesClosedPiper PA-17 · Slatington, PAFeb 16, 1973 · N4841H · Substantial damage NTSB NYC73FGT07Accident · No injuriesClosedBeech 95 · Montoursville, PAFeb 14, 1973 · N4511L · Substantial damage NTSB NYC73FGM17Accident · No injuriesClosedCessna 150 · West Mifflin, PAFeb 4, 1973 · N61038 · Substantial damage NTSB NYC73DHA14Accident · No injuriesClosedBellanca 14-13 · Erwinna, PAFeb 3, 1973 · N74267 · Substantial damage NTSB NYC73FHD24Accident · Minor injuriesClosedCessna 150L · Up.Phoenixvile, PAJan 31, 1973 · N6759G · Substantial damage NTSB NYC73FGT05Accident · No injuriesClosedCessna 310Q · Centre Hall, PAJan 21, 1973 · N7529Q · Substantial damage NTSB NYC73FGM16Accident · Minor injuriesClosedPiper PA-28 · Monroeville, PAJan 21, 1973 · N5569U · Substantial damage NTSB NYC73AN098Accident · 4 fatalClosedCessna 320E · Avoca, PAJan 7, 1973 · N4883B · Destroyed NTSB NYC73DHD21Accident · No injuriesClosedSchweizer SG233A · West Chester, PAJan 6, 1973 · N7609 · Substantial damage NTSB NYC73FGM15Accident · No injuriesClosedPiper PA-30 · Conemaugh, PAJan 3, 1973 · N153MC · Substantial damage NTSB NYC73AGM14Accident · Serious injuriesClosedCessna 310N · Bedford, PADec 29, 1972 · N4101Q · Substantial damage NTSB NYC73AN087Accident · No injuriesClosedPiper PA-23 · Allentown, PADec 20, 1972 · N5811Y · Destroyed NTSB NYC73DHD73Accident · No injuriesClosedBrantly B-2 · Downingtown, PADec 19, 1972 · N4997C · Substantial damage NTSB NYC73AN088Accident · 2 fatalClosedAmer Avco AA-1A · Clermont, PADec 19, 1972 · N9409L · Substantial damage NTSB NYC73DGT06Accident · No injuriesClosedPiper PA-23 · Lititz, PADec 2, 1972 · N4040P · Substantial damage NTSB NYC73IN076Incident · No injuriesClosedBeech 99 · New Cumberland, PANov 30, 1972 · N7486N · Minor damage NTSB NYC73AN075Accident · 1 fatalClosedBeech D50 · Avoca, PANov 30, 1972 · N634H · Destroyed NTSB NYC73DHD20Accident · Minor injuriesClosedPiper PA-23 · Chester, PANov 25, 1972 · N6185Y · Substantial damage NTSB NYC73FGM13Accident · Serious injuriesClosedPiper PA-32 · Roaring Spring, PANov 22, 1972 · N8672N · Substantial damage NTSB NYC73AN072Accident · 1 fatalClosedBell 212 · Laughlintown, PANov 21, 1972 · N7064J · Substantial damage NTSB NYC73FHA11Accident · No injuriesClosedPiper PA-23 · Reading, PANov 10, 1972 · N5933Y · Substantial damage NTSB NYC73FGM12Accident · Serious injuriesClosedPiper PA-28 · Jeannette, PANov 6, 1972 · N2138R · Substantial damage NTSB NYC73AN062Accident · 1 fatalClosedChampion 7GCB · Honesdale, PANov 5, 1972 · N9881Y · Destroyed NTSB NYC73FGM11Accident · No injuriesClosedAero Comdr 500 · West Mifflin, PAOct 30, 1972 · N8494C · Substantial damage NTSB NYC73FHD17Accident · No injuriesClosedPiper PA-30 · Philadelphia, PAOct 18, 1972 · N8662Y · Substantial damage NTSB NYC73AN052Accident · No injuriesClosedLockheed Howard · Philadelphia, PAOct 15, 1972 · N361MC · Destroyed NTSB NYC73AN050Accident · 2 fatalClosedBell 206A · Whitehaven, PAOct 7, 1972 · N6260N · Destroyed NTSB NYC73FGT04Accident · No injuriesClosedPiper PA-23 · Carlisle, PAOct 5, 1972 · N2236P · Substantial damage NTSB NYC73FGM10Accident · No injuriesClosedCessna 172H · Emlenton, PAOct 1, 1972 · N3818R · Substantial damage