NTSB investigations: Piper PA-34-200, 1993
7 cases on aircraft the registry lists as Piper PA-34-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
| 1972 | 6 |
|---|---|
| 1973 | 7 |
| 1974 | 15 |
| 1975 | 11 |
| 1976 | 14 |
| 1977 | 8 |
| 1978 | 15 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 5 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 5 |
| 1990 | 4 |
| 1991 | 1 |
| 1992 | 7 |
| 1993 | 7 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 7 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 1 |
| 2010 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 6 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 3 |
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 year(c.\"eventDate\") = 1993
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103405'))
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 year(c."eventDate") = 1993
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103405'))
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 NYC94LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Bowling Green, OHThe flight instructor's inadequate supervision of an attempted go-around by the student pilot which resulted in a loss of control and subsequent impact with the terrain. Factors were noncompliance with published procedures.NTSB CHI93LA361Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Fenton, MOFailure of the pilot to maintain lateral (roll) and directional control of the airplane, when one engine hesitated to respond to application of power during an attempted go-around. Factors related to the accident were: the crosswind and the pilot's inadequate…NTSB LAX93FA282Accident · Minor injuriesField investigationFinal reportPiper PA-34-200 · La Verne, CAThe flight instructor's failure to obtain/maintain best the single-engine rate-of-climb airspeed, and his failure to ensure that the landing gear was retracted. A factor related to the accident was contamination in the fuel system, which blocked fuel flow…NTSB LAX93LA236Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Sedona, AZA failure of the pilot to adequately compensate for the wind conditions and subsequent loss of directional control during the landing roll. A factor in the accident was a lack of total experience in the aircraft type.NTSB LAX93LA217Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jean, NV1) The pilots inadequate preflight inspection of the aircraft, 2) his failure to adequately compensate for the existing gusty wind conditions, and, 3) his failure to maintain an adequate landing approach airspeed. Contributing to the accident was the pilots…NTSB DEN93IA050Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Boulder, CONot determined.NTSB LAX93FA153Accident · 6 fatalField investigationFinal reportPiper PA-34-200 · Carpenteria, CAUndetermined.