NTSB investigations: Piper PA-18-105 SPECIAL, 1983
2 cases on aircraft the registry lists as Piper PA-18-105 SPECIAL. 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 | 5 |
|---|---|
| 1965 | 4 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 2 |
| 1972 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2007 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2021 | 4 |
| 2022 | 1 |
| 2024 | 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\") = 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 ('7101808'))
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 ('7101808'))
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 LAX84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Oceanside, CAThe acft collided with a fence during landing roll. The private plt receiving instruction in conventional gear acft was making his second landing. After rolling 150 ft the acft made a skidding right turn and veered off the right side of therwy. The CFI was…NTSB FTW84LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 Special · Wichita Falls, TXThe plt reported that during a landing with a quartering left head wind, the right brake did not hold & the acft veered to the left. He added power in an attempt to avoid a ground loop; however, the acft went in a wet, plowed field & nosed over. Reportedly,…