NTSB investigations: North American T-6G

7 cases on aircraft the registry lists as North American T-6G, where the first occurrence was “Loss of control - on ground/water”. 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

19852026

NTSB investigations: North American T-6G per year, 1985–2026: 7 cases
1985	2
1986	1
1988	1
1990	1
1991	1
2003	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 ('6400432', '05629FV') 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" = 260)) 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 ('6400432', '05629FV')
      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\" = 260))
  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 ('6400432', '05629FV')
    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" = 260))
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 ATL04IA002Incident · No injuriesIncident investigationFinal reportNorth American T6G · Clayton, GAThe pilot's inadequate compensation for wind conditions that resulted in his failure to maintain directional control during landing roll. A factor was gusting tailwinds.Oct 2, 2003 · N2831D · Minor damage NTSB NYC91LA253Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Manchester, NHThe pilot's failure to maintain control. A factor was the unforecasted strong cross winds.Sep 29, 1991 · N3167G · Substantial damage NTSB DEN90LA061Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Englewood, COTo be a failure of the pilot to maintain directional control.Mar 11, 1990 · N2879G · Substantial damage NTSB ATL89LA008Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · West Jefferson, NCDuring a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem.Oct 8, 1988 · N7704C · Substantial damage NTSB DEN86LA258Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Englewood, COPlt made two unsuccessful attempts to land on rwy 26 but discontinued each approach because of unfavorable winds. Winds were reported to be 220 deg at 20 KTS with gusts to 30 KTS. Plt then made two unsuccessful attempts to land on rwy 17L. On third attempt…Sep 25, 1986 · N66TY · Substantial damage NTSB LAX85LA340Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Tucson, AZThe tailwheel equipped acft nosed over after the plt lost iirecitional control during lndg. There were no reports of mechanical difficulties or weather facotrs to be considered in the area of cause. The plts flt experience is unknown since repeated attempts…Aug 4, 1985 · N45CT · Substantial damage NTSB FTW85LA162Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Frederick, OKThe passenger heard a loud mechanical noise from the tail of the aircraft during rollout from a touch-and-go landing. The pilot was unable to maintain directional control, the aircraft ground looped, the main landing gear collapsed, and the wings were…Mar 23, 1985 · N9035Z · Substantial damage