NTSB investigations: Pratt & Whitney PT6A series, MO
11 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
| 1994 | 1 |
|---|---|
| 1995 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 1 |
| 2011 | 1 |
| 2018 | 1 |
| 2020 | 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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
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 CEN20LA084Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · St Louis, MOThe pilot’s loss of directional control and the subsequent nose landing gear collapse of for undetermined reasons.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 CEN11LA296Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · New Madrid, MOThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.NTSB CEN09CA316Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Charleston, MOThe pilot's failure to abort the takeoff resulting in a runway overrun and impact with terrain.NTSB DEN08LA151Accident · No injuriesLimited investigationFinal reportBeech 1900D · St. Louis, MOThe ground crew's failure to ensure airplane clearance from the building while parking the airplane. Contributing to the accident was the flight crew's unprofessional behavior and the lack of marshaling procedures for the ground crew.NTSB DFW08CA219Accident · No injuriesData collectionFinal reportPiper PA46-500TP · St. Louis, MOThe pilot's failure to ensure that the landing gear was placed in the down position prior to landing.NTSB DFW08LA167Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Bethany, MOThe pilot's decision to take off with a known deficiency.NTSB CHI07LA063Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Cape Girardeau, MOThe company pilot's poor judgment before and during the flight, including turning the oxygen system ready switch to the OFF position after he conducted the preflight inspection and using an unapproved checklist, which did not provide guidance for a fractured…NTSB CHI01LA183Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Catron, MOthe failure of the pilot to maintain clearance from the electrical wires.NTSB CHI95LA278Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-400 · Hayti, MOthe pilot inadvertently stalled the airplane. A factor was the reduced power setting.NTSB CHI94LA147Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Sikeston, MOa fatigue failure of a compressor blade which resulted in a catostrophic engine failure.