NTSB investigations: Air Tractor AT-301, 1989
13 cases on aircraft the registry lists as Air Tractor AT-301. 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
| 1967 | 1 |
|---|---|
| 1976 | 2 |
| 1978 | 4 |
| 1979 | 7 |
| 1980 | 11 |
| 1981 | 11 |
| 1982 | 14 |
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 8 |
| 1986 | 9 |
| 1987 | 15 |
| 1988 | 10 |
| 1989 | 13 |
| 1990 | 5 |
| 1991 | 4 |
| 1992 | 10 |
| 1993 | 6 |
| 1994 | 10 |
| 1995 | 14 |
| 1996 | 6 |
| 1997 | 7 |
| 1998 | 10 |
| 1999 | 7 |
| 2000 | 7 |
| 2001 | 5 |
| 2002 | 7 |
| 2003 | 7 |
| 2004 | 6 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 7 |
| 2008 | 8 |
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 7 |
| 2012 | 3 |
| 2013 | 6 |
| 2014 | 4 |
| 2016 | 2 |
| 2018 | 3 |
| 2022 | 3 |
| 2024 | 1 |
| 2025 | 2 |
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 year(c.\"eventDate\") = 1989
AND 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'))
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 year(c."eventDate") = 1989
AND 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'))
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 MKC90LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Ellinwood, KSThe partial failure of the engine for undetermined reasons which resulted in a forced landing. A factor related to the accident was the soft dirt.NTSB MIA90LA001Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Belle Glade, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. A factor related to the accident was: the terrain condition in the emergency landing area.NTSB LAX89DUG09Accident · No injuriesFinal reportAir Tractor AT-301A · Blythe, CAThe pilot's failure to verify the fuel supply prior to takeoff.NTSB LAX89DVA10Accident · No injuriesFinal reportAir Tractor AT-301 · Mendota, CAA loss of aircraft control by the pilot when he slowed the aircraft to begin a spray run. Contributing to the loss of control was the inoperative stall warning system.NTSB CHI89DEP10Accident · 1 fatalFinal reportAir Tractor AT-301 · Plainfield, WIFailure of the pilot-in-command to maintain control of the aircraft while conducting aerial application maneuvers in close proximity to the terrain.NTSB ATL89DKG04Accident · 1 fatalFinal reportAir Tractor AT-301 · Americus, GAThe pilot's failure to properly survey the area in which he would be conducting aerial application flights and his failure to see and avoid powerlines while performing aerial application.NTSB MKC89LA146Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Lonoke, ARPartial failure of the power-plant for undetermined reasons.NTSB FTW89DRG08Accident · No injuriesFinal reportAir Tractor AT-301 · Rio Hondo, TXImproper compensation for wind conditions by the pilot. Factors related to the accident were the adverse wind conditions.NTSB MIA89LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Arcola, MSThe circumferential on the number 2 cylinder which resulted in a loss of engine power.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 MKC89LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roseau, MNFuel starvation due to fuel ice.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.