Skip to content

NTSB investigations: Piper PA-28-140, ME

24 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" = 'ME' 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\" = 'ME' 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" = 'ME' 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 GAA19CA350Accident · No injuriesData collectionFinal reportPiper PA28 · Nowdoinham, METhe flight instructor's delayed decision to abort the takeoff from a wet, grass runway with insufficient runway remaining, which resulted in a runway overrun and the airplane going down an embankment.Jun 7, 2019 · N7227F · Substantial damage NTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.Sep 20, 2008 · N2318T · Substantial damage NTSB NYC08LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Rockland, METhe non-instrument rated pilot becoming spatially disorientated after inadvertently entering instrument flight conditions.Jun 21, 2008 · N8776N · Substantial damage NTSB NYC98LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Rockland, METhe pilot's failure to attain adequate airspeed during the takeoff, which resulted in a stall.Jul 19, 1998 · N5755F · Destroyed NTSB NYC94LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Augusta, METhe improper positioning of the fuel selector because of inadequate inflight decision/planning which resulted in fuel exhaustion and the loss of engine power.Jul 25, 1994 · N32925 · Substantial damage NTSB NYC94LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Haven, METhe pilot's use of excessive speed and altitude during the approach which resulted in a landing overrun of the runway. Factors were a precautionary landing and a ravine.Dec 4, 1993 · N55719 · Substantial damage NTSB NYC88LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · W. Peru, METhe cockpit of the Piper PA-28 filled with smoke after takeoff, at an altitude of approximately 800 ft. the pilot tried to land on a road and struck trees, shearing off the wings. The fuselage landed on a road, inverted and was immediately enfulfed in flames.…May 29, 1988 · N54368 · Destroyed NTSB NYC86LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hampden, MEAfter taking off, the plt initiated a climb & leveled off at 2500'. As he reduced power to cruise, the eng stopped running. All attempts to restart the eng were unsuccessful. Subsequently, the acft was damaged when the plt landed on rocky pasture land. Fuel…Apr 15, 1986 · N6264W · Substantial damage NTSB NYC81FNC04Accident · Serious injuriesClosedPiper PA-28 · Limerick, MEOct 19, 1980 · N9514W · Substantial damage NTSB NYC80FNC16Accident · No injuriesClosedPiper PA-28 · Eliot, MEMar 15, 1980 · N57302 · Substantial damage NTSB NYC80FNC15Accident · Minor injuriesClosedPiper PA-28 · Portland, MEMar 13, 1980 · N1016X · Substantial damage NTSB NYC80FA006Accident · 1 fatalClosedPiper PA-28 · Gilead, MEOct 25, 1979 · N407FL · Substantial damage NTSB NYC78DNC49Accident · No injuriesClosedPiper PA-28 · Dexter, MESep 4, 1978 · N6910W · Substantial damage NTSB NYC78FNC35Accident · No injuriesClosedPiper PA-28 · Swans Island, MEJun 25, 1978 · N5567U · Substantial damage NTSB NYC77DNC42Accident · No injuriesClosedPiper PA-28 · Old Town, MEJul 22, 1977 · N7882C · Substantial damage NTSB NYC76FNC53Accident · No injuriesClosedPiper PA-28 · Hollis Center, MEJul 6, 1976 · N8400R · Substantial damage NTSB NYC73DNC58Accident · No injuriesClosedPiper PA-28 · Machias, MEFeb 28, 1973 · N575CA · Substantial damage NTSB NYC72DNC29Accident · No injuriesClosedPiper PA-28 · Auburn, MEFeb 25, 1972 · N9514W · Substantial damage NTSB NYC72DNC08Accident · No injuriesClosedPiper PA-28 · Limestone, MEAug 2, 1971 · N98384 · Substantial damage NTSB NYC71DFG12Accident · No injuriesClosedPiper PA-28 · Belfast, MEJan 10, 1971 · N8870N · Substantial damage NTSB NYC70D0214Accident · Minor injuriesClosedPiper PA-28 · Pittsfield, MENov 24, 1969 · N7577R · Substantial damage NTSB NYC68F0203Accident · No injuriesClosedPiper PA-28 · Auburn, MESep 24, 1967 · N9514W · Substantial damage NTSB NYC67D0512Accident · No injuriesClosedPiper PA-28 · Old Town, MEMar 2, 1967 · N7405R · Substantial damage NTSB NYC67F0086Accident · No injuriesClosedPiper PA-28 · Winterport, MEJul 11, 1966 · N6910W · Substantial damage