NTSB investigations: Boeing A75N1(PT17)

9 cases on aircraft the registry lists as Boeing A75N1(PT17), where the first occurrence was “In flight encounter with weather”. 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

19822026

NTSB investigations: Boeing A75N1(PT17) per year, 1982–2026: 9 cases
1982	1
1985	1
1987	1
1989	1
1991	1
1992	1
1993	1
1998	1
2004	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" = 240)) 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\" = 240))
  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" = 240))
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 NYC05CA004Accident · Minor injuriesData collectionFinal reportBoeing Stearman B75-N1 · Jaffery, NHThe pilots inadvertent encounter with a downdraft wind condition and the airplane's inability to climb, which resulted in a forced landing. A factor related to the accident was the downdraft wind conditions.Oct 9, 2004 · N49738 · Substantial damage NTSB LAX98LA279Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Big Bear, CAThe pilot's encounter with an unfavorable wind condition, which caused the aircraft to descend at a rate that exceeded the aircraft's climb capability.Aug 29, 1998 · N56856 · Destroyed NTSB FTW94LA054Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Madisonville, TXThe pilot's continued flight into adverse weather. Factors were weather conditions and collision with a sign.Dec 19, 1993 · N55133 · Substantial damage NTSB MIA92LA105Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deland, FLThe pilot's inadequate compensation for wind conditions.Apr 4, 1992 · N50072 · Substantial damage NTSB DEN91LA124Accident · No injuriesLimited investigationFinal reportBoeing A 75N1 · Lordsburg, NMUnexpected encounter with adverse wind (downdraft).Sep 2, 1991 · N61248 · Substantial damage NTSB SEA90LA008Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Salmon, IDFailure of pilot to properly evaluate weather conditions through mountainous terrain and fly at an altitude high enough to maintain terrain clearance.Oct 19, 1989 · N75863 · Destroyed NTSB FTW88DQG01Accident · No injuriesFinal reportBoeing A75N1 · Fort Stockton, TXThe pilot stated that during the flare for a full stall landing in the tail wheel equipped aircraft, a whirlwind was encountered. He said he applied full power & full left aileron & rudder, but could not recover. Subsequently, the aircraft struck an…Oct 11, 1987 · N54279 · Substantial damage NTSB FTW85LA121Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Holmwood, LAThe acft was 1 of 2 that were being repositioned form 1 ag strip to another. While en route, the flt encountered dense fog & the lead plt initiated a 180 deg turn. During the turn, the 2nd acft (N60885) was about 100 ft in trail of the 1st acft at aprx 150 ft…Feb 19, 1985 · N60885 · Substantial damage NTSB CHI82DA295Accident · No injuriesFinal reportBoeing Stearman A75-300N1 · Whitehall, WIThe pilot received a weather briefing before takeoff, and reportedly, was advised that VFR flight was not recommended. During the flight, the ceiling and visibility began to decrease. The pilot decided to make a precautionary landing in a field. He stated…Aug 5, 1982 · N802RB · Substantial damage