NTSB investigations: Pratt & Whitney PT6A series, 2018
15 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series. 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
| 1964 | 1 |
|---|---|
| 1969 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 6 |
| 1993 | 2 |
| 1994 | 9 |
| 1995 | 10 |
| 1996 | 10 |
| 1997 | 23 |
| 1998 | 14 |
| 1999 | 16 |
| 2000 | 20 |
| 2001 | 24 |
| 2002 | 28 |
| 2003 | 34 |
| 2004 | 26 |
| 2005 | 25 |
| 2006 | 21 |
| 2007 | 32 |
| 2008 | 22 |
| 2009 | 19 |
| 2010 | 18 |
| 2011 | 23 |
| 2012 | 21 |
| 2013 | 20 |
| 2014 | 20 |
| 2015 | 15 |
| 2016 | 25 |
| 2017 | 19 |
| 2018 | 15 |
| 2019 | 17 |
| 2020 | 19 |
| 2021 | 9 |
| 2022 | 12 |
| 2023 | 10 |
| 2024 | 18 |
| 2025 | 11 |
| 2026 | 8 |
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\") = 2018
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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") = 2018
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034'))
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 GAA19CA078Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Americus, GAThe pilot's failure to see and avoid a power line during an agricultural application flight.NTSB WPR19IA030Incident · Minor injuriesClass 3 · IncidentFinal reportCessna 208 · Bakersfield, CAThe pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…NTSB CEN19FA003Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Placedo, TXThe pilot's failure to maintain clearance from the antenna tower, a known obstruction, during the agricultural application flight. Contributing to the accident was glare from the sun which hindered the pilot's ability to see and avoid the antenna tower.NTSB GAA19CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Crowley, LAThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with vegetation and a subsequent loss of directional control.NTSB GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.NTSB WPR18LA234Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 400 · Grand Forks, NDThe loss of engine power while maneuvering due to the failure of the power turbine blade assembly for reasons that could not be determined based on available evidence.NTSB GAA18CA476Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Louise, MSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent loss of directional control.NTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.NTSB CEN18LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT502 · Tappen, NDThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18FA201Accident · 1 fatalField investigationFinal reportAyres S2R · El Reno, OKThe pilot's failure to maintain clearance from tower guy wires while maneuvering during an aerial application flight.NTSB CEN18LA194Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Qulin, MOThe pilot’s improper weight-and-balance calculations and his decision to take off with the airplane at a high gross weight in high density altitude conditions, which resulted in an attempted takeoff that exceeded the airplane’s performance capability. Also…NTSB GAA18CA309Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Nicolaus, CAThe pilot’s failure to maintain adequate clearance from a power transmission wire.NTSB GAA18CA187Accident · No injuriesData collectionFinal reportBeech 99 · King Salmon, AKThe pilot’s failure to maintain an adequate approach path and runway centerline during the initial landing, which resulted in a hard landing to the left of the runway and damage to the landing gear and wing.NTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.NTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.