NTSB investigations: Boeing A75N1(PT17)
5 cases on aircraft the registry lists as Boeing A75N1(PT17), where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1996 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1380134')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1380134')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 LAX96LA291Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Tracy, CAA loss of engine power due to the disengagement of the crankshaft gear from it's hub due to the overload shear of the eight retaining screws.NTSB FTW95LA360Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Evadale, TXA failure that resulted in separation of the #5 cylinder and loss of engine oil. The lack of suitable terrain for a forced landing was a related factor.NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.NTSB SEA83LA110Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Turner, WAThe acft nosed over during an emergency landing after an engine failure. The pilot stated that he had almost completed his spraying, when during a turn-around, the engine started to backfire. He dumped the remaining load and reduced power. The engine…NTSB ATL83LA066Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Anderson, SCAfter takeoff, while several hundred feet in the air, the engine backfired & quit. The plt was able to turn around & head back toward the arpt, but could not quite reach the rwy. The acft landed 1,000 ft short of the rwy, hit a ditch & flipped over. The plt…