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 CHI67D0356Accident · Minor injuriesClosedPiper PA-20 · No.Jackson, OHMay 28, 1966 · N7002K · Substantial damage NTSB UNK66X0141Accident · 1 fatalClosedPiper PA-20 · San Fillipi, MexicoMay 20, 1966 · N7095K · Substantial damage NTSB MKC66F0549Accident · No injuriesClosedPiper PA-20 · Minnesota Lk, MNMay 8, 1966 · N6893K · Substantial damage NTSB CHI67D0054Accident · No injuriesClosedPiper PA-20 · Joliet, ILMay 2, 1966 · N7430K · Substantial damage NTSB NYC66A0113Accident · 3 fatalClosedPiper PA-20 · North Collins, NYApr 10, 1966 · N7361K · Destroyed NTSB NYC66F0625Accident · No injuriesClosedPiper PA-20 · Somerset, PAApr 2, 1966 · N7396K · Substantial damage NTSB MKC66D0504Accident · No injuriesClosedPiper PA-20 · Mitchell, SDMar 19, 1966 · N1591A · Substantial damage NTSB LAX66D0253Accident · No injuriesClosedPiper PA-20 · Montello, NVJan 17, 1966 · N7414K · Substantial damage NTSB ANC66D0074Accident · Minor injuriesClosedPiper PA-20 · Barrow, AKDec 5, 1965 · N6899K · Destroyed NTSB DEN66D0150Accident · No injuriesClosedPiper PA-20 · Casper, WYOct 28, 1965 · N7663K · Substantial damage NTSB MIA66F0286Accident · No injuriesClosedPiper PA-20 · Charlotte, NCOct 26, 1965 · N1512A · Substantial damage NTSB CHI66D0432Accident · No injuriesClosedPiper PA-20 · Ft Wayne, INOct 19, 1965 · N7667K · Substantial damage NTSB MIA66D0282Accident · No injuriesClosedPiper PA-20 · No Wilkesboro, NCOct 3, 1965 · N7738K · Substantial damage NTSB DEN66F0100Accident · No injuriesClosedPiper PA-20 · Akron, COSep 14, 1965 · N6969K · Substantial damage NTSB FTW66F0299Accident · No injuriesClosedPiper PA-20 · Lexington, TXSep 11, 1965 · N7752K · Destroyed NTSB ANC66D0029Accident · No injuriesClosedPiper PA-20 · Kotzebue, AKSep 8, 1965 · N7080K · Substantial damage NTSB LAX66F0072Accident · No injuriesClosedPiper PA-20 · Van Nuys, CAAug 4, 1965 · N7325K · Substantial damage NTSB CHI66F0077Accident · No injuriesClosedPiper PA-20 · Luzerne, MIJun 12, 1965 · N7411K · Destroyed NTSB ANC66D0051Accident · No injuriesClosedPiper PA-20 · Kodiak, AKJun 10, 1965 · N1563A · Substantial damage NTSB NYC65D0246Accident · No injuriesClosedPiper PA-20 · Vineland, NJJun 8, 1965 · N7018K · Substantial damage NTSB CHI66F0074Accident · No injuriesClosedPiper PA-20 · Galesburg, ILJun 6, 1965 · N7622K · Substantial damage NTSB MKC65F0143Accident · Minor injuriesClosedPiper PA-20 · Emporia, KSMay 26, 1965 · N1560A · Destroyed NTSB SEA65F0065Accident · No injuriesClosedPiper PA-20 · Othello, WAMay 25, 1965 · N7092K · Substantial damage NTSB LAX65F0086Accident · No injuriesClosedPiper PA-20 · Huntington Bc, CAMay 25, 1965 · N7336K · Substantial damage NTSB CHI65F0180Accident · Minor injuriesClosedPiper PA-20 · Greenville, OHMay 24, 1965 · N10199 · Substantial damage NTSB ANC65D0013Accident · No injuriesClosedPiper PA-20 · Yanert Valley, AKMay 24, 1965 · N7343K · Substantial damage NTSB LAX66D0026Accident · No injuriesClosedPiper PA-20 · Corona, CAMay 6, 1965 · N7013K · Substantial damage NTSB DEN65F0064Accident · No injuriesClosedPiper PA-20 · Ajo, AZApr 18, 1965 · N1567A · Substantial damage NTSB SEA65F0039Accident · No injuriesClosedPiper PA-20 · Ontario, ORApr 17, 1965 · N1561A · Substantial damage NTSB NYC65D0162Accident · No injuriesClosedPiper PA-20 · Lakewood, NJMar 30, 1965 · N7641K · Substantial damage NTSB MKC65A0054Accident · 3 fatalClosedPiper PA-20 · Johnson, KSMar 20, 1965 · N3584A · Destroyed NTSB MKC65D0036Accident · No injuriesClosedPiper PA-20 · Dawson, IAMar 7, 1965 · N7711K · Substantial damage NTSB OAK65A0049Accident · 3 fatalClosedPiper PA20 · San Carlos, CAJan 9, 1965 · N7459K · Destroyed NTSB MKC65F0031Accident · No injuriesClosedPiper PA-20 · Bemidji, MNJan 4, 1965 · N7020K · Substantial damage NTSB MIA65 0063Accident · 1 fatalClosedPiper PA-20 · Batesville, MSDec 13, 1964 · N7091K · Destroyed NTSB UNK65X0802Accident · No injuriesClosedPiper PA20 · Wainwright, AKNov 22, 1964 · N7763K · Substantial damage NTSB UNK65X0533Accident · No injuriesClosedPiper PA20 · Half Moon Bay, CANov 2, 1964 · N7719K · Substantial damage NTSB UNK65X0404Accident · No injuriesClosedPiper PA20 · Marana, AZOct 24, 1964 · N1567A · Substantial damage NTSB UNK65X0193Accident · No injuriesClosedPiper PA20 · Woods Cross, UTOct 8, 1964 · N7783K · Substantial damage NTSB UNK65X0181Accident · No injuriesClosedPiper PA20 · Yakima, WAOct 7, 1964 · N7754K · Substantial damage NTSB UNK64X4142Accident · No injuriesClosedPiper PA20 · Cleveland, OHSep 25, 1964 · N7667K · Substantial damage NTSB UNK64X4137Accident · No injuriesClosedPiper PA20 · Woods Cross, UTSep 25, 1964 · N7414K · Substantial damage NTSB UNK64X3840Accident · No injuriesClosedPiper PA20 · Grove City, MNSep 7, 1964 · N7717K · Substantial damage NTSB UNK64X3785Accident · No injuriesClosedPiper PA20 · Harrisonburg, VASep 5, 1964 · N7014K · Substantial damage NTSB UNK64X3267Accident · No injuriesClosedPiper PA20 · Tazlina, AKAug 8, 1964 · N6948K · Substantial damage NTSB UNK64X3035Accident · No injuriesClosedPiper PA-20 · Nucia, COJul 25, 1964 · N1561A · Substantial damage NTSB UNK64X2675Accident · Serious injuriesClosedPiper PA20 · Shelby, OHJul 5, 1964 · N7063K · Destroyed NTSB UNK64X2522Accident · No injuriesClosedPiper PA20 · Akron, COJun 27, 1964 · N1573A · Substantial damage NTSB UNK64X2409Accident · No injuriesClosedPiper PA20 · Ft Leonardwood, MOJun 21, 1964 · N7089K · Substantial damage NTSB UNK64X1988Accident · No injuriesClosedPiper PA20 · Center, COMay 28, 1964 · N6978K · Substantial damage