NTSB investigations: Piper PA-34-200T, 1986
9 cases on aircraft the registry lists as Piper PA-34-200T. 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
| 1971 | 1 |
|---|---|
| 1975 | 4 |
| 1976 | 5 |
| 1977 | 8 |
| 1978 | 10 |
| 1979 | 9 |
| 1980 | 17 |
| 1981 | 12 |
| 1982 | 14 |
| 1983 | 11 |
| 1984 | 8 |
| 1985 | 10 |
| 1986 | 9 |
| 1987 | 7 |
| 1988 | 9 |
| 1989 | 6 |
| 1990 | 6 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 7 |
| 1996 | 7 |
| 1997 | 9 |
| 1998 | 5 |
| 1999 | 4 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 5 |
| 2007 | 7 |
| 2008 | 6 |
| 2009 | 5 |
| 2010 | 3 |
| 2012 | 2 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 3 |
| 2019 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 1986
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103406'))
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") = 1986
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103406'))
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 ATL87LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt had suspected a hydraulic problem prior to departure when hydraulic fluid was found on the hangar floor. The acft was flown to a nearby arpt for repairs. The acft then departed and aprx 1 hr into the flt a heater problem was experienced. The plt…NTSB MIA87LA036Accident · 2 fatalLimited investigationFinal reportPiper PA-34-200T · Isabela, PRThe acft was reported missing while on a personal flight from san juan PR to aguadilla PR. The plts last radio contact was with aguadilla tower requesting an alternate arpt to land because they were in heavy rain. The coast guard initiated a search and found…NTSB CHI87DEV01Accident · No injuriesFinal reportPiper PA-34-200T · Bloomington, ILAccording to the plt, the acft bounced upon touchdown. She attempted to reflare the acft, however, it bounced again and a go-around was performed. The acft was then landed without further incident. Following the landing it was determined the acft had received…NTSB ATL86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt received a wx briefing prior to takeoff which forecasted widely scattered thunderstorms. On arrival at destination a thunderstorm was over the arpt. The plt executed an ILS rwy 14 apch. A preceding DC-9 made a missed approach due to tower reported…NTSB LAX86LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Long Beach, CAThe airplane crashed on final approach to runway 16L at Long Beach airport (lgb), Long Beach, California. The pilot reported that both engines sustained a total loss of power. The airplane's altitude was insufficient to land on the airport. The left fuel tank…NTSB MKC86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Olathe, KSDuring a takeoff roll fm johnson county executive airport, the PIC stated that the left landing gear collapsed and the aircraft impacted the rwy and veered off into soft terrain. Inspection revealed that when electrical power was initiated and the gear switch…NTSB ATL86FA137Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Valdosta, GAThe left engine lost power shortly after takeoff and the pilot did not feather the propeller. A traffic pattern was flown with the aircraft in a continuous descent. Insufficient altitude remained to maneuver the aircraft to the runway, so the pilot elected to…NTSB ATL86LLT08Incident · No injuriesFinal reportPiper PA-34 · Smithville, TNThe acft ran off the departure end of the rwy during landing. The acft reportedly landed 1/2 way down the 3400 ft rwy. The plt stated in a post acc interview that he was 'too high too fast and too long.'NTSB NYC86LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Boston, MAThe pilot was attempting to start the aircraft for a cross country flight. The weather was cold. Initially. The pilot stated the engine started but stopped. The pilot pulled key from ignition, pulled back throttle and closed the mixture before exiting the…