NTSB investigations: Piper PA-28, 1985
3 cases on aircraft the registry lists as Piper PA-28. 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
| 1964 | 16 |
|---|---|
| 1965 | 15 |
| 1966 | 9 |
| 1967 | 13 |
| 1968 | 8 |
| 1969 | 6 |
| 1970 | 9 |
| 1971 | 7 |
| 1972 | 3 |
| 1973 | 4 |
| 1974 | 3 |
| 1975 | 3 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 1 |
| 1985 | 3 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2021 | 1 |
| 2022 | 3 |
| 2024 | 2 |
| 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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102801'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102801'))
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 FTW86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Houston, TXThe passengers stated that the pilot was unable to obtain higher power settings on a go-around from a low approach to an airport, and elected to land on a rural street. An examination of the engine revealed insect nests in the intake manifold and water in the…NTSB MKC85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Springfield, MODuring a wx briefing, the plt was advised of possible thunderstorms at his destination. While en route, he was told that thunderstorm activity at his destination was confirmed by radar. During the last 40 min of the flt, the plt flew past aprx 15 arpts where…NTSB LAX85LA242Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Springville, CAAfter overflying the uncharted, private airstrip & evaluating its size, the PIC attempted to land on the narrow rwy. Only about 900 ft of the rwy was usable. After touching down, the plt realized the acft could not be stopped on the remaining available strip,…