NTSB investigations: Boeing A75N1(PT17), MO

10 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

NTSB investigations: Boeing A75N1(PT17), MO per year, 1964–2026: 10 cases
1964	1
1965	1
1967	1
1973	3
1987	1
1992	1
1993	1
2000	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."eventStateOrRegion" = 'MO' 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\" = 'MO' 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" = 'MO' 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 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 CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.Sep 12, 1993 · N54941 · Substantial damage NTSB CHI92LA133Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Washington, MOThe pilot in command's improper use of the carburetor heat control.Apr 26, 1992 · N59528 · Substantial damage NTSB MKC88LA006Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Creve Coeur, MOWhile practicing stop and go ldgs, plt lost control during rollout. Acft swerved and entered an inadvertent ground loop. The right main landing gear failed and the right lower wing contacted the ground.Oct 9, 1987 · N1754M · Substantial damage NTSB MKC74DCA04Accident · No injuriesClosedBoeing A75 · Hannibal, MOAug 9, 1973 · N60421 · Substantial damage NTSB MKC74FCG02Accident · No injuriesClosedBoeing A75N1 · Kansas City, MOJul 23, 1973 · N69696 · Substantial damage NTSB MKC73DCA19Accident · No injuriesClosedBoeing A75-N1 · Campbell, MOMar 28, 1973 · N75016 · Substantial damage NTSB MKC67D0576Accident · No injuriesClosedBoeing A75N1 · Sedalia, MOMay 9, 1967 · N61673 · Substantial damage NTSB MKC66D0052Accident · Minor injuriesClosedBoeing A75N1 · Duenweg, MOApr 24, 1965 · N59209 · Substantial damage NTSB UNK64X2147Accident · Minor injuriesClosedBoeing B75N1 · Mexico, MOJun 6, 1964 · N74650 · Substantial damage