NTSB investigations: Air Tractor AT-301
18 cases on aircraft the registry lists as Air Tractor AT-301, where the first occurrence was “Loss of engine power(partial) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1997 | 2 |
| 2003 | 1 |
| 2007 | 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 ('0390103', '0390105')
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\" = 352))
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 ('0390103', '0390105')
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" = 352))
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 DEN07LA138Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Alamosa, COThe failure of the number one cylinder due to fatigue. Contributing to the accident was the pilot's diminished visual lookout due to the oil covered windscreen.NTSB NYC03LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Rhinebeck, NYA loss of engine power due to a failure of the number eight cylinder.NTSB ATL97LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clewiston, FLThe crack in the #8 cylinder head which led to the loss of power. A factor was the soft terrain.NTSB MIA97LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Waynesboro, GAThe obscured vision of the pilot due to oil covering the windscreen. Contributing to the accident was the partial loss of engine power due to a cracked head of one of the cylinders and unsuitable terrain encountered during the forced landing.NTSB SEA95LA154Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roberts, IDA loss of engine power due to the separation of the number 3 cylinder exhaust valve rocker arm shaft from the cylinder head, which disabled movement of the exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB ATL93LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Deatsville, ALWas a crack in no.3 cylinder head which resulted in the loss of engine power.NTSB LAX93LA327Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAThe failure of the master rod which resulted in a complete loss of engine power and subsequent forced landing. The irrigation ditch was a factor in this accident.NTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.NTSB MIA91LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · High Springs, FLLoss of engine power due to disintegration of the impeller caused by a worn impeller bearing.NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.NTSB SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.NTSB MIA89LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Fort Pierce, FLFailure of the number five cylinder. Factors related to the accident were: the proximity of homes in the area, which precluded jettisoning of the chemical load, and high vegetation in the emergency landing area.NTSB FTW89DPJ03Accident · No injuriesFinal reportAir Tractor 301 · Jefferson, OKLoss of engine power, due to a cracked number 4 cylinder. A factor related to the accident was: the terrace (dirt bank) in the emergency landing area.NTSB MIA88LA147Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hastings, FLWhile on an aerial application flt shortly after takeoff, the eng lost power. The plt then dumped the load of fertilizer & landed the acft in a field. After touchdown it nosed over & came to rest. Examination of the eng revealed that the no. four cylinder…NTSB FTW87DPJ06Accident · No injuriesFinal reportAir Tractor AT301 · El Dorado, OKThe pilot stated that during takeoff from a county road, black smoke started coming out of the engine exhaust. The aircraft then collided with a tree and a post causing substantial damage. It was found that the carburetor heat system had been modified and the…NTSB FTW87DPJ04Accident · No injuriesFinal reportAir Tractor 301 · Oluskee, OKDuring aerial application the engine sustained a power loss due to separation of the number 9 cylinder head. During the forced landing in rough terrain the aircraft was substantially damaged.NTSB LAX84LA445Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · San Joaquin, CAThe Air Tractor was on takeoff initial climb and was about 20 ft high when the engine began to backfire. The aircraft settled into the cotton field and rotated about 90 degrees after ground contact. The plt reported that the number one cylinder was found to…NTSB FTW82DA101Accident · No injuriesFinal reportSnow AT-301 · Spearman, TXWhen the aircraft lost power after spraying crops the pilot executed a forced landing in a field. During the landing the aircraft nosed over. Investigation revealed that an induction hose had failed and blocked the carburetor. A service letter relating to…