NTSB investigations: Piper PA-28-161
9 cases on aircraft the registry lists as Piper PA-28-161, where NTSB found Tree(s). 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
| 2008 | 4 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2019 | 1 |
Where
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 ('7102803', '7102834')
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\", '03022020')))
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 ('7102803', '7102834')
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", '03022020')))
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 ERA19LA097Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLThe pilot's failure to use carburetor heat while operating the airplane in weather conditions and at engine power settings conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing and the subsequent forced…NTSB ERA15LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Bristow, VAThe student pilot’s failure to maintain altitude during approach, which resulted in controlled flight into terrain. Contributing to the accident was the student’s distraction due to other traffic in the airport traffic pattern.NTSB CEN15LA228Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Ranger, TXA total loss of engine power during cruise flight due to piston fatigue cracking for reasons that could not be determined due to postfracture smearing damage.NTSB ERA14CA438Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Block Island, RIA loss of control during the attempted go-around, which resulted in an aerodynamic stall and impact with trees.NTSB CEN12FA188Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Mexico, MOThe pilot’s failure to maintain airplane control during takeoff, which resulted in an aerodynamic stall and subsequent collision with trees. Contributing to the accident was the pilot’s inadequate preflight performance planning before departing on the soft,…NTSB LAX08CA243Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Canyon City, ORThe pilot's failure to maintain directional control. Contributing to the accident was the gusting tailwind.NTSB NYC08FA237Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Middletown, RIThe flight instructor's failure to initiate a go-around during a high approach, and his inadequate remedial action during an attempted touch-and-go.NTSB NYC08CA200Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Wildwood, NJThe pilot's failure to maintain clearance from trees during approach. Contributing to the accident were the dark night conditions.NTSB DFW08LA144Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Roanoke, TXThe departing pilot's inadequate visual lookout resulting in his airplane colliding with the landing airplane. Contributing to the accident was the trees/visual obstructions along the runway's approach path.