NTSB investigations: Boeing A75N1(PT17), AZ
13 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 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1972 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2023 | 1 |
| 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 c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
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 WPR26LA138Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Mesa, AZThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR24LA015Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Mesa, AZThe flight instructor’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB LAX99LA126Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Mesa, AZThe pilot's inadequate compensation for the gusty and variable crosswind condition, which led to a loss of directional control and an inadvertent ground loop.NTSB LAX96LA208Accident · No injuriesLimited investigationFinal reportBoeing B75-A75N1 · Page, AZthe pilot's improper flare, improper recovery from a bounced landing, inadequate compensation for wind conditions, and failure to maintain directional control of the airplane, while landing in gusty/crosswind conditions. The gusty, crosswind condition was a…NTSB LAX91LA120Accident · No injuriesLimited investigationFinal reportBoeing A75 · Marana, AZThe failure of the pilot in the trailing airplane to maintain clearance from the lead airplane.NTSB LAX81FUJ39Accident · Minor injuriesClosedBoeing A75N1 · Phoenix, AZNTSB LAX79DUJ84Accident · No injuriesClosedBoeing A75 · Scottsdale, AZNTSB LAX73FUJ14Accident · No injuriesClosedBoeing A75N1 · Florence, AZNTSB LAX71FUJ12Accident · 1 fatalClosedBoeing A75N1 · Somerton, AZNTSB LAX70D0076Accident · No injuriesClosedBoeing PT-17 · Somerton, AZNTSB LAX70F0016Accident · Serious injuriesClosedBoeing A75N1 · Goodyear, AZNTSB LAX69D0123Accident · No injuriesClosedBoeing A75N1 · Parker, AZNTSB UNK64X1753Accident · No injuriesClosedBoeing A75 · Chandler, AZ