Skip to content

NTSB investigations: North American T-28A

21 cases on aircraft the registry lists as North American T-28A. 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6402504')) 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 ('6402504'))
  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 ('6402504'))
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 GAA26WA248Accident · 2 fatalClass 5 · ForeignNorth American T28 · Limburghof, GermanyMay 16, 2026 · N728NA · Destroyed NTSB WPR19FA215Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28A · Ontario, ORA total loss of engine power due to the improperly adjusted carburetor idle valve.Aug 9, 2019 · N9862C · Substantial damage NTSB CEN17LA250Accident · 1 fatalLimited investigationFinal reportNorth American T-28A · Moorhead, MNControlled descent into terrain due to engine issues, the reason for which could not be determined because examination of the engine revealed no evidence of malfunctions or failures that would have precluded normal operation.Jul 2, 2017 · N9103F · Destroyed NTSB CEN15LA360Accident · 1 fatalLimited investigationFinal reportNorth American T 28A · Las Cruces, NMFailure of the No. 6 cylinder connecting rod, due to improper rotation of the propeller during a previous hydraulic lock.Aug 14, 2015 · N14124 · Substantial damage NTSB CEN10LA272Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Oklahoma City, OKThe failure of the master rod bearing, which resulted in a loss of engine power.May 27, 2010 · N128AF · Substantial damage NTSB FTW03LA170Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Houston, TXThe failure of the nose wheel landing gear shimmy damper for undetermined reasons.May 30, 2003 · N14124 · Substantial damage NTSB SEA95LA192Accident · Serious injuriesLimited investigationFinal reportNorth American T-28A · Rexburg, IDfatigue failure of the main hydraulic line and a resulting hydraulic fluid fire. Lack of suitable terrain for the forced landing contributed to the accident.Aug 23, 1995 · N9640C · Destroyed NTSB MIA95LA138Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Arcadia, FLLoss of engine power due to separation of 3 connecting rods from the master rod for undetermined reasons(s).May 28, 1995 · N28FE · Substantial damage NTSB MIA93LA054Accident · Minor injuriesLimited investigationFinal reportNorth American T-28A · Plantation, FLFailure of the master rod main bearing which resulted in loss of engine power and a subsequent forced landing.Jan 27, 1993 · N203CB · Substantial damage NTSB SEA89LA058Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Jerome, IDThe failure of another person to report a hard landing which resulted in the airplane not being inspected by authorized personnel.Mar 18, 1989 · N128AF · Substantial damage NTSB CHI88DEM01Accident · Minor injuriesFinal reportNorth American T-28A · Schoolcraft, MIWhile the pilot was climbing through 7800 MSL he noticed a vapor trail coming from the right exhaust area. The pilot notified approach control that he was returning to the departure airport and they supplied radar vectors. The pilot started a descent and…Feb 24, 1988 · N14142 · Substantial damage NTSB DEN87FA121Accident · 2 fatalField investigationFinal reportNorth American T-28D · Tatum, NMAccording to friends of the plt, the acft left roswell, new Mexico, with 2 people aboard after an airshow with a destination of lovington, NM. Witnesses observed the acft flying in the distance and then observed a big cloud of dust rising from the ground. The…May 10, 1987 · N9611C · Destroyed NTSB MIA86FA033Accident · 1 fatalField investigationFinal reportNorth American T-28A · Lantana, FLThe pilot/mechanic had recently re-installed a rebuilt engine in the aircraft and performed a very short run-up prior to takeoff. Witnesses stated the aircraft engine made popping noises and was belching black smoke during the takeoff roll. The aircraft…Nov 23, 1985 · N9867C · Destroyed NTSB ATL84FLT10Accident · No injuriesFinal reportNorth American T-28 · Loudon, TNThe plt reported that he heard a loud bang in the acft eng & it lost pwr & started emmitting smoke. During a forced landing, the acft went thru 4 fences & hit a ditch, and the nose gear collapsed. A fire, which started in flt, destroyed the cockpit after the…Jun 23, 1984 · N700H · Destroyed NTSB DEN83FA058Accident · 1 fatalField investigationFinal reportNorth American T-28A · N. Winter Park, COAccording to the surviving passenger (the plt's 15 yr old son), they saw some skiers after crossing over a mountain pass. He stated that as they turned, his father said, 'let's buzz them.' He reported that they turned sharply, 'sort of dove down to buzz…Feb 12, 1983 · N28TW · Destroyed NTSB MIA74FLD10Accident · No injuriesClosedN.American T-28B · Venice, FLJul 23, 1973 · N9665C · Substantial damage NTSB SEA73AS026Accident · 2 fatalClosedN.American T-28A · Gorst, WAMar 24, 1973 · N2800N · Destroyed NTSB UNK69X0139Accident · 1 fatalClosedN.American T-28A · Bigbar Crk, CanadaAug 7, 1969 · N2814G · Destroyed NTSB LAX68F0400Accident · 1 fatalClosedN American T-28A · Holbrook, AZApr 10, 1968 · N7708C · Substantial damage NTSB UNK64X3928Accident · 1 fatalClosedN. American T-28A · Houston, TXSep 12, 1964 · N3662G · Destroyed NTSB UNK64X2615Accident · No injuriesClosedNo American T28A · San Fernando, CAJul 3, 1964 · N9862C · Substantial damage