Fatal NTSB investigations: Piper PA-28-201T
4 cases on aircraft the registry lists as Piper PA-28-201T. 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
| 1985 | 1 |
|---|---|
| 1989 | 1 |
| 1991 | 2 |
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.\"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 ('7102819'))
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."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 ('7102819'))
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 NYC91FA171Accident · 2 fatalField investigationFinal reportPiper PA-28-201T · Wernersville, PAThe pilot's loss of airplane control due to spatial disorientation/vertigo. Factors related to the accident were the pilot's use of an antihistamine and self induced pressure to complete the flight.NTSB ATL91FA067Accident · 2 fatalField investigationFinal reportPiper PA-28-201T · Hamilton, NCThe pilot's improper use of equipment which affected the operation of the standby vacuum pump, the pilot's loss of aircraft control after experiencing spatial disorientation, and his exceeding the design stress limits of the aircraft. Factors related to the…NTSB LAX89FA178Accident · 1 fatalField investigationFinal reportPiper PA-28-201T · Stockton, CAThe pilot's improper decision to perform aerobatics which resulted in the design stress limits of the airplane being exceeded due to excessive airspeed. Contributing factors to the accident were the pilot's overconfidence in his and the airplane's ability,…NTSB LAX86FA061Accident · 3 fatalField investigationFinal reportPiper PA-28-201T · So. Lake Tahoe, CAPrior to departing on a VFR flt from south lake Tahoe, CA, to tracy, CA, the plt failed to obtain a wx briefing or file a flt plan. Wx at the arpt of departure was reported as scattered clouds at 1500 ft, broken ceiling conditions at an estimated 3000 ft,…