Skip to content

NTSB investigations: Boeing A75N1(PT17), WA

21 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'WA' 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

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\" = 'WA' 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" = 'WA' 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

Run 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 WPR19LA125Accident · Minor injuriesClass 3 · LimitedFinal reportStearman A75N1(PT17) · Sequim, WAThe total loss of engine power due to the fatigue failure of the crankshaft.Apr 28, 2019 · N68825 · Substantial damage NTSB WPR09CA328Accident · No injuriesData collectionFinal reportBoeing A75N1 · Gig Harbor, WAThe pilot's inadequate compensation for the crosswind and failure to maintain directional control.Jul 5, 2009 · N1431C · Substantial damage NTSB SEA01LA162Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Shelton, WAThe binding/grabbing of the right main gear braking system during the landing roll.Aug 29, 2001 · N53411 · Substantial damage NTSB SEA93LA086Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Davenport, WAUnsuitable terrain was selected for landing. A factor to the accident was: soft terrain.Apr 1, 1993 · N56426 · Substantial damage NTSB SEA84FA011Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Brewster, WAThe plt was positioning the acft for swath runs when it crashed into rising terrain on the side of a hill next to a valley. The plt had planned to make swath runs over an orchard in the valley. During impact, he received serious head injuries & could not…Oct 23, 1983 · N49385 · Destroyed 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…May 27, 1983 · N56426 · Substantial damage NTSB SEA81DYP42Accident · No injuriesClosedBoeing A75N1 · Orondo, WASep 17, 1981 · N56929 · Substantial damage NTSB SEA81FYP31Accident · No injuriesClosedBoeing A75N1 · Wenatchee, WAAug 3, 1981 · N49323 · Substantial damage NTSB SEA78DYP28Accident · Minor injuriesClosedBoeing A75N1 · Mansfield, WAApr 20, 1978 · N49385 · Substantial damage NTSB SEA77FYP32Accident · No injuriesClosedStearman A75N1 · Hunters, WAJul 1, 1977 · N68200 · Substantial damage NTSB SEA77DYE22Accident · No injuriesClosedStearman A75N1 · Port Angeles, WAApr 29, 1977 · N5728N · Substantial damage NTSB SEA75DYG29Accident · No injuriesClosedBoeing E75 · Dayton, WAApr 12, 1975 · N56426 · Substantial damage NTSB SEA74DYG41Accident · No injuriesClosedStearman E75 · Dayton, WAMay 17, 1974 · N49413 · Substantial damage NTSB SEA71DYG53Accident · No injuriesClosedBoeing A75N · Waterville, WAMay 18, 1971 · N56929 · Substantial damage NTSB SEA69F0159Accident · Minor injuriesClosedBoeing A75N1 · Sprague, WAOct 16, 1968 · N56919 · Substantial damage NTSB SEA68D0158Accident · No injuriesClosedBoeing B75 · Yakima, WASep 18, 1967 · N1145N · 2 aircraft · Minor damage NTSB SEA67F0342Accident · Minor injuriesClosedBoeing A75N1 · Lind, WAApr 28, 1967 · N58700 · Substantial damage NTSB SEA67F0099Accident · No injuriesClosedBoeing A75N1 · Sunnyside, WAAug 16, 1966 · N1153N · Substantial damage NTSB UNK64X3758Accident · 1 fatalClosedBoeing A75 · Quincy, WASep 3, 1964 · N49385 · 2 aircraft · Substantial damage NTSB UNK64X1148Accident · Minor injuriesClosedBoeing 75 · Colfax, WAApr 3, 1964 · N54950 · Destroyed NTSB UNK64X0979Accident · Serious injuriesClosedBoeing PT17 · Pullman, WAMar 19, 1964 · N58700 · Substantial damage