NTSB investigations: Piper PA-28-201T, CA
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
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1989 | 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.\"eventStateOrRegion\" = 'CA' 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 ('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."eventStateOrRegion" = 'CA' 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 ('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 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,…NTSB LAX82DA176Accident · No injuriesFinal reportPiper PA-28-201T · Van Nuys, CADuring flight at about 1500 ft, the engine suddenly lost power and the propeller stopped turning. The pilot attempted a restart, but the starter would not turn the propeller. The pilot maneuvered to make a forced landing at the Van Nuys airport. The aircraft…NTSB LAX82DA120Accident · No injuriesFinal reportPiper PA-28-201T · Auberry, CADuring landing, the pilot rolled to the left side of the runway to avoid possible potholes. After steering to the left side, the left main gear encountered a small berm and the aircraft veered further left. The nosewheel hit the berm and the nose gear…