Fatal NTSB investigations: Piper PA-24

78 cases on aircraft the registry lists as Piper PA-24. 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.

Cases, 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_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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102402'))
  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.

NTSB MIA71AM056Accident · 1 fatalClosedPiper PA-24 · Barney, GAJan 5, 1971 · N5122P · DestroyedNTSB SEA71AS028Accident · 1 fatalClosedPiper PA-24 · Kimberly, IDNov 26, 1970 · N6703P · DestroyedNTSB CHI71AC034Accident · 4 fatalClosedPiper PA-24 · Weston, WINov 18, 1970 · N7880P · DestroyedNTSB ANC71AA023Accident · 1 fatalClosedPiper PA-24 · Fairbanks, AKOct 9, 1970 · N5016P · DestroyedNTSB SEA70A0016Accident · 3 fatalClosedPiper PA-24 · Newberg, OROct 17, 1969 · N7315P · Substantial damageNTSB FTW69A0084Accident · 1 fatalClosedPiper PA-24 · Boydville, ARMay 30, 1969 · N5375P · DestroyedNTSB CHI69A0084Accident · 4 fatalClosedPiper PA-24 · Aledo, ILMar 30, 1969 · N6346P · DestroyedNTSB NYC69A0087Accident · 4 fatalClosedPiper PA-24 · Ogletown, PAMar 14, 1969 · N7183P · DestroyedNTSB FTW69A0060Accident · 4 fatalClosedCessna 150 · Manvel, TXFeb 26, 1969 · N3488J · 2 aircraft · Substantial damageNTSB FTW69A0036Accident · 3 fatalClosedPiper PA-24 · Lampasas, TXNov 27, 1968 · N8153P · DestroyedNTSB NYC69A0047Accident · 2 fatalClosedPiper PA-24 · Fleming, PAOct 26, 1968 · N5025P · DestroyedNTSB MIA69A0010Accident · 2 fatalClosedPiper PA-24 · Bradenton, FLAug 26, 1968 · N7413P · DestroyedNTSB MKC68A0059Accident · 1 fatalClosedCessna 150 · Kansas City, MOApr 10, 1968 · N6386S · 2 aircraft · Substantial damageNTSB DIA68A0042Accident · 2 fatalClosedPiper PA-24 · Robbinsville, NCDec 22, 1967 · N6238P · DestroyedNTSB NYC67A0079Accident · 2 fatalClosedPiper PA-24 · Spencer, WVNov 11, 1966 · N5834P · DestroyedNTSB CHI67A0026Accident · 2 fatalClosedPiper PA-24 · New Lexingtn, OHAug 22, 1966 · N7859P · DestroyedNTSB MKC67A0009Accident · 4 fatalClosedPiper PA-24 · Hunter, KSAug 5, 1966 · N6161P · DestroyedNTSB MIA66A0106Accident · 2 fatalClosedPiper PA-24 · Burnsville, NCMay 22, 1966 · N7325P · DestroyedNTSB SEA66A0045Accident · 2 fatalClosedPiper PA-24 · New Plymouth, IDFeb 24, 1966 · N7831P · DestroyedNTSB MIA66A0076Accident · 2 fatalClosedPiper PA-24 · Steele, ALJan 1, 1966 · N6966P · DestroyedNTSB DEN66A0009Accident · 3 fatalClosedPiper PA-24 · Ruidoso, NMAug 13, 1965 · N7960P · DestroyedNTSB NYC65A0156Accident · 1 fatalClosedCessna 170 · Neffsville, PAJun 27, 1965 · N4080V · 2 aircraft · Minor damageNTSB NYC65A0128Accident · 2 fatalClosedPiper PA-24 · Johnstown, PAApr 17, 1965 · N7397P · DestroyedNTSB CHI65A0088Accident · 2 fatalClosedPiper PA-24 · Flint, MIApr 6, 1965 · N6356P · DestroyedNTSB UNK65X0842Accident · 1 fatalClosedPiper PA-24 · El Dorado, ARNov 26, 1964 · N8171P · DestroyedNTSB UNK64X3095Accident · 1 fatalClosedPiper PA-24 · Elizabethtown, KYJul 28, 1964 · N7529P · DestroyedNTSB UNK64X0764Accident · 1 fatalClosedPiper PA22 · Birmingham, MIFeb 29, 1964 · N5608P · DestroyedNTSB LAX94LA336Accident · 4 fatalLimited investigationClosedPiper PA24-180 · Bridgeport, CAIn-flight collision with terrain for unknown reason(s).Jul 20, 1962 · N5069P · Destroyed