Skip to content

NTSB investigations: Piper PA-34-200T

278 cases on aircraft the registry lists as Piper PA-34-200T. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103406')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103406'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103406'))
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 DEN79FQA08Accident · No injuriesClosedPiper PA-34 · Albuquerque, NMNov 30, 1978 · N3039M · Substantial damage NTSB FTW79DRD02Accident · No injuriesClosedPiper PA-34 · Westwego, LAOct 1, 1978 · N3566M · Substantial damage NTSB LAX78DUM38Accident · No injuriesClosedPiper PA-34T · San Diego, CASep 20, 1978 · N1451X · Substantial damage NTSB IAD78FLQ26Accident · No injuriesClosedPiper PA-34 · Louisville, KYJul 23, 1978 · N415HE · Substantial damage NTSB MIA78DKJ37Accident · No injuriesClosedPiper PA-34 · Eufaula, ALMay 22, 1978 · N577SA · Substantial damage NTSB MIA78FKQ10Accident · Serious injuriesClosedPiper PA-34 · Laurel, MSMay 6, 1978 · N47488 · Destroyed NTSB LAX78FUA15Accident · No injuriesClosedPiper PA-34 · Fullerton, CAMay 5, 1978 · N2710M · Substantial damage NTSB DEN78FTC20Accident · No injuriesClosedPiper PA-34 · Cheyenne, WYApr 4, 1978 · N6646F · Substantial damage NTSB MIA78FLA26Accident · Minor injuriesClosedPiper PA-34 · Madison, FLApr 1, 1978 · N1839H · Substantial damage NTSB MKC78DCA18Accident · No injuriesClosedPiper PA-34 · Malden, MOFeb 27, 1978 · N8385C · Substantial damage NTSB SEA78FA016Accident · 1 fatalClosedPiper PA-34 · Wenatchee, WADec 30, 1977 · N7089C · Destroyed NTSB MKC78FA013Accident · 2 fatalClosedPiper PA-34 · Davenport, IADec 14, 1977 · N1634H · Destroyed NTSB NYC78FA010Accident · 1 fatalClosedPiper PA-34 · Reedsville, NYNov 23, 1977 · N777TD · Destroyed NTSB FTW78FA010Accident · Serious injuriesClosedPiper PA-34 · Tulsa, OKNov 6, 1977 · N33041 · Destroyed NTSB CHI77DEX42Accident · No injuriesClosedPiper PA-34 · Huntingburg, INAug 9, 1977 · N32174 · Substantial damage NTSB IAD77FA041Accident · 1 fatalClosedPiper PA-34 · Bridgeport, WVMay 26, 1977 · N1153H · Destroyed NTSB DEN77FA041Accident · 2 fatalClosedPiper PA-34 · Bigtrails, WYMay 6, 1977 · N4948F · Destroyed NTSB IAD77DA033Accident · No injuriesClosedPiper PA-34 · Charlotte, NCMar 8, 1977 · N41941 · Substantial damage NTSB SEA77DYE06Accident · No injuriesClosedPiper PA-34 · Verlot, WADec 27, 1976 · N33589 · Destroyed NTSB IAD76II075Incident · No injuriesClosedPiper PA-34 · Washington, DCJun 5, 1976 · N8312C · Minor damage NTSB DEN76FTM33Accident · No injuriesClosedPiper PA-34 · Bullfrog Basin, UTMay 31, 1976 · N33025 · Substantial damage NTSB MKC76FCA24Accident · No injuriesClosedPiper PA-34 · Eminence, MOMay 21, 1976 · N33819 · Substantial damage NTSB SEA76DYG40Accident · No injuriesClosedPiper PA-34 · Clyde, WAMar 4, 1976 · N7333L · Substantial damage NTSB FTW76FPA10Accident · No injuriesClosedPiper PA-34 · Plano, TXOct 30, 1975 · N32510 · Destroyed NTSB OAK76AP023Accident · 2 fatalClosedPiper PA-34 · Zephyr Cove, NVOct 26, 1975 · N1495X · Destroyed NTSB OAK76AP004Accident · No injuriesClosedPiper PA-34 · Redding, CAJul 23, 1975 · N8SW · Substantial damage NTSB CHI75FEE68Accident · No injuriesClosedPiper PA-34 · Union Hill, ILJun 21, 1975 · N33742 · Substantial damage NTSB MKC71FCG64Accident · Minor injuriesClosedPiper PA-28 · Liberty, MOMay 9, 1971 · N5151S · Substantial damage