NTSB investigations: Boeing A75N1(PT17), IN
11 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 | 2 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 2010 | 1 |
| 2023 | 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\" = 'IN' 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" = 'IN' 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 CEN23LA156Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Evansville, INThe pilot’s failure to engage the tailwheel lock before landing which resulted in the loss of control and ground loop.NTSB CEN10LA351Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Indianapolis, INThe pilot's inability to maintain directional control during landing due to the airplane not being equipped with a steerable or locking tailwheel as required by the airplane's design.NTSB CHI94LA188Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Paris, INthe pilot's inadequate visual lookout. Factors associated with the accident are a fence post, and the pilot's lack of familiarity with the geographic area (landing environment).NTSB CHI87LA225Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Rochester, INThe tailwheel aircraft was landed into a strong left crosswind, experienced a loss of directional control, followed by a ground loop, and nose over.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 CHI79FEX28Accident · Minor injuriesClosedBoeing A75N1 · Indianapolis, INNTSB CHI77DEX40Accident · No injuriesClosedStearman PT-17 · Converse, INNTSB CHI72FEA01Accident · No injuriesClosedBoeing A75N1 · Greensburg, INNTSB CHI69D0637Accident · Minor injuriesClosedBoeing A75N1 · Mackey, INNTSB CHI66D0208Accident · No injuriesClosedBoeing A-75N1 · Indianapolis, INNTSB CHI65F0095Accident · Serious injuriesClosedBoeing A75N1 · Plainville, IN