Skip to content

NTSB investigations: Piper PA-34-200

210 cases on aircraft the registry lists as Piper PA-34-200. 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 ('7103405')) 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 ('7103405'))
  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 ('7103405'))
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 FTW77FPG01Accident · No injuriesClosedPiper PA-34 · Little Rock, AROct 4, 1977 · N41192 · Substantial damage NTSB MIA77FLA55Accident · No injuriesClosedPiper PA-34 · Madison, FLSep 16, 1977 · N41538 · Substantial damage NTSB MIA77FLD82Accident · No injuriesClosedPiper PA-34 · Tampa, FLSep 4, 1977 · N55051 · Substantial damage NTSB OAK77FVM26Accident · No injuriesClosedPiper PA-34 · Palo Alto, CAAug 29, 1977 · N41564 · Destroyed NTSB OAK77DVA40Accident · No injuriesClosedPiper PA-34 · Turlock, CAJul 8, 1977 · N43540 · Substantial damage NTSB DEN77FQA33Accident · No injuriesClosedPiper PA-34 · Gallup, NMMay 7, 1977 · N40949 · Substantial damage NTSB CHI77DEX10Accident · No injuriesClosedPiper PA-34 · Terre Haute, INJan 24, 1977 · N4522T · Substantial damage NTSB NYC77FA019Accident · 5 fatalClosedPiper PA-34 · Forked River, NJDec 4, 1976 · N15698 · Destroyed NTSB IAD77FA005Accident · 4 fatalClosedPiper PA-34 · Busick, NCOct 9, 1976 · N15025 · Destroyed NTSB SEA76AS079Accident · 4 fatalClosedPiper PA-34 · Kent, WASep 25, 1976 · N15867 · Destroyed NTSB LAX76AL093Accident · 2 fatalClosedPiper PA-34 · Phoenix, AZSep 6, 1976 · N15075 · Destroyed NTSB MKC76AK070Accident · 2 fatalClosedPiper PA-34 · Greensburg, KSJul 27, 1976 · N56712 · Substantial damage NTSB SEA76OO508Accident · Minor injuriesClosedPiper PA-34 · San Luis, MexicoJul 2, 1976 · N1057U · Substantial damage NTSB OAK76DVG89Accident · No injuriesClosedPiper PA-34 · San Andreas, CAJun 24, 1976 · N56602 · Substantial damage NTSB ANC76IA104Incident · No injuriesClosedPiper PA-34 · Fairbanks, AKJun 20, 1976 · N56912 · Minor damage NTSB ANC76AA088Accident · 6 fatalClosedPiper PA-34 · Petersburg, AKMay 18, 1976 · N55951 · Destroyed NTSB IAD76FLQ18Accident · No injuriesClosedPiper PA-34 · Lexington, KYApr 20, 1976 · N55322 · Substantial damage NTSB MIA76FKG50Accident · No injuriesClosedPiper PA-34 · Savannah, GAApr 10, 1976 · N16389 · Substantial damage NTSB CHI76DEE46Accident · No injuriesClosedPiper PA-34 · Wilmington, ILMar 20, 1976 · N4467T · Substantial damage NTSB MKC76DCQ37Accident · Minor injuriesClosedPiper PA-34 · Medicine Lodge, KSFeb 17, 1976 · N41513 · Substantial damage NTSB IAD76AI056Accident · No injuriesClosedPiper PA-34 · Greeneville, TNFeb 3, 1976 · N55073 · Substantial damage NTSB DEN76FQA32Accident · No injuriesClosedPiper PA-34 · Albuquerque, NMDec 30, 1975 · N44311 · Substantial damage NTSB CHI76FEC15Accident · No injuriesClosedPiper PA-34 · Troy, MIDec 18, 1975 · N5297T · Substantial damage NTSB OAK76AP015Accident · 2 fatalClosedPiper PA-34 · Kirkwood, CAOct 6, 1975 · N55105 · Destroyed NTSB NYC76IN053Incident · No injuriesClosedPiper PA-34 · Boston, MASep 19, 1975 · N56121 · Minor damage NTSB MKC76DCQ14Accident · No injuriesClosedPiper PA-34 · Hutchinson, KSAug 29, 1975 · N1040U · Substantial damage NTSB NYC76FNA13Accident · No injuriesClosedPiper PA-34 · Newburyport, MAAug 22, 1975 · N4519T · Substantial damage NTSB CHI76FEE09Accident · No injuriesClosedPiper PA-34 · Hinckley, ILJul 12, 1975 · N41494 · Substantial damage NTSB SEA75DTI31Accident · No injuriesClosedPiper PA-34 · Missoula, MTMay 30, 1975 · N55258 · Substantial damage NTSB ANC75AA063Accident · Minor injuriesClosedPiper PA-34 · Togiak, AKMar 12, 1975 · N1062U · Substantial damage NTSB IAD75II045Incident · No injuriesClosedPiper PA-34 · Dover, DEJan 24, 1975 · N15686 · Minor damage NTSB IAD75FLJ18Accident · No injuriesClosedPiper PA-34 · Fort Bragg, NCJan 14, 1975 · N1050U · Substantial damage NTSB IAD75II025Incident · No injuriesClosedPiper PA-34 · Ocean City, MDOct 16, 1974 · N15686 · Minor damage NTSB DEN75FTE27Accident · No injuriesClosedPiper PA-34 · Englewood, COOct 11, 1974 · N44211 · Substantial damage NTSB FTW75DPJ08Accident · No injuriesClosedPiper PA-34 · Early, OKSep 29, 1974 · N16397 · Substantial damage NTSB FTW75DQG18Accident · No injuriesClosedPiper PA-34 · Perryton, TXAug 11, 1974 · N15566 · Substantial damage NTSB IAD75II005Incident · No injuriesClosedPiper PA-34 · Washington, DCAug 2, 1974 · N1067U · Minor damage NTSB NYC75AN016Accident · No injuriesClosedPiper PA-34 · Cheswold, DEAug 1, 1974 · N56541 · Substantial damage NTSB NYC75FHA06Accident · No injuriesClosedPiper PA-34 · Reading, PAJul 31, 1974 · N1040U · Substantial damage NTSB NYC75AN009Accident · No injuriesClosedPiper PA-34 · Philadelphia, PAJul 21, 1974 · N5264T · Substantial damage NTSB NYC75FGT01Accident · No injuriesClosedPiper PA-34 · Myerstown, PAJul 3, 1974 · N42866 · Substantial damage NTSB LAX74AL083Accident · 4 fatalClosedPiper PA-34 · Denver, COJun 21, 1974 · N15774 · 2 aircraft · Destroyed NTSB FTW74DPJ32Accident · Minor injuriesClosedPiper PA-34 · Duncan, OKJun 15, 1974 · N16575 · Destroyed NTSB MKC74DTK17Accident · No injuriesClosedPiper PA-25 · Mobridge, SDJun 4, 1974 · N16502 · Substantial damage NTSB FTW74AF079Accident · 3 fatalClosedPiper PA-34 · Hockey, TXMay 3, 1974 · N5286T · Destroyed NTSB LAX74OL072Accident · No injuriesClosedPiper PA-34 · Ciudad Juarez, MexicoMar 14, 1974 · N55334 · Substantial damage NTSB DEN74AD040Accident · 1 fatalClosedPiper PA-34 · Taos, NMFeb 17, 1974 · N4980T · Destroyed NTSB LAX74DUM11Accident · No injuriesClosedPiper PA-34 · Santee, CANov 15, 1973 · N1025U · Substantial damage NTSB MIA74FLT03Accident · Minor injuriesClosedPiper PA-34 · Memphis, TNNov 4, 1973 · N56068 · Substantial damage NTSB DEN74AD020Accident · 2 fatalClosedPiper PA-34 · Levan, UTNov 2, 1973 · N56025 · Destroyed