Fatal NTSB investigations: North American T-28A
11 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1973 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"highestInjuryLevel\" = 'Fatal'
AND 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."highestInjuryLevel" = 'Fatal'
AND 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" DESCRun 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, GermanyNTSB WPR19FA215Accident · 1 fatalClass 3 · FieldFinal reportNorth American T28A · Ontario, ORA total loss of engine power due to the improperly adjusted carburetor idle valve.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.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.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…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…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…NTSB SEA73AS026Accident · 2 fatalClosedN.American T-28A · Gorst, WANTSB UNK69X0139Accident · 1 fatalClosedN.American T-28A · Bigbar Crk, CanadaNTSB LAX68F0400Accident · 1 fatalClosedN American T-28A · Holbrook, AZNTSB UNK64X3928Accident · 1 fatalClosedN. American T-28A · Houston, TX