NTSB investigations: Boeing A75N1(PT17), CO
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
| 1965 | 1 |
|---|---|
| 1968 | 2 |
| 1973 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1998 | 1 |
| 2001 | 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\" = 'CO' 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" = 'CO' 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 DEN01LA159Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Watkins, COthe pilot's failure to maintain clearance with the guy wire.NTSB FTW98LA168Accident · No injuriesLimited investigationFinal reportBoeing A75N (PT-17) · Grand Junction, COFailure by the pilot to maintain control of the aircraft during landing roll. Factors were variable winds and the pilot's lack of recent experience in make and model.NTSB DEN90LA040Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Ft Collins, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the aircraft.NTSB DEN88DTE02Accident · 1 fatalFinal reportBoeing A75N1 · Keenesburg, COThe commercial ag plt was starting a spray run on a new field. During the first pass, the aircraft struck power line wires. The aircraft rolled left and impacted the terrain in a wings level, nose low attitude. An immediate post crash fire destroyed the…NTSB DEN85LA139Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Grand Junction, COThe plt reported that as he arrived at the destination (canyonlands, UT), there was a storm over the arpt, so he diverteded toward delta, CO. About 10 mi from delta, he encountered another storm, so he turned toward Grand Junction, CO. Before reaching the…NTSB DEN74FTE16Accident · No injuriesClosedBoeing A75N1 · Sheridan Lke, CONTSB DEN68D0264Accident · No injuriesClosedBoeing A75N1 · Byers, CONTSB DEN68D0259Accident · No injuriesClosedBoeing A75N1 · Anton, CONTSB DEN65A0076Accident · No injuriesClosedBoeing A-75N1 · Broomfield, CO