NTSB investigations: Boeing A75N1(PT17), 1983
9 cases on aircraft the registry lists as Boeing A75N1(PT17). 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 | 43 |
|---|---|
| 1965 | 25 |
| 1966 | 39 |
| 1967 | 28 |
| 1968 | 35 |
| 1969 | 28 |
| 1970 | 20 |
| 1971 | 21 |
| 1972 | 20 |
| 1973 | 32 |
| 1974 | 30 |
| 1975 | 23 |
| 1976 | 19 |
| 1977 | 12 |
| 1978 | 10 |
| 1979 | 14 |
| 1980 | 11 |
| 1981 | 12 |
| 1982 | 10 |
| 1983 | 9 |
| 1984 | 5 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 8 |
| 1988 | 3 |
| 1989 | 8 |
| 1990 | 6 |
| 1991 | 5 |
| 1992 | 5 |
| 1993 | 9 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 8 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 3 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
| 2009 | 4 |
| 2010 | 5 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 7 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 5 |
| 2022 | 4 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 2 |
| 2026 | 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\") = 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 ('1380134'))
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 ('1380134'))
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 SEA84FA011Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Brewster, WAThe plt was positioning the acft for swath runs when it crashed into rising terrain on the side of a hill next to a valley. The plt had planned to make swath runs over an orchard in the valley. During impact, he received serious head injuries & could not…NTSB LAX84IA014Incident · No injuriesIncident investigationFinal reportCessna 152II · Woodland, CAThe Cessna 152 was performing a touch and go landng and had just taken off when the Boeing stearman landed on the left wing and propeller of the Cessna 152. Both acft landed sucessfully and taxied clear of the runway. Both acft were broadcasting their…NTSB MIA83LA243Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · St. Augustine, FLOn the previous flt, the plt noted that the left brake was weaker than the right brake. Before taking off again, he added fluid to the left brake sys. After flying about 1 hr, he returned & landed. During the landing roll, the left brake failed to operate.…NTSB CHI83LA422Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Galesburg, ILAfter landing at the Galesburg arpt, the plt was turning onto the taxiway when the acft ground looped in strong wind conditions. The left wing was substantially damaged during the mishap.NTSB CHI83LER03Accident · Serious injuriesFinal reportBoeing A75N1 · Sabin, MNAcft collided with power lines.NTSB MKC83LA131Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Benkelman, NEThe plt stated he was flying at a low altitude along a river when the eng failed.NTSB SEA83LA110Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Turner, WAThe acft nosed over during an emergency landing after an engine failure. The pilot stated that he had almost completed his spraying, when during a turn-around, the engine started to backfire. He dumped the remaining load and reduced power. The engine…NTSB CHI83LA232Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 · Lebanon, INThe plt had flown the acft to boone county arpt to get the acft's carburetor adjusted. After the adjustment, he took off to the south on a grass rwy beside the concrete rwy. While climbing thru about 300 to 400 ft AGL, the eng began running rough. The plt…NTSB FTW83LA219Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Iowa, LAThe acft nosed over during an off arpt landing. The plt stated that he was landing to check his aerial application load and talk to a farmer. During touchdown the main landing gear dug into the soft ground and the acft nosed over.