NTSB investigations: Boeing PT-13D

7 cases on aircraft the registry lists as Boeing PT-13D. 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

19672026

NTSB investigations: Boeing PT-13D per year, 1967–2026: 7 cases
1967	1
1975	1
1977	2
1983	1
1987	1
2025	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 ('1380122')) 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 ('1380122'))
  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 ('1380122'))
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 WPR26LA066Accident · No injuriesClass 4 · LimitedFinal reportBoeing PT-13D · El Cajon, CAThe pilot's failure to maintain directional control during the landing roll.Dec 19, 2025 · N68830 · Substantial damage NTSB LAX87LA122Accident · Serious injuriesLimited investigationFinal reportBoeing PT-13D · Vacaville, CAThe aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the…Feb 22, 1987 · N620BD · 2 aircraft · Substantial damage NTSB CHI83LA420Accident · No injuriesLimited investigationFinal reportBoeing PT-13D · Galesburg, ILDuring the landing roll, the left main tire blew out & the plt lost directional control. Subsequently, the acft ground looped & the left wing & aileron were damaged.Sep 7, 1983 · N620BD · Substantial damage NTSB OAK77FVM21Accident · No injuriesClosedBoeing PT-13D · Morgan Hill, CAAug 9, 1977 · N55520 · Substantial damage NTSB DEN77FQA35Accident · No injuriesClosedStearman E75 · Cuba, NMMay 12, 1977 · N121R · Substantial damage NTSB OAK76FXQ15Accident · 1 fatalClosedStearman PT-17 · Reno, NVSep 12, 1975 · N121R · Minor damage NTSB FTW67F0603Accident · Serious injuriesClosedBoeing E-75 · Nome, TXApr 30, 1967 · N3992B · Destroyed