NTSB investigations: Piper PA-28-140
11 cases on aircraft the registry lists as Piper PA-28-140, where the sequence of events included Other weather encounter. 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
| 2011 | 1 |
|---|---|
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 1 |
| 2021 | 2 |
| 2023 | 2 |
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.\"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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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."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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Martinsville, INThe pilot’s inadequate weather evaluation and failure to abort the takeoff that resulted in an impact with terrain.NTSB ERA23LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Paris, KYThe pilot’s loss of control after encountering changing wind conditions during the initial climb, which resulted in descent and collision with terrain.NTSB 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.NTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…NTSB GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.NTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.NTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.NTSB GAA17CA103Accident · Minor injuriesData collectionFinal reportPiper PA28 · Shreveport, LAThe pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.NTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.NTSB CEN14FA019Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Talihina, OKThe pilot’s lack of weather planning and his continued flight into an area of known rain with reduced visibility and his subsequent failure to maintain clearance with trees.NTSB CEN11LA426Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphia, OHThe pilot's incorrect identification of the wind direction before landing, which resulted in a tailwind landing and subsequent runway excursion.