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 NYC72DGM22Accident · No injuriesClosedPiper PA-28 · Valencia, PANov 6, 1971 · N7140R · Substantial damage NTSB NYC72DHA23Accident · No injuriesClosedPiper PA-32 · Hamburg, PANov 5, 1971 · N3559W · Substantial damage NTSB NYC72AN061Accident · 4 fatalClosedPiper PA-28 · Boalsburg, PAOct 31, 1971 · N9287J · Destroyed NTSB NYC72FGM21Accident · Minor injuriesClosedPiper PA-22 · Somerset, PAOct 30, 1971 · N7423D · Substantial damage NTSB NYC72FHD19Accident · No injuriesClosedBeech 95-55 · Philadelphia, PAOct 29, 1971 · N77MW · Substantial damage NTSB NYC72AN059Accident · 4 fatalClosedBeech B99 · Bath, PAOct 24, 1971 · N986MA · Destroyed NTSB NYC72FGM20Accident · No injuriesClosedCessna 150L · Bridgeville, PAOct 23, 1971 · N1310Q · Substantial damage NTSB NYC72FGT05Accident · No injuriesClosedCessna 182E · Dushore, PAOct 19, 1971 · N9391X · Substantial damage NTSB NYC72FHA20Accident · No injuriesClosedBeech B23 · Thompson, PAOct 17, 1971 · N6118N · Substantial damage NTSB NYC72AN051Accident · 1 fatalClosedPiper PA-28R · Washingtnville, PAOct 10, 1971 · N2941R · Destroyed NTSB NYC72DHA18Accident · No injuriesClosedCessna 150 · Perkasie, PAOct 8, 1971 · N6759G · Substantial damage NTSB NYC72AN049Accident · 4 fatalClosedCessna 172L · Meyerstown, PAOct 8, 1971 · N7527G · 2 aircraft · Substantial damage NTSB NYC72AN048Accident · 3 fatalClosedMooney M21 · Zelienople, PAOct 8, 1971 · N9472V · Destroyed NTSB NYC72FGM19Accident · Minor injuriesClosedPiper PA-28 · Franklin, PAOct 4, 1971 · N6097W · Substantial damage NTSB NYC72AN047Accident · 2 fatalClosedNavion B · Hazleton, PAOct 4, 1971 · N5259K · Destroyed NTSB NYC72DGM17Accident · Minor injuriesClosedPiper PA-32 · Central City, PASep 25, 1971 · N3698W · Substantial damage NTSB NYC72FGM16Accident · Serious injuriesClosedGibson VPI · Belle Vernon, PASep 24, 1971 · N5186 · Substantial damage NTSB NYC72FHA17Accident · No injuriesClosedCessna 172 · Kempton, PASep 23, 1971 · N7558G · Substantial damage NTSB NYC72FHD15Accident · No injuriesClosedPiper PA-39 · Ambler, PASep 22, 1971 · N8898Y · Substantial damage NTSB NYC72DGM18Accident · No injuriesClosedStarduster TOO · Indiana, PASep 22, 1971 · N2361 · Substantial damage NTSB NYC72FHA16Accident · No injuriesClosedSchweizer SGS233 · Erwinna, PASep 21, 1971 · N1205S · Substantial damage NTSB NYC72AN042Accident · 2 fatalClosedPiper PA-28 · Orson, PASep 19, 1971 · N5507F · Destroyed NTSB NYC72AN043Accident · 4 fatalClosedPiper PA-23 · Mainesburg, PASep 18, 1971 · CF-KKM · Destroyed NTSB NYC72AN038Accident · Minor injuriesClosedLockheed PV-1 · Philadelphia, PASep 11, 1971 · N725YC · Destroyed NTSB NYC72FHD13Accident · No injuriesClosedBeech 70 · Philadelphia, PASep 9, 1971 · N795Q · Substantial damage NTSB NYC72FGM14Accident · No injuriesClosedPiper PA-22 · Prospect, PASep 8, 1971 · N7348D · Substantial damage NTSB NYC72DGM15Accident · No injuriesClosedCessna 150 · Eighty Four, PASep 5, 1971 · N61038 · Substantial damage NTSB NYC72FHA15Accident · No injuriesClosedAero Comdr 100 · Warrington, PASep 3, 1971 · N3859X · Substantial damage NTSB NYC72FGM13Accident · No injuriesClosedPiper PA-24 · Brookville, PASep 2, 1971 · N5737P · Substantial damage NTSB NYC72FGT03Accident · Minor injuriesClosedPiper PA-39 · W Milton, PAAug 31, 1971 · N8843Y · Destroyed NTSB NYC72FHA14Accident · No injuriesClosedErco 415-C · Doylestown, PAAug 29, 1971 · N87089 · Substantial damage NTSB NYC72DHA12Accident · No injuriesClosedCessna 172 · Collegeville, PAAug 23, 1971 · N7227G · Substantial damage NTSB NYC72DHA11Accident · No injuriesClosedPiper PA-28 · Prospectville, PAAug 23, 1971 · N7307J · Substantial damage NTSB NYC72DHD09Accident · No injuriesClosedPiper PA-24 · Gap, PAAug 22, 1971 · N7753P · Substantial damage NTSB NYC72DHA10Accident · No injuriesClosedPiper PA-28 · Souderton, PAAug 22, 1971 · N6214W · Substantial damage NTSB NYC72AN028Accident · No injuriesClosedConvair 580 · Pittsburgh, PAAug 20, 1971 · N5844 · Substantial damage NTSB NYC72FGT02Accident · No injuriesClosedCessna 150J · Dallastown, PAAug 17, 1971 · N5597G · Substantial damage NTSB NYC72FHA08Accident · No injuriesClosedCessna 172 · Collegeville, PAAug 13, 1971 · N3622L · Substantial damage NTSB NYC72FGT01Accident · No injuriesClosedAeronca 15AC · Liberty, PAAug 9, 1971 · N1271H · Substantial damage NTSB NYC72DHA07Accident · Serious injuriesClosedSchweizer SGS134 · Hilltown, PAAug 8, 1971 · N7607 · Substantial damage NTSB NYC72AN022Accident · 1 fatalClosedCessna 170B · Wellsboro, PAAug 8, 1971 · N8155A · Substantial damage NTSB NYC72FGM10Accident · No injuriesClosedCessna 172C · Elmo, PAAug 7, 1971 · N1850Y · Substantial damage NTSB NYC72FGM09Accident · Serious injuriesClosedErco 415C · Irwin, PAAug 7, 1971 · N99162 · Substantial damage NTSB NYC72FHA09Accident · Minor injuriesClosedPiper PA-28 · Easton, PAAug 6, 1971 · N1752T · Substantial damage NTSB NYC72FGM08Accident · Serious injuriesClosedCessna 150G · Valencia, PAAug 6, 1971 · N3787J · Substantial damage NTSB NYC72FGM11Accident · No injuriesClosedFairchild M62A · Finleyville, PAAug 5, 1971 · N60109 · Substantial damage NTSB NYC72FGT04Accident · No injuriesClosedWhittman W-8 · Halifax, PAAug 1, 1971 · N1111N · Substantial damage NTSB NYC72DHA06Accident · No injuriesClosedCessna 172I · Berwick, PAAug 1, 1971 · N46315 · Substantial damage NTSB NYC72DGM07Accident · No injuriesClosedCessna 182 · Bradford, PAJul 29, 1971 · N7217R · Substantial damage NTSB NYC72AN012Accident · 2 fatalClosedCessna A150K · Collegeville, PAJul 26, 1971 · N8440M · Substantial damage