Skip to content

NTSB investigations: Piper PA-20

359 cases on aircraft the registry lists as Piper PA-20. 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 ('7102002')) 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 ('7102002'))
  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 ('7102002'))
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 LAX69D0342Accident · No injuriesClosedPiper PA-20 · San Diego, CAMay 4, 1969 · N7387K · Substantial damage NTSB DEN69D0223Accident · Minor injuriesClosedPiper PA-20 · Stmboat Sprg, COApr 29, 1969 · N7722K · Substantial damage NTSB SEA69D0234Accident · No injuriesClosedPiper PA-20 · Wilbur, WAApr 3, 1969 · N7666K · Substantial damage NTSB SEA69D0227Accident · No injuriesClosedPiper PA-20 · Chehalis, WAMar 30, 1969 · N7028K · Substantial damage NTSB ANC69D0099Accident · No injuriesClosedPiper PA-20 · Copper Centr, AKNov 5, 1968 · N5591H · Substantial damage NTSB NYC69D0224Accident · No injuriesClosedPiper PA-20 · Warrington, PAOct 26, 1968 · N7333K · Substantial damage NTSB ANC69D0073Accident · No injuriesClosedPiper PA-20 · Nabesna, AKSep 20, 1968 · N7755K · Destroyed NTSB ANC69D0036Accident · Serious injuriesClosedPiper PA-20 · Dillingham, AKSep 3, 1968 · N745R · Substantial damage NTSB ANC69D0030Accident · Minor injuriesClosedPiper PA-20 · Nome, AKAug 19, 1968 · N7440K · Substantial damage NTSB ANC69D0046Accident · Minor injuriesClosedPiper PA-20S · Talkeetna, AKAug 12, 1968 · N716SA · Destroyed NTSB ANC69F0007Accident · No injuriesClosedPiper PA-20 · Cordova, AKAug 8, 1968 · N7473K · Substantial damage NTSB NYC69D0176Accident · No injuriesClosedPiper PA-20 · Conneaut Lake, PAJul 20, 1968 · N1580A · Substantial damage NTSB MKC69F0040Accident · No injuriesClosedPiper PA-20 · Fort Calhoun, NEJul 13, 1968 · N7044K · Substantial damage NTSB MKC69D0143Accident · No injuriesClosedPiper PA-20 · Gravois Mills, MOJul 5, 1968 · N7075K · Substantial damage NTSB SEA69F0064Accident · No injuriesClosedPiper PA-20 · Redmond, ORJun 8, 1968 · N7725K · Substantial damage NTSB DEN69F0018Accident · No injuriesClosedPiper PA-20 · Ogden, UTMay 29, 1968 · N7767K · Substantial damage NTSB LAX69D0008Accident · No injuriesClosedPiper PA-20 · Big Bear Lake, CAMay 20, 1968 · N7060K · Substantial damage NTSB MIA68D0498Accident · No injuriesClosedPiper PA-20 · Picayune, MSApr 21, 1968 · N7472K · Substantial damage NTSB NYC68D0423Accident · No injuriesClosedPiper PA-20 · Blossvale, NYMar 26, 1968 · N5540A · Substantial damage NTSB MKC68D0448Accident · No injuriesClosedPiper PA-20 · Chadron, NEFeb 4, 1968 · N2274A · Substantial damage NTSB DIA68D0121Accident · No injuriesClosedPiper PA-20 · Bat Cave, NCDec 1, 1967 · N7620K · Substantial damage NTSB NYC68F0212Accident · Serious injuriesClosedPiper PA-20 · Belford, NJSep 30, 1967 · N7741K · Destroyed NTSB ANC68F0055Accident · No injuriesClosedPiper PA-22 · Kenai, AKSep 22, 1967 · N8520D · Substantial damage NTSB NYC68F0124Accident · No injuriesClosedPiper PA-20S · Bucksport, MEAug 30, 1967 · N1835A · Substantial damage NTSB NYC68D0129Accident · No injuriesClosedPiper PA-20 · Waterville, MEAug 23, 1967 · N7623K · Substantial damage NTSB LAX68D0084Accident · No injuriesClosedPiper PA-20 · Upland, CAAug 9, 1967 · N7754K · Substantial damage NTSB FTW68D0080Accident · No injuriesClosedPiper PA-20 · Friendswood, TXJun 21, 1967 · N7756K · Substantial damage NTSB CHI68F0147Accident · No injuriesClosedPiper PA-20 · Spring Port, MIJun 20, 1967 · N6971K · Substantial damage NTSB SEA68F0008Accident · No injuriesClosedPiper PA-20A · Newport, WAJun 9, 1967 · N2338A · Substantial damage NTSB FTW67D0616Accident · No injuriesClosedPiper PA-20 · Athens, LAMay 18, 1967 · N7057K · Substantial damage NTSB MKC67F0506Accident · No injuriesClosedPiper PA-20 · Arcadia, NEApr 22, 1967 · N6905K · Substantial damage NTSB DIA67F0080Accident · No injuriesClosedPiper PA-20 · Benson, NCApr 21, 1967 · N1508A · Substantial damage NTSB CHI67D0580Accident · No injuriesClosedPiper PA-20 · Mt Vernon, ILMar 18, 1967 · N7089K · Substantial damage NTSB MKC67F0442Accident · No injuriesClosedPiper PA-20 · Wimbledon, NDJan 11, 1967 · N5598H · Substantial damage NTSB CHI67F0409Accident · Serious injuriesClosedPiper PA-20 · Prt Columbus, OHJan 5, 1967 · N7371K · Substantial damage NTSB NYC67F0400Accident · No injuriesClosedPiper PA-18 · Augusta, MEDec 18, 1966 · N1516A · Substantial damage NTSB LAX67F0233Accident · No injuriesClosedPiper PA-20 · Yuma, AZDec 11, 1966 · N5596H · Substantial damage NTSB MKC67D0347Accident · No injuriesClosedPiper PA-20 · Philip, SDDec 8, 1966 · N1510A · Substantial damage NTSB MKC67F0320Accident · No injuriesClosedPiper PA-20 · Paynesville, MNDec 3, 1966 · N7428K · Substantial damage NTSB NYC67F0347Accident · Minor injuriesClosedPiper PA-20 · Dayville, CTOct 29, 1966 · N7337K · Substantial damage NTSB NYC67D0323Accident · No injuriesClosedPiper PA-20 · Finleyville, PAOct 2, 1966 · N1564A · Substantial damage NTSB MIA67D0171Accident · No injuriesClosedPiper PA-20 · New Smyrna Be, FLAug 15, 1966 · N1645A · Substantial damage NTSB CHI67F0230Accident · No injuriesClosedPiper PA-20 · Ionia, MIAug 6, 1966 · N7349K · Substantial damage NTSB MKC67A0010Accident · 2 fatalClosedPiper PA-20 · Kingsdown, KSAug 5, 1966 · N7602K · Destroyed NTSB ANC67D0050Accident · No injuriesClosedPiper PA-20 · Port Alswort, AKAug 2, 1966 · N7006K · Destroyed NTSB LAX67D0062Accident · No injuriesClosedPiper PA-20 · Apple Valley, CAJul 30, 1966 · N7624K · Substantial damage NTSB SEA67A0007Accident · 3 fatalClosedPiper PA-20 · Glide, ORJul 25, 1966 · N6930K · Destroyed NTSB ANC67D0047Accident · No injuriesClosedPiper PA-20 · Aleknagik, AKJul 10, 1966 · N7096K · Substantial damage NTSB DEN67D0050Accident · No injuriesClosedPiper PA-20 · Denver, COJul 7, 1966 · N7371K · Substantial damage NTSB ANC67D0036Accident · No injuriesClosedPiper PA-20 · Dillingham, AKJun 27, 1966 · N7625K · Substantial damage