NTSB investigations: Piper PA-28-140, CO
71 cases on aircraft the registry lists as Piper PA-28-140. 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
| 1965 | 2 |
|---|---|
| 1966 | 5 |
| 1967 | 5 |
| 1968 | 3 |
| 1969 | 6 |
| 1970 | 4 |
| 1971 | 2 |
| 1972 | 6 |
| 1973 | 6 |
| 1974 | 3 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 4 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2013 | 2 |
| 2018 | 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.\"eventStateOrRegion\" = 'CO' 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 ('7102802'))
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" = 'CO' 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 ('7102802'))
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 ERA19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Parker, COA partial loss of engine power during initial climb due to carburetor icing, and the pilot's failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB CEN13FA327Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Mosca, COThe pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN13FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Castle Rock, COThe pilot's loss of airplane control while maneuvering between two convective storms that likely produced low-level windshear. Contributing to the accident was the pilot's relatively low overall flight experience and low night flight experience, which…NTSB DEN01LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Calhan, COthe loss of engine power due to fuel contamination (water). A contributing factor was the lack of suitable terrain on which to perform a forced landing.NTSB DEN99LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Junction, COThe pilot's inadequate preflight planning and preparation for the runway and the environment in which he intended to fly. Factors were high-density altitude and a dirt runway.NTSB FTW97LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Leadville, COan attempt by the pilot to fly the aircraft over mountainous terrain in a regime that was beyond its climb performance limit. High density altitude was a related factor.NTSB FTW97LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Fort Collins, COa total loss of power for reasons undetermined. A factor was unsuitable terrain for a forced landing.NTSB FTW95LA274Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Colorado Spgs, COAn inadvertent windshear encounter. A factor was the high density altitude.NTSB DEN93FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Falcon, COInadequate supervision of the student pilot by the flight instructor. Factors were: IMC weather conditions, dark night, inaccurate weather evaluation by both the flight instructor and student pilot, and inadequate training of the student pilot.NTSB DEN92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Yuma, COThe pilot's failure to maintain aircraft control. Factors were: an improper flare and lack of total flight time.NTSB DEN90LA025Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Steamboat Spgs, COContinued VFR flight by the pilot into instrument meteorological conditions (IMC) and his delay in diverting or reversing course. The terrain, weather conditions, wing ice, and trees were considered to be contributing factors.NTSB DEN89FA017Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Garfield, CONTSB DEN87FA213Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Last Chance, COWhile on a cross country flt the plt encountered IFR conditions and was neither trained nor qualified to fly IFR. Attempts by ATC to assist the plt and route the flt to an arpt were unsuccessful. The plt lost control of the acft and crashed in a field, the…NTSB DEN84LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Durango, COThe acft collided with a rwy light during takeoff. The plt said the acft got to about 6 ft AGL for about 100 ft and whenthe plt pushed foward on the control column the acft settled back on the rwy. During the roll the horizontal stabilizer hit a rwy light.…NTSB DEN83LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Erie, COThe acft crashed shortly after takeoff in VMC wx conditions with an arpt elevation of 5145 ft MSL and tempertaure 86 degrees f. density alt was 7468 ft. in the pilots operating handbook the takeoff distance vs density alt chart goes to amax alt of 7000 ft. a…NTSB DEN83LA020Accident · No injuriesLimited investigationFinal reportPiper 28-140 · Fort Collins, COThe pilot failed to enrich mixture during descent from 10,000 feet. Power was lost during the approach and a forced landing made in a pasture. During the landing the aircraft collided with a fence and ground-looped collapsing the landing gear.NTSB DEN82DA163Accident · No injuriesFinal reportPiper PA-28-140 · 5nm Colorado Sp, COThe pilot on a cross-country landed after 2.4 hrs. No refueling crew was found so he measured 15 gals into each tank forabout 25 gals each. The next leg was 3.5 hours. At 3.3 hrs both tanks were out of useable fuel 6 miles from the destination. A forced…NTSB DEN81FTE28Accident · No injuriesClosedPiper PA-28 · Longmont, CONTSB DEN80FTE63Accident · Serious injuriesClosedPiper PA-28 · Elizabeth, CONTSB DEN80FTE50Accident · Minor injuriesClosedPiper PA-28 · Broomfield, CONTSB DEN77DTE81Accident · No injuriesClosedPiper PA-22 · Peyton, CONTSB DEN77FTE60Accident · No injuriesClosedPiper PA-28 · Colo Springs, CONTSB DEN77FTE59Accident · No injuriesClosedPiper PA-28 · Lafayette, CONTSB DEN77DTE19Accident · No injuriesClosedPiper PA-28 · Idalia, CONTSB DEN76FTE85Accident · Minor injuriesClosedPiper PA-28 · Ft Collins, CONTSB DEN76FTE82Accident · No injuriesClosedPiper PA-28 · Englewood, CONTSB DEN76FTE58Accident · No injuriesClosedPiper PA-28 · Boulder, CONTSB DEN7LFTE15Accident · Serious injuriesClosedPiper PA-28 · Englewood, CONTSB DEN75FTE72Accident · No injuriesClosedPiper PA-28 · Littleton, CONTSB DEN75AD013Accident · 2 fatalClosedPiper PA-28 · Eldora, CONTSB DEN75FTE15Accident · Minor injuriesClosedPiper PA-28 · Antonito, CONTSB DEN74FTE53Accident · No injuriesClosedPiper PA-28 · Strasburg, CONTSB DEN74AD015Accident · 1 fatalClosedPiper PA-28 · Holyoke, CONTSB DEN74FTE09Accident · No injuriesClosedPiper PA-28 · Broomfield, CONTSB DEN73DTE81Accident · No injuriesClosedPiper PA-28 · Salida, CONTSB DEN73DTE80Accident · No injuriesClosedPiper PA-28 · Longmont, CONTSB DEN73FTE59Accident · Serious injuriesClosedPiper PA-28 · Broomfield, CONTSB DEN73FTE50Accident · Serious injuriesClosedPiper PA-28 · Greeley, CONTSB DEN73FTE38Accident · No injuriesClosedPiper PA-28 · Rangely, CONTSB DEN73ADO22Accident · 1 fatalClosedPiper PA-28 · Rangley, CONTSB DEN73FTE26Accident · Minor injuriesClosedPiper PA-28 · Littleton, CONTSB DEN73DTE08Accident · No injuriesClosedPiper PA-28 · Littleton, CONTSB DEN72FTE67Accident · No injuriesClosedPiper PA-28 · Fort Collins, CONTSB DEN72FTE56Accident · No injuriesClosedPiper PA-28 · Broomfield, CONTSB DEN72DTE28Accident · No injuriesClosedPiper PA-28 · Ft.Collins, CONTSB DEN72FTE07Accident · No injuriesClosedPiper PA-28 · Laporte, CONTSB DEN71DXD35Accident · No injuriesClosedPiper PA-28 · Littleton, CONTSB DEN71DXD23Accident · No injuriesClosedPiper PA-28 · Fort Collins, CONTSB DEN71DXD13Accident · Minor injuriesClosedPiper PA-28 · Littleton, CONTSB DEN70DXD14Accident · No injuriesClosedPiper PA-28 · Broomfield, CO