NTSB investigations: Boeing A75N1(PT17), KS
15 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 |
|---|---|
| 1966 | 2 |
| 1969 | 1 |
| 1971 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 2011 | 2 |
| 2015 | 1 |
| 2016 | 2 |
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\" = 'KS' 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" = 'KS' 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 GAA17CA053Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Valley Center, KSThe pilot's failure to maintain directional control during the landing roll and to see and avoid the airplane stopped on the edge of the runway.NTSB CEN16LA177Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Osage City, KSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB CEN11LA375Accident · No injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Junction City, KSThe degraded engine performance due to low compression on the cylinder and delayed ignition timing.NTSB CEN11CA256Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Wichita, KSThe pilot's failure to maintain directional control during the landing roll.NTSB MKC75DCQ56Accident · No injuriesClosedBoeing A75N1 · Stafford, KSNTSB MKC74DCQ47Accident · No injuriesClosedBoeing A75 · Hepler, KSNTSB MKC74FCQ11Accident · No injuriesClosedBoeing A75L · Ingalls, KSNTSB MKC73DCQ29Accident · Minor injuriesClosedBoeing A75N1 · Pittsburg, KSNTSB MKC72FCQ10Accident · No injuriesClosedBoeing A75N1 · Abilene, KSNTSB MKC71DCQ35Accident · No injuriesClosedBoeing A75N1 · Liberal, KSNTSB MKC70F0198Accident · Serious injuriesClosedBoeing A75N1 · Basehor, KSNTSB MKC67F0060Accident · No injuriesClosedBoeing A75N1 · Mcdonald, KSNTSB MKC66D0586Accident · No injuriesClosedBoeing A75 · Berryton, KSNTSB UNK64X2841Accident · No injuriesClosedBoeing A75 · Norton, KS