NTSB investigations: Boeing A75N1(PT17)

6 cases on aircraft the registry lists as Boeing A75N1(PT17), where the first occurrence was “Loss of engine power(partial) - nonmechanical”. 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

19882026

NTSB investigations: Boeing A75N1(PT17) per year, 1988–2026: 6 cases
1988	1
1989	2
1990	1
2000	1
2002	1

Where

Open the map

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."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" = 354)) 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.\"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\" = 354))
  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" = 354))
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 ATL02LA105Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Panacea, FLLoss of engine power due to fuel starvation resulting from fuel restriction through the fuel shutoff valve.May 24, 2002 · N5545F · Substantial damage NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.Jul 13, 2000 · N53131 · Substantial damage NTSB FTW90LA130Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · San Antonio, TXPilot's failure to maintain adequate speed. Contributing to the accident was the momentary power loss.Jul 2, 1990 · N66302 · Substantial damage NTSB BFO89LA056Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bealeton, VAWater in the fuel, which resulted in a momentary loss of power during an inverted low pass, and the pilot's failure to plan the maneuver to allow for appropriate remedial action.Jul 9, 1989 · N56940 · Destroyed NTSB ATL89FA114Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Covington, GAInadequate preflight by the pilot by inadvertently allowing the carburetor heat to be in the 'hot' position for takeoff. The high density altitude and trees were considered to be contributing factors.Mar 26, 1989 · N55530 · Substantial damage NTSB SEA88LA087Accident · Minor injuriesLimited investigationFinal reportStearman A-75-N1 · Medford, ORPlt performed a negative 'g' maneuver, estimated at 2 to 2.5 negative 'g' force, following which the engine lost power. A forced landing was accomplished in scrub trees. The engine is equipped with a float carburetor. There were indications that the cause of…May 1, 1988 · N53125 · Substantial damage