Final NTSB investigations: Pratt & Whitney PT6A series, 1999
13 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 | 7 |
| 1995 | 10 |
| 1996 | 9 |
| 1997 | 22 |
| 1998 | 13 |
| 1999 | 13 |
| 2000 | 19 |
| 2001 | 24 |
| 2002 | 27 |
| 2003 | 32 |
| 2004 | 24 |
| 2005 | 24 |
| 2006 | 21 |
| 2007 | 28 |
| 2008 | 20 |
| 2009 | 19 |
| 2010 | 17 |
| 2011 | 23 |
| 2012 | 21 |
| 2013 | 20 |
| 2014 | 19 |
| 2015 | 14 |
| 2016 | 24 |
| 2017 | 19 |
| 2018 | 15 |
| 2019 | 16 |
| 2020 | 18 |
| 2021 | 9 |
| 2022 | 11 |
| 2023 | 9 |
| 2024 | 16 |
| 2025 | 5 |
| 2026 | 3 |
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\") = 1999
AND c.\"completionStatus\" = 'Completed'
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") = 1999
AND c."completionStatus" = 'Completed'
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 ATL00LA018Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Adjuntas, PRThe pilot continued flight into adverse weather conditions that included low ceiling and turbulence. Factors to the accident were trees.NTSB ANC00LA017Accident · No injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's inadequate preflight and his failure to remove snow and airframe ice from the airplane.NTSB NYC00FA006Accident · 2 fatalField investigationFinal reportRaytheon Corporate Jets BE-200 · Williamstown, MAThe pilot-in-command's failure comply with an air traffic control clearance which resulted in a collision with terrain. A factor in this accident was clouds.NTSB MIA99LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Anguilla, MSThe P3 air line disconnected at the P3 air filter housing , and a 'B' nut not being safetied by maintenance personnel, which resulted in a total loss of engine power.NTSB FTW99LA249Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Seminole, TXThe pilot's failure to maintain obstacle clearance.NTSB MIA99FA245Accident · 8 fatalField investigationFinal reportBeech B-90 · West Palm Beach, FLa total loss of engine power due to fuel exhaustion. Contributing factors in this accident were the pilot's operation of the airplane in an overweight condition, inadequate pre-flight and in-flight planning.NTSB LAX99TA274Accident · No injuriesFinal reportAir Tractor AT-802A · Elko, NVThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude margin while engaged in fire fighting operations.NTSB MIA99LA229Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Holly Bluff, MSThe pilot's failure to maintain visual separation between his airplane and a tree while maneuvering during aerial application and the subsequent collision with the tree and the terrain. A factor in the accident was the sunglare on the airplane's windscreen.NTSB FTW99LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Snyder, TXThe loss of engine power due to fuel starvation as result of a leak in the engine fuel control. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA149Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402A · Mead, COThe pilot's failure to follow proper approach to landing procedures as outlined in the Airplane Flight Manual. A factor was the 6-foot tall corn stalks.NTSB ANC99LA107Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Ketchikan, AKA failure of ground handling personnel to verify a release procedure/directive, and removal of the airplane's tiedown, and subsequent collision with a parked airplane.NTSB FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.NTSB ANC99LA066Accident · No injuriesLimited investigationFinal reportde Havilland DHC 2 MK III · Anchorage, AKThe certificated flight instructor's inadequate supervision of the duel student. Factors associated with the accident were the student's inadvertent stall, and a surging turboshaft engine.