Skip to content

NTSB investigations: Piper PA-32-260

693 cases on aircraft the registry lists as Piper PA-32-260. 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 ('7103206')) 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 ('7103206'))
  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 ('7103206'))
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 MIA76FLG02Accident · No injuriesClosedPiper PA-32 · Beech Island, SCJul 4, 1975 · N121MB · Substantial damage NTSB ANC75AA089Accident · No injuriesClosedPiper PA-32 · Nuiqsut, AKJun 14, 1975 · N3728W · Substantial damage NTSB MIA75DLD74Accident · No injuriesClosedPiper PA-32 · Groveland, FLMay 12, 1975 · N4799S · Substantial damage NTSB MIA75DKT75Accident · No injuriesClosedPiper PA-32 · Stuart, FLApr 28, 1975 · N7728J · Substantial damage NTSB MIA75DLA39Accident · No injuriesClosedPiper PA-32 · Gainesville, FLApr 27, 1975 · N7703J · Substantial damage NTSB NYC75FFJ22Accident · No injuriesClosedPiper PA-32 · Ovid, NYApr 18, 1975 · N3337W · Substantial damage NTSB CHI75DEC37Accident · No injuriesClosedPiper PA-32 · Ann Arbor, MIFeb 20, 1975 · N3939W · Substantial damage NTSB MIA75FLD49Accident · No injuriesClosedPiper PA-32 · Nw Port Richey, FLJan 21, 1975 · N5592J · 2 aircraft · Substantial damage NTSB LAX75AL036Accident · 2 fatalClosedPiper PA-32 · Show Low, AZJan 9, 1975 · N3883W · Destroyed NTSB IAD75AI037Accident · 2 fatalClosedPiper PA-32 · Laytonsville, MDDec 29, 1974 · N3840W · Substantial damage NTSB OAK75AP027Accident · 6 fatalClosedPiper PA-32 · Hlf Moon By, CADec 27, 1974 · N7705J · Destroyed NTSB NYC75DHD28Accident · No injuriesClosedPiper PA-32 · West Chester, PADec 26, 1974 · N56982 · Substantial damage NTSB CHI75FEI36Accident · Minor injuriesClosedPiper PA-32 · Akron, OHDec 22, 1974 · N56754 · Substantial damage NTSB SEA75AS023Accident · 4 fatalClosedCessna 150L · Mt Vernon, WANov 29, 1974 · N11383 · 2 aircraft · Destroyed NTSB FTW75AF027Accident · 1 fatalClosedPiper PA-32 · Huntsville, TXOct 23, 1974 · N3928W · Destroyed NTSB FTW75ORG49Accident · No injuriesClosedPiper PA-32 · Agualeguas, MexicoOct 11, 1974 · N3470W · Destroyed NTSB LAX75OL005Accident · No injuriesClosedPiper PA-32 · Ban.Izabal, GuatemalaSep 29, 1974 · N3204W · Substantial damage NTSB FTW75DPD08Accident · No injuriesClosedPiper PA-32 · Abilene, TXSep 27, 1974 · N8600N · Substantial damage NTSB MIA75FKJ27Accident · No injuriesClosedPiper PA-32 · Tarrant City, ALSep 23, 1974 · N41481 · Substantial damage NTSB MKC75DCJ28Accident · No injuriesClosedPiper PA-32 · York, NESep 15, 1974 · N3332W · Substantial damage NTSB CHI75AC023Accident · 6 fatalClosedPiper PA-32 · Mcconnelsvle, OHSep 1, 1974 · N5503J · Destroyed NTSB FTW75AF012Accident · 3 fatalClosedPiper PA-32 · Lytle, TXAug 29, 1974 · N3349W · Destroyed NTSB SEA75DVC15Accident · No injuriesClosedPiper PA-32 · Condon, ORAug 17, 1974 · N3623W · Substantial damage NTSB MIA75DKJ10Accident · No injuriesClosedPiper PA-32 · Grove Hill, ALAug 4, 1974 · N3916W · Substantial damage NTSB NYC75AN008Accident · Serious injuriesClosedPiper PA-32 · Manchester, VTJul 20, 1974 · N3804W · Destroyed NTSB FTW75FRD05Accident · No injuriesClosedPiper PA-32 · Port Barre, LAJul 20, 1974 · N3765W · Substantial damage NTSB MIA75DKT05Accident · No injuriesClosedPiper PA-32 · Bimini (Atlantic Ocean)Jul 11, 1974 · N3379W · Destroyed NTSB ANC74AA082Accident · No injuriesClosedPiper PA-32 · Anchorage, AKJun 17, 1974 · N400TH · Substantial damage NTSB IAD74AI064Accident · 2 fatalClosedPiper PA-32 · Hayesville, NCMay 26, 1974 · N3764W · Destroyed NTSB MIA74DKG76Accident · No injuriesClosedPiper PA-32 · Winder, GAApr 28, 1974 · N3420W · Substantial damage NTSB IAD74AI057Accident · 1 fatalClosedPiper PA-32 · Luray, VAApr 24, 1974 · N5507J · Destroyed NTSB NYC74DFA26Accident · No injuriesClosedPiper PA-28 · Camp Drum, NYApr 11, 1974 · N5545J · Substantial damage NTSB UNK74X0103Incident · No injuriesClosedPiper PA-32 · Montego B, JamaicaApr 5, 1974 · N5559J · Minor damage NTSB FTW74FPA19Accident · 1 fatalClosedPiper PA-32 · Garland, TXMar 27, 1974 · N3775W · Destroyed NTSB CHI74DEE58Accident · No injuriesClosedPiper PA-32 · Dekalb, ILFeb 26, 1974 · N4803S · Substantial damage NTSB CHI74DEP35Accident · No injuriesClosedPiper PA-32 · Racine, WIFeb 17, 1974 · N3303W · Substantial damage NTSB IAD74DKM40Accident · Minor injuriesClosedPiper PA-32 · Cherokee, NCFeb 16, 1974 · N56508 · Substantial damage NTSB CHI74FEM38Accident · No injuriesClosedPiper PA-32 · Pellston, MIFeb 5, 1974 · N3911W · Substantial damage NTSB CHI74FEI26Accident · Minor injuriesClosedPiper PA-32 · Cleveland, OHJan 29, 1974 · N3793W · Substantial damage NTSB CHI74AC062Accident · 1 fatalClosedPiper PA-32 · Chicago, ILJan 17, 1974 · N3998W · Destroyed NTSB MKC74DCA19Accident · No injuriesClosedPiper PA-32 · Memphis, MOJan 16, 1974 · N3677W · Substantial damage NTSB MKC74IK026Incident · No injuriesClosedPiper PA-32 · Readsville, MONov 26, 1973 · N3977W · Minor damage NTSB MIA74AM045Accident · 1 fatalClosedPiper PA-32 · Evergreen, ALNov 20, 1973 · N8665N · Destroyed NTSB MKC74AK024Accident · No injuriesClosedPiper PA-32 · Topeka, KSNov 16, 1973 · N3412W · Substantial damage NTSB CHI74FEK08Accident · Minor injuriesClosedPiper PA-32 · Warsaw, OHNov 4, 1973 · N4280T · Substantial damage NTSB MKC74FCA16Accident · Serious injuriesClosedPiper PA-32 · Rolla, MOOct 26, 1973 · N3222W · Destroyed NTSB DEN74FTE25Accident · Serious injuriesClosedPiper PA-32 · Aspen, COOct 7, 1973 · N3234W · Substantial damage NTSB FTW74FPD10Accident · Minor injuriesClosedPiper PA-32 · South Lake, TXSep 13, 1973 · N3301W · Destroyed NTSB MIA74DLA11Accident · No injuriesClosedPiper PA-32 · Chipley, FLAug 29, 1973 · N5587J · Substantial damage NTSB FTW74FRJ04Accident · No injuriesClosedPiper PA-32 · Minden, LAAug 11, 1973 · N3691W · Substantial damage