NTSB investigations: Pratt & Whitney PT6A series
21 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series, where the first occurrence was “In flight collision with terrain/water”. 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
| 1991 | 1 |
|---|---|
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 4 |
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.engine_model_code IN ('52032', '52034')
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\" = 230))
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.engine_model_code IN ('52032', '52034')
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" = 230))
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 CHI08FA045Accident · 2 fatalField investigationFinal reportCessna 208B · Columbus, OHThe pilot's failure to maintain aircraft control and collision avoidance with terrain due to spatial disorientation. Contributing to the accident were the low cloud ceiling and night conditions.NTSB DEN08FA003Accident · 3 fatalField investigationFinal reportRaytheon C90A · Pagosa Springs, COThe pilot's failure to maintain clearance from mountainous terrain. Contributing to the accident was the pilot's inadequate preflight planning, improper in-flight planning and decision making, the dark night, and the controller's failure to issue a safety…NTSB CHI07LA213Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402A · Laurel, IAThe pilot failed to maintain clearance with the upsloping terrain for undetermined reasons.NTSB DFW07CA114Accident · Minor injuriesData collectionFinal reportAir Tractor AT-402A · Edmonson, TXThe pilot's failure to maintain clearance with the crops.NTSB ATL06CA113Accident · No injuriesData collectionFinal reportCessna 208 · Riceboro, GAThe pilot's failure to achieve the proper takeoff distance on a short water runway resulting in an in-flight collision with a berm and a marshy area on initial takeoff climb.NTSB DFW06LA163Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Colt, ARThe pilot's failure to maintain clearance with the ground during an aerial application flight.NTSB DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.NTSB CHI04LA278Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Gwinner, NDThe pilot's failure to maintain altitude during the circling maneuver. Contributing factors were the pilot's improper decision to execute the approach when weather conditions were below minimums and the low light (dark night) conditions.NTSB FTW04LA156Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Joiner, ARThe pilot's failure to maintain clearance and altitude from terrain while maneuvering during an aerial application.NTSB ANC03FA096Accident · 2 fatalField investigationFinal reportReims 406 · Barrow, AKAn in-flight collision with ocean waters while maneuvering for an undetermined reason.NTSB MIA03FA034Accident · 1 fatalField investigationFinal reportCessna 208B · Manteo, NCThe pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…NTSB FTW03FA059Accident · 3 fatalField investigationFinal reportBeech 1900C · Eagleton, ARIn-flight collision with terrain due to the pilot's failure to maintain clearance and altitude above rapidly rising terrain while on a VFR approach. Contributing factors were the obscuration of the terrain due to clouds.NTSB NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…NTSB ANC00LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-T3 · Kotzebue, AKThe pilot descended below the minimum descent altitude. Factors associated with this accident were the task overload of the pilot during the instrument approach, and not performing a level off.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 FTW99LA196Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Marvel, ARThe pilot's failure to attain the proper takeoff airspeed.NTSB FTW98LA205Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Forrest City, ARThe pilot's failure to maintain clearance with terrain. Factors were the sunglare and the pilot's restriction to visibility due to chemicals on the windshield.NTSB MIA97LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Tunica, MSThe pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.NTSB ATL95LA168Accident · No injuriesLimited investigationFinal reportAir Tractor 502B · Minter City, MSInadequate preflight planning/preparation by the pilot. Factors relating to the accident were: the excessive gross weight of the airplane and the high outside air temperature, which would have reduced the performance of the airplane.NTSB DEN93FA009Accident · 3 fatalField investigationFinal reportPiper PA-42 · Grand Junction, COImproper IFR procedure and resultant disorientation which resulted in a collision with terrain.NTSB FTW91DRG04Accident · Serious injuriesFinal reportAir Tractor AT-402 · Taft, TXThe pilot's failure to maintain proper terrain clearance.