NTSB investigations: AiResearch TPE331 series
15 cases on aircraft whose registry engine model is AiResearch TPE331 series, where the first occurrence was “In flight collision with object”. 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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 ('01514', '01517')
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\" = 220))
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 ('01514', '01517')
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" = 220))
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 ANC07FA103Accident · 1 fatalField investigationFinal reportShort Bros. SC-7 · McGrath, AKA collision with trees during takeoff-initial climb for an undetermined reason.NTSB CHI07LA207Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Wyoming, ILThe pilot's failure to maintain clearance with the power lines during the aerial application flight. Contributing to the accident were the power lines and the low altitude.NTSB CHI06LA244Accident · Minor injuriesLimited investigationFinal reportFairchild SA227-AC · Grain Valley, MOthe pilot not maintaining clearance from the fence. Contributing factors were the pilot's fatigue and the fence.NTSB DFW05CA133Accident · No injuriesData collectionFinal reportGrumman 164-B · Fontaine, ARThe pilot's failure to maintain clearance during a downwind takeoff with a full load of fertilizer. Factor contributing to the accident were the prevailing tailwind and the high density altitude.NTSB SEA05LA014Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Boise, IDThe pilot's failure to maintain the required glidepath, and his failure to maintain obstacle clearance after visual contact with the runway during the instrument approach.NTSB DCA05MA004Accident · 13 fatalClass 1 · MajorFinal reportBritish Aerospace Jetstream 32 · Kirksville, MOthe pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…NTSB ANC04FA063Accident · 1 fatalField investigationFinal reportBeech C-45H · Kodiak, AKThe pilot's failure to follow proper IFR procedures by not adhering to the published missed approach procedures, which resulted in an in-flight collision with tree-covered terrain. Factors contributing to the accident were a low ceiling, fog, rain, and the…NTSB SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…NTSB CHI03LA278Accident · 1 fatalLimited investigationFinal reportAyres S2R-G6 · Breckenridge, MIThe pilot's failure to maintain clearance from the powerlines during the aerial application pass rendering the airplane uncontrollable. The powerlines were a factor.NTSB IAD02FA052Accident · 1 fatalField investigationFinal reportAyres S-2R · Swanton, MDThe pilot's failure to maintain visual separation from a set of known, yet unmarked power lines.NTSB LAX01LA268Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Winnemucca, NVthe pilot's failure to maintain clearance with the wires while he was maneuvering for an aerial application run.NTSB CHI01FA032Accident · 1 fatalField investigationFinal reportSwearingen SA226TC · Fort Wayne, INThe indicated failure of the right hand AC bus during takeoff with low ceiling. The factors were the low ceiling, night, and the execssive workload the pilot experienced on takeoff with an electrical failure without a second in command.NTSB LAX95LA269Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Tulare, CAfailure of the pilot to see and avoid power lines along his route of flight.NTSB CHI86FA172Accident · 3 fatalField investigationFinal reportCessna 441 · Norton Shores, MIN6857E was transporting executives from holland, MI, to muskegon. The pilot was executing an asr approach to runway 06. The mda is 537 ft AGL. Co-pilot called out 1200 feet then below 1000 feet, pilot continued approach. Aircraft struck trees two miles from…NTSB FTW84LA228Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bay City, TXWhile spraying a field with propanel & modown grass killers, the plt was crossing below a high tension power line. The vertical stabilizer contacted the lowest wire which tore loose the vertical stabilizer. The acft pitched nose up, then it dove down, crashed…