NTSB investigations: Air Tractor AT-301
26 cases on aircraft the registry lists as Air Tractor AT-301, where the first occurrence was “Loss of engine power(total) - 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 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 3 |
| 2001 | 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\" = 351))
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" = 351))
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 FTW02LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Anton, TXThe total loss of engine power while maneuvering due to a cracked cylinder, which resulted in a forced landing. A factor was lack of suitable terrain for the forced landing.NTSB FTW00LA168Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXthe loss of engine power in cruise flight as a result of the failure of the right magneto. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA159Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXThe failure of the supercharger seal resulting in the loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA087Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brawley, CAFailure of the engine due to improper installation of the intake and exhaust push rods (components were switched) by unknown maintenance personnel.NTSB LAX98LA090Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Wasco, CAThe pilot overboosting the engine on takeoff which resulted in a cracked cylinder and subsequent loss of engine power.NTSB FTW96LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Griffithville, ARloss of engine oil (leak) for an undetermined reason, which resulted in oil starvation and a loss of engine power; and failure of the pilot to maintain airspeed during the emergency descent/landing phase, which resulted in an inadvertent stall and subsequent…NTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.NTSB SEA95LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Havre, MTthe loss of power due to a failure of the cylinder head exhaust valve rocker box. The tall crop encountered during the forced landing is a factor.NTSB CHI95LA198Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Hoxie, KSthe loss of engine power due to the loose nut on the adjustment screw and the jammed exhaust valve on the number three cylinder. A factor in the accident was the ditch.NTSB FTW95LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Caldwell, ARThe loss of power due to a crack in the #4 cylinder. Factors were the lack of suitable terrain for the forced landing and proper touchdown point not possible.NTSB ATL94LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Smithville, GAThe failure of # 2 cylinder head.NTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.NTSB FTW92DPG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power. A factor was the unsuitable terrain.NTSB ATL91LA059Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Pavo, GAThe failure of the no. 2 exhaust valve and cylinder head, which resulted in a total loss of engine power. A factor in the accident was the collision with a road sign during the forced landing.NTSB FTW90DPG08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Corning, ARBlockage of the carburetor Air intake by a collapsed Air induction hose due to improper maintenance by an unknown party.NTSB LAX88DVG07Accident · No injuriesFinal reportSnow AT-301 · Davis, CAAt the end of an aerial application flight, en route to home base, the engine quit. The pilot made an emergency landing in a field, where during the landing roll the airplane collided with a bale of hay and nosed over. Inspection of the engine revealed that…NTSB MIA87LA244Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Belle Glade, FLThe plt stated that he was spraying water to clean out his hopper tank. During approach to land the eng quit. Unable to reach the airstrip the plt landed on a road. On landing rollout on the road he struck a hidden 55 gallon drum with the right wing tip, spun…NTSB DEN87LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Conrad, MTAn ag plt was returning from an aerial application. Six miles from the destination arpt the engine quit. The plt attempted to land on a road but the acft struck the edge of a pit, spun across the road and came to rest facing 180 degrees from the original…NTSB FTW87DPJ02Accident · Serious injuriesFinal reportAir Tractor AT-302 · Colony, OKDuring a downwind swath run the number one compressor bearing failed in the ltp 101-600-1A engine which resulted in the engine failing completely. During an attempt to turn into the wind for an emergency landing the left wing tip struck the ground and the…NTSB CHI85LA283Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Roseau, MNThe aircraft had been airborne about 15 min engaged in ag spray operations when the pilot described hearing a loud band. Engine power decreased to idle. Pilot ld in soft soil and nosed over inverted. Exam disclosed #2 piston had failed.NTSB DEN85LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clovis, NMAs the plt was pulling up over a power line at the end of a spray run, the eng lost power & smoke began coming from the right side of the eng. The plt turned to land in a field, but was unable to align the acft with forrows. During a forced landing, the acft…NTSB FTW85LA017Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Seminole, TXThe plt reported that while on a local flt the engine 'blew up' & he made an emergency landing. He stated that the windshield was covered with oil & he could not see to flare the acft & landed hard. Inspection revealed a failure of the #4 rod at the master…NTSB MKC84LA260Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Dexter, MOThe engine on the ag-plane lost power during takeoff and the plt began dumping his load as he made a forced landing. Thelanding area available was a flooded rice levee. The acft was landed tailwheel first but when the main gear dug in, the acft nose over.…NTSB ATL83LA225Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fort Valley, GAThe eng quit at 200 ft AGL as the plt was returning to a strip. A forced landing was made in a wheat field & the acft rolled through a narrow tree line. The carb float was found cracked & leaking.NTSB FTW83LA166Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Newellton, LAAprx 1 minute after takeoff the acft engine failed. During the forced landing, the acft flipped inverted damaging one wing tip and the vertical stabalizer. Post crash inspection revealed a crack in the number 7 cylinder, from spark plug to spark plug, which…NTSB FTW82DA350Accident · No injuriesFinal reportAir Tractor AT-301 · Winnesboro, LAThe pilot was circling the field during alignment for his initial swath run when the aircraft engine failed. During the forced landing the aircraft nosed over and the pilot exited the aircraft without turning off any switches. He stated that fuel was leaking…