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 UNK64X1072Accident · No injuriesClosedCessna 172 · Elizabethville, PAMar 28, 1964 · N8750B · Substantial damage NTSB UNK64X0926Accident · No injuriesClosedChampion 7FC · Sharon, PAMar 15, 1964 · N8513E · Substantial damage NTSB UNK64X0914Accident · No injuriesClosedPiper PA24 · Allentown, PAMar 14, 1964 · N7867P · Substantial damage NTSB UNK64X0900Accident · No injuriesClosedPiper PA22 · Pottstown, PAMar 13, 1964 · N6119D · Substantial damage NTSB UNK64X0883Accident · No injuriesClosedPiper PA22 · Martinsburg, PAMar 11, 1964 · N5570Z · Substantial damage NTSB UNK64X0878Incident · No injuriesClosedDouglas DC-8 · Philadelphia, PAMar 11, 1964 · N80610 · No damage NTSB UNK64X0876Accident · No injuriesClosedPiper PA30 · Montoursville, PAMar 10, 1964 · N7005Y · Substantial damage NTSB UNK64X0835Accident · No injuriesClosedStinson 108-3 · Punxtawney, PAMar 7, 1964 · N6829M · Substantial damage NTSB UNK64X0830Accident · No injuriesClosedPiper PA18 · Brodheadsville, PAMar 7, 1964 · N4065Z · Substantial damage NTSB UNK64X0784Accident · No injuriesClosedPiper PA22 · New Kingston, PAMar 1, 1964 · N9243D · Substantial damage NTSB UNK64X0782Accident · No injuriesClosedCessna 195 · Limerick, PAMar 1, 1964 · N3022B · Substantial damage NTSB UNK64X0743Accident · Minor injuriesClosedBeechcraft F35 · Johnstown, PAFeb 29, 1964 · N506 · Substantial damage NTSB UNK64X0698Accident · No injuriesClosedCessna 175 · West Chester, PAFeb 26, 1964 · N8128T · Substantial damage NTSB UNK64X0675Accident · No injuriesClosedLuscombe 8A · Allentown, PAFeb 23, 1964 · N22096 · Substantial damage NTSB UNK64X0653Accident · No injuriesClosedPiper PA25 · Latrobe, PAFeb 22, 1964 · N6935Z · Substantial damage NTSB UNK64X0645Accident · No injuriesClosedCessna 172 · Ambler, PAFeb 22, 1964 · N7672X · Substantial damage NTSB UNK64X0632Accident · No injuriesClosedPiper PA22 · Meadville, PAFeb 21, 1964 · N3523Z · Substantial damage NTSB UNK64X0602Accident · Minor injuriesClosedPiper PA23 · Reading, PAFeb 18, 1964 · N5121Y · Destroyed NTSB UNK64X0598Accident · No injuriesClosedGlobe GC1B · Scranton, PAFeb 17, 1964 · N3785K · Substantial damage NTSB UNK64X0577Accident · No injuriesClosedCessna 310C · Mars, PAFeb 15, 1964 · N6705T · Substantial damage NTSB UNK64X0514Accident · No injuriesClosedErcoupe 415C · Bristol, PAFeb 9, 1964 · N99158 · Substantial damage NTSB UNK64X0496Accident · No injuriesClosedMooney M20A · Allentown, PAFeb 8, 1964 · N6544B · Substantial damage NTSB UNK64X0478Accident · No injuriesClosedPiper PA-12 · Bolivar, PAFeb 6, 1964 · N4054M · Substantial damage NTSB UNK64X0466Accident · No injuriesClosedPiper PA28 · Forty Fort, PAFeb 5, 1964 · N7270W · Substantial damage NTSB UNK64X0450Accident · 1 fatalClosedBrantly B2 · Lyons, PAFeb 3, 1964 · N5960X · Destroyed NTSB UNK64X0316Incident · No injuriesClosedDouglas DC-8 · Philadelphia, PAJan 22, 1964 · N7605 · No damage NTSB UNK64X0205Accident · No injuriesClosedBeechcraft D50A · Erie, PAJan 10, 1964 · N5669D · Substantial damage NTSB UNK64X0163Accident · No injuriesClosedPiper PA22 · Easton, PAJan 5, 1964 · N4533Z · Substantial damage NTSB UNK64X0141Accident · No injuriesClosedCessna 172A · Easton, PAJan 3, 1964 · N7446T · Substantial damage NTSB UNK64X0117Accident · No injuriesClosedBeechcraft 35 · Coatesville, PAJan 2, 1964 · N3104V · Substantial damage NTSB NYC64A0029Accident · No injuriesClosedConvair 440 · Wilkes-Barre, PAAug 21, 1963 · N9320 · Substantial damage NTSB NYC64A0008Accident · Serious injuriesClosedLockheed 188 · Bradford, PAJul 2, 1963 · N6126 · No damage