Skip to content

NTSB investigations: Piper PA-28-140, LA

40 cases on aircraft the registry lists as Piper PA-28-140. 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

19652026

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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802')) 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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
  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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802'))
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 CEN27LA013Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Abita Springs, LAOn October 12, 2026, at 1540 central daylight time, a Piper PA-28-140 airplane, N9859W, sustained substantial damage when it was involved in an accident near Abita Springs, Louisiana. The private pilot was uninjured. The airplane was operated as a Title 14…Oct 12, 2026 · N9859W · Substantial damage NTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.Jul 19, 2018 · N7080F · Substantial damage NTSB GAA17CA103Accident · Minor injuriesData collectionFinal reportPiper PA28 · Shreveport, LAThe pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.Dec 22, 2016 · N9541W · Substantial damage NTSB CEN15LA301Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Oakdale, LAThe pilot's inadequate preflight planning resulting in the airplane not having adequate performance to climb and clear the trees off the end of the dirt runway.Jul 8, 2015 · N3949K · Substantial damage NTSB DFW08CA207Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Abbeville, LAA total loss of engine power for undetermined reasons. Contributing to the accident was unsuitable terrain for a forced landing.Aug 15, 2008 · N8323R · Substantial damage NTSB DFW06CA190Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Woodworth, LAThe pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.Jul 22, 2006 · N9952W · Substantial damage NTSB FTW91FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Folsom, LAThe inadvertent stall. Factors were the pilot's poor judgement in performing the buzzing maneuver and his lack of experience.May 26, 1991 · N6181W · Destroyed NTSB FTW91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Davant, LAThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Feb 25, 1991 · N7388J · Substantial damage NTSB FTW90FA119Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bossier City, LALoss of engine power for an unknown reason.Jun 18, 1990 · N6767W · Destroyed NTSB FTW90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rayne, LAFailure of the #3 exhaust valve, which necessitated a forced landing on unsuitable terrain.Feb 13, 1990 · N1785T · Substantial damage NTSB FTW86FA034Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Deville, LAThe student plt had previously flown this acft in flt training. However, the insurance for the acft had lapsed & the owner had secured the acft to a tie-down with a chain & pad lock to prevent it from being flown. After the chain was cut with a hack saw, the…Jan 13, 1986 · N5655U · Destroyed NTSB FTW84LA301Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Killian, LAThe acft crashed while in a steep bank at low alt in VMC wx.a witness who knew the plt said he heard the acft approaching, went outside his house and saw the acft at about 200 ft AGL. The acft went into a turn and became almost inverted before colliding with…Jul 6, 1984 · N33074 · Destroyed NTSB FTW82DA023Accident · 1 fatalClosedPiper PA-28 · Garden City, LANov 28, 1981 · N1363T · Destroyed NTSB FTW78DRD53Accident · Minor injuriesClosedPiper PA-28 · Bogalusa, LAAug 26, 1978 · N3350T · Substantial damage NTSB FTW78FRD19Accident · Minor injuriesClosedPiper PA-28 · Jennings, LAMar 28, 1978 · N5736F · Substantial damage NTSB FTW77DRD27Accident · Minor injuriesClosedPiper PA 28 · Free Mason Is., LAMay 22, 1977 · N5835U · Substantial damage NTSB FTW76FRJ27Accident · No injuriesClosedPiper PA-28 · Cotton Valley, LAMay 28, 1976 · N1656J · Substantial damage NTSB FTW76FRD44Accident · No injuriesClosedPiper PA-28 · Lafayette, LAMay 9, 1976 · N8730E · Substantial damage NTSB FTW76FRD09Accident · No injuriesClosedPiper PA-28 · Plaquemine, LASep 27, 1975 · N33674 · Substantial damage NTSB FTW76FRJ10Accident · Serious injuriesClosedPiper PA-28 · Jena, LASep 20, 1975 · N8228N · Destroyed NTSB FTW75AF076Accident · 2 fatalClosedPiper PA-28 · Baton Rouge, LAJun 27, 1975 · N32558 · Destroyed NTSB FTW75DRD64Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAMay 11, 1975 · N32558 · Substantial damage NTSB FTW75DRJ24Accident · Minor injuriesClosedPiper PA-28 · Monroe, LAMar 2, 1975 · N8898N · Substantial damage NTSB FTW74FRJ10Accident · Minor injuriesClosedPiper PA-28 · Shreveport, LAAug 31, 1973 · N5064T · Substantial damage NTSB FTW73FRD11Accident · No injuriesClosedPiper PA-28 · New Orleans, LANov 22, 1972 · N486FL · Substantial damage NTSB FTW72FRD06Accident · Serious injuriesClosedCessna 177 · Baton Rouge, LAAug 11, 1971 · N2951X · 2 aircraft · Substantial damage NTSB FTW72FRJ04Accident · Serious injuriesClosedPiper PA-28 · Farmerville, LAAug 8, 1971 · N5754U · Destroyed NTSB FTW71FRD37Accident · No injuriesClosedPiper PA-28 · Westwego, LAMar 17, 1971 · N5594F · Substantial damage NTSB FTW71FRJ11Accident · Serious injuriesClosedPiper PA-28 · Marthaville, LAAug 24, 1970 · N6222W · Substantial damage NTSB FTW71FRD03Accident · Minor injuriesClosedPiper PA-28 · Westwego, LAJul 13, 1970 · N8228N · Substantial damage NTSB FTW70F0304Accident · Serious injuriesClosedPiper PA-28 · Slidell, LANov 11, 1969 · N5718F · Destroyed NTSB FTW70F0037Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAJun 22, 1969 · N8222N · Substantial damage NTSB FTW70D0091Accident · No injuriesClosedPiper PA-28 · Marksville, LAJun 22, 1969 · N6940W · Substantial damage NTSB FTW69F0436Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAApr 3, 1969 · N6761J · Substantial damage NTSB FTW69D0359Accident · No injuriesClosedPiper PA-28 · Amelia, LAJan 17, 1969 · N7448R · Substantial damage NTSB FTW69D0138Accident · No injuriesClosedPiper PA-28 · Dixie, LAAug 3, 1968 · N1857J · Substantial damage NTSB FTW68F0413Accident · Serious injuriesClosedPiper PA-28 · Slidell, LAJan 17, 1968 · N6312R · Destroyed NTSB FTW68F0048Accident · No injuriesClosedPiper PA-28 · Amelia, LAJul 15, 1967 · N7448R · Substantial damage NTSB FTW67F0447Accident · No injuriesClosedPiper PA-28 · Amelia, LAMar 2, 1967 · N7448R · Substantial damage NTSB FTW66F0072Accident · No injuriesClosedPiper PA-28 · Newellton, LAMay 9, 1965 · N6038W · Substantial damage