Skip to content

NTSB investigations: Piper PA-28R-200, CO

21 cases on aircraft the registry lists as Piper PA-28R-200. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19722026

Where

Latest cases

Query with SQL

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 ('7102811')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102811'))
  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 ('7102811'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · Colorado Springs, COOn October 1, 2025, about 0412 mountain daylight time, a Piper PA-28R-200 airplane, N999AD, was substantially damaged during an accident near Colorado Springs, Colorado. The pilot sustained minor injuries, and the 2 passengers were not injured. The airplane…Oct 1, 2025 · N999AD · Substantial damage NTSB CEN20CA332Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Englewood, COThe flight instructor did not maintain a proper approach path and landing flare during a landing with a tailwind, which resulted in a hard landing and damaged landing gear. During the subsequent landing with damaged landing gear, the flight instructor lost…Aug 8, 2020 · N4964S · Substantial damage NTSB CEN17LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Centennial, COThe loss of airplane control during takeoff for reasons that could not be determined based on the available information, which resulted in an aerodynamic stall and impact with terrain.Feb 18, 2017 · N2702R · Substantial damage NTSB FTW02FA262Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Chromo, COThe flight instructor's failure to maintain clearance with the mountainous terrain during the cross-country flight. A contributing factor was the dark night light conditions.Sep 24, 2002 · N6227J · Destroyed NTSB FTW95FA002Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Pagosa Springs, COThe pilot's continued flight into known adverse weather. Factors were the pilot's lack of familiarity with the geographic area, the turbulence and high density altitude.Oct 1, 1994 · N1480X · Destroyed NTSB DEN92LA075Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200R · Nederland, COA partial loss of power for undetermined reasons. A factor was: no suitable terrain for a forced landing.Jul 24, 1992 · N75350 · Substantial damage NTSB DEN86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sterling, COAccording to the plt, during the checkride for his commercial plt certificate, the flt examiner gave him a simulated electrical failure & turned the landing lights off. The plt stated that during the night landing flare, he lost visual reference with the rwy…Jan 16, 1986 · N33535 · Substantial damage NTSB DEN82DA137Accident · No injuriesFinal reportPiper PA-28R · Near Almosa, COThe pilot stated that during flight, his oil temperature began to rise and he elected to land on an abandoned air strip. During the landing, the aircraft encountered rough, uneven terrain, and subsequently, the landing gear and right wing were damaged. An…Jul 17, 1982 · N5114S · Substantial damage NTSB DEN80FTE35Accident · No injuriesClosedPiper PA-28R · Denver, COMar 31, 1980 · N75139 · Substantial damage NTSB DEN79FTE09Accident · No injuriesClosedPiper PA-28R · Ft Collins, CODec 13, 1978 · N1562X · Substantial damage NTSB DEN79FTE08Accident · No injuriesClosedPiper PA28R · Englewood, CODec 1, 1978 · N6507J · Substantial damage NTSB DEN78FTE74Accident · Serious injuriesClosedPiper PA-28 · Colorado Spngs, COJul 16, 1978 · N33445 · Substantial damage NTSB DEN78DTE13Accident · No injuriesClosedPiper PA-28R · Paonia, CONov 26, 1977 · N41373 · Substantial damage NTSB DEN77FTE29Accident · Minor injuriesClosedPiper PA-28 · Englewood, COMar 23, 1977 · N4992T · Substantial damage NTSB DEN77FTE08Accident · No injuriesClosedPiper PA-28R · Boulder, CONov 24, 1976 · N9350K · Substantial damage NTSB DEN75FTE36Accident · No injuriesClosedPiper PA-28R · Longmont, CONov 29, 1974 · N2079T · Substantial damage NTSB DEN74FTE58Accident · No injuriesClosedPiper PA-28R · Pueblo, COFeb 17, 1974 · N4337T · Substantial damage NTSB DEN74AD039Accident · 4 fatalClosedPiper PA-28R · Pueblo, COFeb 17, 1974 · N15654 · Destroyed NTSB DEN74DTE41Accident · No injuriesClosedPiper PA-28R · Denver, COJan 24, 1974 · N56696 · Substantial damage NTSB DEN73DTE83Accident · No injuriesClosedPiper PA-28R · Cripple Crk, COJun 3, 1973 · N15362 · Destroyed NTSB DEN72DTE68Accident · Minor injuriesClosedPiper PA-28R · Alamosa, COApr 29, 1972 · N9371N · Substantial damage