Skip to content

Fatal NTSB investigations: Piper PA-28-160

43 cases on aircraft the registry lists as Piper PA-28-160. 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 ('7102806')) 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 ('7102806'))
  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 ('7102806'))
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 ERA13FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Parkton, NCThe failure of the instrument-rated pilot to maintain control of the airplane while in instrument meteorological conditions after reporting a gyro malfunction. Contributing to the accident was the loss of primary gyro flight instruments due to the failure of…Dec 16, 2012 · N5714W · Substantial damage NTSB ERA09LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Indiana, PAThe pilot's decision to attempt VFR flight in IMC conditions, resulting in a collision with trees during a go-around.Jan 4, 2009 · N5212W · Substantial damage NTSB ATL02FA063Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Laurens, SCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with terrain. Factors were low clouds and dark-night.Mar 9, 2002 · N160D · Destroyed NTSB ATL01WA015Accident · 2 fatalForeign investigationPiper PA-28-160 · Alaj Uela, Costa RicaDec 11, 2000 · N5306W · Destroyed NTSB MIA95FA100Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · St. Petersburg, FLThe failure of the pilot to extend wing flaps and maintain airspeed while on approach to land resulting in an inadvertent stall, spin, and uncontrolled descent until collision with a residence and the ground.Apr 8, 1995 · N5718W · Destroyed NTSB MIA93FA160Accident · 4 fatalField investigationFinal reportPiper PA-28 · Morriston, FLVFR flight by the pilot(s) into instrument meteorological conditions (IMC) and failure to maintain adequate altitude (or clearance) from the tower. The proximity of the tower/guy wires and weather condition were related factors.Jul 21, 1993 · N5096W · Destroyed NTSB BFO92LA150Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Bethel, METhe pilot's failure to maintain adequate altitude to avoid the terrain. The dark night was a factor.Sep 26, 1992 · N5867W · Destroyed NTSB ATL92FA162Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Lawrenceville, GAThe pilot's failure to maintain aircraft control which resulted in an inadvertent stall, and his improper execution of emergency procedures. Factors were the pilot's overconfidence, his inadequate preflight inspection when he failed to drain the gascolator,…Aug 19, 1992 · N5640W · Substantial damage NTSB MIA89FA108Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Holley, FLContinued flight by the plt into adverse wx, followed by spatial disorientation and loss of aircraft control. Lack of a preflight weather briefing, weather conditions, and lack of visual cues at night were considered contributing factors.Mar 14, 1989 · N5572W · Destroyed NTSB MKC88FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Beedeville, ARIntentional buzzing performed, visual outlook not maintained and over confidence in personal ability by the pilot in command.Jul 2, 1988 · N5517W · Substantial damage NTSB CHI84LA338Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Palmyra, WIWhile on a personal flt the eng and airframe began to vibrate severely. The plt closed the throttle and turned eastward to land in a mint field. As he approached the field he applied power to clear a row of small houses, but during this maneuver struck a…Aug 4, 1984 · N5086W · Destroyed NTSB LAX81FA059Accident · 4 fatalClosedPiper PA-28 · Molokai, HIMar 14, 1981 · N5956W · Destroyed NTSB MKC79FA011Accident · 4 fatalClosedPiper PA-28 · Kennett, MODec 22, 1978 · N5716W · Destroyed NTSB SEA79FA016Accident · 1 fatalClosedPiper PA-14 · Eugene, ORDec 1, 1978 · N5013W · Destroyed NTSB NYC79FA005Accident · 1 fatalClosedPiper PA-28 · Great Bend, PAOct 27, 1978 · N5622W · Destroyed NTSB CHI78FEI23Accident · 1 fatalClosedPiper PA-28 · South Bass Is, OHJun 21, 1978 · N5570W · Destroyed NTSB MIA78FA017Accident · 1 fatalClosedPiper PA-28 · Lakeport, FLNov 29, 1977 · N5374W · Destroyed NTSB SEA76AS075Accident · 1 fatalClosedPiper PA-28 · Mountain Home, IDSep 6, 1976 · N5916W · Substantial damage NTSB CHI76AC062Accident · 1 fatalClosedPiper PA-28 · Milan, MIMay 14, 1976 · N5729W · Destroyed NTSB IAD76AI008Accident · 2 fatalClosedPiper PA-28 · Charlotte, NCAug 11, 1975 · N5423W · Destroyed NTSB LAX75AL052Accident · 1 fatalClosedPiper PA-28 · Sedona, AZApr 8, 1975 · N5016W · Destroyed NTSB CHI75AC067Accident · 1 fatalClosedPiper PA-28 · Plainfield, ILMar 17, 1975 · N5116W · Destroyed NTSB MIA75AM051Accident · 1 fatalClosedPiper PA-28 · Hartselle, ALJan 31, 1975 · N167SP · Destroyed NTSB FTW75AF032Accident · 1 fatalClosedPiper PA-28 · El Paso, TXNov 9, 1974 · N269JB · Destroyed NTSB CHI75AC006Accident · 1 fatalClosedPiper PA-28 · Columbia, ILJul 10, 1974 · N5291W · Destroyed NTSB LAX74AL044Accident · 2 fatalClosedPiper PA-28 · Corona, CADec 20, 1973 · N5382W · Substantial damage NTSB NYC73FHD37Accident · 1 fatalClosedPiper PA-28 · Forked River, NJFeb 28, 1973 · N5033W · Substantial damage NTSB NYC72AN013Accident · 2 fatalClosedPiper PA-28 · Wanaque, NJJul 29, 1971 · N5563W · Destroyed NTSB DEN71AD047Accident · 3 fatalClosedPiper PA-28 · Colorado Spg, COJun 10, 1971 · N5332W · Destroyed NTSB FTW71AF036Accident · 1 fatalClosedPiper PA-28 · Leakey, TXJan 2, 1971 · N5540W · Destroyed NTSB MIA70FKT10Accident · 3 fatalClosedPiper PA-28 · Mastic Pt, Burkina FasoMar 14, 1970 · N5974W · Destroyed NTSB DEN70AD029Accident · 4 fatalClosedPiper PA-28 · Cuchara, COOct 23, 1969 · N5752W · Destroyed NTSB OAK69F0156Accident · 2 fatalClosedPiper PA-28 · Mt View, HIOct 14, 1968 · N5433W · Destroyed NTSB LAX68A0041Accident · 4 fatalClosedPiper PA-28 · W.Los Angeles, CAOct 18, 1967 · N5109W · 2 aircraft · Destroyed NTSB DIA68A0016Accident · 3 fatalClosedPiper PA-28 · Pendleton, NCOct 10, 1967 · N5469W · Destroyed NTSB NYC67A0153Accident · 3 fatalClosedPiper PA-28 · Flushing, NYMay 1, 1967 · N5836W · 2 aircraft · Destroyed NTSB FTW66A0049Accident · 2 fatalClosedPiper PA-28 · West Fork, ARNov 21, 1965 · N5525W · Destroyed NTSB LAX66A0028Accident · 2 fatalClosedPiper PA-28 · Altadena, CASep 16, 1965 · N5871W · Destroyed NTSB DEN65A0080Accident · 3 fatalClosedPiper PA-28 · Salina, UTJun 11, 1965 · N5244W · Destroyed NTSB DEN65A0062Accident · 1 fatalClosedPiper PA-28 · Salt Lake City, UTMar 31, 1965 · N5748W · Substantial damage NTSB UNK65X1176Accident · 2 fatalClosedPiper PA-28 · Terry, MTDec 28, 1964 · N5124W · Destroyed NTSB UNK65X0956Accident · 1 fatalClosedPiper PA28 · Waterville, OHDec 8, 1964 · N5527W · Destroyed NTSB UNK64X2884Accident · 2 fatalClosedPiper PA-28 · Vale, ORJul 17, 1964 · N5139W · Destroyed