NTSB investigations: Piper PA-28R-201T, 1983
6 cases on aircraft the registry lists as Piper PA-28R-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
| 1977 | 5 |
|---|---|
| 1978 | 10 |
| 1979 | 6 |
| 1980 | 8 |
| 1981 | 9 |
| 1982 | 8 |
| 1983 | 6 |
| 1984 | 8 |
| 1985 | 3 |
| 1987 | 3 |
| 1988 | 8 |
| 1989 | 1 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 8 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2020 | 3 |
| 2024 | 1 |
| 2025 | 2 |
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\") = 1983
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102813'))
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") = 1983
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102813'))
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 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…NTSB LAX84LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Chandler, AZPrior to landing the plt observed that the gear down light for the right gear did not illuminate. He recycled the gear 2 or 3 times, but the green gear down light would not illuminate. Ground personnel reported to the plt that the gear appeared to be down.…NTSB FTW84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Smithville, TXDuring cruise at 8,500 ft MSL the eng quit. A night emergency landing was made at an arpt that the acft had just flown over. On final approach the plt could not see thru the windshield very well due to oil building up on the windshield. The plt held the gear…NTSB FTW83LA411Accident · No injuriesLimited investigationFinal reportPiper PA28R-201T · Anton Chico, NMDuring flt, the plt heard a 'pop' noise which was followed by a loss of power. The fuel flow indicated zero & he was unable to start the eng. During a forced landing, the left wing hit a bush which caused the acft to swerve & the main gear to collapse. An…NTSB CHI83LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Jackson, MIComplete electrical failure occurred at 8,000 ft. the plt diverted to Jackson & the acft landed wheels-up. The plt laterstated that he thought he was familiar with the emergency gear extension procedures in the flt manual but that he might not have put the…NTSB MKC83FA060Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Salem, MODuring the 0910 telephone wx briefing by the st. louis fss, the plt mentioned that there was ground fog in the Salem area. At about 1010 the plt departed from rwy 16, made a left turn & crossed the arpt heading north. A witness who drovethe plt to the arpt…