Skip to content

NTSB investigations: Piper PA-28-140, NH

22 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" = 'NH' 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\" = 'NH' 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" = 'NH' 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 ERA15LA237Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Hampton, NHThe pilot’s failure to properly set the stabilator trim prior to takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Jun 14, 2015 · N43078 · Substantial damage NTSB NYC99LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Wolfeboro, NHThe pilot's failure to attain a proper touchdown point. A factor in the accident was the pilot's failure to use a preflight briefing service, resulting in an in flight encounter with snow, and subsequent precautionary landing.Feb 28, 1999 · N8790N · Substantial damage NTSB NYC85FA109Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · No. Hampton, NHOn April 20, 1985, a Piper PA-28-140, flown by a student plt, crashed during an attempted go-around at north Hampton, NH, while on a pleasure flt. The wx was clear, winds were light and variable with unlimited visibility. The tough rwy is 2050 ft long and 300…Apr 20, 1985 · N95043 · Destroyed NTSB NYC84FNC03Accident · Serious injuriesFinal reportPiper PA-28-140 · Hampton, NHPurpose of flt was to obtain actual experience in short/soft field operations. Takeoff was initiated on a runway that was not only short and soft, but uphill and with a 70 degree left crosswind. Under these conditions, acft performance was inadequate to clear…Jun 5, 1984 · N95007 · Substantial damage NTSB NYC82FNC13Accident · 1 fatalFinal reportPiper PA-28-140 · Beans Purchase, NHThe acft impacted an obscured mountain. An observation log & a pilot-certificated witness confirmed that IFR conditions existed at the time of the accident.Aug 2, 1982 · N5566F · Destroyed NTSB NYC80FNC26Accident · No injuriesClosedPiper PA-28 · Antrim, NHJun 11, 1980 · N55817 · Substantial damage NTSB NYC79FA091Accident · 3 fatalClosedPiper PA-28 · Charlestown, NHSep 9, 1979 · N159TA · Destroyed NTSB NYC78DNC22Accident · No injuriesClosedPiper PA-28 · Antrim, NHApr 12, 1978 · N8262N · Substantial damage NTSB NYC76FNC52Accident · Serious injuriesClosedPiper PA-28 · Keene, NHJun 3, 1976 · N95228 · Destroyed NTSB NYC76DNC02Accident · No injuriesClosedPiper PA-28 · Errol, NHJul 22, 1975 · N7297J · Substantial damage NTSB NYC75DNC39Accident · No injuriesClosedPiper PA-28 · Keene, NHJun 25, 1975 · N7227F · Substantial damage NTSB NYC75AN085Accident · 1 fatalClosedPiper PA-28 · Rummey, NHFeb 8, 1975 · N8827N · Substantial damage NTSB NYC71AN003Accident · 1 fatalClosedPiper PA-28 · Northwood, NHMay 28, 1973 · N5553F · Destroyed NTSB NYC73AN102Accident · Minor injuriesClosedCessna 150 · Nashua, NHJan 14, 1973 · N4239U · 2 aircraft · Substantial damage NTSB NYC73ANC46Accident · No injuriesClosedPiper PA-28 · Nashua, NHJan 11, 1973 · N15320 · Substantial damage NTSB NYC73DNC10Accident · No injuriesClosedPiper PA-28 · Melvin Village, NHJul 30, 1972 · N3580K · Substantial damage NTSB NYC72DNC50Accident · No injuriesClosedPiper PA-28 · Keene, NHMay 22, 1972 · N6447R · Substantial damage NTSB NYC69D0313Accident · No injuriesClosedPiper PA-28 · Laconia, NHJan 27, 1969 · N6148W · Substantial damage NTSB NYC69F0109Accident · No injuriesClosedPiper PA-28 · Laconia, NHJul 31, 1968 · N9901W · Substantial damage NTSB NYC69D0098Accident · Minor injuriesClosedPiper PA-28 · Plymouth, NHJul 20, 1968 · N4567R · Substantial damage NTSB NYC68A0024Accident · 5 fatalClosedPiper PA-28 · Laconia, NHAug 6, 1967 · N4226J · 2 aircraft · Destroyed NTSB NYC66D0436Accident · No injuriesClosedPiper PA-28 · Manchester, NHDec 22, 1965 · N6642W · Substantial damage