NTSB investigations: Piper PA-28-140, MA
100 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 4 |
| 1966 | 3 |
| 1967 | 11 |
| 1968 | 4 |
| 1969 | 8 |
| 1970 | 10 |
| 1971 | 5 |
| 1972 | 6 |
| 1973 | 4 |
| 1974 | 8 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 6 |
| 1980 | 4 |
| 1981 | 4 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 3 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1998 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2019 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'MA' 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" = 'MA' 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" DESCRun 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 ERA20CA111Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Hanson, MAThe flight instructor's delayed remedial action, which resulted in his decision to perform an off field landing and the airplane's subsequent impact with terrain.NTSB MIA08CA017Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hyannis, MAThe student pilot's mismanagement of the fuel supply and the flight instructor's inadequate supervision.NTSB NYC05LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marstons Mills, MAThe pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.NTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.NTSB NYC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Nantucket, MAa loss of engine power for undetermined reasons.NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.NTSB IAD97LA034Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Beverly, MAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and subsequent in-flight collision with terrain.NTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…NTSB NYC95LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grt Barrington, MAthe pilot's improper flare during landing, which resulted in a hard landing and the subsequent collapsed landing gear. A factor in this accident was the pilot's lack of total recent flying experience and recent experience in make and model.NTSB NYC91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taunton, MAThe pilot attempted to land in a strong cross wind, lost control of the airplane, ran off the runway and hit the VASI system.NTSB NYC88LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Mendon, MAOff airport landing due to engine power loss for undetermined reasons.NTSB NYC87FA006Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Holyoke, MAThe aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…NTSB NYC85FA019Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Beverly, MADuring an approach to land at night, the acft crashed & burned about 3000 ft from the approach end of the rwy. The non-instrument rated plt had been in contact with approach control. He indicated that IFR conditions existed over the arpt & that he was going…NTSB NYC84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Beverly, MAThe acft made a forced landing after the engine vibrated and lost power. The plt said that the fuel gages were checked and indicated 1/4 full. The plt said he switched fuel tanks but the engine did not improve its performance. The plt thenaccomplished the…NTSB NYC84LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Muskeget Island, MAThe acft was unable to clear trees during the initial takeoff climb. The plt raised the nose of the acft and the acft stalled contacted the trees.NTSB NYC83FNE02Accident · Serious injuriesFinal reportPiper PA-28-140 · Oxford, MADuring a go-around, the eng began losing power, & subsequently, the plt elected to make a forced landing in an open field. However, before landing, the acft collided with an electric wire, then crashed. An investigation revealed some maintenance…NTSB NYC82DA212Accident · No injuriesFinal reportPiper PA-28-140 · Norwood, MAThe student pilot was on a local flight and returned to the airport to practice landings. Just prior to touchdown on his second touch-and-go, the nose went to the right. Left rudder was applied to re-align the aircraft to the centerline of the runway. At…NTSB NYC82DA092Accident · No injuriesFinal reportPiper PA-28-140 · North Andover, MADuring landing the aircraft bounced and touched down on the center of runway 05. When the nosewheel was lowered the aircraft swerved to the right. According to the pilot, manipulation of the rudder pedals failed to change the direction or rate of turn of the…NTSB NYC81FNE29Accident · Minor injuriesClosedPiper PA-28 · Berlin, MANTSB NYC81FNE18Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC81FNE09Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC81FNA08Accident · Minor injuriesClosedPiper PA-28 · Beverly, MANTSB NYC81FNE07Accident · No injuriesClosedPiper PA-28 · Westfield, MANTSB NYC81FNA05Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC80FNA26Accident · Serious injuriesClosedPiper PA-28 · Hanson, MANTSB NYC80DNA16Accident · No injuriesClosedPiper PA-28 · Oak Bluffs, MANTSB NYC79FNA01Accident · No injuriesClosedPiper PA-28 · Marlboro, MANTSB NYC78FA098Accident · No injuriesClosedCessna 152 · Plymouth, MANTSB NYC78FNE35Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC78FNE22Accident · Minor injuriesClosedPiper PA-28 · Barrington, MANTSB NYC78FNE21Accident · No injuriesClosedPiper PA-28 · Orange, MANTSB NYC78DNA17Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC77DNA08Accident · No injuriesClosedPiper PA-28 · Beverly, MANTSB NYC76FNA28Accident · Serious injuriesClosedPiper PA-28 · Norfolk, MANTSB NYC76FNA22Accident · Minor injuriesClosedPiper PA-28 · Malboro, MANTSB NYC75FNA47Accident · No injuriesClosedPiper PA-28 · Bedford, MANTSB NYC75FNA28Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC75FNA16Accident · Minor injuriesClosedPiper PA-28 · Stow, MANTSB NYC75FNA15Accident · No injuriesClosedPiper PA-28 · Marston Mill, MANTSB NYC74FNE25Accident · No injuriesClosedPiper PA-28 · Sterling, MANTSB NYC74FNE18Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC74FNA40Accident · No injuriesClosedPiper PA-28 · Norwood, MANTSB NYC74FNA39Accident · No injuriesClosedPiper PA-28 · Marthas Vyrd, MANTSB NYC74FNA33Accident · Minor injuriesClosedPiper PA-28 · Plympton, MANTSB NYC74FNE07Accident · No injuriesClosedPiper PA-28 · Worcester, MANTSB NYC74FNA06Accident · Serious injuriesClosedPiper PA-28 · N.Andover, MANTSB NYC73DNA44Accident · No injuriesClosedPiper PA-28 · Taunton, MANTSB NYC73ANA43Accident · Minor injuriesClosedPiper PA-28 · Fall River, MANTSB NYC73FNE11Accident · No injuriesClosedPiper PA-28 · Oxford, MANTSB NYC73DNA28Accident · No injuriesClosedPiper PA-28 · Taunton, MA