NTSB investigations: Piper PA-28R-201T
5 cases on aircraft the registry lists as Piper PA-28R-201T, where the first occurrence was “Loss of control - in flight”. 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 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 1998 | 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\" = 250))
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" = 250))
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 CHI98LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Edgeley, NDThe pilot's inadequate in-flight planning/decision making which resulted in a delayed go-around and his not maintaining aircraft control. A factor was the crosswind.NTSB LAX94LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Overgaard, AZthe pilot's failure to maintain an adequate airspeed margin, which resulted in an inadvertent stall. Factors in the accident were weather conditions, high density altitude, and shifting wind conditions.NTSB BFO89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28R-201T · College Park, MDFailure of the pilot to maintain aircraft control due to spatial disorientation, and his exceeding the design stress limits of the aircraft, which resulted in overload failure of the stabilators and wings. Factors related to the accident were: the pilot's…NTSB NYC88LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lincoln Park, NJDuring takeoff the aircraft was observed to become briefly airborne; then the wing dipped just before ground contact. The aircraft crashed about 50 feet from the departure end of the runway and about 300 feet to the right. The pilot said he experienced a…NTSB LAX84FA107Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Tehachapi, CAThe acft collided with the ground after stalling during a right climbing turn into clouds. Witnesses reported that the initial climb attitude was 'very steep'. No one observed the crash but the engine RPM 'revved up' to a very high RPM 4-5SECONDS prior to the…