Skip to content

NTSB investigations: Piper PA-28-140, NE

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

19662026

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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 CEN24FA327Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Wayne, NEThe non-instrument-rated pilot’s encounter with instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Aug 26, 2024 · N9626K · Destroyed NTSB CHI06FA215Accident · No injuriesField investigationFinal reportManarin/Johnson Lancair IVP · Omaha, NEThe selection of an unsuitable landing area by the pilot of the other airplane, and his failure to maintain separation during landing.Aug 4, 2006 · N330RM · 2 aircraft · Substantial damage NTSB CHI06FA037Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Atlanta, NEThe non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.Nov 27, 2005 · N5596F · Destroyed NTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Aug 28, 1999 · N5535U · Substantial damage NTSB CHI98LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrison, NEthe pilot's improper positioning of the magneto switch and his improper use of the mixture control.Jun 6, 1998 · N4541R · Substantial damage NTSB CHI96FA073Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hallam, NEimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Darkness was a related factor.Jan 14, 1996 · N98254 · Destroyed NTSB MKC85LA172Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Minden, NEPlt said that he was unable to clear wires at the end of the 2,100 ft long, sod, farm, strip. He said he began truning to avoid the wires and in the turn the acft settled, the rt wing hit the ground and the acft crashed. The acft weight was near max allowable…Jul 29, 1985 · N98193 · Substantial damage NTSB MKC82FCJ02Accident · 1 fatalFinal reportPiper PA-28-140 · Davenport, NEAt 1242 CST, the pilot received a weather briefing including a forecast of marginal VFR conditions at the destination. Between 1649 and 1848 CST, there were three weather reports from the destination of ceilings between 300 and 500 ft, visibilities between…Mar 25, 1982 · N32329 · Destroyed NTSB MKC79DCJ39Accident · No injuriesClosedPiper PA-28 · Omaha, NESep 23, 1979 · N54435 · Substantial damage NTSB MKC79DCJ37Accident · Minor injuriesClosedPiper PA-28 · Hartington, NEAug 17, 1979 · N754WW · Substantial damage NTSB MKC79DCJ33Accident · Minor injuriesClosedPiper PA-28 · Hay Springs, NEAug 11, 1979 · N4513R · Substantial damage NTSB MKC78FCJ36Accident · Serious injuriesClosedPiper PA-28 · Gothenburg, NEAug 4, 1978 · N44123 · Destroyed NTSB MKC78DCJ15Accident · No injuriesClosedPiper PA-28 · Lincoln, NEMar 30, 1978 · N56705 · Substantial damage NTSB MKC75DCJ41Accident · No injuriesClosedPiper PA-28 · Albion, NEDec 8, 1974 · N7116R · Substantial damage NTSB MKC75FCJ31Accident · Minor injuriesClosedPiper PA-28 · Fairmont, NEOct 9, 1974 · N9387W · Substantial damage NTSB MKC75DCJ23Accident · Minor injuriesClosedPiper PA-28 · Ogallala, NEAug 25, 1974 · N54386 · Substantial damage NTSB MKC75AK001Accident · 2 fatalClosedPiper PA-28 · Omaha, NEJul 5, 1974 · N2885T · Destroyed NTSB MKC73DCJ50Accident · No injuriesClosedPiper PA-28 · Hay Springs, NEJun 28, 1973 · N5273S · Destroyed NTSB MKC72FCJ41Accident · Minor injuriesClosedPiper PA-28 · Lincoln, NEDec 19, 1971 · N6710J · Substantial damage NTSB MKC72DCJ29Accident · No injuriesClosedPiper PA-28 · Glenvil, NEOct 3, 1971 · N6744W · Substantial damage NTSB MKC71AK055Accident · 1 fatalClosedPiper PA-28 · Chadron, NEMay 10, 1971 · N4614R · Destroyed NTSB MKC71DCJ53Accident · Minor injuriesClosedPiper PA-28 · Beatrice, NEMar 9, 1971 · N9592W · Substantial damage NTSB MKC71DCJ52Accident · No injuriesClosedPiper PA-28 · Gothenburg, NEMar 9, 1971 · N5627U · Substantial damage NTSB MKC71DCJ47Accident · No injuriesClosedPiper PA-28 · Gothenburg, NEFeb 14, 1971 · N5521U · Substantial damage NTSB MKC71FCJ27Accident · Serious injuriesClosedPiper PA-28 · Auburn, NEOct 24, 1970 · N1503J · Destroyed NTSB MKC71FCJ12Accident · No injuriesClosedPiper PA-28 · Bassett, NEAug 1, 1970 · N4151J · Substantial damage NTSB MKC70DCJ32Accident · No injuriesClosedPiper PA-28 · S.Sioux City, NEJun 25, 1970 · N8259N · Substantial damage NTSB MKC70DCJ19Accident · No injuriesClosedPiper PA-28 · Gothenburg, NEApr 28, 1970 · N6189W · Substantial damage NTSB MKC70FCJ07Accident · No injuriesClosedPiper PA-28 · Gothenburg, NEFeb 8, 1970 · N5521U · Substantial damage NTSB MKC70D0254Accident · Minor injuriesClosedPiper PA-28 · Sidney, NEOct 27, 1969 · N6987W · Substantial damage NTSB MKC70D0219Accident · No injuriesClosedPiper PA-28 · Gothenburg, NESep 20, 1969 · N5521U · Substantial damage NTSB MKC70D0133Accident · No injuriesClosedPiper PA-28 · Rockville, NEAug 15, 1969 · N4316J · Substantial damage NTSB MKC70D0108Accident · No injuriesClosedPiper PA-28 · Bloomfield, NEJul 21, 1969 · N3670K · Substantial damage NTSB MKC69F0323Accident · No injuriesClosedPiper PA-28 · Omaha, NEJan 11, 1969 · N1818J · Substantial damage NTSB MKC68F0573Accident · No injuriesClosedPiper PA-28 · Lincoln, NEMay 8, 1968 · N7144R · Substantial damage NTSB MKC68F0511Accident · Serious injuriesClosedPiper PA-28 · Weepng Water, NEApr 5, 1968 · N8450R · Substantial damage NTSB MKC68F0298Accident · No injuriesClosedPiper PA-28 · Pender, NESep 25, 1967 · N6784W · Substantial damage NTSB MKC67F0511Accident · No injuriesClosedPiper PA-28 · Fremont, NEApr 18, 1967 · N6548W · Substantial damage NTSB MKC67F0421Accident · No injuriesClosedPiper PA-28 · Central City, NEJan 28, 1967 · N8489R · Substantial damage NTSB MKC67F0298Accident · No injuriesClosedPiper PA-28 · Lincoln, NENov 2, 1966 · N6913W · Substantial damage