Skip to content

Fatal NTSB investigations: Piper PA-28

25 cases on aircraft the registry lists as Piper PA-28. 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 per year

19642026

Where

Latest cases

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."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 ('7102801')) 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.\"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 ('7102801'))
  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."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 ('7102801'))
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 WPR13FA058Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Tacna, AZThe pilot’s failure to maintain airplane control. Contributing to the accident was the pilot’s impairment due to acute psychosis with paranoid thoughts.Nov 23, 2012 · N5076W · Substantial damage NTSB FTW02FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Ben Wheeler, TXThe pilot's failure to maintain aircraft control for undetermined reasons.Nov 22, 2001 · N6321W · Destroyed NTSB CHI98FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Faribault, MNwas the pilot's patial incapacitation due to carbon monoxide poisoning. A factor associated with this accident was the mechanic's inadequate inspection of the airplane's muffler and inadequate preflight planning and preparation by the pilot.Jan 26, 1998 · N5099W · Destroyed NTSB MIA95WA025Accident · 3 fatalForeign investigationPiper PA28 · St. Vincent, SpainNov 21, 1994 · N5082W · Destroyed NTSB CHI92FA095Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Burlington, ILThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions in cruise flight. Related factors are the pilot's inadequate weather evaluation, the low ceiling and reduced visibility (fog).Feb 23, 1992 · N5309W · Destroyed NTSB ATL86FA120Accident · 4 fatalField investigationFinal reportPiper PA-28-160 · Winton, NCBefore the flt, the student plt & passengers had been socializing & drinking beer. At aprx 0200 EDT, while at a friend'shome near murfreesboro, NC, they decided to go flying. At about 0300, an acft was observed to fly over the friend's home at low alt, then…Apr 29, 1986 · N5258W · Destroyed NTSB LAX75AL049Accident · 2 fatalClosedPiper PA-28 · Yuma, AZMar 11, 1975 · N5133W · Destroyed NTSB OAK74AP067Accident · 2 fatalClosedPiper PA-28 · Glen Ellen, CAJun 14, 1974 · N8762W · Destroyed NTSB MIA73AM015Accident · 1 fatalClosedPiper PA-28 · Detroit, ALNov 18, 1972 · N15431 · Substantial damage NTSB CHI72AC088Accident · 1 fatalClosedPiper PA-28 · Richfield, OHMay 13, 1972 · N5112S · Destroyed NTSB LAX71AL064Accident · 1 fatalClosedPiper PA-28 · Phoenix, AZApr 30, 1971 · N7342W · Destroyed NTSB MIA71AM052Accident · 2 fatalClosedPiper PA-28 · Savannah, GADec 14, 1970 · N4115J · Destroyed NTSB MIA69A0049Accident · 4 fatalClosedPiper PA-28 · Cross City, FLAug 30, 1968 · N5284W · Destroyed NTSB DIA68A0049Accident · 4 fatalClosedPiper PA-28 · Myersville, MDMay 15, 1968 · N9215W · Destroyed NTSB FTW68A0024Accident · 3 fatalClosedPiper PA-28 · Yoakum, TXSep 2, 1967 · N8493W · Destroyed NTSB MIA68A0002Accident · 4 fatalClosedPiper PA-28 · Mayaguez, PRJul 2, 1967 · N5100W · Destroyed NTSB DEN67A0043Accident · 1 fatalClosedPiper PA-28 · Brigham City, UTJan 31, 1967 · N8317R · Destroyed NTSB SEA67A0026Accident · 4 fatalClosedPiper PA-28 · Alberton, MTSep 20, 1966 · N5182W · Destroyed NTSB MKC66A0028Accident · 1 fatalClosedPiper PA-28 · Fairfax, MNOct 19, 1965 · N7619W · Destroyed NTSB FTW65A0097Accident · 4 fatalClosedPiper PA-28 · Laredo, TXMar 27, 1965 · N7583W · Destroyed NTSB OAK65A0055Accident · 4 fatalClosedPiper PA28 · Hayward, CAFeb 13, 1965 · N7513W · Destroyed NTSB UNK65X1279Accident · 4 fatalClosedPiper PA-28 · Marheim, GeorgiaJan 13, 1965 · N7756W · Destroyed NTSB UNK64X3386Accident · 2 fatalClosedPiper PA-28 · Lake Athabaska, CanadaAug 15, 1964 · N5343W · Destroyed NTSB UNK64X2295Accident · 1 fatalClosedPiper PA-28 · Monterey, CAJun 14, 1964 · N5384W · Destroyed NTSB UNK64X1084Accident · 4 fatalClosedPiper PA-28 · Auburn, INMar 28, 1964 · N7551W · Destroyed