NTSB investigations: Piper PA-28-140

13 cases on aircraft the registry lists as Piper PA-28-140, where NTSB found Dark. 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

20082026
NTSB investigations: Piper PA-28-140 per year, 2008–2026: 13 cases
20081
20093
20103
20173
20212
20231

Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '03036020')))
  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.

NTSB WPR24FA002Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Moab, UTThe pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.Oct 2, 2023 · N7153R · Substantial damageNTSB CEN22FA067Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 28-140 · Houston, TXThe student pilot’s decision to depart into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Dec 9, 2021 · N3865K · DestroyedNTSB WPR22LA030Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Newdale, IDThe flight instructor’s failure to monitor the flight to ensure terrain clearance during the dark night conditions.Oct 28, 2021 · N1671J · Substantial damageNTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…Sep 30, 2017 · N9549W · DestroyedNTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…Aug 6, 2017 · N56884 · Substantial damageNTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 4, 2017 · N55339 · Substantial damageNTSB ERA11CA072Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Andover, NJAn inadvertent collision with a deer on the runway during a night landing.Nov 13, 2010 · N15499 · Substantial damageNTSB CEN10CA237Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Houston, TXThe pilot's failure to attain the proper touchdown point which resulted in an overrun.Apr 30, 2010 · N4397T · Substantial damageNTSB ERA10CA114Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Collegedale, TNThe pilot’s failure to maintain directional control during the initial climb after takeoff in dark light conditions.Jan 14, 2010 · N43421 · Substantial damageNTSB ERA10FA099Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Heflin, ALThe student pilot's failure to maintain adequate airspeed during night, adverse weather conditions, which resulted in an aerodynamic stall/spin. Contributing to the accident was the student pilot's decision to attempt a flight that he was not qualified for…Dec 25, 2009 · N1277T · Substantial damageNTSB ERA10LA066Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Newcomb, NYThe pilot’s failure to maintain clearance from mountainous terrain during descent at night, with low clouds and fog.Nov 15, 2009 · N1723T · Substantial damageNTSB ERA10CA006Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Gainesboro, TNThe pilot's failure to maintain clearance from trees. Contributing to the accident were the rising terrain and night light conditions.Oct 5, 2009 · N95472 · Substantial damageNTSB ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.Dec 31, 2008 · N95156 · Substantial damage