NTSB investigations: Piper PA-28-161, MO
12 cases on aircraft the registry lists as Piper PA-28-161. 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
| 1979 | 1 |
|---|---|
| 1981 | 2 |
| 1982 | 3 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2006 | 1 |
| 2012 | 1 |
| 2022 | 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\" = 'MO' 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 ('7102803', '7102834'))
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" = 'MO' 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 ('7102803', '7102834'))
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 CEN22LA324Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Grain Valley, MOThe loss of engine power due to fuel exhaustion.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 CHI06CA180Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Jefferson City, MOThe dual student's excessive landing flare and his failure to maintain adequate airspeed, which resulted in the airplane stalling. A factor to the accident was the flight instructor's delayed remedial action and the runway edge light that the airplane struck.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MKC88LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bonne Terre, MOThe plt rprtd the eng lost pwr fm fuel exhaustion as he was cruising at ngt on a x-country flt at 6500' MSL. He declaredan emerg with st louis apch & reqd vectors to the nearest arpt. The controller (ctlr) provided vectors to the Bonne Terre arpt which was…NTSB MKC84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Branson, MOExcessive airspeed caused the acft to float about halfway down the rwy prior to touchdown. A go-aground was initiated with the addition of power but the plt then elected to attempt to stop due to low airspeed and minimal rwy remaining. The plt then applied…NTSB MKC83FCA01Accident · 4 fatalFinal reportPiper PA-28-161 · St. Charles, MOThe acft crashed on the north boundary of the arpt within minutes after having been seen departing rwy 27. Dense ground fog prevailed at the crash site. Approximately 1-1/2 hours after the accident examination disclosd very heavy frost on all acft parked…NTSB MKC82DA176Accident · No injuriesFinal reportPiper PA-28-161 · Point Lookout, MODuring arrival, the UNICOM had recommended that runway 11 be used. However, the student pilot landed on runway 29 with a quartering tail wind. According to witnesses, the aircraft touched down about, 2800 ft beyond the approach end of the runway, then it slid…NTSB MKC82DA039Accident · No injuriesFinal reportPiper PA-28-161 · Perryville, MOThe student pilot landed on runway 19 at his home airport after returing from a solo cross-country flight. The wind was from 220 degrees at 12 knots. After touchdown, the aircraft drifted to the right and impacted a snowbank beside the runway.NTSB MKC82DCG12Accident · No injuriesClosedPiper PA-28 · Willow Spgs, MONTSB MKC81FA048Accident · 4 fatalClosedPiper PA-28 · Kirksville, MONTSB MKC79FA054Accident · 1 fatalClosedPiper PA-28 · Mountain View, MO