NTSB investigations: Boeing A75N1(PT17), OK
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
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1975 | 3 |
| 1976 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 2022 | 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\" = 'OK' 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" = 'OK' 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 CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.NTSB FTW86LA037Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Yukon, OKThe left brake locked after the aircraft rolled a short distance during landing. Aircraft slowed until about 20 mph forward speed and then flipped inverted and stopped. Post accident examination revealed the brake shoe return spring on the left brake was…NTSB FTW82FPM13Accident · Serious injuriesFinal reportBoeing A75 · Tulsa, OKA witness located at the departure end of the runway stated that the aircraft climbed to an altitude of approximately 400 feet when the engine stopped running. In a nose high atitude the left wing was observed to drop and a stall occurred. The pilot had no…NTSB FTW81DPJ14Accident · No injuriesClosedBoeing A75 · Covington, OKNTSB FTW76DPJ26Accident · Minor injuriesClosedBoeing A75N1 · Eldorado, OKNTSB FTW76FPM10Accident · Minor injuriesClosedBoeing A75N1 · Blanco, OKNTSB FTW76FPM08Accident · Minor injuriesClosedBoeing A75N1 · Hartsharne, OKNTSB FTW76FPJ10Accident · 1 fatalClosedBoeing E75 · Fort Cobb, OKNTSB FTW74FPM14Accident · No injuriesClosedBoeing A75 · Tulsa, OKNTSB FTW74DPJ04Accident · No injuriesClosedBoeing A75N1 · Minco, OKNTSB FTW72FPM33Accident · No injuriesClosedBoeing A75 · Blocker, OKNTSB FTW72DPJ26Accident · No injuriesClosedBoeing A75N1 · Hollis, OKNTSB FTW70DPM11Accident · No injuriesClosedBoeing A75N1 · Vera, OK