NTSB investigations: Piper PA-28-161, KS
10 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 | 3 |
|---|---|
| 1982 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2024 | 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\" = 'KS' 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" = 'KS' 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 CEN24LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · New Century, KSThe inability of the Boeing 75 pilot to anticipate that the Piper would stop earlier on the taxiway which resulted in the on-ground collision.NTSB CHI96LA319Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Pittsburg, KSthe pilot diverted his attention and failed to maintain sufficient altitude and clearance with the terrain. Factors relating to the accident were: darkness, and the pilot performing low altitude flight at night.NTSB CHI94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Wichita, KSThe pilot's failure to attain the proper touchdown point and delay in aborting the landing. The pilot's inadequate training was a factor.NTSB CHI92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hanover, KSThe pilot's failure to abort the takeoff earlier in the takeoff roll, and the inadvertent stall/mush after lift-off. A factor was the soft terrain.NTSB CHI91FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Gardner, KSA loss of engine power for undetermined reasons. Darkness was a related factor.NTSB MKC85LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Olathe, KSPilot said acft swerved to right during landing roll. Acft ran off right side of rwy into snow covered area resulting indamage to wing & gear. No evidence of aircraft malfunction was found after the accident.NTSB MKC83LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Oakley, KSDuring landing the aircraft hit a patch of ice, swerved to the left, hit a runway light and slid off the runway.NTSB MKC79FA056Accident · Minor injuriesClosedPiper PA-28 · Chanute, KSNTSB MKC79FCQ37Accident · No injuriesClosedPiper PA-28 · Halstead, KSNTSB MKC79FCG24Accident · No injuriesClosedPiper PA-28 · Ottawa, KS