NTSB investigations: Air Tractor AT-300
8 cases on aircraft the registry lists as Air Tractor AT-300. 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
| 1975 | 1 |
|---|---|
| 1980 | 3 |
| 1981 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1992 | 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 ('0390101'))
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 ('0390101'))
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 FTW92DPG14Accident · No injuriesFinal reportAir Tractor AT-300 · Wilmont, ARPower loss due to a failed cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB LAX89DUQ04Accident · No injuriesFinal reportAir Tractor AT-300 · New Cuyama, CAThe pilot's mismanagement of the fuel supply which led to an engine power loss due to fuel exhaustion and subsequent collision with the ground by allowing the aircraft to stall.NTSB LAX84LA208Accident · No injuriesLimited investigationFinal reportAir Tractor AT-300 · Delano, CAThe plt was making a tight, 180 degree, right turn from downwind to final when he felt a buffet. He then applied power and lowered the nose. He stated he remained in the turn to avoid power lines. The power lines were located along the left side of the rwy.…NTSB FTW81DPG33Accident · Serious injuriesClosedAir Tractor AT-300 · Foreman, ARNTSB LAX81DVA05Accident · No injuriesClosedAir Tractor AT-300 · Pixley, CANTSB LAX81FUM01Accident · 1 fatalClosedAir Tractor AT-300 · Imperial, CANTSB LAX80DUJ32Accident · No injuriesClosedAir Tractor AT-300 · Tacna, AZNTSB FTW75FRG84Accident · Serious injuriesClosedAir Tractor AT-301 · Los Fresnos, TX