NTSB investigations: Piper PA-34-200, 2019
4 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\") = 2019
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") = 2019
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 CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.NTSB ERA19WA242Accident · No injuriesForeign investigationPiper PA34 · Bimini, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB CEN19FA238Accident · 2 fatalClass 3 · FieldFinal reportPiper PA34 · Gainesville, TXThe pilots’ failure to maintain airspeed while on final approach with asymmetric engine power, which resulted in a loss of control.NTSB CEN19LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Ypsilanti, MIThe pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…