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 NYC77FNC52Accident · No injuriesClosedPiper PA-20 · Thomaston, MEAug 31, 1977 · N7309K · Substantial damage NTSB LAX77FUJ59Accident · No injuriesClosedPiper PA-20 · New River, AZAug 20, 1977 · N7707K · Substantial damage NTSB ANC77DAG93Accident · No injuriesClosedPiper PA-20 · Anchorage, AKAug 15, 1977 · N7357K · Substantial damage NTSB MKC77DCJ36Accident · No injuriesClosedPiper PA-20 · Grant, NEAug 4, 1977 · N7477K · Substantial damage NTSB FTW77FRG57Accident · Serious injuriesClosedPiper PA-20 · Johnson City, TXJul 3, 1977 · N7052K · Substantial damage NTSB SEA77DYE26Accident · No injuriesClosedPiper PA-20 · Seattle, WAJun 24, 1977 · N6895K · Substantial damage NTSB ANC77DAG72Accident · No injuriesClosedPiper PA-20 · Anchorage, AKJun 2, 1977 · N6908K · Substantial damage NTSB SEA77FTA22Accident · No injuriesClosedPiper PA-20 · Ismay, MTMay 1, 1977 · N7635K · Substantial damage NTSB IAD77FID17Accident · No injuriesClosedPiper PA-20 · Suffolk, VAApr 30, 1977 · N1712A · 2 aircraft · Substantial damage NTSB OAK77DVA24Accident · No injuriesClosedPiper PA-20 · Mariposa, CAMar 11, 1977 · N1592A · Substantial damage NTSB FTW77DRJ03Accident · No injuriesClosedPiper PA-20 · Shreveport, LAFeb 13, 1977 · N7494K · Substantial damage NTSB ANC76DAH85Accident · No injuriesClosedPiper PA-20 · Anchorage, AKSep 19, 1976 · N7358K · Substantial damage NTSB ANC77DAD11Accident · No injuriesClosedPiper PA-20 · Icy Bay, AKSep 6, 1976 · N7772K · Substantial damage NTSB SEA76DYA27Accident · No injuriesClosedPiper PA-20 · Council, IDJun 15, 1976 · N1018Z · Substantial damage NTSB IAD76FLT16Accident · No injuriesClosedPiper PA-20 · Memphis, TNJun 10, 1976 · N6896K · Substantial damage NTSB ANC76DAG97Accident · No injuriesClosedPiper PA-20 · Anchorage, AKMar 20, 1976 · N7358K · Substantial damage NTSB CHI76DEP24Accident · No injuriesClosedPiper PA-20 · Baraboo, WIFeb 8, 1976 · N7354K · Substantial damage NTSB MIA76AM044Accident · 1 fatalClosedPiper PA-20 · Lighthouse Pt, FLNov 21, 1975 · N7427K · Destroyed NTSB ANC76AA035Accident · 2 fatalClosedPiper PA-20 · Talkeetna, AKSep 14, 1975 · N6965K · Destroyed NTSB ANC76DAG33Accident · No injuriesClosedPiper PA-20 · Moose Pass, AKAug 31, 1975 · N7432K · Substantial damage NTSB CHI76DEM08Accident · No injuriesClosedPiper PA-20 · Charlotte, MIAug 24, 1975 · N6993K · Substantial damage NTSB FTW76FPA04Accident · No injuriesClosedPiper PA-20 · Sherman, TXAug 9, 1975 · N6904K · Substantial damage NTSB CHI76FEC06Accident · No injuriesClosedPiper PA-20 · Tecumseh, MIAug 9, 1975 · N7041K · Substantial damage NTSB SEA76DYG06Accident · No injuriesClosedPiper PA-20 · Coeur D'Alene, IDAug 2, 1975 · N1018Z · Substantial damage NTSB SEA75DYI31Accident · No injuriesClosedPiper PA-20 · Eugene, ORJun 28, 1975 · N7013K · Substantial damage NTSB MIA75DKJ63Accident · No injuriesClosedPiper PA-20 · Columbiana, ALJun 21, 1975 · N7059K · Substantial damage NTSB ANC75DAH01Accident · Serious injuriesClosedPiper PA-20 · King Salmon, AKJun 12, 1975 · N7028K · Substantial damage NTSB ANC75DAG83Accident · No injuriesClosedPiper PA-20 · Kenai, AKApr 12, 1975 · N6959K · Substantial damage NTSB LAX75AL041Accident · 1 fatalClosedPiper PA-20 · Ramona, CAFeb 18, 1975 · N7056K · Destroyed NTSB SEA75AS032Accident · 3 fatalClosedPiper PA-20 · Drain, ORFeb 13, 1975 · N7691K · Destroyed NTSB LAX75DUG25Accident · Minor injuriesClosedPiper PA-20 · Rubidoux, CADec 29, 1974 · N7382K · Substantial damage NTSB LAX75AUM05Accident · No injuriesClosedPiper PA-20 · Santee, CASep 5, 1974 · N7387K · Substantial damage NTSB MIA75DKJ12Accident · No injuriesClosedPiper PA-20 · Bay Minette, ALAug 15, 1974 · N7311K · Substantial damage NTSB CHI74FEI46Accident · Minor injuriesClosedPiper PA-20 · Fremont, OHJun 19, 1974 · N7335K · Substantial damage NTSB MKC74DER56Accident · No injuriesClosedPiper PA-20 · Monticello, MNJun 13, 1974 · N7717K · Substantial damage NTSB ANC74DAH12Accident · No injuriesClosedPiper PA-20 · Mcgrath, AKMay 24, 1974 · N4647V · Substantial damage NTSB MKC74FCD33Accident · Minor injuriesClosedPiper PA-20 · Red Oak, IAMay 22, 1974 · N1806A · Substantial damage NTSB ANC74AA072Accident · No injuriesClosedCurtis-Wrt C-46 · Fairbanks, AKMay 13, 1974 · N1663M · 2 aircraft · Minor damage NTSB FTW74DPJ19Accident · No injuriesClosedPiper PA-20 · Woodward, OKJan 14, 1974 · N1580A · Substantial damage NTSB FTW74DPD28Accident · No injuriesClosedPiper PA-20 · Denton, TXNov 16, 1973 · N7714K · Substantial damage NTSB ANC74DAG74Accident · No injuriesClosedPiper PA-20 · Alex Lk Ldge, AKNov 12, 1973 · N7012K · Substantial damage NTSB ANC74AA044Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKNov 12, 1973 · N3872Z · 2 aircraft · Substantial damage NTSB DEN74FTC18Accident · No injuriesClosedPiper PA-20 · Cheyenne, WYOct 19, 1973 · N7657K · Substantial damage NTSB ANC74DAA14Accident · No injuriesClosedPiper PA-20 · Bettles, AKSep 22, 1973 · N1775A · Substantial damage NTSB SEA74AS017Accident · 2 fatalClosedPiper PA-20 · Oakesdale, WASep 18, 1973 · N7666K · Destroyed NTSB ANC73DAG99Accident · No injuriesClosedPiper PA-20 · Cantwell, AKMay 30, 1973 · N7721K · Substantial damage NTSB FTW73FRA25Accident · No injuriesClosedPiper PA-20 · Vidor, TXApr 25, 1973 · N7076K · Substantial damage NTSB OAK73DVD33Accident · No injuriesClosedPiper PA-20 · Concord, CAApr 22, 1973 · N7454K · Substantial damage NTSB ANC73AA040Accident · 6 fatalClosedCessna 180D · Cooper Ldg, AKFeb 4, 1973 · N3156D · 2 aircraft · Destroyed NTSB FTW73FRA16Accident · Minor injuriesClosedPiper PA-20 · Baytown, TXJan 27, 1973 · N7398K · Substantial damage