Piper PA-20
NTSB investigations · 359
Matched to the registry by N-number and event date, newest first.
Query with SQL
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('7102002')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 UNK64X1828Accident · No injuriesClosedPiper PA20 · Yanert Val, AKNTSB UNK64X1725Accident · No injuriesClosedPiper PA20 · Paxson, AKNTSB UNK64X1265Accident · No injuriesClosedPiper PA20 · Hays, KSNTSB UNK64X1208Accident · No injuriesClosedPiper PA20 · King Cove, AKNTSB UNK64X1111Accident · No injuriesClosedPiper PA20 · Portage, AKNTSB UNK64X0958Accident · No injuriesClosedPiper PA20 · Anson, TXNTSB UNK64X0892Accident · No injuriesClosedPiper PA20 · Ft Dodge, IANTSB UNK64X0746Accident · No injuriesClosedPiper PA20 · Mountains, AKNTSB UNK64X0425Accident · No injuriesClosedPiper PA20 · Glendo, WY
Back to Piper PA-20