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 NYC67F0407Accident · No injuriesClosedPiper PA-28 · Mt Pocono, PAJan 2, 1967 · N8406R · Substantial damage NTSB NYC67D0424Accident · No injuriesClosedStinson V-77 · Honesdale, PAJan 2, 1967 · N9028H · Substantial damage NTSB NYC67D0439Accident · No injuriesClosedPiper PA-22 · Clarion, PADec 31, 1966 · N3547P · Substantial damage NTSB NYC67F0574Accident · No injuriesClosedPiper PA-24 · Coraopolis, PADec 30, 1966 · N5276P · Substantial damage NTSB NYC67F0428Accident · No injuriesClosedPiper PA-24 · Selinsgrove, PADec 30, 1966 · N8999P · Substantial damage NTSB NYC67D0675Accident · No injuriesClosedCessna 172C · Greenville, PADec 30, 1966 · N8274X · Substantial damage NTSB NYC67F0438Accident · No injuriesClosedLuscombe 8E · Aliquippa, PADec 25, 1966 · N2527K · Destroyed NTSB NYC67F0411Accident · No injuriesClosedCessna 411 · Erie, PADec 20, 1966 · N2214Z · Substantial damage NTSB NYC67D0480Accident · Minor injuriesClosedPiper PA-28 · Millcreek, PADec 17, 1966 · N5483Z · Substantial damage NTSB NYC67D0417Accident · No injuriesClosedAeronca 7AC · Mechanicsburg, PADec 17, 1966 · N82146 · No damage NTSB NYC67A0091Accident · No injuriesClosedPiper PA-23 · Lock Haven, PADec 5, 1966 · N5625U · Substantial damage NTSB NYC67D0397Accident · No injuriesClosedNavion G · West Chester, PANov 29, 1966 · N2443T · Substantial damage NTSB NYC67A0089Accident · No injuriesClosedConvair 340 · New Cumberland, PANov 29, 1966 · N3414 · Substantial damage NTSB NYC67A0085Accident · 1 fatalClosedPiper PA-18 · Northeast, PANov 23, 1966 · N4202Z · Destroyed NTSB NYC67A0083Accident · 4 fatalClosedPiper PA-23 · Lewisburg, PANov 23, 1966 · N4562P · Destroyed NTSB NYC67A0082Accident · No injuriesClosedPiper PA-24 · Berwick, PANov 23, 1966 · N8912P · Substantial damage NTSB NYC67F0378Accident · No injuriesClosedMaule M4 · Mt Pleasant, PANov 20, 1966 · N4724T · Substantial damage NTSB NYC67F0349Accident · No injuriesClosedCessna 320B · Easton, PANov 18, 1966 · N810S · Substantial damage NTSB NYC67F0367Accident · No injuriesClosedCessna 180 · Culmerville, PANov 17, 1966 · N3613C · Substantial damage NTSB NYC67F0372Accident · Serious injuriesClosedStinson 108-3 · New Castle, PANov 13, 1966 · N6970M · Destroyed NTSB NYC67D0379Accident · No injuriesClosedPiper PA-28 · Clearfield, PANov 13, 1966 · N8546W · Substantial damage NTSB NYC67D0374Accident · No injuriesClosedMooney M20E · Johnstown, PANov 11, 1966 · N7844V · Substantial damage NTSB NYC67F0377Accident · No injuriesClosedCessna 150 · Hiladelphia, PANov 8, 1966 · N8517G · Substantial damage NTSB NYC67D0358Accident · No injuriesClosedPiper PA-24 · Pottstown, PANov 8, 1966 · N8353P · Substantial damage NTSB NYC67A0077Accident · 3 fatalClosedBeech S35 · Columbia X-Rds, PANov 7, 1966 · N6030F · Destroyed NTSB NYC67A0076Accident · No injuriesClosedPiper PA-30 · New Cumberland, PANov 7, 1966 · N7507Y · Substantial damage NTSB NYC67I0074Incident · No injuriesClosedViscount 745D · Pittsburg, PANov 2, 1966 · N7422 · No damage NTSB NYC67F0341Accident · No injuriesClosedCessna 140 · Danville, PAOct 30, 1966 · N1992V · Substantial damage NTSB NYC67F0317Accident · Minor injuriesClosedPiper PA-12 · Clarks Summit, PAOct 30, 1966 · N3414M · Destroyed NTSB NYC67D0373Accident · No injuriesClosedMooney M20E · Grove City, PAOct 30, 1966 · N7826V · Substantial damage NTSB NYC67F0355Accident · No injuriesClosedBeechcraft E18S · Reedsville, PAOct 27, 1966 · N219Y · Substantial damage NTSB NYC67F0326Accident · No injuriesClosedPiper PA-30 · Morrisville, PAOct 25, 1966 · N7907Y · Destroyed NTSB NYC67D0375Accident · Minor injuriesClosedPiper PA-22 · Erie, PAOct 23, 1966 · N5385Z · Substantial damage NTSB NYC67A0064Accident · No injuriesClosedBrantly 305 · West Mifflin, PAOct 22, 1966 · N2207U · Substantial damage NTSB NYC67D0365Accident · No injuriesClosedStinson 108-1 · Leechburg, PAOct 21, 1966 · N8701K · Substantial damage NTSB NYC67A0106Accident · No injuriesClosedHiller UH-12A · Honesdale, PAOct 13, 1966 · N8109H · Substantial damage NTSB NYC67F0300Accident · No injuriesClosedCessna 150 · Carlisle, PAOct 2, 1966 · N7834E · Substantial damage NTSB NYC67D0323Accident · No injuriesClosedPiper PA-20 · Finleyville, PAOct 2, 1966 · N1564A · Substantial damage NTSB NYC67F0280Accident · No injuriesClosedMooney M20E · Avoca, PASep 30, 1966 · N1279X · Substantial damage NTSB NYC67F0252Accident · No injuriesClosedCessna 337 · Ohnstown, PASep 28, 1966 · CF-SBX · Substantial damage NTSB NYC67D0366Accident · No injuriesClosedPiper PA-28 · Johnston, PASep 28, 1966 · N7856W · Substantial damage NTSB NYC67A0052Accident · 1 fatalClosedBensen B8M · Benton, PASep 25, 1966 · N1138 · Destroyed NTSB NYC67F0244Accident · Serious injuriesClosedCessna 180 · Tarentum, PASep 6, 1966 · N1612C · Substantial damage NTSB NYC67F0189Accident · No injuriesClosedCessna 180 · Freedom, PASep 5, 1966 · N2919A · Substantial damage NTSB NYC67F0271Accident · Serious injuriesClosedCessna 182 · Clarion, PASep 4, 1966 · N8387S · Destroyed NTSB NYC67F0206Accident · No injuriesClosedCessna 182A · Pottstown, PASep 3, 1966 · N2041G · Substantial damage NTSB NYC67F0176Accident · No injuriesClosedMooney MK20A · Allentown, PASep 1, 1966 · N8170E · Substantial damage NTSB NYC67D0246Accident · No injuriesClosedMooney M20C · Philadelphia, PASep 1, 1966 · N5681Q · Substantial damage NTSB NYC67F0230Accident · Minor injuriesClosedPiper PA-22 · Milroy, PAAug 31, 1966 · N9552D · Substantial damage NTSB NYC67A0041Accident · No injuriesClosedHughes 269A · Montoursville, PAAug 30, 1966 · N8803F · Destroyed