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 NYC65F0054Accident · No injuriesClosedMooney M20E · Warrington, PAFeb 27, 1965 · N1990Y · Substantial damage NTSB NYC65F0063Accident · Minor injuriesClosedPiper PA-22 · Fredericksburg, PAFeb 21, 1965 · N4500Z · 2 aircraft · Substantial damage NTSB NYC65A0109Accident · No injuriesClosedBell 47G4 · Donegal, PAFeb 20, 1965 · N1151W · Substantial damage NTSB NYC65F0022Accident · No injuriesClosedLuscombe 8A · Selinsgrove, PAFeb 13, 1965 · N1094K · Substantial damage NTSB NYC65F0028Accident · No injuriesClosedCessna 150 · New Holland, PAFeb 8, 1965 · N5929T · Substantial damage NTSB NYC65F0023Accident · Minor injuriesClosedMooney M21 · Montoursville, PAFeb 8, 1965 · N74538 · Destroyed NTSB NYC65F0151Accident · No injuriesClosedPiper PA-24 · Philadelphia, PAFeb 6, 1965 · N7777P · Substantial damage NTSB NYC65F0004Accident · No injuriesClosedPiper PA-22 · Prospectville, PAFeb 6, 1965 · N3516P · 2 aircraft · Substantial damage NTSB NYC65D0139Accident · No injuriesClosedChampion 7FC · Warren, PAFeb 6, 1965 · N7513E · Substantial damage NTSB NYC65F0015Accident · No injuriesClosedMooney M20E · New Cumberland, PAJan 31, 1965 · N7845V · Substantial damage NTSB UNK65X1375Accident · No injuriesClosedMooney M20 · Butler, PAJan 30, 1965 · N5257B · Minor damage NTSB NYC65F0024Accident · No injuriesClosedPiper PA15 · Friedens, PAJan 30, 1965 · N4567H · Substantial damage NTSB NYC65F0009Accident · No injuriesClosedPiper PA22 · Somerset, PAJan 30, 1965 · N1704A · Substantial damage NTSB UNK65X1357Accident · No injuriesClosedCessna 172 · Leighton, PAJan 27, 1965 · N7950U · Substantial damage NTSB NYC65A0099Accident · Serious injuriesClosedCaravelle VIR · Allentown, PAJan 24, 1965 · N1001 · No damage NTSB NYC65F0003Accident · No injuriesClosedLuscombe 8A · West Chester, PAJan 21, 1965 · N1129B · Substantial damage NTSB NYC65A0098Accident · Serious injuriesClosedConvair CV-340 · Lancaster, PAJan 21, 1965 · N8417H · Substantial damage NTSB UNK65X1290Accident · Minor injuriesClosedPiper PA-22 · Prospectville, PAJan 15, 1965 · N4765Z · Substantial damage NTSB UNK65X1282Accident · No injuriesClosedPiper PA24 · Pottstown, PAJan 13, 1965 · N8078P · Substantial damage NTSB UNK65X1271Accident · No injuriesClosedPiper PA30 · Reading, PAJan 11, 1965 · N7178Y · Substantial damage NTSB UNK65X1243Accident · No injuriesClosedSwift GC-1B · Forty Fort, PAJan 6, 1965 · N2336B · Substantial damage NTSB UNK65X1228Accident · Serious injuriesClosedMooney M-20 · Snowden Twnshp, PAJan 3, 1965 · N858B · Destroyed NTSB UNK65X1212Accident · No injuriesClosedPiper PA24 · Prospectville, PAJan 1, 1965 · N6251P · Substantial damage NTSB UNK65X1204Accident · No injuriesClosedCessna 182 · Benton, PADec 31, 1964 · N3130S · Substantial damage NTSB UNK65X1100Accident · No injuriesClosedBeechcraft B55 · Allentown, PADec 23, 1964 · N6845Q · Substantial damage NTSB UNK65X1099Accident · No injuriesClosedBell 47J2 · Philadelphia, PADec 22, 1964 · N73216 · Substantial damage NTSB UNK65X1045Accident · Minor injuriesClosedBrantly B2B · Hawthorn, PADec 18, 1964 · N2264U · Substantial damage NTSB UNK65X1028Accident · No injuriesClosedCessna 310C · Bedford, PADec 16, 1964 · N1779H · Substantial damage NTSB UNK65X1022Accident · No injuriesClosedVickers VI745D · Franklin, PADec 15, 1964 · N505W · Substantial damage NTSB UNK65X0968Accident · No injuriesClosedPiper PA24 · Philadelphia, PADec 10, 1964 · N6638P · Substantial damage NTSB UNK65X0895Accident · No injuriesClosedChampion 7FC · Berwick, PADec 1, 1964 · N9050B · Substantial damage NTSB UNK65X0890Accident · Serious injuriesClosedPiper PA22 · St Marys, PANov 30, 1964 · N8616C · Destroyed NTSB UNK65X0870Accident · 4 fatalClosedCessna 172 · Philadelphia, PANov 28, 1964 · N3558S · Destroyed NTSB UNK65X0858Accident · Minor injuriesClosedAeronca 7AC · Emporium, PANov 27, 1964 · N84241 · Substantial damage NTSB UNK65X0846Accident · Minor injuriesClosedPiper PA22 · Warren, PANov 26, 1964 · N7302D · Substantial damage NTSB UNK65X0844Accident · 3 fatalClosedCessna 310B · Clarks Summit, PANov 26, 1964 · N5364A · Destroyed NTSB UNK65X0829Accident · Serious injuriesClosedPiper PA-24 · Mars, PANov 25, 1964 · N7334P · Substantial damage NTSB UNK65X0821Accident · Minor injuriesClosedPiper PA-22 · Waynesburg, PANov 24, 1964 · N7204D · Destroyed NTSB UNK65X0717Accident · No injuriesClosedCessna 140A · Somerset, PANov 15, 1964 · N242S · Substantial damage NTSB UNK65X0703Accident · No injuriesClosedCessna 210D · West Mifflin, PANov 14, 1964 · N3733Y · Substantial damage NTSB UNK65X0702Accident · No injuriesClosedStinson 108-1 · Collegeville, PANov 14, 1964 · N9202K · Substantial damage NTSB UNK65X0701Accident · Minor injuriesClosedTaylorcraft DC065 · Emlenton, PANov 14, 1964 · N57731 · Destroyed NTSB UNK65X0599Accident · No injuriesClosedMooney M21 · Clarks Summit, PANov 7, 1964 · N6885U · Substantial damage NTSB UNK65X0587Accident · 1 fatalClosedPiper PA-28 · Center Valley, PANov 6, 1964 · N8892W · Substantial damage NTSB UNK65X0563Incident · No injuriesClosedViscount 745 · Harrisburg, PANov 5, 1964 · N7429 · Minor damage NTSB UNK65X0539Accident · No injuriesClosedBeechcraft B50 · Waynesburg, PANov 3, 1964 · N3561B · Substantial damage NTSB UNK65X0495Accident · No injuriesClosedCurtis C-46F · Pittsburgh, PAOct 30, 1964 · N618Z · Substantial damage NTSB UNK65X0494Accident · Serious injuriesClosedPiper PA24 · Stahlstown, PAOct 30, 1964 · N7721P · Destroyed NTSB UNK65X0461Accident · No injuriesClosedCessna 310C · Phillipsburg, PAOct 28, 1964 · N1779H · Substantial damage NTSB UNK65X0435Accident · No injuriesClosedCessna 150 · Clarion, PAOct 25, 1964 · N7766E · Substantial damage