Skip to content

NTSB investigations: Piper PA-12

817 cases on aircraft the registry lists as Piper PA-12. 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 ('7101202')) 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 ('7101202'))
  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 ('7101202'))
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 MKC74FTG16Accident · Minor injuriesClosedPiper PA-12 · Oakes, NDJun 1, 1974 · N3896M · Substantial damage NTSB CHI74DEE69Accident · No injuriesClosedPiper PA-12 · Harvard, ILApr 20, 1974 · N4225M · Substantial damage NTSB ANC74AA060Accident · 2 fatalClosedPiper PA-12 · Kenai, AKMar 16, 1974 · N3692N · Destroyed NTSB SEA74DYE37Accident · No injuriesClosedPiper PA-12 · Blakely Isle, WAFeb 8, 1974 · N4043H · Substantial damage NTSB FTW74DRJ23Accident · No injuriesClosedPiper PA-12 · Jonesville, LAJan 13, 1974 · N4252M · Substantial damage NTSB ANC74DAG84Accident · No injuriesClosedPiper PA-12 · Farewell, AKJan 1, 1974 · N2537M · Substantial damage NTSB ANC74DAG83Accident · Minor injuriesClosedPiper PA-12 · Anchorage, AKDec 30, 1973 · N3029M · Substantial damage NTSB ANC74DAG77Accident · No injuriesClosedPiper PA-12 · Beluga, AKNov 10, 1973 · N2368M · Substantial damage NTSB ANC74DAG59Accident · No injuriesClosedPiper PA-12 · Anchorage, AKSep 25, 1973 · N4444M · Substantial damage NTSB IAD74FIA05Accident · No injuriesClosedPiper PA-12 · Front Royal, VASep 16, 1973 · N2547M · Substantial damage NTSB ANC74DAG43Accident · No injuriesClosedPiper PA-12 · Skwentna, AKSep 9, 1973 · N3241M · Substantial damage NTSB ANC74DAG36Accident · No injuriesClosedPiper PA-12 · Alexander Lk, AKSep 6, 1973 · N2899M · Substantial damage NTSB ANC74DAG27Accident · No injuriesClosedPiper PA-12 · Anchorage, AKAug 26, 1973 · N4112M · Substantial damage NTSB NYC74FNA11Accident · Serious injuriesClosedPiper PA-12 · Greene, RIAug 24, 1973 · N4029H · Substantial damage NTSB ANC74DAG19Accident · No injuriesClosedPiper PA-12 · Port Lions, AKAug 12, 1973 · N4008M · Substantial damage NTSB IAD74DKM05Accident · No injuriesClosedPiper PA-12 · Indian Trail, NCJul 22, 1973 · N3289M · Substantial damage NTSB SEA74DTI02Accident · No injuriesClosedPiper PA-12 · Ennis, MTJul 6, 1973 · N78495 · Substantial damage NTSB ANC73DAH03Accident · Minor injuriesClosedPiper PA-12 · Soldotna, AKJun 10, 1973 · N92527 · Substantial damage NTSB SEA73DYC34Accident · No injuriesClosedPiper PA-12 · Sandy, ORJun 6, 1973 · N7754H · Substantial damage NTSB MIA73DKJ67Accident · No injuriesClosedPiper PA-12 · Brownsboro, ALJun 3, 1973 · N2849M · Substantial damage NTSB LAX73DUG55Accident · No injuriesClosedPiper PA-12 · Rialto, CAMay 27, 1973 · N2555M · Substantial damage NTSB ANC73FAA22Accident · No injuriesClosedPiper PA-12 · Delta Junctn, AKMay 26, 1973 · N2874M · Substantial damage NTSB MIA73DLD83Accident · Minor injuriesClosedPiper PA-12 · Basinger, FLMay 20, 1973 · N3228M · Substantial damage NTSB MKC73DCD66Accident · No injuriesClosedPiper PA-12 · Davenport, IAMay 13, 1973 · N4014M · Substantial damage NTSB MKC73AK060Accident · 2 fatalClosedPiper PA-12 · Bock, MNApr 8, 1973 · N7705H · Destroyed NTSB ANC73DAG82Accident · No injuriesClosedPiper PA-12 · Glennallen, AKMar 30, 1973 · N92507 · Substantial damage NTSB MIA73DLG40Accident · No injuriesClosedPiper PA-12 · Kinards, SCMar 27, 1973 · N92536 · Substantial damage NTSB IAD73A1001Accident · 1 fatalClosedPiper PA-12 · Selbyville, DEMar 13, 1973 · N2454M · Destroyed NTSB MIA73FKT33Accident · No injuriesClosedPiper PA-12 · Opa Locka, FLDec 5, 1972 · N7955H · Substantial damage NTSB ANC73DAG48Accident · No injuriesClosedPiper PA-12 · Anchorage, AKOct 7, 1972 · N4158M · Substantial damage NTSB DEN73DQA17Accident · Minor injuriesClosedPiper PA-12 · Glencoe, NMSep 17, 1972 · N7964C · Substantial damage NTSB LAX73DUG16Accident · No injuriesClosedPiper PA-12 · Idyllwild, CASep 6, 1972 · N4166M · Substantial damage NTSB ANC73DAA09Accident · No injuriesClosedPiper PA-12 · North Pole, AKAug 27, 1972 · N78486 · Substantial damage NTSB ANC73DAG32Accident · No injuriesClosedPiper PA-12 · Prt Alsworth, AKAug 25, 1972 · N2526M · Substantial damage NTSB ANC73AA018Accident · 3 fatalClosedPiper PA-12 · Kenai, AKAug 25, 1972 · N92505 · Destroyed NTSB MKC73DCD20Accident · Minor injuriesClosedPiper PA-12 · Maysville, IAAug 13, 1972 · N7847H · Substantial damage NTSB CHI73FEE11Accident · Serious injuriesClosedPiper PA-12 · Maple Park, ILAug 6, 1972 · N7774H · Substantial damage NTSB ANC73DAG08Accident · No injuriesClosedPiper PA-12 · Iliamna, AKAug 6, 1972 · N4084M · Substantial damage NTSB ANC73DAA08Accident · No injuriesClosedPiper PA-12 · Tok Junctn, AKAug 6, 1972 · N3957M · Substantial damage NTSB NYC73FHD04Accident · Minor injuriesClosedPiper PA-12 · Wildwood, NJJul 23, 1972 · N3721M · Destroyed NTSB SEA72DYA41Accident · No injuriesClosedPiper PA-12 · Middleton, IDJun 28, 1972 · N4401M · Substantial damage NTSB NYC72DNA48Accident · Minor injuriesClosedPiper PA-12 · Falmouth, MAJun 26, 1972 · N2468M · Substantial damage NTSB NYC72FFJ43Accident · Serious injuriesClosedPiper PA-12 · Geneseo, NYJun 11, 1972 · N4029M · Destroyed NTSB NYC72DIA22Accident · No injuriesClosedPiper PA-12 · Warrenton, VAMay 19, 1972 · N7599H · Substantial damage NTSB FTW72DRD27Accident · No injuriesClosedPiper PA-12 · Boothville, LAMay 9, 1972 · N3666M · Substantial damage NTSB ANC72DAA31Accident · Minor injuriesClosedPiper PA-12 · Timber Lk, AKMay 6, 1972 · N3571M · Substantial damage NTSB SEA72FYC40Accident · No injuriesClosedPiper PA-12 · Oregon City, ORMay 5, 1972 · N2954M · Substantial damage NTSB NYC72FKM32Accident · No injuriesClosedPiper PA-12 · Rockingham, NCApr 15, 1972 · N92792 · Substantial damage NTSB MKC72DER49Accident · No injuriesClosedPiper PA-12 · Duluth, MNApr 1, 1972 · N3752M · Substantial damage NTSB MIA72AM082Accident · 2 fatalClosedPiper PA-12 · Missing AircraftFeb 10, 1972 · N98991 · Destroyed