NTSB investigations: Piper PA-28R-201T
9 cases on aircraft the registry lists as Piper PA-28R-201T, where the first occurrence was “In flight encounter with weather”. 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
| 1983 | 1 |
|---|---|
| 1988 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102813')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102813')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 MIA03FA071Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Cedar Key, FLThe pilot's inadequate in-flight planning/decision by his continued VFR flight into instrument meteorological condition after receiving an in-flight weather advisory. Also causal was his failure to maintain aircraft control, which resulted in flight that…NTSB CHI96FA038Accident · 4 fatalField investigationFinal reportPiper PA-28-201T · Belvidere, SDthe pilot's attempted visual flight into instrument meteorological conditions, his failure to maintain control of the airplane, and exceeding the design stress limits of the airplane. Factors in the accident were: the snow and fog, and the aft airplane center…NTSB FTW94FA208Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Southard, OKThe pilot's continued flight into known adverse weather resulting in the design limits of the airplane being exceeded. Factors were the thunderstorms and the pilot's disregard for the forecasted adverse weather.NTSB FTW92FA180Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Tool, TXThe pilot exceeded the design stress limits of the airframe as a result of flight into known adverse weather conditions.NTSB LAX91FA138Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Vacaville, CAThe pilot's continued VFR flight at night under low clouds, and his failure to maintain sufficient altitude over rising terrain. Factors related to the accident were: darkness, the adverse weather and terrain conditions, and the controller's inaccurate…NTSB LAX91LA101Accident · No injuriesLimited investigationFinal reportPiper PA28-201T · So. Lake Tahoe, CAThe pilot failed to properly compensate for the wind conditions, abruptly flared the airplane, and inadvertenly stalled the airplane. Contributing to this accident was windshear.NTSB DEN89FA041Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Arvada, WYThe pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when…NTSB FTW88FA164Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Okmulgee, OKNon-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup…NTSB MKC83FA060Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Salem, MODuring the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt…