NTSB investigations: North American AT-6
11 cases on aircraft the registry lists as North American AT-6. 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
| 1965 | 1 |
|---|---|
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2016 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6400402'))
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 ('6400402'))
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 WPR16FA112Accident · 2 fatalField investigationFinal reportNorth American AT 6 · Mesa, AZThe pilot's inability to return to the departure airport due to an unspecified in-flight emergency for reasons that could not be determined during a postaccident examination of the airplane.NTSB CEN10CA565Accident · No injuriesData collectionFinal reportNorth American AT-6 · Blakesburg, IAThe pilot's excessive airspeed during the landing, which resulted in his decision to perform an intentional ground loop to avoid a runway overrun.NTSB SEA08CA215Accident · No injuriesData collectionFinal reportNorth American AT-6 · Arlington, WAThe front seated pilot's inadequate compensation for the right quartering tailwind and failure to maintain directional control. Also causal was the rear seated pilot's inadequate remedial action and failure to regain directional control.NTSB CHI03LA285Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Omaha, NEThe pilot not maintaining aircraft control during the landing roll. Factors were the grass the airplane encountered when the airplane ground looped off the runway and the main gear collapsed.NTSB LAX01LA183Accident · No injuriesLimited investigationFinal reportNorth American AT-6 D · Prescott, AZThe pilot's inadequate compensation for an existing crosswind condition.NTSB LAX95LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6F · Long Beach, CAthe failure of the left main landing gear locking mechanism to fully seat in the 'down' position due to loose attachment bolts.NTSB BFO93LA142Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Matawan, NJThe water collection in the ignition harness which rendered the lower cylinder spark plugs inoperative resulting in partial power loss.NTSB LAX91LA384Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Hayward, CAThe failure of the pilot to maintain directional control of the aircraft while correcting an unwanted deviation.NTSB NYC90LA142Accident · 1 fatalLimited investigationFinal reportNorth American AT-6 · Buffalo, NYLoss of control in flight due to physical impairment. Factors related to the accident were: the pilots use of an over the counter antihistamine.NTSB LAX89LA114Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6 · Compton, CAFatigue cracks that existed in an engine cylinder.NTSB FTW65A0106Accident · 2 fatalClosedN.American T 6G · Pampa, TX