NTSB investigations: Piper PA-28-181, KY
10 cases on aircraft the registry lists as Piper PA-28-181. 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
| 1980 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1992 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2019 | 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\" = 'KY' 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 ('7102807', '7102832'))
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" = 'KY' 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 ('7102807', '7102832'))
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 ERA19LA109Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYThe failure of the magnetos due to a known deficiency, which resulted in a partial loss of engine power. Contributing to the accident was maintenance personnel’s failure to comply with the applicable service bulletin.NTSB NYC04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Louisville, KYThe student pilot's failure to maintain directional control while landing, and the CFI's delayed remedial action. A factor related to the accident was the gusting wind conditions.NTSB NYC98LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · West Liberty, KYThe pilot's inadequate planning for a downslope landing. A factor was the pilot's lack of training for downslope landing situations.NTSB NYC97LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manchester, KYThe pilot's delay in aborting the takeoff. A factor in the accident was the high, wet grassy runway.NTSB NYC95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Louisville, KYThe pilot's inadequate planning which resulted in his failure to attain adequate airspeed for takeoff.NTSB BFO92LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Pikesville, KYThe pilot's failure to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's improper flare. And objects near the runway.NTSB BFO92LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Clay City, KYFuel starvation for an undetermined reason. Darkness and trees in the emergency landing area were related factors.NTSB ATL85FLQ01Accident · Minor injuriesFinal reportPiper PA-28-181 · Bowling Green, KYThe acft was substantially damaged during a forced landing in a corn field following a loss of pwr 5 miles from the destination arpt. The plt reported to Bowling Green fss that he was 'out of gas' at an alt of 3000 ft. post accident examination disclosed a…NTSB ATL84LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waverly, KYAbout 8 mi from his destination the plt encountered freezing rain. He decided to retrieve a flashlight from his briefcase in the back seat to use in checking for ice on the wings & in consulting his charts. While leaning over the back seat, the plt lost his…NTSB ATL80FLQ24Accident · Serious injuriesClosedPiper PA-28 · Louisville, KY