Fatal NTSB investigations: Piper PA-28R-200, TX
17 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.
Cases per year
| 1970 | 1 |
|---|---|
| 1973 | 1 |
| 1975 | 2 |
| 1976 | 2 |
| 1977 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2016 | 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\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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" = 'TX' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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" 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 CEN17FA063Accident · 3 fatalField investigationFinal reportPiper PA28R · McKinney, TXThe other pilot's use of an alternate traffic pattern entry procedure, which resulted in his inability to see and avoid the airplane, which was flying the preferred traffic pattern, and the subsequent midair collision.NTSB DFW08FA031Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Ranger, TXThe pilot's intentional performance of aerobatic maneuvers that exceeded the design limits of the airplane structure.NTSB DFW05FA099Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Jefferson, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB FTW99FA021Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Conroe, TXThe pilot's inadequate in-flight planning/decision which resulted in a loss of engine power due to fuel exhaustion. Factors were the dark night light conditions prevailing for the ensuing forced landing and the pilot's lack of experience in the make and model…NTSB FTW97FA122Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Westminster, TXThe pilot's failure to maintain clearance during an intentional low altitude maneuver. A factor was the transmission line.NTSB FTW97FA044Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Fort Worth, TXthe pilots' continued descent of the aircraft below decision height. Factors contributing to the accident were the fog, the dark night illumination, one of the pilot's impairment due to use of marihuana, and both pilots' fatigue.NTSB FTW91FA010Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Kingsland, TXThe pilot's failure to avoid flying into the mountain.NTSB FTW88FA038Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Burnet, TXThe pilot arrived in the area of his planned destination and completed the outbound and inbound procedure turns for the NDB runway 17 approach without reported incident. Almost immediately thereafter, the aircraft impacted a large oak tree about 15 feet AGL…NTSB FTW87FA029Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Petersburg, TXAcft impacted in a 95 deg nose down attitude following a loss of control in IMC conditions while the non-instrument rated pvt plt was being vectored to the final app crs. Plt had filed IFR and had experienced difficulties thru out the flt. As he was given…NTSB FTW83FA253Accident · 1 fatalField investigationFinal reportPiper PA28R200 · Decatur, TXAfter landing due to poor wx the pilot obtained a wx briefing during which he was told of a long line of thunderstorms 150 miles wide covering the area in which he was located. The pilot departed & then attempted to land at an airport 15 miles away in gusty…NTSB UNK77X0104Accident · 1 fatalClosedPiper PA-28 · Gruver, TXNTSB FTW77FA005Accident · 1 fatalClosedPiper PA-28R · Elmendorf, TXNTSB FTW76AF065Accident · 4 fatalClosedPiper PA-28R · Mont Belview, TXNTSB FTW76AF051Accident · 1 fatalClosedPiper PA-28R · Abernathy, TXNTSB FTW75AF072Accident · 1 fatalClosedPiper PA-28R · Jasper, TXNTSB FTW73AF038Accident · 1 fatalClosedPiper PA-28R · Whiteface, TXNTSB FTW70AF047Accident · 4 fatalClosedPiper PA-28R · Stonewall, TX